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

6 columns | Print definition?910 | OMWAC | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOPH92: Interactive Engine/OL
1F98210OMW Log Header5LHOMWACObject Management Action CodeStringUDC50
2F98222OMW Project Objects15POOMWACObject Management Action CodeStringUDC50
3F98223OMW Allowed Actions4AAOMWACObject Management Action CodeStringUDC50
4F98225OMW Transfer Activity Rules9TROMWACObject Management Action CodeStringUDC50
5F98231DOMW Transfer Activity Rule Director - Detail2TDOMWACObject Management Action CodeStringUDC50
6F9829OMW Notification Subscriptions7OSOMWACObject Management Action CodeStringUDC50

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

TOPUDC H92 / AC (OMW Actions) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1     01   TransferY
2     02   Check-InY
3     03   Check-OutY
4     04   DeleteY
5     05   AddY
6     06   CopyY
7     07   InstallY
8     08   SaveY
9     09   RestoreY
10     10   DesignY
11     106  Get ObjectIDY
12     109  Generate Web SpecsY
13     11   GetY
14     12   Remove Object From ProjectN
15     13   Update ProjectY
16     14   Update Project UserY
17     15   Remove User From ProjectY
18     16   Add Object to ProjectY
19     20   Request TokenY
20     21   Switch TokenY
21     22   Add to Token QueueY
22     23   Force Release From Token QueueY
23     30   Erase Check-OutY
24     31   RollbackY
25     32   BackupY
26     35   Validate Check-Out DateY
27     36   Is LocalY
28     37   Is DifferentY
29     38   Status ChangeY
30     Z100 Get Object From ProjectY
31     Z101 Get User From ProjectY
32     Z102 Update Project ObjectY
33     Z103 Copy Object from ProjectY
34     Z104 Move Object to ProjectY
35     Z105 Assign TokenY
36     Z108 Get OMW FeatureY
37     Z700 PARAMETER_OBJECTTYPEY
38     Z7000eP_PARAMETER_PO_PROMPT_FLAGY
39     Z7001eP_PARAMETER_VER_SECURITYY
40     Z7002eP_PARAMETER_PO_DATAY
41     Z7003eP_PARAMETER_BHVRCOMY
42     Z7004eP_PARAMETER_VOIDY
43     Z7005eP_PARAMETER_SETSEL_FLAGY
44     Z7006eP_PARAMETER_FORM_TO_CALLY
45     Z7007eP_PARAMETER_REPLACE_SAVELOCY
46     Z7008eP_PARAMETER_DEL_FROMSRVRY
47     Z7009eP_PARAMETER_DEL_COMPLETELYY
48     Z701 PARAMETER_OBJECTIDY
49     Z7010eP_PARAMETER_GLOSSARY_ITEMY
50     Z7011eP_PARAMETER_INHERIT_TOKENY
51     Z7012eP_PARAMETER_UPDATEDPROJECTSLIY
52     Z7013eP_PARAMETER_NEWPROJECTIDY
53     Z7014eP_PARAMETER_NOSTATUSUPDATEY
54     Z7015eP_PARAMETER_FROMSARSTATUSY
55     Z7016eP_PARAMETER_TOSARSTATUSY
56     Z7017eP_PARAMETER_XFERREDINHERITOBJY
57     Z7018eP_PARAMETER_OL_PACKAGECOLY
58     Z7019eP_PARAMETER_OL_BASEMEMBERY
59     Z702 PARAMETER_PROJECTIDY
60     Z7020eP_PARAMETER_OL_PROCESSOPY
61     Z7021eP_PARAMETER_OL_GTFUTUREY
62     Z7022eP_PARAMETER_OL_TYPETEXTY
63     Z7023eP_PARAMETER_OL_TEXTFILEY
64     Z7024eP_PARAMETER_OL_CURRENCYY
65     Z7025eP_PARAMETER_OL_APPLIDY
66     Z7026eP_PARAMETER_OL_ANSIY
67     Z7027eP_PARAMETER_DEL_SAVEY
68     Z7028eP_PARAMETER_OBJSNOTMODIFIEDOBY
69     Z7029eP_PARAMETER_PROJECTPOINTERLISY
70     Z703 PARAMETER_OBJECTDESCRIPTIONY
71     Z7030ePARAMETER_FROMPATHY
72     Z7031ePARAMETER_TOPATHY
73     Z7032ePARAMETER_PACKAGE_NAMEY
74     Z7039eP_PARAMETER_OMWFEATURETYPEY
75     Z704 PARAMETER_RELEASEY
76     Z7043eP_PARAMETER_TEXT_SEARCH_BSVWY
77     Z7044eP_PARAMETER_NO_PROGRESS_DLGY
78     Z7045eP_PARAMETER_PRINT_IMMEDIATEY
79     Z705 PARAMETER_PROGRAMIDY
80     Z7050eP_PARAMETER_NONOL_WF_PROCESSY
81     Z7051eP_PARAMETER_NONOL_WF_VERSIONY
82     Z7052eP_PARAMETER_NONOL_WF_DESCY
83     Z7053eP_PARAMETER_NONOL_WF_PROD_CDY
84     Z7054eP_PARAMETER_NONOL_WF_KEY_DSY
85     Z7055eP_PARAMETER_NONOL_WF_ADD_DSY
86     Z7056eP_PARAMETER_NONOL_WF_HISTORYY
87     Z7057eP_PARAMETER_NONOL_WF_CPY_PROCY
88     Z7058eP_PARAMETER_NONOL_WF_CPY_VERY
89     Z7059eP_PARAMETER_NONOL_WF_CAT_1Y
90     Z706 PARAMETER_METHODY
91     Z7060eP_PARAMETER_NONOL_WF_CAT_2Y
92     Z7061eP_PARAMETER_NONOL_WF_CAT_3Y
93     Z7062eP_PARAMETER_NONOL_WF_ESCALATEY
94     Z707 PARAMETER_TOSTATUSY
95     Z708 PARAMETER_FROMTSTATUSY
96     Z709 PARAMETER_TOPATHCODEY
97     Z710 PARAMETER_FROMPATHCODEY
98     Z711 PARAMETER_TOENVY
99     Z712 PARAMETER_FROMENVY
100     Z713 PARAMETER_TODSY
101     Z714 PARAMETER_FROMDSY
102     Z715 PARAMETER_CURRENTPROJECTY
103     Z716 PARAMETER_CURRENTSTATUSY
104     Z717 PARAMETER_SEVERITYY
105     Z718 PARAMETER_SARNUMBERY
106     Z719 PARAMETER_SIGNONUSERY
107     Z720 PARAMETER_SIGNONUSERROLEY
108     Z721 PARAMETER_VERSIONIDY
109     Z722 PARAMETER_DELETELOCALONLYY
110     Z723 PARAMETER_OBJECTINTERFACEPOY
111     Z724 PARAMETER_LOGINTERFACEPOINTY
112     Z725 eP_PARAMETER_SYSTEMCODEY
113     Z726 eP_PARAMETER_PLANCOMPLETEDATEY
114     Z727 eP_PARAMETER_CATEGORYCODE1Y
115     Z728 eP_PARAMETER_CATEGORYCODE2Y
116     Z729 eP_PARAMETER_CATEGORYCODE3Y
117     Z730 eP_PARAMETER_CATEGORYCODE4Y
118     Z731 eP_PARAMETER_CATEGORYCODE5Y
119     Z732 eP_PARAMETER_CATEGORYCODE6Y
120     Z733 eP_PARAMETER_CATEGORYCODE7Y
121     Z734 eP_PARAMETER_CATEGORYCODE8Y
122     Z735 eP_PARAMETER_CATEGORYCODE9Y
123     Z736 eP_PARAMETER_CATEGORYCODE10Y
124     Z737 eP_PARAMETER_PROJECTTYPEY
125     Z738 eP_PARAMETER_PROJECTDESCY
126     Z739 PARAMETER_AUTOHUSERY
127     Z740 PARAMETER_HWNDY
128     Z741 P_PARAMETER_OKCANCELY
129     Z742 P_OL_ADD_MODE_FLAGY
130     Z743 P_PARAMETER_REPSYSTEMCODEY
131     Z744 P_PARAMETER_OL_FUNC_USEY
132     Z745 eP_PARAMETER_OL_TC_FLAGY
133     Z746 eP_PARAMETER_OL_COL_PREFIXY
134     Z747 eP_PARAMETER_OL_DSTR_TYPEY
135     Z748 eP_PARAMETER_OL_SRC_LANGY
136     Z749 P_PARAMETER_CLIENT_SERVERY
137     Z750 P_PARAMETER_CREATIONDATEY
138     Z751 P_PARAMETER_STARTDATEY
139     Z752 eP_PARAMETER_OL_COMMON_FILEY
140     Z753 eP_PARAMETER_OL_COPY_DATAY
141     Z754 eP_PARAMETER_OL_OPT_DATAY
142     Z755 eP_PARAMETER_OL_PO_TEMPLATEY
143     Z756 eP_PARAMETER_OL_PAR_DLLY
144     Z757 eP_PARAMETER_OL_CC1Y
145     Z758 eP_PARAMETER_OL_CC2Y
146     Z759 eP_PARAMETER_OL_CC3Y
147     Z760 eP_PARAMETER_OL_CC4Y
148     Z761 eP_PARAMETER_OL_CC5Y
149     Z762 eP_PARAMETER_PROMPT_USERY
150     Z763 P_PARAMETER_PRJHANDLEY
151     Z764 P_PRJPOINTERY
152     Z765 P_DESIGN MODEY
153     Z766 eP_PARAMETER_PROJECTLEADY
154     Z767 eP_PARAMETER_ESTHOURSY
155     Z768 eP_PARAMETER_DATEASSIGNEDY
156     Z769 eP_PARAMETER_TIMEASSIGNEDY
157     Z770 eP_PARAMETER_ER_PRODTYPEY
158     Z771 eP_PARAMETER_REFERENCESARY
159     Z772 eP_PARAMETER_COMPLETEDATEY
160     Z773 eP_PARAMETER_TRUE_FALSEY
161     Z774 eP_PARAMETER_OL_OMIT_OPTY
162     Z775 eP_PARAMETER_OL_GLBL_BUILDY
163     Z776 eP_PARAMETER_OL_JDETEXTY
164     Z777 eP_PARAMETER_OL_OBJ_CATY
165     Z778 eP_PARAMETER_OL_PAR_OBNY
166     Z780 eP_PARAMETER_LOCATIONY
167     Z781 eP_PARAMETER_NEWRELEASEY
168     Z782 eP_PARAMETER_DEAD_LOCK_PROJECTY
169     Z783 eP_PARAMETER_DEAD_LOCK_OBJECTY
170     Z784 eP_PARAMETER_ASSIGNED_TOKEN_PRY
171     Z785 eP_PARAMETER_ASSIGNED_TOKEN_OBY
172     Z786 eP_PARAMETER_PROOF_FINALY
173     Z787 eP_PARAMETER_TDA_DATAY
174     Z788 eP_PARAMETER_TSE_OTHERUSERY
175     Z789 eP_PARAMETER_NEW_PO_TEMPLATEY
176     Z790 eP_PARAMETER_CUSTOMER_NUMBERY
177     Z791 eP_PARAMETER_ORIGINATORY
178     Z792 eP_PARAMETER_PRODUCT_SUPPORTY
179     Z793 eP_PARAMETER_MANAGERY
180     Z794 eP_PARAMETER_SUPERVISORY
181     Z795 eP_PARAMETER_ASSIGNED_TOY
182     Z796 eP_PARAMETER_TESTERY
183     Z797 eP_PARAMETER_LONGDESCY
184     Z798 eP_PARAMETER_COVERPAGEY
185     Z799 eP_PARAMETER_JOBQUEUEY
186     Z801 L_SETATTRIBUTE_TOSTATUSY
187     Z802 L_SETATTRIBUTE_FROMSTATUSY
188     Z803 L_SETATTRIBUTE_TOPATHCODEY
189     Z804 L_SETATTRIBUTE_FROMPATHCODEY
190     Z805 L_SETATTRIBUTE_TOENVY
191     Z806 L_SETATTRIBUTE_FROMENVY
192     Z807 L_SETATTRIBUTE_TODSY
193     Z808 L_SETATTRIBUTE_FROMDSY
194     Z810 eP_PARAMETER_CODE_CHANGEY
195     Z811 eP_PARAMETER_ROOT_CAUSEY
196     Z812 eP_PARAMETER_DEFECT_SOURCEY
197     Z813 eP_PARAMETER_ESCALATEDY
198     Z814 eP_PARAMETER_ASSESSMENTY
199     Z815 eP_PARAMETER_STATUS_COMMENTY
200     Z816 eP_PARAMETER_PARENT_SARY
201     Z90  Create ObjectY
202     Z901 O_SETATTRIBUTE_TOSTATUSY
203     Z902 O_SETATTRIBUTE_CURRENTPROJECTY
204     Z903 O_SETATTRIBUTE_SARNUMBERY
205     Z904 O_SETATTRIBUTE_SIGNONUSERY
206     Z905 O_SETATTRIBUTE_SIGNONUSERROLEY
207     Z906 O_SETATTRIBUTE_VERSIONIDY
208     Z907 O_SETATTRIBUTE_DELETELOCALONLY
209     Z91  Create ProjectY
210     Z92  Get ProjectY
211     Z93  Log ActionY
212     Z94  Log InitilizeY
213     Z95  Get ObjectY
214     Z950 O_GETATTRIBUTE_TOSTATUSY
215     Z951 O_GETATTRIBUTE_OMWRELEASEY
216     Z952 O_GETATTRIBUTE_SARNUMBERY
217     Z953 O_GETATTRIBUTE_SIGNONUSERY
218     Z954 O_GETATTRIBUTE_SIGNONUSERROLEY
219     Z955 O_GETATTRIBUTE_VERSIONIDY
220     Z956 O_GETATTRIBUTE_OBJECTIDY
221     Z957 O_GETATTRIBUTE_OBJECTTYPEY
222     Z958 O_GETATTRIBUTE_DESCRIPTIONY
223     Z96  Delete Pointer referenceY
224     Z97  Create Parameter ObjectY
225     Z99  Add User To ProjectY
22639        ExtractY