	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

80 COLUMNS | 9 INDEXES | 812 | 52 | F5201 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
52: Contract Billing
1	812	F5201	G4	80	9	Contract Master File	Master Files	52: Contract Billing	No

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 FROM F5201

TOP 812 | 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?

TOP 812 | 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

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

80 COLUMNS | 9 INDEXES | 812 | 52 | F5201 TABLE

TOP 812 | 52 | F5201 COLUMNS

TOP 812 | 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

80 COLUMNS | 9 INDEXES | 812 | 52 | F5201 TABLE

TOP812 | 52 | F5201 COLUMNS

TOP812 | 52 | F5201 INDEXES

TOP 812 | 52 | F5201 COLUMNS

TOP 812 | 52 | F5201 INDEXES