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

1 column | Print definition?920 | 54RWOS3 | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP54R: Rental Management
1F54R01Rental Constants43RC54RWOS3Service Order Status 3StringUDC20

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

TOPUDC 00 / SS (Work Order Status) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1  . Y
2        00PRP Order, Pre-Quote Accept N
3        05Order Created Y
4        10Order Reviewed Y
5        15Sales Order WO Not Processed N
6        20Parts List Attached Y
7        25PL and Rtg Reviewed Y
8        30Paperwork Printed Y
9        40Started Labor or Material N
10        41Firm Planned Order (FPO) N
11        44Check Outside ProcessNN
12        45Material Issued Y
13        80Completion Reported Y
14        81CRP Display Orders N
15        825 Days from Final Accting Y
16        83Mfg. Acctg Example N
17        844 Days from Final Accting Y
18        863 Days from Final Accting Y
19        882 Days from Final Accting Y
20        901 Days from Final Accting Y
21        91Complete - Cancelled N
22        92Complete - Partial Split N
23        95Ready for Final Acctg Y
24        96WIP Transactions Complete Y
25        97Variance Report Printed Y
26        98J.E.'s Variances - Proofed N
27        99Order Closed Y
28        AApproved ECO N
29        AIAdditional data required (ECO) N
30        DDisapproved ECO N
31        E1ECO Entered N
32        E2Preliminary Workup N
33        E3Approval Pending N
34        E4ECO Approved N
35        E5ECO Implemented N
36        EMEmergency Order N
37        IAInactive Work Order N
38        MMaintenance Work Request N
39        M*MWO Waiting Manager Approval N
40        MAMWO Approved N
41        MBMWO Material Issued N
42        MCW/O In Planning N
43        MDW/O Plant Shutdown N
44        MEW/O Waiting for Parts N
45        MFW/O Parts Staged and Ready N
46        MGW/O Ready to Schedule N
47        MHW/O Issued & Released N
48        MIW/O Outside Services N
49        MJW/O Completed N
50        MKW/O Closed N
51        MLStanding W/O`s N
52        MMW/O Cancelled N
53        MPMWO Planning Only N
54        MRMWO Requested/Not Approved N
55        NBNon-Billable Work Order N
56        NEECO Entered N
57        PPlanned (MRP) Order N
58        S1Supplier Recovery entered N
59        S2Supplier Recovery approved N
60        S3Supplier Recovery Parts Added N
61        S4Supplier Recovery process N
62        S5Supplier Recovery completed N
63        V0No Description N
64        V5No Description N
65        V7No Description N
66        V9No Description N
67        VAService Order Entered N
68        VDService Order Planned N
69        VGService Order Printed N
70        VJService Order Started N
71        VLService Order on Quote N
72        VMService Order Material Issued N
73        VTService Order Time Entered N
74        VXService Order Canceled N
75        VZService Order Completed N
76        W1Warranty Claim entered N
77        W2Warranty Claim approved N
78        W3Warranty Claim Parts added N
79        W4Warranty Claim process N
80        W5Warranty Claim completed N
81        YYOP Configured Work OrderNY
82        ZZNew Rate For Processing Y