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

86 columns | Print definition?812 | 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
6F1755Customer Call 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
TOP55: Reserved for Clients
77F55IF421Sales Order per BO10SDOCTOOriginal Order TypeStringUDC20
78F55IF425Sales Order per BO - 200510SDOCTOOriginal Order TypeStringUDC20
79F55IFP03Checking Credit Note Number WF6WFOCTOOriginal Order TypeStringUDC20
80F55W0100Correction Invoice Print - WF111SDOCTOOriginal Order TypeStringUDC20
81F74P0710Credit Order History9PLOCTOOriginal Order TypeStringUDC20
82F59H0220CRM Case Tag File - Proposals4CCOCTOOriginal Order TypeStringUDC20
TOP76B: Brazil - Reporting System Only
83F7601BNota Fiscal Header - Brazil9FHOCTOOriginal Order TypeStringUDC20
84F7611BNota Fiscal Detail - Brazil11FDOCTOOriginal Order TypeStringUDC20
85F761BAAS Fiscal file book10FBOCTOOriginal Order TypeStringUDC20
TOP89: Conversion Programs
86F43199ATemp 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        $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