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

36 columns | Print definition?910 | PDCT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger47GLPDCTDocument Type - Purchase OrderStringUDC20
TOP03: Accounts Receivable
2F0311Accounts Receivable Ledger134RPPDCTDocument Type - Purchase OrderStringUDC20
3F0312A/R Batch Cash Application45RUPDCTDocument Type - Purchase OrderStringUDC20
TOP03B: Enhanced Accounts Receivable
4F03B11Customer Ledger76RPPDCTDocument Type - Purchase OrderStringUDC20
5F03B11PCustomer Ledger Purge File76RPPDCTDocument Type - Purchase OrderStringUDC20
6F03B11Z1Batch Invoices92VJPDCTDocument Type - Purchase OrderStringUDC20
7F03B11Z2F03B11 Interoperability Table89SYPDCTDocument Type - Purchase OrderStringUDC20
8F03B14Receipts Detail73RZPDCTDocument Type - Purchase OrderStringUDC20
9F03B14PReceipts Detail Purge File73RZPDCTDocument Type - Purchase OrderStringUDC20
10F03B14Z2F03B14 Interoperability Table86SZPDCTDocument Type - Purchase OrderStringUDC20
11F03B575Auto Debit Invoice Select and Build85RDPDCTDocument Type - Purchase OrderStringUDC20
TOP04: Accounts Payable
12F0411Accounts Payable Ledger64RPPDCTDocument Type - Purchase OrderStringUDC20
13F0411AWF - As Of Accounts Payable Ledger64RPPDCTDocument Type - Purchase OrderStringUDC20
14F0411PPurge - Accounts Payable Ledger64RPPDCTDocument Type - Purchase OrderStringUDC20
15F0411Z1Voucher Transactions - Batch Upload82VLPDCTDocument Type - Purchase OrderStringUDC20
16F0411Z3F0411 Interoperability Table87SZPDCTDocument Type - Purchase OrderStringUDC20
17F04572A/P Payment Processing - Summary39KKPDCTDocument Type - Purchase OrderStringUDC20
18F04573A/P Payment Processing - Detail29KIPDCTDocument Type - Purchase OrderStringUDC20
TOP09: General Accounting
19F0911PPurge - Account Ledger47GLPDCTDocument Type - Purchase OrderStringUDC20
20F0911RWF - Account Ledger Reconciliation83GLPDCTDocument Type - Purchase OrderStringUDC20
21F0911Z1Journal Entry Transactions - Batch File64VNPDCTDocument Type - Purchase OrderStringUDC20
22F0911Z4F0911 Interoperability Table69SZPDCTDocument Type - Purchase OrderStringUDC20
23F09UI015Indexed Computations Multi-Tiered Entries47GLPDCTDocument Type - Purchase OrderStringUDC20
TOP42: Sales Management
24F42800G1Sales Update G Batch Detail Workfile37DGPDCTDocument Type - Purchase OrderStringUDC20
TOP47: Electronic Commerce
25F47057EDI Payment Order Remittance Advice - Outbound49D3PDCTDocument Type - Purchase OrderStringUDC20
26F47057WEDI Payment Order Remittance Advice - Work49D3PDCTDocument Type - Purchase OrderStringUDC20
27F47114EDI Lockbox/Payment Detail - Payment25Z4PDCTDocument Type - Purchase OrderStringUDC20
TOP48S: Service Billing
28F4812Billing Detail Workfile26WDPDCTDocument Type - Purchase OrderStringUDC20
29F4812HBilling Workfile History26WDPDCTDocument Type - Purchase OrderStringUDC20
30F4812HSBilling Workfile History Purged Save26WDPDCTDocument Type - Purchase OrderStringUDC20
31F48SUI01Billing Detail Print Workfile26WDPDCTDocument Type - Purchase OrderStringUDC20
TOP75I: India
32F75I2241WorkFile for VAT/CST Receivables12VCPDCTDocument Type - Purchase OrderStringUDC20
TOP76B: Brazil - Reporting System Only
33F7611BNota Fiscal Detail - BRA - 4214FDPDCTDocument Type - Purchase OrderStringUDC20
34F761BAAS Fiscal file book - 0913FBPDCTDocument Type - Purchase OrderStringUDC20
35F76B8200IN86-Work Table for Fixed Assets - 1214FAPDCTDocument Type - Purchase OrderStringUDC20
TOP76C: Colombia
36F76C034AA/R Check Detail file As Of - COL - 03B73RZPDCTDocument Type - Purchase OrderStringUDC20

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