JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

193 COLUMNS | 4 INDEXES | Print definition?920 | 09 | F0911Z1 TABLE

09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0911Z1VN1934Journal Entry Transactions - Batch FileBatch Input Files09: General AccountingBusiness Data
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 VNEDUS, VNEDTY, VNEDSQ, VNEDTN, VNEDCT, VNEDLN, VNEDTS, VNEDFT, VNEDDT, VNEDER, VNEDDL, VNEDSP, VNEDTC, VNEDTR, VNEDBT, VNEDGL, VNEDAN, VNKCO, VNDCT, VNDOC, VNDGJ, VNJELN, VNEXTL, VNPOST, VNICU, VNICUT, VNDICJ, VNDSYJ, VNTICU, VNCO, VNANI, VNAM, VNAID, VNMCU, VNOBJ, VNSUB, VNSBL, VNSBLT, VNLT, VNPN, VNCTRY, VNFY, VNFQ, VNCRCD, VNCRR, VNHCRR, VNHDGJ, VNAA, VNU, VNUM, VNGLC, VNRE, VNEXA, VNEXR, VNR1, VNR2, VNR3, VNSFX, VNODOC, VNODCT, VNOSFX, VNPKCO, VNOKCO, VNPDCT, VNAN8, VNCN, VNDKJ, VNDKC, VNASID, VNBRE, VNRCND, VNSUMM, VNPRGE, VNTNN, VNALT1, VNALT2, VNALT3, VNALT4, VNALT5, VNALT6, VNALT7, VNALT8, VNALT9, VNALT0, VNALTT, VNALTU, VNALTV, VNALTW, VNALTX, VNALTZ, VNDLNA, VNCFF1, VNCFF2, VNASM, VNBC, VNVINV, VNIVD, VNWR01, VNPO, VNPSFX, VNDCTO, VNLNID, VNWY, VNWN, VNFNLP, VNOPSQ, VNJBCD, VNJBST, VNHMCU, VNDOI, VNALID, VNALTY, VNDSVJ, VNTORG, VNREG#, VNPYID, VNUSER, VNPID, VNJOBN, VNUPMJ, VNUPMT, VNCRRM, VNACR, VNDGM, VNDGD, VNDGY, VNDG#, VNDICM, VNDICD, VNDICY, VNDIC#, VNDSYM, VNDSYD, VNDSYY, VNDSY#, VNDKM, VNDKD, VNDKY, VNDK#, VNDSVM, VNDSVD, VNDSVY, VNDSV#, VNHDGM, VNHDGD, VNHDGY, VNHDG#, VNDKCM, VNDKCD, VNDKCY, VNDKC#, VNIVDM, VNIVDD, VNIVDY, VNIVD#, VNABR1, VNABR2, VNABR3, VNABR4, VNABT1, VNABT2, VNABT3, VNABT4, VNITM, VNPM01, VNPM02, VNPM03, VNPM04, VNPM05, VNPM06, VNPM07, VNPM08, VNPM09, VNPM10, VNBCRC, VNEXR1, VNTXA1, VNTXITM, VNACTB, VNSTAM, VNCTAM, VNAG, VNAGF, VNTKTX, VNDLNID, VNCKNU, VNBUPC, VNAHBU, VNEPGC, VNJPGC, VNRC5, VNSFXE, VNOFM FROM F0911Z1

TOP920 | 09 | F0911Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1VNEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2VNEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
3VNEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
4VNEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
5VNEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6VNEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
7VNEDTSEDI - Transaction Set NumberStringGeneric Edit60 Allow NULL? 
8VNEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
9VNEDDTEDI - Transmission DateDateGeneric Edit60
10VNEDEREDI - Send/Receive IndicatorCharacterUDC (H00 ED)10 Allow NULL? 
11VNEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
12VNEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
13VNEDTCEDI - Transaction ActionCharacterGeneric Edit10 Allow NULL? 
14VNEDTREDI - Transaction TypeCharacterGeneric Edit10 Allow NULL? 
15VNEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
16VNEDGLBatch File Create G/L RecordCharacterGeneric Edit10 Allow NULL? 
17VNEDANUser Address NumberNumericGeneric Edit80 Allow NULL? 
18VNKCODocument CompanyStringGeneric Edit50 Allow NULL? 
19VNDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
20VNDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
21VNDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
22VNJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
23VNEXTLLine Extension CodeStringGeneric Edit20 Allow NULL? 
24VNPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
25VNICUBatch NumberNumericGeneric Edit80 Allow NULL? 
26VNICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
27VNDICJDate - Batch (Julian)DateGeneric Edit60
28VNDSYJDate - Batch System DateDateGeneric Edit60
29VNTICUBatch TimeNumericGeneric Edit60 Allow NULL? 
30VNCOCompanyStringGeneric Edit50 Allow NULL? 
31VNANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
32VNAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
33VNAIDAccount IDStringGeneric Edit80 Allow NULL? 
34VNMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
35VNOBJObject AccountStringGeneric Edit60 Allow NULL? 
36VNSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
37VNSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
38VNSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
39VNLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
40VNPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
41VNCTRYCenturyNumericGeneric Edit20 Allow NULL? 
42VNFYFiscal YearNumericGeneric Edit20 Allow NULL? 
43VNFQFiscal Quarter (Obsolete)StringUDC (H09 FQ)40 Allow NULL? 
44VNCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
45VNCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
46VNHCRRHistorical Currency Conversion RateNumericGeneric Edit150 Allow NULL? 
47VNHDGJHistorical Date - JulianDateGeneric Edit60
48VNAAAmountNumericGeneric Edit152 Allow NULL? 
49VNUUnitsNumericGeneric Edit152 Allow NULL? 
50VNUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
51VNGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
52VNREReverse or Void (R/V)CharacterUDC (H09 RE)10 Allow NULL? 
53VNEXAName - Alpha ExplanationStringGeneric Edit300 Allow NULL? 
54VNEXRName - Remark ExplanationStringGeneric Edit300 Allow NULL? 
55VNR1Reference 1 - JE Voucher Invoice etc.StringGeneric Edit80 Allow NULL? 
56VNR2Reference 2StringGeneric Edit80 Allow NULL? 
57VNR3Reference 3 - Account ReconciliationStringGeneric Edit80 Allow NULL? 
58VNSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
59VNODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
60VNODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
61VNOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
62VNPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
63VNOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
64VNPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
65VNAN8Address NumberNumericGeneric Edit80 Allow NULL? 
66VNCNPayment NumberStringGeneric Edit80 Allow NULL? 
67VNDKJDate - Check - JulianDateGeneric Edit60
68VNDKCDate - Check ClearedDateGeneric Edit60
69VNASIDSerial NumberStringGeneric Edit250 Allow NULL? 
70VNBREBatch Rear End Posted CodeCharacterUDC (09 BR)10 Allow NULL? 
71VNRCNDReconciled CodeCharacterUDC (09 RC)10 Allow NULL? 
72VNSUMMSummarized CodeCharacterGeneric Edit10 Allow NULL? 
73VNPRGEPurge CodeCharacterGeneric Edit10 Allow NULL? 
74VNTNNFlag for 1099CharacterGeneric Edit10 Allow NULL? 
75VNALT1G/L Posting Code - Alternate 1CharacterGeneric Edit10 Allow NULL? 
76VNALT2G/L Posting Code - Alternate 2CharacterGeneric Edit10 Allow NULL? 
77VNALT3G/L Posting Code - Alternate 3CharacterGeneric Edit10 Allow NULL? 
78VNALT4G/L Posting Code - Alternate 4CharacterGeneric Edit10 Allow NULL? 
79VNALT5G/L Posting Code - Alternate 5CharacterGeneric Edit10 Allow NULL? 
80VNALT6G/L Posting Code - Cash Basis AcctCharacterGeneric Edit10 Allow NULL? 
81VNALT7Commitment Relief FlagCharacterGeneric Edit10 Allow NULL? 
82VNALT8Billing ControlCharacterGeneric Edit10 Allow NULL? 
83VNALT9Currency UpdateCharacterGeneric Edit10 Allow NULL? 
84VNALT0G/L Posting Code - Alternate 0CharacterGeneric Edit10 Allow NULL? 
85VNALTTG/L Posting Code - Alternate TCharacterGeneric Edit10 Allow NULL? 
86VNALTUG/L Posting Code - Alternate UCharacterGeneric Edit10 Allow NULL? 
87VNALTVStocked Inventory CommitmentCharacterGeneric Edit10 Allow NULL? 
88VNALTWG/L Posting Code - Alternate WCharacterGeneric Edit10 Allow NULL? 
89VNALTXConsumption Tax Cross ReferenceCharacterGeneric Edit10 Allow NULL? 
90VNALTZG/L Posting Code - Account Debit BalanceCharacterGeneric Edit10 Allow NULL? 
91VNDLNADelete Not AllowedCharacterGeneric Edit10 Allow NULL? 
92VNCFF1Client Free Form - Alternate 1CharacterGeneric Edit10 Allow NULL? 
93VNCFF2Client Free Form - Alternate 2CharacterGeneric Edit10 Allow NULL? 
94VNASMLease Cost Ledger Posted CodeCharacterGeneric Edit10 Allow NULL? 
95VNBCBill CodeCharacterUDC (98 BC)10 Allow NULL? 
96VNVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
97VNIVDDate - InvoiceDateGeneric Edit60
98VNWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
99VNPOPurchase OrderStringGeneric Edit80 Allow NULL? 
100VNPSFXPurchase Order SuffixStringGeneric Edit30 Allow NULL? 
101VNDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
102VNLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
103VNWYFiscal Year - WeeklyNumericGeneric Edit20 Allow NULL? 
104VNWNFiscal Period - WeeklyNumericGeneric Edit20 Allow NULL? 
105VNFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
106VNOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
107VNJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
108VNJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
109VNHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
110VNDOIDOI SubNumericGeneric Edit20 Allow NULL? 
111VNALIDOutsider Lease or Well IDStringGeneric Edit250 Allow NULL? 
112VNALTYID TypeStringUDC (00 AL)20 Allow NULL? 
113VNDSVJDate - Service/TaxDateGeneric Edit60
114VNTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
115VNREG#Registration NumberNumericGeneric Edit80 Allow NULL? 
116VNPYIDPayment ID (Internal)NumericGeneric Edit150 Allow NULL? 
117VNUSERUser IDStringGeneric Edit100 Allow NULL? 
118VNPIDProgram IDStringGeneric Edit100 Allow NULL? 
119VNJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
120VNUPMJDate - UpdatedDateGeneric Edit60
121VNUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
122VNCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
123VNACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
124VNDGMDate - For G/L (and Voucher) - MONumericGeneric Edit20 Allow NULL? 
125VNDGDDate - For G/L (and Voucher) - DANumericGeneric Edit20 Allow NULL? 
126VNDGYDate - For G/L (and Voucher) - YRNumericGeneric Edit20 Allow NULL? 
127VNDG#Date - For G/L (and Voucher) - CTRYNumericGeneric Edit20 Allow NULL? 
128VNDICMDate - Batch - MONumericGeneric Edit20 Allow NULL? 
129VNDICDDate - Batch - DANumericGeneric Edit20 Allow NULL? 
130VNDICYDate - Batch - YRNumericGeneric Edit20 Allow NULL? 
131VNDIC#Date - Batch - CTRYNumericGeneric Edit20 Allow NULL? 
132VNDSYMDate - Batch System Date - MONumericGeneric Edit20 Allow NULL? 
133VNDSYDDate - Batch System Date - DANumericGeneric Edit20 Allow NULL? 
134VNDSYYDate - Batch System Date - YRNumericGeneric Edit20 Allow NULL? 
135VNDSY#Date - Batch System Date - CTRYNumericGeneric Edit20 Allow NULL? 
136VNDKMDate - Check - MONumericGeneric Edit20 Allow NULL? 
137VNDKDDate - Check - DANumericGeneric Edit20 Allow NULL? 
138VNDKYDate - Check - YRNumericGeneric Edit20 Allow NULL? 
139VNDK#Date - Check - CTRYNumericGeneric Edit20 Allow NULL? 
140VNDSVMDate - Service/Tax - MONumericGeneric Edit20 Allow NULL? 
141VNDSVDDate - Service/Tax - DANumericGeneric Edit20 Allow NULL? 
142VNDSVYDate - Service/Tax - YRNumericGeneric Edit20 Allow NULL? 
143VNDSV#Date - Service/Tax - CTRYNumericGeneric Edit20 Allow NULL? 
144VNHDGMHistorical Date - MONumericGeneric Edit20 Allow NULL? 
145VNHDGDHistorical Date - DANumericGeneric Edit20 Allow NULL? 
146VNHDGYHistorical Date - YRNumericGeneric Edit20 Allow NULL? 
147VNHDG#Historical Date - CTRYNumericGeneric Edit20 Allow NULL? 
148VNDKCMDate - Check Cleared - MONumericGeneric Edit20 Allow NULL? 
149VNDKCDDate - Check Cleared - DANumericGeneric Edit20 Allow NULL? 
150VNDKCYDate - Check Cleared - YRNumericGeneric Edit20 Allow NULL? 
151VNDKC#Date - Check Cleared - CTRYNumericGeneric Edit20 Allow NULL? 
152VNIVDMDate - Invoice - MONumericGeneric Edit20 Allow NULL? 
153VNIVDDDate - Invoice - DANumericGeneric Edit20 Allow NULL? 
154VNIVDYDate - Invoice - YRNumericGeneric Edit20 Allow NULL? 
155VNIVD#Date - Invoice - CTRYNumericGeneric Edit20 Allow NULL? 
156VNABR1Managerial Analysis Code 1StringGeneric Edit120 Allow NULL? 
157VNABR2Managerial Analysis Code 2StringGeneric Edit120 Allow NULL? 
158VNABR3Managerial Analysis Code 3StringGeneric Edit120 Allow NULL? 
159VNABR4Managerial Analysis Code 4StringGeneric Edit120 Allow NULL? 
160VNABT1Managerial Analysis Type 1CharacterUDC10 Allow NULL? 
161VNABT2Managerial Analysis Type 2CharacterUDC10 Allow NULL? 
162VNABT3Managerial Analysis Type 3CharacterUDC10 Allow NULL? 
163VNABT4Managerial Analysis Type 4CharacterUDC10 Allow NULL? 
164VNITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
165VNPM01Posting Code 1 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
166VNPM02Posting Code 2 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
167VNPM03Posting Code 3 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
168VNPM04Posting Code 4 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
169VNPM05Posting Code 5 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
170VNPM06Posting Code 6 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
171VNPM07Posting Code 7 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
172VNPM08Posting Code 8 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
173VNPM09Posting Code 9 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
174VNPM10Posting Code 10- Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
175VNBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
176VNEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
177VNTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
178VNTXITMTax - Short Item NumberNumericGeneric Edit80 Allow NULL? 
179VNACTBActivity-Based Costing Activity CodeStringGeneric Edit100 Allow NULL? 
180VNSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
181VNCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
182VNAGAmount - GrossNumericGeneric Edit152 Allow NULL? 
183VNAGFAmount - Foreign GrossNumericGeneric Edit152 Allow NULL? 
184VNTKTXTrack Taxes FlagCharacterGeneric Edit10 Allow NULL? 
185VNDLNIDDistributionLine NumberNumericGeneric Edit63 Allow NULL? 
186VNCKNUReceipt NumberStringGeneric Edit250 Allow NULL? 
187VNBUPCBurdening Posted CodeCharacterGeneric Edit10 Allow NULL? 
188VNAHBUAlternate Home Business UnitStringGeneric Edit120 Allow NULL? 
189VNEPGCEmployee Pool Grouping CodeStringUDC (00 12)30 Allow NULL? 
190VNJPGCJob Pool Grouping CodeStringUDC (00 12)30 Allow NULL? 
191VNRC5File Line Identifier 5.0NumericGeneric Edit50 Allow NULL? 
192VNSFXEPay Item Extension NumberNumericGeneric Edit20 Allow NULL? 
193VNOFMAuto Offset Method (S Y or B)CharacterGeneric Edit10 Allow NULL? 

TOP920 | 09 | F0911Z1 INDEXES

NumberDescription
1User Batch # + (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
2Batch # Trans +
ElementAliasDescriptionSequence
1EDBTEDI - Batch NumberAscending
2EDTNEDI - Transaction NumberAscending
3EDSPEDI - Successfully ProcessedAscending
3User Batch # Trans G/L Date +
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4DGJDate - For G/L (and Voucher) - JulianAscending
5EDLNEDI - Line NumberAscending
4EDUS EDBT EDTN EDLN Des
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberDescending