	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

152 COLUMNS | 3 INDEXES | 920 | 15 | F1538B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Real Estate Management
1	920	F1538B	NZ	152	3	EP Billing Register	Regular Work Files	15: Real Estate Management	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 NZAN8, NZALPH, NZAN8J, NZDOCO, NZLSVR, NZICU, NZEPCL, 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, NZSEPI, NZBCI, NZBCI3, NZMCU, NZUNIT, NZDL01, NZBRAD, NZTRAR, NZCRCD, NZTXA1, NZEXR1, NZFEBS, NZGPCT, NZREDO, NZCRRM, NZFAP, NZCDS, NZCDSA, NZCTAM, NZCTXA, NZCTXN, NZAAP, NZMSGF, NZCLAF, NZCLAA, NZCAA2, NZBLMR, NZBLGR, NZUNGR, NZPPUP, NZEPCN, NZEPLN, NZBALN, NZBALX, NZBANC, NZBAXC, NZBYCN, NZBYCX, NZBYLN, NZBYLX, NZEPCC, NZCTCN, NZCTCX, NZCTLN, NZCTLX, NZURCD, NZURDT, NZURAT, NZURAB, NZURRF, NZUSER, NZPID, NZUPMJ, NZUPMT, NZJOBN, NZEACN, NZEACM, NZEALN, NZEALM, NZTEXR, NZCPVA, NZSFDN, NZEXCV, NZCAPA, NZCRR, NZACR, 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 F1538B

TOP 920 | 15 | F1538B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	NZAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
2	NZALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
3	NZAN8J	Address Number - Alternate Payee	Numeric	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	NZICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
7	NZEPCL	Expense Participation Class	String	Generic Edit	4	0	Allow NULL?
8	NZEPGR	Expense Participation Group	String	Generic Edit	3	0	Allow NULL?
9	NZEPSG	Expense Participation Subgroup	String	Generic Edit	3	0	Allow NULL?
10	NZTRBM	Date - Term Beginning Month	Numeric	Generic Edit	2	0	Allow NULL?
11	NZTRBY	Date - Term Beginning Year	Numeric	Generic Edit	2	0	Allow NULL?
12	NZTRB#	Date - Term Beginning Century	Numeric	Generic Edit	2	0	Allow NULL?
13	NZTREJ	Term Ending Date - Julian	Date	Generic Edit	6	0
14	NZPTBM	Date - Participation Beginning Month	Numeric	Generic Edit	2	0	Allow NULL?
15	NZPTBY	Date - Participation Beginning Year	Numeric	Generic Edit	2	0	Allow NULL?
16	NZPTB#	Date - Participation Beginning Century	Numeric	Generic Edit	2	0	Allow NULL?
17	NZPTEM	Date - Participation Ending Month	Numeric	Generic Edit	2	0	Allow NULL?
18	NZPTEY	Date - Participation Ending Year	Numeric	Generic Edit	2	0	Allow NULL?
19	NZPTE#	Date - Participation Ending Century	Numeric	Generic Edit	2	0	Allow NULL?
20	NZCLSX	EP Tenant Class Exposure	Numeric	Generic Edit	15	2	Allow NULL?
21	NZACTX	EP Account Exclusions	Numeric	Generic Edit	15	2	Allow NULL?
22	NZTRNX	EP Transaction Exclusions	Numeric	Generic Edit	15	2	Allow NULL?
23	NZEPCP	EP - Class Expense Limit	Numeric	Generic Edit	15	2	Allow NULL?
24	NZADEX	EP Adjusted Class Exposure	Numeric	Generic Edit	15	2	Allow NULL?
25	NZBSEX	Base Exclusion Amount	Numeric	Generic Edit	15	2	Allow NULL?
26	NZBPSM	Base Period Start - Month	Numeric	Generic Edit	2	0	Allow NULL?
27	NZBPSY	Base Period Start - Year	Numeric	Generic Edit	2	0	Allow NULL?
28	NZBPS#	Base Period Start - Century	Numeric	Generic Edit	2	0	Allow NULL?
29	NZCPFC	EP Annual Compound Factor	Numeric	Generic Edit	15	6	Allow NULL?
30	NZCMPF	EP Compounded Factor	Numeric	Generic Edit	15	6	Allow NULL?
31	NZTOTX	Compounded Base Exclusion	Numeric	Generic Edit	15	2	Allow NULL?
32	NZNETX	EP Net Exposure	Numeric	Generic Edit	15	2	Allow NULL?
33	NZEPOF	Occupancy Factor	Numeric	Generic Edit	15	0	Allow NULL?
34	NZEPCD	Expense Participation Code	String	UDC (15 EP)	2	0	Allow NULL?
35	NZECMP	Computation Method	Character	Generic Edit	1	0	Allow NULL?
36	NZDENM	Share Denominator	Numeric	Generic Edit	15	2	Allow NULL?
37	NZSHFC	EP Share Factor	Numeric	Generic Edit	15	6	Allow NULL?
38	NZGRSH	EP Gross Share	Numeric	Generic Edit	15	2	Allow NULL?
39	NZGRPL	Group Limit for E.P.	Numeric	Generic Edit	15	2	Allow NULL?
40	NZSGRL	Sub-Group Limit for E.P.	Numeric	Generic Edit	15	2	Allow NULL?
41	NZSGAD	EP Subgroup Adjustment	Numeric	Generic Edit	15	2	Allow NULL?
42	NZGRAD	EP Group Adjustment	Numeric	Generic Edit	15	2	Allow NULL?
43	NZOCRL	EP Occupancy Rule	Character	UDC (15 OC)	1	0	Allow NULL?
44	NZOCPB	Occupancy Date From	Date	Generic Edit	6	0
45	NZOCPE	Occupancy Date To	Date	Generic Edit	6	0
46	NZOCAD	EP Occupancy Adjustment Factor	Numeric	Generic Edit	15	6	Allow NULL?
47	NZEPLM	EP Tenant Share Limit	Numeric	Generic Edit	15	2	Allow NULL?
48	NZNETS	EP Net Share	Numeric	Generic Edit	15	2	Allow NULL?
49	NZAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
50	NZCLSB	EP Class Billable	Numeric	Generic Edit	15	2	Allow NULL?
51	NZFERT	Fee Rate	Numeric	Generic Edit	15	6	Allow NULL?
52	NZFEEA	EP Fee Amount	Numeric	Generic Edit	15	2	Allow NULL?
53	NZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
54	NZSEPI	Separate Invoice Code	Character	Generic Edit	1	0	Allow NULL?
55	NZBCI	Billing Control ID	Numeric	Generic Edit	8	0	Allow NULL?
56	NZBCI3	Billing Control ID - Third	Numeric	Generic Edit	8	0	Allow NULL?
57	NZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
58	NZUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
59	NZDL01	Description	String	Generic Edit	30	0	Allow NULL?
60	NZBRAD	Billing Receipt Code-Admin Fee	String	Generic Edit	4	0	Allow NULL?
61	NZTRAR	Payment Terms - A/R	String	Generic Edit	3	0	Allow NULL?
62	NZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
63	NZTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
64	NZEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
65	NZFEBS	Fee Basis	Character	UDC (15 FB)	1	0	Allow NULL?
66	NZGPCT	Percentage Gross-Up E.P.	Numeric	Generic Edit	15	6	Allow NULL?
67	NZREDO	Reprocess Accounts	Character	Generic Edit	1	0	Allow NULL?
68	NZCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
69	NZFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
70	NZCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
71	NZCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
72	NZCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
73	NZCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
74	NZCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
75	NZAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
76	NZMSGF	Message Flag	Character	Generic Edit	1	0	Allow NULL?
77	NZCLAF	Class Adjustment Factor	Numeric	Generic Edit	15	6	Allow NULL?
78	NZCLAA	Class Adjustment Amount	Numeric	Generic Edit	15	2	Allow NULL?
79	NZCAA2	Class Adjustment Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
80	NZBLMR	Manual Review Required	Character	UDC	1	0	Allow NULL?
81	NZBLGR	Billing Group	String	Generic Edit	12	0	Allow NULL?
82	NZUNGR	Unit Group Code	Character	Generic Edit	1	0	Allow NULL?
83	NZPPUP	Pre Post Update Flag	Character	Generic Edit	1	0	Allow NULL?
84	NZEPCN	EP Mimimum Class Limit	Numeric	Generic Edit	15	2	Allow NULL?
85	NZEPLN	EP Mimimum Lease Limit	Numeric	Generic Edit	15	2	Allow NULL?
86	NZBALN	Lease Mimimum Base	Numeric	Generic Edit	15	2	Allow NULL?
87	NZBALX	Lease Maximum Base	Numeric	Generic Edit	15	2	Allow NULL?
88	NZBANC	Class Mimimum Base	Numeric	Generic Edit	15	2	Allow NULL?
89	NZBAXC	Class Maximum Base	Numeric	Generic Edit	15	2	Allow NULL?
90	NZBYCN	Class Base Start Year - Min	Numeric	Generic Edit	4	0	Allow NULL?
91	NZBYCX	Class Base Start Year - Max	Numeric	Generic Edit	4	0	Allow NULL?
92	NZBYLN	Lease Base Start Year - Min	Numeric	Generic Edit	4	0	Allow NULL?
93	NZBYLX	Lease Base Start Year - Max	Numeric	Generic Edit	4	0	Allow NULL?
94	NZEPCC	EPCalculationChangeLevel	Character	Generic Edit	1	0	Allow NULL?
95	NZCTCN	Calculation Type Class - Min	Character	Generic Edit	1	0	Allow NULL?
96	NZCTCX	Calculation Type Class - Max	Character	Generic Edit	1	0	Allow NULL?
97	NZCTLN	Calculation Type Lease - Min	Character	Generic Edit	1	0	Allow NULL?
98	NZCTLX	Calculation Type Lease - Max	Character	Generic Edit	1	0	Allow NULL?
99	NZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
100	NZURDT	User Reserved Date	Date	Generic Edit	6	0
101	NZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
102	NZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
103	NZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
104	NZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
105	NZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
106	NZUPMJ	Date - Updated	Date	Generic Edit	6	0
107	NZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
108	NZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
109	NZEACN	EP Adjustment - Class Min	Numeric	Generic Edit	15	2	Allow NULL?
110	NZEACM	EP Adjustment - Class Max	Numeric	Generic Edit	15	2	Allow NULL?
111	NZEALN	EP Adjustment - Lease Min	Numeric	Generic Edit	15	2	Allow NULL?
112	NZEALM	EP Adjustment - Lease Max	Numeric	Generic Edit	15	2	Allow NULL?
113	NZTEXR	EP Tenant Exclusion Rule	String	Generic Edit	10	0	Allow NULL?
114	NZCPVA	Cap Value	Numeric	Generic Edit	5	2	Allow NULL?
115	NZSFDN	Share Factor Denominator ID	String	Generic Edit	10	0	Allow NULL?
116	NZEXCV	Exclusion Value	Numeric	Generic Edit	15	2	Allow NULL?
117	NZCAPA	Cap Amount	Numeric	Generic Edit	15	2	Allow NULL?
118	NZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
119	NZACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
120	NZCAPID	Cap Rule ID	String	Generic Edit	10	0	Allow NULL?
121	NZCAPIDC	Cap Rule ID Class	String	Generic Edit	10	0	Allow NULL?
122	NZCAPPCT	Cap Percentage Factor	Numeric	Generic Edit	15	6	Allow NULL?
123	NZCAPPCTC	Cap Percentage Factor Class	Numeric	Generic Edit	15	6	Allow NULL?
124	NZCAPAMT	Cap Amount	Numeric	Generic Edit	15	2	Allow NULL?
125	NZCAPAMTC	Cap Amount Class	Numeric	Generic Edit	15	2	Allow NULL?
126	NZACTAMT	Actual Amount	Numeric	Generic Edit	15	2	Allow NULL?
127	NZACTAMTC	Actual Amount Class	Numeric	Generic Edit	15	2	Allow NULL?
128	NZEXSTCAP	Exposure Subject To Cap	Numeric	Generic Edit	15	2	Allow NULL?
129	NZEXSTCAPC	Exposure Subject To Cap Class	Numeric	Generic Edit	15	2	Allow NULL?
130	NZEXNOCAP	Exposure Not Subject To Cap	Numeric	Generic Edit	15	2	Allow NULL?
131	NZEXNOCAPC	Exposure Not Subject To Cap Class	Numeric	Generic Edit	15	2	Allow NULL?
132	NZCAPADJ	Cap Adjustment Amount	Numeric	Generic Edit	15	2	Allow NULL?
133	NZCAPADJC	Cap Adjustment Amount Class	Numeric	Generic Edit	15	2	Allow NULL?
134	NZOCGUA	Gross Up Adjustment	Numeric	Generic Edit	15	2	Allow NULL?
135	NZEXREDST	Exclusion Redistribution Adjustment	Numeric	Generic Edit	15	2	Allow NULL?
136	NZBILLRAT	Billable Rate	Numeric	Generic Edit	15	8	Allow NULL?
137	NZBSEXG	Base Exclusion Group	String	Generic Edit	10	0	Allow NULL?
138	NZCOMADJ	Class Common Adjustment Amount	Numeric	Generic Edit	15	2	Allow NULL?
139	NZCLAFAMT	Class Adjustment Factor Amount	Numeric	Generic Edit	15	2	Allow NULL?
140	NZRFREC	Roll Forward Recovered Amount	Numeric	Generic Edit	15	2	Allow NULL?
141	NZRFRECC	Roll Forward Recovered Amount Class	Numeric	Generic Edit	15	2	Allow NULL?
142	NZGLMD	Area Calculation Method	Character	UDC (15 OM)	1	0	Allow NULL?
143	NZPOCPCT	Physical Occupancy Percentage	Numeric	Generic Edit	15	6	Allow NULL?
144	NZEOCPCT	Economic Occupancy Percentage	Numeric	Generic Edit	15	6	Allow NULL?
145	NZFEEA2	EP Fee Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
146	NZFEEA3	EP Fee Amount 3	Numeric	Generic Edit	15	2	Allow NULL?
147	NZBEXUOM	Base Year Exclusion Per Square Foot	Numeric	Generic Edit	15	2	Allow NULL?
148	NZORDNUM	Order of Processing Number	Numeric	Generic Edit	8	0	Allow NULL?
149	NZLTGRP	Ledger Type Group	String	Generic Edit	15	0	Allow NULL?
150	NZAECBF	Expense Cap Placement	Character	UDC (15 C1)	1	0	Allow NULL?
151	NZALCBF	Lease Cap Placement	Character	UDC (15 C2)	1	0	Allow NULL?
152	NZACTADJ	EP Account Adjustment	Numeric	Generic Edit	15	2	Allow NULL?

TOP 920 | 15 | F1538B INDEXES

Number

Description

Batch Lease + (Primary/Unique)

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	LSVR	Lease Version	Ascending
4	EPCL	Expense Participation Class	Ascending
5	BCI	Billing Control ID	Ascending

Batch Lease +

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	LSVR	Lease Version	Ascending
4	SEPI	Separate Invoice Code	Ascending
5	AN8J	Address Number - Alternate Payee	Ascending

Batch Lease EP Group +

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	LSVR	Lease Version	Ascending
4	EPGR	Expense Participation Group	Ascending
5	EPSG	Expense Participation Subgroup	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

152 COLUMNS | 3 INDEXES | 920 | 15 | F1538B TABLE

TOP 920 | 15 | F1538B COLUMNS

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

152 COLUMNS | 3 INDEXES | 920 | 15 | F1538B TABLE

TOP920 | 15 | F1538B COLUMNS

TOP920 | 15 | F1538B INDEXES

TOP 920 | 15 | F1538B COLUMNS

TOP 920 | 15 | F1538B INDEXES