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

6 columns | Print definition?920 | 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     01Transfer Y
2     02Check-In Y
3     02ACheck-In Keep Checked Out Y
4     02UDOEdit Y
5     03Check-Out Y
6     04Delete Y
7     05Add Y
8     05UDORequest Publish Y
9     06Copy Y
10     07Install Y
11     08Save Y
12     08UDOApprove Y
13     09Restore Y
14     10Design Y
15     106Get ObjectID Y
16     109Generate Web Specs Y
17     11Get Y
18     12Remove Object From Project N
19     13Update Project Y
20     14Update Project User Y
21     15Remove User From Project Y
22     16Add Object to Project Y
23     20Request Token Y
24     21Switch Token Y
25     22Add to Token Queue Y
26     23Force Release From Token Queue Y
27     25UDOReject Y
28     30Erase Check-Out Y
29     31Rollback Y
30     32Backup Y
31     35Validate Check-Out Date Y
32     36Is Local Y
33     37Is Different Y
34     38Status Change Y
35     39Extract Y
36     40Load Y
37     41Web Object Action Y
38     Z100Get Object From Project Y
39     Z101Get User From Project Y
40     Z102Update Project Object Y
41     Z103Copy Object from Project Y
42     Z104Move Object to Project Y
43     Z105Assign Token Y
44     Z108Get OMW Feature Y
45     Z700PARAMETER_OBJECTTYPE Y
46     Z7000eP_PARAMETER_PO_PROMPT_FLAG Y
47     Z7001eP_PARAMETER_VER_SECURITY Y
48     Z7002eP_PARAMETER_PO_DATA Y
49     Z7003eP_PARAMETER_BHVRCOM Y
50     Z7004eP_PARAMETER_VOID Y
51     Z7005eP_PARAMETER_SETSEL_FLAG Y
52     Z7006eP_PARAMETER_FORM_TO_CALL Y
53     Z7007eP_PARAMETER_REPLACE_SAVELOC Y
54     Z7008eP_PARAMETER_DEL_FROMSRVR Y
55     Z7009eP_PARAMETER_DEL_COMPLETELY Y
56     Z701PARAMETER_OBJECTID Y
57     Z7010eP_PARAMETER_GLOSSARY_ITEM Y
58     Z7011eP_PARAMETER_INHERIT_TOKEN Y
59     Z7012eP_PARAMETER_UPDATEDPROJECTSLI Y
60     Z7013eP_PARAMETER_NEWPROJECTID Y
61     Z7014eP_PARAMETER_NOSTATUSUPDATE Y
62     Z7015eP_PARAMETER_FROMSARSTATUS Y
63     Z7016eP_PARAMETER_TOSARSTATUS Y
64     Z7017eP_PARAMETER_XFERREDINHERITOBJ Y
65     Z7018eP_PARAMETER_OL_PACKAGECOL Y
66     Z7019eP_PARAMETER_OL_BASEMEMBER Y
67     Z702PARAMETER_PROJECTID Y
68     Z7020eP_PARAMETER_OL_PROCESSOP Y
69     Z7021eP_PARAMETER_OL_GTFUTURE Y
70     Z7022eP_PARAMETER_OL_TYPETEXT Y
71     Z7023eP_PARAMETER_OL_TEXTFILE Y
72     Z7024eP_PARAMETER_OL_CURRENCY Y
73     Z7025eP_PARAMETER_OL_APPLID Y
74     Z7026eP_PARAMETER_OL_ANSI Y
75     Z7027eP_PARAMETER_DEL_SAVE Y
76     Z7028eP_PARAMETER_OBJSNOTMODIFIEDOB Y
77     Z7029eP_PARAMETER_PROJECTPOINTERLIS Y
78     Z703PARAMETER_OBJECTDESCRIPTION Y
79     Z7030ePARAMETER_FROMPATH Y
80     Z7031ePARAMETER_TOPATH Y
81     Z7032ePARAMETER_PACKAGE_NAME Y
82     Z7039eP_PARAMETER_OMWFEATURETYPE Y
83     Z704PARAMETER_RELEASE Y
84     Z7043eP_PARAMETER_TEXT_SEARCH_BSVW Y
85     Z7044eP_PARAMETER_NO_PROGRESS_DLG Y
86     Z7045eP_PARAMETER_PRINT_IMMEDIATE Y
87     Z7046eP_PARAMETER_INT_OBJTYPE Y
88     Z7047eP_PARAMETER_CHECKIN/CHECKOUT Y
89     Z7048eP_PARAMETER_PACKAGE_PREFIX Y
90     Z705PARAMETER_PROGRAMID Y
91     Z7050eP_PARAMETER_NONOL_WF_PROCESS Y
92     Z7051eP_PARAMETER_NONOL_WF_VERSION Y
93     Z7052eP_PARAMETER_NONOL_WF_DESC Y
94     Z7053eP_PARAMETER_NONOL_WF_PROD_CD Y
95     Z7054eP_PARAMETER_NONOL_WF_KEY_DS Y
96     Z7055eP_PARAMETER_NONOL_WF_ADD_DS Y
97     Z7056eP_PARAMETER_NONOL_WF_HISTORY Y
98     Z7057eP_PARAMETER_NONOL_WF_CPY_PROC Y
99     Z7058eP_PARAMETER_NONOL_WF_CPY_VER Y
100     Z7059eP_PARAMETER_NONOL_WF_CAT_1 Y
101     Z706PARAMETER_METHOD Y
102     Z7060eP_PARAMETER_NONOL_WF_CAT_2 Y
103     Z7061eP_PARAMETER_NONOL_WF_CAT_3 Y
104     Z7062eP_PARAMETER_NONOL_WF_ESCALATE Y
105     Z707PARAMETER_TOSTATUS Y
106     Z7070eP_PARAMETER_OMWFEAT_SCMINT_ON Y
107     Z7071eP_PARAMETER_SCM_REQUEST Y
108     Z7072eP_PARAMETER_SCM_PATH_VALID Y
109     Z7073eP_PARAMETER_SCM_PATH Y
110     Z7074eP_PARAMETER_SCM_INTCHOICE Y
111     Z7075eP_PARAMETER_SCM_SERVER Y
112     Z7076eP_PARAMETER_SCM_USER Y
113     Z7077eP_PARAMETER_SCM_PASSWORD Y
114     Z7078eP_PARAMETER_SCM_STARTEAM_PORT Y
115     Z7079eP_PARAMETER_SCM_CREATEPATH Y
116     Z708PARAMETER_FROMTSTATUS Y
117     Z7080eP_PARAMETER_OMWSCM_NOMESSAGE Y
118     Z7081eP_PARAMETER_SCM_FEATURE Y
119     Z7082eP_PARAMETER_SCM_FEATURE_SUPPO Y
120     Z709PARAMETER_TOPATHCODE Y
121     Z710PARAMETER_FROMPATHCODE Y
122     Z711PARAMETER_TOENV Y
123     Z712PARAMETER_FROMENV Y
124     Z713PARAMETER_TODS Y
125     Z714PARAMETER_FROMDS Y
126     Z715PARAMETER_CURRENTPROJECT Y
127     Z716PARAMETER_CURRENTSTATUS Y
128     Z717PARAMETER_SEVERITY Y
129     Z718PARAMETER_SARNUMBER Y
130     Z719PARAMETER_SIGNONUSER Y
131     Z720PARAMETER_SIGNONUSERROLE Y
132     Z721PARAMETER_VERSIONID Y
133     Z722PARAMETER_DELETELOCALONLY Y
134     Z723PARAMETER_OBJECTINTERFACEPO Y
135     Z724PARAMETER_LOGINTERFACEPOINT Y
136     Z725eP_PARAMETER_SYSTEMCODE Y
137     Z726eP_PARAMETER_PLANCOMPLETEDATE Y
138     Z727eP_PARAMETER_CATEGORYCODE1 Y
139     Z728eP_PARAMETER_CATEGORYCODE2 Y
140     Z729eP_PARAMETER_CATEGORYCODE3 Y
141     Z730eP_PARAMETER_CATEGORYCODE4 Y
142     Z731eP_PARAMETER_CATEGORYCODE5 Y
143     Z732eP_PARAMETER_CATEGORYCODE6 Y
144     Z733eP_PARAMETER_CATEGORYCODE7 Y
145     Z734eP_PARAMETER_CATEGORYCODE8 Y
146     Z735eP_PARAMETER_CATEGORYCODE9 Y
147     Z736eP_PARAMETER_CATEGORYCODE10 Y
148     Z737eP_PARAMETER_PROJECTTYPE Y
149     Z738eP_PARAMETER_PROJECTDESC Y
150     Z739PARAMETER_AUTOHUSER Y
151     Z740PARAMETER_HWND Y
152     Z741P_PARAMETER_OKCANCEL Y
153     Z742P_OL_ADD_MODE_FLAG Y
154     Z743P_PARAMETER_REPSYSTEMCODE Y
155     Z744P_PARAMETER_OL_FUNC_USE Y
156     Z745eP_PARAMETER_OL_TC_FLAG Y
157     Z746eP_PARAMETER_OL_COL_PREFIX Y
158     Z747eP_PARAMETER_OL_DSTR_TYPE Y
159     Z748eP_PARAMETER_OL_SRC_LANG Y
160     Z749P_PARAMETER_CLIENT_SERVER Y
161     Z750P_PARAMETER_CREATIONDATE Y
162     Z751P_PARAMETER_STARTDATE Y
163     Z752eP_PARAMETER_OL_COMMON_FILE Y
164     Z753eP_PARAMETER_OL_COPY_DATA Y
165     Z754eP_PARAMETER_OL_OPT_DATA Y
166     Z755eP_PARAMETER_OL_PO_TEMPLATE Y
167     Z756eP_PARAMETER_OL_PAR_DLL Y
168     Z757eP_PARAMETER_OL_CC1 Y
169     Z758eP_PARAMETER_OL_CC2 Y
170     Z759eP_PARAMETER_OL_CC3 Y
171     Z760eP_PARAMETER_OL_CC4 Y
172     Z761eP_PARAMETER_OL_CC5 Y
173     Z762eP_PARAMETER_PROMPT_USER Y
174     Z763P_PARAMETER_PRJHANDLE Y
175     Z764P_PRJPOINTER Y
176     Z765P_DESIGN MODE Y
177     Z766eP_PARAMETER_PROJECTLEAD Y
178     Z767eP_PARAMETER_ESTHOURS Y
179     Z768eP_PARAMETER_DATEASSIGNED Y
180     Z769eP_PARAMETER_TIMEASSIGNED Y
181     Z770eP_PARAMETER_ER_PRODTYPE Y
182     Z771eP_PARAMETER_REFERENCESAR Y
183     Z772eP_PARAMETER_COMPLETEDATE Y
184     Z773eP_PARAMETER_TRUE_FALSE Y
185     Z774eP_PARAMETER_OL_OMIT_OPT Y
186     Z775eP_PARAMETER_OL_GLBL_BUILD Y
187     Z776eP_PARAMETER_OL_JDETEXT Y
188     Z777eP_PARAMETER_OL_OBJ_CAT Y
189     Z778eP_PARAMETER_OL_PAR_OBN Y
190     Z780eP_PARAMETER_LOCATION Y
191     Z781eP_PARAMETER_NEWRELEASE Y
192     Z782eP_PARAMETER_DEAD_LOCK_PROJECT Y
193     Z783eP_PARAMETER_DEAD_LOCK_OBJECT Y
194     Z784eP_PARAMETER_ASSIGNED_TOKEN_PR Y
195     Z785eP_PARAMETER_ASSIGNED_TOKEN_OB Y
196     Z786eP_PARAMETER_PROOF_FINAL Y
197     Z787eP_PARAMETER_TDA_DATA Y
198     Z788eP_PARAMETER_TSE_OTHERUSER Y
199     Z789eP_PARAMETER_NEW_PO_TEMPLATE Y
200     Z790eP_PARAMETER_CUSTOMER_NUMBER Y
201     Z791eP_PARAMETER_ORIGINATOR Y
202     Z792eP_PARAMETER_PRODUCT_SUPPORT Y
203     Z793eP_PARAMETER_MANAGER Y
204     Z794eP_PARAMETER_SUPERVISOR Y
205     Z795eP_PARAMETER_ASSIGNED_TO Y
206     Z796eP_PARAMETER_TESTER Y
207     Z797eP_PARAMETER_LONGDESC Y
208     Z798eP_PARAMETER_COVERPAGE Y
209     Z799eP_PARAMETER_JOBQUEUE Y
210     Z801L_SETATTRIBUTE_TOSTATUS Y
211     Z802L_SETATTRIBUTE_FROMSTATUS Y
212     Z803L_SETATTRIBUTE_TOPATHCODE Y
213     Z804L_SETATTRIBUTE_FROMPATHCODE Y
214     Z805L_SETATTRIBUTE_TOENV Y
215     Z806L_SETATTRIBUTE_FROMENV Y
216     Z807L_SETATTRIBUTE_TODS Y
217     Z808L_SETATTRIBUTE_FROMDS Y
218     Z810eP_PARAMETER_CODE_CHANGE Y
219     Z811eP_PARAMETER_ROOT_CAUSE Y
220     Z812eP_PARAMETER_DEFECT_SOURCE Y
221     Z813eP_PARAMETER_ESCALATED Y
222     Z814eP_PARAMETER_ASSESSMENT Y
223     Z815eP_PARAMETER_STATUS_COMMENT Y
224     Z816eP_PARAMETER_PARENT_SAR Y
225     Z90Create Object Y
226     Z901O_SETATTRIBUTE_TOSTATUS Y
227     Z902O_SETATTRIBUTE_CURRENTPROJECT Y
228     Z903O_SETATTRIBUTE_SARNUMBER Y
229     Z904O_SETATTRIBUTE_SIGNONUSER Y
230     Z905O_SETATTRIBUTE_SIGNONUSERROLE Y
231     Z906O_SETATTRIBUTE_VERSIONID Y
232     Z907O_SETATTRIBUTE_DELETELOCALONL Y
233     Z91Create Project Y
234     Z92Get Project Y
235     Z93Log Action Y
236     Z94Log Initilize Y
237     Z95Get Object Y
238     Z950O_GETATTRIBUTE_TOSTATUS Y
239     Z951O_GETATTRIBUTE_OMWRELEASE Y
240     Z952O_GETATTRIBUTE_SARNUMBER Y
241     Z953O_GETATTRIBUTE_SIGNONUSER Y
242     Z954O_GETATTRIBUTE_SIGNONUSERROLE Y
243     Z955O_GETATTRIBUTE_VERSIONID Y
244     Z956O_GETATTRIBUTE_OBJECTID Y
245     Z957O_GETATTRIBUTE_OBJECTTYPE Y
246     Z958O_GETATTRIBUTE_DESCRIPTION Y
247     Z96Delete Pointer reference Y
248     Z97Create Parameter Object Y
249     Z99Add User To Project Y
25039Extract Y

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