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

31 COLUMNS | 6 INDEXES | Print definition?910 | H92 | F98225 TABLE

H92: Interactive Engine/OL
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F98225TR316OMW Transfer Activity RulesSecondary Master FilesH92: Interactive Engine/OLSystem 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 TROMWFPS, TROMWTPS, TROMWUSER, TROMWOT, TRSRCRLS, TRTRGRLS, TROMWSRCLOC, TROMWTRGLOC, TROMWAC, TROMWRLSTK, TROMWACTFLG, TROMWTMS1, TROMWTMS2, TROMWTMS3, TROMWTMD1, TROMWTMD2, TROMWTMD3, TROMWTMD4, TROMWTMD5, TROMWTMN1, TROMWTMN2, TROMWTMN3, TROMWTMN4, TROMWTMN5, TRPID, TRMKEY, TRUSER, TRUPMJ, TRUPMT, TRTIMEZONES, TRDSAVNAME FROM F98225

TOP910 | H92 | F98225 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1TROMWFPSObject Management From Project StatusStringUDC (H92 PS)50 Allow NULL? 
2TROMWTPSObject Management To Project StatusStringUDC (H92 PS)50 Allow NULL? 
3TROMWUSEROMW Project UserStringGeneric Edit100 Allow NULL? 
4TROMWOTObject Management Object TypeStringUDC (H92 OT)100 Allow NULL? 
5TRSRCRLSSource Release NumberStringUDC (98 RL)100 Allow NULL? 
6TRTRGRLSTarget Release NumberStringUDC (98 RL)100 Allow NULL? 
7TROMWSRCLOCOMW Source LocationStringGeneric Edit300 Allow NULL? 
8TROMWTRGLOCOMW Target LocationStringGeneric Edit300 Allow NULL? 
9TROMWACObject Management Action CodeStringUDC (H92 AC)50 Allow NULL? 
10TROMWRLSTKOMW Release Token Now FlagCharacterGeneric Edit10 Allow NULL? 
11TROMWACTFLGOMW Active FlagCharacterGeneric Edit10 Allow NULL? 
12TROMWTMS1OMW Transfer Map Future String 1StringGeneric Edit300 Allow NULL? 
13TROMWTMS2OMW Transfer Map Future String 2StringGeneric Edit300 Allow NULL? 
14TROMWTMS3OMW Transfer Map Future String 3StringGeneric Edit300 Allow NULL? 
15TROMWTMD1OMW Transfer Map Future Use Date 1DateGeneric Edit60
16TROMWTMD2OMW Transfer Map Future Use Date 2DateGeneric Edit60
17TROMWTMD3OMW Transfer Map Future Use Date 3DateGeneric Edit60
18TROMWTMD4OMW Transfer Map Future Use Date 4DateGeneric Edit60
19TROMWTMD5OMW Transfer Map Future Use Date 5DateGeneric Edit60
20TROMWTMN1OMW Mandatory Trans. Activity Rule FlagNumericUDC (H92 MA)110 Allow NULL? 
21TROMWTMN2OMW Backup RuleNumericGeneric Edit110 Allow NULL? 
22TROMWTMN3OMW Dependency ValidationNumericGeneric Edit110 Allow NULL? 
23TROMWTMN4OMW Transfer Map Future Use Numeric 4NumericGeneric Edit110 Allow NULL? 
24TROMWTMN5OMW Transfer Map Future Use Numeric 5NumericGeneric Edit110 Allow NULL? 
25TRPIDProgram IDStringGeneric Edit100 Allow NULL? 
26TRMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
27TRUSERUser IDStringGeneric Edit100 Allow NULL? 
28TRUPMJDate - UpdatedDateGeneric Edit60
29TRUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
30TRTIMEZONESTime Zone ListStringUDC (H91 TZ)20 Allow NULL? 
31TRDSAVNAMEDaylight Savings Rule NameStringUDC100 Allow NULL? 

TOP910 | H92 | F98225 INDEXES

NumberDescription
1Fm To Usr Typ SR TR SL TL Act (Primary/Unique)
ElementAliasDescriptionSequence
1OMWFPSObject Management From Project StatusAscending
2OMWTPSObject Management To Project StatusAscending
3OMWUSEROMW Project UserAscending
4OMWOTObject Management Object TypeAscending
5SRCRLSSource Release NumberAscending
6TRGRLSTarget Release NumberAscending
7OMWSRCLOCOMW Source LocationAscending
8OMWTRGLOCOMW Target LocationAscending
9OMWACObject Management Action CodeAscending
2Release Token Now
ElementAliasDescriptionSequence
1OMWRLSTKOMW Release Token Now FlagAscending
3Active Flag
ElementAliasDescriptionSequence
1OMWACTFLGOMW Active FlagAscending
4FromStatus ToStatus +
ElementAliasDescriptionSequence
1OMWFPSObject Management From Project StatusAscending
2OMWTPSObject Management To Project StatusAscending
3OMWUSEROMW Project UserAscending
4OMWACTFLGOMW Active FlagAscending
5Action User
ElementAliasDescriptionSequence
1OMWACObject Management Action CodeAscending
2OMWUSEROMW Project UserAscending
3OMWOTObject Management Object TypeAscending
7From To Type SRelease Actv Tkn
ElementAliasDescriptionSequence
1OMWFPSObject Management From Project StatusAscending
2OMWTPSObject Management To Project StatusAscending
3OMWOTObject Management Object TypeAscending
4SRCRLSSource Release NumberAscending
5OMWACTFLGOMW Active FlagAscending
6OMWRLSTKOMW Release Token Now FlagAscending