	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

69 COLUMNS | 2 INDEXES | 910 | 15 | F1513B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Property Management
1	910	F1513B	O3	69	2	FASB 13 Lease Control	Transaction Files	15: Property Management	Business Data

TOP 910 | 15 | F1513B COLUMNS

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	UDC	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	O3URCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
56	O3URDT	User Reserved Date	Date	Generic Edit	6	0
57	O3URAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
58	O3URAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
59	O3URRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
60	O3USER	User ID	String	Generic Edit	10	0	Allow NULL?
61	O3PID	Program ID	String	Generic Edit	10	0	Allow NULL?
62	O3UPMJ	Date - Updated	Date	Generic Edit	6	0
63	O3UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
64	O3JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
65	O3ENTJ	Date - Entered	Date	Generic Edit	6	0
66	O3TORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
67	O3CRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
68	O3CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
69	O3CRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?

TOP 910 | 15 | F1513B INDEXES

Number

Description

Batch No. Lease + (Primary/Unique)

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	MCU	Business Unit	Ascending
4	UNIT	Unit	Ascending
5	CRCD	Currency Code - From	Ascending
6	CTRY	Century	Ascending
7	YR	Year - Calendar Year	Ascending

Lease Building +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	MCU	Business Unit	Ascending
3	UNIT	Unit	Ascending
4	CRCD	Currency Code - From	Ascending
5	CTRY	Century	Ascending
6	YR	Year - Calendar Year	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

69 COLUMNS | 2 INDEXES | 910 | 15 | F1513B TABLE

TOP 910 | 15 | F1513B COLUMNS

TOP 910 | 15 | F1513B 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

69 COLUMNS | 2 INDEXES | 910 | 15 | F1513B TABLE

TOP910 | 15 | F1513B COLUMNS

TOP910 | 15 | F1513B INDEXES

TOP 910 | 15 | F1513B COLUMNS

TOP 910 | 15 | F1513B INDEXES