	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

135 COLUMNS | 17 INDEXES | 920 | 03B | F03B14 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	920	F03B14	RZ	135	17	Receipts Detail	Transaction Files	03B: Enhanced Accounts Receivable	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 RZPYID, RZRC5, RZCKNU, RZDOC, RZDCT, RZKCO, RZSFX, RZAN8, RZDCTM, RZDMTJ, RZDGJ, RZPOST, RZGLC, RZAID, RZCTRY, RZFY, RZPN, RZCO, RZICUT, RZICU, RZDICJ, RZPA8, RZRPID, RZRLIN, RZPAAP, RZADSC, RZADSA, RZAAAJ, RZECBA, RZDDA, RZBCRC, RZCRRM, RZCRCD, RZCRR, RZPFAP, RZCDS, RZCDSA, RZFCHG, RZECBF, RZFDA, RZAGL, RZAIDT, RZTCRC, RZTAAP, RZTADA, RZTAAJ, RZTCBA, RZTDA, RZACRR, RZACR1, RZACR2, RZACRM, RZAGLA, RZAIDA, RZAIDD, RZRSCO, RZAIDW, RZECBR, RZGLCC, RZAIDC, RZDDEX, RZDAID, RZTYIN, RZUTIC, RZUCTF, RZAID2, RZAM2, RZMCU, RZSBL, RZSBLT, RZPKCO, RZPO, RZPDCT, RZNUMB, RZUNIT, RZMCU2, RZRMK, RZFNLP, RZALT6, RZODOC, RZODCT, RZOKCO, RZOSFX, RZGDOC, RZGDCT, RZGKCO, RZGSFX, RZDCTG, RZDOCG, RZKCOG, RZCTL, RZSMTJ, RZVDGJ, RZVRE, RZNFVD, RZHCRR, RZISTC, RZLFCJ, RZPDLT, RZDDJ, RZDDNJ, RZIDGJ, RZDDST, RZVR01, RZRFID, RZRIDC, RZPRGF, RZGFL1, RZRNID, RZTORG, RZUSER, RZPID, RZUPMJ, RZUPMT, RZJOBN, RZURAB, RZURAT, RZURC1, RZURDT, RZURRF, RZSHPN, RZOMOD, RZDOCO, RZRASI, RZSFXO, RZKCOO, RZDCTO, RZRAMT, RZLRFL, RZGFL2, RZDRCO, RZNETTCID, RZNETDOC, RZNETRC5, RZADGJ FROM F03B14

TOP 920 | 03B | F03B14 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RZPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	RZRC5	File Line Identifier 5.0	Numeric	Generic Edit	5	0	Allow NULL?
3	RZCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?
4	RZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	RZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
6	RZKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
7	RZSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
8	RZAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
9	RZDCTM	Document Type - Matching	String	UDC (00 DT)	2	0	Allow NULL?
10	RZDMTJ	Date - Matching Check or Item - Julian	Date	Generic Edit	6	0
11	RZDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
12	RZPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
13	RZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
14	RZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
15	RZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
16	RZFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
17	RZPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
18	RZCO	Company	String	Generic Edit	5	0	Allow NULL?
19	RZICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
20	RZICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
21	RZDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
22	RZPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
23	RZRPID	Related Payment ID	Numeric	Generic Edit	15	0	Allow NULL?
24	RZRLIN	Related Payment Line ID	Numeric	Generic Edit	5	0	Allow NULL?
25	RZPAAP	Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
26	RZADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
27	RZADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
28	RZAAAJ	Amount - Write Off	Numeric	Generic Edit	15	2	Allow NULL?
29	RZECBA	Amount - Chargeback	Numeric	Generic Edit	15	2	Allow NULL?
30	RZDDA	Amount - Deduction	Numeric	Generic Edit	15	2	Allow NULL?
31	RZBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
32	RZCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
33	RZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
34	RZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
35	RZPFAP	Payment Amount - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
36	RZCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
37	RZCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
38	RZFCHG	Amount - Foreign Changed Amount	Numeric	Generic Edit	15	2	Allow NULL?
39	RZECBF	Amount - Foreign Chargeback	Numeric	Generic Edit	15	2	Allow NULL?
40	RZFDA	Amount - Foreign Deduction	Numeric	Generic Edit	15	2	Allow NULL?
41	RZAGL	Amount Gain/Loss	Numeric	Generic Edit	15	2	Allow NULL?
42	RZAIDT	Gain/Loss Account ID	String	Generic Edit	8	0	Allow NULL?
43	RZTCRC	Transaction Currency Code	String	Generic Edit	3	0	Allow NULL?
44	RZTAAP	Transaction Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
45	RZTADA	Transaction Discount Amount	Numeric	Generic Edit	15	2	Allow NULL?
46	RZTAAJ	Transaction Write Off Amount	Numeric	Generic Edit	15	2	Allow NULL?
47	RZTCBA	Transaction Charge Back Amount	Numeric	Generic Edit	15	2	Allow NULL?
48	RZTDA	Transaction Deduction Amount	Numeric	Generic Edit	15	2	Allow NULL?
49	RZACRR	Alternate Currency Exchange Rate	Numeric	Generic Edit	15	0	Allow NULL?
50	RZACR1	Alternate Currency Rate 1	Numeric	Generic Edit	15	0	Allow NULL?
51	RZACR2	Alternate Currency Rate 2	Numeric	Generic Edit	15	0	Allow NULL?
52	RZACRM	Alt Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
53	RZAGLA	Alternate Currency Gain/Loss	Numeric	Generic Edit	15	2	Allow NULL?
54	RZAIDA	Alt Curr Gain/Loss Account ID	String	Generic Edit	8	0	Allow NULL?
55	RZAIDD	Discount Account ID	String	Generic Edit	8	0	Allow NULL?
56	RZRSCO	Write-Off Reason Code	String	UDC (03B RC)	2	0	Allow NULL?
57	RZAIDW	Write-Off Account ID	String	Generic Edit	8	0	Allow NULL?
58	RZECBR	Chargeback Reason Code	String	UDC (03B CB)	2	0	Allow NULL?
59	RZGLCC	G/L Offset Chargebacks	String	Generic Edit	4	0	Allow NULL?
60	RZAIDC	Chargeback Account ID	String	Generic Edit	8	0	Allow NULL?
61	RZDDEX	Deduction Reason Code	String	UDC (03B CR)	2	0	Allow NULL?
62	RZDAID	Deduction Account ID	String	Generic Edit	8	0	Allow NULL?
63	RZTYIN	Receipt Type Code	Character	UDC (03B TI)	1	0	Allow NULL?
64	RZUTIC	User Type Input Code	String	UDC (03B RE)	2	0	Allow NULL?
65	RZUCTF	Unapplied Cash Transfer	Character	Generic Edit	1	0	Allow NULL?
66	RZAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
67	RZAM2	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
68	RZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
69	RZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
70	RZSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
71	RZPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
72	RZPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
73	RZPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
74	RZNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
75	RZUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
76	RZMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
77	RZRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
78	RZFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
79	RZALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
80	RZODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
81	RZODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
82	RZOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
83	RZOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
84	RZGDOC	Deduction Document Number	Numeric	Generic Edit	8	0	Allow NULL?
85	RZGDCT	Deduction Document Type	String	UDC (00 DT)	2	0	Allow NULL?
86	RZGKCO	Deduction Document Company	String	Generic Edit	5	0	Allow NULL?
87	RZGSFX	Deduction Document Pay Item	String	Generic Edit	3	0	Allow NULL?
88	RZDCTG	Document Type - JE	String	UDC (00 DT)	2	0	Allow NULL?
89	RZDOCG	Document Number - JE	Numeric	Generic Edit	8	0	Allow NULL?
90	RZKCOG	Document Company - JE	String	Generic Edit	5	0	Allow NULL?
91	RZCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
92	RZSMTJ	Date - Statement	Date	Generic Edit	6	0
93	RZVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
94	RZVRE	Void Reason Code	String	UDC (03B VR)	3	0	Allow NULL?
95	RZNFVD	Receipt NSF/Void Code	Character	Generic Edit	1	0	Allow NULL?
96	RZHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
97	RZISTC	A/R Post to Cash Management	Character	Generic Edit	1	0	Allow NULL?
98	RZLFCJ	Date - Last Fee Calculated (Julian)	Date	Generic Edit	6	0
99	RZPDLT	Partial Payment	Character	UDC (03B PL)	1	0	Allow NULL?
100	RZDDJ	Date - Net Due	Date	Generic Edit	6	0
101	RZDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
102	RZIDGJ	Date - Invoice Journal Date - Julian	Date	Generic Edit	6	0
103	RZDDST	Draft Status	Character	UDC (03B DS)	1	0	Allow NULL?
104	RZVR01	Reference	String	Generic Edit	25	0	Allow NULL?
105	RZRFID	Reference ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
106	RZRIDC	Reference ID Code	Character	Generic Edit	1	0	Allow NULL?
107	RZPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
108	RZGFL1	Generic Flag 1	Character	Generic Edit	1	0	Allow NULL?
109	RZRNID	Batch Run ID (Internal)	Numeric	Generic Edit	3	0	Allow NULL?
110	RZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
111	RZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
112	RZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
113	RZUPMJ	Date - Updated	Date	Generic Edit	6	0
114	RZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
115	RZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
116	RZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
117	RZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
118	RZURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
119	RZURDT	User Reserved Date	Date	Generic Edit	6	0
120	RZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
121	RZSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
122	RZOMOD	Originating System	Character	UDC (03B OS)	1	0	Allow NULL?
123	RZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
124	RZRASI	Rounding Account Short ID	String	Generic Edit	8	0	Allow NULL?
125	RZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
126	RZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
127	RZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
128	RZRAMT	Rounding Amount	Numeric	Generic Edit	15	2	Allow NULL?
129	RZLRFL	Localization Reserved Flag	Character	Generic Edit	1	0	Allow NULL?
130	RZGFL2	Generic Flag 2	Character	Generic Edit	1	0	Allow NULL?
131	RZDRCO	Discount Reason Code	String	UDC (00 DE)	3	0	Allow NULL?
132	RZNETTCID	Netting Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
133	RZNETDOC	Netting Document Number	Numeric	Generic Edit	15	0	Allow NULL?
134	RZNETRC5	Netting Line ID	Numeric	Generic Edit	6	0	Allow NULL?
135	RZADGJ	Actual Receipt Date	Date	Generic Edit	6	0

TOP 920 | 03B | F03B14 INDEXES

Number

Description

Payment ID File Line ID (Primary/Unique)

Element	Alias	Description	Sequence
1	PYID	Payment ID (Internal)	Ascending
2	RC5	File Line Identifier 5.0	Ascending

Payment ID Post

Element	Alias	Description	Sequence
1	PYID	Payment ID (Internal)	Ascending
2	POST	G/L Posted Code	Ascending

Doc Dct Kco Sfx Pyid Rc5

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	PYID	Payment ID (Internal)	Ascending
6	RC5	File Line Identifier 5.0	Ascending

ICU ICUT POST RPID RLIN

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	ICUT	Batch Type	Ascending
3	POST	G/L Posted Code	Ascending
4	RPID	Related Payment ID	Ascending
5	RLIN	Related Payment Line ID	Ascending

Address Company

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CO	Company	Ascending

Doc Dct Kco Sfx Tcrc +A

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	TCRC	Transaction Currency Code	Ascending
6	PYID	Payment ID (Internal)	Ascending
7	RC5	File Line Identifier 5.0	Ascending

Payment ID File Line ID Desc

Element	Alias	Description	Sequence
1	PYID	Payment ID (Internal)	Ascending
2	RC5	File Line Identifier 5.0	Descending

Purchase Order G/L Offset +

Element	Alias	Description	Sequence
1	PO	Purchase Order	Ascending
2	GLC	G/L Offset	Ascending
3	DGJ	Date - For G/L (and Voucher) - Julian	Ascending

Address Number Receipt +

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

Address Number G/L Date +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
3	DCT	Document Type	Ascending
4	DOC	Document (Voucher Invoice etc.)	Ascending
5	KCO	Document Company	Ascending
6	SFX	Document Pay Item	Ascending

G/L Date Company

Element	Alias	Description	Sequence
1	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
2	CO	Company	Ascending

AddressNumber Company +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CO	Company	Ascending
3	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
4	DICJ	Date - Batch (Julian)	Ascending
5	RC5	File Line Identifier 5.0	Ascending

CTL CRCD PYID

Element	Alias	Description	Sequence
1	CTL	Control/Statement Field	Ascending
2	CRCD	Currency Code - From	Ascending
3	PYID	Payment ID (Internal)	Ascending

NetTransID NetDocNum +A

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

NetTransID NetDocNum +B

Element	Alias	Description	Sequence
1	NETTCID	Netting Transaction ID	Ascending
2	NETDOC	Netting Document Number	Ascending
3	NETRC5	Netting Line ID	Ascending
4	VRE	Void Reason Code	Ascending

GDOC GDCT GKCO GSFX

Element	Alias	Description	Sequence
1	GDOC	Deduction Document Number	Ascending
2	GDCT	Deduction Document Type	Ascending
3	GKCO	Deduction Document Company	Ascending
4	GSFX	Deduction Document Pay Item	Ascending

DOCG ICUT ICU

Element	Alias	Description	Sequence
1	DOCG	Document Number - JE	Ascending
2	ICUT	Batch Type	Ascending
3	ICU	Batch Number	Ascending
4	SFX	Document Pay Item	Ascending
5	RC5	File Line Identifier 5.0	Ascending
6	VDGJ	Void Date - For G/L - Julian	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

135 COLUMNS | 17 INDEXES | 920 | 03B | F03B14 TABLE

TOP 920 | 03B | F03B14 COLUMNS

TOP 920 | 03B | F03B14 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

135 COLUMNS | 17 INDEXES | 920 | 03B | F03B14 TABLE

TOP920 | 03B | F03B14 COLUMNS

TOP920 | 03B | F03B14 INDEXES

TOP 920 | 03B | F03B14 COLUMNS

TOP 920 | 03B | F03B14 INDEXES