JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

92 COLUMNS | 1 INDEXES | Print definition?920 | H95 | F00166 TABLE

H95: Object and Environment Tech
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F00166GT921Media Object CategoriesMaster FilesH95: Object and Environment TechBusiness Data
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 GTOBNM, GTTXKY, GTMOSEQN, GTMODOCTP, GTMODL01, GTMOAUTHOR, GTCDT, GTMOSTATUS, GTMOEFDTFR, GTMOEFDTTO, GTMOREVDT, GTMOCPYLINK, GTMOLNGP, GTMCU, GTCO, GTAN8, GTSHAN, GTAN8V, GTMOEMPL, GTDOCO, GTDCTO, GTITM, GTLITM, GTAITM, GTMOCALLNUM, GTMOOPPNUM, GTMOCAMPNUM, GTMOCOMPET, GTVEHN, GTAID, GTNUMB, GTDRAW, GTMOCATCD1, GTMOCATCD2, GTMOCATCD3, GTMOCATCD4, GTMOCATCD5, GTMOCATCD6, GTMOCATCD7, GTMOCATCD8, GTMOCATCD9, GTMOCATCD10, GTMOCATCD11, GTMOCATCD12, GTMOCATCD13, GTMOCATCD14, GTMOCATCD15, GTMOCATCD16, GTMOCATCD17, GTMOCATCD18, GTMOCATCD19, GTMOCATCD20, GTMOCATCD21, GTMOCATCD22, GTMOCATCD23, GTMOCATCD24, GTMOCATCD25, GTMOCATCD26, GTMOCATCD27, GTMOCATCD28, GTMOCATCD29, GTMOCATCD30, GTMODATE1, GTMODATE2, GTMODATE3, GTMODATE4, GTMODATE5, GTMOMATH01, GTMOMATH02, GTMOMATH03, GTMOMATH04, GTMOMATH05, GTMOFALPH1, GTMOFALPH2, GTMOFALPH3, GTMOFALPH4, GTMOFALPH5, GTPID, GTJOBN, GTUSER, GTUPMJ, GTUPMT, GTSERK, GTMOFMN1, GTMOFMN2, GTMOFMN3, GTMOFMN4, GTMOACTVID, GTMOFSTR1, GTMOFSTR2, GTMOFSTR3, GTMOFSTR4 FROM F00166

TOP920 | H95 | F00166 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1GTOBNMObject NameStringGeneric Edit100 Allow NULL? 
2GTTXKYGeneric Text KeyVariable StringGeneric Edit2540 Allow NULL? 
3GTMOSEQNMedia Object Sequence NumberIntegerGeneric Edit110 Allow NULL? 
4GTMODOCTPMedia Object Document TypeStringUDC (H98 MT)60 Allow NULL? 
5GTMODL01Media Object DescriptionStringGeneric Edit300 Allow NULL? 
6GTMOAUTHORMedia Object Document AuthorStringGeneric Edit400 Allow NULL? 
7GTCDTDate - CreationDateGeneric Edit60
8GTMOSTATUSMedia Object StatusStringUDC (H98 MS)60 Allow NULL? 
9GTMOEFDTFRMedia Object Effective Date - FromDateGeneric Edit60
10GTMOEFDTTOMedia Object Effective Date - ToDateGeneric Edit60
11GTMOREVDTMedia Object Review DateDateGeneric Edit60
12GTMOCPYLINKMedia Object Copy/Link FlagCharacterGeneric Edit10 Allow NULL? 
13GTMOLNGPMedia ObjectLanguageStringUDC (01 LP)20 Allow NULL? 
14GTMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
15GTCOCompanyStringGeneric Edit50 Allow NULL? 
16GTAN8Address NumberNumericGeneric Edit80 Allow NULL? 
17GTSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
18GTAN8VAddress Number - SupplierNumericGeneric Edit80 Allow NULL? 
19GTMOEMPLMedia Object Employee NumberNumericGeneric Edit80 Allow NULL? 
20GTDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
21GTDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
22GTITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
23GTLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
24GTAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
25GTMOCALLNUMMedia Object Call NumberNumericGeneric Edit80 Allow NULL? 
26GTMOOPPNUMMedia Object Opportunity NumberNumericGeneric Edit80 Allow NULL? 
27GTMOCAMPNUMMedia Object Campaign NumberNumericGeneric Edit80 Allow NULL? 
28GTMOCOMPETMedia Object Competitor NumberNumericGeneric Edit80 Allow NULL? 
29GTVEHNVehicle NumberNumericGeneric Edit80 Allow NULL? 
30GTAIDAccount IDStringGeneric Edit80 Allow NULL? 
31GTNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
32GTDRAWDrawing NumberStringGeneric Edit200 Allow NULL? 
33GTMOCATCD1Media Object Category Code 1StringGeneric Edit100 Allow NULL? 
34GTMOCATCD2Media Object Category Code 2StringGeneric Edit100 Allow NULL? 
35GTMOCATCD3Media Object Category Code 3StringGeneric Edit100 Allow NULL? 
36GTMOCATCD4Media Object Category Code 4StringGeneric Edit100 Allow NULL? 
37GTMOCATCD5Media Object Category Code 5StringGeneric Edit100 Allow NULL? 
38GTMOCATCD6Media Object Category Code 6StringGeneric Edit100 Allow NULL? 
39GTMOCATCD7Media Object Category Code 7StringGeneric Edit100 Allow NULL? 
40GTMOCATCD8Media Object Category Code 8StringGeneric Edit100 Allow NULL? 
41GTMOCATCD9Media Object Category Code 9StringGeneric Edit100 Allow NULL? 
42GTMOCATCD10Media Object Category Code 10StringGeneric Edit100 Allow NULL? 
43GTMOCATCD11Media Object Category Code 11StringGeneric Edit100 Allow NULL? 
44GTMOCATCD12Media Object Category Code 12StringGeneric Edit100 Allow NULL? 
45GTMOCATCD13Media Object Category Code 13StringGeneric Edit100 Allow NULL? 
46GTMOCATCD14Media Object Category Code 14StringGeneric Edit100 Allow NULL? 
47GTMOCATCD15Media Object Category Code 15StringGeneric Edit100 Allow NULL? 
48GTMOCATCD16Media Object Category Code 16StringGeneric Edit100 Allow NULL? 
49GTMOCATCD17Media Object Category Code 17StringGeneric Edit100 Allow NULL? 
50GTMOCATCD18Media Object Category Code 18StringGeneric Edit100 Allow NULL? 
51GTMOCATCD19Media Object Category Code 19StringGeneric Edit100 Allow NULL? 
52GTMOCATCD20Media Object Category Code 20StringGeneric Edit100 Allow NULL? 
53GTMOCATCD21Media Object Category Code 21StringGeneric Edit100 Allow NULL? 
54GTMOCATCD22Media Object Category Code 22StringGeneric Edit100 Allow NULL? 
55GTMOCATCD23Media Object Category Code 23StringGeneric Edit100 Allow NULL? 
56GTMOCATCD24Media Object Category Code 24StringGeneric Edit100 Allow NULL? 
57GTMOCATCD25Media Object Category Code 25StringGeneric Edit100 Allow NULL? 
58GTMOCATCD26Media Object Category Code 26StringGeneric Edit100 Allow NULL? 
59GTMOCATCD27Media Object Category Code 27StringGeneric Edit100 Allow NULL? 
60GTMOCATCD28Media Object Category Code 28StringGeneric Edit100 Allow NULL? 
61GTMOCATCD29Media Object Category Code 29StringGeneric Edit100 Allow NULL? 
62GTMOCATCD30Media Object Category Code 30StringGeneric Edit100 Allow NULL? 
63GTMODATE1Media Object Date 1DateGeneric Edit60
64GTMODATE2Media Object Date 2DateGeneric Edit60
65GTMODATE3Media Object Date 3DateGeneric Edit60
66GTMODATE4Media Object Date 4DateGeneric Edit60
67GTMODATE5Media Object Date 5DateGeneric Edit60
68GTMOMATH01Media Object Math 01NumericGeneric Edit150 Allow NULL? 
69GTMOMATH02Media Object Math 02NumericGeneric Edit150 Allow NULL? 
70GTMOMATH03Media Object Math 03NumericGeneric Edit150 Allow NULL? 
71GTMOMATH04Media Object Math 04NumericGeneric Edit150 Allow NULL? 
72GTMOMATH05Media Object Math 05NumericGeneric Edit150 Allow NULL? 
73GTMOFALPH1Media Object Future Alpha 1StringGeneric Edit100 Allow NULL? 
74GTMOFALPH2Media Object Future Alpha 2StringGeneric Edit100 Allow NULL? 
75GTMOFALPH3Media Object Future Alpha 2StringGeneric Edit100 Allow NULL? 
76GTMOFALPH4Media Object Future Alpha 4StringGeneric Edit300 Allow NULL? 
77GTMOFALPH5Media Object Future Alpha 5StringGeneric Edit300 Allow NULL? 
78GTPIDProgram IDStringGeneric Edit100 Allow NULL? 
79GTJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
80GTUSERUser IDStringGeneric Edit100 Allow NULL? 
81GTUPMJDate - UpdatedDateGeneric Edit60
82GTUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
83GTSERKKey Value Serial NumberNumericGeneric Edit150 Allow NULL? 
84GTMOFMN1Media Object Future Math Numeric 1NumericGeneric Edit150 Allow NULL? 
85GTMOFMN2Media Object Future Math Numeric 2NumericGeneric Edit150 Allow NULL? 
86GTMOFMN3Media Object Future Math Numeric 3NumericGeneric Edit150 Allow NULL? 
87GTMOFMN4Media Object Future Math Numeric 4NumericGeneric Edit150 Allow NULL? 
88GTMOACTVIDMedia Object Activity IDStringGeneric Edit370 Allow NULL? 
89GTMOFSTR1Media Object Future Use String 1StringGeneric Edit370 Allow NULL? 
90GTMOFSTR2Media Object Future Use String 2StringGeneric Edit370 Allow NULL? 
91GTMOFSTR3Media Object Future Use String 3StringGeneric Edit370 Allow NULL? 
92GTMOFSTR4Media Object Future Use String 4StringGeneric Edit370 Allow NULL? 

TOP920 | H95 | F00166 INDEXES

NumberDescription
1GTName GTKey Lang Seq (Primary/Unique)
ElementAliasDescriptionSequence
1OBNMObject NameAscending
2TXKYGeneric Text KeyAscending
3MOSEQNMedia Object Sequence NumberAscending