	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

171 COLUMNS | 2 INDEXES | 812 | 03B | F03B11Z2 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	812	F03B11Z2	SY	171	2	F03B11 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 SYEDUS, SYEDBT, SYEDTN, SYEDLN, SYEDCT, SYTYTN, SYEDFT, SYEDDT, SYDRIN, SYEDDL, SYEDSP, SYPNID, SYTNAC, SYDOC, SYDCT, SYKCO, SYSFX, SYAN8, SYDGJ, SYDIVJ, SYICUT, SYICU, SYDICJ, SYFY, SYCTRY, SYPN, SYCO, SYGLC, SYAID, SYPA8, SYAN8J, SYPYR, SYPOST, SYISTR, SYBALJ, SYPST, SYAG, SYAAP, SYADSC, SYADSA, SYATXA, SYATXN, SYSTAM, SYBCRC, SYCRRM, SYCRCD, SYCRR, SYDMCD, SYACR, SYFAP, SYCDS, SYCDSA, SYCTXA, SYCTXN, SYCTAM, SYTXA1, SYEXR1, SYDSVJ, SYGLBA, SYAM, SYAID2, SYAM2, SYMCU, SYOBJ, SYSUB, SYSBLT, SYSBL, SYPTC, SYDDJ, SYDDNJ, SYRDDJ, SYRDSJ, SYLFCJ, SYSMTJ, SYNBRR, SYRDRL, SYRMDS, SYCOLL, SYCORC, SYAFC, SYDNLT, SYRSCO, SYODOC, SYODCT, SYOKCO, SYOSFX, SYVINV, SYPO, SYPDCT, SYPKCO, SYDCTO, SYLNID, SYSDOC, SYSDCT, SYSKCO, SYSFXO, SYVLDT, SYCMC1, SYVR01, SYUNIT, SYMCU2, SYRMK, SYALPH, SYRF, SYDRF, SYCTL, SYFNLP, SYITM, SYU, SYUM, SYALT6, SYRYIN, SYVDGJ, SYVOD, SYRP1, SYRP2, SYRP3, SYAR01, SYAR02, SYAR03, SYAR04, SYAR05, SYAR06, SYAR07, SYAR08, SYAR09, SYAR10, SYISTC, SYPYID, SYRNID, SYPPDI, SYJCL, SYDDEX, SYHCRR, SYHDGJ, SYDCP, SYURCD, SYURDT, SYURAT, SYURAB, SYURRF, SYTORG, SYUSER, SYPID, SYJOBN, SYUPMJ, SYTDAY, SYSHPN, SYDTXS, SYOMOD, SYCLMG, SYCMGR, SYATAD, SYCTAD, SYNRTA, SYFNRT, SYPRGF, SYGFL1, SYGFL2, SYDOCO, SYKCOO, SYSOTF, SYDTPB, SYERDJ, SYPWPG, SYNETTCID, SYNETDOC, SYNETRC5, SYNETST, SYAJCL, SYRMR1 FROM F03B11Z2

TOP 812 | 03B | F03B11Z2 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SYEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	SYEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	SYEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	SYEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	SYEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SYTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	SYEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	SYEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	SYDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	SYEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	SYEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	SYPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	SYTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	SYDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
15	SYDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
16	SYKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
17	SYSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
18	SYAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
19	SYDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
20	SYDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
21	SYICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
22	SYICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
23	SYDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
24	SYFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
25	SYCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
26	SYPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
27	SYCO	Company	String	Generic Edit	5	0	Allow NULL?
28	SYGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
29	SYAID	Account ID	String	Generic Edit	8	0	Allow NULL?
30	SYPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
31	SYAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
32	SYPYR	Payor Address Number	Numeric	Generic Edit	8	0	Allow NULL?
33	SYPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
34	SYISTR	A/R Post Status	Character	Generic Edit	1	0	Allow NULL?
35	SYBALJ	Balanced - Journal Entries	Character	UDC (H00 BB)	1	0	Allow NULL?
36	SYPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
37	SYAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
38	SYAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
39	SYADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
40	SYADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
41	SYATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
42	SYATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
43	SYSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
44	SYBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
45	SYCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
46	SYCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
47	SYCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
48	SYDMCD	Domestic Entry w/Mult Currency Distr	Character	Generic Edit	1	0	Allow NULL?
49	SYACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
50	SYFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
51	SYCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
52	SYCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
53	SYCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
54	SYCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
55	SYCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
56	SYTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
57	SYEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
58	SYDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
59	SYGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
60	SYAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
61	SYAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
62	SYAM2	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
63	SYMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
64	SYOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
65	SYSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
66	SYSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
67	SYSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
68	SYPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
69	SYDDJ	Date - Net Due	Date	Generic Edit	6	0
70	SYDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
71	SYRDDJ	Date of Last Sent Reminder	Date	Generic Edit	6	0
72	SYRDSJ	Date - Reminder Stop Until Date	Date	Generic Edit	6	0
73	SYLFCJ	Date - Last Fee Calculated (Julian)	Date	Generic Edit	6	0
74	SYSMTJ	Date - Statement	Date	Generic Edit	6	0
75	SYNBRR	Reminders - Number of Reminders to Send	Character	UDC (H00 NB)	1	0	Allow NULL?
76	SYRDRL	Level of Last Sent Reminder	Character	UDC	1	0	Allow NULL?
77	SYRMDS	Number of Sent Reminders - Total	Numeric	Generic Edit	3	0	Allow NULL?
78	SYCOLL	Collection Report (Y/N)	Character	UDC (H00 CO)	1	0	Allow NULL?
79	SYCORC	Collection Reason Code	String	UDC (03B CL)	2	0	Allow NULL?
80	SYAFC	Apply Finance Charges - Y/N	Character	UDC (H00 AF)	1	0	Allow NULL?
81	SYDNLT	Delinquency Notice (Y/N)	Character	Generic Edit	1	0	Allow NULL?
82	SYRSCO	Write-Off Reason Code	String	UDC (03B RC)	2	0	Allow NULL?
83	SYODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
84	SYODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
85	SYOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
86	SYOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
87	SYVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
88	SYPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
89	SYPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
90	SYPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
91	SYDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
92	SYLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
93	SYSDOC	Sales Document Number	Numeric	Generic Edit	8	0	Allow NULL?
94	SYSDCT	Sales Document Type	String	UDC (00 DT)	2	0	Allow NULL?
95	SYSKCO	Document Company (Sales Order)	String	Generic Edit	5	0	Allow NULL?
96	SYSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
97	SYVLDT	Date - Cleared/Value	Date	Generic Edit	6	0
98	SYCMC1	Commission Code 1	Numeric	Generic Edit	8	0	Allow NULL?
99	SYVR01	Reference	String	Generic Edit	25	0	Allow NULL?
100	SYUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
101	SYMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
102	SYRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
103	SYALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
104	SYRF	Frequency - Recurring	String	UDC (H00 RF)	2	0	Allow NULL?
105	SYDRF	Recurring Frequency # of Payments	Numeric	Generic Edit	3	0	Allow NULL?
106	SYCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
107	SYFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
108	SYITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
109	SYU	Units	Numeric	Generic Edit	15	2	Allow NULL?
110	SYUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
111	SYALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
112	SYRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
113	SYVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
114	SYVOD	Void Flag	Character	Generic Edit	1	0	Allow NULL?
115	SYRP1	A/R - A/P - Miscellaneous Code 1	Character	Generic Edit	1	0	Allow NULL?
116	SYRP2	A/R - A/P - Miscellaneous Code 2	Character	Generic Edit	1	0	Allow NULL?
117	SYRP3	A/R - A/P - Cash Rcpts/Inv Reg Code	Character	Generic Edit	1	0	Allow NULL?
118	SYAR01	A/R Reporting Code 1	String	UDC (01 01)	3	0	Allow NULL?
119	SYAR02	A/R Reporting Code 2	String	UDC (01 02)	3	0	Allow NULL?
120	SYAR03	A/R Reporting Code 3	String	UDC (01 03)	3	0	Allow NULL?
121	SYAR04	A/R Reporting Code 4	String	UDC (01 04)	3	0	Allow NULL?
122	SYAR05	A/R Reporting Code 5	String	UDC (01 05)	3	0	Allow NULL?
123	SYAR06	A/R Reporting Code 6	String	UDC (01 06)	3	0	Allow NULL?
124	SYAR07	A/R Reporting Code 7	String	UDC (01 07)	3	0	Allow NULL?
125	SYAR08	A/R Reporting Code 8	String	UDC (01 08)	3	0	Allow NULL?
126	SYAR09	A/R Reporting Code 9	String	UDC (01 09)	3	0	Allow NULL?
127	SYAR10	A/R Reporting Code 10	String	UDC (01 10)	3	0	Allow NULL?
128	SYISTC	A/R Post to Cash Management	Character	Generic Edit	1	0	Allow NULL?
129	SYPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
130	SYRNID	Batch Run ID (Internal)	Numeric	Generic Edit	3	0	Allow NULL?
131	SYPPDI	Date - Invoice Printed	Date	Generic Edit	6	0
132	SYJCL	Date Invoice Closed	Date	Generic Edit	6	0
133	SYDDEX	Deduction Reason Code	String	UDC (03B CR)	2	0	Allow NULL?
134	SYHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
135	SYHDGJ	Historical Date - Julian	Date	Generic Edit	6	0
136	SYDCP	Discount % - Payment Terms	Numeric	Generic Edit	5	0	Allow NULL?
137	SYURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
138	SYURDT	User Reserved Date	Date	Generic Edit	6	0
139	SYURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
140	SYURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
141	SYURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
142	SYTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
143	SYUSER	User ID	String	Generic Edit	10	0	Allow NULL?
144	SYPID	Program ID	String	Generic Edit	10	0	Allow NULL?
145	SYJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
146	SYUPMJ	Date - Updated	Date	Generic Edit	6	0
147	SYTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
148	SYSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
149	SYDTXS	Deferred Tax Status - VAT	Character	Generic Edit	1	0	Allow NULL?
150	SYOMOD	Originating System	Character	UDC (03B OS)	1	0	Allow NULL?
151	SYCLMG	Collection Manager	String	Generic Edit (01 CM)	10	0	Allow NULL?
152	SYCMGR	Credit Manager	String	UDC (01 CR)	10	0	Allow NULL?
153	SYATAD	Amount - To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
154	SYCTAD	Amount - Currency To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
155	SYNRTA	Non-Recoverable Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
156	SYFNRT	Foreign Non-Recoverable Tax	Numeric	Generic Edit	15	2	Allow NULL?
157	SYPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
158	SYGFL1	Generic Flag 1	Character	Generic Edit	1	0	Allow NULL?
159	SYGFL2	Generic Flag 2	Character	Generic Edit	1	0	Allow NULL?
160	SYDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
161	SYKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
162	SYSOTF	Sales Order Tax Flag	Character	Generic Edit	1	0	Allow NULL?
163	SYDTPB	Notification Payment Date	Date	Generic Edit	6	0
164	SYERDJ	Date - For Exchange Rate - Julian	Date	Generic Edit	6	0
165	SYPWPG	Pay When Paid Group Number	Numeric	Generic Edit	15	0	Allow NULL?
166	SYNETTCID	Netting Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
167	SYNETDOC	Netting Document Number	Numeric	Generic Edit	15	0	Allow NULL?
168	SYNETRC5	Netting Line ID	Numeric	Generic Edit	6	0	Allow NULL?
169	SYNETST	Netting Status Code	Character	UDC (00 NS)	1	0	Allow NULL?
170	SYAJCL	Actual Date Invoice Closed	Date	Generic Edit	6	0
171	SYRMR1	Generic AR Receipt Matching Reference1	String	Generic Edit	50	0	Allow NULL?

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

Doc Number Doc Type +

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

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

171 COLUMNS | 2 INDEXES | 812 | 03B | F03B11Z2 TABLE

TOP 812 | 03B | F03B11Z2 COLUMNS

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

171 COLUMNS | 2 INDEXES | 812 | 03B | F03B11Z2 TABLE

TOP812 | 03B | F03B11Z2 COLUMNS

TOP812 | 03B | F03B11Z2 INDEXES

TOP 812 | 03B | F03B11Z2 COLUMNS

TOP 812 | 03B | F03B11Z2 INDEXES