	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

21 COLUMNS | 6 INDEXES | 920 | 52G | F52G21 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
52G: Proj & Gov Contract Accounting
1	920	F52G21	LR	21	6	Contract Specific Labor Category Cross Reference	Files	52G: Proj & Gov Contract Accounting

TOP 920 | 52G | F52G21 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	LRDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
2	LRDCTO	Order Type	String	UDC (00 DT)	2	Allow NULL?
3	LRKCOO	Order Company (Order Number)	String	Generic Edit	5	Allow NULL?
4	LRMCU	Business Unit	String	Generic Edit	12	Allow NULL?
5	LRJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	Allow NULL?
6	LRAN8	Address Number	Numeric	Generic Edit	8	Allow NULL?
7	LREFTB	Date - Beginning Effective	Date	Generic Edit	6
8	LREFTE	Date - Ending Effective	Date	Generic Edit	6
9	LROBJ	Object Account	String	Generic Edit	6	Allow NULL?
10	LROBJT	Object Account Thru	String	Generic Edit	6	Allow NULL?
11	LRSUB	Subsidiary	String	Generic Edit	8	Allow NULL?
12	LRSUBT	Thru Subsidiary	String	Generic Edit	8	Allow NULL?
13	LRHMCU	Business Unit - Home	String	Generic Edit	12	Allow NULL?
14	LRJBST	Job Step	String	UDC (06 GS)	4	Allow NULL?
15	LRRP12	Category Code - Business Unit 12	String	UDC (00 12)	3	Allow NULL?
16	LRUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	Allow NULL?
17	LRPID	Program ID	String	Generic Edit	10	Allow NULL?
18	LRJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
19	LRUSER	User ID	String	Generic Edit	10	Allow NULL?
20	LRUPMJ	Date - Updated	Date	Generic Edit	6
21	LRUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	MCU	Business Unit	Ascending
5	JBCD	Job Type (Craft) Code	Ascending
6	UKID	Unique Key ID (Internal)	Ascending

Contract No Type Company

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending

Business Unit

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

UKID

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

Multiple

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	MCU	Business Unit	Ascending
5	AN8	Address Number	Ascending
6	JBST	Job Step	Ascending
7	HMCU	Business Unit - Home	Ascending
8	RP12	Category Code - Business Unit 12	Ascending

Validate

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	MCU	Business Unit	Ascending
5	EFTB	Date - Beginning Effective	Descending