JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

81 columns | Print definition?812 | 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
7F03B11Z1Invoice Transactions - Batch File87VJODCTDocument Type - OriginalStringUDC20
8F03B11Z2F03B11 Interoperability Table84SYODCTDocument Type - OriginalStringUDC20
9F03B14A/R Check Detail File81RZODCTDocument 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
TOP04: Accounts Payable
14F0411Accounts Payable Ledger57RPODCTDocument Type - OriginalStringUDC20
15F0411AWF - As Of - Accounts Payable Ledger57RPODCTDocument Type - OriginalStringUDC20
16F0411PPurge - Accounts Payable Ledger57RPODCTDocument Type - OriginalStringUDC20
17F0411Z1Voucher Transactions - Batch File75VLODCTDocument Type - OriginalStringUDC20
18F0411Z3F0411 Interoperability Table80SZODCTDocument Type - OriginalStringUDC20
TOP09: General Accounting
19F0911PPurge - Account Ledger43GLODCTDocument Type - OriginalStringUDC20
20F0911Z1Journal Entry Transactions - Batch File60VNODCTDocument Type - OriginalStringUDC20
21F0911Z4F0911 Interoperability Table65SZODCTDocument Type - OriginalStringUDC20
22F09UI015Indexed Computations Multi-Tiered Entries43GLODCTDocument Type - OriginalStringUDC20
TOP15: Property Management
23F1511Tenant/Lease Billings Detail83NJODCTDocument Type - OriginalStringUDC20
24F1511BTenant/Lease Billings Detail Master79NJODCTDocument Type - OriginalStringUDC20
25F1511HTenant/Lease Billings Detail History82N#ODCTDocument Type - OriginalStringUDC20
26F1511HBTenant/Lease Billings Detail History78NCODCTDocument Type - OriginalStringUDC20
TOP40: Inventory/OP Base
27F4011ZBatch Receiver File - Order Details119SZODCTDocument Type - OriginalStringUDC20
28F4211Z1Sales Order Detail Unedited Transaction File113SZODCTDocument Type - OriginalStringUDC20
TOP42: Sales Management
29F4211Sales Order Detail File100SDODCTDocument Type - OriginalStringUDC20
30F42119Sales Order History File100SDODCTDocument Type - OriginalStringUDC20
31F42199S.O. Detail Ledger File100SLODCTDocument Type - OriginalStringUDC20
32F42565Invoice Print File167IWODCTDocument Type - OriginalStringUDC20
33F42UI11SO Detail Cache File (MBF)78ZDODCTDocument Type - OriginalStringUDC20
TOP43: Procurement
34F4311ZPurchase Order Generator File220PWODCTDocument Type - OriginalStringUDC20
TOP45: Advanced Pricing
35F4576Z1Ship and Debit Claims Unedited Transaction Table147Z1ODCTDocument Type - OriginalStringUDC20
TOP47: Electronic Commerce
36F47012EDI Purchase Order Detail - Inbound120SZODCTDocument Type - OriginalStringUDC20
37F47027EDI P.O. Acknowledgment Detail - Outbound120SZODCTDocument Type - OriginalStringUDC20
38F47037EDI Shipping Notice Detail - Outbound110SZODCTDocument Type - OriginalStringUDC20
39F470371EDI Shipping Notice Detail - Outbound126SZODCTDocument Type - OriginalStringUDC20
40F47047EDI Invoice Detail (Sales) - Outbound120SZODCTDocument Type - OriginalStringUDC20
41F47057EDI Payment Order Remittance Advice - Outbound44D3ODCTDocument Type - OriginalStringUDC20
42F47057WEDI Payment Order Remittance Advice - Work44D3ODCTDocument Type - OriginalStringUDC20
43F47092EDI Request for Quote Detail - Inbound120SZODCTDocument Type - OriginalStringUDC20
44F47107EDI Response to RFQ Detail - Outbound120SZODCTDocument Type - OriginalStringUDC20
45F47132EDI Purchase Order Change Detail - Inbound121SZODCTDocument Type - OriginalStringUDC20
46F47147EDI P.O. Change Acknowledgment Detail - Outbound122SZODCTDocument Type - OriginalStringUDC20
TOP48S: Service Billing
47F4812Billing Detail Workfile21WDODCTDocument Type - OriginalStringUDC20
48F4812HBilling Workfile - History21WDODCTDocument Type - OriginalStringUDC20
49F4812HSBilling Workfile History Purged Save21WDODCTDocument Type - OriginalStringUDC20
50F48SUI01Billing Detail Print Workfile21WDODCTDocument Type - OriginalStringUDC20
TOP49: Transportation Management
51F4981Freight Audit History43FHODCTDocument Type - OriginalStringUDC20
TOP55: Reserved for Clients
52F55IF421Sales Order per BO109SDODCTDocument Type - OriginalStringUDC20
53F55IF425Sales Order per BO - 2005109SDODCTDocument Type - OriginalStringUDC20
54F55IFP03Checking Credit Note Number WF3WFODCTDocument Type - OriginalStringUDC20
55F55W0100Correction Invoice Print - WF1101SDODCTDocument Type - OriginalStringUDC20
56F74H1051Invoicing Workfile - New31IWODCTDocument Type - OriginalStringUDC20
57F74P0710Credit Order History14PLODCTDocument Type - OriginalStringUDC20
58F59H0223Order/Proposal Credit Batch3WFODCTDocument Type - OriginalStringUDC20
TOP74: EMEA Localization
59F7430015Invoices Related to AR DN/CN - COMM - 03B5DRODCTDocument Type - OriginalStringUDC20
TOP74P: Poland
60F74P411HF0411 Header File - POL - 04 - 74P6P4ODCTDocument Type - OriginalStringUDC20
TOP75T: Taiwan
61F75T004ZGUI/VAT Transaction Header - Work - 75T4ZHODCTDocument Type - OriginalStringUDC20
62F75T005ZGUI/VAT Transaction Detail - Work - 75T4ZDODCTDocument Type - OriginalStringUDC20
TOP76A: Argentina
63F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A42HFODCTDocument Type - OriginalStringUDC20
64F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A42HFODCTDocument Type - OriginalStringUDC20
65F76A81A/P Payment Control Group File - ARG - 04 - 76A23C5ODCTDocument Type - OriginalStringUDC20
66F76A82A/P Payment Control Group File - ARG - 04 - 76A34C6ODCTDocument Type - OriginalStringUDC20
67F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 0042HFODCTDocument Type - OriginalStringUDC20
TOP76B: Brazil - Reporting System Only
68F76B0411Voucher Additional Information Brazil - 0424VBODCTDocument Type - OriginalStringUDC20
69F76B473TF04573 Brazilian Temp WH File - BR - 0428W3ODCTDocument Type - OriginalStringUDC20
TOP76C: Colombia
70F76C031AA/R Customer ledger As Of - F76C031A - COL - 0470RPODCTDocument Type - OriginalStringUDC20
71F76C034AA/R Check Detail file As Of - COL - 76C81RZODCTDocument Type - OriginalStringUDC20
72F76C575Work File Magnetic Media - COL - 0447Q1ODCTDocument Type - OriginalStringUDC20
TOP76H: Chile
73F76H3B15NC/ND - Invoice Related - CHI - 03B - 76H5IRODCTDocument Type - OriginalStringUDC20
74F76H3B20Invoices not Printed - CHI - 03B - 76H13ADODCTDocument Type - OriginalStringUDC20
75F76HUI31Document Related Work File - CHI - 42 - 76H7DRODCTDocument Type - OriginalStringUDC20
TOP76M: Mexico
76F76M0314Receipt Detail Tag File - Mexico12MAODCTDocument Type - OriginalStringUDC20
77F76M0414F0414 - Payment Detail Tag File - Mexico13RTODCTDocument Type - OriginalStringUDC20
TOP76P: Peru
78F76P411TPeru AP Tag File - PER - 04 - 76P22T4ODCTDocument Type - OriginalStringUDC20
79F76P480SPOT Voucher Information - PER - 04 - 76P5SVODCTDocument Type - OriginalStringUDC20
TOP76V: Venezuela
80F76V4015Vouchers Related to Credit/Debit Notes - VEN - 045CDODCTDocument Type - OriginalStringUDC20
81F76V4581Withholding 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