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

151 columns | Print definition?910 | LT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0025Ledger Type Master File1LHLTLedger TypesStringUDC20
2F0902Account Balances5GBLTLedger TypesStringUDC20
3F0911Account Ledger22GLLTLedger TypesStringUDC20
TOP05: Time Accounting and HRM Base
4F069106Union Benefits Master14Y1LTLedger TypesStringUDC20
TOP05T: Time Entry
5F063951Payroll Journal (Compressed) File7GLLTLedger TypesStringUDC20
TOP07: Payroll
6F05290WF - Payroll Journal (Detail)7JRLTLedger TypesStringUDC20
TOP09: General Accounting
7F0902BAccount Balances - 52 Period Accounting5GBLTLedger TypesStringUDC20
8F0902PPurge - Account Balances5GBLTLedger TypesStringUDC20
9F0902Z1Account Balances - Batch File5GBLTLedger TypesStringUDC20
10F0911PPurge - Account Ledger22GLLTLedger TypesStringUDC20
11F0911RWF - Account Ledger Reconciliation22GLLTLedger TypesStringUDC20
12F0911R1Account Reconciliations Header - OneWorld ONLY8GLLTLedger TypesStringUDC20
13F0911Z1Journal Entry Transactions - Batch File39VNLTLedger TypesStringUDC20
14F0911Z4F0911 Interoperability Table44SZLTLedger TypesStringUDC20
15F0912Cost Allocations/Flex Budgeting17RJLTLedger TypesStringUDC20
16F0912AIndex Computation Entry File13RILTLedger TypesStringUDC20
17F09UI004Variable Numerator Allocations work file14R#LTLedger TypesStringUDC20
18F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY15GLLTLedger TypesStringUDC20
19F09UI009Trial Balance Generic Work File - OneWorld ONLY3GBLTLedger TypesStringUDC20
20F09UI010WorkFile for R0970115WFLTLedger TypesStringUDC20
21F09UI013Company by Batch Out of Balance4GLLTLedger TypesStringUDC20
22F09UI014Annual Close Work Table8GBLTLedger TypesStringUDC20
23F09UI015Indexed Computations Multi-Tiered Entries22GLLTLedger TypesStringUDC20
24F09UI016Account Balance Compare Exceptions5GWLTLedger TypesStringUDC20
25F09UI123Advanced Variable Numerator Worktable19VWLTLedger TypesStringUDC20
26F52G02Burdening Summarized Ledger4BSLTLedger TypesStringUDC20
27F52G11Burdening Detail Ledger6BDLTLedger TypesStringUDC20
28F52G11WFTemporary Burdened Detail Ledger Workfile6BWLTLedger TypesStringUDC20
29F52G31WFReburdening Transactions Workfile3RBLTLedger TypesStringUDC20
30F52G60Burden Rate Calculations Workfile2BWLTLedger TypesStringUDC20
31F70UI001Work File for G/L by Cat. Code Localization11WALTLedger TypesStringUDC20
32F740911Work File for G/L Report by Category Code Localization14WALTLedger TypesStringUDC20
TOP10: Financial Reporting
33F1001Multi-Site Consolidation Transfer File Header14GPLTLedger TypesStringUDC20
34F1001Z1Unedited MSC Interoperability Header Table24IALTLedger TypesStringUDC20
35F10UI520Cash Flow Statement Worktable5CWLTLedger TypesStringUDC20
TOP12: Fixed Assets
36F12003Default Depreciation Constants4FFLTLedger TypesStringUDC20
37F1202Asset Account Balances File5FLLTLedger TypesStringUDC20
38F1202PAsset Account Balances Purge Table5FLLTLedger TypesStringUDC20
39F1208Units of Production Schedule Master File2FPLTLedger TypesStringUDC20
40F12141Disposal Account Rule Table3DTLTLedger TypesStringUDC20
41F12911ERPost G/L to FA Exceptions Work File7GLLTLedger TypesStringUDC20
TOP13E: Equipment Cost Analysis
42F1383Equipment Analysis Costs9ECLTLedger TypesStringUDC20
43F1385Equipment Analysis Rules3ERLTLedger TypesStringUDC20
TOP15: Property Management
44F15302Ledger Type Groups3LTLTLedger TypesStringUDC20
45F1532BExpense Participation Audit File13NTLTLedger TypesStringUDC20
TOP16: Profit Management (EPS)
46F1602Cost Analyzer Balances5CBLTLedger TypesStringUDC20
47F1602Z1External Cost Analyzer Balances - Interoperability Table27CZLTLedger TypesStringUDC20
48F1603Cost Analyzer View Structure14CVLTLedger TypesStringUDC20
49F1610Cost Calculation Definitions41CDLTLedger TypesStringUDC20
50F1611Cost Calculation Transactions14CTLTLedger TypesStringUDC20
51F1632Driver Balances4CBLTLedger TypesStringUDC20
52F1632Z1External Driver Balances-Interoperability Table26CYLTLedger TypesStringUDC20
53F1642Rate Master Header File1RHLTLedger TypesStringUDC20
TOP39: Advanced Stock Valuation
54F3910G/L Adjustment Table12SCLTLedger TypesStringUDC20
TOP40: Inventory/OP Base
55F4011ZBatch Receiver File - Order Details197SZLTLedger TypesStringUDC20
56F49211Sales Order Detail File - Tag File116UDLTLedger TypesStringUDC20
57F49211Z1Sales Order Detail Tag Unedited Transaction File135S1LTLedger TypesStringUDC20
58F49219Sales Order Detail - Tag History File93UDLTLedger TypesStringUDC20
TOP41: Inventory Management
59F4115Item History6IHLTLedger TypesStringUDC20
TOP42: Sales Management
60F42800GSales Update G Batch Workfile15SGLTLedger TypesStringUDC20
61F470371TTag for F470371- EDI shipping Notice Detail - Outbound36UZLTLedger TypesStringUDC20
TOP42B: Sales Order Entry
62F49299S.O. Detail Tag Ledger File116UDLTLedger TypesStringUDC20
TOP43: Procurement
63F43080Approvals Fields Constants128PDLTLedger TypesStringUDC20
64F4311Purchase Order Detail File124PDLTLedger TypesStringUDC20
65F4311ZPurchase Order Generator File128PWLTLedger TypesStringUDC20
66F4311Z1Purchase Order Detail Unedited Transaction Table137SZLTLedger TypesStringUDC20
67F43199P.O. Detail Ledger File - Flexible Version124OLLTLedger TypesStringUDC20
TOP44H: Homebuilder Management
68F44H590Closing Worksheet Accounting Instructions8CILTLedger TypesStringUDC20
69F44H591Closing Worksheet Entries11CWLTLedger TypesStringUDC20
70F44H611Bid Details63BDLTLedger TypesStringUDC20
71F44H611WBid Details Work File67BWLTLedger TypesStringUDC20
72F44H711Lot Start Workfile74SWLTLedger TypesStringUDC20
73F44H711ZHB Lot Start Unedited Transaction File87SZLTLedger TypesStringUDC20
74F44H71W1Lot Start Generation Workfile74GWLTLedger TypesStringUDC20
TOP47: Electronic Commerce
75F47012EDI Purchase Order Detail - Inbound198SZLTLedger TypesStringUDC20
76F47017EDI Purchase Order Detail - Outbound138SZLTLedger TypesStringUDC20
77F47022EDI P.O. Acknowledgment Detail - Inbound138SZLTLedger TypesStringUDC20
78F47027EDI P.O. Acknowledgment Detail - Outbound198SZLTLedger TypesStringUDC20
79F47047EDI Invoice Detail (Sales) - Outbound198SZLTLedger TypesStringUDC20
80F47072EDI Receiving Advice Detail - Inbound139SZLTLedger TypesStringUDC20
81F47077EDI Receiving Advice Detail - Outbound139SZLTLedger TypesStringUDC20
82F47092EDI Request for Quote Detail - Inbound198SZLTLedger TypesStringUDC20
83F47097EDI Request for Quote Detail - Outbound138SZLTLedger TypesStringUDC20
84F47102EDI Response to RFQ Detail - Inbound138SZLTLedger TypesStringUDC20
85F47107EDI Response to RFQ Detail - Outbound197SZLTLedger TypesStringUDC20
86F47132EDI Purchase Order Change Detail - Inbound199SZLTLedger TypesStringUDC20
87F47137EDI Purchase Order Change Detail - Outbound139SZLTLedger TypesStringUDC20
88F47142EDI P.O. Change Acknowledgment Detail - Inbound140SZLTLedger TypesStringUDC20
89F47147EDI P.O. Change Acknowledgment Detail - Outbound200SZLTLedger TypesStringUDC20
90F47157EDI Shipping Schedule Detail - Outbound147SZLTLedger TypesStringUDC20
TOP48S: Service Billing
91F4812Billing Detail Workfile16WDLTLedger TypesStringUDC20
92F4812HBilling Workfile History16WDLTLedger TypesStringUDC20
93F4812HSBilling Workfile History Purged Save16WDLTLedger TypesStringUDC20
94F48S910Billing Detail Journal Workfile24W2LTLedger TypesStringUDC20
95F48S911Summarized Journal Workfile22W3LTLedger TypesStringUDC20
96F48S912G/L Link5W6LTLedger TypesStringUDC20
97F48S95Billing AAI Information21WVLTLedger TypesStringUDC20
98F48SUI01Billing Detail Print Workfile16WDLTLedger TypesStringUDC20
TOP55: Reserved for Clients
99F55IF421Sales Order per BO189SDLTLedger TypesStringUDC20
100F55IF425Sales Order per BO - 2005189SDLTLedger TypesStringUDC20
101F74T550General Ledger Work File - Turkish25DKLTLedger TypesStringUDC20
102F74T550BGeneral Ledger PO Work File - Turkish12POLTLedger TypesStringUDC20
TOP74: EMEA Localization
103F749103Section Column Definition - EMEA - 7413CDLTLedger TypesStringUDC20
104F749105Cells Definition - EMEA - 7411EDLTLedger TypesStringUDC20
TOP74H: Hungary
105F741202Work File Accumulated Asset Movement Dep - HUN - 745WFLTLedger TypesStringUDC20
TOP74P: Poland
106F74902TAccount Balance Tag File - COM - 09 - 74P5ATLTLedger TypesStringUDC20
107F74P9100Cash Desk Transaction - POL - 74P9CDLTLedger TypesStringUDC20
TOP74R: CIS
108F74R0018Russian Tax File - 74R71TDLTLedger TypesStringUDC20
109F74R0100Petty Cash Transactions - RUS - 00 - 74R10PCLTLedger TypesStringUDC20
110F74R9002Correspondence Balance - RUS- 09 - 74R6GBLTLedger TypesStringUDC20
111F74R9029Open Accounts - RUS - 09 - 74R7OALTLedger TypesStringUDC20
TOP74U: United Kingdom Localizations
112F74U0412Application Commitment Workfile - UK - 437ACLTLedger TypesStringUDC20
113F74U0414Certificate Commitment Workfile - UK - 437CCLTLedger TypesStringUDC20
114F74U0416Purchase Order Commitment Workfile - UK - 437PCLTLedger TypesStringUDC20
TOP75C: China - Reporting System Only
115F75C015Cash Flow Data - China22CFLTLedger TypesStringUDC20
116F75C202Asset Disposal Amounts - CHINA2DALTLedger TypesStringUDC20
117F75C902Subsidiary Balances File - China4SBLTLedger TypesStringUDC20
118F75C911CNAO - E1 Document Number mapping - China5DNLTLedger TypesStringUDC20
119F75C911AAccount Ledger Processing Info- China - 095ALLTLedger TypesStringUDC20
120F75C912Transaction-wise Subsidiary Info - China - 095TSLTLedger TypesStringUDC20
121F75CUI1China Financial Report Work File - 1023CFLTLedger TypesStringUDC20
122F75CUI2China Financial Report Staging Work File - 105CFLTLedger TypesStringUDC20
TOP76A: Argentina
123F76A41CERG G/L - Lot Detail - ARG - 09 - 76A8LDLTLedger TypesStringUDC20
TOP76B: Brazil - Reporting System Only
124F76B835FCONT Account Ledger Operation - 76B6AOLTLedger TypesStringUDC20
125F76B902IN86-Work Table for Account Balance - 0915BCLTLedger TypesStringUDC20
126F76B911IN86-Work Table for Journal Entries - 0920BDLTLedger TypesStringUDC20
127F76B937SPED Book Ledger Types2LTLTLedger TypesStringUDC20
TOP76C: Colombia
128F76C0902Debits and Credits T/B by object account - COL - 76C5GBLTLedger TypesStringUDC20
129F76C575Work File Magnetic Media - COL - 046Q1LTLedger TypesStringUDC20
130F76C9415Workfile for Dialy Book - COL - 0912LDLTLedger TypesStringUDC20
131F76C9F02DIAN Formats by AccountID - COL - 098DFLTLedger TypesStringUDC20
132F76C9F11DIAN Formats File by Account Id - COL - 095DFLTLedger TypesStringUDC20
133F76CT1Tributary Information - COL - 76C6TILTLedger TypesStringUDC20
TOP76H: Chile
134F76H6001Actual Cost Process Header - CHI - 41 - 76H11PHLTLedger TypesStringUDC20
135F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H8I1LTLedger TypesStringUDC20
136F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H5I2LTLedger TypesStringUDC20
137F76H6005Account ID / Cost Type Relationship - CHI - 41 - 76H1ACLTLedger TypesStringUDC20
138F76H6201Replacement Cost Process Header - CHI - 4110RHLTLedger TypesStringUDC20
139F76H902TAccount Balances Tag File - CHI - 09 - 76H5ATLTLedger TypesStringUDC20
TOP76M: Mexico
140F76M990GL VAT on Gain/loss MEX - 76M6GLLTLedger TypesStringUDC20
TOP76P: Peru
141F76P502Asset ledger set up - PER - 12 - 76P4ALLTLedger TypesStringUDC20
TOP80D: Plant Manager Dashboard
142F80D020G/L Balances Fact Table2GLLTLedger TypesStringUDC20
TOP83: Management Reporting - FASTR
143F83UI001Balance Audit Work File - (Financial Reporting)10R1LTLedger TypesStringUDC20
TOP89: Conversion Programs
144F0902AAccount Debit Balances5GDLTLedger TypesStringUDC20
145F0911TNeeded for upgrade for XE and below5GLLTLedger TypesStringUDC20
146F42119BSales Order History File - temporary for upgrade (2)11SDLTLedger TypesStringUDC20
147F4211BSales Order Detail File - temporary for upgrade (2)11SDLTLedger TypesStringUDC20
148F43199ATemp F43199 for ERP 9.0 Upgrade124OLLTLedger TypesStringUDC20
TOPH95: Tech Resources/Applications
149F8304FASTR - Column Specifications Master File10R4LTLedger TypesStringUDC20
150F8305FASTR - Row Specifications Master File7R5LTLedger TypesStringUDC20
151F8306FASTR - Cell Specifications Master File7R6LTLedger TypesStringUDC20

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