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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

95 columns | Print definition?910 | 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: Property 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
TOP55: Reserved for Clients
54F74H1051Invoicing Workfile - New31IWODCTDocument Type - OriginalStringUDC20
55F74P0710Credit Order History14PLODCTDocument Type - OriginalStringUDC20
TOP70: Multi-National Products - obsolete-do not reuse
56F704001Payment WH Info TEMP - COMM - 047PTODCTDocument Type - OriginalStringUDC20
57F704002Payment WH Info - COMM - 046PFODCTDocument Type - OriginalStringUDC20
58F704002PPayment WH Info Purge - COMM - 046PFODCTDocument Type - OriginalStringUDC20
TOP74: EMEA Localization
59F7430015Invoices Related to AR DN/CN - COMM - 03B5DRODCTDocument Type - OriginalStringUDC20
TOP74H: Hungary
60F74H309Gains & Losses Unrealized Account ing - HUN - 03B5GLODCTDocument Type - OriginalStringUDC20
61F74H409A/P Gains & Losses Unrealized Accounting - HUN - 045GLODCTDocument Type - OriginalStringUDC20
TOP74P: Poland
62F74P411HF0411 Header File - POL - 04 - 74P6P4ODCTDocument Type - OriginalStringUDC20
TOP74R: CIS
63F74R3037Adjustment Invoice Relationship in AR/SOP - RUS - 74R5ARODCTDocument Type - OriginalStringUDC20
TOP74Y: Italy - Reporting System Only
64F74Y015Yearly List Declaration - WF - IT - 0029YLODCTDocument Type - OriginalStringUDC20
65F74Y018Intrastat Additional Info for Services - ITA - 0014IAODCTDocument Type - OriginalStringUDC20
66F74Y171Contract Relations - IT - 0015CRODCTDocument Type - OriginalStringUDC20
67F74Y315Invoices Related to AR DN/CN - ITA - 03B6RIODCTDocument Type - OriginalStringUDC20
68F74Y415Vouchers Related to AP DN/CN - ITA - 047RVODCTDocument Type - OriginalStringUDC20
TOP74Z: Czech Republic
69F74Z0010Cash Desk Document Printed - CZE - 74Z6ZOODCTDocument Type - OriginalStringUDC20
TOP75I: India
70F75I3574Consignment - Issues/Receipts Transactions26CTODCTDocument Type - OriginalStringUDC20
71F75I3576Stock Transfer - Work Orders11SWODCTDocument Type - OriginalStringUDC20
72F75I380Excise - RG-1 - Transaction File - IND20RGODCTDocument Type - OriginalStringUDC20
73F75I411F0411 Tag File - IN - 0413TFODCTDocument Type - OriginalStringUDC20
TOP75T: Taiwan
74F75T004ZGUI/VAT Transaction Header - Work - 75T4ZHODCTDocument Type - OriginalStringUDC20
75F75T005ZGUI/VAT Transaction Detail - Work - 75T4ZDODCTDocument Type - OriginalStringUDC20
TOP76A: Argentina
76F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A42HFODCTDocument Type - OriginalStringUDC20
77F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A42HFODCTDocument Type - OriginalStringUDC20
78F76A81A/P Payment Control Group File - ARG - 04 - 76A23C5ODCTDocument Type - OriginalStringUDC20
79F76A82A/P Payment Control Group File - ARG - 04 - 76A34C6ODCTDocument Type - OriginalStringUDC20
80F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A42HFODCTDocument Type - OriginalStringUDC20
TOP76B: Brazil - Reporting System Only
81F76B0411Voucher Additional Information Brazil - 0424VBODCTDocument Type - OriginalStringUDC20
82F76B473TF04573 Brazilian Temp WH File - BR - 0428W3ODCTDocument Type - OriginalStringUDC20
TOP76C: Colombia
83F76C031AA/R Customer ledger As Of - F76C031A - COL - 0470RPODCTDocument Type - OriginalStringUDC20
84F76C034AA/R Check Detail file As Of - COL - 03B81RZODCTDocument Type - OriginalStringUDC20
85F76C575Work File Magnetic Media - COL - 0447Q1ODCTDocument Type - OriginalStringUDC20
TOP76H: Chile
86F76H3B15NC/ND - Invoice Related - CHI - 03B - 76H5IRODCTDocument Type - OriginalStringUDC20
87F76H3B20Invoices not Printed - CHI - 03B - 76H13ADODCTDocument Type - OriginalStringUDC20
88F76HUI31Document Related Work File - CHI - 42 - 76H7DRODCTDocument Type - OriginalStringUDC20
TOP76M: Mexico
89F76M0314Receipt Detail Tag File - Mexico12MAODCTDocument Type - OriginalStringUDC20
90F76M0414F0414 - Payment Detail Tag File - Mexico13RTODCTDocument Type - OriginalStringUDC20
91F76M990GL VAT on Gain/loss MEX - 76M22GLODCTDocument Type - OriginalStringUDC20
TOP76P: Peru
92F76P411TPeru AP Tag File - PER - 04 - 76P22T4ODCTDocument Type - OriginalStringUDC20
93F76P480SPOT Voucher Information - PER - 04 - 76P5SVODCTDocument Type - OriginalStringUDC20
TOP76V: Venezuela
94F76V4015Vouchers Related to Credit/Debit Notes - VEN - 045CDODCTDocument Type - OriginalStringUDC20
95F76V4581Withholding 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        $PSecurity WithholdingsY
2        $QGeneral SUSSY
3        % Percentage Journal EntryN
4        AJService Billing AdjustmentsY
5        ARAsset RevaluationY
6        ASAsset SplitN
7        ATAsset TransferN
8        BABilling AdjustmentsY
9        BFBalance Forward/SummarizeN
10        CACredit Note for AftercareN
11        CCCredit-Contract & Loyalty SuppN
12        CGLot Grade ChangeN
13        CPLot Potency ChangeN
14        CQCredit Note - Quarterly BonusN
15        CTCredit Note - Targeted BonusN
16        CWCredit Note for WarrantyN
17        DPDepreciation JournalN
18        DRJob Cost Draw SplitsY
19        EUService Billing RevenueY
20        EXCurrency Conversion OffsetsN
21        IQInventory Quantity OnlyY
22        IXRecalculate Average CostN
23        IZLot Hold/ReleaseN
24        JABudget or Cost AllocationN
25        JBJoint Interest BillingN
26        JCJob Cost % CompleteN
27        JDJIB Detail Owner EntriesN
28        JEJournal EntryN
29        JFJournals Brought ForwardN
30        JKA/P Redistribute PaymentsY
31        JMAR VAT RedistributionY
32        JPSubscription SalesN
33        JQSub. Sales Net LedgerN
34        JRSubscription Sales CommissionsN
35        JTAccrued Property TaxesN
36        JVA/P Redistribute PrepaymentsY
37        JXForeign Currency RevaluationN
38        JZCash Basis Journal EntryN
39        NPPartial NSFY
40        O Ordering Document TypesN
41        O4Purchase Order -TransportationN
42        OADo Not UseY
43        OBBlanket OrderN
44        OCConstruction Work OrderN
45        ODDirect Ship OrderN
46        OEDo Not Use--Exchange Rate Var.N
47        OIInteroperability Direct P.O.N
48        OKPurchase Intercompany OrderN
49        OMPurchase Order RMAN
50        OOOutside Operations
51        OPPurchase OrderN
52        OQPurchase Quote or BidN
53        OSSubcontractN
54        OURequisition Self ServiceY
55        OYEDI Purchase Order Quote
56        P1A/P DraftsN
57        P7Alternate Currency PaymentN
58        PACredit Note ReimbursementsN
59        PBBACS Electronic Funds TransferN
60        PEChange to Voucher AmountN
61        PGGain/Loss on Exchange RateN
62        PIPhysical InventoryN
63        PKAutomated CheckN
64        PLVoucher LoggingN
65        PMManual VoucherN
66        PNManual CheckN
67        POVoid CheckN
68        PRRecurring VoucherN
69        PTElectronic Funds TransferN
70        PWWithholding
71        PYPayment Order - EDI Only
72        R ReceivablesN
73        R1A/R DraftsN
74        R2Contract BillingN
75        R5DeductionY
76        R6RMA - Sales OrderY
77        R7Alternate Currency ReceiptN
78        RAAdjustmentN
79        RBChargebackN
80        RCCash ReceiptsN
81        REChange to Invoice AmountN
82        RFFinance ChargeN
83        RGGain/Loss on Exchange RateN
84        RKCash Receipts CheckN
85        ROReversing or Void EntryN
86        RQChargeback Amount CreatedN
87        RRRecurring InvoiceN
88        RSSpread AdjustmentsN
89        RUUnapplied CashN
90        RVNon-sufficient FundsN
91        RWBalance ForwardN
92        RYCash Receipts - EDI Only
93        SBBlanket Sales OrderN
94        SCActual Rate ScheduleN
95        SDDirect ShipN
96        SFFree GoodsN
97        SIInterbranch SalesN
98        SQSales QuoteN
99        SSDo Not Use--Summary RecordsN
100        SYEDI Sales Order QuoteN
101        SZEDI Sales OrderN
102        TMEnterprise Treasury ManagementY