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

is JDE Date
Home | 920
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

4 columns | Print definition?920 | OMWFPS | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOPH92: Interactive Engine/OL
1F98210OMW Log Header6LHOMWFPSObject Management From Project StatusStringUDC50
2F98224OMW Status Activity Rules1SROMWFPSObject Management From Project StatusStringUDC50
3F98225OMW Transfer Activity Rules1TROMWFPSObject Management From Project StatusStringUDC50
4F98231DOMW Transfer Activity Rule Director - Detail4TDOMWFPSObject Management From Project StatusStringUDC50

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

TOPUDC H92 / PS (OMW Project Status) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1     *ALLAll N
2     01Complete Y
3     02Returned for Clarification N
4     04Return - Redesign not planned N
5     05Returned-Reconsider in Future N
6     06Returned -Already Reported N
7     08Returned -Could not Duplicate N
8     09Closed-No Further Action N
9     10Refer to Parent SAR N
10     11New Project Pending Review N
11     17Plan or Research N
12     18Design N
13     19Design Review N
14     20Awaiting Staff N
15     21Programming N
16     21MProgramming - Dual Maint N
17     21PLIDP - Performance Lab N
18     21REGProgramming - Regression N
19     21TProgramming-Special Project N
20     21TDProgramming - Tools Dev N
21     21VIDP Programming/Prgm Test N
22     21VAIDP - View to View Transfer N
23     21VPIDP Parent Project N
24     21VQIDP QA Functional Test N
25     22Programmer Test N
26     22MProgram Test - Dual Maint N
27     22OBeta Obsoletion - INDEV N
28     22VIDP Test N
29     22VQIDP QA Merge Test N
30     23Manager Review N
31     23MManager Review - Dual Maint N
32     23OBeta Obsoletion - PROD N
33     23QQE Test/Review N
34     23REGQE Test/Review - Regression N
35     23TManager Review-Post QE Test N
36     23VIDP Manager Review N
37     24Transfer to Production N
38     24MReady to Transfer - Dual Maint N
39     24OBeta Obsoletion - APPL, AUTO N
40     24REGTransfer to Regression N
41     24TTransfer- Special Project N
42     25Rework-Same Issue N
43     25VIDP Rework N
44     26QA Test/Review N
45     26ESUTransfer - View ESU N
46     26MQA Test/Rvw - Dual Maint N
47     26TTransferred-Special Project N
48     27Rework-New Issue N
49     28QA Test/Review Complete N
50     28MQA Complete- Dual Maint N
51     2AApproved by CRB N
52     2CWaiting Programmer Check In N
53     2MWaiting Manager Approval N
54     2QWaiting QA Manager Approval N
55     2WWaiting CRB Approval N
56     2XESU Exception Exists N
57     35Manager Review ESU N
58     35MManager Review ESU-Dual Maint N
59     36ESU transfer to PD N
60     36MESU transfer to PD-Dual Maint N
61     36YEYear End Transfer to PD N
62     37ESU Ready for Build N
63     37AAPXe Offline Fix N
64     37IFESU - Individual Fix N
65     37MESU Build-Dual Maint N
66     37REGESU - Regression N
67     3PPristine Update - OMW N
68     3PDPrebuild Error-PD fix N
69     3PMPristine Updates - Dual Maint N
70     3PTBuild Error - PD fix N
71     40Production Development N
72     41Xfer Production to Prototype N
73     42Xfer Prototype to Development N
74     45Pristine Get N
75     90Completed -Not Tested N
76     91Cancelled Entered in Error N
77     99Completed N
78     MMBeta Testing-MASTERS N
79     MPAlpha Testing-MASTERS N

All references to JDE, JD Edwards and Oracle logos are trademarks of Oracle Corporation USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the Oracle Corporation or any of its affiliates.
About :: Terms :: Privacy