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
15: Real Estate Management
1	920	F1513	O3	59	1	FASB 13 Lease Control File	Transaction Files	15: Real Estate Management	Business Data

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	O3DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	O3MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	O3UNIT	Unit	String	Generic Edit	8	0	Allow NULL?
4	O3CTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
5	O3YR	Year - Calendar Year	Numeric	Generic Edit	2	0	Allow NULL?
6	O3ICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
7	O3PSTF	Flag - Posted	Character	UDC	1	0	Allow NULL?
8	O3GENC	Generation Control	Character	UDC (15 GN)	1	0	Allow NULL?
9	O3AN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
10	O3AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
11	O3EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
12	O3PMTC	Term of Lease	Numeric	Generic Edit	5	0	Allow NULL?
13	O3AB01	Amount - Billed 01	Numeric	UDC	15	2	Allow NULL?
14	O3AB02	Amount - Billed 02	Numeric	UDC	15	2	Allow NULL?
15	O3AB03	Amount - Billed 03	Numeric	UDC	15	2	Allow NULL?
16	O3AB04	Amount - Billed 04	Numeric	UDC	15	2	Allow NULL?
17	O3AB05	Amount - Billed 05	Numeric	UDC	15	2	Allow NULL?
18	O3AB06	Amount - Billed 06	Numeric	UDC	15	2	Allow NULL?
19	O3AB07	Amount - Billed 07	Numeric	UDC	15	2	Allow NULL?
20	O3AB08	Amount - Billed 08	Numeric	UDC	15	2	Allow NULL?
21	O3AB09	Amount - Billed 09	Numeric	UDC	15	2	Allow NULL?
22	O3AB10	Amount - Billed 10	Numeric	UDC	15	2	Allow NULL?
23	O3AB11	Amount - Billed 11	Numeric	UDC	15	2	Allow NULL?
24	O3AB12	Amount - Billed 12	Numeric	UDC	15	2	Allow NULL?
25	O3AB13	Amount - Billed 13	Numeric	UDC	15	2	Allow NULL?
26	O3BS01	Amount - Straight Line Rent 01	Numeric	Generic Edit	15	2	Allow NULL?
27	O3BS02	Amount - Straight Line Rent 02	Numeric	Generic Edit	15	2	Allow NULL?
28	O3BS03	Amount - Straight Line Rent 03	Numeric	Generic Edit	15	2	Allow NULL?
29	O3BS04	Amount - Straight Line Rent 04	Numeric	Generic Edit	15	2	Allow NULL?
30	O3BS05	Amount - Straight Line Rent 05	Numeric	Generic Edit	15	2	Allow NULL?
31	O3BS06	Amount - Straight Line Rent 06	Numeric	Generic Edit	15	2	Allow NULL?
32	O3BS07	Amount - Straight Line Rent 07	Numeric	Generic Edit	15	2	Allow NULL?
33	O3BS08	Amount - Straight Line Rent 08	Numeric	Generic Edit	15	2	Allow NULL?
34	O3BS09	Amount - Straight Line Rent 09	Numeric	Generic Edit	15	2	Allow NULL?
35	O3BS10	Amount - Straight Line Rent 10	Numeric	Generic Edit	15	2	Allow NULL?
36	O3BS11	Amount - Straight Line Rent 11	Numeric	Generic Edit	15	2	Allow NULL?
37	O3BS12	Amount - Straight Line Rent 12	Numeric	Generic Edit	15	2	Allow NULL?
38	O3BS13	Amount - Straight Line Rent 13	Numeric	Generic Edit	15	2	Allow NULL?
39	O3BALF	Amount - Balance Forward	Numeric	Generic Edit	15	2	Allow NULL?
40	O3CACH	Catch Up Adjustment Amount	Numeric	Generic Edit	15	2	Allow NULL?
41	O3CAHD	Date - Catch Up Adjustment	Date	Generic Edit	6	0
42	O3BA01	Amount - Adjustment 01	Numeric	Generic Edit	15	2	Allow NULL?
43	O3BA02	Amount - Adjustment 02	Numeric	Generic Edit	15	2	Allow NULL?
44	O3BA03	Amount - Adjustment 03	Numeric	Generic Edit	15	2	Allow NULL?
45	O3BA04	Amount - Adjustment 04	Numeric	Generic Edit	15	2	Allow NULL?
46	O3BA05	Amount - Adjustment 05	Numeric	Generic Edit	15	2	Allow NULL?
47	O3BA06	Amount - Adjustment 06	Numeric	Generic Edit	15	2	Allow NULL?
48	O3BA07	Amount - Adjustment 07	Numeric	Generic Edit	15	2	Allow NULL?
49	O3BA08	Amount - Adjustment 08	Numeric	Generic Edit	15	2	Allow NULL?
50	O3BA09	Amount - Adjustment 09	Numeric	Generic Edit	15	2	Allow NULL?
51	O3BA10	Amount - Adjustment 10	Numeric	Generic Edit	15	2	Allow NULL?
52	O3BA11	Amount - Adjustment 11	Numeric	Generic Edit	15	2	Allow NULL?
53	O3BA12	Amount - Adjustment 12	Numeric	Generic Edit	15	2	Allow NULL?
54	O3BA13	Amount - Adjustment 13	Numeric	Generic Edit	15	2	Allow NULL?
55	O3UPMJ	Date - Updated	Date	Generic Edit	6	0
56	O3USER	User ID	String	Generic Edit	10	0	Allow NULL?
57	O3PID	Program ID	String	Generic Edit	10	0	Allow NULL?
58	O3JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
59	O3UPMT	Time - Last Updated	Numeric	Generic Edit	6	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

59 COLUMNS | 1 INDEXES | 920 | 15 | F1513 TABLE

TOP 920 | 15 | F1513 COLUMNS

TOP 920 | 15 | F1513 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

59 COLUMNS | 1 INDEXES | 920 | 15 | F1513 TABLE

TOP920 | 15 | F1513 COLUMNS

TOP920 | 15 | F1513 INDEXES

TOP 920 | 15 | F1513 COLUMNS

TOP 920 | 15 | F1513 INDEXES