	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

72 COLUMNS | 3 INDEXES | 812 | 00 | F1501 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	812	F1501	NE	72	3	Tenant/Lease Master	Master Files	15: Property Management	AS400 Coexistence Tables

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 NEDOCO, NEDCTO, NEMCU, NEUNIT, NEDL01, NEAN8, NEAN8J, NEAN8A, NEAN8S, NEANSA, NEAN8P, NELSST, NEPMTC, NELSCD, NELSET, NEOWLS, NESIC, NEMGTF, NETRAR, NEINVP, NESTMP, NESECN, NEDSPN, NESTMB, NEALP, NEWTDL, NETOTD, NEAVD, NEMCUS, NESMCU, NESIC2, NECTRY, NEEFTB, NEEFTE, NEDSR, NEMIDT, NESPAD, NEMODT, NESBDT, NEDLI, NEDLP, NEMP01, NEMP02, NERNTA, NEUSEA, NERM01, NERM02, NERM03, NERM04, NERM05, NERM06, NERM07, NERM08, NERM09, NERM10, NESOCD, NEXPCD, NEESCD, NEUSER, NEUPMJ, NEPID, NEJOBN, NERYRB, NELYRB, NEAN8B, NECO, NEOLSE, NEDBUI, NEPLNM, NESPND, NEUPMT, NESBLI FROM F1501

TOP 812 | 00 | F1501 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	NEDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	NEDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	NEMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
4	NEUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
5	NEDL01	Description	String	Generic Edit	30	0	Allow NULL?
6	NEAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
7	NEAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
8	NEAN8A	Occupant Address	Numeric	Generic Edit	8	0	Allow NULL?
9	NEAN8S	Address Number - Salesman	Numeric	Generic Edit	8	0	Allow NULL?
10	NEANSA	Address Number - Manager	Numeric	Generic Edit	8	0	Allow NULL?
11	NEAN8P	Address Number - Alternate Payment Src.	Numeric	Generic Edit	8	0	Allow NULL?
12	NELSST	Lease Status	Character	UDC (15 LS)	1	0	Allow NULL?
13	NEPMTC	Term of Lease	Numeric	Generic Edit	5	0	Allow NULL?
14	NELSCD	Lease Condition	Character	Generic Edit	1	0	Allow NULL?
15	NELSET	Lease Type	String	UDC (15 LT)	2	0	Allow NULL?
16	NEOWLS	Own or Lease	Character	UDC (15 OL)	1	0	Allow NULL?
17	NESIC	Industry Classification Code	String	UDC (01 SC)	10	0	Allow NULL?
18	NEMGTF	Management Fee	Character	Generic Edit	1	0	Allow NULL?
19	NETRAR	Payment Terms - A/R	String	Generic Edit	3	0	Allow NULL?
20	NEINVP	Invoice Print Code	Character	UDC	1	0	Allow NULL?
21	NESTMP	Statement Print Code	Character	UDC	1	0	Allow NULL?
22	NESECN	Second Notice Code	Character	UDC	1	0	Allow NULL?
23	NEDSPN	Dispossess Notice Code	Character	Generic Edit	1	0	Allow NULL?
24	NESTMB	Lessee Flag	Character	UDC (15 LF)	1	0	Allow NULL?
25	NEALP	Amount - Last Applied	Numeric	Generic Edit	15	2	Allow NULL?
26	NEWTDL	Renewal Term	Numeric	Generic Edit	15	2	Allow NULL?
27	NETOTD	Total Dollars	Numeric	Generic Edit	15	2	Allow NULL?
28	NEAVD	Average Days Late	Numeric	Generic Edit	3	0	Allow NULL?
29	NEMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
30	NESMCU	Business Unit - Security	String	Generic Edit	12	0	Allow NULL?
31	NESIC2	Occupant SIC Code	String	UDC (01 SC)	10	0	Allow NULL?
32	NECTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
33	NEEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
34	NEEFTE	Date - Ending Effective	Date	Generic Edit	6	0
35	NEDSR	Date - Rent Start	Date	Generic Edit	6	0
36	NEMIDT	Date - Move-In	Date	Generic Edit	6	0
37	NESPAD	Date - Space Available Date	Date	Generic Edit	6	0
38	NEMODT	Date - Move-Out	Date	Generic Edit	6	0
39	NESBDT	Date - Sublease	Date	Generic Edit	6	0
40	NEDLI	Date - Last Invoice	Date	Generic Edit	6	0
41	NEDLP	Date - Last Paid	Date	Generic Edit	6	0
42	NEMP01	Date - Property Dates 01	Date	Generic Edit	6	0
43	NEMP02	Date - Property Dates 02	Date	Generic Edit	6	0
44	NERNTA	Units - Rentable Area (Sq. Ft.)	Numeric	Generic Edit	15	2	Allow NULL?
45	NEUSEA	Units - Usable Area (Sq. Ft.)	Numeric	Generic Edit	15	2	Allow NULL?
46	NERM01	Reporting Code - Property Management 01	String	UDC (15 01)	3	0	Allow NULL?
47	NERM02	Reporting Code - Property Management 02	String	UDC (15 02)	3	0	Allow NULL?
48	NERM03	Reporting Code - Property Management 03	String	UDC (15 03)	3	0	Allow NULL?
49	NERM04	Reporting Code - Property Management 04	String	UDC (15 04)	3	0	Allow NULL?
50	NERM05	Reporting Code - Property Management 05	String	UDC (15 05)	3	0	Allow NULL?
51	NERM06	Reporting Code - Property Management 06	String	UDC (15 06)	3	0	Allow NULL?
52	NERM07	Reporting Code - Property Management 07	String	UDC (15 07)	3	0	Allow NULL?
53	NERM08	Reporting Code - Property Management 08	String	UDC (15 08)	3	0	Allow NULL?
54	NERM09	Reporting Code - Property Management 09	String	UDC (15 09)	3	0	Allow NULL?
55	NERM10	Unit Grouping	String	UDC (15 10)	3	0	Allow NULL?
56	NESOCD	Sales Overage Code	Character	UDC	1	0	Allow NULL?
57	NEXPCD	Expense Participation Code	Character	UDC	1	0	Allow NULL?
58	NEESCD	Escalation Code	Character	UDC	1	0	Allow NULL?
59	NEUSER	User ID	String	Generic Edit	10	0	Allow NULL?
60	NEUPMJ	Date - Updated	Date	Generic Edit	6	0
61	NEPID	Program ID	String	Generic Edit	10	0	Allow NULL?
62	NEJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
63	NERYRB	Rent Year - Beginning Month	Numeric	Generic Edit	2	0	Allow NULL?
64	NELYRB	Lease Year - Beginning Month	Numeric	Generic Edit	2	0	Allow NULL?
65	NEAN8B	Address Number - Legal Notice	Numeric	Generic Edit	8	0	Allow NULL?
66	NECO	Company	String	Generic Edit	5	0	Allow NULL?
67	NEOLSE	Lease Number - Old System	String	Generic Edit	25	0	Allow NULL?
68	NEDBUI	Default Billing Unit Indicator	Character	Generic Edit	1	0	Allow NULL?
69	NEPLNM	Primary Lease Number	Numeric	Generic Edit	8	0	Allow NULL?
70	NESPND	Date - Space Not Available	Date	Generic Edit	6	0
71	NEUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
72	NESBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?

TOP 812 | 00 | F1501 INDEXES

Number

Description

Document Cost Center (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	MCU	Business Unit	Ascending
3	UNIT	Unit	Ascending

Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

Alternate Payee

Element	Alias	Description	Sequence
1	AN8J	Address Number - Alternate Payee	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

72 COLUMNS | 3 INDEXES | 812 | 00 | F1501 TABLE

TOP 812 | 00 | F1501 COLUMNS

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

72 COLUMNS | 3 INDEXES | 812 | 00 | F1501 TABLE

TOP812 | 00 | F1501 COLUMNS

TOP812 | 00 | F1501 INDEXES

TOP 812 | 00 | F1501 COLUMNS

TOP 812 | 00 | F1501 INDEXES