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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

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

93 columns | Print definition?920 | ODCT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger43GLODCTDocument Type - OriginalStringUDC20
TOP03: Accounts Receivable
2F0311Accounts Receivable Ledger76RPODCTDocument Type - OriginalStringUDC20
TOP03B: Enhanced Accounts Receivable
3F03B11Customer Ledger71RPODCTDocument Type - OriginalStringUDC20
4F03B112Invoice Revisions7RWODCTDocument Type - OriginalStringUDC20
5F03B112PInvoice Revisions Purge File7RWODCTDocument Type - OriginalStringUDC20
6F03B11PCustomer Ledger Purge File71RPODCTDocument Type - OriginalStringUDC20
7F03B11Z1Batch Invoices87VJODCTDocument Type - OriginalStringUDC20
8F03B11Z2F03B11 Interoperability Table84SYODCTDocument Type - OriginalStringUDC20
9F03B14Receipts Detail81RZODCTDocument Type - OriginalStringUDC20
10F03B14PReceipts Detail Purge File81RZODCTDocument Type - OriginalStringUDC20
11F03B14Z2F03B14 Interoperability Table94SZODCTDocument Type - OriginalStringUDC20
12F03B40A/R Deduction Management15RBODCTDocument Type - OriginalStringUDC20
13F03B575Auto Debit Invoice Select and Build80RDODCTDocument Type - OriginalStringUDC20
14F09UI011Receipt Prepost Work File47GLODCTDocument Type - OriginalStringUDC20
TOP04: Accounts Payable
15F0411Accounts Payable Ledger57RPODCTDocument Type - OriginalStringUDC20
16F0411AWF - 'As Of' Accounts Payable Ledger57RPODCTDocument Type - OriginalStringUDC20
17F0411PPurge - Accounts Payable Ledger57RPODCTDocument Type - OriginalStringUDC20
18F0411Z1Voucher Transactions - Batch Upload75VLODCTDocument Type - OriginalStringUDC20
19F0411Z3F0411 Interoperability Table80SZODCTDocument Type - OriginalStringUDC20
20F09UI005Tax Offsets User Index52GLODCTDocument Type - OriginalStringUDC20
TOP09: General Accounting
21F0911PPurge - Account Ledger43GLODCTDocument Type - OriginalStringUDC20
22F0911Z1Journal Entry Transactions - Batch File60VNODCTDocument Type - OriginalStringUDC20
23F0911Z4F0911 Interoperability Table65SZODCTDocument Type - OriginalStringUDC20
24F09UI015Indexed Computations Multi-Tiered Entries43GLODCTDocument Type - OriginalStringUDC20
TOP15: Real Estate Management
25F1511Tenant/Lease Billings Detail83NJODCTDocument Type - OriginalStringUDC20
26F1511BLease Billings Master79NJODCTDocument Type - OriginalStringUDC20
27F1511HTenant/Lease Billings Detail History82N#ODCTDocument Type - OriginalStringUDC20
28F1511HBLease Billings History78NCODCTDocument Type - OriginalStringUDC20
TOP40: Inventory/OP Base
29F4011ZBatch Receiver File - Order Details119SZODCTDocument Type - OriginalStringUDC20
30F4211Z1Sales Order Detail Unedited Transaction File113SZODCTDocument Type - OriginalStringUDC20
TOP42: Sales Management
31F4211Sales Order Detail File100SDODCTDocument Type - OriginalStringUDC20
32F42119Sales Order History File100SDODCTDocument Type - OriginalStringUDC20
33F42199S.O. Detail Ledger File100SLODCTDocument Type - OriginalStringUDC20
34F42565Invoice Print File167IWODCTDocument Type - OriginalStringUDC20
35F42UI11SO Detail Cache File (MBF)78ZDODCTDocument Type - OriginalStringUDC20
TOP43: Procurement
36F4311ZPurchase Order Generator File220PWODCTDocument Type - OriginalStringUDC20
TOP45: Advanced Pricing
37F4576Z1Ship and Debit Claims Unedited Transaction Table147Z1ODCTDocument Type - OriginalStringUDC20
TOP47: Electronic Commerce
38F47012EDI Purchase Order Detail - Inbound120SZODCTDocument Type - OriginalStringUDC20
39F47027EDI P.O. Acknowledgment Detail - Outbound120SZODCTDocument Type - OriginalStringUDC20
40F47037EDI Shipping Notice Detail - Outbound110SZODCTDocument Type - OriginalStringUDC20
41F470371EDI Shipping Notice Detail - Outbound126SZODCTDocument Type - OriginalStringUDC20
42F47047EDI Invoice Detail (Sales) - Outbound120SZODCTDocument Type - OriginalStringUDC20
43F47057EDI Payment Order Remittance Advice - Outbound44D3ODCTDocument Type - OriginalStringUDC20
44F47057WEDI Payment Order Remittance Advice - Work44D3ODCTDocument Type - OriginalStringUDC20
45F47092EDI Request for Quote Detail - Inbound120SZODCTDocument Type - OriginalStringUDC20
46F47107EDI Response to RFQ Detail - Outbound120SZODCTDocument Type - OriginalStringUDC20
47F47132EDI Purchase Order Change Detail - Inbound121SZODCTDocument Type - OriginalStringUDC20
48F47147EDI P.O. Change Acknowledgment Detail - Outbound122SZODCTDocument Type - OriginalStringUDC20
TOP48S: Service Billing
49F4812Billing Detail Workfile21WDODCTDocument Type - OriginalStringUDC20
50F4812HBilling Workfile History21WDODCTDocument Type - OriginalStringUDC20
51F4812HSBilling Workfile History Purged Save21WDODCTDocument Type - OriginalStringUDC20
52F48SUI01Billing Detail Print Workfile21WDODCTDocument Type - OriginalStringUDC20
TOP49: Transportation Management
53F4981Freight Audit History43FHODCTDocument Type - OriginalStringUDC20
TOP70: Multi-National Products
54F704001Payment WH Info TEMP - COMM - 047PTODCTDocument Type - OriginalStringUDC20
55F704002Payment WH Info - COMM - 046PFODCTDocument Type - OriginalStringUDC20
56F704002PPayment WH Info Purge - COMM - 046PFODCTDocument Type - OriginalStringUDC20
TOP74: EMEA Localization
57F7430015Invoices Related to AR DN/CN - COMM - 03B5DRODCTDocument Type - OriginalStringUDC20
TOP74H: Hungary
58F74H309Gains & Losses Unrealized Account ing - HUN - 03B5GLODCTDocument Type - OriginalStringUDC20
59F74H409A/P Gains & Losses Unrealized Accounting - HUN - 045GLODCTDocument Type - OriginalStringUDC20
TOP74P: Poland
60F74P411HF0411 Header File - POL - 04 - 74P6P4ODCTDocument Type - OriginalStringUDC20
TOP74R: Russia
61F74R3037Adjustment Invoice Relationship in AR/SOP - RUS - 74R5ARODCTDocument Type - OriginalStringUDC20
TOP74Y: Italy
62F74Y015Yearly List Declaration - WF - IT - 0029YLODCTDocument Type - OriginalStringUDC20
63F74Y018Intrastat Additional Info for Services - ITA - 0014IAODCTDocument Type - OriginalStringUDC20
64F74Y171Contract Relations - IT - 0015CRODCTDocument Type - OriginalStringUDC20
65F74Y315Invoices Related to AR DN/CN - ITA - 03B6RIODCTDocument Type - OriginalStringUDC20
66F74Y415Vouchers Related to AP DN/CN - ITA - 047RVODCTDocument Type - OriginalStringUDC20
TOP74Z: Czech Republic
67F74Z0010Cash Desk Document Printed - CZE - 74Z6ZOODCTDocument Type - OriginalStringUDC20
TOP75I: India
68F75I3574Consignment - Issues/Receipts Transactions26CTODCTDocument Type - OriginalStringUDC20
69F75I3576Stock Transfer - Work Orders11SWODCTDocument Type - OriginalStringUDC20
70F75I380Excise - RG-1 - Transaction File - IND20RGODCTDocument Type - OriginalStringUDC20
71F75I411F0411 Tag File - IN - 0413TFODCTDocument Type - OriginalStringUDC20
TOP75T: Taiwan
72F75T004ZGUI/VAT Transaction Header - Work - 75T4ZHODCTDocument Type - OriginalStringUDC20
73F75T005ZGUI/VAT Transaction Detail - Work - 75T4ZDODCTDocument Type - OriginalStringUDC20
TOP76A: Argentina
74F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A42HFODCTDocument Type - OriginalStringUDC20
75F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A42HFODCTDocument Type - OriginalStringUDC20
76F76A81A/P Payment Control Group File - ARG - 04 - 76A23C5ODCTDocument Type - OriginalStringUDC20
77F76A82A/P Payment Control Group File - ARG - 04 - 76A34C6ODCTDocument Type - OriginalStringUDC20
78F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A42HFODCTDocument Type - OriginalStringUDC20
TOP76B: Brazil
79F76B0411Voucher Additional Information Brazil - 0424VBODCTDocument Type - OriginalStringUDC20
80F76B473TF04573 Brazilian Temp WH File - BR - 0428W3ODCTDocument Type - OriginalStringUDC20
TOP76C: Colombia
81F76C031AA/R Customer ledger As Of - F76C031A - COL - 0470RPODCTDocument Type - OriginalStringUDC20
82F76C034AA/R Check Detail file As Of - COL - 03B81RZODCTDocument Type - OriginalStringUDC20
83F76C575Work File Magnetic Media - COL - 0447Q1ODCTDocument Type - OriginalStringUDC20
TOP76H: Chile
84F76H3B15NC/ND - Invoice Related - CHI - 03B - 76H5IRODCTDocument Type - OriginalStringUDC20
85F76H3B20Invoices not Printed - CHI - 03B - 76H13ADODCTDocument Type - OriginalStringUDC20
86F76HUI31Document Related Work File - CHI - 42 - 76H7DRODCTDocument Type - OriginalStringUDC20
TOP76M: Mexico
87F76M0314Receipt Detail Tag File - Mexico12MAODCTDocument Type - OriginalStringUDC20
88F76M0414F0414 - Payment Detail Tag File - Mexico13RTODCTDocument Type - OriginalStringUDC20
89F76M990GL VAT on Gain/loss MEX - 76M22GLODCTDocument Type - OriginalStringUDC20
TOP76P: Peru
90F76P411TPeru AP Tag File - PER - 04 - 76P22T4ODCTDocument Type - OriginalStringUDC20
91F76P480SPOT Voucher Information - PER - 04 - 76P5SVODCTDocument Type - OriginalStringUDC20
TOP76V: Venezuela
92F76V4015Vouchers Related to Credit/Debit Notes - VEN - 045CDODCTDocument Type - OriginalStringUDC20
93F76V4581Withholding Historical File - VEN - 0412HRODCTDocument Type - OriginalStringUDC20

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