	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

99 COLUMNS | 9 INDEXES | 920 | 15L | F15L101 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15L: Adv Real Estate Forecasting
1	920	F15L101	UM	99	9	AREF Unit Master	Files	15L: Adv Real Estate Forecasting	Business Data

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 UMMCU, UMUNIT, UMRVNB, UMMCUS, UMDESC, UMFLOR, UMOUNT, UMRENA, UMUTTY, UMEPTY, UMRL01, UMRL02, UMRL03, UMRL04, UMRL05, UMUR01, UMUR02, UMUR03, UMUR04, UMUR05, UMVREF, UMVRED, UMDOCO, UMUM, UMUSEA, UMSUSA, UMSPSF, UMEFTB, UMEFTE, UMBELK, UMEPRD, UMEPRE, UMEPRF, UMASP1, UMASP2, UMASP3, UMSOID, UMSOIE, UMSOIF, UMBCRI, UMBCRJ, UMBCRK, UMAACT, UMAACU, UMAACV, UMBA01, UMBA02, UMBA03, UMBA04, UMBA05, UMBA06, UMBA07, UMBA08, UMBA09, UMBA10, UMBA11, UMBA12, UMDAJ, UMDSP, UMDEXJ, UMDBDT, UMDEET, UMNUMB, UMRFL1, UMRFL2, UMRFL3, UMRFL4, UMRFL5, UMRFL6, UMRFL7, UMRFL8, UMRFL9, UMRFL10, UMRFL11, UMRFL12, UMRFL13, UMRFL14, UMRFL15, UMURCD, UMURDT, UMURAT, UMURAB, UMURRF, UMUSER, UMPID, UMUPMJ, UMUPMT, UMJOBN, UMTORG, UMENTJ, UMARRID, UMRNWFLG, UMRNWGPA, UMRNWEXT, UMRNWDWT, UMREMGAP, UMLSVR, UMUKID, UMRNWTTY FROM F15L101

TOP 920 | 15L | F15L101 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	UMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
2	UMUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
3	UMRVNB	Revision Number	Numeric	Generic Edit	3	0	Allow NULL?
4	UMMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
5	UMDESC	Description	String	Generic Edit	30	0	Allow NULL?
6	UMFLOR	Number - Floor	String	UDC (15 FL)	4	0	Allow NULL?
7	UMOUNT	Original Unit No.	String	Generic Edit	8	0	Allow NULL?
8	UMRENA	Rent Amount	Numeric	Generic Edit	15	2	Allow NULL?
9	UMUTTY	Unit Type	String	UDC (15 UT)	5	0	Allow NULL?
10	UMEPTY	Expense Unit Type	String	UDC (15 EU)	5	0	Allow NULL?
11	UMRL01	Reporting Code - Unit Master 01	String	UDC (15 U1)	3	0	Allow NULL?
12	UMRL02	Reporting Code - Unit Master 02	String	UDC (15 U2)	3	0	Allow NULL?
13	UMRL03	Reporting Code - Unit Master 03	String	UDC (15 U3)	3	0	Allow NULL?
14	UMRL04	Reporting Code - Unit Master 04	String	UDC (15 U4)	3	0	Allow NULL?
15	UMRL05	Reporting Code - Unit Master 05	String	UDC (15 U5)	3	0	Allow NULL?
16	UMUR01	Reporting Code - AREF 01	String	UDC (15L 01)	3	0	Allow NULL?
17	UMUR02	Reporting Code - AREF 02	String	UDC (15L 02)	3	0	Allow NULL?
18	UMUR03	Reporting Code - AREF 03	String	UDC (15L 03)	3	0	Allow NULL?
19	UMUR04	Reporting Code - AREF 04	String	UDC (15L 04)	3	0	Allow NULL?
20	UMUR05	Reporting Code - AREF 05	String	UDC (15L 05)	3	0	Allow NULL?
21	UMVREF	Date - Version Effective	Date	Generic Edit	6	0
22	UMVRED	Date - Version Ending	Date	Generic Edit	6	0
23	UMDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
24	UMUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
25	UMUSEA	Units - Usable Area (Sq. Ft.)	Numeric	Generic Edit	15	2	Allow NULL?
26	UMSUSA	Units - Sales Usable Area (Sq. Ft.)	Numeric	Generic Edit	15	2	Allow NULL?
27	UMSPSF	Sales Per Square Foot	Numeric	Generic Edit	15	2	Allow NULL?
28	UMEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
29	UMEFTE	Date - Ending Effective	Date	Generic Edit	6	0
30	UMBELK	Lock Flag	Character	UDC (00 AA)	1	0	Allow NULL?
31	UMEPRD	E.P. Rules ID	String	Generic Edit	10	0	Allow NULL?
32	UMEPRE	E.P. Rules ID 02	String	Generic Edit	10	0	Allow NULL?
33	UMEPRF	E.P. Rules ID 03	String	Generic Edit	10	0	Allow NULL?
34	UMASP1	Assumption ID 01	String	Generic Edit	10	0	Allow NULL?
35	UMASP2	Assumption ID 02	String	Generic Edit	10	0	Allow NULL?
36	UMASP3	Assumption ID 03	String	Generic Edit	10	0	Allow NULL?
37	UMSOID	Sales Overage ID	String	Generic Edit	10	0	Allow NULL?
38	UMSOIE	Sales Overage ID 02	String	Generic Edit	10	0	Allow NULL?
39	UMSOIF	Sales Overage ID 03	String	Generic Edit	10	0	Allow NULL?
40	UMBCRI	Bill Code Rules ID	String	Generic Edit	10	0	Allow NULL?
41	UMBCRJ	Bill Code Rules ID 2	String	Generic Edit	10	0	Allow NULL?
42	UMBCRK	Bill Code Rules ID 3	String	Generic Edit	10	0	Allow NULL?
43	UMAACT	Assumption Action 01	String	UDC (15L UA)	2	0	Allow NULL?
44	UMAACU	Assumption Action 02	String	UDC (15L UA)	2	0	Allow NULL?
45	UMAACV	Assumption Action 03	String	UDC (15L UA)	2	0	Allow NULL?
46	UMBA01	Amount - Adjustment 01	Numeric	Generic Edit	15	2	Allow NULL?
47	UMBA02	Amount - Adjustment 02	Numeric	Generic Edit	15	2	Allow NULL?
48	UMBA03	Amount - Adjustment 03	Numeric	Generic Edit	15	2	Allow NULL?
49	UMBA04	Amount - Adjustment 04	Numeric	Generic Edit	15	2	Allow NULL?
50	UMBA05	Amount - Adjustment 05	Numeric	Generic Edit	15	2	Allow NULL?
51	UMBA06	Amount - Adjustment 06	Numeric	Generic Edit	15	2	Allow NULL?
52	UMBA07	Amount - Adjustment 07	Numeric	Generic Edit	15	2	Allow NULL?
53	UMBA08	Amount - Adjustment 08	Numeric	Generic Edit	15	2	Allow NULL?
54	UMBA09	Amount - Adjustment 09	Numeric	Generic Edit	15	2	Allow NULL?
55	UMBA10	Amount - Adjustment 10	Numeric	Generic Edit	15	2	Allow NULL?
56	UMBA11	Amount - Adjustment 11	Numeric	Generic Edit	15	2	Allow NULL?
57	UMBA12	Amount - Adjustment 12	Numeric	Generic Edit	15	2	Allow NULL?
58	UMDAJ	Date - Acquired	Date	Generic Edit	6	0
59	UMDSP	Date - Disposed or Retired	Date	Generic Edit	6	0
60	UMDEXJ	Date - Expired (Julian)	Date	Generic Edit	6	0
61	UMDBDT	Depreciation Begin Date	Date	Generic Edit	6	0
62	UMDEET	Depreciation End Date	Date	Generic Edit	6	0
63	UMNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
64	UMRFL1	Recapture Field 01	Numeric	Generic Edit	15	2	Allow NULL?
65	UMRFL2	Recapture Field 02	Numeric	Generic Edit	15	2	Allow NULL?
66	UMRFL3	Recapture Field 03	Numeric	Generic Edit	15	2	Allow NULL?
67	UMRFL4	Recapture Field 04	Numeric	Generic Edit	15	2	Allow NULL?
68	UMRFL5	Recapture Field 05	Numeric	Generic Edit	15	2	Allow NULL?
69	UMRFL6	Recapture Field 06	Numeric	Generic Edit	15	2	Allow NULL?
70	UMRFL7	Recapture Field 07	Numeric	Generic Edit	15	2	Allow NULL?
71	UMRFL8	Recapture Field 08	Numeric	Generic Edit	15	2	Allow NULL?
72	UMRFL9	Recapture Field 09	Numeric	Generic Edit	15	2	Allow NULL?
73	UMRFL10	Recapture Field 10	Numeric	Generic Edit	15	2	Allow NULL?
74	UMRFL11	Recapture Field 11	Numeric	Generic Edit	15	2	Allow NULL?
75	UMRFL12	Recapture Field 12	Numeric	Generic Edit	15	2	Allow NULL?
76	UMRFL13	Recapture Field 13	Numeric	Generic Edit	15	2	Allow NULL?
77	UMRFL14	Recapture Field 14	Numeric	Generic Edit	15	2	Allow NULL?
78	UMRFL15	Recapture Field 15	Numeric	Generic Edit	15	2	Allow NULL?
79	UMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
80	UMURDT	User Reserved Date	Date	Generic Edit	6	0
81	UMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
82	UMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
83	UMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
84	UMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
85	UMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
86	UMUPMJ	Date - Updated	Date	Generic Edit	6	0
87	UMUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
88	UMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
89	UMTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
90	UMENTJ	Date - Entered	Date	Generic Edit	6	0
91	UMARRID	Recycle Assumption Rule ID	String	Generic Edit	10	0	Allow NULL?
92	UMRNWFLG	Renew From REM Flag	Character	Generic Edit	1	0	Allow NULL?
93	UMRNWGPA	Renewal Growth Pattern	String	Generic Edit	10	0	Allow NULL?
94	UMRNWEXT	Renewal Term To Extend	Numeric	Generic Edit	5	0	Allow NULL?
95	UMRNWDWT	Renewal Months Downtime	Numeric	Generic Edit	5	0	Allow NULL?
96	UMREMGAP	Time Prior to Lease is Downtime	Character	Generic Edit	1	0	Allow NULL?
97	UMLSVR	Lease Version	Numeric	Generic Edit	6	0	Allow NULL?
98	UMUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
99	UMRNWTTY	Renewal Term Type	String	UDC (15L LT)	10	0	Allow NULL?

TOP 920 | 15L | F15L101 INDEXES

Number

Description

CostCenter UnitNo Revision +A (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	UNIT	Unit	Ascending
3	RVNB	Revision Number	Ascending
4	UKID	Unique Key ID (Internal)	Ascending

CostCenter RevisionNo Original

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	RVNB	Revision Number	Ascending
3	OUNT	Original Unit No.	Ascending

RevisionNo Property Building

Element	Alias	Description	Sequence
1	RVNB	Revision Number	Ascending
2	MCUS	Business Unit - Subsequent	Ascending
3	MCU	Business Unit	Ascending
4	UNIT	Unit	Ascending
5	VREF	Date - Version Effective	Descending

CostCenter Unit Revision +B

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	UNIT	Unit	Ascending
3	RVNB	Revision Number	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	LSVR	Lease Version	Ascending

Assumption Recycle Rule

Element	Alias	Description	Sequence
1	ARRID	Recycle Assumption Rule ID	Ascending

CostCenter Unit Revision +C

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	UNIT	Unit	Ascending
3	RVNB	Revision Number	Ascending
4	VREF	Date - Version Effective	Descending

CostCenter Unit Revision

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	UNIT	Unit	Ascending
3	RVNB	Revision Number	Ascending

CostCenter Unit Revision +D

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	UNIT	Unit	Ascending
3	RVNB	Revision Number	Ascending
4	VREF	Date - Version Effective	Ascending

MCU RVNB ARRID

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	RVNB	Revision Number	Ascending
3	ARRID	Recycle Assumption Rule ID	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

99 COLUMNS | 9 INDEXES | 920 | 15L | F15L101 TABLE

TOP 920 | 15L | F15L101 COLUMNS

TOP 920 | 15L | F15L101 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

99 COLUMNS | 9 INDEXES | 920 | 15L | F15L101 TABLE

TOP920 | 15L | F15L101 COLUMNS

TOP920 | 15L | F15L101 INDEXES

TOP 920 | 15L | F15L101 COLUMNS

TOP 920 | 15L | F15L101 INDEXES