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

82 COLUMNS | 14 INDEXES | Print definition?812 | 09 | F0901 TABLE

09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0901GM8214Account MasterMaster Files09: General AccountingAS400 Coexistence 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 GMCO, GMAID, GMMCU, GMOBJ, GMSUB, GMANS, GMDL01, GMLDA, GMBPC, GMPEC, GMBILL, GMCRCD, GMUM, GMR001, GMR002, GMR003, GMR004, GMR005, GMR006, GMR007, GMR008, GMR009, GMR010, GMR011, GMR012, GMR013, GMR014, GMR015, GMR016, GMR017, GMR018, GMR019, GMR020, GMR021, GMR022, GMR023, GMOBJA, GMSUBA, GMWCMP, GMCCT, GMERC, GMHTC, GMQLDA, GMCCC, GMFMOD, GMUSER, GMPID, GMJOBN, GMUPMJ, GMUPMT, GMCEC1, GMCEC2, GMCEC3, GMCEC4, GMIEC, GMFPEC, GMSTPC, GMTXGL, GMTOBJ, GMTSUB, GMPRGF, GMTXA1, GMR024, GMR025, GMR026, GMR027, GMR028, GMR029, GMR030, GMR031, GMR032, GMR033, GMR034, GMR035, GMR036, GMR037, GMR038, GMR039, GMR040, GMR041, GMR042, GMR043 FROM F0901

TOP812 | 09 | F0901 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1GMCOCompanyStringGeneric Edit50 Allow NULL? 
2GMAIDAccount IDStringGeneric Edit80 Allow NULL? 
3GMMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
4GMOBJObject AccountStringGeneric Edit60 Allow NULL? 
5GMSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
6GMANSAccount Number - 3rdStringGeneric Edit250 Allow NULL? 
7GMDL01DescriptionStringGeneric Edit300 Allow NULL? 
8GMLDAAccount Level of DetailCharacterGeneric Edit10 Allow NULL? 
9GMBPCBudget Pattern CodeStringGeneric Edit30 Allow NULL? 
10GMPECPosting EditCharacterUDC (H00 PE)10 Allow NULL? 
11GMBILLBillable (Y/N)CharacterUDC (H00 BI)10 Allow NULL? 
12GMCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
13GMUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
14GMR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
15GMR002Category Code - G/L2StringUDC (09 02)30 Allow NULL? 
16GMR003Category Code - G/L3StringUDC (09 03)30 Allow NULL? 
17GMR004Category Code - G/L4StringUDC (09 04)30 Allow NULL? 
18GMR005Category Code - G/L5StringUDC (09 05)30 Allow NULL? 
19GMR006Category Code - G/L6StringUDC (09 06)30 Allow NULL? 
20GMR007Category Code - G/L7StringUDC (09 07)30 Allow NULL? 
21GMR008Category Code - G/L8StringUDC (09 08)30 Allow NULL? 
22GMR009Category Code - G/L9StringUDC (09 09)30 Allow NULL? 
23GMR010Category Code - G/L10StringUDC (09 10)30 Allow NULL? 
24GMR011Category Code - G/L11StringUDC (09 11)30 Allow NULL? 
25GMR012Category Code - G/L12StringUDC (09 12)30 Allow NULL? 
26GMR013Category Code - G/L13StringUDC (09 13)30 Allow NULL? 
27GMR014Category Code - G/L14StringUDC (09 14)30 Allow NULL? 
28GMR015Category Code - G/L15StringUDC (09 15)30 Allow NULL? 
29GMR016Category Code - G/L16StringUDC (09 16)30 Allow NULL? 
30GMR017Category Code - G/L17StringUDC (09 17)30 Allow NULL? 
31GMR018Category Code - G/L18StringUDC (09 18)30 Allow NULL? 
32GMR019Category Code - G/L19StringUDC (09 19)30 Allow NULL? 
33GMR020Category Code - G/L20StringUDC (09 20)30 Allow NULL? 
34GMR021Category Code - G/L 021StringUDC (09 21)100 Allow NULL? 
35GMR022Category Code - G/L 022StringUDC (09 22)100 Allow NULL? 
36GMR023Category Code - G/L 023StringUDC (09 23)100 Allow NULL? 
37GMOBJAObject Account - AlternateStringGeneric Edit60 Allow NULL? 
38GMSUBASubsidiary - AlternateStringGeneric Edit80 Allow NULL? 
39GMWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
40GMCCTMethod of ComputationCharacterUDC (51 MC)10 Allow NULL? 
41GMERCEquipment Rate CodeStringUDC (00 RC)20 Allow NULL? 
42GMHTCHeader Type CodeCharacterUDC (H00 HT)10 Allow NULL? 
43GMQLDAQuantity Roll-Up LevelCharacterGeneric Edit10 Allow NULL? 
44GMCCCCost Code Complete (Y/N)CharacterGeneric Edit10 Allow NULL? 
45GMFMODModel Accounts and Consolidation FlagCharacterUDC (H09 MD)10 Allow NULL? 
46GMUSERUser IDStringGeneric Edit100 Allow NULL? 
47GMPIDProgram IDStringGeneric Edit100 Allow NULL? 
48GMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
49GMUPMJDate - UpdatedDateGeneric Edit60
50GMUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
51GMCEC1Cost Object Edit Code 01CharacterGeneric Edit10 Allow NULL? 
52GMCEC2Cost Object Edit Code 02CharacterGeneric Edit10 Allow NULL? 
53GMCEC3Cost Object Edit Code 03CharacterGeneric Edit10 Allow NULL? 
54GMCEC4Cost Object Edit Code 04CharacterGeneric Edit10 Allow NULL? 
55GMIECItem Edit CodeCharacterGeneric Edit10 Allow NULL? 
56GMFPECFixed Asset Posting Edit CodeCharacterGeneric Edit10 Allow NULL? 
57GMSTPCType CodeCharacterGeneric Edit10 Allow NULL? 
58GMTXGLGL Account Taxable Flag . . . . . . . .CharacterGeneric Edit10 Allow NULL? 
59GMTOBJTarget Object AccountStringGeneric Edit60 Allow NULL? 
60GMTSUBTarget SubsidiaryStringGeneric Edit80 Allow NULL? 
61GMPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
62GMTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
63GMR024Category Code - G/L 024StringUDC (09 24)100 Allow NULL? 
64GMR025Category Code - G/L 025StringUDC (09 25)100 Allow NULL? 
65GMR026Category Code - G/L 026StringUDC (09 26)100 Allow NULL? 
66GMR027Category Code - G/L 027StringUDC (09 27)100 Allow NULL? 
67GMR028Category Code - G/L 028StringUDC (09 28)100 Allow NULL? 
68GMR029Category Code - G/L 029StringUDC (09 29)100 Allow NULL? 
69GMR030Category Code - G/L 030StringUDC (09 30)100 Allow NULL? 
70GMR031Category Code - G/L 031StringUDC (09 31)100 Allow NULL? 
71GMR032Category Code - G/L 032StringUDC (09 32)100 Allow NULL? 
72GMR033Category Code - G/L 033StringUDC (09 33)100 Allow NULL? 
73GMR034Category Code - G/L 034StringUDC (09 34)100 Allow NULL? 
74GMR035Category Code - G/L 035StringUDC (09 35)100 Allow NULL? 
75GMR036Category Code - G/L 036StringUDC (09 36)100 Allow NULL? 
76GMR037Category Code - G/L 037StringUDC (09 37)100 Allow NULL? 
77GMR038Category Code - G/L 038StringUDC (09 38)100 Allow NULL? 
78GMR039Category Code - G/L 039StringUDC (09 39)100 Allow NULL? 
79GMR040Category Code - G/L 040StringUDC (09 40)100 Allow NULL? 
80GMR041Category Code - G/L 041StringUDC (09 41)100 Allow NULL? 
81GMR042Category Code - G/L 042StringUDC (09 42)100 Allow NULL? 
82GMR043Category Code - G/L 043StringUDC (09 43)100 Allow NULL? 

TOP812 | 09 | F0901 INDEXES

NumberDescription
2Business Unit Object + (Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2OBJObject AccountAscending
3SUBSubsidiaryAscending
3Account Id (Primary/Unique)
ElementAliasDescriptionSequence
1AIDAccount IDAscending
4Account Number 3rd
ElementAliasDescriptionSequence
1ANSAccount Number - 3rdAscending
5Company Object +
ElementAliasDescriptionSequence
1COCompanyAscending
2OBJObject AccountAscending
3SUBSubsidiaryAscending
4MCUBusiness UnitAscending
6Company Business Unit +
ElementAliasDescriptionSequence
1COCompanyAscending
2MCUBusiness UnitAscending
3OBJObject AccountAscending
4SUBSubsidiaryAscending
7Object Subsidiary + (Unique)
ElementAliasDescriptionSequence
1OBJObject AccountAscending
2SUBSubsidiaryAscending
3MCUBusiness UnitAscending
8Subsidiary Object +
ElementAliasDescriptionSequence
1SUBSubsidiaryAscending
2OBJObject AccountAscending
3COCompanyAscending
9Subsidiary Company +
ElementAliasDescriptionSequence
1SUBSubsidiaryAscending
2COCompanyAscending
3OBJObject AccountAscending
10Business Unit Sub Object (Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2SUBSubsidiaryAscending
3OBJObject AccountAscending
11Code 1 Sub +
ElementAliasDescriptionSequence
1R001Category Code - G/L1Ascending
2SUBSubsidiaryAscending
3OBJObject AccountAscending
4MCUBusiness UnitAscending
12Code 2 Sub +
ElementAliasDescriptionSequence
1R002Category Code - G/L2Ascending
2SUBSubsidiaryAscending
3OBJObject AccountAscending
4MCUBusiness UnitAscending
13Code 3 Sub +
ElementAliasDescriptionSequence
1R003Category Code - G/L3Ascending
2SUBSubsidiaryAscending
3OBJObject AccountAscending
4MCUBusiness UnitAscending
14Code A Sub +
ElementAliasDescriptionSequence
1SUBASubsidiary - AlternateAscending
2SUBSubsidiaryAscending
3OBJObject AccountAscending
4MCUBusiness UnitAscending
15Code C Obj +
ElementAliasDescriptionSequence
1SUBSubsidiaryAscending
2OBJObject AccountAscending
3MCUBusiness UnitAscending