	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

144 COLUMNS | 1 INDEXES | 812 | 03B | F03B575 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	812	F03B575	RD	144	1	Auto Debit Invoice Select and Build	Transaction Files	03B: Enhanced Accounts Receivable	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 RDADCN, RDCKNU, RDRC, RDDOC, RDDCT, RDKCO, RDSFX, RDAN8, RDDGJ, RDDIVJ, RDICUT, RDICU, RDDICJ, RDFY, RDCTRY, RDPN, RDCO, RDGLC, RDAID, RDPA8, RDAN8J, RDPYR, RDPOST, RDISTR, RDBALJ, RDPST, RDAG, RDAAP, RDADSC, RDADSA, RDATXA, RDATXN, RDSTAM, RDBCRC, RDCRRM, RDCRCD, RDCRR, RDCRR1, RDCRR2, RDCRCM, RDTCRC, RDTAAP, RDTADA, RDDMCD, RDACR, RDFAP, RDCDS, RDCDSA, RDCTXA, RDCTXN, RDCTAM, RDTXA1, RDEXR1, RDDSVJ, RDGLBA, RDAM, RDAID2, RDAM2, RDMCU, RDOBJ, RDSUB, RDSBLT, RDSBL, RDPTC, RDDDJ, RDDDNJ, RDRDDJ, RDRDSJ, RDLFCJ, RDSMTJ, RDNBRR, RDRDRL, RDRMDS, RDCOLL, RDCORC, RDAFC, RDDNLT, RDRSCO, RDODOC, RDODCT, RDOKCO, RDOSFX, RDVINV, RDPO, RDPDCT, RDPKCO, RDDCTO, RDLNID, RDSDOC, RDSDCT, RDSKCO, RDSFXO, RDVLDT, RDCMC1, RDVR01, RDUNIT, RDMCU2, RDRMK, RDALPH, RDRF, RDDRF, RDCTL, RDFNLP, RDITM, RDU, RDUM, RDALT6, RDRYIN, RDVDGJ, RDVOD, RDRP1, RDRP2, RDRP3, RDAR01, RDAR02, RDAR03, RDAR04, RDAR05, RDAR06, RDAR07, RDAR08, RDAR09, RDAR10, RDISTC, RDPYID, RDURC1, RDURDT, RDURAT, RDURAB, RDURRF, RDRNID, RDPPDI, RDTORG, RDUSER, RDJCL, RDPID, RDUPMJ, RDUPMT, RDDDEX, RDJOBN, RDHCRR, RDHDGJ, RDDETL, RDSHPN FROM F03B575

TOP 812 | 03B | F03B575 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RDADCN	Auto Debit Control Nbr	Numeric	Generic Edit	8	0	Allow NULL?
2	RDCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?
3	RDRC	Record Code - A/P Checkwriter Work File	Character	Generic Edit	1	0	Allow NULL?
4	RDDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	RDDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
6	RDKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
7	RDSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
8	RDAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
9	RDDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
10	RDDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
11	RDICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
12	RDICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
13	RDDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
14	RDFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
15	RDCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
16	RDPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
17	RDCO	Company	String	Generic Edit	5	0	Allow NULL?
18	RDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
19	RDAID	Account ID	String	Generic Edit	8	0	Allow NULL?
20	RDPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
21	RDAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
22	RDPYR	Payor Address Number	Numeric	Generic Edit	8	0	Allow NULL?
23	RDPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
24	RDISTR	A/R Post Status	Character	Generic Edit	1	0	Allow NULL?
25	RDBALJ	Balanced - Journal Entries	Character	UDC (H00 BB)	1	0	Allow NULL?
26	RDPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
27	RDAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
28	RDAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
29	RDADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
30	RDADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
31	RDATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
32	RDATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
33	RDSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
34	RDBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
35	RDCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
36	RDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
37	RDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
38	RDCRR1	Triangulation Leg 1	Numeric	Generic Edit	15	0	Allow NULL?
39	RDCRR2	Triangulation Leg 2	Numeric	Generic Edit	15	0	Allow NULL?
40	RDCRCM	Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
41	RDTCRC	Transaction Currency Code	String	Generic Edit	3	0	Allow NULL?
42	RDTAAP	Transaction Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
43	RDTADA	Transaction Discount Amount	Numeric	Generic Edit	15	2	Allow NULL?
44	RDDMCD	Domestic Entry w/Mult Currency Distr	Character	Generic Edit	1	0	Allow NULL?
45	RDACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
46	RDFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
47	RDCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
48	RDCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
49	RDCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
50	RDCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
51	RDCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
52	RDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
53	RDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
54	RDDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
55	RDGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
56	RDAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
57	RDAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
58	RDAM2	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
59	RDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
60	RDOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
61	RDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
62	RDSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
63	RDSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
64	RDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
65	RDDDJ	Date - Net Due	Date	Generic Edit	6	0
66	RDDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
67	RDRDDJ	Date of Last Sent Reminder	Date	Generic Edit	6	0
68	RDRDSJ	Date - Reminder Stop Until Date	Date	Generic Edit	6	0
69	RDLFCJ	Date - Last Fee Calculated (Julian)	Date	Generic Edit	6	0
70	RDSMTJ	Date - Statement	Date	Generic Edit	6	0
71	RDNBRR	Reminders - Number of Reminders to Send	Character	UDC (H00 NB)	1	0	Allow NULL?
72	RDRDRL	Level of Last Sent Reminder	Character	UDC	1	0	Allow NULL?
73	RDRMDS	Number of Sent Reminders - Total	Numeric	Generic Edit	3	0	Allow NULL?
74	RDCOLL	Collection Report (Y/N)	Character	UDC (H00 CO)	1	0	Allow NULL?
75	RDCORC	Collection Reason Code	String	UDC (03B CL)	2	0	Allow NULL?
76	RDAFC	Apply Finance Charges - Y/N	Character	UDC (H00 AF)	1	0	Allow NULL?
77	RDDNLT	Delinquency Notice (Y/N)	Character	Generic Edit	1	0	Allow NULL?
78	RDRSCO	Write-Off Reason Code	String	UDC (03B RC)	2	0	Allow NULL?
79	RDODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
80	RDODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
81	RDOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
82	RDOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
83	RDVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
84	RDPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
85	RDPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
86	RDPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
87	RDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
88	RDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
89	RDSDOC	Sales Document Number	Numeric	Generic Edit	8	0	Allow NULL?
90	RDSDCT	Sales Document Type	String	UDC (00 DT)	2	0	Allow NULL?
91	RDSKCO	Document Company (Sales Order)	String	Generic Edit	5	0	Allow NULL?
92	RDSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
93	RDVLDT	Date - Cleared/Value	Date	Generic Edit	6	0
94	RDCMC1	Commission Code 1	Numeric	Generic Edit	8	0	Allow NULL?
95	RDVR01	Reference	String	Generic Edit	25	0	Allow NULL?
96	RDUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
97	RDMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
98	RDRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
99	RDALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
100	RDRF	Frequency - Recurring	String	UDC (H00 RF)	2	0	Allow NULL?
101	RDDRF	Recurring Frequency # of Payments	Numeric	Generic Edit	3	0	Allow NULL?
102	RDCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
103	RDFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
104	RDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
105	RDU	Units	Numeric	Generic Edit	15	2	Allow NULL?
106	RDUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
107	RDALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
108	RDRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
109	RDVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
110	RDVOD	Void Flag	Character	Generic Edit	1	0	Allow NULL?
111	RDRP1	A/R - A/P - Miscellaneous Code 1	Character	Generic Edit	1	0	Allow NULL?
112	RDRP2	A/R - A/P - Miscellaneous Code 2	Character	Generic Edit	1	0	Allow NULL?
113	RDRP3	A/R - A/P - Cash Rcpts/Inv Reg Code	Character	Generic Edit	1	0	Allow NULL?
114	RDAR01	A/R Reporting Code 1	String	UDC (01 01)	3	0	Allow NULL?
115	RDAR02	A/R Reporting Code 2	String	UDC (01 02)	3	0	Allow NULL?
116	RDAR03	A/R Reporting Code 3	String	UDC (01 03)	3	0	Allow NULL?
117	RDAR04	A/R Reporting Code 4	String	UDC (01 04)	3	0	Allow NULL?
118	RDAR05	A/R Reporting Code 5	String	UDC (01 05)	3	0	Allow NULL?
119	RDAR06	A/R Reporting Code 6	String	UDC (01 06)	3	0	Allow NULL?
120	RDAR07	A/R Reporting Code 7	String	UDC (01 07)	3	0	Allow NULL?
121	RDAR08	A/R Reporting Code 8	String	UDC (01 08)	3	0	Allow NULL?
122	RDAR09	A/R Reporting Code 9	String	UDC (01 09)	3	0	Allow NULL?
123	RDAR10	A/R Reporting Code 10	String	UDC (01 10)	3	0	Allow NULL?
124	RDISTC	A/R Post to Cash Management	Character	Generic Edit	1	0	Allow NULL?
125	RDPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
126	RDURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
127	RDURDT	User Reserved Date	Date	Generic Edit	6	0
128	RDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
129	RDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
130	RDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
131	RDRNID	Batch Run ID (Internal)	Numeric	Generic Edit	3	0	Allow NULL?
132	RDPPDI	Date - Invoice Printed	Date	Generic Edit	6	0
133	RDTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
134	RDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
135	RDJCL	Date Invoice Closed	Date	Generic Edit	6	0
136	RDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
137	RDUPMJ	Date - Updated	Date	Generic Edit	6	0
138	RDUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
139	RDDDEX	Deduction Reason Code	String	UDC (03B CR)	2	0	Allow NULL?
140	RDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
141	RDHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
142	RDHDGJ	Historical Date - Julian	Date	Generic Edit	6	0
143	RDDETL	Detail lines for A/P Payments	Numeric	Generic Edit	6	0	Allow NULL?
144	RDSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?

TOP 812 | 03B | F03B575 INDEXES

Number

Description

Batch Ctrl Nbr Rcpt Nbr +A (Primary/Unique)

Element	Alias	Description	Sequence
1	ADCN	Auto Debit Control Nbr	Ascending
2	CKNU	Receipt Number	Ascending
3	RC	Record Code - A/P Checkwriter Work File	Ascending
4	KCO	Document Company	Ascending
5	DCT	Document Type	Ascending
6	DOC	Document (Voucher Invoice etc.)	Ascending
7	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

144 COLUMNS | 1 INDEXES | 812 | 03B | F03B575 TABLE

TOP 812 | 03B | F03B575 COLUMNS

TOP 812 | 03B | F03B575 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

144 COLUMNS | 1 INDEXES | 812 | 03B | F03B575 TABLE

TOP812 | 03B | F03B575 COLUMNS

TOP812 | 03B | F03B575 INDEXES

TOP 812 | 03B | F03B575 COLUMNS

TOP 812 | 03B | F03B575 INDEXES