	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	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail 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

179 COLUMNS | 12 INDEXES | 920 | 52 | F5201 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
52: Contract Billing
1	920	F5201	G4	179	12	Contract Master	Master Files	52: Contract Billing	Business Data

SQL: selectupdate insert create

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.

SELECT G4DOCO, G4DCTO, G4KCOO, G4ICU, G4ICUJ, G4DL01, G4DC, G4DL02, G4DL03, G4ODCM, G4OCNC, G4AN8O, G4MCIF, G4NTEF, G4RCTL, G4ANOB, G4ADCM, G4AN8K, G4USA3, G4USA4, G4USA1, G4USA2, G4USA5, G4DS, G4CT, G4MCUS, G4JMCU, G4CO, G4PCTN, G4PCTT, G4PCKO, G4RTNR, G4RGLC, G4RTN1, G4EXR1, G4TXA1, G4INVF, G4AIAB, G4CTOV, G4PTC, G4BLWP, G4PYWP, G4BROV, G4FSLV, G4CRCD, G4CRCF, G4CRRM, G4NTEX, G4RNTE, G4ERDB, G4LMEX, G4MCIA, G4CSDT, G4CDTE, G4USD1, G4USD2, G4USD3, G4USD4, G4AI01, G4AI02, G4AI03, G4AI04, G4AI05, G4AI11, G4AI12, G4AI13, G4AI14, G4AI15, G4CRR, G4CRRD, G4CTF2, G4CTF3, G4CTF4, G4CTF5, G4BCTK, G4PID, G4JOBN, G4USER, G4MUPM, G4UPMT, G4GCSE, G4CLNU, G4CLTT, G4CLKO, G4FCCM, G4BURTC, G4CCFLG, G4BURTAC, G4ACFLG, G4BURTI, G4ICFLG, G4BURTR, G4RCFLG, G4TOCC, G4TOCS, G4PRCO, G4OWOR, G4POPF, G4POPT, G4EPOP, G4POTA, G4AWCOST, G4AWFE, G4AWAFE, G4FUNDC, G4FUNF, G4FUNAF, G4RICO, G4RIFE, G4RIAWF, G4RETMX, G4POTAF, G4AWCOSTF, G4AWFEF, G4AWAFEF, G4FUNDCF, G4FUNFF, G4FUNAFF, G4RICOF, G4RIFEF, G4RIAWFF, G4RETMXF, G4BILLST, G4BILLMET, G4BILLFRE, G4BILLLIM, G4BILLGRP, G4BILLOVT, G4REVST, G4REVMET, G4REVLIM, G4CAB1, G4CAB2, G4CAB3, G4CAB4, G4CAB5, G4CAB6, G4CAB7, G4CAB8, G4CAB9, G4CAB10, G4CAB11, G4CAB12, G4CAB13, G4CAB14, G4CAB15, G4CLCA, G4SUBLAB, G4ALLEV, G4ALDES, G4ACRNCF, G4ACRNAF, G4GOVPR, G4LOER, G4THRS, G4VARP, G4SECOA, G4DABA, G4CASCO, G4TINACO, G4FDCL, G4QCOPR, G4KEYP, G4VTGR, G4AI06, G4AI07, G4AI08, G4AI09, G4AI10, G4AI16, G4AI17, G4AI18, G4AI19, G4AI20, G4USD5, G4USD6, G4USD7, G4USD8, G4USD9 FROM F5201

TOP 920 | 52 | F5201 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	G4DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	G4DCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	G4KCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	G4ICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
5	G4ICUJ	Batch Number - Revenue	Numeric	Generic Edit	8	0	Allow NULL?
6	G4DL01	Description	String	Generic Edit	30	0	Allow NULL?
7	G4DC	Description - Compressed	String	Generic Edit	40	0	Allow NULL?
8	G4DL02	Description 02	String	Generic Edit	30	0	Allow NULL?
9	G4DL03	Description 03	String	Generic Edit	30	0	Allow NULL?
10	G4ODCM	Owner Contract No.	String	Generic Edit	25	0	Allow NULL?
11	G4OCNC	Owner Contract No. Compressed	String	Generic Edit	20	0	Allow NULL?
12	G4AN8O	Address Number - Job A/R	Numeric	Generic Edit	8	0	Allow NULL?
13	G4MCIF	Minimum Contract Invoice Amount-Foreign	Numeric	Generic Edit	15	2	Allow NULL?
14	G4NTEF	Not to Exceed Amount-Foreign	Numeric	Generic Edit	15	2	Allow NULL?
15	G4RCTL	Retainage Control Flag	Character	UDC (48S RC)	1	0	Allow NULL?
16	G4ANOB	Address Number - Owner Billing	Numeric	Generic Edit	8	0	Allow NULL?
17	G4ADCM	Architect Contract Number	String	Generic Edit	25	0	Allow NULL?
18	G4AN8K	Address Number - Architect	Numeric	Generic Edit	8	0	Allow NULL?
19	G4USA3	Address Number 3 - User	Numeric	Generic Edit	8	0	Allow NULL?
20	G4USA4	Address Number - Remit To	Numeric	Generic Edit	8	0	Allow NULL?
21	G4USA1	Address Number 1 - User	Numeric	Generic Edit	8	0	Allow NULL?
22	G4USA2	Address Number 2 - User	Numeric	Generic Edit	8	0	Allow NULL?
23	G4USA5	Address Number - Send To	Numeric	Generic Edit	8	0	Allow NULL?
24	G4DS	Contract Status	String	UDC (52 CS)	2	0	Allow NULL?
25	G4CT	Contract Type	String	UDC (51 CT)	4	0	Allow NULL?
26	G4MCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
27	G4JMCU	Business Unit - Host	String	Generic Edit	12	0	Allow NULL?
28	G4CO	Company	String	Generic Edit	5	0	Allow NULL?
29	G4PCTN	Parent Contract Number	Numeric	Generic Edit	8	0	Allow NULL?
30	G4PCTT	Parent Contract Type	String	UDC (00 DT)	2	0	Allow NULL?
31	G4PCKO	Parent Contract Document Company	String	Generic Edit	5	0	Allow NULL?
32	G4RTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
33	G4RGLC	Retention G/L Offset	String	Generic Edit	4	0	Allow NULL?
34	G4RTN1	Retainage Rule - Stored Material	String	Generic Edit	3	0	Allow NULL?
35	G4EXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
36	G4TXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
37	G4INVF	Invoice Format Code	String	Generic Edit	10	0	Allow NULL?
38	G4AIAB	AIA Billing Form - Y/N	Character	UDC (H50 AI)	1	0	Allow NULL?
39	G4CTOV	Contract Override Rule	Character	UDC (H50 CV)	1	0	Allow NULL?
40	G4PTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
41	G4BLWP	Bill When Paid	Character	UDC (52 BP)	1	0	Allow NULL?
42	G4PYWP	Pay When Paid	Character	Generic Edit	1	0	Allow NULL?
43	G4BROV	Burden Override Rule	Character	UDC (H50 BR)	1	0	Allow NULL?
44	G4FSLV	Fee Summarization Level	Character	UDC (H50 FS)	1	0	Allow NULL?
45	G4CRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
46	G4CRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
47	G4CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
48	G4NTEX	Not to Exceed Amount	Numeric	Generic Edit	15	2	Allow NULL?
49	G4RNTE	Not to Exceed Amount - Restated	Numeric	Generic Edit	15	2	Allow NULL?
50	G4ERDB	Date - Exchange Rate Date Basis	Character	Generic Edit	1	0	Allow NULL?
51	G4LMEX	Limit Exceeded Flag	Character	Generic Edit	1	0	Allow NULL?
52	G4MCIA	Minimum Contract Invoice Amount	Numeric	Generic Edit	15	2	Allow NULL?
53	G4CSDT	Contract Start Date	Date	Generic Edit	6	0
54	G4CDTE	Contract Completion Date	Date	Generic Edit	6	0
55	G4USD1	User Date 1	Date	Generic Edit	6	0
56	G4USD2	User Date 2	Date	Generic Edit	6	0
57	G4USD3	User Date 3	Date	Generic Edit	6	0
58	G4USD4	User Date 4	Date	Generic Edit	6	0
59	G4AI01	Contract Category Code 1	String	UDC (52 01)	3	0	Allow NULL?
60	G4AI02	Contract Category Code 2	String	UDC (52 02)	3	0	Allow NULL?
61	G4AI03	Contract Category Code 3	String	UDC (52 03)	3	0	Allow NULL?
62	G4AI04	Contract Category Code 4	String	UDC (52 04)	3	0	Allow NULL?
63	G4AI05	Contract Category Code 5	String	UDC (52 05)	3	0	Allow NULL?
64	G4AI11	Contract Category Code 11	String	UDC (52 11)	10	0	Allow NULL?
65	G4AI12	Contract Category Code 12	String	UDC (52 12)	10	0	Allow NULL?
66	G4AI13	Contract Category Code 13	String	UDC (52 13)	10	0	Allow NULL?
67	G4AI14	Contract Category Code 14	String	UDC (52 14)	10	0	Allow NULL?
68	G4AI15	Contract Category Code 15	String	UDC (52 15)	10	0	Allow NULL?
69	G4CRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
70	G4CRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
71	G4CTF2	Control Flag 2	Character	Generic Edit	1	0	Allow NULL?
72	G4CTF3	Progress Cross Reference Flag	Character	UDC (52 PX)	1	0	Allow NULL?
73	G4CTF4	Control Flag 4	Character	Generic Edit	1	0	Allow NULL?
74	G4CTF5	Not To Exceed Rule	Character	UDC (52 NT)	1	0	Allow NULL?
75	G4BCTK	Batch Control Key	String	Generic Edit	10	0	Allow NULL?
76	G4PID	Program ID	String	Generic Edit	10	0	Allow NULL?
77	G4JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
78	G4USER	User ID	String	Generic Edit	10	0	Allow NULL?
79	G4MUPM	Date - Updated	Date	Generic Edit	6	0
80	G4UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
81	G4GCSE	Advanced Contract Sequence No.	Numeric	Generic Edit	6	0	Allow NULL?
82	G4CLNU	Contract Level Number	Numeric	Generic Edit	8	0	Allow NULL?
83	G4CLTT	Contract Level Type	String	UDC (00 DT)	2	0	Allow NULL?
84	G4CLKO	Contract Level Company	String	Generic Edit	5	0	Allow NULL?
85	G4FCCM	Facilities Capital Cost Of Money	Character	Generic Edit	1	0	Allow NULL?
86	G4BURTC	Burden Rate Type-Cost	String	UDC (48S RT)	5	0	Allow NULL?
87	G4CCFLG	Cost Ceiling Flag	Character	Generic Edit	1	0	Allow NULL?
88	G4BURTAC	Burden Rate Type-Alternate Cost	String	UDC (48S RT)	5	0	Allow NULL?
89	G4ACFLG	Alternate Cost Ceiling Flag	Character	Generic Edit	1	0	Allow NULL?
90	G4BURTI	Burden Rate Type-Invoice	String	UDC (48S RT)	5	0	Allow NULL?
91	G4ICFLG	Invoice Ceiling Flag	Character	Generic Edit	1	0	Allow NULL?
92	G4BURTR	Burden Rate Type-Revenue	String	UDC (48S RT)	5	0	Allow NULL?
93	G4RCFLG	Revenue Ceiling Flag	Character	Generic Edit	1	0	Allow NULL?
94	G4TOCC	Type of Contract (Client Type)	String	UDC (52G CT)	4	0	Allow NULL?
95	G4TOCS	Type of Contract (Client/Sub)	String	UDC (52G CS)	4	0	Allow NULL?
96	G4PRCO	Prime Contract Number	String	Generic Edit	30	0	Allow NULL?
97	G4OWOR	Owning Organization	String	Generic Edit	12	0	Allow NULL?
98	G4POPF	Date - Period of Performance From	Date	Generic Edit	6	0
99	G4POPT	Date - Period of Performance To	Date	Generic Edit	6	0
100	G4EPOP	Enforce Period of Performance	Character	Generic Edit	1	0	Allow NULL?
101	G4POTA	Amount - Potential	Numeric	Generic Edit	15	2	Allow NULL?
102	G4AWCOST	Amount - Awarded Cost	Numeric	Generic Edit	15	2	Allow NULL?
103	G4AWFE	Amount - Awarded Fee	Numeric	Generic Edit	15	2	Allow NULL?
104	G4AWAFE	Amount - Awarded Award Fee	Numeric	Generic Edit	15	2	Allow NULL?
105	G4FUNDC	Amount - Funded Cost	Numeric	Generic Edit	15	2	Allow NULL?
106	G4FUNF	Amount - Funded Fee	Numeric	Generic Edit	15	2	Allow NULL?
107	G4FUNAF	Amount - Funded Award Fee	Numeric	Generic Edit	15	2	Allow NULL?
108	G4RICO	Amount - Risk Cost	Numeric	Generic Edit	15	2	Allow NULL?
109	G4RIFE	Amount - Risk Fee	Numeric	Generic Edit	15	2	Allow NULL?
110	G4RIAWF	Amount - Risk Award Fee	Numeric	Generic Edit	15	2	Allow NULL?
111	G4RETMX	Amount - Retainage Maximum	Numeric	Generic Edit	15	2	Allow NULL?
112	G4POTAF	Amount - Potential Foreign	Numeric	Generic Edit	15	2	Allow NULL?
113	G4AWCOSTF	Amount - Awarded Cost Foreign	Numeric	Generic Edit	15	2	Allow NULL?
114	G4AWFEF	Amount - Awarded Fee Foreign	Numeric	Generic Edit	15	2	Allow NULL?
115	G4AWAFEF	Amount - Awarded Award Fee Foreign	Numeric	Generic Edit	15	2	Allow NULL?
116	G4FUNDCF	Amount - Funded Cost Foreign	Numeric	Generic Edit	15	2	Allow NULL?
117	G4FUNFF	Amount - Funded Fee Foreign	Numeric	Generic Edit	15	2	Allow NULL?
118	G4FUNAFF	Amount - Funded Award Fee Foreign	Numeric	Generic Edit	15	2	Allow NULL?
119	G4RICOF	Amount - Risk Cost Foreign	Numeric	Generic Edit	15	2	Allow NULL?
120	G4RIFEF	Amount - Risk Fee Foreign	Numeric	Generic Edit	15	2	Allow NULL?
121	G4RIAWFF	Amount - Risk Award Fee Foreign	Numeric	Generic Edit	15	2	Allow NULL?
122	G4RETMXF	Amount - Retainage Maximum Foreign	Numeric	Generic Edit	15	2	Allow NULL?
123	G4BILLST	Billing Status	Character	UDC (52G BS)	1	0	Allow NULL?
124	G4BILLMET	Billing Method	Character	UDC (52G BM)	1	0	Allow NULL?
125	G4BILLFRE	Billing Frequency Code	String	UDC (52G BF)	3	0	Allow NULL?
126	G4BILLLIM	Billing Limit	Character	UDC (52G LM)	1	0	Allow NULL?
127	G4BILLGRP	Billing Group Code	String	UDC (52G BG)	3	0	Allow NULL?
128	G4BILLOVT	Bill Overtime	Character	Generic Edit	1	0	Allow NULL?
129	G4REVST	Revenue Status	Character	UDC (52G RS)	1	0	Allow NULL?
130	G4REVMET	Revenue Method	Character	UDC (52G RM)	1	0	Allow NULL?
131	G4REVLIM	Revenue Limit	Character	UDC (52G LM)	1	0	Allow NULL?
132	G4CAB1	Purchasing Contracting Officer	Numeric	Generic Edit	8	0	Allow NULL?
133	G4CAB2	Accounting Contracting Officer	Numeric	Generic Edit	8	0	Allow NULL?
134	G4CAB3	Contract Technical Manager	Numeric	Generic Edit	8	0	Allow NULL?
135	G4CAB4	Admin Office	Numeric	Generic Edit	8	0	Allow NULL?
136	G4CAB5	Assignment Office	Numeric	Generic Edit	8	0	Allow NULL?
137	G4CAB6	Project Manager 1	Numeric	Generic Edit	8	0	Allow NULL?
138	G4CAB7	Project Manager 2	Numeric	Generic Edit	8	0	Allow NULL?
139	G4CAB8	Project Manager 3	Numeric	Generic Edit	8	0	Allow NULL?
140	G4CAB9	Biller	Numeric	Generic Edit	8	0	Allow NULL?
141	G4CAB10	Contract Admin	Numeric	Generic Edit	8	0	Allow NULL?
142	G4CAB11	Invoice Contact	Numeric	Generic Edit	8	0	Allow NULL?
143	G4CAB12	Contract User Defined Address 12	Numeric	Generic Edit	8	0	Allow NULL?
144	G4CAB13	Contract User Defined Address 13	Numeric	Generic Edit	8	0	Allow NULL?
145	G4CAB14	Contract User Defined Address 14	Numeric	Generic Edit	8	0	Allow NULL?
146	G4CAB15	Contract User Defined Address 15	Numeric	Generic Edit	8	0	Allow NULL?
147	G4CLCA	Contract Labor Categories	Character	Generic Edit	1	0	Allow NULL?
148	G4SUBLAB	Subcontract As Labor	Character	Generic Edit	1	0	Allow NULL?
149	G4ALLEV	Allocation Level Flag	Character	UDC (52G AL)	1	0	Allow NULL?
150	G4ALDES	Allocation Destination Job	String	Generic Edit	12	0	Allow NULL?
151	G4ACRNCF	ACRN Method-Cost/Fee	Character	UDC (52G AM)	1	0	Allow NULL?
152	G4ACRNAF	ACRN Method-Award Fee	Character	UDC (52G AM)	1	0	Allow NULL?
153	G4GOVPR	Government Priority Rating	String	Generic Edit	10	0	Allow NULL?
154	G4LOER	Level of Effort Required	Character	Generic Edit	1	0	Allow NULL?
155	G4THRS	LOE Target Hours	Numeric	Generic Edit	9	2	Allow NULL?
156	G4VARP	Variance Percent	Numeric	Generic Edit	7	2	Allow NULL?
157	G4SECOA	Service Contract Act	Character	Generic Edit	1	0	Allow NULL?
158	G4DABA	Davis Bacon	Character	Generic Edit	1	0	Allow NULL?
159	G4CASCO	CAS Covered	Character	Generic Edit	1	0	Allow NULL?
160	G4TINACO	TINA Covered	Character	Generic Edit	1	0	Allow NULL?
161	G4FDCL	Flow Down Clauses Apply	Character	Generic Edit	1	0	Allow NULL?
162	G4QCOPR	Quick Close-out Provision	Character	Generic Edit	1	0	Allow NULL?
163	G4KEYP	Key Personnel	Character	Generic Edit	1	0	Allow NULL?
164	G4VTGR	Vendor Type Goals Required	Character	Generic Edit	1	0	Allow NULL?
165	G4AI06	Contract Category Code 6	String	UDC (52 06)	3	0	Allow NULL?
166	G4AI07	Contract Category Code 7	String	UDC (52 07)	3	0	Allow NULL?
167	G4AI08	Contract Category Code 8	String	UDC (52 08)	3	0	Allow NULL?
168	G4AI09	Contract Category Code 9	String	UDC (52 09)	3	0	Allow NULL?
169	G4AI10	Contract Category Code 10	String	UDC (52 10)	3	0	Allow NULL?
170	G4AI16	Contract Category Code 16	String	UDC (52G 16)	10	0	Allow NULL?
171	G4AI17	Contract Category Code 17	String	UDC (52G 17)	10	0	Allow NULL?
172	G4AI18	Contract Category Code 18	String	UDC (52G 18)	10	0	Allow NULL?
173	G4AI19	Contract Category Code 19	String	UDC (52G 19)	10	0	Allow NULL?
174	G4AI20	Contract Category Code 20	String	UDC (52G 20)	10	0	Allow NULL?
175	G4USD5	User Date 5	Date	Generic Edit	6	0
176	G4USD6	User Date 6	Date	Generic Edit	6	0
177	G4USD7	User Date 7	Date	Generic Edit	6	0
178	G4USD8	User Date 8	Date	Generic Edit	6	0
179	G4USD9	User Date 9	Date	Generic Edit	6	0

TOP 920 | 52 | F5201 INDEXES

Number

Description

ContractNumber Type Company (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

AddressNumber OrderNumber +

Element	Alias	Description	Sequence
1	AN8O	Address Number - Job A/R	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending

CostCenter OrderNumber +

Element	Alias	Description	Sequence
1	MCUS	Business Unit - Subsequent	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending

DescCompressed OrderNumber +

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

OwnerContract Order Number +

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

ContractType OrderNumber +

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

ContractStatus OrderNumber +

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

ParentContNumber ParentContTyp

Element	Alias	Description	Sequence
1	PCTN	Parent Contract Number	Ascending
2	PCTT	Parent Contract Type	Ascending

ContractNumber Type

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

ContractLevel Type

Element	Alias	Description	Sequence
1	CLNU	Contract Level Number	Ascending
2	CLTT	Contract Level Type	Ascending

Contract Type Status Cnt Lvl +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	DS	Contract Status	Ascending
4	CLNU	Contract Level Number	Ascending
5	CLTT	Contract Level Type	Ascending

Description

Element	Alias	Description	Sequence
1	DL01	Description	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

179 COLUMNS | 12 INDEXES | 920 | 52 | F5201 TABLE

TOP 920 | 52 | F5201 COLUMNS

TOP 920 | 52 | F5201 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

179 COLUMNS | 12 INDEXES | 920 | 52 | F5201 TABLE

TOP920 | 52 | F5201 COLUMNS

TOP920 | 52 | F5201 INDEXES

TOP 920 | 52 | F5201 COLUMNS

TOP 920 | 52 | F5201 INDEXES