ERPRef.com

36 COLUMNS | 5 INDICIES 920 | 45 | F4079 Rebate Transaction Detail

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F4079	SV	36	5	Rebate Transaction Detail	Transaction Files	45: Advanced Pricing	Business Data

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

36 COLUMNS | TOP 920 | 45 | F4079 Rebate Transaction Detail

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

5 INDICIES | TOP 920 | 45 | F4079 Rebate Transaction Detail

1: Address No Short Item A+ (Primary/Unique)

Element	Alias	Description	Sequence
13	LNID	Line Number	Ascending
12	SFXO	Order Suffix	Ascending
11	KCOO	Order Company (Order Number)	Ascending
10	DCTO	Order Type	Ascending
9	DOCO	Document (Order No Invoice etc.)	Ascending
8	EXDJ	Date - Expired	Ascending
7	EFTJ	Date - Effective	Ascending
6	AST	Price Adjustment Name	Ascending
5	OGID	Order Group Key ID	Ascending
4	CGID	Customer Group Key ID	Ascending
3	IGID	Item Group Key ID	Ascending
2	ITM	Item Number - Short	Ascending
1	AN8	Address Number	Ascending

2: Address No Short Item B+

Element	Alias	Description	Sequence
8	EXDJ	Date - Expired	Ascending
7	AST	Price Adjustment Name	Ascending
6	EFTJ	Date - Effective	Ascending
5	OGID	Order Group Key ID	Ascending
4	CGID	Customer Group Key ID	Ascending
3	IGID	Item Group Key ID	Ascending
2	ITM	Item Number - Short	Ascending
1	AN8	Address Number	Ascending

3: Address No Short Item C+

Element	Alias	Description	Sequence
10	LNID	Line Number	Ascending
9	ORDSEQ	Order Sequence No.	Ascending
8	EXDJ	Date - Expired	Ascending
7	EFTJ	Date - Effective	Ascending
6	AST	Price Adjustment Name	Ascending
5	OGID	Order Group Key ID	Ascending
4	CGID	Customer Group Key ID	Ascending
3	IGID	Item Group Key ID	Ascending
2	ITM	Item Number - Short	Ascending
1	AN8	Address Number	Ascending

4: Address No Short Item D+

Element	Alias	Description	Sequence
10	ORDSEQ	Order Sequence No.	Ascending
9	EXDJ	Date - Expired	Ascending
8	EFTJ	Date - Effective	Ascending
7	AST	Price Adjustment Name	Ascending
6	OGID	Order Group Key ID	Ascending
5	CGID	Customer Group Key ID	Ascending
4	IGID	Item Group Key ID	Ascending
3	ITM	Item Number - Short	Ascending
2	AN8	Address Number	Ascending
1	VIDCHG	Volume Incentive Chg Flag	Descending

5: Order No Order Company E+

Element	Alias	Description	Sequence
5	LNID	Line Number	Ascending
4	SFXO	Order Suffix	Ascending
3	KCOO	Order Company (Order Number)	Ascending
2	DCTO	Order Type	Ascending
1	DOCO	Document (Order No Invoice etc.)	Ascending