	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

89 COLUMNS | 6 INDEXES | 812 | 15 | F15013B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Property Management
1	812	F15013B	NO	89	6	Sales Overage Master File	Secondary Master 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 NODOCO, NOSUSP, NOVRSC, NOBCI3, NOSUDT, NOEFTE, NOEFTB, NOLSVR, NOMCU, NOUNIT, NOSTNR, NOYEOV, NOBCI, NOAN8J, NOBLFC, NODCTO, NOAN8, NOMCUS, NOBLMR, NOCMPM, NOPROL, NOFYMO, NOFYDY, NORPFC, NORFDY, NORADY, NORYEM, NOFYR, NOBGPN, NOATDT, NOBLGR, NOULI, NOULI2, NOUSEA, NOTRAR, NOBKPT, NOIBOE, NOCENTYR, NOGLC, NODEAL, NOCRCD, NOTXA1, NOEXR1, NORM11, NORM12, NORM21, NORM22, NORM23, NORF01, NORF02, NORF03, NORF04, NORF05, NORF06, NORF07, NORF08, NORF09, NORF10, NORF11, NORF12, NORF13, NOBF01, NOBF02, NOBF03, NOBF04, NOBF05, NOBF06, NOBF07, NOBF08, NOBF09, NOBF10, NOBF11, NOBF12, NOBF13, NOURCD, NOURDT, NOURAT, NOURAB, NOURRF, NOUSER, NOPID, NOUPMJ, NOUPMT, NOJOBN, NOENTJ, NOTORG, NOCRR, NOCRRM, NOLDUE FROM F15013B

TOP 812 | 15 | F15013B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	NODOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	NOSUSP	Suspend Code	Character	UDC (15 SU)	1	0	Allow NULL?
3	NOVRSC	Version Suspend Code	Character	Generic Edit	1	0	Allow NULL?
4	NOBCI3	Billing Control ID - Third	Numeric	Generic Edit	8	0	Allow NULL?
5	NOSUDT	Date - Suspended	Date	Generic Edit	6	0
6	NOEFTE	Date - Ending Effective	Date	Generic Edit	6	0
7	NOEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
8	NOLSVR	Lease Version	Numeric	Generic Edit	6	0	Allow NULL?
9	NOMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
10	NOUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
11	NOSTNR	Store Number	String	Generic Edit	10	0	Allow NULL?
12	NOYEOV	Year End Override Code	Character	Generic Edit	1	0	Allow NULL?
13	NOBCI	Billing Control ID	Numeric	Generic Edit	8	0	Allow NULL?
14	NOAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
15	NOBLFC	Billing Frequency Code	Character	UDC	1	0	Allow NULL?
16	NODCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
17	NOAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
18	NOMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
19	NOBLMR	Manual Review Required	Character	UDC	1	0	Allow NULL?
20	NOCMPM	Computation Method	Character	UDC (15 CO)	1	0	Allow NULL?
21	NOPROL	Percentage Rent Only	Character	Generic Edit	1	0	Allow NULL?
22	NOFYMO	End FY Month	Numeric	Generic Edit	2	0	Allow NULL?
23	NOFYDY	End FY Day	Numeric	Generic Edit	2	0	Allow NULL?
24	NORPFC	Sales Report Frequency Code	Character	UDC	1	0	Allow NULL?
25	NORFDY	Report Due Days	Numeric	Generic Edit	3	0	Allow NULL?
26	NORADY	Annual Report Due Days	Numeric	Generic Edit	3	0	Allow NULL?
27	NORYEM	Sales Report Year End Month	Numeric	Generic Edit	2	0	Allow NULL?
28	NOFYR	Fiscal Year	Numeric	Generic Edit	4	0	Allow NULL?
29	NOBGPN	Period Number - Beginning	Numeric	Generic Edit	2	0	Allow NULL?
30	NOATDT	Date - Audit Date	Date	Generic Edit	6	0
31	NOBLGR	Billing Group	String	Generic Edit	12	0	Allow NULL?
32	NOULI	ULI Code	String	UDC (15 UL)	8	0	Allow NULL?
33	NOULI2	Tenant Sales Category	String	UDC (15 UL)	8	0	Allow NULL?
34	NOUSEA	Units - Usable Area (Sq. Ft.)	Numeric	Generic Edit	15	2	Allow NULL?
35	NOTRAR	Payment Terms - A/R	String	Generic Edit	3	0	Allow NULL?
36	NOBKPT	Dollar Breakpoint	Numeric	Generic Edit	15	2	Allow NULL?
37	NOIBOE	Invoice Based on Estimates	Character	Generic Edit	1	0	Allow NULL?
38	NOCENTYR	Century/Year	Numeric	Generic Edit	4	0	Allow NULL?
39	NOGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
40	NODEAL	Deal Number	String	Generic Edit	8	0	Allow NULL?
41	NOCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
42	NOTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
43	NOEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
44	NORM11	Reporting Code - Property Management 11	String	UDC (15 11)	4	0	Allow NULL?
45	NORM12	Reporting Code - Property Management 12	String	UDC (15 12)	4	0	Allow NULL?
46	NORM21	Reporting Code - Property Management 21	String	UDC (15 21)	4	0	Allow NULL?
47	NORM22	Reporting Code - Property Management 22	String	UDC (15 22)	4	0	Allow NULL?
48	NORM23	Reporting Code - Property Management 23	String	UDC (15 23)	4	0	Allow NULL?
49	NORF01	Report Period 01	Character	Generic Edit	1	0	Allow NULL?
50	NORF02	Report Period 02	Character	Generic Edit	1	0	Allow NULL?
51	NORF03	Report Period 03	Character	Generic Edit	1	0	Allow NULL?
52	NORF04	Report Period 04	Character	Generic Edit	1	0	Allow NULL?
53	NORF05	Report Period 05	Character	Generic Edit	1	0	Allow NULL?
54	NORF06	Report Period 06	Character	Generic Edit	1	0	Allow NULL?
55	NORF07	Report Period 07	Character	Generic Edit	1	0	Allow NULL?
56	NORF08	Report Period 08	Character	Generic Edit	1	0	Allow NULL?
57	NORF09	Report Period 09	Character	Generic Edit	1	0	Allow NULL?
58	NORF10	Report Period 10	Character	Generic Edit	1	0	Allow NULL?
59	NORF11	Report Period 11	Character	Generic Edit	1	0	Allow NULL?
60	NORF12	Report Period 12	Character	Generic Edit	1	0	Allow NULL?
61	NORF13	Report Period 13	Character	Generic Edit	1	0	Allow NULL?
62	NOBF01	Billing Period 01	Character	Generic Edit	1	0	Allow NULL?
63	NOBF02	Billing Period 02	Character	Generic Edit	1	0	Allow NULL?
64	NOBF03	Billing Period 03	Character	Generic Edit	1	0	Allow NULL?
65	NOBF04	Billing Period 04	Character	Generic Edit	1	0	Allow NULL?
66	NOBF05	Billing Period 05	Character	Generic Edit	1	0	Allow NULL?
67	NOBF06	Billing Period 06	Character	Generic Edit	1	0	Allow NULL?
68	NOBF07	Billing Period 07	Character	Generic Edit	1	0	Allow NULL?
69	NOBF08	Billing Period 08	Character	Generic Edit	1	0	Allow NULL?
70	NOBF09	Billing Period 09	Character	Generic Edit	1	0	Allow NULL?
71	NOBF10	Billing Period 10	Character	Generic Edit	1	0	Allow NULL?
72	NOBF11	Billing Period 11	Character	Generic Edit	1	0	Allow NULL?
73	NOBF12	Billing Period 12	Character	Generic Edit	1	0	Allow NULL?
74	NOBF13	Billing Period 13	Character	Generic Edit	1	0	Allow NULL?
75	NOURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
76	NOURDT	User Reserved Date	Date	Generic Edit	6	0
77	NOURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
78	NOURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
79	NOURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
80	NOUSER	User ID	String	Generic Edit	10	0	Allow NULL?
81	NOPID	Program ID	String	Generic Edit	10	0	Allow NULL?
82	NOUPMJ	Date - Updated	Date	Generic Edit	6	0
83	NOUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
84	NOJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
85	NOENTJ	Date - Entered	Date	Generic Edit	6	0
86	NOTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
87	NOCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
88	NOCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
89	NOLDUE	Lease Percentage Due	Numeric	Generic Edit	5	0	Allow NULL?

TOP 812 | 15 | F15013B INDEXES

Number

Description

LeaseNo YE Override + (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	YEOV	Year End Override Code	Ascending
3	LSVR	Lease Version	Ascending

Billing Frequency

Element	Alias	Description	Sequence
1	BLFC	Billing Frequency Code	Ascending

LeaseNo BillingControlId

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

LeaseNo LeaseVersion +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	LSVR	Lease Version	Ascending

Lease Version BCI

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

Sales Reporting Frequency

Element	Alias	Description	Sequence
1	RPFC	Sales Report Frequency Code	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

89 COLUMNS | 6 INDEXES | 812 | 15 | F15013B TABLE

TOP 812 | 15 | F15013B COLUMNS

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

89 COLUMNS | 6 INDEXES | 812 | 15 | F15013B TABLE

TOP812 | 15 | F15013B COLUMNS

TOP812 | 15 | F15013B INDEXES

TOP 812 | 15 | F15013B COLUMNS

TOP 812 | 15 | F15013B INDEXES