ERPRef.com

23 COLUMNS | 5 INDICIES 812 | 43 | F41061 Supplier Price/Catalog File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F41061	CB	23	5	Supplier Price/Catalog File	Master Files	45: Advanced Pricing	AS400 Coexistence Tables

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.

23 COLUMNS | TOP 812 | 43 | F41061 Supplier Price/Catalog File

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

5 INDICIES | TOP 812 | 43 | F41061 Supplier Price/Catalog File

1: Bus. Unit Addr Num +A (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	ITM	Item Number - Short	Ascending
4	CATN	Catalog	Ascending
5	CRCD	Currency Code - From	Ascending
6	UOM	Unit of Measure as Input	Ascending
7	UORG	Units - Order/Transaction Quantity	Ascending
8	EXDJ	Date - Expired	Ascending

4: Short Item Bus. Unit +

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	CATN	Catalog	Ascending
3	AN8	Address Number	Ascending
4	CRCD	Currency Code - From	Ascending
5	UOM	Unit of Measure as Input	Ascending
6	EXDJ	Date - Expired	Ascending
7	UORG	Units - Order/Transaction Quantity	Ascending

5: Address Number Short Item +B

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	ITM	Item Number - Short	Ascending
3	CRCD	Currency Code - From	Ascending
4	UOM	Unit of Measure as Input	Ascending
5	CATN	Catalog	Ascending

6: Bus. Unit Address Num +B

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AN8	Address Number	Ascending
3	ITM	Item Number - Short	Ascending
4	CRCD	Currency Code - From	Ascending
5	UOM	Unit of Measure as Input	Ascending
6	CATN	Catalog	Ascending

7: AddressNumber Catalog Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CATN	Catalog	Ascending