	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

119 COLUMNS | 3 INDEXES | 812 | 15 | F1538B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Property Management
1	812	F1538B	NZ	119	3	EP Billing Register Work File	Regular Work Files	15: Property Management	No

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 FROM F1538B

TOP 812 | 15 | F1538B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	NZAN8	Address Number	Numeric	UDC	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	UDC (15 EC)	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	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?

TOP 812 | 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

119 COLUMNS | 3 INDEXES | 812 | 15 | F1538B TABLE

TOP 812 | 15 | F1538B COLUMNS

TOP 812 | 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

119 COLUMNS | 3 INDEXES | 812 | 15 | F1538B TABLE

TOP812 | 15 | F1538B COLUMNS

TOP812 | 15 | F1538B INDEXES

TOP 812 | 15 | F1538B COLUMNS

TOP 812 | 15 | F1538B INDEXES