ERPRef.com

209 COLUMNS | 6 INDICIES 812 | 03 | F03012 Customer Master by Line of Business

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F03012	AI	209	6	Customer Master by Line of Business	Master Files	03: Accounts Receivable	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.

209 COLUMNS | TOP 812 | 03 | F03012 Customer Master by Line of Business

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

6 INDICIES | TOP 812 | 03 | F03012 Customer Master by Line of Business

1: ADDRESS_COMPANY (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CO	Company	Ascending

2: POLICY AN8 CO (Unique)

Element	Alias	Description	Sequence
1	PLY	Policy Number (Internal)	Ascending
2	AN8	Address Number	Ascending
3	CO	Company	Ascending

3: ADDRESS_NO

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

4: COMPANY ADDRESS

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	AN8	Address Number	Ascending

5: INDUSTRY ADDRESS COMPANY

Element	Alias	Description	Sequence
1	CIG	Industry Group	Ascending
2	AN8	Address Number	Ascending
3	CO	Company	Ascending

6: TERRITORYID ADDRESS COMPANY

Element	Alias	Description	Sequence
1	TERRID	Territory Id	Ascending
2	AN8	Address Number	Ascending
3	CO	Company	Ascending