	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

95 COLUMNS | 12 INDEXES | 920 | 15 | F1511B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Real Estate Management
1	920	F1511B	NJ	95	12	Lease Billings Master	Transaction 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 NJGENT, NJICU, NJDOC, NJSFX, NJDOCO, NJDCTO, NJSOSQ, NJMCUS, NJAN8, NJAN8J, NJDL01, NJMCU, NJOBJ, NJSUB, NJSBL, NJAID, NJCO, NJDG, NJDSV, NJGLC, NJBPN, NJYR, NJAG, NJAN01, NJDI, NJDD, NJPTC, NJTRAN, NJSEPI, NJITMG, NJLNID, NJDIC, NJPDUE, NJEPCL, NJDPER, NJDPAR, NJEXCD, NJBCI, NJPRDC, NJYRO, NJCTRY, NJRPRD, NJCRCD, NJCRR, NJACR, NJTXA1, NJEXR1, NJSTAM, NJATXN, NJATXA, NJSBLT, NJCRRM, NJFAP, NJCDS, NJCDSA, NJCTAM, NJCTXA, NJCTXN, NJMI, NJDBAN, NJUNIT, NJBLMR, NJEFFC, NJSOBT, NJSBJR, NJICB1, NJICB2, NJICB3, NJICB4, NJICB5, NJINVP, NJPRRB, NJBCIR, NJICBC, NJPOST, NJSOTY, NJADSC, NJODOC, NJODCT, NJOSFX, NJKCO, NJOKCO, NJLSVR, NJBCI3, NJVINV, NJURCD, NJURDT, NJURAT, NJURAB, NJURRF, NJUSER, NJPID, NJUPMJ, NJUPMT, NJJOBN FROM F1511B

TOP 920 | 15 | F1511B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	NJGENT	Generation Type	Character	UDC (15 GE)	1	0	Allow NULL?
2	NJICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
3	NJDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
4	NJSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
5	NJDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
6	NJDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
7	NJSOSQ	Sequence Number	Numeric	Generic Edit	3	0	Allow NULL?
8	NJMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
9	NJAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
10	NJAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
11	NJDL01	Description	String	Generic Edit	30	0	Allow NULL?
12	NJMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
13	NJOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
14	NJSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
15	NJSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
16	NJAID	Account ID	String	Generic Edit	8	0	Allow NULL?
17	NJCO	Company	String	Generic Edit	5	0	Allow NULL?
18	NJDG	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
19	NJDSV	Date - Service/Tax	Date	Generic Edit	6	0
20	NJGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
21	NJBPN	Period Number - Billing	Numeric	Generic Edit	2	0	Allow NULL?
22	NJYR	Year - Calendar Year	Numeric	Generic Edit	2	0	Allow NULL?
23	NJAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
24	NJAN01	Amount - Net Posting 01	Numeric	Generic Edit	15	2	Allow NULL?
25	NJDI	Date - Invoice	Date	Generic Edit	6	0
26	NJDD	Date - Net Due	Date	Generic Edit	6	0
27	NJPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
28	NJTRAN	Transaction Type	Character	UDC (15 TR)	1	0	Allow NULL?
29	NJSEPI	Separate Invoice Code	Character	Generic Edit	1	0	Allow NULL?
30	NJITMG	Item Grouping	String	Generic Edit	3	0	Allow NULL?
31	NJLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
32	NJDIC	Date - Batch	Date	Generic Edit	6	0
33	NJPDUE	Percentage Due on Sales	Numeric	Generic Edit	5	0	Allow NULL?
34	NJEPCL	Expense Participation Class	String	Generic Edit	4	0	Allow NULL?
35	NJDPER	Days in Accounting Period	Numeric	Generic Edit	3	0	Allow NULL?
36	NJDPAR	Days Participating	Numeric	Generic Edit	3	0	Allow NULL?
37	NJEXCD	Exclusion Code	Character	UDC	1	0	Allow NULL?
38	NJBCI	Billing Control ID	Numeric	Generic Edit	8	0	Allow NULL?
39	NJPRDC	Product Code	String	UDC (15 PC)	4	0	Allow NULL?
40	NJYRO	Year - Calendar Year	Numeric	Generic Edit	2	0	Allow NULL?
41	NJCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
42	NJRPRD	Sales Report Period	Numeric	Generic Edit	2	0	Allow NULL?
43	NJCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
44	NJCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
45	NJACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
46	NJTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
47	NJEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
48	NJSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
49	NJATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
50	NJATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
51	NJSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
52	NJCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
53	NJFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
54	NJCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
55	NJCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
56	NJCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
57	NJCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
58	NJCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
59	NJMI	Manual Input (Y/N)	Character	Generic Edit	1	0	Allow NULL?
60	NJDBAN	Doing Business As	Numeric	Generic Edit	8	0	Allow NULL?
61	NJUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
62	NJBLMR	Manual Review Required	Character	UDC	1	0	Allow NULL?
63	NJEFFC	Exclude From Future Calcs	Character	UDC	1	0	Allow NULL?
64	NJSOBT	S.O. Bill Type	String	UDC (15 CF)	2	0	Allow NULL?
65	NJSBJR	Subject to Minimum Rent	Character	Generic Edit	1	0	Allow NULL?
66	NJICB1	Invoice Control Break Field 1	String	Generic Edit	12	0	Allow NULL?
67	NJICB2	Invoice Control Break Field 2	String	Generic Edit	12	0	Allow NULL?
68	NJICB3	Invoice Control Break Field 3	String	Generic Edit	12	0	Allow NULL?
69	NJICB4	Invoice Control Break Field 4	String	Generic Edit	12	0	Allow NULL?
70	NJICB5	Invoice Control Break Field 5	String	Generic Edit	12	0	Allow NULL?
71	NJINVP	Invoice Print Code	Character	UDC	1	0	Allow NULL?
72	NJPRRB	Prorated Billing	Character	UDC	1	0	Allow NULL?
73	NJBCIR	Billing Control ID Reference	Numeric	Generic Edit	8	0	Allow NULL?
74	NJICBC	Invoice Control Break Code	String	UDC (15 IB)	2	0	Allow NULL?
75	NJPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
76	NJSOTY	S.O. Type Code	String	UDC (15 SP)	2	0	Allow NULL?
77	NJADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
78	NJODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
79	NJODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
80	NJOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
81	NJKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
82	NJOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
83	NJLSVR	Lease Version	Numeric	Generic Edit	6	0	Allow NULL?
84	NJBCI3	Billing Control ID - Third	Numeric	Generic Edit	8	0	Allow NULL?
85	NJVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
86	NJURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
87	NJURDT	User Reserved Date	Date	Generic Edit	6	0
88	NJURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
89	NJURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
90	NJURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
91	NJUSER	User ID	String	Generic Edit	10	0	Allow NULL?
92	NJPID	Program ID	String	Generic Edit	10	0	Allow NULL?
93	NJUPMJ	Date - Updated	Date	Generic Edit	6	0
94	NJUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
95	NJJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 15 | F1511B INDEXES

Number

Description

Generation Type Batch No. A (Primary/Unique)

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

Generation Type User +

Element	Alias	Description	Sequence
1	GENT	Generation Type	Ascending
2	USER	User ID	Ascending
3	DIC	Date - Batch	Ascending
4	ICU	Batch Number	Ascending

Generation Type Batch Date +

Element	Alias	Description	Sequence
1	GENT	Generation Type	Ascending
2	DIC	Date - Batch	Ascending
3	ICU	Batch Number	Ascending

Invoice No.

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending

Batch No. Lease No. A

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

Account ID

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending

Generation Type Batch No. B

Element	Alias	Description	Sequence
1	GENT	Generation Type	Ascending
2	ICU	Batch Number	Ascending
3	TRAN	Transaction Type	Ascending
4	DOC	Document (Voucher Invoice etc.)	Ascending
5	KCO	Document Company	Ascending

Lease No. Generation Type +

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	BCI	Billing Control ID	Ascending
7	LNID	Line Number	Ascending

Batch No. Lease No. B

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	GENT	Generation Type	Ascending
4	CTRY	Century	Ascending
5	YR	Year - Calendar Year	Ascending
6	BPN	Period Number - Billing	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

Invoice No. Document Co. +

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	KCO	Document Company	Ascending
3	GENT	Generation Type	Ascending

Lease No. Invoice No. +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	KCO	Document Company	Ascending
4	SFX	Document Pay Item	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

95 COLUMNS | 12 INDEXES | 920 | 15 | F1511B TABLE

TOP 920 | 15 | F1511B COLUMNS

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

95 COLUMNS | 12 INDEXES | 920 | 15 | F1511B TABLE

TOP920 | 15 | F1511B COLUMNS

TOP920 | 15 | F1511B INDEXES

TOP 920 | 15 | F1511B COLUMNS

TOP 920 | 15 | F1511B INDEXES