JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4211SDSales Order Detail File
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

221 COLUMNS | 1 INDEXES | Print definition?812 | 03 | F03012Z1 TABLE

03: Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F03012Z1VO2211Customer Master LOB-Batch FileBatch Input Files01: Address BookNo
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

TOP812 | 03 | F03012Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1VOEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2VOEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3VOEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4VOEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5VOEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6VOTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7VOEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8VOEDDTEDI - Transmission DateDateGeneric Edit60
9VODRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10VOEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11VOEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12VOPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13VOTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14VOAN8Address NumberNumericUDC80 Allow NULL? 
15VOCOCompanyStringGeneric Edit50 Allow NULL? 
16VOARCG/L OffsetStringUDC (55 AR)40 Allow NULL? 
17VOMCURBusiness Unit - A/R DefaultStringGeneric Edit120 Allow NULL? 
18VOOBARObject - Accounts Receivable DefaultStringGeneric Edit60 Allow NULL? 
19VOAIDRSubsidiary - Accounts Receivable DefaultStringGeneric Edit80 Allow NULL? 
20VOKCORDocument Company (A/R Model Document)StringGeneric Edit50 Allow NULL? 
21VODCARDocument - A/R Default for Model JENumericGeneric Edit80 Allow NULL? 
22VODTARDocument Type - A/R Default for Model JEStringUDC (00 DT)20 Allow NULL? 
23VOCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
24VOTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
25VOEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
26VOACLAmount - Credit LimitNumericGeneric Edit150 Allow NULL? 
27VOHDARHold InvoicesCharacterUDC (H01 HC)10 Allow NULL? 
28VOTRARPayment Terms - A/RStringGeneric Edit30 Allow NULL? 
29VOSTTOSend Statement to C/PCharacterUDC (H00 SV)10 Allow NULL? 
30VORYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
31VOSTMTPrint Statement Y/NCharacterUDC (H03 ST)10 Allow NULL? 
32VOARPYAlternate PayorNumericGeneric Edit80 Allow NULL? 
33VOATCSAuto Receipt (Y/N)CharacterGeneric Edit10 Allow NULL? 
34VOSITOSend Invoice to C/PCharacterUDC (H00 SI)10 Allow NULL? 
35VOSQNLLedger Inquiry SequenceCharacterUDC (H01 SQ)10 Allow NULL? 
36VOALGMAuto Receipt Algorithm MethodStringUDC (01 AA)20 Allow NULL? 
37VOCYCNStatement CycleStringGeneric Edit20 Allow NULL? 
38VOBOBalance Forward-Open ItemCharacterUDC (H03 BO)10 Allow NULL? 
39VOTSTATemporary Credit MessageStringUDC (00 CM)20 Allow NULL? 
40VOCKHCCredit Check Handling CodeCharacterGeneric Edit10 Allow NULL? 
41VODLCDate - Last Credit ReviewDateGeneric Edit60
42VODNLTDelinquency Notice (Y/N)CharacterGeneric Edit10 Allow NULL? 
43VOPLCRPerson Completing Last Credit Limit RevStringGeneric Edit100 Allow NULL? 
44VORVDJDate - Recall for ReviewDateGeneric Edit60
45VODSODays Sales OutstandingNumericGeneric Edit50 Allow NULL? 
46VOCMGRCredit ManagerStringUDC (01 CR)100 Allow NULL? 
47VOCLMGCollection ManagerStringGeneric Edit (01 CM)100 Allow NULL? 
48VODLQTDunning Letters - Number SentNumericGeneric Edit30 Allow NULL? 
49VODLQJDate - Last Dunning LetterDateGeneric Edit60
50VONBRRReminders - Number of Reminders to SendCharacterUDC (H00 NB)10 Allow NULL? 
51VOCOLLCollection Report (Y/N)CharacterUDC (H00 CO)10 Allow NULL? 
52VONBR1Number of Sent Reminders - 1NumericGeneric Edit30 Allow NULL? 
53VONBR2Number of Sent Reminders - 2NumericGeneric Edit30 Allow NULL? 
54VONBR3Number of Sent Reminders - 3NumericGeneric Edit30 Allow NULL? 
55VONBCLNumber of Invoices to Collection ReportNumericGeneric Edit30 Allow NULL? 
56VOAFCApply Finance Charges - Y/NCharacterUDC (H00 AF)10 Allow NULL? 
57VOFDFinance Charge DaysNumericGeneric Edit30 Allow NULL? 
58VOFPPercentage FactorNumericGeneric Edit96 Allow NULL? 
59VOCFCEFinance Charge - Create Entries Y/NCharacterGeneric Edit10 Allow NULL? 
60VOAB2Address Book - Pending Cash ReceiptsCharacterGeneric Edit10 Allow NULL? 
61VODT1JDate - Last Statement DateDateGeneric Edit60
62VODFIJDate - First InvoiceDateGeneric Edit60
63VODLIJDate - Last Invoice (Julian)DateGeneric Edit60
64VOABC1ABC Code SalesCharacterUDC (H01 A1)10 Allow NULL? 
65VOABC2ABC Code 2 - Investment - InventoryCharacterUDC (H01 A2)10 Allow NULL? 
66VOABC3ABC Code Average DaysCharacterUDC (H01 A3)10 Allow NULL? 
67VOFNDJDate - Financial Stmts on HandDateGeneric Edit60
68VODLPDate - Last PaidDateGeneric Edit60
69VODBDun & Bradstreet RatingStringUDC (01 DB)30 Allow NULL? 
70VODNBJDate - Dun & BradstreetDateGeneric Edit60
71VOTRWTRW RatingStringUDC (01 TR)30 Allow NULL? 
72VOTWDJTRW DateDateGeneric Edit60
73VOAVDAverage Days LateNumericGeneric Edit30 Allow NULL? 
74VOCRCACurrency Code - A/B AmountsStringGeneric Edit30 Allow NULL? 
75VOADAmount - DueNumericGeneric Edit152 Allow NULL? 
76VOAFCPAmount - Prior Year Finance ChargesNumericGeneric Edit152 Allow NULL? 
77VOAFCYAmount - YTD Finance ChargesNumericGeneric Edit152 Allow NULL? 
78VOASTYAmount - Invoiced This YearNumericGeneric Edit152 Allow NULL? 
79VOSPYEAmount - Invoiced Prior YearNumericGeneric Edit152 Allow NULL? 
80VOAHBAmount - High BalanceNumericGeneric Edit152 Allow NULL? 
81VOALPAmount - Last AppliedNumericGeneric Edit152 Allow NULL? 
82VOABAMAmount - Address BookNumericGeneric Edit152 Allow NULL? 
83VOABA1Amount - Address BookNumericGeneric Edit152 Allow NULL? 
84VOAPRCAmount - Open OrderNumericGeneric Edit152 Allow NULL? 
85VOMAXOMaximum Order ValueNumericGeneric Edit150 Allow NULL? 
86VOMINOMinimum Order ValueNumericGeneric Edit150 Allow NULL? 
87VOOYTDOrders - Year-to-DateNumericGeneric Edit30 Allow NULL? 
88VOOPYOrders - Prior YearNumericGeneric Edit30 Allow NULL? 
89VOPOPNPerson Opening AccountStringGeneric Edit100 Allow NULL? 
90VODAOJDate - Account OpenedDateGeneric Edit60
91VOAN8RRelated - Address NumberNumericGeneric Edit80 Allow NULL? 
92VOBADTBilling Address TypeCharacterUDC (H42 BA)10 Allow NULL? 
93VOCPGPCustomer Price GroupStringUDC (40 PC)80 Allow NULL? 
94VOORTPOrder TemplateStringUDC (40 OT)80 Allow NULL? 
95VOTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
96VOINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
97VOEXHDCredit Hold ExemptCharacterGeneric Edit10 Allow NULL? 
98VOHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
99VOROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
100VOSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
101VOZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
102VOCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
103VODEL1Delivery Instructions Line 1StringGeneric Edit300 Allow NULL? 
104VODEL2Delivery Instructions Line 2StringGeneric Edit300 Allow NULL? 
105VOLTDTTransit DaysNumericGeneric Edit50 Allow NULL? 
106VOFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
107VOAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
108VOAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
109VOSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
110VOBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
111VOPORQCustomer PO Required (Y/N)CharacterGeneric Edit10 Allow NULL? 
112VOPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
113VOARTOCredit Check LevelCharacterUDC (H42 AR)10 Allow NULL? 
114VOINVCInvoice CopiesNumericGeneric Edit20 Allow NULL? 
115VOICONInvoice ConsolidationCharacterGeneric Edit10 Allow NULL? 
116VOBLFRBilling FrequencyCharacterUDC (H42 BL)10 Allow NULL? 
117VONIVDNext Invoice DateDateGeneric Edit60
118VOLEDJDate - License ExpirationDateGeneric Edit60
119VOPLSTPrice Pick List (Y/N)CharacterGeneric Edit10 Allow NULL? 
120VOMORDMerge Orders (Y/N)CharacterGeneric Edit10 Allow NULL? 
121VOCMC1Commission Code 1NumericGeneric Edit80 Allow NULL? 
122VOCMR1Rate - Commission 1NumericGeneric Edit73 Allow NULL? 
123VOCMC2Commission Code 2NumericGeneric Edit80 Allow NULL? 
124VOCMR2Rate - Commission 2NumericGeneric Edit73 Allow NULL? 
125VOPALCPallet ControlCharacterGeneric Edit10 Allow NULL? 
126VOVUMDUnit of Measure - Volume DisplayStringUDC (00 UM)20 Allow NULL? 
127VOWUMDUnit of Measure - Weight DisplayStringUDC (00 UM)20 Allow NULL? 
128VOEDPMBatch Processing ModeCharacterUDC (H40 EE)10 Allow NULL? 
129VOEDIIItem Type IdentifierCharacterUDC (40 II)10 Allow NULL? 
130VOEDCICustomer Type IdentifierCharacterUDC (40 CI)10 Allow NULL? 
131VOEDQDQuantity DecimalsNumericGeneric Edit10 Allow NULL? 
132VOEDADAmount DecimalsNumericGeneric Edit10 Allow NULL? 
133VOEDF1Delivery NoteCharacterGeneric Edit10 Allow NULL? 
134VOEDF2Item RestrictionsCharacterUDC (H40 ED)10 Allow NULL? 
135VOSI01Partial Order Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
136VOSI02COA Print (Y/N)CharacterGeneric Edit10 Allow NULL? 
137VOSI03Override Territory Id AssignmentCharacterGeneric Edit10 Allow NULL? 
138VOSI04Special Instruction 04CharacterGeneric Edit10 Allow NULL? 
139VOSI05Special Instruction 05CharacterGeneric Edit10 Allow NULL? 
140VOCP01Sales Price Based On DateCharacterUDC (40 DB)10 Allow NULL? 
141VOASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
142VODSPAPrint Adjustments on Invoice (Y/N)CharacterGeneric Edit10 Allow NULL? 
143VOCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
144VOPLYPolicy Number (Internal)NumericGeneric Edit50 Allow NULL? 
145VOMAN8Deduction ManagerNumericGeneric Edit80 Allow NULL? 
146VOARLAuto Receipts Execution ListStringGeneric Edit100 Allow NULL? 
147VOAMCRAdministration Credit LimitNumericGeneric Edit150 Allow NULL? 
148VOAC01Category Code - Address Book 01StringUDC (01 01)30 Allow NULL? 
149VOAC02Category Code - Address Book 02StringUDC (01 02)30 Allow NULL? 
150VOAC03Category Code - Address Book 03StringUDC (01 03)30 Allow NULL? 
151VOAC04Category Code - Address Book 04StringUDC (01 04)30 Allow NULL? 
152VOAC05Category Code - Address Book 05StringUDC (01 05)30 Allow NULL? 
153VOAC06Category Code - Address Book 06StringUDC (01 06)30 Allow NULL? 
154VOAC07Category Code - Address Book 07StringUDC (01 07)30 Allow NULL? 
155VOAC08Category Code - Address Book 08StringUDC (01 08)30 Allow NULL? 
156VOAC09Address Book 09 - Country TypeStringUDC (01 09)30 Allow NULL? 
157VOAC10Address Book 10 - Nature of the TradeStringUDC (01 10)30 Allow NULL? 
158VOAC11Address Book 11 - Discount GroupStringUDC (01 11)30 Allow NULL? 
159VOAC12Category Code - Address Book 12StringUDC (01 12)30 Allow NULL? 
160VOAC13Category Code - Address Book 13StringUDC (01 13)30 Allow NULL? 
161VOAC14Category Code - Address Book 14StringUDC (01 14)30 Allow NULL? 
162VOAC15Category Code - Address Book 15StringUDC (01 15)30 Allow NULL? 
163VOAC16Category Code - Address Book 16StringUDC (01 16)30 Allow NULL? 
164VOAC17Category Code - Address Book 17StringUDC (01 17)30 Allow NULL? 
165VOAC18Category Code - Address Book 18StringUDC (01 18)30 Allow NULL? 
166VOAC19Category Code - Address Book 19StringUDC (01 19)30 Allow NULL? 
167VOAC20Category Code - Address Book 20StringUDC (01 20)30 Allow NULL? 
168VOAC21Category Code - Address Book 21StringUDC (01 21)30 Allow NULL? 
169VOAC22Category Code - Address Book 22StringUDC (01 22)30 Allow NULL? 
170VOAC23Category Code - Address Book 23StringUDC (01 23)30 Allow NULL? 
171VOAC24Category Code - Address Book 24StringUDC (01 24)30 Allow NULL? 
172VOAC25Category Code - Address Book 25StringUDC (01 25)30 Allow NULL? 
173VOAC26Category Code - Address Book 26StringUDC (01 26)30 Allow NULL? 
174VOAC27Category Code - Address Book 27StringUDC (01 27)30 Allow NULL? 
175VOAC28Category Code - Address Book 28StringUDC (01 28)30 Allow NULL? 
176VOAC29Category Code - Address Book 29StringUDC (01 29)30 Allow NULL? 
177VOAC30Category Code - Address Book 30StringUDC (01 30)30 Allow NULL? 
178VOSLPGProgram Name - Shipping LabelsStringGeneric Edit100 Allow NULL? 
179VOSLDWVersion Name - Shipping Label ProgramStringGeneric Edit100 Allow NULL? 
180VOCFPPConfiguration Pick and PackStringGeneric Edit180 Allow NULL? 
181VOCFSPConfiguration Standard Carton PackStringGeneric Edit180 Allow NULL? 
182VOCFDFDefault ConfigurationCharacterGeneric Edit10 Allow NULL? 
183VORQ01Requires Packaging CodeCharacterGeneric Edit10 Allow NULL? 
184VORQ02Requires Weight CodeCharacterGeneric Edit10 Allow NULL? 
185VORQ03Requires Identification - Code 1CharacterGeneric Edit10 Allow NULL? 
186VORQ04Requires Identification - Code 2CharacterGeneric Edit10 Allow NULL? 
187VORQ05Requires Transportation MethodCharacterGeneric Edit10 Allow NULL? 
188VORQ06Requires RoutingCharacterGeneric Edit10 Allow NULL? 
189VORQ07Requires EquipmentCharacterGeneric Edit10 Allow NULL? 
190VORQ08Requires Reference Number 1CharacterGeneric Edit10 Allow NULL? 
191VORQ09Requires Reference Number 2CharacterGeneric Edit10 Allow NULL? 
192VODR03Default Identification Code Qualifier 1StringUDC (41 X3)20 Allow NULL? 
193VODR04Default Identification Code Qualifier 2StringUDC (41 X3)20 Allow NULL? 
194VODR08Default Reference Number Qualifier 1StringUDC (41 X6)20 Allow NULL? 
195VODR09Default Identification Code QualifierStringUDC (41 X6)20 Allow NULL? 
196VOURDTUser Reserved DateDateGeneric Edit60
197VOURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
198VOURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
199VOURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
200VOURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
201VOTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
202VOUSERUser IDStringGeneric Edit100 Allow NULL? 
203VOPIDProgram IDStringGeneric Edit100 Allow NULL? 
204VOJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
205VOUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
206VOUPMJDate - UpdatedDateGeneric Edit60
207VOTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
208VOPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
209VOBYALBypass Audit LoggingCharacterGeneric Edit10 Allow NULL? 
210VOBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
211VOASHLAllow Shipping of Held LotsCharacterGeneric Edit10 Allow NULL? 
212VOPRSNPreference ScheduleStringGeneric Edit80 Allow NULL? 
213VOOPBOOP Business ObjectiveStringUDC (34A BO)300 Allow NULL? 
214VOAPSBAPS Business UnitCharacterGeneric Edit10 Allow NULL? 
215VOTIER1TierStringUDC (01 TI)50 Allow NULL? 
216VOPWPCPPay When Paid Cash Receipt ThresholdNumericGeneric Edit50 Allow NULL? 
217VOCUSTSCustomer StatusCharacterUDC (01 TY)10 Allow NULL? 
218VOSTOFOverride Sales Team AssignmentCharacterGeneric Edit10 Allow NULL? 
219VOTERRIDTerritory IdNumericGeneric Edit150 Allow NULL? 
220VOCIGIndustry GroupNumericGeneric Edit150 Allow NULL? 
221VODTEEDate - EnteredJDE UTimeGeneric Edit110

TOP812 | 03 | F03012Z1 INDEXES

NumberDescription
1User Batch# + (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending