	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

147 COLUMNS | 15 INDEXES | 920 | 04 | F0411 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
04: Accounts Payable
1	920	F0411	RP	147	15	Accounts Payable Ledger	Transaction Files	04: Accounts Payable	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 RPKCO, RPDOC, RPDCT, RPSFX, RPSFXE, RPDCTA, RPAN8, RPPYE, RPSNTO, RPDIVJ, RPDSVJ, RPDDJ, RPDDNJ, RPDGJ, RPFY, RPCTRY, RPPN, RPCO, RPICU, RPICUT, RPDICJ, RPBALJ, RPPST, RPAG, RPAAP, RPADSC, RPADSA, RPATXA, RPATXN, RPSTAM, RPTXA1, RPEXR1, RPCRRM, RPCRCD, RPCRR, RPACR, RPFAP, RPCDS, RPCDSA, RPCTXA, RPCTXN, RPCTAM, RPGLC, RPGLBA, RPPOST, RPAM, RPAID2, RPMCU, RPOBJ, RPSUB, RPSBLT, RPSBL, RPBAID, RPPTC, RPVOD, RPOKCO, RPODCT, RPODOC, RPOSFX, RPCRC, RPVINV, RPPKCO, RPPO, RPPDCT, RPLNID, RPSFXO, RPOPSQ, RPVR01, RPUNIT, RPMCU2, RPRMK, RPRF, RPDRF, RPCTL, RPFNLP, RPU, RPUM, RPPYIN, RPTXA3, RPEXR3, RPRP1, RPRP2, RPRP3, RPAC07, RPTNN, RPDMCD, RPITM, RPHCRR, RPHDGJ, RPURC1, RPURDT, RPURAT, RPURAB, RPURRF, RPTORG, RPUSER, RPPID, RPUPMJ, RPUPMT, RPJOBN, RPTNST, RPYC01, RPYC02, RPYC03, RPYC04, RPYC05, RPYC06, RPYC07, RPYC08, RPYC09, RPYC10, RPDTXS, RPBCRC, RPATAD, RPCTAD, RPNRTA, RPFNRT, RPTAXP, RPPRGF, RPGFL5, RPGFL6, RPGAM1, RPGAM2, RPGEN4, RPGEN5, RPWTAD, RPWTAF, RPSMMF, RPPYWP, RPPWPG, RPNETTCID, RPNETDOC, RPNETRC5, RPNETST, RPCNTRTID, RPCNTRTCD, RPWVID, RPBLSCD2, RPHARPER, RPHARSFX, RPDDRL, RPSEQN, RPCLASS01, RPCLASS02, RPCLASS03, RPCLASS04, RPCLASS05 FROM F0411

TOP 920 | 04 | F0411 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RPKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
2	RPDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	RPDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
4	RPSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
5	RPSFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0	Allow NULL?
6	RPDCTA	Document Type - Adjusting	String	UDC (00 DT)	2	0	Allow NULL?
7	RPAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
8	RPPYE	Payee Address Number	Numeric	Generic Edit	8	0	Allow NULL?
9	RPSNTO	Address Number - Approver	Numeric	Generic Edit	8	0	Allow NULL?
10	RPDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
11	RPDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
12	RPDDJ	Date - Net Due	Date	Generic Edit	6	0
13	RPDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
14	RPDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
15	RPFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
16	RPCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
17	RPPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
18	RPCO	Company	String	Generic Edit	5	0	Allow NULL?
19	RPICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
20	RPICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
21	RPDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
22	RPBALJ	Balanced - Journal Entries	Character	UDC (H00 BB)	1	0	Allow NULL?
23	RPPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
24	RPAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
25	RPAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
26	RPADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
27	RPADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
28	RPATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
29	RPATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
30	RPSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
31	RPTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
32	RPEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
33	RPCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
34	RPCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
35	RPCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
36	RPACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
37	RPFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
38	RPCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
39	RPCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
40	RPCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
41	RPCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
42	RPCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
43	RPGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
44	RPGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
45	RPPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
46	RPAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
47	RPAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
48	RPMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
49	RPOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
50	RPSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
51	RPSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
52	RPSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
53	RPBAID	Bank Transit Short ID	String	Generic Edit	8	0	Allow NULL?
54	RPPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
55	RPVOD	Void Flag	Character	Generic Edit	1	0	Allow NULL?
56	RPOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
57	RPODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
58	RPODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
59	RPOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
60	RPCRC	Payment Handling Code	String	UDC (00 HC)	3	0	Allow NULL?
61	RPVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
62	RPPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
63	RPPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
64	RPPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
65	RPLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
66	RPSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
67	RPOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
68	RPVR01	Reference	String	Generic Edit	25	0	Allow NULL?
69	RPUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
70	RPMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
71	RPRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
72	RPRF	Frequency - Recurring	String	UDC (H00 RF)	2	0	Allow NULL?
73	RPDRF	Recurring Frequency # of Payments	Numeric	Generic Edit	3	0	Allow NULL?
74	RPCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
75	RPFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
76	RPU	Units	Numeric	Generic Edit	15	2	Allow NULL?
77	RPUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
78	RPPYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
79	RPTXA3	Tax Rate/Area 3 - Withholding	String	Generic Edit	10	0	Allow NULL?
80	RPEXR3	Tax Expl Code 3 - Withholding	String	UDC (00 EX)	2	0	Allow NULL?
81	RPRP1	A/R - A/P - Miscellaneous Code 1	Character	Generic Edit	1	0	Allow NULL?
82	RPRP2	A/R - A/P - Miscellaneous Code 2	Character	Generic Edit	1	0	Allow NULL?
83	RPRP3	A/R - A/P - Cash Rcpts/Inv Reg Code	Character	Generic Edit	1	0	Allow NULL?
84	RPAC07	Category Code - Address Book 07	String	UDC (01 07)	3	0	Allow NULL?
85	RPTNN	Flag for 1099	Character	Generic Edit	1	0	Allow NULL?
86	RPDMCD	Domestic Entry w/Mult Currency Distr	Character	Generic Edit	1	0	Allow NULL?
87	RPITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
88	RPHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
89	RPHDGJ	Historical Date - Julian	Date	Generic Edit	6	0
90	RPURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
91	RPURDT	User Reserved Date	Date	Generic Edit	6	0
92	RPURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
93	RPURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
94	RPURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
95	RPTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
96	RPUSER	User ID	String	Generic Edit	10	0	Allow NULL?
97	RPPID	Program ID	String	Generic Edit	10	0	Allow NULL?
98	RPUPMJ	Date - Updated	Date	Generic Edit	6	0
99	RPUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
100	RPJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
101	RPTNST	Transit Number - Bank	String	Generic Edit	20	0	Allow NULL?
102	RPYC01	Category Code - A/P Ledger 01	String	UDC (01 01)	3	0	Allow NULL?
103	RPYC02	Category Code - A/P Ledger 02	String	UDC (01 02)	3	0	Allow NULL?
104	RPYC03	Category Code - A/P Ledger 03	String	UDC (01 03)	3	0	Allow NULL?
105	RPYC04	Category Code - A/P Ledger 04	String	UDC (01 04)	3	0	Allow NULL?
106	RPYC05	Category Code - A/P Ledger 05	String	UDC (01 05)	3	0	Allow NULL?
107	RPYC06	Category Code - A/P Ledger 06	String	UDC (01 06)	3	0	Allow NULL?
108	RPYC07	Category Code - A/P Ledger 07	String	UDC (01 07)	3	0	Allow NULL?
109	RPYC08	Category Code - A/P Ledger 08	String	UDC (01 08)	3	0	Allow NULL?
110	RPYC09	Category Code - A/P Ledger 09	String	UDC (01 09)	3	0	Allow NULL?
111	RPYC10	Category Code - A/P Ledger 10	String	UDC (01 10)	3	0	Allow NULL?
112	RPDTXS	Deferred Tax Status - VAT	Character	Generic Edit	1	0	Allow NULL?
113	RPBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
114	RPATAD	Amount - To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
115	RPCTAD	Amount - Currency To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
116	RPNRTA	Non-Recoverable Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
117	RPFNRT	Foreign Non-Recoverable Tax	Numeric	Generic Edit	15	2	Allow NULL?
118	RPTAXP	Purchasing Taxable Y/N	Character	Generic Edit	1	0	Allow NULL?
119	RPPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
120	RPGFL5	Generic Flag 5	Character	Generic Edit	1	0	Allow NULL?
121	RPGFL6	Generic Flag 6	Character	Generic Edit	1	0	Allow NULL?
122	RPGAM1	Generic Amount 1	Numeric	Generic Edit	15	2	Allow NULL?
123	RPGAM2	Generic Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
124	RPGEN4	Generic String 4	String	Generic Edit	25	0	Allow NULL?
125	RPGEN5	Generic String 5	String	Generic Edit	25	0	Allow NULL?
126	RPWTAD	Future - Withholding Tax Amount Domestic	Numeric	Generic Edit	15	2	Allow NULL?
127	RPWTAF	Future - Withholding Tax Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
128	RPSMMF	Summarized Flag	Character	Generic Edit	1	0	Allow NULL?
129	RPPYWP	Pay When Paid	Character	Generic Edit	1	0	Allow NULL?
130	RPPWPG	Pay When Paid Group Number	Numeric	Generic Edit	15	0	Allow NULL?
131	RPNETTCID	Netting Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
132	RPNETDOC	Netting Document Number	Numeric	Generic Edit	15	0	Allow NULL?
133	RPNETRC5	Netting Line ID	Numeric	Generic Edit	6	0	Allow NULL?
134	RPNETST	Netting Status Code	Character	UDC (00 NS)	1	0	Allow NULL?
135	RPCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
136	RPCNTRTCD	Contract Code	String	Generic Edit	12	0	Allow NULL?
137	RPWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
138	RPBLSCD2	Block Code	String	Generic Edit	10	0	Allow NULL?
139	RPHARPER	Harvest Period	String	Generic Edit	6	0	Allow NULL?
140	RPHARSFX	Harvest Suffix	String	Generic Edit	10	0	Allow NULL?
141	RPDDRL	Due Date Rule	String	Generic Edit	5	0	Allow NULL?
142	RPSEQN	Sequence Number	Numeric	Generic Edit	7	0	Allow NULL?
143	RPCLASS01	Classification Code 01	String	UDC (01 CA)	3	0	Allow NULL?
144	RPCLASS02	Classification Code 02	String	UDC (01 CB)	3	0	Allow NULL?
145	RPCLASS03	Classification Code 03	String	UDC (01 CC)	3	0	Allow NULL?
146	RPCLASS04	Classification Code 04	String	UDC (01 CD)	3	0	Allow NULL?
147	RPCLASS05	Classification Code 05	String	UDC (01 CE)	3	0	Allow NULL?

TOP 920 | 04 | F0411 INDEXES

Number

Description

Document Type + A (Primary/Unique)

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending
4	SFX	Document Pay Item	Ascending
5	SFXE	Pay Item Extension Number	Ascending

Document Type + B

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

Batch Type Number + A

Element	Alias	Description	Sequence
1	ICUT	Batch Type	Ascending
2	ICU	Batch Number	Ascending
3	KCO	Document Company	Ascending
4	DCT	Document Type	Ascending
5	DOC	Document (Voucher Invoice etc.)	Ascending
6	CO	Company	Ascending
7	GLC	G/L Offset	Ascending

Batch Type Number + B

Element	Alias	Description	Sequence
1	ICUT	Batch Type	Ascending
2	ICU	Batch Number	Ascending
3	CO	Company	Ascending
4	GLC	G/L Offset	Ascending
5	PN	Period Number - General Ledger	Ascending
6	FY	Fiscal Year	Ascending
7	CTRY	Century	Ascending

Batch Type Number +C

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	ICUT	Batch Type	Ascending
3	POST	G/L Posted Code	Ascending

Supplier Invoice Number +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	VINV	Supplier Invoice Number	Ascending
3	DIVJ	Date - Invoice - Julian	Descending

Address Number Due Date +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DDJ	Date - Net Due	Ascending
3	DCT	Document Type	Ascending
4	DOC	Document (Voucher Invoice etc.)	Ascending
5	KCO	Document Company	Ascending
6	SFX	Document Pay Item	Ascending
7	SFXE	Pay Item Extension Number	Ascending

Address Num Doc Type +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DCT	Document Type	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	KCO	Document Company	Ascending
5	SFX	Document Pay Item	Ascending
6	SFXE	Pay Item Extension Number	Ascending

Address Num PO +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PO	Purchase Order	Ascending
3	PDCT	Document Type - Purchase Order	Ascending
4	PKCO	Document Company (Purchase Order)	Ascending
5	DOC	Document (Voucher Invoice etc.)	Ascending
6	DCT	Document Type	Ascending
7	KCO	Document Company	Ascending

Sent to Suplier +A

Element	Alias	Description	Sequence
1	SNTO	Address Number - Approver	Ascending
2	AN8	Address Number	Ascending
3	DDJ	Date - Net Due	Descending

PayeeNumber Doc Type +A

Element	Alias	Description	Sequence
1	PYE	Payee Address Number	Ascending
2	DCT	Document Type	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	KCO	Document Company	Ascending
5	SFX	Document Pay Item	Ascending
6	SFXE	Pay Item Extension Number	Ascending

PWP No Address Num +A

Element	Alias	Description	Sequence
1	PWPG	Pay When Paid Group Number	Ascending
2	AN8	Address Number	Ascending
3	PST	Pay Status Code	Ascending

NetTId NetDoc +A

Element	Alias	Description	Sequence
1	NETTCID	Netting Transaction ID	Ascending
2	NETDOC	Netting Document Number	Ascending
3	NETRC5	Netting Line ID	Ascending

NetTId NetDoc +B

Element	Alias	Description	Sequence
1	NETTCID	Netting Transaction ID	Ascending
2	NETDOC	Netting Document Number	Ascending
3	NETRC5	Netting Line ID	Ascending
4	VOD	Void Flag	Ascending

Contract Harvest +A

Element	Alias	Description	Sequence
1	CNTRTID	Contract ID	Ascending
2	WVID	Vessel ID	Ascending
3	PYE	Payee Address Number	Ascending
4	SEQN	Sequence Number	Ascending
5	RP1	A/R - A/P - Miscellaneous Code 1	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

147 COLUMNS | 15 INDEXES | 920 | 04 | F0411 TABLE

TOP 920 | 04 | F0411 COLUMNS

TOP 920 | 04 | F0411 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

147 COLUMNS | 15 INDEXES | 920 | 04 | F0411 TABLE

TOP920 | 04 | F0411 COLUMNS

TOP920 | 04 | F0411 INDEXES

TOP 920 | 04 | F0411 COLUMNS

TOP 920 | 04 | F0411 INDEXES