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
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

90 COLUMNS | 1 INDEXES | Print definition?812 | H95 | F00167 TABLE

H95: Tech Resources/Applications
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F00167GT901Media Object Category ConstantMaster FilesH95: Tech Resources/ApplicationsSystem 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 GTOBNM, GTMODOCTPC, GTMODL01CON, GTMOAUTHORC, GTMOCDT, GTMOSTATUSC, GTMOEFDTFRC, GTMOEFDTTOC, GTMOREVDTC, GTMOCPYLINKC, GTMOLNGPCON, GTMOMCU, GTMOCO, GTMOAN8, GTMOSHAN, GTMOAN8V, GTMOEMPLC, GTMODOCO, GTMODCTO, GTMOITM, GTMOLITM, GTMOAITM, GTMOCALLNUMC, GTMOOPPNUMC, GTMOCAMPNUMC, GTMOCOMPETC, GTMOVEHN, GTMOAID, GTMONUMB, GTMODRAW, GTMOCONST1, GTMOCONST2, GTMOCONST3, GTMOCONST4, GTMOCONST5, GTMOCONST6, GTMOCONST7, GTMOCONST8, GTMOCONST9, GTMOCONST10, GTMOCONST11, GTMOCONST12, GTMOCONST13, GTMOCONST14, GTMOCONST15, GTMOCONST16, GTMOCONST17, GTMOCONST18, GTMOCONST19, GTMOCONST20, GTMOCONST21, GTMOCONST22, GTMOCONST23, GTMOCONST24, GTMOCONST25, GTMOCONST26, GTMOCONST27, GTMOCONST28, GTMOCONST29, GTMOCONST30, GTMODTCON1, GTMODTCON2, GTMODTCON3, GTMODTCON4, GTMODTCON5, GTMOMNCON1, GTMOMNCON2, GTMOMNCON3, GTMOMNCON4, GTMOMNCON5, GTMOFALPH6, GTMOFALPH7, GTMOFALPH8, GTMOFALPH9, GTMOFALPH10, GTPID, GTJOBN, GTUSER, GTUPMJ, GTUPMT, GTMOSRKFLG, GTMOFCHAR1, GTMOFCHAR2, GTMOFCHAR3, GTMOFCHAR4, GTMOACTFLG, GTMOFCHAR5, GTMOFCHAR6, GTMOFCHAR7, GTMOFCHAR8 FROM F00167

TOP812 | H95 | F00167 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1GTOBNMObject NameStringGeneric Edit100 Allow NULL? 
2GTMODOCTPCMedia Object Document Type ConstantCharacterGeneric Edit10 Allow NULL? 
3GTMODL01CONMedia Object Description ConstantCharacterGeneric Edit10 Allow NULL? 
4GTMOAUTHORCMedia Object Document Author ConstantCharacterGeneric Edit10 Allow NULL? 
5GTMOCDTMedia Object Created Date ConstantCharacterGeneric Edit10 Allow NULL? 
6GTMOSTATUSCMedia Object Status ConstantCharacterGeneric Edit10 Allow NULL? 
7GTMOEFDTFRCMedia Object Effective Date - FromCharacterGeneric Edit10 Allow NULL? 
8GTMOEFDTTOCMedia Object Effective Date - To ConstCharacterGeneric Edit10 Allow NULL? 
9GTMOREVDTCMedia Object Review Date ConstantCharacterGeneric Edit10 Allow NULL? 
10GTMOCPYLINKCMedia Object Copy/Link Flag ConstantCharacterGeneric Edit10 Allow NULL? 
11GTMOLNGPCONMedia Object Language ConstantCharacterGeneric Edit10 Allow NULL? 
12GTMOMCUMedia Object MCU ConstantCharacterGeneric Edit10 Allow NULL? 
13GTMOCOMedia Object Company ConstantCharacterGeneric Edit10 Allow NULL? 
14GTMOAN8Media Object Customer ConstantCharacterGeneric Edit10 Allow NULL? 
15GTMOSHANMedia Object Ship To ConstantCharacterGeneric Edit10 Allow NULL? 
16GTMOAN8VMedia Object Supplier ConstantCharacterGeneric Edit10 Allow NULL? 
17GTMOEMPLCMedia Object Employee ConstantCharacterGeneric Edit10 Allow NULL? 
18GTMODOCOMedia Object Document Number ConstantCharacterGeneric Edit10 Allow NULL? 
19GTMODCTOMedia Object Document Type ConstantCharacterGeneric Edit10 Allow NULL? 
20GTMOITMMedia Object Item Number ConstantCharacterGeneric Edit10 Allow NULL? 
21GTMOLITMMedia Object Long Item Number ConstantCharacterGeneric Edit10 Allow NULL? 
22GTMOAITMMedia Object 3rd Item Number ConstantCharacterGeneric Edit10 Allow NULL? 
23GTMOCALLNUMCMedia Object Call Number ConstantCharacterGeneric Edit10 Allow NULL? 
24GTMOOPPNUMCMedia Object Opportunity Number ConstantCharacterGeneric Edit10 Allow NULL? 
25GTMOCAMPNUMCMedia Object Campaign Number ConstantCharacterGeneric Edit10 Allow NULL? 
26GTMOCOMPETCMedia Object Competitor Number ConstantCharacterGeneric Edit10 Allow NULL? 
27GTMOVEHNMedia Object Vehicle Number ConstantCharacterGeneric Edit10 Allow NULL? 
28GTMOAIDMedia Object Account Number ConstantCharacterGeneric Edit10 Allow NULL? 
29GTMONUMBMedia Object Asset Number ConstantCharacterGeneric Edit10 Allow NULL? 
30GTMODRAWMedia Object Draw Number ConstantCharacterGeneric Edit10 Allow NULL? 
31GTMOCONST1Media Object Constant 1CharacterGeneric Edit10 Allow NULL? 
32GTMOCONST2Media Object Constant 2CharacterGeneric Edit10 Allow NULL? 
33GTMOCONST3Media Object Constant 3CharacterGeneric Edit10 Allow NULL? 
34GTMOCONST4Media Object Constant 4CharacterGeneric Edit10 Allow NULL? 
35GTMOCONST5Media Object Constant 5CharacterGeneric Edit10 Allow NULL? 
36GTMOCONST6Media Object Constant 6CharacterGeneric Edit10 Allow NULL? 
37GTMOCONST7Media Object Constant 7CharacterGeneric Edit10 Allow NULL? 
38GTMOCONST8Media Object Constant 8CharacterGeneric Edit10 Allow NULL? 
39GTMOCONST9Media Object Constant 9CharacterGeneric Edit10 Allow NULL? 
40GTMOCONST10Media Object Constant 10CharacterGeneric Edit10 Allow NULL? 
41GTMOCONST11Media Object Constant 11CharacterGeneric Edit10 Allow NULL? 
42GTMOCONST12Media Object Constant 12CharacterGeneric Edit10 Allow NULL? 
43GTMOCONST13Media Object Constant 13CharacterGeneric Edit10 Allow NULL? 
44GTMOCONST14Media Object Constant 14CharacterGeneric Edit10 Allow NULL? 
45GTMOCONST15Media Object Constant 15CharacterGeneric Edit10 Allow NULL? 
46GTMOCONST16Media Object Constant 16CharacterGeneric Edit10 Allow NULL? 
47GTMOCONST17Media Object Constant 17CharacterGeneric Edit10 Allow NULL? 
48GTMOCONST18Media Object Constant 18CharacterGeneric Edit10 Allow NULL? 
49GTMOCONST19Media Object Constant 19CharacterGeneric Edit10 Allow NULL? 
50GTMOCONST20Media Object Constant 20CharacterGeneric Edit10 Allow NULL? 
51GTMOCONST21Media Object Constant 21CharacterGeneric Edit10 Allow NULL? 
52GTMOCONST22Media Object Constant 22CharacterGeneric Edit10 Allow NULL? 
53GTMOCONST23Media Object Constant 23CharacterGeneric Edit10 Allow NULL? 
54GTMOCONST24Media Object Constant 24CharacterGeneric Edit10 Allow NULL? 
55GTMOCONST25Media Object Constant 25CharacterGeneric Edit10 Allow NULL? 
56GTMOCONST26Media Object Constant 26CharacterGeneric Edit10 Allow NULL? 
57GTMOCONST27Media Object Constant 27CharacterGeneric Edit10 Allow NULL? 
58GTMOCONST28Media Object Constant 28CharacterGeneric Edit10 Allow NULL? 
59GTMOCONST29Media Object Constant 29CharacterGeneric Edit10 Allow NULL? 
60GTMOCONST30Media Object Constant 30CharacterGeneric Edit10 Allow NULL? 
61GTMODTCON1Media Object Date Constant 1CharacterGeneric Edit10 Allow NULL? 
62GTMODTCON2Media Object Date Constant 2CharacterGeneric Edit10 Allow NULL? 
63GTMODTCON3Media Object Date Constant 3CharacterGeneric Edit10 Allow NULL? 
64GTMODTCON4Media Object Date Constant 4CharacterGeneric Edit10 Allow NULL? 
65GTMODTCON5Media Object Date Constant 5CharacterGeneric Edit10 Allow NULL? 
66GTMOMNCON1Media Object Math Numeric Constant 1CharacterGeneric Edit10 Allow NULL? 
67GTMOMNCON2Media Object Math Numeric Constant 2CharacterGeneric Edit10 Allow NULL? 
68GTMOMNCON3Media Object Math Numeric Constant 3CharacterGeneric Edit10 Allow NULL? 
69GTMOMNCON4Media Object Math Numeric Constant 4CharacterGeneric Edit10 Allow NULL? 
70GTMOMNCON5Media Object Math Numeric Constant 5CharacterGeneric Edit10 Allow NULL? 
71GTMOFALPH6Media Object Future Use 6CharacterGeneric Edit100 Allow NULL? 
72GTMOFALPH7Media Object Future Use 7StringGeneric Edit100 Allow NULL? 
73GTMOFALPH8Media Object Future Use 8StringGeneric Edit100 Allow NULL? 
74GTMOFALPH9Media Object Future Use 9StringGeneric Edit300 Allow NULL? 
75GTMOFALPH10Media Object Future Use 10StringGeneric Edit300 Allow NULL? 
76GTPIDProgram IDStringGeneric Edit100 Allow NULL? 
77GTJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
78GTUSERUser IDStringGeneric Edit100 Allow NULL? 
79GTUPMJDate - UpdatedDateGeneric Edit60
80GTUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
81GTMOSRKFLGMedia Object SERK FlagCharacterGeneric Edit10 Allow NULL? 
82GTMOFCHAR1Media Object Future Use Char 1CharacterGeneric Edit10 Allow NULL? 
83GTMOFCHAR2Media Object Future Use Char 2CharacterGeneric Edit10 Allow NULL? 
84GTMOFCHAR3Media Object Future Use Char 3CharacterGeneric Edit10 Allow NULL? 
85GTMOFCHAR4Media Object Future Use Char 4CharacterGeneric Edit10 Allow NULL? 
86GTMOACTFLGMedia Object Activity FlagCharacterGeneric Edit10 Allow NULL? 
87GTMOFCHAR5Media Object Future Use Char 5CharacterGeneric Edit10 Allow NULL? 
88GTMOFCHAR6Media Object Future Use Char 6CharacterGeneric Edit10 Allow NULL? 
89GTMOFCHAR7Media Object Future Use Char 7CharacterGeneric Edit10 Allow NULL? 
90GTMOFCHAR8Media Object Future Use Char 8CharacterGeneric Edit10 Allow NULL? 

TOP812 | H95 | F00167 INDEXES

NumberDescription
1Object Name (Primary/Unique)
ElementAliasDescriptionSequence
1OBNMObject NameAscending