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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger 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	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	812	F4456	JI	131	1	Lot Proceed Entry (World)	Files	44H: Homebuilder Management

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	JIMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
2	JIMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	JIALOT	Lot Proceed Lot Number	String	Generic Edit	4	0	Allow NULL?
4	JISFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
5	JIPL	Plan Number	String	Generic Edit	4	0	Allow NULL?
6	JIELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
7	JISTDJ	Start Date (Julian)	Date	Generic Edit	6	0
8	JILNT	Loan Type	String	Generic Edit	8	0	Allow NULL?
9	JIPMN	Permit Number	String	Generic Edit	12	0	Allow NULL?
10	JICLRH	Color Hold	Character	Generic Edit	1	0	Allow NULL?
11	JICLPK	Color Package	String	Generic Edit	10	0	Allow NULL?
12	JISWG	Swing	Character	Generic Edit	1	0	Allow NULL?
13	JIBYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
14	JIASC	Sales Associate Number	Numeric	Generic Edit	8	0	Allow NULL?
15	JISDJ	Sales Date (Julian)	Date	Generic Edit	6	0
16	JIEDJ	Cancel Date (Julian)	Date	Generic Edit	6	0
17	JIBSP	Amount - Base Price	Numeric	Generic Edit	15	2	Allow NULL?
18	JILTP	Amount - Lot Premium	Numeric	Generic Edit	15	2	Allow NULL?
19	JIINCA	Amount - Incentive	Numeric	Generic Edit	15	2	Allow NULL?
20	JIPN1	Proceed Notes 1	String	Generic Edit	30	0	Allow NULL?
21	JIPN2	Proceed Notes 2	String	Generic Edit	30	0	Allow NULL?
22	JIPN3	Proceed Notes 3	String	Generic Edit	30	0	Allow NULL?
23	JIPN4	Proceed Notes 4	String	Generic Edit	30	0	Allow NULL?
24	JIPN5	Proceed Notes 5	String	Generic Edit	30	0	Allow NULL?
25	JIPN6	Proceed Notes 6	String	Generic Edit	30	0	Allow NULL?
26	JIJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
27	JIPID	Program ID	String	Generic Edit	10	0	Allow NULL?
28	JIUSER	User ID	String	Generic Edit	10	0	Allow NULL?
29	JIUPMJ	Date - Updated	Date	Generic Edit	6	0
30	JIACCL	Accent Color	String	Generic Edit	15	0	Allow NULL?
31	JIBDC	Body Color	String	Generic Edit	15	0	Allow NULL?
32	JIFSC	Fascia Color	String	Generic Edit	15	0	Allow NULL?
33	JIHSTY	House Type	Character	UDC (44 HT)	1	0	Allow NULL?
34	JIUPG	Amount - Upgrade	Numeric	Generic Edit	15	2	Allow NULL?
35	JITSP	Amount - Option Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
36	JISUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
37	JIDL01	Description	String	Generic Edit	30	0	Allow NULL?
38	JIROF	Roof Tile	String	Generic Edit	15	0	Allow NULL?
39	JISLP	Amount - Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
40	JIATFN	Date - Actual Finish (Julian)	Date	Generic Edit	6	0
41	JICTGJ	Contingency Effective Date	Date	Generic Edit	6	0
42	JICRD	Contingency Release Date	Date	Generic Edit	6	0
43	JICXD	Contingency Expiration Date	Date	Generic Edit	6	0
44	JILRD	Listing Receipt Date	Date	Generic Edit	6	0
45	JIPTDJ	Plot Approval Date	Date	Generic Edit	6	0
46	JIPHD	PQ Hold Date	Date	Generic Edit	6	0
47	JICTYJ	Date at City	Date	Generic Edit	6	0
48	JIPRD	Permit Received Date	Date	Generic Edit	6	0
49	JISWD	Sched walkthru date	Date	Generic Edit	6	0
50	JISWT	Sched walkthru Time	String	Generic Edit	8	0	Allow NULL?
51	JITAD	Title Appt. Date	Date	Generic Edit	6	0
52	JIPXD	Points expiration date	Date	Generic Edit	6	0
53	JIOD1	Other date 1	Date	Generic Edit	6	0
54	JIOD2	Other date 2	Date	Generic Edit	6	0
55	JIOD3	Other date 3	Date	Generic Edit	6	0
56	JILDN	Lender Name	String	Generic Edit	30	0	Allow NULL?
57	JICN1	Contingent Note 1	String	Generic Edit	30	0	Allow NULL?
58	JICN2	Contingent Note 2	String	Generic Edit	30	0	Allow NULL?
59	JION1	Other Note 1	String	Generic Edit	30	0	Allow NULL?
60	JION2	Other Note 2	String	Generic Edit	30	0	Allow NULL?
61	JION3	Other Note 3	String	Generic Edit	30	0	Allow NULL?
62	JIINR	Interest Rate	Numeric	Generic Edit	15	0	Allow NULL?
63	JIMGA	Mortage_Amount	Numeric	Generic Edit	15	2	Allow NULL?
64	JIDNPT	Down Payment	Numeric	Generic Edit	15	2	Allow NULL?
65	JIEMD	Earnest Money Deposit	Numeric	Generic Edit	15	2	Allow NULL?
66	JIOA1	Other Amount 1	Numeric	Generic Edit	15	0	Allow NULL?
67	JIOA2	Other Amount 2	Numeric	Generic Edit	15	0	Allow NULL?
68	JICDJ	Close Date (Julian)	Date	Generic Edit	6	0
69	JISCS	Sales Contract Status	Character	UDC (44 SC)	1	0	Allow NULL?
70	JICPJ	Compliance Date (Julian)	Date	Generic Edit	6	0
71	JIMAD	Mortgage Approval Date (julian)	Date	Generic Edit	6	0
72	JILADJ	Loan Application Date	Date	Generic Edit	6	0
73	JICTGS	Contingent Sale Type	String	Generic Edit	8	0	Allow NULL?
74	JICBK	Cobroke	Character	Generic Edit	1	0	Allow NULL?
75	JIUSD1	User Date 1	Date	Generic Edit	6	0
76	JIUSD2	User Date 2	Date	Generic Edit	6	0
77	JIUSD3	User Date 3	Date	Generic Edit	6	0
78	JIUC01	User Reason Code 01	Character	Generic Edit	1	0	Allow NULL?
79	JIUC02	User Reason Code 02	Character	Generic Edit	1	0	Allow NULL?
80	JIUC03	User Reason Code 03	Character	Generic Edit	1	0	Allow NULL?
81	JIF1T	Future 1 Text	String	Generic Edit	30	0	Allow NULL?
82	JIF2T	Future 2 Text	String	Generic Edit	30	0	Allow NULL?
83	JIF3T	Future 3 Text	String	Generic Edit	30	0	Allow NULL?
84	JIF1A	Future 1 Amount	Numeric	Generic Edit	15	0	Allow NULL?
85	JIF2A	Future 2 Amount	Numeric	Generic Edit	15	0	Allow NULL?
86	JIF3A	Future 3 Amount	Numeric	Generic Edit	15	0	Allow NULL?
87	JIPSG	Posting Stage	Numeric	Generic Edit	3	0	Allow NULL?
88	JICLT	Change Lot	String	Generic Edit	4	0	Allow NULL?
89	JIDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
90	JIDOC2	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
91	JIDOC3	Cost Document Number	Numeric	Generic Edit	8	0	Allow NULL?
92	JIDCT1	Close Document Type	String	UDC (00 DT)	2	0	Allow NULL?
93	JIDCT2	Final Document Type	String	UDC (00 DT)	2	0	Allow NULL?
94	JIDCT3	Cost Document Type	String	UDC (00 DT)	2	0	Allow NULL?
95	JILDR	Lender Number	Numeric	Generic Edit	8	0	Allow NULL?
96	JIASC2	Sales Associate Number 2	Numeric	Generic Edit	8	0	Allow NULL?
97	JIASC3	Sales Associate Number 3	Numeric	Generic Edit	8	0	Allow NULL?
98	JICM1	Amount - Commission 1	Numeric	Generic Edit	15	2	Allow NULL?
99	JICM2	Amount - Commission 2	Numeric	Generic Edit	15	2	Allow NULL?
100	JICM3	Amount - Commission 3	Numeric	Generic Edit	15	2	Allow NULL?
101	JIUSD4	User Date 4	Date	Generic Edit	6	0
102	JIUSD5	User Date 5	Date	Generic Edit	6	0
103	JIUSD6	User Date 6	Date	Generic Edit	6	0
104	JIPC1	Percent 1	Numeric	Generic Edit	3	2	Allow NULL?
105	JIPC2	Percent 2	Numeric	Generic Edit	3	2	Allow NULL?
106	JIPC3	Percent 3	Numeric	Generic Edit	3	2	Allow NULL?
107	JICBN	Cobroke Number	Numeric	Generic Edit	8	0	Allow NULL?
108	JICLJ	Conversion Loss Date	Date	Generic Edit	6	0
109	JILAG	Listing Agent	Numeric	Generic Edit	8	0	Allow NULL?
110	JIPTX	Property Text	String	Generic Edit	30	0	Allow NULL?
111	JILNN	Loan Number	String	Generic Edit	8	0	Allow NULL?
112	JIOP1	Amount - Option Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
113	JIOP2	Amount - Option Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
114	JIOP3	Amount - Option Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
115	JIDSN1	Design Consultant 1	Numeric	Generic Edit	8	0	Allow NULL?
116	JIDSN2	Design Consultant 2	Numeric	Generic Edit	8	0	Allow NULL?
117	JIDSC1	Description	String	Generic Edit	30	0	Allow NULL?
118	JIDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
119	JIDSC3	Description - Line 3	String	Generic Edit	30	0	Allow NULL?
120	JIF4A	Future 4 Amount	Numeric	Generic Edit	15	0	Allow NULL?
121	JIF5A	Future 5 Amount	Numeric	Generic Edit	15	0	Allow NULL?
122	JIF6A	Future 6 Amount	Numeric	Generic Edit	15	0	Allow NULL?
123	JIUSD7	User Date 7	Date	Generic Edit	6	0
124	JIUSD8	User Date 8	Date	Generic Edit	6	0
125	JIUSD9	User Date 9	Date	Generic Edit	6	0
126	JIUC04	User Reason Code 04	Character	Generic Edit	1	0	Allow NULL?
127	JIUC05	User Reason Code 05	Character	Generic Edit	1	0	Allow NULL?
128	JIUC06	User Reason Code 06	Character	Generic Edit	1	0	Allow NULL?
129	JIDTKN	Amount - Deposit Taken	Numeric	Generic Edit	15	2	Allow NULL?
130	JISLKF	Start Lock Flag	Character	Generic Edit	1	0	Allow NULL?
131	JIBLDR	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 | 812 | 44H | F4456 TABLE

TOP 812 | 44H | F4456 COLUMNS

TOP 812 | 44H | F4456 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 | 812 | 44H | F4456 TABLE

TOP812 | 44H | F4456 COLUMNS

TOP812 | 44H | F4456 INDEXES

TOP 812 | 44H | F4456 COLUMNS

TOP 812 | 44H | F4456 INDEXES