	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

83 COLUMNS | 3 INDEXES | 920 | 44H | F44H401 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H401	OC	83	3	Option Master	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 OCHBAREA, OCHBMCUS, OCCPHASE, OCHBPLAN, OCHBELEV, OCOPTION, OCDL01, OCDL02, OCDL03, OCDL04, OCDL05, OCDL06, OCOPTYP, OCOPKG, OCOPKGC, OCOCSTM, OCHBLOT, OCDPTP, OCCSPR, OCSPJ, OCEXDE, OCHGPP, OCPSPR, OCAMTO, OCSTRT, OCINACDTJ, OCPLNQ, OCOPM01, OCOPM02, OCOPM03, OCOPM04, OCOPM05, OCOPM06, OCOPM07, OCOPM08, OCOPM09, OCOPM10, OCOPM11, OCOPM12, OCOPM13, OCOPM14, OCOPM15, OCOPM16, OCOPM17, OCOPM18, OCOPM19, OCOPM20, OCOPSTAV, OCOPSTCO, OCOPLVL, OCHBST1, OCHBST2, OCHBST3, OCHBST4, OCHBST5, OCUC01, OCUC02, OCUC03, OCUSD1, OCUSD2, OCUSD3, OCUSD4, OCUSD5, OCUAMT01, OCUAMT02, OCUAMT03, OCUAMT04, OCUAMT05, OCF1A, OCF2A, OCF3A, OCF4A, OCF5A, OCCRTU, OCCRTJ, OCCRTT, OCWRKSTNID, OCHBOPID, OCUPMB, OCUPMJ, OCUPMT, OCJOBN, OCPID FROM F44H401

TOP 920 | 44H | F44H401 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	OCHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
2	OCHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
3	OCCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
4	OCHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
5	OCHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
6	OCOPTION	Option Number	String	Generic Edit	8	0	Allow NULL?
7	OCDL01	Description	String	Generic Edit	30	0	Allow NULL?
8	OCDL02	Description 02	String	Generic Edit	30	0	Allow NULL?
9	OCDL03	Description 03	String	Generic Edit	30	0	Allow NULL?
10	OCDL04	Description 04	String	Generic Edit	30	0	Allow NULL?
11	OCDL05	Description 05	String	Generic Edit	30	0	Allow NULL?
12	OCDL06	Description 06	String	Generic Edit	30	0	Allow NULL?
13	OCOPTYP	Option Type	String	UDC (44H4 OT)	3	0	Allow NULL?
14	OCOPKG	Option Package Flag	Character	Generic Edit	1	0	Allow NULL?
15	OCOPKGC	Option Package Component	Character	Generic Edit	1	0	Allow NULL?
16	OCOCSTM	Custom Option Flag	Character	Generic Edit	1	0	Allow NULL?
17	OCHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
18	OCDPTP	Option Deposit Percentage	Numeric	Generic Edit	15	7	Allow NULL?
19	OCCSPR	Current Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
20	OCSPJ	Sales Price Effective Date	Date	Generic Edit	6	0
21	OCEXDE	Expiration Date	Date	Generic Edit	6	0
22	OCHGPP	Gross Profit Percentage	Numeric	Generic Edit	5	4	Allow NULL?
23	OCPSPR	Amount - Previous Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
24	OCAMTO	Amount - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
25	OCSTRT	Date - Start (Julian)	Date	Generic Edit	6	0
26	OCINACDTJ	Date - Inactive	Date	Generic Edit	6	0
27	OCPLNQ	Plan Qualifier	String	Generic Edit	25	0	Allow NULL?
28	OCOPM01	Option Category 01	String	UDC (44H4 01)	3	0	Allow NULL?
29	OCOPM02	Option Category 02	String	UDC (44H4 02)	3	0	Allow NULL?
30	OCOPM03	Option Category 03	String	UDC (44H4 03)	3	0	Allow NULL?
31	OCOPM04	Option Category 04	String	UDC (44H4 04)	3	0	Allow NULL?
32	OCOPM05	Option Category 05	String	UDC (44H4 05)	3	0	Allow NULL?
33	OCOPM06	Option Category 06	String	UDC (44H4 06)	3	0	Allow NULL?
34	OCOPM07	Option Category 07	String	UDC (44H4 07)	3	0	Allow NULL?
35	OCOPM08	Option Category 08	String	UDC (44H4 08)	3	0	Allow NULL?
36	OCOPM09	Option Category 09	String	UDC (44H4 09)	3	0	Allow NULL?
37	OCOPM10	Option Category 10	String	UDC (44H4 10)	3	0	Allow NULL?
38	OCOPM11	Option Category 11	String	UDC (44H4 11)	10	0	Allow NULL?
39	OCOPM12	Option Category 12	String	UDC (44H4 12)	10	0	Allow NULL?
40	OCOPM13	Option Category 13	String	UDC (44H4 13)	10	0	Allow NULL?
41	OCOPM14	Option Category 14	String	UDC (44H4 14)	10	0	Allow NULL?
42	OCOPM15	Option Category 15	String	UDC (44H4 15)	10	0	Allow NULL?
43	OCOPM16	Option Category 16	String	UDC (44H4 16)	10	0	Allow NULL?
44	OCOPM17	Option Category 17	String	UDC (44H4 17)	10	0	Allow NULL?
45	OCOPM18	Option Category 18	String	UDC (44H4 18)	10	0	Allow NULL?
46	OCOPM19	Option Category 19	String	UDC (44H4 19)	10	0	Allow NULL?
47	OCOPM20	Option Category 20	String	UDC (44H4 20)	10	0	Allow NULL?
48	OCOPSTAV	Option Cut-Off (Not Before)	String	UDC (44H0 RL)	3	0	Allow NULL?
49	OCOPSTCO	Option Cut-Off (Not After)	String	UDC (44H0 RL)	3	0	Allow NULL?
50	OCOPLVL	Option Option Offerred Level	Numeric	Generic Edit	2	0	Allow NULL?
51	OCHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
52	OCHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
53	OCHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
54	OCHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
55	OCHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
56	OCUC01	User Reason Code 01	Character	Generic Edit	1	0	Allow NULL?
57	OCUC02	User Reason Code 02	Character	Generic Edit	1	0	Allow NULL?
58	OCUC03	User Reason Code 03	Character	Generic Edit	1	0	Allow NULL?
59	OCUSD1	User Date 1	Date	Generic Edit	6	0
60	OCUSD2	User Date 2	Date	Generic Edit	6	0
61	OCUSD3	User Date 3	Date	Generic Edit	6	0
62	OCUSD4	User Date 4	Date	Generic Edit	6	0
63	OCUSD5	User Date 5	Date	Generic Edit	6	0
64	OCUAMT01	User Defined Amount 01	Numeric	Generic Edit	15	2	Allow NULL?
65	OCUAMT02	User Defined Amount 02	Numeric	Generic Edit	15	2	Allow NULL?
66	OCUAMT03	User Defined Amount 03	Numeric	Generic Edit	15	2	Allow NULL?
67	OCUAMT04	User Defined Amount 04	Numeric	Generic Edit	15	2	Allow NULL?
68	OCUAMT05	User Defined Amount 05	Numeric	Generic Edit	15	2	Allow NULL?
69	OCF1A	Future 1 Amount	Numeric	Generic Edit	15	0	Allow NULL?
70	OCF2A	Future 2 Amount	Numeric	Generic Edit	15	0	Allow NULL?
71	OCF3A	Future 3 Amount	Numeric	Generic Edit	15	0	Allow NULL?
72	OCF4A	Future 4 Amount	Numeric	Generic Edit	15	0	Allow NULL?
73	OCF5A	Future 5 Amount	Numeric	Generic Edit	15	0	Allow NULL?
74	OCCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
75	OCCRTJ	Date - Created	Date	Generic Edit	6	0
76	OCCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
77	OCWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
78	OCHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
79	OCUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
80	OCUPMJ	Date - Updated	Date	Generic Edit	6	0
81	OCUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
82	OCJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
83	OCPID	Program ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 44H | F44H401 INDEXES

Number

Description

HBAREA HBMCUS CPHASE HBPLAN + (Primary/Unique)

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	HBMCUS	Community	Ascending
3	CPHASE	Phase	Ascending
4	HBPLAN	Plan Number	Ascending
5	HBELEV	Elevation	Ascending
6	OPTION	Option Number	Ascending

HBAREA CPHASE HBPLAN +

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	CPHASE	Phase	Ascending
3	HBPLAN	Plan Number	Ascending
4	HBELEV	Elevation	Ascending
5	OPTION	Option Number	Ascending

HBAREA OPTION

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	OPTION	Option 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

83 COLUMNS | 3 INDEXES | 920 | 44H | F44H401 TABLE

TOP 920 | 44H | F44H401 COLUMNS

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

83 COLUMNS | 3 INDEXES | 920 | 44H | F44H401 TABLE

TOP920 | 44H | F44H401 COLUMNS

TOP920 | 44H | F44H401 INDEXES

TOP 920 | 44H | F44H401 COLUMNS

TOP 920 | 44H | F44H401 INDEXES