920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F4450	JD	131	1	Lot Proceed Header (World)	Files	44H: Homebuilder Management

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	JDMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
2	JDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	JDALOT	Lot Proceed Lot Number	String	Generic Edit	4	0	Allow NULL?
4	JDSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
5	JDPL	Plan Number	String	Generic Edit	4	0	Allow NULL?
6	JDELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
7	JDSTDJ	Start Date (Julian)	Date	Generic Edit	6	0
8	JDLNT	Loan Type	String	Generic Edit	8	0	Allow NULL?
9	JDPMN	Permit Number	String	Generic Edit	12	0	Allow NULL?
10	JDCLRH	Color Hold	Character	Generic Edit	1	0	Allow NULL?
11	JDCLPK	Color Package	String	Generic Edit	10	0	Allow NULL?
12	JDSWG	Swing	Character	Generic Edit	1	0	Allow NULL?
13	JDBYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
14	JDASC	Sales Associate Number	Numeric	Generic Edit	8	0	Allow NULL?
15	JDSDJ	Sales Date (Julian)	Date	Generic Edit	6	0
16	JDEDJ	Cancel Date (Julian)	Date	Generic Edit	6	0
17	JDBSP	Amount - Base Price	Numeric	Generic Edit	15	2	Allow NULL?
18	JDLTP	Amount - Lot Premium	Numeric	Generic Edit	15	2	Allow NULL?
19	JDINCA	Amount - Incentive	Numeric	Generic Edit	15	2	Allow NULL?
20	JDPN1	Proceed Notes 1	String	Generic Edit	30	0	Allow NULL?
21	JDPN2	Proceed Notes 2	String	Generic Edit	30	0	Allow NULL?
22	JDPN3	Proceed Notes 3	String	Generic Edit	30	0	Allow NULL?
23	JDPN4	Proceed Notes 4	String	Generic Edit	30	0	Allow NULL?
24	JDPN5	Proceed Notes 5	String	Generic Edit	30	0	Allow NULL?
25	JDPN6	Proceed Notes 6	String	Generic Edit	30	0	Allow NULL?
26	JDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
27	JDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
28	JDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
29	JDUPMJ	Date - Updated	Date	Generic Edit	6	0
30	JDACCL	Accent Color	String	Generic Edit	15	0	Allow NULL?
31	JDBDC	Body Color	String	Generic Edit	15	0	Allow NULL?
32	JDFSC	Fascia Color	String	Generic Edit	15	0	Allow NULL?
33	JDHSTY	House Type	Character	UDC (44 HT)	1	0	Allow NULL?
34	JDUPG	Amount - Upgrade	Numeric	Generic Edit	15	2	Allow NULL?
35	JDTSP	Amount - Option Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
36	JDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
37	JDDL01	Description	String	Generic Edit	30	0	Allow NULL?
38	JDROF	Roof Tile	String	Generic Edit	15	0	Allow NULL?
39	JDSLP	Amount - Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
40	JDATFN	Date - Actual Finish (Julian)	Date	Generic Edit	6	0
41	JDCTGJ	Contingency Effective Date	Date	Generic Edit	6	0
42	JDCRD	Contingency Release Date	Date	Generic Edit	6	0
43	JDCXD	Contingency Expiration Date	Date	Generic Edit	6	0
44	JDLRD	Listing Receipt Date	Date	Generic Edit	6	0
45	JDPTDJ	Plot Approval Date	Date	Generic Edit	6	0
46	JDPHD	PQ Hold Date	Date	Generic Edit	6	0
47	JDCTYJ	Date at City	Date	Generic Edit	6	0
48	JDPRD	Permit Received Date	Date	Generic Edit	6	0
49	JDSWD	Sched walkthru date	Date	Generic Edit	6	0
50	JDSWT	Sched walkthru Time	String	Generic Edit	8	0	Allow NULL?
51	JDTAD	Title Appt. Date	Date	Generic Edit	6	0
52	JDPXD	Points expiration date	Date	Generic Edit	6	0
53	JDOD1	Other date 1	Date	Generic Edit	6	0
54	JDOD2	Other date 2	Date	Generic Edit	6	0
55	JDOD3	Other date 3	Date	Generic Edit	6	0
56	JDLDN	Lender Name	String	Generic Edit	30	0	Allow NULL?
57	JDCN1	Contingent Note 1	String	Generic Edit	30	0	Allow NULL?
58	JDCN2	Contingent Note 2	String	Generic Edit	30	0	Allow NULL?
59	JDON1	Other Note 1	String	Generic Edit	30	0	Allow NULL?
60	JDON2	Other Note 2	String	Generic Edit	30	0	Allow NULL?
61	JDON3	Other Note 3	String	Generic Edit	30	0	Allow NULL?
62	JDINR	Interest Rate	Numeric	Generic Edit	15	0	Allow NULL?
63	JDMGA	Mortage_Amount	Numeric	Generic Edit	15	2	Allow NULL?
64	JDDNPT	Down Payment	Numeric	Generic Edit	15	2	Allow NULL?
65	JDEMD	Earnest Money Deposit	Numeric	Generic Edit	15	2	Allow NULL?
66	JDOA1	Other Amount 1	Numeric	Generic Edit	15	0	Allow NULL?
67	JDOA2	Other Amount 2	Numeric	Generic Edit	15	0	Allow NULL?
68	JDCDJ	Close Date (Julian)	Date	Generic Edit	6	0
69	JDSCS	Sales Contract Status	Character	UDC (44 SC)	1	0	Allow NULL?
70	JDCPJ	Compliance Date (Julian)	Date	Generic Edit	6	0
71	JDMAD	Mortgage Approval Date (julian)	Date	Generic Edit	6	0
72	JDLADJ	Loan Application Date	Date	Generic Edit	6	0
73	JDCTGS	Contingent Sale Type	String	Generic Edit	8	0	Allow NULL?
74	JDCBK	Cobroke	Character	Generic Edit	1	0	Allow NULL?
75	JDUSD1	User Date 1	Date	Generic Edit	6	0
76	JDUSD2	User Date 2	Date	Generic Edit	6	0
77	JDUSD3	User Date 3	Date	Generic Edit	6	0
78	JDUC01	User Reason Code 01	Character	Generic Edit	1	0	Allow NULL?
79	JDUC02	User Reason Code 02	Character	Generic Edit	1	0	Allow NULL?
80	JDUC03	User Reason Code 03	Character	Generic Edit	1	0	Allow NULL?
81	JDF1T	Future 1 Text	String	Generic Edit	30	0	Allow NULL?
82	JDF2T	Future 2 Text	String	Generic Edit	30	0	Allow NULL?
83	JDF3T	Future 3 Text	String	Generic Edit	30	0	Allow NULL?
84	JDF1A	Future 1 Amount	Numeric	Generic Edit	15	0	Allow NULL?
85	JDF2A	Future 2 Amount	Numeric	Generic Edit	15	0	Allow NULL?
86	JDF3A	Future 3 Amount	Numeric	Generic Edit	15	0	Allow NULL?
87	JDPSG	Posting Stage	Numeric	Generic Edit	3	0	Allow NULL?
88	JDCLT	Change Lot	String	Generic Edit	4	0	Allow NULL?
89	JDDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
90	JDDOC2	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
91	JDDOC3	Cost Document Number	Numeric	Generic Edit	8	0	Allow NULL?
92	JDDCT1	Close Document Type	String	UDC (00 DT)	2	0	Allow NULL?
93	JDDCT2	Final Document Type	String	UDC (00 DT)	2	0	Allow NULL?
94	JDDCT3	Cost Document Type	String	UDC (00 DT)	2	0	Allow NULL?
95	JDLDR	Lender Number	Numeric	Generic Edit	8	0	Allow NULL?
96	JDASC2	Sales Associate Number 2	Numeric	Generic Edit	8	0	Allow NULL?
97	JDASC3	Sales Associate Number 3	Numeric	Generic Edit	8	0	Allow NULL?
98	JDCM1	Amount - Commission 1	Numeric	Generic Edit	15	2	Allow NULL?
99	JDCM2	Amount - Commission 2	Numeric	Generic Edit	15	2	Allow NULL?
100	JDCM3	Amount - Commission 3	Numeric	Generic Edit	15	2	Allow NULL?
101	JDUSD4	User Date 4	Date	Generic Edit	6	0
102	JDUSD5	User Date 5	Date	Generic Edit	6	0
103	JDUSD6	User Date 6	Date	Generic Edit	6	0
104	JDPC1	Percent 1	Numeric	Generic Edit	3	2	Allow NULL?
105	JDPC2	Percent 2	Numeric	Generic Edit	3	2	Allow NULL?
106	JDPC3	Percent 3	Numeric	Generic Edit	3	2	Allow NULL?
107	JDCBN	Cobroke Number	Numeric	Generic Edit	8	0	Allow NULL?
108	JDCLJ	Conversion Loss Date	Date	Generic Edit	6	0
109	JDLAG	Listing Agent	Numeric	Generic Edit	8	0	Allow NULL?
110	JDPTX	Property Text	String	Generic Edit	30	0	Allow NULL?
111	JDLNN	Loan Number	String	Generic Edit	8	0	Allow NULL?
112	JDOP1	Amount - Option Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
113	JDOP2	Amount - Option Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
114	JDOP3	Amount - Option Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
115	JDDSN1	Design Consultant 1	Numeric	Generic Edit	8	0	Allow NULL?
116	JDDSN2	Design Consultant 2	Numeric	Generic Edit	8	0	Allow NULL?
117	JDDSC1	Description	String	Generic Edit	30	0	Allow NULL?
118	JDDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
119	JDDSC3	Description - Line 3	String	Generic Edit	30	0	Allow NULL?
120	JDF4A	Future 4 Amount	Numeric	Generic Edit	15	0	Allow NULL?
121	JDF5A	Future 5 Amount	Numeric	Generic Edit	15	0	Allow NULL?
122	JDF6A	Future 6 Amount	Numeric	Generic Edit	15	0	Allow NULL?
123	JDUSD7	User Date 7	Date	Generic Edit	6	0
124	JDUSD8	User Date 8	Date	Generic Edit	6	0
125	JDUSD9	User Date 9	Date	Generic Edit	6	0
126	JDUC04	User Reason Code 04	Character	Generic Edit	1	0	Allow NULL?
127	JDUC05	User Reason Code 05	Character	Generic Edit	1	0	Allow NULL?
128	JDUC06	User Reason Code 06	Character	Generic Edit	1	0	Allow NULL?
129	JDDTKN	Amount - Deposit Taken	Numeric	Generic Edit	15	2	Allow NULL?
130	JDSLKF	Start Lock Flag	Character	Generic Edit	1	0	Allow NULL?
131	JDBLDR	Builder Number	Numeric	Generic Edit	8	0	Allow NULL?

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

131 COLUMNS | 1 INDEXES | 920 | 44H | F4450 TABLE

TOP 920 | 44H | F4450 COLUMNS

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

131 COLUMNS | 1 INDEXES | 920 | 44H | F4450 TABLE

TOP920 | 44H | F4450 COLUMNS

TOP920 | 44H | F4450 INDEXES

TOP 920 | 44H | F4450 COLUMNS

TOP 920 | 44H | F4450 INDEXES