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
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

84 COLUMNS | 15 INDEXES | Print definition?920 | 09 | F0901 TABLE

09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0901GM8415Account MasterMaster Files09: General AccountingBusiness 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 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, GMADJENT, GMUAFL FROM F0901

TOP920 | 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? 
83GMADJENTAdjustment EntryCharacterGeneric Edit10 Allow NULL? 
84GMUAFLFAR UnAllowable FlagCharacterGeneric Edit10 Allow NULL? 

TOP920 | 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
16Description
ElementAliasDescriptionSequence
1DL01DescriptionAscending