	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

84 COLUMNS | 6 INDEXES | 920 | 44H | F44H73W1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H73W1	CG	84	6	Lot Start - P.O. / Committment Generation Work File	Work Files	44H: Homebuilder Management

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 CGJOBS, CGMCU, CGOBJ, CGSUB, CGOPTION, CGAN8, CGITM, CGSEQ, CGHBLOT, CGKCOO, CGDOCO, CGDCTO, CGSFXO, CGLNID, CGLSWERR, CGHBAREA, CGHBMCUS, CGHBPFLG1, CGCPHASE, CGHBPLAN, CGHBELEV, CGOKCO, CGOCTO, CGOORN, CGOGNO, CGLITM, CGUORG, CGPRRC, CGPROV, CGAEXP, CGFTN1, CGPTC, CGLNTY, CGUOM, CGVR01, CGVR02, CGDSC1, CGDSC2, CGASID, CGLTTR, CGNXTR, CGGLC, CGAID, CGANI, CGSBL, CGSBLT, CGDSPR, CGTX, CGEXR1, CGTXA1, CGCRCD, CGCRCF, CGCRRM, CGCRR, CGFRRC, CGFEA, CGFUC, CGFEC, CGURRF, CGPCRT, CGRTNR, CGGLPT, CGPURG, CGR001, CGIVI, CGDGL, CGOPDJ, CGTRDJ, CGSHAN, CGAVEL, CGDESC, CGRMK, CGPDP1, CGPDP2, CGPDP3, CGPDP4, CGPDP5, CGANBY, CGFUF1, CGFUF2, CGRCD, CGSTTS, CGTCID, CGUKID FROM F44H73W1

TOP 920 | 44H | F44H73W1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CGJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
2	CGMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	CGOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
4	CGSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
5	CGOPTION	Option Number	String	Generic Edit	8	0	Allow NULL?
6	CGAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
7	CGITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
8	CGSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
9	CGHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
10	CGKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
11	CGDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
12	CGDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
13	CGSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
14	CGLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
15	CGLSWERR	Lot Start Workfile Error Return Code	String	Generic Edit	10	0	Allow NULL?
16	CGHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
17	CGHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
18	CGHBPFLG1	Homebuilder - Lot Start Process Type	Character	UDC (44H7 LP)	1	0	Allow NULL?
19	CGCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
20	CGHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
21	CGHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
22	CGOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
23	CGOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
24	CGOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
25	CGOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
26	CGLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
27	CGUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
28	CGPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
29	CGPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
30	CGAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
31	CGFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
32	CGPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
33	CGLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
34	CGUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
35	CGVR01	Reference	String	Generic Edit	25	0	Allow NULL?
36	CGVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
37	CGDSC1	Description	String	Generic Edit	30	0	Allow NULL?
38	CGDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
39	CGASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
40	CGLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
41	CGNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
42	CGGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
43	CGAID	Account ID	String	Generic Edit	8	0	Allow NULL?
44	CGANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
45	CGSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
46	CGSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
47	CGDSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
48	CGTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
49	CGEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
50	CGTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
51	CGCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
52	CGCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
53	CGCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
54	CGCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
55	CGFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
56	CGFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
57	CGFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
58	CGFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
59	CGURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
60	CGPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
61	CGRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
62	CGGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
63	CGPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
64	CGR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
65	CGIVI	Inventory Interface Y/N - Distribution	Character	UDC (H40 IV)	1	0	Allow NULL?
66	CGDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
67	CGOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
68	CGTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
69	CGSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
70	CGAVEL	Autovoucher Eligible Flag	Character	Generic Edit	1	0	Allow NULL?
71	CGDESC	Description	String	Generic Edit	30	0	Allow NULL?
72	CGRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
73	CGPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
74	CGPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
75	CGPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
76	CGPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
77	CGPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
78	CGANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
79	CGFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
80	CGFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
81	CGRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
82	CGSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
83	CGTCID	Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
84	CGUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?

TOP 920 | 44H | F44H73W1 INDEXES

Number

Description

JOBS MCU OBJ SUB OPTION AN8 + (Primary/Unique)

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	MCU	Business Unit	Ascending
3	OBJ	Object Account	Ascending
4	SUB	Subsidiary	Ascending
5	OPTION	Option Number	Ascending
6	AN8	Address Number	Ascending
7	ITM	Item Number - Short	Ascending
8	SEQ	Sequence Number	Ascending

JOBS MCU HBPFLG1 OKCO OCTO +

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	MCU	Business Unit	Ascending
3	HBPFLG1	Homebuilder - Lot Start Process Type	Ascending
4	OKCO	Document Company (Original Order)	Ascending
5	OCTO	Original Order Type	Ascending
6	OORN	Original Order Number	Ascending
7	OGNO	Original Line Number	Ascending

JOBS MCU HBPFLG1 AN8 SUB OBJ +

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	MCU	Business Unit	Ascending
3	HBPFLG1	Homebuilder - Lot Start Process Type	Ascending
4	AN8	Address Number	Ascending
5	SUB	Subsidiary	Ascending
6	OBJ	Object Account	Ascending
7	OPTION	Option Number	Ascending
8	ITM	Item Number - Short	Ascending

JOBS HBMCUS HBALOT

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	HBMCUS	Community	Ascending
3	HBLOT	Lot Number	Ascending

JOBS MCU HBPFLG1 KCOO DOCO +

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	MCU	Business Unit	Ascending
3	HBPFLG1	Homebuilder - Lot Start Process Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending
6	DCTO	Order Type	Ascending
7	SFXO	Order Suffix	Ascending
8	LNID	Line Number	Ascending

JOBS MCU KCOO DOCO DCTO +

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	MCU	Business Unit	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	DCTO	Order Type	Ascending
6	SFXO	Order Suffix	Ascending
7	HBPFLG1	Homebuilder - Lot Start Process 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

84 COLUMNS | 6 INDEXES | 920 | 44H | F44H73W1 TABLE

TOP 920 | 44H | F44H73W1 COLUMNS

TOP 920 | 44H | F44H73W1 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

84 COLUMNS | 6 INDEXES | 920 | 44H | F44H73W1 TABLE

TOP920 | 44H | F44H73W1 COLUMNS

TOP920 | 44H | F44H73W1 INDEXES

TOP 920 | 44H | F44H73W1 COLUMNS

TOP 920 | 44H | F44H73W1 INDEXES