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

39 COLUMNS | 10 INDEXES | Print definition?910 | H92 | F98222 TABLE

H92: Interactive Engine/OL
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F98222PO3910OMW Project ObjectsSecondary 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 POOMWPRJID, POOMWOBJID, POOMWOT, POSRCRLS, POOMWUSER, POOMWMKEY, POENHV, POPATHCD, PODATS, POOMWCHS, POOMWOST, POOMWOVS, POOMWOBSDT, POOMWCRTDT, POOMWAC, POOMWTC, POOMWTCV, POOMWPOS1, POOMWPOS2, POOMWPOS3, POOMWPOS4, POOMWPOS5, POOMWPOD1, POOMWPOD2, POOMWPOD3, POOMWPOD4, POOMWPOD5, POOMWPON1, POOMWPON2, POOMWPON3, POOMWPON4, POOMWPON5, POPID, POMKEY, POUSER, POUPMJ, POUPMT, POTIMEZONES, PODSAVNAME FROM F98222

TOP910 | H92 | F98222 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1POOMWPRJIDObject Management Project NameStringGeneric Edit300 Allow NULL? 
2POOMWOBJIDObject Management Object NameStringGeneric Edit2000 Allow NULL? 
3POOMWOTObject Management Object TypeStringUDC (H92 OT)100 Allow NULL? 
4POSRCRLSSource Release NumberStringUDC (98 RL)100 Allow NULL? 
5POOMWUSEROMW Project UserStringGeneric Edit100 Allow NULL? 
6POOMWMKEYOMW Object Machine LocationStringGeneric Edit150 Allow NULL? 
7POENHVEnvironment NameStringGeneric Edit100 Allow NULL? 
8POPATHCDCode - PathStringGeneric Edit100 Allow NULL? 
9PODATSData SourceStringGeneric Edit300 Allow NULL? 
10POOMWCHSOMW Checkout StatusCharacterGeneric Edit10 Allow NULL? 
11POOMWOSTObject Management Object StatusStringUDC (H92 OS)50 Allow NULL? 
12POOMWOVSObject Management Validation StatusStringUDC (H92 OV)50 Allow NULL? 
13POOMWOBSDTOMW Obsolete DateDateGeneric Edit60
14POOMWCRTDTOMW Initial Creation DateDateGeneric Edit60
15POOMWACObject Management Action CodeStringUDC (H92 AC)50 Allow NULL? 
16POOMWTCObject Management Table Conversion NameStringGeneric Edit100 Allow NULL? 
17POOMWTCVOMW Table Conversion VersionStringGeneric Edit100 Allow NULL? 
18POOMWPOS1OMW Project Object FlagsStringGeneric Edit300 Allow NULL? 
19POOMWPOS2Token Inheritance Parent ProjectStringGeneric Edit300 Allow NULL? 
20POOMWPOS3OMW Project Object Future String 3StringGeneric Edit300 Allow NULL? 
21POOMWPOS4OMW Project Object Future String 4StringGeneric Edit300 Allow NULL? 
22POOMWPOS5OMW Project Object Future String 5StringGeneric Edit300 Allow NULL? 
23POOMWPOD1OMW Project Object Future Use Date 1DateGeneric Edit60
24POOMWPOD2OMW Project Object Future Use Date 2DateGeneric Edit60
25POOMWPOD3OMW Project Object Future Use Date 3DateGeneric Edit60
26POOMWPOD4OMW Project Object Future Use Date 4DateGeneric Edit60
27POOMWPOD5OMW Project Object Future Use Date 5DateGeneric Edit60
28POOMWPON1Object Token Queue Time StampNumericGeneric Edit110 Allow NULL? 
29POOMWPON2OMW Project Object Future Use Numeric 2NumericGeneric Edit110 Allow NULL? 
30POOMWPON3OMW Project Object Future Use Numeric 3NumericGeneric Edit110 Allow NULL? 
31POOMWPON4OMW Project Object Future Use Numeric 4NumericGeneric Edit110 Allow NULL? 
32POOMWPON5OMW Project Object Future Use Numeric 5NumericGeneric Edit110 Allow NULL? 
33POPIDProgram IDStringGeneric Edit100 Allow NULL? 
34POMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
35POUSERUser IDStringGeneric Edit100 Allow NULL? 
36POUPMJDate - UpdatedDateGeneric Edit60
37POUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
38POTIMEZONESTime Zone ListStringUDC (H91 TZ)20 Allow NULL? 
39PODSAVNAMEDaylight Savings Rule NameStringUDC100 Allow NULL? 

TOP910 | H92 | F98222 INDEXES

NumberDescription
1Project Object Rel ObjType (Primary/Unique)
ElementAliasDescriptionSequence
1OMWPRJIDObject Management Project NameAscending
2OMWOBJIDObject Management Object NameAscending
3SRCRLSSource Release NumberAscending
4OMWOTObject Management Object TypeAscending
9Object ID Type Rls Flags
ElementAliasDescriptionSequence
1OMWOBJIDObject Management Object NameAscending
2OMWOTObject Management Object TypeAscending
3SRCRLSSource Release NumberAscending
4OMWPOS1OMW Project Object FlagsAscending
10Project ID Token Stp Obj Fgs
ElementAliasDescriptionSequence
1OMWPRJIDObject Management Project NameAscending
2OMWPON1Object Token Queue Time StampAscending
3OMWPOS1OMW Project Object FlagsAscending
11ObjID Type Rls Token Stamp
ElementAliasDescriptionSequence
1OMWOBJIDObject Management Object NameAscending
2OMWOTObject Management Object TypeAscending
3SRCRLSSource Release NumberAscending
4OMWPON1Object Token Queue Time StampAscending
12ObjID Type Rls Checkout Flg
ElementAliasDescriptionSequence
1OMWOBJIDObject Management Object NameAscending
2OMWOTObject Management Object TypeAscending
3SRCRLSSource Release NumberAscending
4OMWCHSOMW Checkout StatusAscending
13ObjID Type Rls Inherit Prj
ElementAliasDescriptionSequence
1OMWOBJIDObject Management Object NameAscending
2OMWOTObject Management Object TypeAscending
3SRCRLSSource Release NumberAscending
4OMWPOS2Token Inheritance Parent ProjectAscending
14ObjID Type Rls Project (Unique)
ElementAliasDescriptionSequence
1OMWOBJIDObject Management Object NameAscending
2OMWOTObject Management Object TypeAscending
3SRCRLSSource Release NumberAscending
4OMWPRJIDObject Management Project NameAscending
15ObjType Rls
ElementAliasDescriptionSequence
1OMWPRJIDObject Management Project NameAscending
2SRCRLSSource Release NumberAscending
3OMWOTObject Management Object TypeAscending
16PRJID OBJID REL TYPE POS2
ElementAliasDescriptionSequence
1OMWPRJIDObject Management Project NameAscending
2OMWOBJIDObject Management Object NameAscending
3SRCRLSSource Release NumberAscending
4OMWOTObject Management Object TypeAscending
5OMWPOS2Token Inheritance Parent ProjectAscending
17POS2
ElementAliasDescriptionSequence
1OMWPOS2Token Inheritance Parent ProjectAscending