	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

140 COLUMNS | 2 INDEXES | 920 | 15L | F15L38 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15L: Adv Real Estate Forecasting
1	920	F15L38	NZ	140	2	AREF EP Billing Register	Regular Work 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 NZMCU, NZRVNB, NZUNIT, NZDOCO, NZLSVR, NZEPCL, NZBCI, NZCTRY, NZFY, NZPN, NZPOFE, NZEPGR, NZEPSG, NZTRBM, NZTRBY, NZTRB#, NZTREJ, NZPTBM, NZPTBY, NZPTB#, NZPTEM, NZPTEY, NZPTE#, NZCLSX, NZACTX, NZTRNX, NZEPCP, NZADEX, NZBSEX, NZBPSM, NZBPSY, NZBPS#, NZCPFC, NZCMPF, NZTOTX, NZNETX, NZEPOF, NZEPCD, NZECMP, NZDENM, NZSHFC, NZGRSH, NZGRPL, NZSGRL, NZSGAD, NZGRAD, NZOCRL, NZOCPB, NZOCPE, NZOCAD, NZEPLM, NZNETS, NZAG, NZCLSB, NZFERT, NZFEEA, NZGLC, NZDL01, NZBRAD, NZFEBS, NZGPCT, NZAAP, NZMSGF, NZCLAF, NZCLAA, NZCAA2, NZEPCN, NZEPLN, NZBALN, NZBALX, NZBANC, NZBAXC, NZBYCN, NZBYCX, NZBYLN, NZBYLX, NZEPCC, NZCTCN, NZCTCX, NZCTLN, NZCTLX, NZEACN, NZEACM, NZEALN, NZEALM, NZTEXR, NZCPVA, NZSFDN, NZEXCV, NZCAPA, NZAEPA, NZPRORAT, NZAID, NZURCD, NZURDT, NZURAT, NZURAB, NZURRF, NZUSER, NZPID, NZUPMJ, NZUPMT, NZJOBN, NZCLEST, NZCLEAID, NZCLACC, NZCLAAID, NZCAPID, NZCAPIDC, NZCAPPCT, NZCAPPCTC, NZCAPAMT, NZCAPAMTC, NZACTAMT, NZACTAMTC, NZEXSTCAP, NZEXSTCAPC, NZEXNOCAP, NZEXNOCAPC, NZCAPADJ, NZCAPADJC, NZOCGUA, NZEXREDST, NZBILLRAT, NZBSEXG, NZCOMADJ, NZCLAFAMT, NZRFREC, NZRFRECC, NZGLMD, NZPOCPCT, NZEOCPCT, NZFEEA2, NZFEEA3, NZBEXUOM, NZORDNUM, NZLTGRP, NZAECBF, NZALCBF, NZACTADJ FROM F15L38

TOP 920 | 15L | F15L38 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	NZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
2	NZRVNB	Revision Number	Numeric	Generic Edit	3	0	Allow NULL?
3	NZUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
4	NZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	NZLSVR	Lease Version	Numeric	Generic Edit	6	0	Allow NULL?
6	NZEPCL	Expense Participation Class	String	Generic Edit	4	0	Allow NULL?
7	NZBCI	Billing Control ID	Numeric	Generic Edit	8	0	Allow NULL?
8	NZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
9	NZFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
10	NZPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
11	NZPOFE	Preliminary Or Final Exposure Flag	Character	Generic Edit	1	0	Allow NULL?
12	NZEPGR	Expense Participation Group	String	Generic Edit	3	0	Allow NULL?
13	NZEPSG	Expense Participation Subgroup	String	Generic Edit	3	0	Allow NULL?
14	NZTRBM	Date - Term Beginning Month	Numeric	Generic Edit	2	0	Allow NULL?
15	NZTRBY	Date - Term Beginning Year	Numeric	Generic Edit	2	0	Allow NULL?
16	NZTRB#	Date - Term Beginning Century	Numeric	Generic Edit	2	0	Allow NULL?
17	NZTREJ	Term Ending Date - Julian	Date	Generic Edit	6	0
18	NZPTBM	Date - Participation Beginning Month	Numeric	Generic Edit	2	0	Allow NULL?
19	NZPTBY	Date - Participation Beginning Year	Numeric	Generic Edit	2	0	Allow NULL?
20	NZPTB#	Date - Participation Beginning Century	Numeric	Generic Edit	2	0	Allow NULL?
21	NZPTEM	Date - Participation Ending Month	Numeric	Generic Edit	2	0	Allow NULL?
22	NZPTEY	Date - Participation Ending Year	Numeric	Generic Edit	2	0	Allow NULL?
23	NZPTE#	Date - Participation Ending Century	Numeric	Generic Edit	2	0	Allow NULL?
24	NZCLSX	EP Tenant Class Exposure	Numeric	Generic Edit	15	2	Allow NULL?
25	NZACTX	EP Account Exclusions	Numeric	Generic Edit	15	2	Allow NULL?
26	NZTRNX	EP Transaction Exclusions	Numeric	Generic Edit	15	2	Allow NULL?
27	NZEPCP	EP - Class Expense Limit	Numeric	Generic Edit	15	2	Allow NULL?
28	NZADEX	EP Adjusted Class Exposure	Numeric	Generic Edit	15	2	Allow NULL?
29	NZBSEX	Base Exclusion Amount	Numeric	Generic Edit	15	2	Allow NULL?
30	NZBPSM	Base Period Start - Month	Numeric	Generic Edit	2	0	Allow NULL?
31	NZBPSY	Base Period Start - Year	Numeric	Generic Edit	2	0	Allow NULL?
32	NZBPS#	Base Period Start - Century	Numeric	Generic Edit	2	0	Allow NULL?
33	NZCPFC	EP Annual Compound Factor	Numeric	Generic Edit	15	6	Allow NULL?
34	NZCMPF	EP Compounded Factor	Numeric	Generic Edit	15	6	Allow NULL?
35	NZTOTX	Compounded Base Exclusion	Numeric	Generic Edit	15	2	Allow NULL?
36	NZNETX	EP Net Exposure	Numeric	Generic Edit	15	2	Allow NULL?
37	NZEPOF	Occupancy Factor	Numeric	Generic Edit	15	0	Allow NULL?
38	NZEPCD	Expense Participation Code	String	UDC (15 EP)	2	0	Allow NULL?
39	NZECMP	Computation Method	Character	Generic Edit	1	0	Allow NULL?
40	NZDENM	Share Denominator	Numeric	Generic Edit	15	2	Allow NULL?
41	NZSHFC	EP Share Factor	Numeric	Generic Edit	15	6	Allow NULL?
42	NZGRSH	EP Gross Share	Numeric	Generic Edit	15	2	Allow NULL?
43	NZGRPL	Group Limit for E.P.	Numeric	Generic Edit	15	2	Allow NULL?
44	NZSGRL	Sub-Group Limit for E.P.	Numeric	Generic Edit	15	2	Allow NULL?
45	NZSGAD	EP Subgroup Adjustment	Numeric	Generic Edit	15	2	Allow NULL?
46	NZGRAD	EP Group Adjustment	Numeric	Generic Edit	15	2	Allow NULL?
47	NZOCRL	EP Occupancy Rule	Character	UDC (15 OC)	1	0	Allow NULL?
48	NZOCPB	Occupancy Date From	Date	Generic Edit	6	0
49	NZOCPE	Occupancy Date To	Date	Generic Edit	6	0
50	NZOCAD	EP Occupancy Adjustment Factor	Numeric	Generic Edit	15	6	Allow NULL?
51	NZEPLM	EP Tenant Share Limit	Numeric	Generic Edit	15	2	Allow NULL?
52	NZNETS	EP Net Share	Numeric	Generic Edit	15	2	Allow NULL?
53	NZAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
54	NZCLSB	EP Class Billable	Numeric	Generic Edit	15	2	Allow NULL?
55	NZFERT	Fee Rate	Numeric	Generic Edit	15	6	Allow NULL?
56	NZFEEA	EP Fee Amount	Numeric	Generic Edit	15	2	Allow NULL?
57	NZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
58	NZDL01	Description	String	Generic Edit	30	0	Allow NULL?
59	NZBRAD	Billing Receipt Code-Admin Fee	String	Generic Edit	4	0	Allow NULL?
60	NZFEBS	Fee Basis	Character	UDC (15 FB)	1	0	Allow NULL?
61	NZGPCT	Percentage Gross-Up E.P.	Numeric	Generic Edit	15	6	Allow NULL?
62	NZAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
63	NZMSGF	Message Flag	Character	Generic Edit	1	0	Allow NULL?
64	NZCLAF	Class Adjustment Factor	Numeric	Generic Edit	15	6	Allow NULL?
65	NZCLAA	Class Adjustment Amount	Numeric	Generic Edit	15	2	Allow NULL?
66	NZCAA2	Class Adjustment Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
67	NZEPCN	EP Mimimum Class Limit	Numeric	Generic Edit	15	2	Allow NULL?
68	NZEPLN	EP Mimimum Lease Limit	Numeric	Generic Edit	15	2	Allow NULL?
69	NZBALN	Lease Mimimum Base	Numeric	Generic Edit	15	2	Allow NULL?
70	NZBALX	Lease Maximum Base	Numeric	Generic Edit	15	2	Allow NULL?
71	NZBANC	Class Mimimum Base	Numeric	Generic Edit	15	2	Allow NULL?
72	NZBAXC	Class Maximum Base	Numeric	Generic Edit	15	2	Allow NULL?
73	NZBYCN	Class Base Start Year - Min	Numeric	Generic Edit	4	0	Allow NULL?
74	NZBYCX	Class Base Start Year - Max	Numeric	Generic Edit	4	0	Allow NULL?
75	NZBYLN	Lease Base Start Year - Min	Numeric	Generic Edit	4	0	Allow NULL?
76	NZBYLX	Lease Base Start Year - Max	Numeric	Generic Edit	4	0	Allow NULL?
77	NZEPCC	EPCalculationChangeLevel	Character	Generic Edit	1	0	Allow NULL?
78	NZCTCN	Calculation Type Class - Min	Character	Generic Edit	1	0	Allow NULL?
79	NZCTCX	Calculation Type Class - Max	Character	Generic Edit	1	0	Allow NULL?
80	NZCTLN	Calculation Type Lease - Min	Character	Generic Edit	1	0	Allow NULL?
81	NZCTLX	Calculation Type Lease - Max	Character	Generic Edit	1	0	Allow NULL?
82	NZEACN	EP Adjustment - Class Min	Numeric	Generic Edit	15	2	Allow NULL?
83	NZEACM	EP Adjustment - Class Max	Numeric	Generic Edit	15	2	Allow NULL?
84	NZEALN	EP Adjustment - Lease Min	Numeric	Generic Edit	15	2	Allow NULL?
85	NZEALM	EP Adjustment - Lease Max	Numeric	Generic Edit	15	2	Allow NULL?
86	NZTEXR	EP Tenant Exclusion Rule	String	Generic Edit	10	0	Allow NULL?
87	NZCPVA	Cap Value	Numeric	Generic Edit	5	2	Allow NULL?
88	NZSFDN	Share Factor Denominator ID	String	Generic Edit	10	0	Allow NULL?
89	NZEXCV	Exclusion Value	Numeric	Generic Edit	15	2	Allow NULL?
90	NZCAPA	Cap Amount	Numeric	Generic Edit	15	2	Allow NULL?
91	NZAEPA	Amount Per Sq. Ft.	Numeric	Generic Edit	15	2	Allow NULL?
92	NZPRORAT	Proration Factor	Numeric	Generic Edit	5	3	Allow NULL?
93	NZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
94	NZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
95	NZURDT	User Reserved Date	Date	Generic Edit	6	0
96	NZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
97	NZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
98	NZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
99	NZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
100	NZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
101	NZUPMJ	Date - Updated	Date	Generic Edit	6	0
102	NZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
103	NZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
104	NZCLEST	EP Class Estimated Billable	Numeric	Generic Edit	15	2	Allow NULL?
105	NZCLEAID	EP Est Account ID	String	Generic Edit	8	0	Allow NULL?
106	NZCLACC	EP Class Accrual Billable	Numeric	Generic Edit	15	2	Allow NULL?
107	NZCLAAID	EP Acc Account ID	String	Generic Edit	8	0	Allow NULL?
108	NZCAPID	Cap Rule ID	String	Generic Edit	10	0	Allow NULL?
109	NZCAPIDC	Cap Rule ID Class	String	Generic Edit	10	0	Allow NULL?
110	NZCAPPCT	Cap Percentage Factor	Numeric	Generic Edit	15	6	Allow NULL?
111	NZCAPPCTC	Cap Percentage Factor Class	Numeric	Generic Edit	15	6	Allow NULL?
112	NZCAPAMT	Cap Amount	Numeric	Generic Edit	15	2	Allow NULL?
113	NZCAPAMTC	Cap Amount Class	Numeric	Generic Edit	15	2	Allow NULL?
114	NZACTAMT	Actual Amount	Numeric	Generic Edit	15	2	Allow NULL?
115	NZACTAMTC	Actual Amount Class	Numeric	Generic Edit	15	2	Allow NULL?
116	NZEXSTCAP	Exposure Subject To Cap	Numeric	Generic Edit	15	2	Allow NULL?
117	NZEXSTCAPC	Exposure Subject To Cap Class	Numeric	Generic Edit	15	2	Allow NULL?
118	NZEXNOCAP	Exposure Not Subject To Cap	Numeric	Generic Edit	15	2	Allow NULL?
119	NZEXNOCAPC	Exposure Not Subject To Cap Class	Numeric	Generic Edit	15	2	Allow NULL?
120	NZCAPADJ	Cap Adjustment Amount	Numeric	Generic Edit	15	2	Allow NULL?
121	NZCAPADJC	Cap Adjustment Amount Class	Numeric	Generic Edit	15	2	Allow NULL?
122	NZOCGUA	Gross Up Adjustment	Numeric	Generic Edit	15	2	Allow NULL?
123	NZEXREDST	Exclusion Redistribution Adjustment	Numeric	Generic Edit	15	2	Allow NULL?
124	NZBILLRAT	Billable Rate	Numeric	Generic Edit	15	8	Allow NULL?
125	NZBSEXG	Base Exclusion Group	String	Generic Edit	10	0	Allow NULL?
126	NZCOMADJ	Class Common Adjustment Amount	Numeric	Generic Edit	15	2	Allow NULL?
127	NZCLAFAMT	Class Adjustment Factor Amount	Numeric	Generic Edit	15	2	Allow NULL?
128	NZRFREC	Roll Forward Recovered Amount	Numeric	Generic Edit	15	2	Allow NULL?
129	NZRFRECC	Roll Forward Recovered Amount Class	Numeric	Generic Edit	15	2	Allow NULL?
130	NZGLMD	Area Calculation Method	Character	UDC (15 OM)	1	0	Allow NULL?
131	NZPOCPCT	Physical Occupancy Percentage	Numeric	Generic Edit	15	6	Allow NULL?
132	NZEOCPCT	Economic Occupancy Percentage	Numeric	Generic Edit	15	6	Allow NULL?
133	NZFEEA2	EP Fee Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
134	NZFEEA3	EP Fee Amount 3	Numeric	Generic Edit	15	2	Allow NULL?
135	NZBEXUOM	Base Year Exclusion Per Square Foot	Numeric	Generic Edit	15	2	Allow NULL?
136	NZORDNUM	Order of Processing Number	Numeric	Generic Edit	8	0	Allow NULL?
137	NZLTGRP	Ledger Type Group	String	Generic Edit	15	0	Allow NULL?
138	NZAECBF	Expense Cap Placement	Character	UDC (15 C1)	1	0	Allow NULL?
139	NZALCBF	Lease Cap Placement	Character	UDC (15 C2)	1	0	Allow NULL?
140	NZACTADJ	EP Account Adjustment	Numeric	Generic Edit	15	2	Allow NULL?

TOP 920 | 15L | F15L38 INDEXES

Number

Description

Building Revision Num + (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	RVNB	Revision Number	Ascending
3	UNIT	Unit	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	LSVR	Lease Version	Ascending
6	EPCL	Expense Participation Class	Ascending
7	BCI	Billing Control ID	Ascending
8	CTRY	Century	Ascending
9	FY	Fiscal Year	Ascending
10	PN	Period Number - General Ledger	Ascending
11	POFE	Preliminary Or Final Exposure Flag	Ascending

Building Rev Num no POFE

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	RVNB	Revision Number	Ascending
3	UNIT	Unit	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	LSVR	Lease Version	Ascending
6	EPCL	Expense Participation Class	Ascending
7	BCI	Billing Control ID	Ascending
8	CTRY	Century	Ascending
9	FY	Fiscal Year	Ascending
10	PN	Period Number - General Ledger	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

140 COLUMNS | 2 INDEXES | 920 | 15L | F15L38 TABLE

TOP 920 | 15L | F15L38 COLUMNS

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

140 COLUMNS | 2 INDEXES | 920 | 15L | F15L38 TABLE

TOP920 | 15L | F15L38 COLUMNS

TOP920 | 15L | F15L38 INDEXES

TOP 920 | 15L | F15L38 COLUMNS

TOP 920 | 15L | F15L38 INDEXES