	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

149 COLUMNS | 2 INDEXES | 812 | 03B | F03B14Z2 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	812	F03B14Z2	SZ	149	2	F03B14 Interoperability Table	Batch Input 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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZPYID, SZRC5, SZCKNU, SZDOC, SZDCT, SZKCO, SZSFX, SZAN8, SZDCTM, SZDMTJ, SZDGJ, SZPOST, SZGLC, SZAID, SZCTRY, SZFY, SZPN, SZCO, SZICUT, SZICU, SZDICJ, SZPA8, SZRPID, SZRLIN, SZPAAP, SZADSC, SZADSA, SZAAAJ, SZECBA, SZDDA, SZBCRC, SZCRRM, SZCRCD, SZCRR, SZPFAP, SZCDS, SZCDSA, SZFCHG, SZECBF, SZFDA, SZAGL, SZAIDT, SZTCRC, SZTAAP, SZTADA, SZTAAJ, SZTCBA, SZTDA, SZACRR, SZACR1, SZACR2, SZACRM, SZAGLA, SZAIDA, SZAIDD, SZRSCO, SZAIDW, SZECBR, SZGLCC, SZAIDC, SZDDEX, SZDAID, SZTYIN, SZUTIC, SZUCTF, SZAID2, SZAM2, SZMCU, SZSBL, SZSBLT, SZPKCO, SZPO, SZPDCT, SZNUMB, SZUNIT, SZMCU2, SZRMK, SZFNLP, SZALT6, SZODOC, SZODCT, SZOKCO, SZOSFX, SZGDOC, SZGDCT, SZGKCO, SZGSFX, SZDCTG, SZDOCG, SZKCOG, SZCTL, SZSMTJ, SZVDGJ, SZVRE, SZNFVD, SZHCRR, SZISTC, SZLFCJ, SZPDLT, SZDDJ, SZDDNJ, SZIDGJ, SZDDST, SZVR01, SZRFID, SZRIDC, SZPRGF, SZGFL1, SZRNID, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZSHPN, SZRASI, SZRAMT, SZSFXO, SZDCTO, SZKCOO, SZDOCO, SZGFL2, SZOMOD, SZLRFL, SZDRCO, SZURC1, SZNETTCID, SZNETDOC, SZNETRC5, SZADGJ FROM F03B14Z2

TOP 812 | 03B | F03B14Z2 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SZEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	SZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	SZEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	SZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	SZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SZTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	SZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	SZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	SZDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	SZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	SZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	SZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	SZTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	SZPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
15	SZRC5	File Line Identifier 5.0	Numeric	Generic Edit	5	0	Allow NULL?
16	SZCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?
17	SZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
18	SZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
19	SZKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
20	SZSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
21	SZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
22	SZDCTM	Document Type - Matching	String	UDC (00 DT)	2	0	Allow NULL?
23	SZDMTJ	Date - Matching Check or Item - Julian	Date	Generic Edit	6	0
24	SZDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
25	SZPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
26	SZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
27	SZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
28	SZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
29	SZFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
30	SZPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
31	SZCO	Company	String	Generic Edit	5	0	Allow NULL?
32	SZICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
33	SZICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
34	SZDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
35	SZPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
36	SZRPID	Related Payment ID	Numeric	Generic Edit	15	0	Allow NULL?
37	SZRLIN	Related Payment Line ID	Numeric	Generic Edit	5	0	Allow NULL?
38	SZPAAP	Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
39	SZADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
40	SZADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
41	SZAAAJ	Amount - Write Off	Numeric	Generic Edit	15	2	Allow NULL?
42	SZECBA	Amount - Chargeback	Numeric	Generic Edit	15	2	Allow NULL?
43	SZDDA	Amount - Deduction	Numeric	Generic Edit	15	2	Allow NULL?
44	SZBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
45	SZCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
46	SZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
47	SZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
48	SZPFAP	Payment Amount - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
49	SZCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
50	SZCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
51	SZFCHG	Amount - Foreign Changed Amount	Numeric	Generic Edit	15	2	Allow NULL?
52	SZECBF	Amount - Foreign Chargeback	Numeric	Generic Edit	15	2	Allow NULL?
53	SZFDA	Amount - Foreign Deduction	Numeric	Generic Edit	15	2	Allow NULL?
54	SZAGL	Amount Gain/Loss	Numeric	Generic Edit	15	2	Allow NULL?
55	SZAIDT	Gain/Loss Account ID	String	Generic Edit	8	0	Allow NULL?
56	SZTCRC	Transaction Currency Code	String	Generic Edit	3	0	Allow NULL?
57	SZTAAP	Transaction Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
58	SZTADA	Transaction Discount Amount	Numeric	Generic Edit	15	2	Allow NULL?
59	SZTAAJ	Transaction Write Off Amount	Numeric	Generic Edit	15	2	Allow NULL?
60	SZTCBA	Transaction Charge Back Amount	Numeric	Generic Edit	15	2	Allow NULL?
61	SZTDA	Transaction Deduction Amount	Numeric	Generic Edit	15	2	Allow NULL?
62	SZACRR	Alternate Currency Exchange Rate	Numeric	Generic Edit	15	0	Allow NULL?
63	SZACR1	Alternate Currency Rate 1	Numeric	Generic Edit	15	0	Allow NULL?
64	SZACR2	Alternate Currency Rate 2	Numeric	Generic Edit	15	0	Allow NULL?
65	SZACRM	Alt Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
66	SZAGLA	Alternate Currency Gain/Loss	Numeric	Generic Edit	15	2	Allow NULL?
67	SZAIDA	Alt Curr Gain/Loss Account ID	String	Generic Edit	8	0	Allow NULL?
68	SZAIDD	Discount Account ID	String	Generic Edit	8	0	Allow NULL?
69	SZRSCO	Write-Off Reason Code	String	UDC (03B RC)	2	0	Allow NULL?
70	SZAIDW	Write-Off Account ID	String	Generic Edit	8	0	Allow NULL?
71	SZECBR	Chargeback Reason Code	String	UDC (03B CB)	2	0	Allow NULL?
72	SZGLCC	G/L Offset Chargebacks	String	Generic Edit	4	0	Allow NULL?
73	SZAIDC	Chargeback Account ID	String	Generic Edit	8	0	Allow NULL?
74	SZDDEX	Deduction Reason Code	String	UDC (03B CR)	2	0	Allow NULL?
75	SZDAID	Deduction Account ID	String	Generic Edit	8	0	Allow NULL?
76	SZTYIN	Receipt Type Code	Character	UDC (03B TI)	1	0	Allow NULL?
77	SZUTIC	User Type Input Code	String	UDC (03B RE)	2	0	Allow NULL?
78	SZUCTF	Unapplied Cash Transfer	Character	Generic Edit	1	0	Allow NULL?
79	SZAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
80	SZAM2	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
81	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
82	SZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
83	SZSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
84	SZPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
85	SZPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
86	SZPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
87	SZNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
88	SZUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
89	SZMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
90	SZRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
91	SZFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
92	SZALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
93	SZODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
94	SZODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
95	SZOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
96	SZOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
97	SZGDOC	Deduction Document Number	Numeric	Generic Edit	8	0	Allow NULL?
98	SZGDCT	Deduction Document Type	String	UDC (00 DT)	2	0	Allow NULL?
99	SZGKCO	Deduction Document Company	String	Generic Edit	5	0	Allow NULL?
100	SZGSFX	Deduction Document Pay Item	String	Generic Edit	3	0	Allow NULL?
101	SZDCTG	Document Type - JE	String	UDC (00 DT)	2	0	Allow NULL?
102	SZDOCG	Document Number - JE	Numeric	Generic Edit	8	0	Allow NULL?
103	SZKCOG	Document Company - JE	String	Generic Edit	5	0	Allow NULL?
104	SZCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
105	SZSMTJ	Date - Statement	Date	Generic Edit	6	0
106	SZVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
107	SZVRE	Void Reason Code	String	UDC (03B VR)	3	0	Allow NULL?
108	SZNFVD	Receipt NSF/Void Code	Character	Generic Edit	1	0	Allow NULL?
109	SZHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
110	SZISTC	A/R Post to Cash Management	Character	Generic Edit	1	0	Allow NULL?
111	SZLFCJ	Date - Last Fee Calculated (Julian)	Date	Generic Edit	6	0
112	SZPDLT	Partial Payment	Character	UDC (03B PL)	1	0	Allow NULL?
113	SZDDJ	Date - Net Due	Date	Generic Edit	6	0
114	SZDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
115	SZIDGJ	Date - Invoice Journal Date - Julian	Date	Generic Edit	6	0
116	SZDDST	Draft Status	Character	UDC (03B DS)	1	0	Allow NULL?
117	SZVR01	Reference	String	Generic Edit	25	0	Allow NULL?
118	SZRFID	Reference ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
119	SZRIDC	Reference ID Code	Character	Generic Edit	1	0	Allow NULL?
120	SZPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
121	SZGFL1	Generic Flag 1	Character	Generic Edit	1	0	Allow NULL?
122	SZRNID	Batch Run ID (Internal)	Numeric	Generic Edit	3	0	Allow NULL?
123	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
124	SZURDT	User Reserved Date	Date	Generic Edit	6	0
125	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
126	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
127	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
128	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
129	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
130	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
131	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
132	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
133	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
134	SZSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
135	SZRASI	Rounding Account Short ID	String	Generic Edit	8	0	Allow NULL?
136	SZRAMT	Rounding Amount	Numeric	Generic Edit	15	2	Allow NULL?
137	SZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
138	SZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
139	SZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
140	SZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
141	SZGFL2	Generic Flag 2	Character	Generic Edit	1	0	Allow NULL?
142	SZOMOD	Originating System	Character	UDC (03B OS)	1	0	Allow NULL?
143	SZLRFL	Localization Reserved Flag	Character	Generic Edit	1	0	Allow NULL?
144	SZDRCO	Discount Reason Code	String	UDC (00 DE)	3	0	Allow NULL?
145	SZURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
146	SZNETTCID	Netting Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
147	SZNETDOC	Netting Document Number	Numeric	Generic Edit	15	0	Allow NULL?
148	SZNETRC5	Netting Line ID	Numeric	Generic Edit	6	0	Allow NULL?
149	SZADGJ	Actual Receipt Date	Date	Generic Edit	6	0

TOP 812 | 03B | F03B14Z2 INDEXES

Number

Description

User ID Batch Number + (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

Payment ID File Line ID

Element	Alias	Description	Sequence
1	PYID	Payment ID (Internal)	Ascending
2	RC5	File Line Identifier 5.0	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

149 COLUMNS | 2 INDEXES | 812 | 03B | F03B14Z2 TABLE

TOP 812 | 03B | F03B14Z2 COLUMNS

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

149 COLUMNS | 2 INDEXES | 812 | 03B | F03B14Z2 TABLE

TOP812 | 03B | F03B14Z2 COLUMNS

TOP812 | 03B | F03B14Z2 INDEXES

TOP 812 | 03B | F03B14Z2 COLUMNS

TOP 812 | 03B | F03B14Z2 INDEXES