	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

93 COLUMNS | 6 INDEXES | 920 | 15 | F1511HB TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Real Estate Management
1	920	F1511HB	NC	93	6	Lease Billings History	History 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 NCGENT, NCICU, NCDOC, NCSFX, NCDOCO, NCDCTO, NCSOSQ, NCMCUS, NCAN8, NCAN8J, NCDL01, NCMCU, NCOBJ, NCSUB, NCSBL, NCAID, NCCO, NCDG, NCDSV, NCGLC, NCBPN, NCYR, NCAG, NCAN01, NCDI, NCDD, NCPTC, NCTRAN, NCSEPI, NCITMG, NCLNID, NCDIC, NCPDUE, NCEPCL, NCDPER, NCDPAR, NCEXCD, NCBCI, NCPRDC, NCYRO, NCCTRY, NCRPRD, NCCRCD, NCCRR, NCACR, NCTXA1, NCEXR1, NCSTAM, NCATXN, NCATXA, NCSBLT, NCCRRM, NCFAP, NCCDS, NCCDSA, NCCTAM, NCCTXA, NCCTXN, NCMI, NCDBAN, NCUNIT, NCBLMR, NCEFFC, NCSOBT, NCSBJR, NCICB1, NCICB2, NCICB3, NCICB4, NCICB5, NCINVP, NCPRRB, NCBCIR, NCICBC, NCIST, NCSOTY, NCODOC, NCODCT, NCOSFX, NCKCO, NCOKCO, NCLSVR, NCBCI3, NCURCD, NCURDT, NCURAT, NCURAB, NCURRF, NCUSER, NCPID, NCUPMJ, NCUPMT, NCJOBN FROM F1511HB

TOP 920 | 15 | F1511HB COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	NCGENT	Generation Type	Character	UDC (15 GE)	1	0	Allow NULL?
2	NCICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
3	NCDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
4	NCSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
5	NCDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
6	NCDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
7	NCSOSQ	Sequence Number	Numeric	Generic Edit	3	0	Allow NULL?
8	NCMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
9	NCAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
10	NCAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
11	NCDL01	Description	String	Generic Edit	30	0	Allow NULL?
12	NCMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
13	NCOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
14	NCSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
15	NCSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
16	NCAID	Account ID	String	Generic Edit	8	0	Allow NULL?
17	NCCO	Company	String	Generic Edit	5	0	Allow NULL?
18	NCDG	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
19	NCDSV	Date - Service/Tax	Date	Generic Edit	6	0
20	NCGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
21	NCBPN	Period Number - Billing	Numeric	Generic Edit	2	0	Allow NULL?
22	NCYR	Year - Calendar Year	Numeric	Generic Edit	2	0	Allow NULL?
23	NCAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
24	NCAN01	Amount - Net Posting 01	Numeric	Generic Edit	15	2	Allow NULL?
25	NCDI	Date - Invoice	Date	Generic Edit	6	0
26	NCDD	Date - Net Due	Date	Generic Edit	6	0
27	NCPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
28	NCTRAN	Transaction Type	Character	UDC (15 TR)	1	0	Allow NULL?
29	NCSEPI	Separate Invoice Code	Character	Generic Edit	1	0	Allow NULL?
30	NCITMG	Item Grouping	String	Generic Edit	3	0	Allow NULL?
31	NCLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
32	NCDIC	Date - Batch	Date	Generic Edit	6	0
33	NCPDUE	Percentage Due on Sales	Numeric	Generic Edit	5	0	Allow NULL?
34	NCEPCL	Expense Participation Class	String	Generic Edit	4	0	Allow NULL?
35	NCDPER	Days in Accounting Period	Numeric	Generic Edit	3	0	Allow NULL?
36	NCDPAR	Days Participating	Numeric	Generic Edit	3	0	Allow NULL?
37	NCEXCD	Exclusion Code	Character	UDC	1	0	Allow NULL?
38	NCBCI	Billing Control ID	Numeric	Generic Edit	8	0	Allow NULL?
39	NCPRDC	Product Code	String	UDC (15 PC)	4	0	Allow NULL?
40	NCYRO	Year - Calendar Year	Numeric	Generic Edit	2	0	Allow NULL?
41	NCCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
42	NCRPRD	Sales Report Period	Numeric	Generic Edit	2	0	Allow NULL?
43	NCCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
44	NCCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
45	NCACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
46	NCTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
47	NCEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
48	NCSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
49	NCATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
50	NCATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
51	NCSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
52	NCCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
53	NCFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
54	NCCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
55	NCCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
56	NCCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
57	NCCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
58	NCCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
59	NCMI	Manual Input (Y/N)	Character	Generic Edit	1	0	Allow NULL?
60	NCDBAN	Doing Business As	Numeric	Generic Edit	8	0	Allow NULL?
61	NCUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
62	NCBLMR	Manual Review Required	Character	UDC	1	0	Allow NULL?
63	NCEFFC	Exclude From Future Calcs	Character	UDC	1	0	Allow NULL?
64	NCSOBT	S.O. Bill Type	String	UDC (15 CF)	2	0	Allow NULL?
65	NCSBJR	Subject to Minimum Rent	Character	Generic Edit	1	0	Allow NULL?
66	NCICB1	Invoice Control Break Field 1	String	Generic Edit	12	0	Allow NULL?
67	NCICB2	Invoice Control Break Field 2	String	Generic Edit	12	0	Allow NULL?
68	NCICB3	Invoice Control Break Field 3	String	Generic Edit	12	0	Allow NULL?
69	NCICB4	Invoice Control Break Field 4	String	Generic Edit	12	0	Allow NULL?
70	NCICB5	Invoice Control Break Field 5	String	Generic Edit	12	0	Allow NULL?
71	NCINVP	Invoice Print Code	Character	UDC	1	0	Allow NULL?
72	NCPRRB	Prorated Billing	Character	UDC	1	0	Allow NULL?
73	NCBCIR	Billing Control ID Reference	Numeric	Generic Edit	8	0	Allow NULL?
74	NCICBC	Invoice Control Break Code	String	UDC (15 IB)	2	0	Allow NULL?
75	NCIST	Batch Status	Character	UDC (98 IC)	1	0	Allow NULL?
76	NCSOTY	S.O. Type Code	String	UDC (15 SP)	2	0	Allow NULL?
77	NCODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
78	NCODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
79	NCOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
80	NCKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
81	NCOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
82	NCLSVR	Lease Version	Numeric	Generic Edit	6	0	Allow NULL?
83	NCBCI3	Billing Control ID - Third	Numeric	Generic Edit	8	0	Allow NULL?
84	NCURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
85	NCURDT	User Reserved Date	Date	Generic Edit	6	0
86	NCURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
87	NCURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
88	NCURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
89	NCUSER	User ID	String	Generic Edit	10	0	Allow NULL?
90	NCPID	Program ID	String	Generic Edit	10	0	Allow NULL?
91	NCUPMJ	Date - Updated	Date	Generic Edit	6	0
92	NCUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
93	NCJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 15 | F1511HB INDEXES

Number

Description

Lease No. Gen Type + (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	GENT	Generation Type	Ascending
3	CTRY	Century	Ascending
4	YR	Year - Calendar Year	Ascending
5	BPN	Period Number - Billing	Ascending
6	SOBT	S.O. Bill Type	Ascending
7	ICU	Batch Number	Ascending
8	DOC	Document (Voucher Invoice etc.)	Ascending
9	KCO	Document Company	Ascending
10	SFX	Document Pay Item	Ascending

Lease No. Billing Ctl Ref

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

Batch No. Invoice No. +

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	KCO	Document Company	Ascending
4	SFX	Document Pay Item	Ascending

Orig Doc No. Orig Doc Co. +

Element	Alias	Description	Sequence
1	ODOC	Document - Original	Ascending
2	OKCO	Document Company (Original Order)	Ascending
3	ODCT	Document Type - Original	Ascending
4	OSFX	Document Pay Item - Original	Ascending

Lease No. Lease Version +

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

Lease No Billing Ctrl ID +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	BCI	Billing Control ID	Ascending
3	LSVR	Lease Version	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

93 COLUMNS | 6 INDEXES | 920 | 15 | F1511HB TABLE

TOP 920 | 15 | F1511HB COLUMNS

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

93 COLUMNS | 6 INDEXES | 920 | 15 | F1511HB TABLE

TOP920 | 15 | F1511HB COLUMNS

TOP920 | 15 | F1511HB INDEXES

TOP 920 | 15 | F1511HB COLUMNS

TOP 920 | 15 | F1511HB INDEXES