ERPRef.com

152 COLUMNS | 7 INDICIES 920 | 00 | F0006 Business Unit Master

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F0006	MC	152	7	Business Unit Master	Master Files	09: General Accounting	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.

152 COLUMNS | TOP 920 | 00 | F0006 Business Unit Master

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

7 INDICIES | TOP 920 | 00 | F0006 Business Unit Master

1: Cost Center (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

2: Company

Element	Alias	Description	Sequence
1	CO	Company	Ascending

4: Type Company

Element	Alias	Description	Sequence
2	CO	Company	Ascending
1	STYL	Business Unit Type	Ascending

5: Type Model

Element	Alias	Description	Sequence
2	FMOD	Model Accounts and Consolidation Flag	Ascending
1	STYL	Business Unit Type	Ascending

6: Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Descending

7: Cntrct Inv Funding

Element	Alias	Description	Sequence
3	DOCO	Document (Order No Invoice etc.)	Ascending
2	PCTN	Parent Contract Number	Ascending
1	CLNU	Contract Level Number	Ascending

8: Description

Element	Alias	Description	Sequence
1	DL01	Description	Ascending