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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

32 COLUMNS | 12 INDEXES | Print definition?920 | H90 | F98865 TABLE

H90: EnterpriseOne TOOLS
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F98865AI3212Task InstanceMaster FilesH90: EnterpriseOne TOOLSControl Tables
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT AIPROCNAME, AIPROCVER, AIPROCIST, AIACTNAME, AIACTIST, AIORGGRP, AISEQUENCE, AIRESOURCE, AIALLREQ, AIACTSTS, AIACTACT, AIOVERRIDE, AIEMAILNO, AISTDATE, AISTTME, AIENDATE, AIENTME, AISUBPROC, AISUBIST, AISUBVER, AIDAEXP, AITIEXP, AIESCHR, AIAINSTUID, AIACTUID, AIPINSTUID, AILOCSPUID, AIREMSPKEY, AIUSER, AIPID, AIJOBN, AIUPMJ FROM F98865

TOP920 | H90 | F98865 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1AIPROCNAMEProcess IDStringGeneric Edit100 Allow NULL? 
2AIPROCVERWorkflow Process VersionNumericGeneric Edit50 Allow NULL? 
3AIPROCISTProcess InstanceNumericGeneric Edit80 Allow NULL? 
4AIACTNAMETaskStringGeneric Edit100 Allow NULL? 
5AIACTISTTask InstanceNumericGeneric Edit80 Allow NULL? 
6AIORGGRPOrganizational Group NumberNumericGeneric Edit30 Allow NULL? 
7AISEQUENCESequence NumberNumericGeneric Edit50 Allow NULL? 
8AIRESOURCEResourceNumericGeneric Edit80 Allow NULL? 
9AIALLREQRequired (Y/N)CharacterGeneric Edit10 Allow NULL? 
10AIACTSTSTask StatusStringUDC (98 AS)20 Allow NULL? 
11AIACTACTTask ActionStringUDC (98 AN)20 Allow NULL? 
12AIOVERRIDEHigher Level Override (Y/N)CharacterGeneric Edit10 Allow NULL? 
13AIEMAILNOE-mail Serial NumberNumericGeneric Edit150 Allow NULL? 
14AISTDATEStart DateDateGeneric Edit60
15AISTTMEStart TimeNumericGeneric Edit70 Allow NULL? 
16AIENDATEEnd DateDateGeneric Edit60
17AIENTMEEnd TimeNumericGeneric Edit70 Allow NULL? 
18AISUBPROCWorkflow Sub Process DescriptionStringGeneric Edit100 Allow NULL? 
19AISUBISTSub Process InstanceNumericGeneric Edit80 Allow NULL? 
20AISUBVERSub Workflow Process VersionNumericGeneric Edit50 Allow NULL? 
21AIDAEXPDate ExpiredDateGeneric Edit60
22AITIEXPTime ExpiredNumericGeneric Edit70 Allow NULL? 
23AIESCHREscalation Hours/MinutesNumericGeneric Edit70 Allow NULL? 
24AIAINSTUIDWorkflow Task Instance Unique IDStringGeneric Edit640 Allow NULL? 
25AIACTUIDWorkflow Task Unique IDStringGeneric Edit640 Allow NULL? 
26AIPINSTUIDWorkflow Process Instance Unique IDStringGeneric Edit640 Allow NULL? 
27AILOCSPUIDWorkflow Local Sub Process Unique IDStringGeneric Edit640 Allow NULL? 
28AIREMSPKEYWorkflow Remote Sub Process KeyStringGeneric Edit1270 Allow NULL? 
29AIUSERUser IDStringGeneric Edit100 Allow NULL? 
30AIPIDProgram IDStringGeneric Edit100 Allow NULL? 
31AIJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
32AIUPMJDate - UpdatedDateGeneric Edit60

TOP920 | H90 | F98865 INDEXES

NumberDescription
1Process Name Version + A (Primary/Unique)
ElementAliasDescriptionSequence
1PROCNAMEProcess IDAscending
2PROCVERWorkflow Process VersionAscending
3PROCISTProcess InstanceAscending
4ACTNAMETaskAscending
5ACTISTTask InstanceAscending
6ORGGRPOrganizational Group NumberAscending
7SEQUENCESequence NumberAscending
2Email Serial Number
ElementAliasDescriptionSequence
1EMAILNOE-mail Serial NumberAscending
3Sub Process Sub Process Ist
ElementAliasDescriptionSequence
1SUBPROCWorkflow Sub Process DescriptionAscending
2SUBVERSub Workflow Process VersionAscending
3SUBISTSub Process InstanceAscending
4Process Name Version + B
ElementAliasDescriptionSequence
1PROCNAMEProcess IDAscending
2PROCVERWorkflow Process VersionAscending
3PROCISTProcess InstanceAscending
4RESOURCEResourceAscending
5ACTNAMETaskAscending
6ACTSTSTask StatusAscending
5Process Name Verision + C
ElementAliasDescriptionSequence
1PROCNAMEProcess IDAscending
2PROCVERWorkflow Process VersionAscending
3PROCISTProcess InstanceAscending
4STDATEStart DateAscending
5STTMEStart TimeAscending
6ORGGRPOrganizational Group NumberAscending
7SEQUENCESequence NumberAscending
6Process Name Version + D
ElementAliasDescriptionSequence
1PROCNAMEProcess IDAscending
2PROCVERWorkflow Process VersionAscending
3PROCISTProcess InstanceAscending
4STDATEStart DateAscending
5STTMEStart TimeAscending
7Process Name Version + E
ElementAliasDescriptionSequence
1PROCNAMEProcess IDAscending
2RESOURCEResourceAscending
3ACTSTSTask StatusDescending
4DAEXPDate ExpiredAscending
5ACTNAMETaskAscending
8ActivityInstanceUID (Unique)
ElementAliasDescriptionSequence
1AINSTUIDWorkflow Task Instance Unique IDAscending
9ActivityUID
ElementAliasDescriptionSequence
1ACTUIDWorkflow Task Unique IDAscending
10ProcessInstanceUID
ElementAliasDescriptionSequence
1PINSTUIDWorkflow Process Instance Unique IDAscending
11LocalProcessUID
ElementAliasDescriptionSequence
1LOCSPUIDWorkflow Local Sub Process Unique IDAscending
12RemoteProcessKey
ElementAliasDescriptionSequence
1REMSPKEYWorkflow Remote Sub Process KeyAscending