	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

23 COLUMNS | 2 INDEXES | 920 | 10 | F10470 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
10: Financial Reporting
1	920	F10470	CS	23	2	Consolidation Specifications (OW)	Extra Features Files	10: Financial Reporting	Business Data

TOP 920 | 10 | F10470 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	CSCNAM	Consolidation Name	String	UDC (00 TS)	3	Allow NULL?
2	CSSERK	Key Value Serial Number	Numeric	Generic Edit	15	Allow NULL?
3	CSCNBU	Consolidate Business Units	Character	Generic Edit	1	Allow NULL?
4	CSOSNM	Structure Name	String	Generic Edit	10	Allow NULL?
5	CSSEQL	Sequence Level	String	Generic Edit	2	Allow NULL?
6	CSSEQV	Sequence Value	String	Generic Edit	10	Allow NULL?
7	CSSMCUS	Business Unit Structure	Character	Generic Edit	1	Allow NULL?
8	CSSEFT	Snapshot Date - Effective	Date	Generic Edit	6
9	CSSVER	Snapshot Version	String	Generic Edit	10	Allow NULL?
10	CSOTPA	Account Type Structure	String	UDC (00 TS)	3	Allow NULL?
11	CSLDA	Account Level of Detail	Character	Generic Edit	1	Allow NULL?
12	CSSBLD	Subledger Detail	Character	UDC (00 DS)	1	Allow NULL?
13	CSABIN	Post Account Balances by Currency	Character	Generic Edit	1	Allow NULL?
14	CSRNDG	Rounding Factor	Character	UDC (00 RN)	1	Allow NULL?
15	CSFLT1	From Ledger Type 1	String	Generic Edit	2	Allow NULL?
16	CSFLT2	From Ledger Type 2	String	Generic Edit	2	Allow NULL?
17	CSFLT3	From Ledger Type 3	String	Generic Edit	2	Allow NULL?
18	CSUSER	User ID	String	Generic Edit	10	Allow NULL?
19	CSJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
20	CSPID	Program ID	String	Generic Edit	10	Allow NULL?
21	CSVERS	Version History	String	Generic Edit	10	Allow NULL?
22	CSUPMJ	Date - Updated	Date	Generic Edit	6
23	CSUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

Consolidation Name Serial No (Primary/Unique)

Element	Alias	Description	Sequence
1	CNAM	Consolidation Name	Ascending
2	SERK	Key Value Serial Number	Ascending

Consolidate BU Consol Name +

Element	Alias	Description	Sequence
1	CNBU	Consolidate Business Units	Ascending
2	CNAM	Consolidation Name	Ascending
3	OSNM	Structure Name	Ascending
4	SEQL	Sequence Level	Ascending
5	SEQV	Sequence Value	Ascending
6	SMCUS	Business Unit Structure	Ascending
7	SEFT	Snapshot Date - Effective	Ascending
8	SVER	Snapshot Version	Ascending
9	OTPA	Account Type Structure	Ascending
10	LDA	Account Level of Detail	Ascending