	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

97 COLUMNS | 8 INDEXES | 920 | 15 | F15012B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Real Estate Management
1	920	F15012B	NS	97	8	Tenant E.P. Class Master	Secondary Master 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 NSDOCO, NSLSVR, NSDCTO, NSEPCL, NSEPSG, NSDL01, NSDL02, NSFERT, NSEPOF, NSBSEX, NSEPGR, NSGRPL, NSBPS#, NSBPSY, NSBPSM, NSCPFC, NSGLC, NSBLGR, NSMCU, NSUNIT, NSDEAL, NSEFTB, NSEFTE, NSPCTP, NSBLFC, NSBF01, NSBF02, NSBF03, NSBF04, NSBF05, NSBF06, NSBF07, NSBF08, NSBF09, NSBF10, NSBF11, NSBF12, NSBF13, NSEPCD, NSECMP, NSEXCD, NSBRCD, NSBRAD, NSEPLM, NSCPLL, NSEPCP, NSCPCL, NSAN8J, NSTRAR, NSSEPI, NSITMG, NSSUSP, NSEPGI, NSVRSC, NSBLMN, NSBCI, NSCRCD, NSTXA1, NSEXR1, NSOCRL, NSOCPB, NSOCPE, NSFEBS, NSGPCT, NSCRRM, NSCTAM, NSCTXA, NSCTXN, NSBLMR, NSALCR, NSUNGR, NSBCI3, NSSUDT, NSURCD, NSURDT, NSURAT, NSURAB, NSURRF, NSUSER, NSPID, NSUPMJ, NSUPMT, NSJOBN, NSENTJ, NSTORG, NSTEXR, NSSFDN, NSEXCO, NSCRR, NSACR, NSBSEXG, NSBEXUOM, NSLTGRP, NSGLMD, NSCAPID, NSORDNUM, NSRMK FROM F15012B

TOP 920 | 15 | F15012B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	NSDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	NSLSVR	Lease Version	Numeric	Generic Edit	6	0	Allow NULL?
3	NSDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	NSEPCL	Expense Participation Class	String	Generic Edit	4	0	Allow NULL?
5	NSEPSG	Expense Participation Subgroup	String	Generic Edit	3	0	Allow NULL?
6	NSDL01	Description	String	Generic Edit	30	0	Allow NULL?
7	NSDL02	Description 02	String	Generic Edit	30	0	Allow NULL?
8	NSFERT	Fee Rate	Numeric	Generic Edit	15	6	Allow NULL?
9	NSEPOF	Occupancy Factor	Numeric	Generic Edit	15	0	Allow NULL?
10	NSBSEX	Base Exclusion Amount	Numeric	Generic Edit	15	2	Allow NULL?
11	NSEPGR	Expense Participation Group	String	Generic Edit	3	0	Allow NULL?
12	NSGRPL	Group Limit for E.P.	Numeric	Generic Edit	15	2	Allow NULL?
13	NSBPS#	Base Period Start - Century	Numeric	Generic Edit	2	0	Allow NULL?
14	NSBPSY	Base Period Start - Year	Numeric	Generic Edit	2	0	Allow NULL?
15	NSBPSM	Base Period Start - Month	Numeric	Generic Edit	2	0	Allow NULL?
16	NSCPFC	EP Annual Compound Factor	Numeric	Generic Edit	15	6	Allow NULL?
17	NSGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
18	NSBLGR	Billing Group	String	Generic Edit	12	0	Allow NULL?
19	NSMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
20	NSUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
21	NSDEAL	Deal Number	String	Generic Edit	8	0	Allow NULL?
22	NSEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
23	NSEFTE	Date - Ending Effective	Date	Generic Edit	6	0
24	NSPCTP	Percentage - Expense Participation	Numeric	Generic Edit	15	6	Allow NULL?
25	NSBLFC	Billing Frequency Code	Character	UDC	1	0	Allow NULL?
26	NSBF01	Billing Period 01	Character	Generic Edit	1	0	Allow NULL?
27	NSBF02	Billing Period 02	Character	Generic Edit	1	0	Allow NULL?
28	NSBF03	Billing Period 03	Character	Generic Edit	1	0	Allow NULL?
29	NSBF04	Billing Period 04	Character	Generic Edit	1	0	Allow NULL?
30	NSBF05	Billing Period 05	Character	Generic Edit	1	0	Allow NULL?
31	NSBF06	Billing Period 06	Character	Generic Edit	1	0	Allow NULL?
32	NSBF07	Billing Period 07	Character	Generic Edit	1	0	Allow NULL?
33	NSBF08	Billing Period 08	Character	Generic Edit	1	0	Allow NULL?
34	NSBF09	Billing Period 09	Character	Generic Edit	1	0	Allow NULL?
35	NSBF10	Billing Period 10	Character	Generic Edit	1	0	Allow NULL?
36	NSBF11	Billing Period 11	Character	Generic Edit	1	0	Allow NULL?
37	NSBF12	Billing Period 12	Character	Generic Edit	1	0	Allow NULL?
38	NSBF13	Billing Period 13	Character	Generic Edit	1	0	Allow NULL?
39	NSEPCD	Expense Participation Code	String	UDC (15 EP)	2	0	Allow NULL?
40	NSECMP	Computation Method	Character	Generic Edit	1	0	Allow NULL?
41	NSEXCD	Exclusion Code	Character	UDC	1	0	Allow NULL?
42	NSBRCD	Billing Receipt Code	String	Generic Edit	4	0	Allow NULL?
43	NSBRAD	Billing Receipt Code-Admin Fee	String	Generic Edit	4	0	Allow NULL?
44	NSEPLM	EP Tenant Share Limit	Numeric	Generic Edit	15	2	Allow NULL?
45	NSCPLL	EP Lease Limit Compound Factor	Numeric	Generic Edit	15	6	Allow NULL?
46	NSEPCP	EP - Class Expense Limit	Numeric	Generic Edit	15	2	Allow NULL?
47	NSCPCL	EP Class Limit Compound Factor	Numeric	Generic Edit	15	6	Allow NULL?
48	NSAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
49	NSTRAR	Payment Terms - A/R	String	Generic Edit	3	0	Allow NULL?
50	NSSEPI	Separate Invoice Code	Character	Generic Edit	1	0	Allow NULL?
51	NSITMG	Item Grouping	String	Generic Edit	3	0	Allow NULL?
52	NSSUSP	Suspend Code	Character	UDC (15 SU)	1	0	Allow NULL?
53	NSEPGI	EP Group Indicator	Character	Generic Edit	1	0	Allow NULL?
54	NSVRSC	Version Suspend Code	Character	Generic Edit	1	0	Allow NULL?
55	NSBLMN	Bill Manually	Character	UDC	1	0	Allow NULL?
56	NSBCI	Billing Control ID	Numeric	Generic Edit	8	0	Allow NULL?
57	NSCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
58	NSTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
59	NSEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
60	NSOCRL	EP Occupancy Rule	Character	UDC (15 OC)	1	0	Allow NULL?
61	NSOCPB	Occupancy Date From	Date	Generic Edit	6	0
62	NSOCPE	Occupancy Date To	Date	Generic Edit	6	0
63	NSFEBS	Fee Basis	Character	UDC (15 FB)	1	0	Allow NULL?
64	NSGPCT	Percentage Gross-Up E.P.	Numeric	Generic Edit	15	6	Allow NULL?
65	NSCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
66	NSCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
67	NSCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
68	NSCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
69	NSBLMR	Manual Review Required	Character	UDC	1	0	Allow NULL?
70	NSALCR	Allow Credit (Y/N)	Character	Generic Edit	1	0	Allow NULL?
71	NSUNGR	Unit Group Code	Character	Generic Edit	1	0	Allow NULL?
72	NSBCI3	Billing Control ID - Third	Numeric	Generic Edit	8	0	Allow NULL?
73	NSSUDT	Date - Suspended	Date	Generic Edit	6	0
74	NSURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
75	NSURDT	User Reserved Date	Date	Generic Edit	6	0
76	NSURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
77	NSURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
78	NSURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
79	NSUSER	User ID	String	Generic Edit	10	0	Allow NULL?
80	NSPID	Program ID	String	Generic Edit	10	0	Allow NULL?
81	NSUPMJ	Date - Updated	Date	Generic Edit	6	0
82	NSUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
83	NSJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
84	NSENTJ	Date - Entered	Date	Generic Edit	6	0
85	NSTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
86	NSTEXR	EP Tenant Exclusion Rule	String	Generic Edit	10	0	Allow NULL?
87	NSSFDN	Share Factor Denominator ID	String	Generic Edit	10	0	Allow NULL?
88	NSEXCO	Exclusion Amount Override	Numeric	Generic Edit	15	2	Allow NULL?
89	NSCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
90	NSACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
91	NSBSEXG	Base Exclusion Group	String	Generic Edit	10	0	Allow NULL?
92	NSBEXUOM	Base Year Exclusion Per Square Foot	Numeric	Generic Edit	15	2	Allow NULL?
93	NSLTGRP	Ledger Type Group	String	Generic Edit	15	0	Allow NULL?
94	NSGLMD	Area Calculation Method	Character	UDC (15 OM)	1	0	Allow NULL?
95	NSCAPID	Cap Rule ID	String	Generic Edit	10	0	Allow NULL?
96	NSORDNUM	Order of Processing Number	Numeric	Generic Edit	8	0	Allow NULL?
97	NSRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?

TOP 920 | 15 | F15012B INDEXES

Number

Description

Lease Version A (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	LSVR	Lease Version	Ascending
3	BCI	Billing Control ID	Ascending

Business Unit

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

Billing Frequency Code

Element	Alias	Description	Sequence
1	BLFC	Billing Frequency Code	Ascending

Lease Building Unit

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

Lease Billing Ctl ID

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	BCI	Billing Control ID	Ascending

Lease Version B

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	LSVR	Lease Version	Ascending
3	EPCL	Expense Participation Class	Ascending
4	EPGR	Expense Participation Group	Ascending
5	EPSG	Expense Participation Subgroup	Ascending
6	ECMP	Computation Method	Ascending

Building Unit Share Factor D

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	UNIT	Unit	Ascending
3	SFDN	Share Factor Denominator ID	Ascending
4	ECMP	Computation Method	Ascending
5	GLMD	Area Calculation Method	Ascending

Building Comp Method

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ECMP	Computation Method	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

97 COLUMNS | 8 INDEXES | 920 | 15 | F15012B TABLE

TOP 920 | 15 | F15012B COLUMNS

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

97 COLUMNS | 8 INDEXES | 920 | 15 | F15012B TABLE

TOP920 | 15 | F15012B COLUMNS

TOP920 | 15 | F15012B INDEXES

TOP 920 | 15 | F15012B COLUMNS

TOP 920 | 15 | F15012B INDEXES