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
3F9671SDSoftware Update Detail Table
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F41021LIItem Location File
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
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
9F4111ILItem Ledger File
10F0411RPAccounts Payable Ledger

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

21 columns | Print definition?920 | SRST | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP13: Plant/Equipment Management
1F13411PM Projections16RXSRSTStatus Code W.O.StringUDC20
2F13907Associated Service Types7FCSRSTStatus Code W.O.StringUDC20
3F13907PAssociated Service Types Purge Table7FCSRSTStatus Code W.O.StringUDC20
4F1393Maintenance Rules7GOSRSTStatus Code W.O.StringUDC20
TOP17: Customer Service Management
5F4801Z2Warranty Claim/Supplier Recovery processing38WSSRSTStatus Code W.O.StringUDC20
TOP31: Shop Floor Control
6F3115Net Change Transaction table5NCSRSTStatus Code W.O.StringUDC20
7F31UI006Line Scheduling Workbench - Work File33LSSRSTStatus Code W.O.StringUDC20
TOP31A: Manufacturing Accounting
8F30UI003WIP Revaluation Work File17WRSRSTStatus Code W.O.StringUDC20
TOP34A: Advanced Planning & Scheduling
9F34A10APS Integration Constants34N0SRSTStatus Code W.O.StringUDC20
TOP34X: In-Memory Planning Advisor
10F34X200WPlanning Details Supply/Demand Work Table43SDSRSTStatus Code W.O.StringUDC20
TOP41F: Apparel Management
11FCW65Work Order Header for Style Items20OFSRSTStatus Code W.O.StringUDC20
TOP48: Work Order Processing
12F4801Work Order Master File19WASRSTStatus Code W.O.StringUDC20
13F4801SPurge - Work Order Master file19WASRSTStatus Code W.O.StringUDC20
14F4801Z1Outbound Work Order Header38SYSRSTStatus Code W.O.StringUDC20
15F4826W.O. Status Action Table3GESRSTStatus Code W.O.StringUDC20
16F4827Work Order Approval Routing4W5SRSTStatus Code W.O.StringUDC20
17F48710Work Order Mass Update Template Table9WTSRSTStatus Code W.O.StringUDC20
18F48UI001X4801 Master Business Function Workfile22WASRSTStatus Code W.O.StringUDC20
TOP76H: Chile
19F76H6001Actual Cost Process Header - CHI - 41 - 76H15PHSRSTStatus Code W.O.StringUDC20
TOPH96: Deployment
20F96400Sar grouping file for ESUs3SGSRSTStatus Code W.O.StringUDC20
TOPH99: Product Version Control
21F9900003Software Update Object Verification Work Table10SUSRSTStatus Code W.O.StringUDC20

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