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

146 columns | Print definition?812 | UM | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger33GLUMUnit of MeasureStringUDC20
2F4303Log Master19PKUMUnit of MeasureStringUDC20
3F4303MLog Models17PMUMUnit of MeasureStringUDC20
TOP03: Accounts Receivable
4F0311Accounts Receivable Ledger99RPUMUnit of MeasureStringUDC20
TOP03B: Enhanced Accounts Receivable
5F03B11Customer Ledger97RPUMUnit of MeasureStringUDC20
6F03B11PCustomer Ledger Purge File97RPUMUnit of MeasureStringUDC20
7F03B11Z1Invoice Transactions - Batch File113VJUMUnit of MeasureStringUDC20
8F03B11Z2F03B11 Interoperability Table110SYUMUnit of MeasureStringUDC20
9F03B575Auto Debit Invoice Select and Build106RDUMUnit of MeasureStringUDC20
TOP04: Accounts Payable
10F0411Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
11F0411AWF - As Of - Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
12F0411PPurge - Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
13F0411Z1Voucher Transactions - Batch File95VLUMUnit of MeasureStringUDC20
14F0411Z3F0411 Interoperability Table100SZUMUnit of MeasureStringUDC20
TOP05: Time Accounting and HRM Base
15F06106Employee Pay Instructions24YMUMUnit of MeasureStringUDC20
16F0618Employee Transaction History27YTUMUnit of MeasureStringUDC20
17F069116Payroll Transaction Constants16YCUMUnit of MeasureStringUDC20
18F069162Job Type/ Item Cross Reference File5JHUMUnit of MeasureStringUDC20
TOP05T: Time Entry
19F06116Employee Transaction Detail File27YTUMUnit of MeasureStringUDC20
20F06116Z1Employee Transactions - Batch File44VLUMUnit 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 - Acct Ledger File for Reconciliation30GLUMUnit of MeasureStringUDC20
39F0911Z1Journal Entry Transactions - Batch File50VNUMUnit of MeasureStringUDC20
40F0911Z4F0911 Interoperability Table55SZUMUnit of MeasureStringUDC20
41F0912Cost Allocations/Flex Budgeting34RJUMUnit of MeasureStringUDC20
42F09UI015Indexed Computations Multi-Tiered Entries33GLUMUnit of MeasureStringUDC20
TOP09E: Expense Reimbursment
43F09E108Policy Edit Rules20PRUMUnit of MeasureStringUDC20
TOP12: Fixed Assets
44F1208Units of Production Schedule Master File4FPUMUnit of MeasureStringUDC20
45F1215Specification Cross Reference15GVUMUnit of MeasureStringUDC20
TOP13: Plant/Equipment Management
46F13017Equipment Parts List16PLUMUnit of MeasureStringUDC20
47F3111IGSWO Parts for IGS Integration8IGUMUnit of MeasureStringUDC20
TOP15: Property Management
48F1503Log Standards Master18NBUMUnit of MeasureStringUDC20
49F1514Area Master11NWUMUnit of MeasureStringUDC20
50F15141Gross Lease Occupied Areas12NCUMUnit of MeasureStringUDC20
51F1521Log Detail Master17NBUMUnit of MeasureStringUDC20
52F1523Log Standard Master10OGUMUnit of MeasureStringUDC20
53F15703Legal Clause Amounts7NIUMUnit of MeasureStringUDC20
TOP15L: Adv Real Estate Forecasting
54F15L101AREF Unit Master24UMUMUnit of MeasureStringUDC20
55F15L141AREF Gross Lease Occupied Area13GLUMUnit of MeasureStringUDC20
TOP17: Customer Service Management
56F1721Contract Detail64CDUMUnit of MeasureStringUDC20
57F3111Z2Warranty Claim/Supplier Recovery processing59WPUMUnit of MeasureStringUDC20
TOP17C: Call Management
58F1755Customer Call Master178ZAUMUnit of MeasureStringUDC20
59F1760Time Entry55ZBUMUnit of MeasureStringUDC20
TOP18: Resource Scheduling
60F186602Labor Rules Tag File40TFUMUnit of MeasureStringUDC20
TOP30: Product Data Management
61F300210Lean Multi Level Bill of Material Header15EHUMUnit of MeasureStringUDC20
62F300211Lean Multi Level Bill of Material Detail23EDUMUnit of MeasureStringUDC20
63F3002Z1Bill of Material Transaction File27SZUMUnit of MeasureStringUDC20
64F3007Work Center Resource Units5WUUMUnit of MeasureStringUDC20
65F3016Kanban Master18KMUMUnit of MeasureStringUDC20
66F30UI008Bill of Material Comparison Work File5IJUMUnit of MeasureStringUDC20
TOP31: Shop Floor Control
67F3111Work Order Parts List46WMUMUnit of MeasureStringUDC20
68F3111SPurge - Shop Floor Parts List46WMUMUnit of MeasureStringUDC20
69F3111Z1Outbound Work Order Parts List59SZUMUnit of MeasureStringUDC20
70F3118Shortage Maintenance Master File7WNUMUnit of MeasureStringUDC20
71F31UI802Accumulate Amounts by Account8WGUMUnit of MeasureStringUDC20
72F31UI803Work File for Summarizing Journal Entries8SGUMUnit of MeasureStringUDC20
TOP32: Configuration Management
73F3283Rules Table Detail32RDUMUnit of MeasureStringUDC20
74F3293Assembly Inclusions Rules25KYUMUnit of MeasureStringUDC20
TOP33: Capacity Planning
75F3303Capacity Resource Profile9CTUMUnit of MeasureStringUDC20
76F3311Capacity Message File8CNUMUnit of MeasureStringUDC20
77F3312Capacity Pegging8CWUMUnit of MeasureStringUDC20
78F3313Capacity Load Table4CRUMUnit of MeasureStringUDC20
TOP40: Inventory/OP Base
79F3002Bill of Material Master File14IXUMUnit of MeasureStringUDC20
80F3011Bill of Materials Change File14IZUMUnit of MeasureStringUDC20
81F3013ECO Parts List Detail18CYUMUnit of MeasureStringUDC20
82F30UI004Bill of Material Update Work File25WFUMUnit of MeasureStringUDC20
83F41002Item Units of Measure Conversion Factors3UMUMUnit of MeasureStringUDC20
84F41003Unit of Measure standard conversion1UCUMUnit of MeasureStringUDC20
85F49211Sales Order Detail File - Tag File11UDUMUnit of MeasureStringUDC20
86F49211Z1Sales Order Detail Tag Unedited Transaction File24S1UMUnit of MeasureStringUDC20
87F49219Sales Order Detail - Tag History File11UDUMUnit of MeasureStringUDC20
TOP40G: Grower Management
88F40G031Harvest Estimate Freeze Hdr10FHUMUnit of MeasureStringUDC20
TOP41: Inventory Management
89F41013Unique Product Number5UNUMUnit of MeasureStringUDC20
90F4118Container Deposit File7CNUMUnit of MeasureStringUDC20
91F41181Container Transaction File6CMUMUnit of MeasureStringUDC20
TOP42: Sales Management
92F4020Freight/Additional Charges Rate Information27ARUMUnit of MeasureStringUDC20
93F42800G1Sales Update G Batch Detail Workfile23DGUMUnit of MeasureStringUDC20
TOP42B: Sales Order Entry
94F49299S.O. Detail Tag Ledger File11UDUMUnit of MeasureStringUDC20
TOP43: Procurement
95F4305Log Master27PLUMUnit of MeasureStringUDC20
TOP45: Advanced Pricing
96F4575Ship and Debit History51AHUMUnit of MeasureStringUDC20
97F4575TMPShip and Debit History - Temp Table51AHUMUnit of MeasureStringUDC20
98F4576Ship and Debit Claims79ACUMUnit of MeasureStringUDC20
99F4576TMPShip and Debit Claims- Temp Table79ACUMUnit of MeasureStringUDC20
100F4576Z1Ship and Debit Claims Unedited Transaction Table76Z1UMUnit of MeasureStringUDC20
TOP46: Warehouse Management
101F4142Warehouse Count Transactions40CTUMUnit of MeasureStringUDC20
TOP47: Electronic Commerce
102F47057EDI Payment Order Remittance Advice - Outbound88D3UMUnit of MeasureStringUDC20
103F47057WEDI Payment Order Remittance Advice - Work88D3UMUnit of MeasureStringUDC20
TOP48S: Service Billing
104F4812Billing Detail Workfile55WDUMUnit of MeasureStringUDC20
105F4812HBilling Workfile - History55WDUMUnit of MeasureStringUDC20
106F4812HSBilling Workfile History Purged Save55WDUMUnit of MeasureStringUDC20
107F4822Invoice Summary Work File38W4UMUnit of MeasureStringUDC20
108F4823Voucher Summary34W0UMUnit of MeasureStringUDC20
109F48S0618Payroll Reclassification Workfile27YTUMUnit of MeasureStringUDC20
110F48S910Billing Detail Journal File33W2UMUnit of MeasureStringUDC20
111F48S911Compressed Journal File30W3UMUnit of MeasureStringUDC20
112F48SUI01Billing Detail Print Workfile55WDUMUnit of MeasureStringUDC20
TOP49: Transportation Management
113F4941Shipment Routing Steps35RSUMUnit of MeasureStringUDC20
114F4960Load Header49TMUMUnit of MeasureStringUDC20
TOP51: Job Costing
115F5109Chart Type Master7GJUMUnit of MeasureStringUDC20
TOP52: Contract Billing
116F5202Contract Billing Line Detail29G6UMUnit of MeasureStringUDC20
TOP53: Change Management
117F5302F5302 World Specs16DKUMUnit of MeasureStringUDC20
TOP55: Reserved for Clients
118F55IFP01Kit Pricing File31KPUMUnit of MeasureStringUDC20
119F59H0220CRM Case Tag File - Proposals12CCUMUnit of MeasureStringUDC20
120F59I0011Purchase Receipt - Buffer11P1UMUnit of MeasureStringUDC20
121F59I0012Purchase Receipt - Template12P1UMUnit of MeasureStringUDC20
TOP74U: United Kingdom Localizations
122F74U03BTLease Master Alternative UOM Tag File - 156PFUMUnit of MeasureStringUDC20
TOP76A: Argentina
123F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A11DLUMUnit of MeasureStringUDC20
124F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A11DLUMUnit of MeasureStringUDC20
125F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0011DLUMUnit of MeasureStringUDC20
TOP76B: Brazil - Reporting System Only
126F76B3010Work Table for Item/Part List - 309IPUMUnit of MeasureStringUDC20
127F76B60Products Table - IN68 - 304PRUMUnit of MeasureStringUDC20
128F76B61Packing and Raw Material Table - IN68 - 306IEUMUnit of MeasureStringUDC20
TOP89: Conversion Programs
129F07352TPiece Rate Stub Detail Tag File12Y2UMUnit of MeasureStringUDC20
TOPD3N: dcLINK (data collection) - DSI
130FD3N1611Pallet Tracking Table 25PDUMUnit of MeasureStringUDC20
131FD3N4041Pallet Tracking Table 68CDUMUnit of MeasureStringUDC20
132FD3N421PPallet Tracking Table 38SHUMUnit of MeasureStringUDC20
TOPF30L: DFM Line Design
133FF30L002DFM Bill of Material Master10DHUMUnit of MeasureStringUDC20
134FF30L116Components Consumed10CCUMUnit of MeasureStringUDC20
135FF30L512DFM Item Units of Measure Conversion Factors4UMUMUnit of MeasureStringUDC20
136FF30L513DFM Units of Measure Standard Conversion1UCUMUnit of MeasureStringUDC20
137FF30L801Sales Order Master9SDUMUnit of MeasureStringUDC20
TOPF31: Lean Transactions
138FF31010Production Master File27EHUMUnit of MeasureStringUDC20
139FF31011TransactionID Master File10EHUMUnit of MeasureStringUDC20
140FF31011SPurge - TransactionID Master File10ERUMUnit of MeasureStringUDC20
141FF31111Lean Transaction Parts List15PLUMUnit of MeasureStringUDC20
142FF31111SPurge - Lean Transaction Parts List15PRUMUnit of MeasureStringUDC20
143FF31112Routing Transaction Table60EHUMUnit of MeasureStringUDC20
144FF31112SPurge - Routing Transaction Table60ETUMUnit of MeasureStringUDC20
TOPF34S: DFM Production Sequencing
145FF34S002Daily Plan20DPUMUnit of MeasureStringUDC20
146FF34S01WDFM 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