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

155 columns | Print definition?910 | UM | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger33GLUMUnit of MeasureStringUDC20
2F4303MLog Models17PMUMUnit of MeasureStringUDC20
TOP03: Accounts Receivable
3F0311Accounts Receivable Ledger99RPUMUnit of MeasureStringUDC20
TOP03B: Enhanced Accounts Receivable
4F03B11Customer Ledger97RPUMUnit of MeasureStringUDC20
5F03B11PCustomer Ledger Purge File97RPUMUnit of MeasureStringUDC20
6F03B11Z1Batch Invoices113VJUMUnit of MeasureStringUDC20
7F03B11Z2F03B11 Interoperability Table110SYUMUnit of MeasureStringUDC20
8F03B575Auto Debit Invoice Select and Build106RDUMUnit of MeasureStringUDC20
TOP04: Accounts Payable
9F0411Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
10F0411AWF - As Of Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
11F0411PPurge - Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
12F0411Z1Voucher Transactions - Batch Upload95VLUMUnit of MeasureStringUDC20
13F0411Z3F0411 Interoperability Table100SZUMUnit of MeasureStringUDC20
TOP05: Time Accounting and HRM Base
14F06106Employee Pay Instructions24YMUMUnit of MeasureStringUDC20
15F0618Employee Transaction History27YTUMUnit of MeasureStringUDC20
16F069116Payroll Transaction Constants16YCUMUnit of MeasureStringUDC20
17F069162Job Type/ Item Cross Reference File5JHUMUnit of MeasureStringUDC20
TOP05T: Time Entry
18F06116Employee Transaction Detail File27YTUMUnit of MeasureStringUDC20
19F06116Z1Employee Transactions - Batch File44VLUMUnit of MeasureStringUDC20
20F06116Z2ESS Timecard History44VMUMUnit of MeasureStringUDC20
21F0623Piecework History File7JLUMUnit of MeasureStringUDC20
22F06278Retro Timecard Detail File30YTUMUnit of MeasureStringUDC20
23F06916Piecework Item Master3JJUMUnit of MeasureStringUDC20
24F069161Item Master Cross Reference File5JEUMUnit of MeasureStringUDC20
25F06918PF - Piece Rate File9JNUMUnit of MeasureStringUDC20
TOP07: Payroll
26F06156Pay Check History Summary12YUUMUnit of MeasureStringUDC20
27F06350IWF - Paycheck (Interims)24Y4UMUnit of MeasureStringUDC20
28F0716702Employee Assignment Rates9EAUMUnit of MeasureStringUDC20
29F071861Stub Detail Piece Rate History File12Y8UMUnit of MeasureStringUDC20
30F073521Stub Detail Piece Rate File12Y2UMUnit of MeasureStringUDC20
31F07UI200Timecard History Work File30THUMUnit of MeasureStringUDC20
TOP08: Human Resources
32F08711Employee Setup Tasks8ETUMUnit of MeasureStringUDC20
TOP08AD: ADP Integration
33F051371ADP Employee DBA Instructions29ADUMUnit of MeasureStringUDC20
34F051375ADP Payroll DBA Transaction Constants18ADUMUnit of MeasureStringUDC20
TOP09: General Accounting
35F0901Account Master13GMUMUnit of MeasureStringUDC20
36F0909Chart of Accounts - Reference File6ACUMUnit of MeasureStringUDC20
37F0911PPurge - Account Ledger33GLUMUnit of MeasureStringUDC20
38F0911RWF - Account Ledger Reconciliation30GLUMUnit of MeasureStringUDC20
39F0911Z1Journal Entry Transactions - Batch File50VNUMUnit of MeasureStringUDC20
40F0911Z4F0911 Interoperability Table55SZUMUnit of MeasureStringUDC20
41F0912Cost Allocations/Flex Budgeting34RJUMUnit of MeasureStringUDC20
42F09123Advanced Variable Numerator18VNUMUnit of MeasureStringUDC20
43F09UI015Indexed Computations Multi-Tiered Entries33GLUMUnit of MeasureStringUDC20
44F52G11Burdening Detail Ledger55BDUMUnit of MeasureStringUDC20
TOP09E: Expense Reimbursment
45F09E108Policy Edit Rules20PRUMUnit of MeasureStringUDC20
TOP12: Fixed Assets
46F1208Units of Production Schedule Master File4FPUMUnit of MeasureStringUDC20
47F1215Specification Cross Reference15GVUMUnit of MeasureStringUDC20
TOP13: Plant/Equipment Management
48F13017Equipment Parts List16PLUMUnit of MeasureStringUDC20
49F3111IGSWO Parts for IGS Integration8IGUMUnit of MeasureStringUDC20
TOP15: Property Management
50F1503Log Standards Master18NBUMUnit of MeasureStringUDC20
51F1514Area Master11NWUMUnit of MeasureStringUDC20
52F15141Gross Lease Occupied Areas12NCUMUnit of MeasureStringUDC20
53F1521Log Detail Master17NBUMUnit of MeasureStringUDC20
54F1523Log Standard Master10OGUMUnit of MeasureStringUDC20
55F15703Legal Clause Amounts7NIUMUnit of MeasureStringUDC20
TOP15L: Adv Real Estate Forecasting
56F15L101AREF Unit Master24UMUMUnit of MeasureStringUDC20
57F15L141AREF Gross Lease Occupied Area13GLUMUnit of MeasureStringUDC20
TOP17: Customer Service Management
58F1721Contract Detail64CDUMUnit of MeasureStringUDC20
59F3111Z2Warranty Claim/Supplier Recovery processing59WPUMUnit of MeasureStringUDC20
TOP17C: Call Management
60F1755Case Master178ZAUMUnit of MeasureStringUDC20
61F1760Time Entry55ZBUMUnit of MeasureStringUDC20
TOP18: Resource Scheduling
62F186602Labor Rules Tag File40TFUMUnit of MeasureStringUDC20
TOP30: Product Data Management
63F300210Lean Multi Level Bill of Material Header15EHUMUnit of MeasureStringUDC20
64F300211Lean Multi Level Bill of Material Detail23EDUMUnit of MeasureStringUDC20
65F3002Z1Bill of Material Transaction File27SZUMUnit of MeasureStringUDC20
66F3007Work Center Resource Units5WUUMUnit of MeasureStringUDC20
67F3016Kanban Master18KMUMUnit of MeasureStringUDC20
68F30UI008Bill of Material Comparison Work File5IJUMUnit of MeasureStringUDC20
69F30UI015BOM Item Fact Work File for BI11BDUMUnit of MeasureStringUDC20
70F30UI016BOM Explosion Work File for BI15BEUMUnit of MeasureStringUDC20
TOP31: Shop Floor Control
71F3111Work Order Parts List46WMUMUnit of MeasureStringUDC20
72F3111SPurge - Shop Floor Parts List46WMUMUnit of MeasureStringUDC20
73F3111Z1Outbound Work Order Parts List59SZUMUnit of MeasureStringUDC20
74F3118Shortage Maintenance Master File7WNUMUnit of MeasureStringUDC20
75F31UI802Accumulate Amounts by Account8WGUMUnit of MeasureStringUDC20
76F31UI803Work File for Summarizing Journal Entries8SGUMUnit of MeasureStringUDC20
TOP32: Configuration Management
77F3283Rules Table Detail32RDUMUnit of MeasureStringUDC20
78F3293Assembly Inclusions Rules25KYUMUnit of MeasureStringUDC20
TOP33: Capacity Planning
79F3303Capacity Resource Profile9CTUMUnit of MeasureStringUDC20
80F3311Capacity Message File8CNUMUnit of MeasureStringUDC20
81F3312Capacity Pegging8CWUMUnit of MeasureStringUDC20
82F3313Capacity Load Table4CRUMUnit of MeasureStringUDC20
TOP40: Inventory/OP Base
83F3002Bill of Material Master File14IXUMUnit of MeasureStringUDC20
84F3011Bill of Materials Change File14IZUMUnit of MeasureStringUDC20
85F3013ECO Parts List Detail18CYUMUnit of MeasureStringUDC20
86F30UI004Bill of Material Update Work File25WFUMUnit of MeasureStringUDC20
87F41002Item Units of Measure Conversion Factors3UMUMUnit of MeasureStringUDC20
88F41003Unit of Measure standard conversion1UCUMUnit of MeasureStringUDC20
89F49211Sales Order Detail File - Tag File11UDUMUnit of MeasureStringUDC20
90F49211Z1Sales Order Detail Tag Unedited Transaction File24S1UMUnit of MeasureStringUDC20
91F49219Sales Order Detail - Tag History File11UDUMUnit of MeasureStringUDC20
TOP40G: Grower Management
92F40G031Harvest Estimate Freeze Hdr10FHUMUnit of MeasureStringUDC20
TOP41: Inventory Management
93F41013Unique Product Number5UNUMUnit of MeasureStringUDC20
94F4118Container Deposit File7CNUMUnit of MeasureStringUDC20
95F41181Container Transaction File6CMUMUnit of MeasureStringUDC20
TOP41F: Apparel Management
96FCW17Work File F410024WFUMUnit of MeasureStringUDC20
97FCW67Style Work Order Parts List53WMUMUnit of MeasureStringUDC20
98FCW961Simulation Detailed Parts List15DLUMUnit of MeasureStringUDC20
TOP42: Sales Management
99F4020Freight/Additional Charges Rate Information27ARUMUnit of MeasureStringUDC20
100F42800G1Sales Update G Batch Detail Workfile23DGUMUnit of MeasureStringUDC20
TOP42B: Sales Order Entry
101F49299S.O. Detail Tag Ledger File11UDUMUnit of MeasureStringUDC20
TOP43: Procurement
102F4303Log Master19PKUMUnit of MeasureStringUDC20
103F4305Log Master27PLUMUnit of MeasureStringUDC20
TOP45: Advanced Pricing
104F4575Ship and Debit History51AHUMUnit of MeasureStringUDC20
105F4575TMPShip and Debit History - Temp Table51AHUMUnit of MeasureStringUDC20
106F4576Ship and Debit Claims79ACUMUnit of MeasureStringUDC20
107F4576TMPShip and Debit Claims- Temp Table79ACUMUnit of MeasureStringUDC20
108F4576Z1Ship and Debit Claims Unedited Transaction Table76Z1UMUnit of MeasureStringUDC20
TOP46: Warehouse Management
109F4142Warehouse Count Transactions40CTUMUnit of MeasureStringUDC20
TOP47: Electronic Commerce
110F47057EDI Payment Order Remittance Advice - Outbound88D3UMUnit of MeasureStringUDC20
111F47057WEDI Payment Order Remittance Advice - Work88D3UMUnit of MeasureStringUDC20
TOP48S: Service Billing
112F4812Billing Detail Workfile55WDUMUnit of MeasureStringUDC20
113F4812HBilling Workfile History55WDUMUnit of MeasureStringUDC20
114F4812HSBilling Workfile History Purged Save55WDUMUnit of MeasureStringUDC20
115F4822Invoice Summary Work File38W4UMUnit of MeasureStringUDC20
116F4823Voucher Summary34W0UMUnit of MeasureStringUDC20
117F48S0618Payroll Reclassification Workfile27YTUMUnit of MeasureStringUDC20
118F48S910Billing Detail Journal Workfile33W2UMUnit of MeasureStringUDC20
119F48S911Summarized Journal Workfile30W3UMUnit of MeasureStringUDC20
120F48SUI01Billing Detail Print Workfile55WDUMUnit of MeasureStringUDC20
TOP49: Transportation Management
121F4941Shipment Routing Steps35RSUMUnit of MeasureStringUDC20
122F4960Load Header49TMUMUnit of MeasureStringUDC20
TOP51: Job Costing
123F5109Chart Type Master7GJUMUnit of MeasureStringUDC20
TOP52: Contract Billing
124F5202Contract Billing Line Detail29G6UMUnit of MeasureStringUDC20
TOP52G: Government Contracting
125F4822HInvoice Summary History38IHUMUnit of MeasureStringUDC20
TOP53: Change Management
126F5302F5302 World Specs16DKUMUnit of MeasureStringUDC20
TOP55: Reserved for Clients
127F55IFP01Kit Pricing File31KPUMUnit of MeasureStringUDC20
128F59H0220CRM Case Tag File - Proposals12CCUMUnit of MeasureStringUDC20
129F59I0011Purchase Receipt - Buffer11P1UMUnit of MeasureStringUDC20
130F59I0012Purchase Receipt - Template12P1UMUnit of MeasureStringUDC20
TOP74U: United Kingdom Localizations
131F74U03BTLease Master Alternative UOM Tag File - 156PFUMUnit of MeasureStringUDC20
TOP75I: India
132F75I395BER - 5 (2)13ERUMUnit of MeasureStringUDC20
133F75I395TER - 5 (temp)13ERUMUnit of MeasureStringUDC20
TOP76A: Argentina
134F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A11DLUMUnit of MeasureStringUDC20
135F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A11DLUMUnit of MeasureStringUDC20
136F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A11DLUMUnit of MeasureStringUDC20
TOP76B: Brazil - Reporting System Only
137F76B3010Work Table for Item/Part List - 309IPUMUnit of MeasureStringUDC20
138F76B60Products Table - IN68 - 304PRUMUnit of MeasureStringUDC20
139F76B61Packing and Raw Material Table - IN68 - 306IEUMUnit of MeasureStringUDC20
TOP79A: Greenhouse Gas Accounting
140F79A39GHG Source UM Conversion2UMUMUnit of MeasureStringUDC20
TOP89: Conversion Programs
141F07352TPiece Rate Stub Detail Tag File12Y2UMUnit of MeasureStringUDC20
TOPF30L: DFM Line Design
142FF30L002DFM Bill of Material Master10DHUMUnit of MeasureStringUDC20
143FF30L116Components Consumed10CCUMUnit of MeasureStringUDC20
144FF30L512DFM Item Units of Measure Conversion Factors4UMUMUnit of MeasureStringUDC20
145FF30L513DFM Units of Measure Standard Conversion1UCUMUnit of MeasureStringUDC20
146FF30L801Sales Order Master9SDUMUnit of MeasureStringUDC20
TOPF31: Lean Transactions
147FF31010Production Master File27EHUMUnit of MeasureStringUDC20
148FF31011TransactionID Master File10EHUMUnit of MeasureStringUDC20
149FF31011SPurge - TransactionID Master File10ERUMUnit of MeasureStringUDC20
150FF31111Lean Transaction Parts List15PLUMUnit of MeasureStringUDC20
151FF31111SPurge - Lean Transaction Parts List15PRUMUnit of MeasureStringUDC20
152FF31112Routing Transaction Table60EHUMUnit of MeasureStringUDC20
153FF31112SPurge - Routing Transaction Table60ETUMUnit of MeasureStringUDC20
TOPF34S: DFM Production Sequencing
154FF34S002Daily Plan20DPUMUnit of MeasureStringUDC20
155FF34S01WDFM Plan Demand Work File12PDUMUnit of MeasureStringUDC20

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

TOPUDC 00 / UM (Unit of Measure) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        % PercentN
2        12Twelve PackN
3        ASAnnual Salary(rounded)xmult.N
4        ATAnnual Salary(truncated)xmult.N
5        BABar Absolute (Pressure)N
6        BCBagN
7        BGBar Gauge (Pressure)N
8        BKBucketN
9        BLBarrelsN
10        BTBottlesN
11        BUBushelN
12        BXBoxN
13        CACaseN
14        CCCubic CentimeterVN
15        CFHundred FeetN
16        CICubic InchesVN
17        CLCentilitersVN
18        CMCentimetersN
19        CNCanN
20        CRCartonN
21        CSHundred Square FeetN
22        CTCaratN
23        CWHundredweightWN
24        CYCubic YardVN
25        DCDecimetersN
26        DLDeciliterN
27        DRdrumsN
28        DWPenny Weight
29        DYDaysN
30        DZDozenN
31        EAEachN
32        FCCubic FeetVN
33        FFFeet/Inches/16thN
34        FOFluid OunceY
35        FTFeetN
36        G1100 GallonsN
37        GAGallonsVN
38        GMGramsWN
39        GPPotent GallonsVPN
40        GRGrossN
41        H1Half Hour CalculationsN
42        HAAverage Hourly RateN
43        HEHead CountN
44        HHHours X Hours WorkedN
45        HLHectoliterVN
46        HQHours per period (zero $)N
47        HRHourN
48        HTHectareN
49        HZHours x Hrs worked (zero $)N
50        ICCubic InchesVN
51        IGImperial GallonsVN
52        INInchesN
53        JTJointsN
54        KGKilogramsWN
55        KLKiloliter .N
56        KMKilometersN
57        KTKaratN
58        L3Pounds per square inchN
59        LBPoundsWN
60        LCCubic LitersVN
61        LFLinear FeetN
62        LGLogN
63        LPPotent LitersVPN
64        LSLump SumN
65        LTLitersVN
66        M3Cubic MetersVN
67        MFThousand FeetN
68        MGMilligramsWN
69        MHMan HourN
70        MIMilesN
71        MKMicrogramsWN
72        MLMilliliterVN
73        MMMillimeters .N
74        MNMinutesY
75        MOMonthsN
76        MPThousand PiecesN
77        MSThousand Square FeetN
78        MTMetersN
79        MWThousand PoundsWN
80        OPPotent OuncesPN
81        OTTroy OuncesN
82        OZOuncesWN
83        PCPiecesN
84        PDPadN
85        PLPalletN
86        PRPairN
87        PTPintVN
88        QTQuartVN
89        RDRental DepositN
90        RLRollN
91        RMReamN
92        RT$1000s of SalaryN
93        SCSquare CentimetersN
94        SESecondsY
95        SFSquare FeetN
96        SISquare InchesN
97        SKSkeinN
98        SLSleeveN
99        SMSquare MetersN
100        SPSpaces
101        SXSix PackN
102        SYSquare YardN
103        TKTankN
104        TLLong Ton (English)WN
105        TMMetric TonWN
106        TNTon (U.S.)WN
107        TSShort Ton (U.S.)WN
108        UNUnitsN
109        WKWeeksN
110        WUWeld UnitsN
111        XLExcess LifeN
112        YDYardsN
113        YRYearN
114        Z Set (3-PW)N