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

4 columns | Print definition?910 | 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     *ALL AllN
2     01   CompleteY
3     02   Returned for ClarificationN
4     06   Returned -Already ReportedN
5     08   Returned -Could not DuplicateN
6     09   Closed-No Further ActionN
7     10   Refer to Parent SARN
8     11   New Project Pending ReviewN
9     12   Reviewed by Customer SupportN
10     13   Reserved by Software Devel.N
11     14   Reserved by Software Devel.N
12     15   Reserved by Software Devel.N
13     16   Reserved by Software Devel.N
14     17   Plan or ResearchN
15     18   DesignN
16     19   Design ReviewN
17     20   Awaiting StaffN
18     20AUTAwaiting Staff - AutomotiveN
19     20RF Refactoring TransferN
20     21   ProgrammingN
21     21AUTProgramming - AutomotiveN
22     21PL IDP - Performance LabN
23     21REGProgramming - RegressionN
24     21RF Programming -RefactoringN
25     21T  Programming-Special ProjectN
26     21TD Programming - Tools DevN
27     21V  IDP Programming/Prgm TestN
28     21VA IDP - View to View TransferN
29     21VP IDP Parent ProjectN
30     21VQ IDP QA Functional TestN
31     22   Programmer TestN
32     22AUTProgrammer Test - AutomotiveN
33     22O  Beta Obsoletion - INDEVN
34     22RF Refactoring XferN
35     22V  IDP TestN
36     22VQ IDP QA Merge TestN
37     23   Manager ReviewN
38     23O  Beta Obsoletion - PRODN
39     23Q  QE Test/ReviewN
40     23REGQE Test/Review - RegressionN
41     23T  Manager Review-Post QE TestN
42     23V  IDP Manager ReviewN
43     24   Transfer to ProductionN
44     24O  Beta Obsoletion - APPL, AUTON
45     24REGTransfer to RegressionN
46     24T  Transfer- Special ProjectN
47     25   Rework-Same IssueN
48     25V  IDP ReworkN
49     26   QA Test/ReviewN
50     26ESUTransfer - View ESUN
51     26T  Transferred-Special ProjectN
52     26UK Transfer to UK TestN
53     27   Rework-New IssueN
54     28   QA Test/Review CompleteN
55     29   Demo DataN
56     2A   Approved by CRBN
57     2C   Waiting Programmer Check InN
58     2M   Waiting Manager ApprovalN
59     2Q   Waiting QA Manager ApprovalN
60     2W   Waiting CRB ApprovalN
61     2X   ESU Exception ExistsN
62     30   Ready for Transfer to CumN
63     31   Returned -Not PlannedN
64     35   Manager Review ESUN
65     36   ESU transfer to PRDN
66     36YE Year End Transfer to PDN
67     37   Ready for ESU BuildN
68     37IF ESU - Individual FixN
69     37REGESU - RegressionN
70     38   In ProductionN
71     38UK Transfer to UK ProdN
72     39   To be reviewed with Users grouN
73     3P   Pristine Updates-OMWN
74     3PT  Build Error - PD fixN
75     40   Production DevelopmentN
76     41   Xfer Production to PrototypeN
77     42   Xfer Prototype to DevelopmentN
78     45   Pristine GetN
79     55   XFER CheckoutN
80     90   Completed -Not TestedN
81     91   Cancelled Entered in ErrorN
82     99   CompletedN
83     MM   Beta Testing-MASTERSN
84     MP   Alpha Testing-MASTERSN