	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

85 COLUMNS | 7 INDEXES | 812 | 52 | F5202 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
52: Contract Billing
1	812	F5202	G6	85	7	Contract Billing Line Detail	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 G6DOCO, G6DCTO, G6KCOO, G6COCH, G6LNID, G6OPIM, G6DL01, G6SD1, G6SD3, G6CHD, G6TRMO, G6CHST, G6RTNR, G6RTN1, G6RTNC, G6MCUS, G6MCU, G6OBJ, G6SUB, G6SBL, G6SBLT, G6CO, G6GLC, G6PRTP, G6SCOF, G6FSOF, G6RSOF, G6U, G6UM, G6UP, G6FUP, G6RUP, G6EXR1, G6TXA1, G6STAM, G6ATXN, G6ATXA, G6NTEX, G6FNTE, G6RNTE, G6NTEC, G6FNTO, G6RNTO, G6NTEU, G6RRBC, G6RRBA, G6FRBA, G6RRRA, G6EXMP, G6ALSQ, G6BLSP, G6BLWP, G6PYWP, G6MCBL, G6MKRP, G6FBAS, G6RFBS, G6RACD, G6ROLU, G6R001, G6ACCO, G6AD01, G6AD02, G6AD03, G6AD04, G6AD05, G6CTF1, G6CTF2, G6CTF3, G6CTF4, G6CTF5, G6RMK, G6TAG, G6CRR, G6CRCD, G6CRCF, G6CRRD, G6CRRM, G6PID, G6JOBN, G6USER, G6MUPM, G6UPMT, G6VVTY, G6VVTC FROM F5202

TOP 812 | 52 | F5202 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	G6DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	G6DCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	G6KCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	G6COCH	Contract Change Number	String	Generic Edit	3	0	Allow NULL?
5	G6LNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
6	G6OPIM	Owner Pay Item	String	Generic Edit	15	0	Allow NULL?
7	G6DL01	Description	String	Generic Edit	30	0	Allow NULL?
8	G6SD1	Date - Planned Start	Date	Generic Edit	6	0
9	G6SD3	Date - Planned Complete	Date	Generic Edit	6	0
10	G6CHD	Change Date	Date	Generic Edit	6	0
11	G6TRMO	Terms Only	Character	UDC (H00 TR)	1	0	Allow NULL?
12	G6CHST	Change Status	String	UDC (52 CH)	2	0	Allow NULL?
13	G6RTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
14	G6RTN1	Retainage Rule - Stored Material	String	Generic Edit	3	0	Allow NULL?
15	G6RTNC	Retainage Rule - Change Order	String	Generic Edit	3	0	Allow NULL?
16	G6MCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
17	G6MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
18	G6OBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
19	G6SUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
20	G6SBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
21	G6SBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
22	G6CO	Company	String	Generic Edit	5	0	Allow NULL?
23	G6GLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
24	G6PRTP	Pricing Type - Contracts	Character	UDC (52 PT)	1	0	Allow NULL?
25	G6SCOF	Schedule of Values	Numeric	Generic Edit	15	2	Allow NULL?
26	G6FSOF	Schedule of Values - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
27	G6RSOF	Schedule of Values - Restated	Numeric	Generic Edit	15	2	Allow NULL?
28	G6U	Units	Numeric	Generic Edit	15	2	Allow NULL?
29	G6UM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
30	G6UP	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
31	G6FUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
32	G6RUP	Amount - Restated Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
33	G6EXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
34	G6TXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
35	G6STAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
36	G6ATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
37	G6ATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
38	G6NTEX	Not to Exceed Amount	Numeric	Generic Edit	15	2	Allow NULL?
39	G6FNTE	Not to Exceed Amount - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
40	G6RNTE	Not to Exceed Amount - Restated	Numeric	Generic Edit	15	2	Allow NULL?
41	G6NTEC	Not to Exceed Amount - Change Order	Numeric	Generic Edit	15	2	Allow NULL?
42	G6FNTO	Not to Exceed - Chg Order Amt - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
43	G6RNTO	Not to Exceed - Chg Order Amt - Restated	Numeric	Generic Edit	15	2	Allow NULL?
44	G6NTEU	Not to Exceed Units	Numeric	Generic Edit	15	2	Allow NULL?
45	G6RRBC	Recurring Billing Code	String	UDC (52 RB)	3	0	Allow NULL?
46	G6RRBA	Recurring Billing Amount	Numeric	Generic Edit	15	2	Allow NULL?
47	G6FRBA	Recurring Billing Amount - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
48	G6RRRA	Recurring Billing Amount - Restated	Numeric	Generic Edit	15	2	Allow NULL?
49	G6EXMP	Exempt from Not To Exceed Rule	Character	UDC (52 NT)	1	0	Allow NULL?
50	G6ALSQ	Alternate Sequence Code	String	Generic Edit	10	0	Allow NULL?
51	G6BLSP	Bill Suspend	Character	UDC (52 BS)	1	0	Allow NULL?
52	G6BLWP	Bill When Paid	Character	UDC (52 BP)	1	0	Allow NULL?
53	G6PYWP	Pay When Paid	Character	Generic Edit	1	0	Allow NULL?
54	G6MCBL	Current Billing Method	Character	UDC (H50 MC)	1	0	Allow NULL?
55	G6MKRP	% Fee	Numeric	Generic Edit	9	4	Allow NULL?
56	G6FBAS	Invoice Fee Basis	Character	UDC (H50 FB)	1	0	Allow NULL?
57	G6RFBS	Revenue Fee Basis	Character	UDC (H50 RF)	1	0	Allow NULL?
58	G6RACD	Rate Code	String	Generic Edit	3	0	Allow NULL?
59	G6ROLU	Roll Units	Character	UDC (52 RU)	1	0	Allow NULL?
60	G6R001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
61	G6ACCO	Account Override Flag	Character	UDC (52 AC)	1	0	Allow NULL?
62	G6AD01	Change Order Category Code 1	String	UDC (52 A1)	3	0	Allow NULL?
63	G6AD02	Change Order Category Code 2	String	UDC (52 A2)	3	0	Allow NULL?
64	G6AD03	Contract Category Code 3	String	UDC (52 A3)	3	0	Allow NULL?
65	G6AD04	Contract Category Code 4	String	UDC (52 A4)	3	0	Allow NULL?
66	G6AD05	Contract Category Code 5	String	UDC (52 A5)	3	0	Allow NULL?
67	G6CTF1	Control Flag 1	Character	UDC (52 EL)	1	0	Allow NULL?
68	G6CTF2	Control Flag 2	Character	Generic Edit	1	0	Allow NULL?
69	G6CTF3	Progress Cross Reference Flag	Character	UDC (52 PX)	1	0	Allow NULL?
70	G6CTF4	Control Flag 4	Character	Generic Edit	1	0	Allow NULL?
71	G6CTF5	Not To Exceed Rule	Character	UDC (52 NT)	1	0	Allow NULL?
72	G6RMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
73	G6TAG	Tag - Reference	String	Generic Edit	8	0	Allow NULL?
74	G6CRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
75	G6CRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
76	G6CRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
77	G6CRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
78	G6CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
79	G6PID	Program ID	String	Generic Edit	10	0	Allow NULL?
80	G6JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
81	G6USER	User ID	String	Generic Edit	10	0	Allow NULL?
82	G6MUPM	Date - Updated	Date	Generic Edit	6	0
83	G6UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
84	G6VVTY	Vertex Transaction Type	String	UDC (73 TY)	6	0	Allow NULL?
85	G6VVTC	Vertex Product Category	String	UDC (73 PC)	10	0	Allow NULL?

TOP 812 | 52 | F5202 INDEXES

Number

Description

Contract Number Type +A (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	COCH	Contract Change Number	Ascending
5	LNID	Line Number	Ascending

Contract Number Type +B

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	COCH	Contract Change Number	Ascending
5	OPIM	Owner Pay Item	Ascending
6	LNID	Line Number	Ascending

Contract Number Type +C

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	SUB	Subsidiary	Ascending
6	OBJ	Object Account	Ascending
7	SBL	Subledger - G/L	Ascending
8	SBLT	Subledger Type	Ascending

Contract Number Type +D

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	OPIM	Owner Pay Item	Ascending
5	COCH	Contract Change Number	Ascending
6	LNID	Line Number	Ascending

Contract Number Type +E

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	ALSQ	Alternate Sequence Code	Ascending
5	COCH	Contract Change Number	Ascending
6	OPIM	Owner Pay Item	Ascending
7	LNID	Line Number	Ascending

Cost Center

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

Contract Number Type +F

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	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

85 COLUMNS | 7 INDEXES | 812 | 52 | F5202 TABLE

TOP 812 | 52 | F5202 COLUMNS

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

85 COLUMNS | 7 INDEXES | 812 | 52 | F5202 TABLE

TOP812 | 52 | F5202 COLUMNS

TOP812 | 52 | F5202 INDEXES

TOP 812 | 52 | F5202 COLUMNS

TOP 812 | 52 | F5202 INDEXES