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

157 columns | Print definition?920 | 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
5F03B117Revenue Recognition GL Info25RLUMUnit of MeasureStringUDC20
6F03B119Revenue Recognition GL Info Audit13RNUMUnit of MeasureStringUDC20
7F03B11PCustomer Ledger Purge File97RPUMUnit of MeasureStringUDC20
8F03B11Z1Batch Invoices113VJUMUnit of MeasureStringUDC20
9F03B11Z2F03B11 Interoperability Table110SYUMUnit of MeasureStringUDC20
10F03B575Auto Debit Invoice Select and Build106RDUMUnit of MeasureStringUDC20
TOP04: Accounts Payable
11F0411Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
12F0411AWF - 'As Of' Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
13F0411PPurge - Accounts Payable Ledger77RPUMUnit of MeasureStringUDC20
14F0411Z1Voucher Transactions - Batch Upload95VLUMUnit of MeasureStringUDC20
15F0411Z3F0411 Interoperability Table100SZUMUnit of MeasureStringUDC20
TOP05: Time Accounting and HRM Base
16F06106Employee Pay Instructions24YMUMUnit of MeasureStringUDC20
17F0618Employee Transaction History27YTUMUnit of MeasureStringUDC20
18F069116Payroll Transaction Constants16YCUMUnit of MeasureStringUDC20
19F069162Job Type/ Item Cross Reference File5JHUMUnit of MeasureStringUDC20
TOP05T: Time Entry
20F06116Employee Transaction Detail File27YTUMUnit of MeasureStringUDC20
21F06116Z1Employee Transactions - Batch File44VLUMUnit of MeasureStringUDC20
22F06116Z2ESS Timecard History44VMUMUnit of MeasureStringUDC20
23F0623Piecework History File7JLUMUnit of MeasureStringUDC20
24F06278Retro Timecard Detail File30YTUMUnit of MeasureStringUDC20
25F06916Piecework Item Master3JJUMUnit of MeasureStringUDC20
26F069161Item Master Cross Reference File5JEUMUnit of MeasureStringUDC20
27F06918PF - Piece Rate File9JNUMUnit of MeasureStringUDC20
TOP07: Payroll
28F06156Pay Check History Summary12YUUMUnit of MeasureStringUDC20
29F06350IWF - Paycheck (Interims)24Y4UMUnit of MeasureStringUDC20
30F0716702Employee Assignment Rates9EAUMUnit of MeasureStringUDC20
31F071861Stub Detail Piece Rate History File12Y8UMUnit of MeasureStringUDC20
32F073521Stub Detail Piece Rate File12Y2UMUnit of MeasureStringUDC20
33F07UI200Timecard History Work File30THUMUnit of MeasureStringUDC20
TOP08: Human Resources
34F08711Employee Setup Tasks8ETUMUnit of MeasureStringUDC20
TOP08AD: ADP Integration
35F051371ADP Employee DBA Instructions29ADUMUnit of MeasureStringUDC20
36F051375ADP Payroll DBA Transaction Constants18ADUMUnit of MeasureStringUDC20
TOP09: General Accounting
37F0901Account Master13GMUMUnit of MeasureStringUDC20
38F0909Chart of Accounts - Reference File6ACUMUnit of MeasureStringUDC20
39F0911PPurge - Account Ledger33GLUMUnit of MeasureStringUDC20
40F0911RWF - Account Ledger Reconciliation30GLUMUnit of MeasureStringUDC20
41F0911SWAccount Ledger Summary Work Table6GSUMUnit of MeasureStringUDC20
42F0911Z1Journal Entry Transactions - Batch File50VNUMUnit of MeasureStringUDC20
43F0911Z4F0911 Interoperability Table55SZUMUnit of MeasureStringUDC20
44F0912Cost Allocations/Flex Budgeting34RJUMUnit of MeasureStringUDC20
45F09123Advanced Variable Numerator18VNUMUnit of MeasureStringUDC20
46F09UI015Indexed Computations Multi-Tiered Entries33GLUMUnit of MeasureStringUDC20
47F52G11Burdening Detail Ledger55BDUMUnit of MeasureStringUDC20
TOP09E: Expense Reimbursment
48F09E108Policy Edit Rules20PRUMUnit of MeasureStringUDC20
TOP12: Fixed Assets
49F1208Units of Production Schedule Master File4FPUMUnit of MeasureStringUDC20
50F1215Specification Cross Reference15GVUMUnit of MeasureStringUDC20
TOP13: Plant/Equipment Management
51F13017Equipment Parts List16PLUMUnit of MeasureStringUDC20
52F3111IGSWO Parts for IGS Integration8IGUMUnit of MeasureStringUDC20
TOP15: Real Estate Management
53F1503Log Standards Master18NBUMUnit of MeasureStringUDC20
54F1514Area Master11NWUMUnit of MeasureStringUDC20
55F15141Gross Lease Occupied Areas12NCUMUnit of MeasureStringUDC20
56F1521Log Detail Master17NBUMUnit of MeasureStringUDC20
57F1523Log Standard Master10OGUMUnit of MeasureStringUDC20
58F15703Legal Clause Amounts7NIUMUnit of MeasureStringUDC20
TOP15L: Adv Real Estate Forecasting
59F15L101AREF Unit Master24UMUMUnit of MeasureStringUDC20
60F15L141AREF Gross Lease Occupied Area13GLUMUnit of MeasureStringUDC20
TOP17: Customer Service Management
61F1721Contract Detail64CDUMUnit of MeasureStringUDC20
62F3111Z2Warranty Claim/Supplier Recovery processing59WPUMUnit of MeasureStringUDC20
TOP17C: Call Management
63F1755Case Master178ZAUMUnit of MeasureStringUDC20
64F1760Time Entry55ZBUMUnit of MeasureStringUDC20
TOP18: Timecard Automation
65F186602Labor Rules Tag File40TFUMUnit of MeasureStringUDC20
TOP30: Product Data Management
66F300210Lean Multi Level Bill of Material Header15EHUMUnit of MeasureStringUDC20
67F300211Lean Multi Level Bill of Material Detail23EDUMUnit of MeasureStringUDC20
68F3002Z1Bill of Material Transaction File27SZUMUnit of MeasureStringUDC20
69F3007Work Center Resource Units5WUUMUnit of MeasureStringUDC20
70F3016Kanban Master18KMUMUnit of MeasureStringUDC20
71F30UI008Bill of Material Comparison Work File5IJUMUnit of MeasureStringUDC20
72F30UI015BOM Item Fact Work File for BI11BDUMUnit of MeasureStringUDC20
73F30UI016BOM Explosion Work File for BI15BEUMUnit of MeasureStringUDC20
TOP31: Shop Floor Control
74F3111Work Order Parts List46WMUMUnit of MeasureStringUDC20
75F3111SPurge - Shop Floor Parts List46WMUMUnit of MeasureStringUDC20
76F3111Z1Outbound Work Order Parts List59SZUMUnit of MeasureStringUDC20
77F3118Shortage Maintenance Master File7WNUMUnit of MeasureStringUDC20
78F31UI802Accumulate Amounts by Account8WGUMUnit of MeasureStringUDC20
79F31UI803Work File for Summarizing Journal Entries8SGUMUnit of MeasureStringUDC20
TOP32: Configuration Management
80F3283Rules Table Detail32RDUMUnit of MeasureStringUDC20
81F3293Assembly Inclusions Rules25KYUMUnit of MeasureStringUDC20
TOP33: Capacity Planning
82F3303Capacity Resource Profile9CTUMUnit of MeasureStringUDC20
83F3311Capacity Message File8CNUMUnit of MeasureStringUDC20
84F3312Capacity Pegging8CWUMUnit of MeasureStringUDC20
85F3313Capacity Load Table4CRUMUnit of MeasureStringUDC20
TOP34X: In-Memory Planning Advisor
86F34X310WPlanning Advisor BOM Component Detail Table20PDUMUnit of MeasureStringUDC20
TOP40: Inventory/OP Base
87F3002Bill of Material Master File14IXUMUnit of MeasureStringUDC20
88F3011Bill of Materials Change File14IZUMUnit of MeasureStringUDC20
89F3013ECO Parts List Detail18CYUMUnit of MeasureStringUDC20
90F30UI004Bill of Material Update Work File25WFUMUnit of MeasureStringUDC20
91F41002Item Units of Measure Conversion Factors3UMUMUnit of MeasureStringUDC20
92F41003Unit of Measure standard conversion1UCUMUnit of MeasureStringUDC20
93F49211Sales Order Detail File - Tag File11UDUMUnit of MeasureStringUDC20
94F49211Z1Sales Order Detail Tag Unedited Transaction File24S1UMUnit of MeasureStringUDC20
95F49219Sales Order Detail - Tag History File11UDUMUnit of MeasureStringUDC20
TOP40G: Grower Management
96F40G031Harvest Estimate Freeze Hdr10FHUMUnit of MeasureStringUDC20
TOP41: Inventory Management
97F41013Unique Product Number5UNUMUnit of MeasureStringUDC20
98F4118Container Deposit File7CNUMUnit of MeasureStringUDC20
99F41181Container Transaction File6CMUMUnit of MeasureStringUDC20
TOP41F: Apparel Management
100FCW17Work File F410024WFUMUnit of MeasureStringUDC20
101FCW67Style Work Order Parts List53WMUMUnit of MeasureStringUDC20
102FCW961Simulation Detailed Parts List15DLUMUnit of MeasureStringUDC20
TOP42: Sales Management
103F4020Freight/Additional Charges Rate Information27ARUMUnit of MeasureStringUDC20
104F42800G1Sales Update G Batch Detail Workfile23DGUMUnit of MeasureStringUDC20
TOP42B: Sales Order Entry
105F49299S.O. Detail Tag Ledger File11UDUMUnit of MeasureStringUDC20
TOP43: Procurement
106F4303Log Master19PKUMUnit of MeasureStringUDC20
107F4305Log Master27PLUMUnit of MeasureStringUDC20
TOP45: Advanced Pricing
108F4575Ship and Debit History51AHUMUnit of MeasureStringUDC20
109F4575TMPShip and Debit History - Temp Table51AHUMUnit of MeasureStringUDC20
110F4576Ship and Debit Claims79ACUMUnit of MeasureStringUDC20
111F4576TMPShip and Debit Claims- Temp Table79ACUMUnit of MeasureStringUDC20
112F4576Z1Ship and Debit Claims Unedited Transaction Table76Z1UMUnit of MeasureStringUDC20
TOP46: Warehouse Management
113F4142Warehouse Count Transactions40CTUMUnit of MeasureStringUDC20
TOP47: Electronic Commerce
114F47057EDI Payment Order Remittance Advice - Outbound88D3UMUnit of MeasureStringUDC20
115F47057WEDI Payment Order Remittance Advice - Work88D3UMUnit of MeasureStringUDC20
TOP48S: Service Billing
116F4812Billing Detail Workfile55WDUMUnit of MeasureStringUDC20
117F4812HBilling Workfile History55WDUMUnit of MeasureStringUDC20
118F4812HSBilling Workfile History Purged Save55WDUMUnit of MeasureStringUDC20
119F4822Invoice Summary Work File38W4UMUnit of MeasureStringUDC20
120F4823Voucher Summary34W0UMUnit of MeasureStringUDC20
121F48S0618Payroll Reclassification Workfile27YTUMUnit of MeasureStringUDC20
122F48S910Billing Detail Journal Workfile33W2UMUnit of MeasureStringUDC20
123F48S911Summarized Journal Workfile30W3UMUnit of MeasureStringUDC20
124F48SUI01Billing Detail Print Workfile55WDUMUnit of MeasureStringUDC20
TOP49: Transportation Management
125F4941Shipment Routing Steps35RSUMUnit of MeasureStringUDC20
126F4960Load Header49TMUMUnit of MeasureStringUDC20
TOP51: Job Costing
127F5109Chart Type Master7GJUMUnit of MeasureStringUDC20
TOP51F: Advanced Job Forecasting
128F51F115Remaining Work Detail8QJUMUnit of MeasureStringUDC20
TOP51X: In-Memory Project Management
129F51X10Project Advisor Console Worktable131EXUMUnit of MeasureStringUDC20
TOP52: Contract Billing
130F5202Contract Billing Line Detail29G6UMUnit of MeasureStringUDC20
TOP52G: Proj & Gov Contract Accounting
131F4822HInvoice Summary History38IHUMUnit of MeasureStringUDC20
TOP53: Change Management
132F5302F5302 World Specs16DKUMUnit of MeasureStringUDC20
TOP74U: United Kingdom Localizations
133F74U03BTLease Master Alternative UOM Tag File - 156PFUMUnit of MeasureStringUDC20
TOP75I: India
134F75I395BER - 5 (2)13ERUMUnit of MeasureStringUDC20
135F75I395TER - 5 (temp)13ERUMUnit of MeasureStringUDC20
TOP76A: Argentina
136F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A11DLUMUnit of MeasureStringUDC20
137F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A11DLUMUnit of MeasureStringUDC20
138F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A11DLUMUnit of MeasureStringUDC20
TOP76B: Brazil
139F76B3010Work Table for Item/Part List - 309IPUMUnit of MeasureStringUDC20
140F76B60Products Table - IN68 - 304PRUMUnit of MeasureStringUDC20
141F76B61Packing and Raw Material Table - IN68 - 306IEUMUnit of MeasureStringUDC20
TOP79A: Greenhouse Gas Accounting
142F79A39GHG Source UM Conversion2UMUMUnit of MeasureStringUDC20
TOP89: Conversion Programs
143F07352TPiece Rate Stub Detail Tag File12Y2UMUnit of MeasureStringUDC20
TOPF30L: DFM Line Design
144FF30L002DFM Bill of Material Master10DHUMUnit of MeasureStringUDC20
145FF30L116Components Consumed10CCUMUnit of MeasureStringUDC20
146FF30L512DFM Item Units of Measure Conversion Factors4UMUMUnit of MeasureStringUDC20
147FF30L513DFM Units of Measure Standard Conversion1UCUMUnit of MeasureStringUDC20
148FF30L801Sales Order Master9SDUMUnit of MeasureStringUDC20
TOPF31: Lean Transactions
149FF31010Production Master File27EHUMUnit of MeasureStringUDC20
150FF31011TransactionID Master File10EHUMUnit of MeasureStringUDC20
151FF31011SPurge - TransactionID Master File10ERUMUnit of MeasureStringUDC20
152FF31111Lean Transaction Parts List15PLUMUnit of MeasureStringUDC20
153FF31111SPurge - Lean Transaction Parts List15PRUMUnit of MeasureStringUDC20
154FF31112Routing Transaction Table60EHUMUnit of MeasureStringUDC20
155FF31112SPurge - Routing Transaction Table60ETUMUnit of MeasureStringUDC20
TOPF34S: DFM Production Sequencing
156FF34S002Daily Plan20DPUMUnit of MeasureStringUDC20
157FF34S01WDFM 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 . Y
2        %Percent N
3        12Twelve Pack N
4        ACAcre N
5        ASAnnual Salary(rounded)xmult. N
6        ATAnnual Salary(truncated)xmult. N
7        BABar Absolute (Pressure) N
8        BCBag N
9        BGBar Gauge (Pressure) N
10        BKBucket N
11        BLBarrels N
12        BTBottles N
13        BUBushel N
14        BXBox N
15        CACase N
16        CCCubic CentimeterVN
17        CFHundred Feet N
18        CICubic InchesVN
19        CLCentilitersVN
20        CMCentimeters N
21        CNCan N
22        COContainer N
23        CRCarton N
24        CSHundred Square Feet N
25        CTCarat Y
26        CUCubic Meter Y
27        CWHundredweightWN
28        CYCubic YardVN
29        DCDecimeters N
30        DLDeciliter N
31        DRdrums N
32        DWPenny Weight
33        DYDays N
34        DZDozen N
35        EAEach N
36        FCCubic FeetVN
37        FFFeet/Inches/16th N
38        FOFluid Ounce Y
39        FTFeet N
40        G1100 Gallons N
41        GAGallonsVN
42        GJGiga Joule Y
43        GMGramsWN
44        GPPotent GallonsVPN
45        GRGross N
46        H1Half Hour Calculations N
47        HAAverage Hourly Rate N
48        HEHead Count N
49        HHHours X Hours Worked N
50        HLHectoliterVN
51        HQHours per period (zero $) N
52        HRHour N
53        HTHectare N
54        HZHours x Hrs worked (zero $) N
55        ICCubic InchesVN
56        IGImperial GallonsVN
57        INInches N
58        JTJoints N
59        KGKilogramsWN
60        KLKiloliter . N
61        KMKilometers N
62        KTKarat N
63        KWKilowatt Hour Y
64        L3Pounds per square inch N
65        LBPoundsWN
66        LCCubic LitersVN
67        LFLinear Feet N
68        LGLog N
69        LPPotent LitersVPN
70        LSLump Sum N
71        LTLitersVN
72        M3Cubic MetersVN
73        MFThousand Feet N
74        MGMilligramsWN
75        MHMan Hour N
76        MIMiles N
77        MKMicrogramsWN
78        MLMilliliterVN
79        MMMillimeters . N
80        MNMinutes Y
81        MOMonths N
82        MPThousand Pieces N
83        MSThousand Square Feet N
84        MTMeters N
85        MWThousand PoundsWN
86        OPPotent Ounces PN
87        OTTroy Ounces N
88        OZOuncesWN
89        PCPieces N
90        PDPad N
91        PKPackage N
92        PLPallet N
93        PRPair N
94        PTPintVN
95        QTQuartVN
96        RDRental Deposit N
97        RLRoll N
98        RMReam N
99        RT$1000s of Salary N
100        SCSquare Centimeters N
101        SESeconds Y
102        SFSquare Feet N
103        SISquare Inches N
104        SKSkein N
105        SLSleeve N
106        SMSquare Meters N
107        SPSpaces
108        STEaches N
109        SXSix Pack N
110        SYSquare Yard N
111        TKTank N
112        TLLong Ton (English)WN
113        TMMetric TonWN
114        TNTon (U.S.)WN
115        TSShort Ton (U.S.)WN
116        UNUnits N
117        WKWeeks N
118        WUWeld Units N
119        XLExcess Life N
120        YDYards N
121        YRYear N
122        ZSet (3-PW) N