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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

83 columns | Print definition?920 | OCTO | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP12: Fixed Assets
1F1217Equipment Master Extension21WROCTOOriginal Order TypeStringUDC20
2F1217PEquipment Master Extension Purge Table21WROCTOOriginal Order TypeStringUDC20
3F1217Z1Unedited Equipment Tag Transactions34WROCTOOriginal Order TypeStringUDC20
4F1217Z2Unedited Equipment Tag Transactions34WROCTOOriginal Order TypeStringUDC20
TOP17C: Call Management
5F1713ECOs Applied to Equipment5EEOCTOOriginal Order TypeStringUDC20
6F1755Case Master82ZAOCTOOriginal Order TypeStringUDC20
TOP40: Inventory/OP Base
7F4001ZBatch Receiver File - Order Headings32SYOCTOOriginal Order TypeStringUDC20
8F40051Return Material Authorization26RDOCTOOriginal Order TypeStringUDC20
9F4011ZBatch Receiver File - Order Details23SZOCTOOriginal Order TypeStringUDC20
10F4012ZWWF - Destination Quantity8SPOCTOOriginal Order TypeStringUDC20
11F4201Z1Sales Order Header Unedited Transaction File22SYOCTOOriginal Order TypeStringUDC20
12F4211Z1Sales Order Detail Unedited Transaction File23SZOCTOOriginal Order TypeStringUDC20
TOP42: Sales Management
13F4201Sales Order Header File9SHOCTOOriginal Order TypeStringUDC20
14F42019Sales Order Header History File9SHOCTOOriginal Order TypeStringUDC20
15F4211Sales Order Detail File10SDOCTOOriginal Order TypeStringUDC20
16F42119Sales Order History File10SDOCTOOriginal Order TypeStringUDC20
17F42199S.O. Detail Ledger File10SLOCTOOriginal Order TypeStringUDC20
18F42565Invoice Print File168IWOCTOOriginal Order TypeStringUDC20
19F42UI01SO Header Cache File (MBF)14ZHOCTOOriginal Order TypeStringUDC20
20F42UI11SO Detail Cache File (MBF)14ZDOCTOOriginal Order TypeStringUDC20
21F42UI521Pick Slips Detail File9S9OCTOOriginal Order TypeStringUDC20
TOP43: Procurement
22F4301Purchase Order Header8PHOCTOOriginal Order TypeStringUDC20
23F4301ZPO Header Work File12PAOCTOOriginal Order TypeStringUDC20
24F4301Z1Purchase Order Header Unedited Transaction Table21SYOCTOOriginal Order TypeStringUDC20
25F43080Approvals Fields Constants20PDOCTOOriginal Order TypeStringUDC20
26F4311Purchase Order Detail File10PDOCTOOriginal Order TypeStringUDC20
27F4311ZPurchase Order Generator File14PWOCTOOriginal Order TypeStringUDC20
28F4311Z1Purchase Order Detail Unedited Transaction Table23SZOCTOOriginal Order TypeStringUDC20
29F43199P.O. Detail Ledger File - Flexible Version10OLOCTOOriginal Order TypeStringUDC20
30F4332Multiple Requisition File6P2OCTOOriginal Order TypeStringUDC20
31F43UI50DPO Print Detail Work File23PWOCTOOriginal Order TypeStringUDC20
TOP44H: Homebuilder Management
32F44H001HomeBuilder Constants13HCOCTOOriginal Order TypeStringUDC20
33F44H0011HomeBuilder Constants Lot Start Documents2LDOCTOOriginal Order TypeStringUDC20
34F44H611WBid Details Work File9BWOCTOOriginal Order TypeStringUDC20
35F44H711Lot Start Workfile22SWOCTOOriginal Order TypeStringUDC20
36F44H711PAfter Start Purchasing24TPOCTOOriginal Order TypeStringUDC20
37F44H711ZHB Lot Start Unedited Transaction File35SZOCTOOriginal Order TypeStringUDC20
38F44H71W1Lot Start Generation Workfile22GWOCTOOriginal Order TypeStringUDC20
39F44H73W1Lot Start - P.O. / Committment Generation Work File23CGOCTOOriginal Order TypeStringUDC20
TOP45: Advanced Pricing
40F4576Z1Ship and Debit Claims Unedited Transaction Table128Z1OCTOOriginal Order TypeStringUDC20
TOP47: Electronic Commerce
41F47011EDI Purchase Order Header - Inbound27SYOCTOOriginal Order TypeStringUDC20
42F47012EDI Purchase Order Detail - Inbound24SZOCTOOriginal Order TypeStringUDC20
43F47016EDI Purchase Order Header - Outbound23SYOCTOOriginal Order TypeStringUDC20
44F47017EDI Purchase Order Detail - Outbound24SZOCTOOriginal Order TypeStringUDC20
45F47021EDI P.O. Acknowledgment Header - Inbound23SYOCTOOriginal Order TypeStringUDC20
46F47022EDI P.O. Acknowledgment Detail - Inbound24SZOCTOOriginal Order TypeStringUDC20
47F47026EDI P.O. Acknowledgment Header - Outbound24SYOCTOOriginal Order TypeStringUDC20
48F47027EDI P.O. Acknowledgment Detail - Outbound24SZOCTOOriginal Order TypeStringUDC20
49F47031EDI Shipping Notice Header - Inbound24SYOCTOOriginal Order TypeStringUDC20
50F47032EDI Shipping Notice Detail - Inbound27SZOCTOOriginal Order TypeStringUDC20
51F47037EDI Shipping Notice Detail - Outbound27SZOCTOOriginal Order TypeStringUDC20
52F470371EDI Shipping Notice Detail - Outbound27SZOCTOOriginal Order TypeStringUDC20
53F47046EDI Invoice Header (Sales) - Outbound24SYOCTOOriginal Order TypeStringUDC20
54F47047EDI Invoice Detail (Sales) - Outbound24SZOCTOOriginal Order TypeStringUDC20
55F47071EDI Receiving Advice Header - Inbound24SYOCTOOriginal Order TypeStringUDC20
56F47072EDI Receiving Advice Detail - Inbound25SZOCTOOriginal Order TypeStringUDC20
57F47076EDI Receiving Advice Header - Outbound24SYOCTOOriginal Order TypeStringUDC20
58F47077EDI Receiving Advice Detail - Outbound25SZOCTOOriginal Order TypeStringUDC20
59F47091EDI Request for Quote Header - Inbound27SYOCTOOriginal Order TypeStringUDC20
60F47092EDI Request for Quote Detail - Inbound24SZOCTOOriginal Order TypeStringUDC20
61F47096EDI Request for Quote Header - Outbound23SYOCTOOriginal Order TypeStringUDC20
62F47097EDI Request for Quote Detail - Outbound24SZOCTOOriginal Order TypeStringUDC20
63F47101EDI Response to RFQ Header - Inbound23SYOCTOOriginal Order TypeStringUDC20
64F47102EDI Response to RFQ Detail - Inbound24SZOCTOOriginal Order TypeStringUDC20
65F47106EDI Response to RFQ Header - Outbound24SYOCTOOriginal Order TypeStringUDC20
66F47107EDI Response to RFQ Detail - Outbound24SZOCTOOriginal Order TypeStringUDC20
67F47131EDI Purchase Order Change Header - Inbound24SYOCTOOriginal Order TypeStringUDC20
68F47132EDI Purchase Order Change Detail - Inbound25SZOCTOOriginal Order TypeStringUDC20
69F47136EDI Purchase Order Change Header - Outbound23SYOCTOOriginal Order TypeStringUDC20
70F47137EDI Purchase Order Change Detail - Outbound25SZOCTOOriginal Order TypeStringUDC20
71F47141EDI P.O. Change Acknowledgment Header - Inbound24SYOCTOOriginal Order TypeStringUDC20
72F47142EDI P.O. Change Acknowledgment Detail - Inbound26SZOCTOOriginal Order TypeStringUDC20
73F47146EDI P.O. Change Acknowledgment Header - Outbound25SYOCTOOriginal Order TypeStringUDC20
74F47147EDI P.O. Change Acknowledgment Detail - Outbound26SZOCTOOriginal Order TypeStringUDC20
75F47156EDI Shipping Schedule Header - Outbound24SYOCTOOriginal Order TypeStringUDC20
76F47157EDI Shipping Schedule Detail - Outbound24SZOCTOOriginal Order TypeStringUDC20
TOP74R: Russia
77F74R0401Adjustment to Voucher - RUS - 04 - 74R3ADOCTOOriginal Order TypeStringUDC20
78F74R0402Correction to Voucher - RUS - 04 - 74R5COOCTOOriginal Order TypeStringUDC20
TOP75I: India
79F75I346Excise - D3-Form Table7Q9OCTOOriginal Order TypeStringUDC20
TOP76B: Brazil
80F7601BNota Fiscal Header - BRA - 429FHOCTOOriginal Order TypeStringUDC20
81F7611BNota Fiscal Detail - BRA - 4211FDOCTOOriginal Order TypeStringUDC20
82F761BAAS Fiscal file book - 0910FBOCTOOriginal Order TypeStringUDC20
TOP89: Conversion Programs
83F43199ATemp F43199 for ERP 9.0 Upgrade10OLOCTOOriginal Order TypeStringUDC20

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / DT (Document Type - All Documents) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        ##Prior Year Transactions Y
2        $AEventual Withholdings N
3        $BGross Income Withholdings N
4        $GProfit Withholdings N
5        $IV.A.T Withholdings N
6        $LCleaning Services Withholding N
7        $PSecurity Withholdings Y
8        $QGeneral SUSS Y
9        $SContract Withholdings N
10        %Percentage Journal Entry Y
11        @OPayment order N
12        AInv. Cnv. - Adjustments N
13        ACLease Accrual / Deferral N
14        ADAsset Disposal Y
15        AEAutomatic Entries Y
16        AFAdjusting Entries Y
17        AJService Billing Adjustments Y
18        ARAsset Revaluation Y
19        ASAsset Split Y
20        ATAsset Transfer Y
21        AUUnits - Committed Y
22        BABilling Adjustments Y
23        BBBulk - Simple Blend N
24        BCBase Agreement Contract N
25        BDBulk- Decant N
26        BEBilling Entries N
27        BFBalance Forward/Summarize Y
28        BGRegrade/GSM N
29        BIBulk/Packed Invoice N
30        BJBulk - Adjustment N
31        BLBulk-Filling N
32        BMBill of Lading N
33        BOBulk-Consumed in Operations N
34        BPBulk-Repacking N
35        BRBulk-Rebrand or Regrade N
36        BTBulk-Tank to Tank Transfer N
37        BXBudget Change Order N
38        C%TDS Withholding N
39        C1Contract Level Y
40        C2Invoice Level Y
41        C3Funding Level Y
42        C4Credit Order - Transportation N
43        CCUSER N
44        CDContainer Deposits N
45        CFJournal Entry From Conversion N
46        CGLot Grade Change Y
47        CLCall N
48        CMService Contracts - CSMSNN
49        COCredit Order N
50        CPLot Potency Change Y
51        CSRFx N
52        CTTransportation Confirmation N
53        CWHomeBuilder Closing Worksheet N
54        CXChange Request Y
55        CZCash Basis Y
56        DADebit Note N
57        DDSale Order N
58        DLDelivery Ticket N
59        DNCredit Note N
60        DPDepreciation Journal Y
61        DRJob Cost Draw Splits Y
62        EEnergy N
63        EALease Cost Adjusting Entries N
64        ECRevenue Checks N
65        EGEngineering Change RequestRN
66        ENEngineering Change Order N
67        EPRevenue J/E`s 8/8`s N
68        EQRevenue J/E`s Subledger N
69        ERRevenue J/E`s Net Company N
70        ESRevenue Suspense Entries N
71        ETEngineer to OrderNN
72        EUService Billing Revenue Y
73        EVRevenue Manual/Void Checks N
74        EXCurrency Conversion Offsets Y
75        FAInvoice N
76        FCForecast N
77        FERevenue Fees N
78        FJRevenue Fees - Jrnl Entry Only N
79        FOFirm Work Order W/Parts List N
80        FPField Progress Reporting N
81        FRFirm Rate Order W/Parts List Y
82        FSFRW Created Doc. Types N
83        FTFreight N
84        G2Inbound Completions N
85        GFGeneral Ledger Transferred N
86        GGEnvironmental Document Y
87        GLBulk Product Gain/Loss N
88        HPPurchase Order N
89        HSHours Service N
90        HTPurchase Transfer Order N
91        IInv Cnv - Issues N
92        I1Interbranch Sales
93        I2Sorties de Stock- Obsolescence N
94        I3Sorties de Stock - Vol N
95        I4Sorties de Stock - Dommages N
96        IAInventory Adjustments N
97        IBItem Cost Changes N
98        ICCompleted W.O.`s To Inventory N
99        IDInventory Issue To Blend Mgmt Y
100        IHLabor Charged To W.O.`s N
101        IIInventory Issue N
102        IJInventory Adjustments
103        ILInventory Issue
104        IMMaterial Charged To W.O.`s N
105        IOComponent Scrap to W.O.`s N
106        IPPhysical Inventory Y
107        IQInventory Quantity Only Y
108        IRInventory Receipt N
109        ISScrapped W.O.`s To Inventory N
110        ITInventory Transfers N
111        IVVariance Calculated for W.O.`s N
112        IXRecalculate Average Cost Y
113        IZLot Hold/Release Y
114        JABudget or Cost Allocation Y
115        JBJoint Interest Billing N
116        JCJob Cost % Complete N
117        JDJIB Detail Owner Entries N
118        JEJournal Entry Y
119        JFJournals Brought Forward N
120        JKA/P Redistribute Payments Y
121        JMAR VAT Redistribution Y
122        JPSubscription Sales N
123        JQSub. Sales Net Ledger N
124        JRSubscription Sales Commissions N
125        JTAccrued Property Taxes N
126        JVA/P Redistribute Prepayments Y
127        JXForeign Currency Revaluation Y
128        JZCash Basis Journal Entry Y
129        K1Kanban Type 1 Y
130        K2Kanban Type 2 Y
131        K3Kanban Type 3 Y
132        K4Kanban Type 4 Y
133        LBLabels N
134        LCCompleted Lean Trans to InvL3N
135        LHWork Order Labor Hours N
136        LLLabor charged to Lean TransL2N
137        LMMaterial charged to Lean TransL1N
138        LOComponent Scrap to Lean TransLN
139        LPScrapped Lean Trans to InvL4N
140        LSProperty Management Lease N
141        LVVariance calculated for Lean TLN
142        MPAnother Purchase Order N
143        MSMaterial Issue Service N
144        MUMileage (Meter) Update N
145        NOther ValuesNN
146        NAStand Alone Nota Fiscal N
147        NDShip-To Nota Fiscal Return N
148        NFPurchasing Nota Fiscal N
149        NINon Stock Nota Fiscal N
150        NLPreliminary Order N
151        NNNota Fiscal Reverse/Void N
152        NONetting Transactions Y
153        NPPartial NSF Y
154        NRShip-From Nota Fiscal Return N
155        NSNota Fiscal Sales N
156        OOrdering Document Types N
157        O1Order Document Type Fixed Asse N
158        O4Purchase Order -Transportation N
159        OADo Not Use Y
160        OBBlanket Order N
161        OCConstruction Work Order N
162        ODDirect Ship Order N
163        OEDo Not Use--Exchange Rate Var. Y
164        OIInteroperability Direct P.O. N
165        OKPurchase Intercompany Order N
166        OMPurchase Order RMA N
167        OOOutside Operations
168        OPPurchase Order N
169        OQPurchase Quote or Bid N
170        ORPurchase Requisition N
171        OSSubcontract N
172        OTTransfer Order N
173        OURequisition Self Service Y
174        OVDo Not Use--Receiving Document Y
175        OXChange Order N
176        OYEDI Purchase Order Quote
177        OZEDI Purchase Order
178        PPayables N
179        P1A/P Drafts Y
180        P7Alternate Currency Payment Y
181        P9Voucher Y
182        PACredit Note Reimbursements Y
183        PBBACS Electronic Funds Transfer Y
184        PCPercent Complete FASTR Entry N
185        PDDebit Memo Y
186        PEChange to Voucher Amount Y
187        PFRecurring Billing N
188        PGGain/Loss on Exchange Rate Y
189        PIPhysical Inventory Y
190        PJSales Overage N
191        PKAutomated Check Y
192        PLVoucher Logging Y
193        PMManual Voucher Y
194        PNManual Check Y
195        POVoid Check Y
196        PPPeriodic Invoice Y
197        PQManual Billing N
198        PRRecurring Voucher Y
199        PTElectronic Funds Transfer Y
200        PVVoucher Y
201        PWWithholding Y
202        PYPayment Order - EDI Only Y
203        PZA/P Cash Basis Y
204        Q7Suspended VAT - Recognized N
205        Q8Suspended and Recognized VAT N
206        Q9Suspended VAT N
207        QANon-Comformance Report N
208        QOQuote Order N
209        QRQuote Request N
210        RReceivables N
211        R%TDS Withholding N
212        R1A/R Drafts Y
213        R2Contract Billing Y
214        R3Draft Invoice Y
215        R4Final Invoice Y
216        R5Deduction Y
217        R6RMA - Sales Order Y
218        R7Alternate Currency Receipt Y
219        R8Return Material Authorization N
220        R9RMA Credit Order N
221        RAAdjustment Y
222        RBChargeback Y
223        RCReceipts - A/R Y
224        RDRecurring Billing N
225        REChange to Invoice Amount Y
226        RFFinance Charge Y
227        RGGain/Loss on Exchange Rate Y
228        RHExpense Participation N
229        RIInvoice Y
230        RJSales Overage N
231        RKReceipt - Summarized Y
232        RLEscalation N
233        RMCredit Memo Y
234        RNManual Billing Y
235        ROReversing or Void Entry Y
236        RPDirect Payments Y
237        RQChargeback Amount Created Y
238        RRRecurring Invoice Y
239        RSSpread Adjustments Y
240        RTA/R Fee & Interest Y
241        RUUnapplied Cash Y
242        RVNon-sufficient Funds Y
243        RWReceipt Journal Entry Y
244        RXSales Contracts N
245        RYEDI Receipt Y
246        RZA/R Cash Basis Y
247        SSales Order Document Types N
248        S1Counter Sales N
249        S2Phone Sales N
250        S3Sales Order - ECS N
251        S4Sales Order - Transportation10N
252        SBBlanket Sales Order N
253        SCActual Rate Schedule Y
254        SDDirect Ship N
255        SEExtended Warr. ServiceNN
256        SHSupplier Recovery N
257        SIInterbranch Sales N
258        SKSales Intercompany Order N
259        SNNonwarranty ServiceNN
260        SOSales OrderSON
261        SPPrice List N
262        SQSales Quote N
263        SRSales Order - Rush N
264        SSDo Not Use--Summary Records Y
265        STTransfer Sale N
266        SVBase Warranty ServiceNN
267        SWSales with Trans. & Warehouse N
268        SYEDI Sales Order Quote N
269        SZEDI Sales Order N
270        TTime and Pay N
271        T1Payroll Disbursement Entries N
272        T2Payroll Labor Distribution N
273        T3Actual Burden Journal Entries N
274        T4Labor Billing Distribution N
275        T5Equipment Distribution N
276        T6Payroll Accruals / Deferrals N
277        T7Payroll Vouchers N
278        TETime Sheet Entry N
279        TJPayroll Journal N
280        TMEnterprise Treasury Management Y
281        TOTakeoff N
282        U1U1 through U9 client reserved N
283        UAUA through UZ client reserved N
284        UPUsed Produt N
285        V1Versand Service N
286        VCSales Order Reverse N
287        VDDelivery ocument for Service N
288        VLNota Fiscal Batch Return N
289        VNVendor Notice
290        VOSales Order N
291        VRSales Order Return N
292        VSPurchase Order Return N
293        VTSales Transfer Order N
294        W1Work Order Other N
295        WAWork order for A N
296        WCWarranty Claim N
297        WDWrite Downs
298        WHEquipment Work Order N
299        WMMaintenance Work Order N
300        WOReal (firm) Work Orders N
301        WPPlanning Work Orders N
302        WTWire Transfer N
303        X1User-defined Doc Type X1
304        X2User-defined Doc Type X2
305        X3User-defined Doc Type X3
306        X4User-defined Doc Type X4
307        XRRental Contracts Y
308        Y1User-defined Doc Type Y1
309        Y2User-defined Doc Type Y2
310        Y3User-defined Doc Type Y3
311        Y4User-defined Doc Type Y4
312        Y5User-defined Doc Type Y5
313        ZInv Cnv - Month End Summary N
314        ZCDocument ZC N
315        ZDDocument ZD N
316        ZZUnrecognized Version E Trans. N