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

812: Top 10 requests

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

1 column | Print definition?910 | 74UALTF | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP74U: United Kingdom Localizations
1F74U0401SPC - Constants - UK - 4311SA74UALTFApplication Ledger Type - ForeignStringUDC20

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 09 / LT (Ledger Types) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        AAGeneral LedgerN
2        ACConsolidations LedgerN
3        AD"As If" Restatement LedgerN
4        AUGeneral Ledger UnitsN
5        AXCost Markup/Billing LedgerN
6        AZCash BasisN
7        B2Revised BudgetN
8        B3Budget Ledger Amount - 3rdN
9        BABudget AmountN
10        BUBudget Ledger UnitsN
11        BXBudget Assumptions - DollarsN
12        BZBudget Assumptions-StatisticsN
13        CAForeign CurrencyN
14        CDForeign Currency-Direct UpdateN
15        CUForeign Currency - UnitsN
16        D1Federal Tax -Book1N
17        D2State - 150% Decline BalN
18        D3Earn. & Profit-MACRSN
19        D4Alter. Minimum-200%N
20        D5MACRS AlternativeN
21        D7Revaluation LedgerN
22        E2Committed Out of ScopeN
23        E3Proceed in ScopeN
24        E4Proceed Out of ScopeN
25        E5Anticipated in ScopeN
26        E6Anticipated Other EstimateN
27        E7Potential Out of ScopeN
28        EUChange Management UnitsN
29        F%Percent of Job CompleteN
30        FAField Progress AmountsN
31        FEField Estimate LedgerN
32        FIFinancial InformationN
33        FMStored MaterialsN
34        FUField Progress UnitsN
35        GAActual Lease RevenuesN
36        GPGAAP AdjustmentsN
37        GUUnit Square Footage AmountsN
38        H%Percent CompleteN
39        HAProjected Final AmountN
40        HUProjected Final UnitsN
41        IAJob Cost Projection Budget AmtN
42        JAJob Cost Budget AmountN
43        JUJob Budgeted UnitsN
44        KANotice to Proceed - AmountsN
45        KUNotice to Proceed - UnitsN
46        LARequest Budget Changes AmountN
47        LURequest Budget Changes UnitsN
48        MAMemo Budget Changes AmountN
49        MUMemo Budget Changes UnitsN
50        NANotice to Proceed - AmountsN
51        NINet Insider LedgerN
52        NTNotice to Proceed - UnitsN
53        NUNet Insider Units LedgerN
54        PAPO/Contract AmountN
55        PRMonthly ProductionN
56        PUPO/Contract UnitsN
57        RARemaining Unit RateN
58        ROEncumbrance RolloverN
59        SASpeculative Lease AmountsN
60        TABook To Tax LedgerN
61        TB`754` Basis AdjustmentsN
62        TFBook To Tax Ledger - As IfN
63        TX1099 AdjustmentN
64        U2Opening AccountsN
65        XAAlternate LedgerUSDN
66        XTTransfer Cost LedgerN
67        YADomestic OriginN
68        ZAForeign OriginUSDN
69        ZUCash Basis UnitsN