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

80 columns | Print definition?920 | UOM2 | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F1721Contract Detail115CDUOM2Unit of Measure - SecondaryStringUDC20
2F1725Service Contract Services8STUOM2Unit of Measure - SecondaryStringUDC20
3F3111Z2Warranty Claim/Supplier Recovery processing94WPUOM2Unit of Measure - SecondaryStringUDC20
4F4801TZ2Warranty Claim/Supplier Recovery processing49WQUOM2Unit of Measure - SecondaryStringUDC20
TOP31: Shop Floor Control
5F3111Work Order Parts List80WMUOM2Unit of Measure - SecondaryStringUDC20
6F3111SPurge - Shop Floor Parts List80WMUOM2Unit of Measure - SecondaryStringUDC20
7F3111Z1Outbound Work Order Parts List94SZUOM2Unit of Measure - SecondaryStringUDC20
TOP31B: Blend Management
8F31B85Weigh Tag Master50WTUOM2Unit of Measure - SecondaryStringUDC20
9F31B91Bill Of Lading Master65BLUOM2Unit of Measure - SecondaryStringUDC20
TOP34X: In-Memory Planning Advisor
10F34X110WItem List Work Table17ILUOM2Unit of Measure - SecondaryStringUDC20
TOP40: Inventory/OP Base
11F4011ZBatch Receiver File - Order Details156SZUOM2Unit of Measure - SecondaryStringUDC20
12F4211Z1Sales Order Detail Unedited Transaction File143SZUOM2Unit of Measure - SecondaryStringUDC20
TOP41: Inventory Management
13F4101Item Master44IMUOM2Unit of Measure - SecondaryStringUDC20
14F4101AItem File25IMUOM2Unit of Measure - SecondaryStringUDC20
15F4101Z1F4101 Item Master Unedited Transaction Table59SZUOM2Unit of Measure - SecondaryStringUDC20
16F4111Item Ledger File55ILUOM2Unit of Measure - SecondaryStringUDC20
17F4131Consignment Master Detail (FUTURE)11MDUOM2Unit of Measure - SecondaryStringUDC20
18F4133Usage Detail (FUTURE)13UDUOM2Unit of Measure - SecondaryStringUDC20
19F4160Tag Inventory File31ITUOM2Unit of Measure - SecondaryStringUDC20
20F41UI001Inventory Transactions Detail File223ITUOM2Unit of Measure - SecondaryStringUDC20
TOP41F: Apparel Management
21FCW09Item Revisions Work File36WRUOM2Unit of Measure - SecondaryStringUDC20
TOP42: Sales Management
22F420UI55Kit Balance Work File19UIUOM2Unit of Measure - SecondaryStringUDC20
23F4211Sales Order Detail File130SDUOM2Unit of Measure - SecondaryStringUDC20
24F42119Sales Order History File130SDUOM2Unit of Measure - SecondaryStringUDC20
25F42199S.O. Detail Ledger File130SLUOM2Unit of Measure - SecondaryStringUDC20
26F42565Invoice Print File174IWUOM2Unit of Measure - SecondaryStringUDC20
27F42UI11SO Detail Cache File (MBF)90ZDUOM2Unit of Measure - SecondaryStringUDC20
28F42UI521Pick Slips Detail File101S9UOM2Unit of Measure - SecondaryStringUDC20
29F42UI800Sales Detail Work File - Sales Update104SDUOM2Unit of Measure - SecondaryStringUDC20
TOP42B: Sales Order Entry
30F42420Audit Log Transaction86ALUOM2Unit of Measure - SecondaryStringUDC20
TOP42I: Outbound Inventory Management
31F42I015Outbound Inventory Agreement Transaction File21OIUOM2Unit of Measure - SecondaryStringUDC20
32F42I02Outbound Inventory Agreement Acknowledge20OIUOM2Unit of Measure - SecondaryStringUDC20
33F42I021Outbound Inventory Item Balance13OQUOM2Unit of Measure - SecondaryStringUDC20
34F42I03Outbound Order Consumption Report File19OIUOM2Unit of Measure - SecondaryStringUDC20
35F42I09Outbound Hold and Return Transactions22OIUOM2Unit of Measure - SecondaryStringUDC20
TOP42W: Fulfilment Management
36F4277703Unfulfilled Items Workfile10UIUOM2Unit of Measure - SecondaryStringUDC20
TOP42X: In-Memory Sales Advisor
37F42X040WOrder Upsell Item Group Totals Work File16GRUOM2Unit of Measure - SecondaryStringUDC20
38F42X050WOrder Level Upsell Candidate Items10CIUOM2Unit of Measure - SecondaryStringUDC20
TOP43: Procurement
39F43080Approvals Fields Constants112PDUOM2Unit of Measure - SecondaryStringUDC20
40F4311Purchase Order Detail File108PDUOM2Unit of Measure - SecondaryStringUDC20
41F4311ZPurchase Order Generator File112PWUOM2Unit of Measure - SecondaryStringUDC20
42F4311Z1Purchase Order Detail Unedited Transaction Table121SZUOM2Unit of Measure - SecondaryStringUDC20
43F43121Purchase Order Receiver File131PRUOM2Unit of Measure - SecondaryStringUDC20
44F43121ZReceiver workfile49PWUOM2Unit of Measure - SecondaryStringUDC20
45F43121Z1Receipts Unedited Transaction Table174SZUOM2Unit of Measure - SecondaryStringUDC20
46F43199P.O. Detail Ledger File - Flexible Version108OLUOM2Unit of Measure - SecondaryStringUDC20
TOP46: Warehouse Management
47F4142Warehouse Count Transactions15CTUOM2Unit of Measure - SecondaryStringUDC20
48F4602Location Detail Information89IFUOM2Unit of Measure - SecondaryStringUDC20
TOP46L: License Plating
49F46L11License Plate Item Detail9IDUOM2Unit of Measure - SecondaryStringUDC20
50F46L42License Plate Cycle and Tag Count13CCUOM2Unit of Measure - SecondaryStringUDC20
51F46L99License Plate History42LMUOM2Unit of Measure - SecondaryStringUDC20
52F46LUI01Assign/Remove Items To LP Work File16WFUOM2Unit of Measure - SecondaryStringUDC20
TOP47: Electronic Commerce
53F47012EDI Purchase Order Detail - Inbound157SZUOM2Unit of Measure - SecondaryStringUDC20
54F47017EDI Purchase Order Detail - Outbound122SZUOM2Unit of Measure - SecondaryStringUDC20
55F47022EDI P.O. Acknowledgment Detail - Inbound122SZUOM2Unit of Measure - SecondaryStringUDC20
56F47027EDI P.O. Acknowledgment Detail - Outbound157SZUOM2Unit of Measure - SecondaryStringUDC20
57F47037EDI Shipping Notice Detail - Outbound139SZUOM2Unit of Measure - SecondaryStringUDC20
58F470371EDI Shipping Notice Detail - Outbound160SZUOM2Unit of Measure - SecondaryStringUDC20
59F47047EDI Invoice Detail (Sales) - Outbound157SZUOM2Unit of Measure - SecondaryStringUDC20
60F47072EDI Receiving Advice Detail - Inbound123SZUOM2Unit of Measure - SecondaryStringUDC20
61F47077EDI Receiving Advice Detail - Outbound123SZUOM2Unit of Measure - SecondaryStringUDC20
62F47092EDI Request for Quote Detail - Inbound157SZUOM2Unit of Measure - SecondaryStringUDC20
63F47097EDI Request for Quote Detail - Outbound122SZUOM2Unit of Measure - SecondaryStringUDC20
64F47102EDI Response to RFQ Detail - Inbound122SZUOM2Unit of Measure - SecondaryStringUDC20
65F47107EDI Response to RFQ Detail - Outbound157SZUOM2Unit of Measure - SecondaryStringUDC20
66F47122EDI Product Activity Data Detail - Inbound85MJUOM2Unit of Measure - SecondaryStringUDC20
67F47127EDI Product Activity Data Detail - Outbound87MJUOM2Unit of Measure - SecondaryStringUDC20
68F47132EDI Purchase Order Change Detail - Inbound158SZUOM2Unit of Measure - SecondaryStringUDC20
69F47137EDI Purchase Order Change Detail - Outbound123SZUOM2Unit of Measure - SecondaryStringUDC20
70F47142EDI P.O. Change Acknowledgment Detail - Inbound124SZUOM2Unit of Measure - SecondaryStringUDC20
71F47147EDI P.O. Change Acknowledgment Detail - Outbound159SZUOM2Unit of Measure - SecondaryStringUDC20
72F47157EDI Shipping Schedule Detail - Outbound131SZUOM2Unit of Measure - SecondaryStringUDC20
73F47182EDI Consumption Detail (FUTURE)11EDUOM2Unit of Measure - SecondaryStringUDC20
TOP48: Work Order Processing
74F4801STPurge - Work Order Master Tag File36WAUOM2Unit of Measure - SecondaryStringUDC20
75F4801TWork Order Master Tag File36WAUOM2Unit of Measure - SecondaryStringUDC20
76F4801Z1Outbound Work Order Header183SYUOM2Unit of Measure - SecondaryStringUDC20
TOP49: Transportation Management
77F4971Freight Rate Definition16RDUOM2Unit of Measure - SecondaryStringUDC20
TOP75I: India
78F75I3901Work With Consignment - IND -4318COUOM2Unit of Measure - SecondaryStringUDC20
TOP89: Conversion Programs
79F43199ATemp F43199 for ERP 9.0 Upgrade108OLUOM2Unit of Measure - SecondaryStringUDC20
TOPF30L: DFM Line Design
80FF30L501DFM Item Definition Master94IBUOM2Unit of Measure - SecondaryStringUDC20

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