	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

221 COLUMNS | 1 INDEXES | 812 | 03 | F03012Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03: Accounts Receivable
1	812	F03012Z1	VO	221	1	Customer Master LOB-Batch File	Batch Input Files	01: Address Book	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 VOEDUS, VOEDBT, VOEDTN, VOEDLN, VOEDCT, VOTYTN, VOEDFT, VOEDDT, VODRIN, VOEDDL, VOEDSP, VOPNID, VOTNAC, VOAN8, VOCO, VOARC, VOMCUR, VOOBAR, VOAIDR, VOKCOR, VODCAR, VODTAR, VOCRCD, VOTXA1, VOEXR1, VOACL, VOHDAR, VOTRAR, VOSTTO, VORYIN, VOSTMT, VOARPY, VOATCS, VOSITO, VOSQNL, VOALGM, VOCYCN, VOBO, VOTSTA, VOCKHC, VODLC, VODNLT, VOPLCR, VORVDJ, VODSO, VOCMGR, VOCLMG, VODLQT, VODLQJ, VONBRR, VOCOLL, VONBR1, VONBR2, VONBR3, VONBCL, VOAFC, VOFD, VOFP, VOCFCE, VOAB2, VODT1J, VODFIJ, VODLIJ, VOABC1, VOABC2, VOABC3, VOFNDJ, VODLP, VODB, VODNBJ, VOTRW, VOTWDJ, VOAVD, VOCRCA, VOAD, VOAFCP, VOAFCY, VOASTY, VOSPYE, VOAHB, VOALP, VOABAM, VOABA1, VOAPRC, VOMAXO, VOMINO, VOOYTD, VOOPY, VOPOPN, VODAOJ, VOAN8R, VOBADT, VOCPGP, VOORTP, VOTRDC, VOINMG, VOEXHD, VOHOLD, VOROUT, VOSTOP, VOZON, VOCARS, VODEL1, VODEL2, VOLTDT, VOFRTH, VOAFT, VOAPTS, VOSBAL, VOBACK, VOPORQ, VOPRIO, VOARTO, VOINVC, VOICON, VOBLFR, VONIVD, VOLEDJ, VOPLST, VOMORD, VOCMC1, VOCMR1, VOCMC2, VOCMR2, VOPALC, VOVUMD, VOWUMD, VOEDPM, VOEDII, VOEDCI, VOEDQD, VOEDAD, VOEDF1, VOEDF2, VOSI01, VOSI02, VOSI03, VOSI04, VOSI05, VOCP01, VOASN, VODSPA, VOCRMD, VOPLY, VOMAN8, VOARL, VOAMCR, VOAC01, VOAC02, VOAC03, VOAC04, VOAC05, VOAC06, VOAC07, VOAC08, VOAC09, VOAC10, VOAC11, VOAC12, VOAC13, VOAC14, VOAC15, VOAC16, VOAC17, VOAC18, VOAC19, VOAC20, VOAC21, VOAC22, VOAC23, VOAC24, VOAC25, VOAC26, VOAC27, VOAC28, VOAC29, VOAC30, VOSLPG, VOSLDW, VOCFPP, VOCFSP, VOCFDF, VORQ01, VORQ02, VORQ03, VORQ04, VORQ05, VORQ06, VORQ07, VORQ08, VORQ09, VODR03, VODR04, VODR08, VODR09, VOURDT, VOURCD, VOURAT, VOURAB, VOURRF, VOTORG, VOUSER, VOPID, VOJOBN, VOUPMT, VOUPMJ, VOTDAY, VOPRGF, VOBYAL, VOBSC, VOASHL, VOPRSN, VOOPBO, VOAPSB, VOTIER1, VOPWPCP, VOCUSTS, VOSTOF, VOTERRID, VOCIG, VODTEE FROM F03012Z1

TOP 812 | 03 | F03012Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	VOEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	VOEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	VOEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	VOEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	VOEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	VOTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	VOEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	VOEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	VODRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	VOEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	VOEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	VOPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	VOTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	VOAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
15	VOCO	Company	String	Generic Edit	5	0	Allow NULL?
16	VOARC	G/L Offset	String	UDC (55 AR)	4	0	Allow NULL?
17	VOMCUR	Business Unit - A/R Default	String	Generic Edit	12	0	Allow NULL?
18	VOOBAR	Object - Accounts Receivable Default	String	Generic Edit	6	0	Allow NULL?
19	VOAIDR	Subsidiary - Accounts Receivable Default	String	Generic Edit	8	0	Allow NULL?
20	VOKCOR	Document Company (A/R Model Document)	String	Generic Edit	5	0	Allow NULL?
21	VODCAR	Document - A/R Default for Model JE	Numeric	Generic Edit	8	0	Allow NULL?
22	VODTAR	Document Type - A/R Default for Model JE	String	UDC (00 DT)	2	0	Allow NULL?
23	VOCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
24	VOTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
25	VOEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
26	VOACL	Amount - Credit Limit	Numeric	Generic Edit	15	0	Allow NULL?
27	VOHDAR	Hold Invoices	Character	UDC (H01 HC)	1	0	Allow NULL?
28	VOTRAR	Payment Terms - A/R	String	Generic Edit	3	0	Allow NULL?
29	VOSTTO	Send Statement to C/P	Character	UDC (H00 SV)	1	0	Allow NULL?
30	VORYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
31	VOSTMT	Print Statement Y/N	Character	UDC (H03 ST)	1	0	Allow NULL?
32	VOARPY	Alternate Payor	Numeric	Generic Edit	8	0	Allow NULL?
33	VOATCS	Auto Receipt (Y/N)	Character	Generic Edit	1	0	Allow NULL?
34	VOSITO	Send Invoice to C/P	Character	UDC (H00 SI)	1	0	Allow NULL?
35	VOSQNL	Ledger Inquiry Sequence	Character	UDC (H01 SQ)	1	0	Allow NULL?
36	VOALGM	Auto Receipt Algorithm Method	String	UDC (01 AA)	2	0	Allow NULL?
37	VOCYCN	Statement Cycle	String	Generic Edit	2	0	Allow NULL?
38	VOBO	Balance Forward-Open Item	Character	UDC (H03 BO)	1	0	Allow NULL?
39	VOTSTA	Temporary Credit Message	String	UDC (00 CM)	2	0	Allow NULL?
40	VOCKHC	Credit Check Handling Code	Character	Generic Edit	1	0	Allow NULL?
41	VODLC	Date - Last Credit Review	Date	Generic Edit	6	0
42	VODNLT	Delinquency Notice (Y/N)	Character	Generic Edit	1	0	Allow NULL?
43	VOPLCR	Person Completing Last Credit Limit Rev	String	Generic Edit	10	0	Allow NULL?
44	VORVDJ	Date - Recall for Review	Date	Generic Edit	6	0
45	VODSO	Days Sales Outstanding	Numeric	Generic Edit	5	0	Allow NULL?
46	VOCMGR	Credit Manager	String	UDC (01 CR)	10	0	Allow NULL?
47	VOCLMG	Collection Manager	String	Generic Edit (01 CM)	10	0	Allow NULL?
48	VODLQT	Dunning Letters - Number Sent	Numeric	Generic Edit	3	0	Allow NULL?
49	VODLQJ	Date - Last Dunning Letter	Date	Generic Edit	6	0
50	VONBRR	Reminders - Number of Reminders to Send	Character	UDC (H00 NB)	1	0	Allow NULL?
51	VOCOLL	Collection Report (Y/N)	Character	UDC (H00 CO)	1	0	Allow NULL?
52	VONBR1	Number of Sent Reminders - 1	Numeric	Generic Edit	3	0	Allow NULL?
53	VONBR2	Number of Sent Reminders - 2	Numeric	Generic Edit	3	0	Allow NULL?
54	VONBR3	Number of Sent Reminders - 3	Numeric	Generic Edit	3	0	Allow NULL?
55	VONBCL	Number of Invoices to Collection Report	Numeric	Generic Edit	3	0	Allow NULL?
56	VOAFC	Apply Finance Charges - Y/N	Character	UDC (H00 AF)	1	0	Allow NULL?
57	VOFD	Finance Charge Days	Numeric	Generic Edit	3	0	Allow NULL?
58	VOFP	Percentage Factor	Numeric	Generic Edit	9	6	Allow NULL?
59	VOCFCE	Finance Charge - Create Entries Y/N	Character	Generic Edit	1	0	Allow NULL?
60	VOAB2	Address Book - Pending Cash Receipts	Character	Generic Edit	1	0	Allow NULL?
61	VODT1J	Date - Last Statement Date	Date	Generic Edit	6	0
62	VODFIJ	Date - First Invoice	Date	Generic Edit	6	0
63	VODLIJ	Date - Last Invoice (Julian)	Date	Generic Edit	6	0
64	VOABC1	ABC Code Sales	Character	UDC (H01 A1)	1	0	Allow NULL?
65	VOABC2	ABC Code 2 - Investment - Inventory	Character	UDC (H01 A2)	1	0	Allow NULL?
66	VOABC3	ABC Code Average Days	Character	UDC (H01 A3)	1	0	Allow NULL?
67	VOFNDJ	Date - Financial Stmts on Hand	Date	Generic Edit	6	0
68	VODLP	Date - Last Paid	Date	Generic Edit	6	0
69	VODB	Dun & Bradstreet Rating	String	UDC (01 DB)	3	0	Allow NULL?
70	VODNBJ	Date - Dun & Bradstreet	Date	Generic Edit	6	0
71	VOTRW	TRW Rating	String	UDC (01 TR)	3	0	Allow NULL?
72	VOTWDJ	TRW Date	Date	Generic Edit	6	0
73	VOAVD	Average Days Late	Numeric	Generic Edit	3	0	Allow NULL?
74	VOCRCA	Currency Code - A/B Amounts	String	Generic Edit	3	0	Allow NULL?
75	VOAD	Amount - Due	Numeric	Generic Edit	15	2	Allow NULL?
76	VOAFCP	Amount - Prior Year Finance Charges	Numeric	Generic Edit	15	2	Allow NULL?
77	VOAFCY	Amount - YTD Finance Charges	Numeric	Generic Edit	15	2	Allow NULL?
78	VOASTY	Amount - Invoiced This Year	Numeric	Generic Edit	15	2	Allow NULL?
79	VOSPYE	Amount - Invoiced Prior Year	Numeric	Generic Edit	15	2	Allow NULL?
80	VOAHB	Amount - High Balance	Numeric	Generic Edit	15	2	Allow NULL?
81	VOALP	Amount - Last Applied	Numeric	Generic Edit	15	2	Allow NULL?
82	VOABAM	Amount - Address Book	Numeric	Generic Edit	15	2	Allow NULL?
83	VOABA1	Amount - Address Book	Numeric	Generic Edit	15	2	Allow NULL?
84	VOAPRC	Amount - Open Order	Numeric	Generic Edit	15	2	Allow NULL?
85	VOMAXO	Maximum Order Value	Numeric	Generic Edit	15	0	Allow NULL?
86	VOMINO	Minimum Order Value	Numeric	Generic Edit	15	0	Allow NULL?
87	VOOYTD	Orders - Year-to-Date	Numeric	Generic Edit	3	0	Allow NULL?
88	VOOPY	Orders - Prior Year	Numeric	Generic Edit	3	0	Allow NULL?
89	VOPOPN	Person Opening Account	String	Generic Edit	10	0	Allow NULL?
90	VODAOJ	Date - Account Opened	Date	Generic Edit	6	0
91	VOAN8R	Related - Address Number	Numeric	Generic Edit	8	0	Allow NULL?
92	VOBADT	Billing Address Type	Character	UDC (H42 BA)	1	0	Allow NULL?
93	VOCPGP	Customer Price Group	String	UDC (40 PC)	8	0	Allow NULL?
94	VOORTP	Order Template	String	UDC (40 OT)	8	0	Allow NULL?
95	VOTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
96	VOINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
97	VOEXHD	Credit Hold Exempt	Character	Generic Edit	1	0	Allow NULL?
98	VOHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
99	VOROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
100	VOSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
101	VOZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
102	VOCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
103	VODEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
104	VODEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
105	VOLTDT	Transit Days	Numeric	Generic Edit	5	0	Allow NULL?
106	VOFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
107	VOAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
108	VOAPTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
109	VOSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
110	VOBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
111	VOPORQ	Customer PO Required (Y/N)	Character	Generic Edit	1	0	Allow NULL?
112	VOPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
113	VOARTO	Credit Check Level	Character	UDC (H42 AR)	1	0	Allow NULL?
114	VOINVC	Invoice Copies	Numeric	Generic Edit	2	0	Allow NULL?
115	VOICON	Invoice Consolidation	Character	Generic Edit	1	0	Allow NULL?
116	VOBLFR	Billing Frequency	Character	UDC (H42 BL)	1	0	Allow NULL?
117	VONIVD	Next Invoice Date	Date	Generic Edit	6	0
118	VOLEDJ	Date - License Expiration	Date	Generic Edit	6	0
119	VOPLST	Price Pick List (Y/N)	Character	Generic Edit	1	0	Allow NULL?
120	VOMORD	Merge Orders (Y/N)	Character	Generic Edit	1	0	Allow NULL?
121	VOCMC1	Commission Code 1	Numeric	Generic Edit	8	0	Allow NULL?
122	VOCMR1	Rate - Commission 1	Numeric	Generic Edit	7	3	Allow NULL?
123	VOCMC2	Commission Code 2	Numeric	Generic Edit	8	0	Allow NULL?
124	VOCMR2	Rate - Commission 2	Numeric	Generic Edit	7	3	Allow NULL?
125	VOPALC	Pallet Control	Character	Generic Edit	1	0	Allow NULL?
126	VOVUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
127	VOWUMD	Unit of Measure - Weight Display	String	UDC (00 UM)	2	0	Allow NULL?
128	VOEDPM	Batch Processing Mode	Character	UDC (H40 EE)	1	0	Allow NULL?
129	VOEDII	Item Type Identifier	Character	UDC (40 II)	1	0	Allow NULL?
130	VOEDCI	Customer Type Identifier	Character	UDC (40 CI)	1	0	Allow NULL?
131	VOEDQD	Quantity Decimals	Numeric	Generic Edit	1	0	Allow NULL?
132	VOEDAD	Amount Decimals	Numeric	Generic Edit	1	0	Allow NULL?
133	VOEDF1	Delivery Note	Character	Generic Edit	1	0	Allow NULL?
134	VOEDF2	Item Restrictions	Character	UDC (H40 ED)	1	0	Allow NULL?
135	VOSI01	Partial Order Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
136	VOSI02	COA Print (Y/N)	Character	Generic Edit	1	0	Allow NULL?
137	VOSI03	Override Territory Id Assignment	Character	Generic Edit	1	0	Allow NULL?
138	VOSI04	Special Instruction 04	Character	Generic Edit	1	0	Allow NULL?
139	VOSI05	Special Instruction 05	Character	Generic Edit	1	0	Allow NULL?
140	VOCP01	Sales Price Based On Date	Character	UDC (40 DB)	1	0	Allow NULL?
141	VOASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
142	VODSPA	Print Adjustments on Invoice (Y/N)	Character	Generic Edit	1	0	Allow NULL?
143	VOCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
144	VOPLY	Policy Number (Internal)	Numeric	Generic Edit	5	0	Allow NULL?
145	VOMAN8	Deduction Manager	Numeric	Generic Edit	8	0	Allow NULL?
146	VOARL	Auto Receipts Execution List	String	Generic Edit	10	0	Allow NULL?
147	VOAMCR	Administration Credit Limit	Numeric	Generic Edit	15	0	Allow NULL?
148	VOAC01	Category Code - Address Book 01	String	UDC (01 01)	3	0	Allow NULL?
149	VOAC02	Category Code - Address Book 02	String	UDC (01 02)	3	0	Allow NULL?
150	VOAC03	Category Code - Address Book 03	String	UDC (01 03)	3	0	Allow NULL?
151	VOAC04	Category Code - Address Book 04	String	UDC (01 04)	3	0	Allow NULL?
152	VOAC05	Category Code - Address Book 05	String	UDC (01 05)	3	0	Allow NULL?
153	VOAC06	Category Code - Address Book 06	String	UDC (01 06)	3	0	Allow NULL?
154	VOAC07	Category Code - Address Book 07	String	UDC (01 07)	3	0	Allow NULL?
155	VOAC08	Category Code - Address Book 08	String	UDC (01 08)	3	0	Allow NULL?
156	VOAC09	Address Book 09 - Country Type	String	UDC (01 09)	3	0	Allow NULL?
157	VOAC10	Address Book 10 - Nature of the Trade	String	UDC (01 10)	3	0	Allow NULL?
158	VOAC11	Address Book 11 - Discount Group	String	UDC (01 11)	3	0	Allow NULL?
159	VOAC12	Category Code - Address Book 12	String	UDC (01 12)	3	0	Allow NULL?
160	VOAC13	Category Code - Address Book 13	String	UDC (01 13)	3	0	Allow NULL?
161	VOAC14	Category Code - Address Book 14	String	UDC (01 14)	3	0	Allow NULL?
162	VOAC15	Category Code - Address Book 15	String	UDC (01 15)	3	0	Allow NULL?
163	VOAC16	Category Code - Address Book 16	String	UDC (01 16)	3	0	Allow NULL?
164	VOAC17	Category Code - Address Book 17	String	UDC (01 17)	3	0	Allow NULL?
165	VOAC18	Category Code - Address Book 18	String	UDC (01 18)	3	0	Allow NULL?
166	VOAC19	Category Code - Address Book 19	String	UDC (01 19)	3	0	Allow NULL?
167	VOAC20	Category Code - Address Book 20	String	UDC (01 20)	3	0	Allow NULL?
168	VOAC21	Category Code - Address Book 21	String	UDC (01 21)	3	0	Allow NULL?
169	VOAC22	Category Code - Address Book 22	String	UDC (01 22)	3	0	Allow NULL?
170	VOAC23	Category Code - Address Book 23	String	UDC (01 23)	3	0	Allow NULL?
171	VOAC24	Category Code - Address Book 24	String	UDC (01 24)	3	0	Allow NULL?
172	VOAC25	Category Code - Address Book 25	String	UDC (01 25)	3	0	Allow NULL?
173	VOAC26	Category Code - Address Book 26	String	UDC (01 26)	3	0	Allow NULL?
174	VOAC27	Category Code - Address Book 27	String	UDC (01 27)	3	0	Allow NULL?
175	VOAC28	Category Code - Address Book 28	String	UDC (01 28)	3	0	Allow NULL?
176	VOAC29	Category Code - Address Book 29	String	UDC (01 29)	3	0	Allow NULL?
177	VOAC30	Category Code - Address Book 30	String	UDC (01 30)	3	0	Allow NULL?
178	VOSLPG	Program Name - Shipping Labels	String	Generic Edit	10	0	Allow NULL?
179	VOSLDW	Version Name - Shipping Label Program	String	Generic Edit	10	0	Allow NULL?
180	VOCFPP	Configuration Pick and Pack	String	Generic Edit	18	0	Allow NULL?
181	VOCFSP	Configuration Standard Carton Pack	String	Generic Edit	18	0	Allow NULL?
182	VOCFDF	Default Configuration	Character	Generic Edit	1	0	Allow NULL?
183	VORQ01	Requires Packaging Code	Character	Generic Edit	1	0	Allow NULL?
184	VORQ02	Requires Weight Code	Character	Generic Edit	1	0	Allow NULL?
185	VORQ03	Requires Identification - Code 1	Character	Generic Edit	1	0	Allow NULL?
186	VORQ04	Requires Identification - Code 2	Character	Generic Edit	1	0	Allow NULL?
187	VORQ05	Requires Transportation Method	Character	Generic Edit	1	0	Allow NULL?
188	VORQ06	Requires Routing	Character	Generic Edit	1	0	Allow NULL?
189	VORQ07	Requires Equipment	Character	Generic Edit	1	0	Allow NULL?
190	VORQ08	Requires Reference Number 1	Character	Generic Edit	1	0	Allow NULL?
191	VORQ09	Requires Reference Number 2	Character	Generic Edit	1	0	Allow NULL?
192	VODR03	Default Identification Code Qualifier 1	String	UDC (41 X3)	2	0	Allow NULL?
193	VODR04	Default Identification Code Qualifier 2	String	UDC (41 X3)	2	0	Allow NULL?
194	VODR08	Default Reference Number Qualifier 1	String	UDC (41 X6)	2	0	Allow NULL?
195	VODR09	Default Identification Code Qualifier	String	UDC (41 X6)	2	0	Allow NULL?
196	VOURDT	User Reserved Date	Date	Generic Edit	6	0
197	VOURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
198	VOURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
199	VOURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
200	VOURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
201	VOTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
202	VOUSER	User ID	String	Generic Edit	10	0	Allow NULL?
203	VOPID	Program ID	String	Generic Edit	10	0	Allow NULL?
204	VOJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
205	VOUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
206	VOUPMJ	Date - Updated	Date	Generic Edit	6	0
207	VOTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
208	VOPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
209	VOBYAL	Bypass Audit Logging	Character	Generic Edit	1	0	Allow NULL?
210	VOBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
211	VOASHL	Allow Shipping of Held Lots	Character	Generic Edit	1	0	Allow NULL?
212	VOPRSN	Preference Schedule	String	Generic Edit	8	0	Allow NULL?
213	VOOPBO	OP Business Objective	String	UDC (34A BO)	30	0	Allow NULL?
214	VOAPSB	APS Business Unit	Character	Generic Edit	1	0	Allow NULL?
215	VOTIER1	Tier	String	UDC (01 TI)	5	0	Allow NULL?
216	VOPWPCP	Pay When Paid Cash Receipt Threshold	Numeric	Generic Edit	5	0	Allow NULL?
217	VOCUSTS	Customer Status	Character	UDC (01 TY)	1	0	Allow NULL?
218	VOSTOF	Override Sales Team Assignment	Character	Generic Edit	1	0	Allow NULL?
219	VOTERRID	Territory Id	Numeric	Generic Edit	15	0	Allow NULL?
220	VOCIG	Industry Group	Numeric	Generic Edit	15	0	Allow NULL?
221	VODTEE	Date - Entered	JDE UTime	Generic Edit	11	0

TOP 812 | 03 | F03012Z1 INDEXES

Number

Description

User Batch# + (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

221 COLUMNS | 1 INDEXES | 812 | 03 | F03012Z1 TABLE

TOP 812 | 03 | F03012Z1 COLUMNS

TOP 812 | 03 | F03012Z1 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

221 COLUMNS | 1 INDEXES | 812 | 03 | F03012Z1 TABLE

TOP812 | 03 | F03012Z1 COLUMNS

TOP812 | 03 | F03012Z1 INDEXES

TOP 812 | 03 | F03012Z1 COLUMNS

TOP 812 | 03 | F03012Z1 INDEXES