	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

202 COLUMNS | 1 INDEXES | 812 | 03B | F03B11Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	812	F03B11Z1	VJ	202	1	Invoice Transactions - Batch File	Batch Input Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables

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 VJEDUS, VJEDTY, VJEDSQ, VJEDTN, VJEDCT, VJEDLN, VJEDTS, VJEDFT, VJEDDT, VJEDER, VJEDDL, VJEDSP, VJEDTC, VJEDTR, VJEDBT, VJEDGL, VJEDDH, VJEDAN, VJDOC, VJDCT, VJKCO, VJSFX, VJAN8, VJDGJ, VJDIVJ, VJICUT, VJICU, VJDICJ, VJFY, VJCTRY, VJPN, VJCO, VJGLC, VJAID, VJPA8, VJAN8J, VJPYR, VJPOST, VJISTR, VJBALJ, VJPST, VJAG, VJAAP, VJADSC, VJADSA, VJATXA, VJATXN, VJSTAM, VJCRRM, VJCRCD, VJCRR, VJDMCD, VJACR, VJFAP, VJCDS, VJCDSA, VJCTXA, VJCTXN, VJCTAM, VJTXA1, VJEXR1, VJDSVJ, VJGLBA, VJAM, VJAID2, VJAM2, VJMCU, VJOBJ, VJSUB, VJSBLT, VJSBL, VJPTC, VJDDJ, VJDDNJ, VJRDDJ, VJRDSJ, VJSMTJ, VJNBRR, VJRDRL, VJRMDS, VJCOLL, VJCORC, VJAFC, VJRSCO, VJCKNU, VJODOC, VJODCT, VJOKCO, VJOSFX, VJVINV, VJPO, VJPDCT, VJPKCO, VJDCTO, VJLNID, VJSDOC, VJSDCT, VJSKCO, VJSFXO, VJVLDT, VJCMC1, VJVR01, VJUNIT, VJMCU2, VJRMK, VJALPH, VJRF, VJDRF, VJCTL, VJFNLP, VJITM, VJU, VJUM, VJALT6, VJRYIN, VJVDGJ, VJVRE, VJRP1, VJRP2, VJRP3, VJAR01, VJAR02, VJAR03, VJAR04, VJAR05, VJAR06, VJAR07, VJAR08, VJAR09, VJAR10, VJURC1, VJURDT, VJURAT, VJURAB, VJURRF, VJTORG, VJUSER, VJPID, VJUPMJ, VJUPMT, VJJOBN, VJHCRR, VJHDGJ, VJDIM, VJDID, VJDIY, VJDI#, VJDGM, VJDGD, VJDGY, VJDG#, VJDICM, VJDICD, VJDICY, VJDIC#, VJDSVM, VJDSVD, VJDSVY, VJDSV#, VJDDM, VJDDD, VJDDY, VJDD#, VJDDNM, VJDDND, VJDDNY, VJDDN#, VJSMTM, VJSMTD, VJSMTY, VJSMT#, VJRDDM, VJRDDD, VJRDDY, VJRDD#, VJRDSM, VJRDSD, VJRDSY, VJRDS#, VJHDGM, VJHDGD, VJHDGY, VJHDG#, VJSHPN, VJDTXS, VJOMOD, VJCLMG, VJCMGR, VJATAD, VJCTAD, VJNRTA, VJFNRT, VJPRGF, VJGFL1, VJGFL2, VJDOCO, VJKCOO, VJSOTF, VJDTPB, VJERDJ, VJNETST, VJRMR1 FROM F03B11Z1

TOP 812 | 03B | F03B11Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	VJEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	VJEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
3	VJEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
4	VJEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
5	VJEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	VJEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	VJEDTS	EDI - Transaction Set Number	String	Generic Edit	6	0	Allow NULL?
8	VJEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
9	VJEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
10	VJEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
11	VJEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
12	VJEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
13	VJEDTC	EDI - Transaction Action	Character	Generic Edit	1	0	Allow NULL?
14	VJEDTR	EDI - Transaction Type	Character	Generic Edit	1	0	Allow NULL?
15	VJEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
16	VJEDGL	Batch File Create G/L Record	Character	Generic Edit	1	0	Allow NULL?
17	VJEDDH	Batch File Discount Handling Flag	Character	Generic Edit	1	0	Allow NULL?
18	VJEDAN	User Address Number	Numeric	Generic Edit	8	0	Allow NULL?
19	VJDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
20	VJDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
21	VJKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
22	VJSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
23	VJAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
24	VJDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
25	VJDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
26	VJICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
27	VJICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
28	VJDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
29	VJFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
30	VJCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
31	VJPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
32	VJCO	Company	String	Generic Edit	5	0	Allow NULL?
33	VJGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
34	VJAID	Account ID	String	Generic Edit	8	0	Allow NULL?
35	VJPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
36	VJAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
37	VJPYR	Payor Address Number	Numeric	Generic Edit	8	0	Allow NULL?
38	VJPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
39	VJISTR	A/R Post Status	Character	Generic Edit	1	0	Allow NULL?
40	VJBALJ	Balanced - Journal Entries	Character	UDC (H00 BB)	1	0	Allow NULL?
41	VJPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
42	VJAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
43	VJAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
44	VJADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
45	VJADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
46	VJATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
47	VJATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
48	VJSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
49	VJCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
50	VJCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
51	VJCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
52	VJDMCD	Domestic Entry w/Mult Currency Distr	Character	Generic Edit	1	0	Allow NULL?
53	VJACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
54	VJFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
55	VJCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
56	VJCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
57	VJCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
58	VJCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
59	VJCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
60	VJTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
61	VJEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
62	VJDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
63	VJGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
64	VJAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
65	VJAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
66	VJAM2	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
67	VJMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
68	VJOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
69	VJSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
70	VJSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
71	VJSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
72	VJPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
73	VJDDJ	Date - Net Due	Date	Generic Edit	6	0
74	VJDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
75	VJRDDJ	Date of Last Sent Reminder	Date	Generic Edit	6	0
76	VJRDSJ	Date - Reminder Stop Until Date	Date	Generic Edit	6	0
77	VJSMTJ	Date - Statement	Date	Generic Edit	6	0
78	VJNBRR	Reminders - Number of Reminders to Send	Character	UDC (H00 NB)	1	0	Allow NULL?
79	VJRDRL	Level of Last Sent Reminder	Character	UDC	1	0	Allow NULL?
80	VJRMDS	Number of Sent Reminders - Total	Numeric	Generic Edit	3	0	Allow NULL?
81	VJCOLL	Collection Report (Y/N)	Character	UDC (H00 CO)	1	0	Allow NULL?
82	VJCORC	Collection Reason Code	String	UDC (03B CL)	2	0	Allow NULL?
83	VJAFC	Apply Finance Charges - Y/N	Character	UDC (H00 AF)	1	0	Allow NULL?
84	VJRSCO	Write-Off Reason Code	String	UDC (03B RC)	2	0	Allow NULL?
85	VJCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?
86	VJODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
87	VJODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
88	VJOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
89	VJOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
90	VJVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
91	VJPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
92	VJPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
93	VJPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
94	VJDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
95	VJLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
96	VJSDOC	Sales Document Number	Numeric	Generic Edit	8	0	Allow NULL?
97	VJSDCT	Sales Document Type	String	UDC (00 DT)	2	0	Allow NULL?
98	VJSKCO	Document Company (Sales Order)	String	Generic Edit	5	0	Allow NULL?
99	VJSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
100	VJVLDT	Date - Cleared/Value	Date	Generic Edit	6	0
101	VJCMC1	Commission Code 1	Numeric	Generic Edit	8	0	Allow NULL?
102	VJVR01	Reference	String	Generic Edit	25	0	Allow NULL?
103	VJUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
104	VJMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
105	VJRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
106	VJALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
107	VJRF	Frequency - Recurring	String	UDC (H00 RF)	2	0	Allow NULL?
108	VJDRF	Recurring Frequency # of Payments	Numeric	Generic Edit	3	0	Allow NULL?
109	VJCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
110	VJFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
111	VJITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
112	VJU	Units	Numeric	Generic Edit	15	2	Allow NULL?
113	VJUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
114	VJALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
115	VJRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
116	VJVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
117	VJVRE	Void Reason Code	String	UDC (03B VR)	3	0	Allow NULL?
118	VJRP1	A/R - A/P - Miscellaneous Code 1	Character	Generic Edit	1	0	Allow NULL?
119	VJRP2	A/R - A/P - Miscellaneous Code 2	Character	Generic Edit	1	0	Allow NULL?
120	VJRP3	A/R - A/P - Cash Rcpts/Inv Reg Code	Character	Generic Edit	1	0	Allow NULL?
121	VJAR01	A/R Reporting Code 1	String	UDC (01 01)	3	0	Allow NULL?
122	VJAR02	A/R Reporting Code 2	String	UDC (01 02)	3	0	Allow NULL?
123	VJAR03	A/R Reporting Code 3	String	UDC (01 03)	3	0	Allow NULL?
124	VJAR04	A/R Reporting Code 4	String	UDC (01 04)	3	0	Allow NULL?
125	VJAR05	A/R Reporting Code 5	String	UDC (01 05)	3	0	Allow NULL?
126	VJAR06	A/R Reporting Code 6	String	UDC (01 06)	3	0	Allow NULL?
127	VJAR07	A/R Reporting Code 7	String	UDC (01 07)	3	0	Allow NULL?
128	VJAR08	A/R Reporting Code 8	String	UDC (01 08)	3	0	Allow NULL?
129	VJAR09	A/R Reporting Code 9	String	UDC (01 09)	3	0	Allow NULL?
130	VJAR10	A/R Reporting Code 10	String	UDC (01 10)	3	0	Allow NULL?
131	VJURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
132	VJURDT	User Reserved Date	Date	Generic Edit	6	0
133	VJURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
134	VJURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
135	VJURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
136	VJTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
137	VJUSER	User ID	String	Generic Edit	10	0	Allow NULL?
138	VJPID	Program ID	String	Generic Edit	10	0	Allow NULL?
139	VJUPMJ	Date - Updated	Date	Generic Edit	6	0
140	VJUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
141	VJJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
142	VJHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
143	VJHDGJ	Historical Date - Julian	Date	Generic Edit	6	0
144	VJDIM	Date - Invoice - MO	Numeric	Generic Edit	2	0	Allow NULL?
145	VJDID	Date - Invoice - DA	Numeric	Generic Edit	2	0	Allow NULL?
146	VJDIY	Date - Invoice - YR	Numeric	Generic Edit	2	0	Allow NULL?
147	VJDI#	Date - Invoice - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
148	VJDGM	Date - For G/L (and Voucher) - MO	Numeric	Generic Edit	2	0	Allow NULL?
149	VJDGD	Date - For G/L (and Voucher) - DA	Numeric	Generic Edit	2	0	Allow NULL?
150	VJDGY	Date - For G/L (and Voucher) - YR	Numeric	Generic Edit	2	0	Allow NULL?
151	VJDG#	Date - For G/L (and Voucher) - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
152	VJDICM	Date - Batch - MO	Numeric	Generic Edit	2	0	Allow NULL?
153	VJDICD	Date - Batch - DA	Numeric	Generic Edit	2	0	Allow NULL?
154	VJDICY	Date - Batch - YR	Numeric	Generic Edit	2	0	Allow NULL?
155	VJDIC#	Date - Batch - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
156	VJDSVM	Date - Service/Tax - MO	Numeric	Generic Edit	2	0	Allow NULL?
157	VJDSVD	Date - Service/Tax - DA	Numeric	Generic Edit	2	0	Allow NULL?
158	VJDSVY	Date - Service/Tax - YR	Numeric	Generic Edit	2	0	Allow NULL?
159	VJDSV#	Date - Service/Tax - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
160	VJDDM	Date - Net Due - MO	Numeric	Generic Edit	2	0	Allow NULL?
161	VJDDD	Date - Net Due - DA	Numeric	Generic Edit	2	0	Allow NULL?
162	VJDDY	Date - Net Due - YR	Numeric	Generic Edit	2	0	Allow NULL?
163	VJDD#	Date - Net Due - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
164	VJDDNM	Date - Discount Due - MO	Numeric	Generic Edit	2	0	Allow NULL?
165	VJDDND	Date - Discount Due -DA	Numeric	Generic Edit	2	0	Allow NULL?
166	VJDDNY	Date - Discount Due - YR	Numeric	Generic Edit	2	0	Allow NULL?
167	VJDDN#	Date - Discount Due - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
168	VJSMTM	Date - Statement - MO	Numeric	Generic Edit	2	0	Allow NULL?
169	VJSMTD	Date - Statement - DA	Numeric	Generic Edit	2	0	Allow NULL?
170	VJSMTY	Date - Statement - YR	Numeric	Generic Edit	2	0	Allow NULL?
171	VJSMT#	Date - Statement - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
172	VJRDDM	Date of Last Sent Reminder - MO	Numeric	Generic Edit	2	0	Allow NULL?
173	VJRDDD	Date of Last Sent Reminder - DA	Numeric	Generic Edit	2	0	Allow NULL?
174	VJRDDY	Date of Last Sent Reminder - YR	Numeric	Generic Edit	2	0	Allow NULL?
175	VJRDD#	Date of Last Sent Reminder - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
176	VJRDSM	Date - Reminder Stop Until Date - MO	Numeric	Generic Edit	2	0	Allow NULL?
177	VJRDSD	Date - Reminder Stop Until Date - DA	Numeric	Generic Edit	2	0	Allow NULL?
178	VJRDSY	Date - Reminder Stop Until Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
179	VJRDS#	Date - Reminder Stop Until Date - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
180	VJHDGM	Historical Date - MO	Numeric	Generic Edit	2	0	Allow NULL?
181	VJHDGD	Historical Date - DA	Numeric	Generic Edit	2	0	Allow NULL?
182	VJHDGY	Historical Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
183	VJHDG#	Historical Date - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
184	VJSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
185	VJDTXS	Deferred Tax Status - VAT	Character	Generic Edit	1	0	Allow NULL?
186	VJOMOD	Originating System	Character	UDC (03B OS)	1	0	Allow NULL?
187	VJCLMG	Collection Manager	String	Generic Edit (01 CM)	10	0	Allow NULL?
188	VJCMGR	Credit Manager	String	UDC (01 CR)	10	0	Allow NULL?
189	VJATAD	Amount - To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
190	VJCTAD	Amount - Currency To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
191	VJNRTA	Non-Recoverable Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
192	VJFNRT	Foreign Non-Recoverable Tax	Numeric	Generic Edit	15	2	Allow NULL?
193	VJPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
194	VJGFL1	Generic Flag 1	Character	Generic Edit	1	0	Allow NULL?
195	VJGFL2	Generic Flag 2	Character	Generic Edit	1	0	Allow NULL?
196	VJDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
197	VJKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
198	VJSOTF	Sales Order Tax Flag	Character	Generic Edit	1	0	Allow NULL?
199	VJDTPB	Notification Payment Date	Date	Generic Edit	6	0
200	VJERDJ	Date - For Exchange Rate - Julian	Date	Generic Edit	6	0
201	VJNETST	Netting Status Code	Character	UDC (00 NS)	1	0	Allow NULL?
202	VJRMR1	Generic AR Receipt Matching Reference1	String	Generic Edit	50	0	Allow NULL?

TOP 812 | 03B | F03B11Z1 INDEXES

Number

Description

User 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

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

202 COLUMNS | 1 INDEXES | 812 | 03B | F03B11Z1 TABLE

TOP 812 | 03B | F03B11Z1 COLUMNS

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

202 COLUMNS | 1 INDEXES | 812 | 03B | F03B11Z1 TABLE

TOP812 | 03B | F03B11Z1 COLUMNS

TOP812 | 03B | F03B11Z1 INDEXES

TOP 812 | 03B | F03B11Z1 COLUMNS

TOP 812 | 03B | F03B11Z1 INDEXES