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

56 COLUMNS | 16 INDEXES | Print definition?920 | 79A | F79A11 TABLE

79A: Greenhouse Gas Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F79A11GR5616GHG LedgerFiles79A: Greenhouse Gas Accounting
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 GRUKID, GRKCO, GRDCT, GRDOC, GRSFX, GRSFXE, GRLNID, GRAN8, GRMMCU, GRITM, GRLITM, GRAITM, GRTRQT, GRUOM1, GRTREX, GRTRDJ, GR79ADGHG, GRCTRY, GRFY, GRPN, GR79AGESID, GR79ASRC, GR79AEMSC, GR79AGCUM, GR79AEUQTY, GR79AEGJ, GR79ACO2Q, GRRE, GR79AGRCD, GR79AGS01, GR79AGS02, GRCOUN, GRADDS, GRCTR, GRNUMB, GRASII, GR79AGELT, GRURCD, GRURRF, GRURAB, GRURAT, GRURDT, GRPID, GRUSER, GRJOBN, GRUPMJ, GRTDAY, GR79AVN01, GRCRCD, GRCRR, GRBCRC, GR79ABV01, GR79AGCRIT, GRMCU, GR79AGBNO, GR79AGCM FROM F79A11

TOP920 | 79A | F79A11 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1GRUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
2GRKCODocument CompanyStringGeneric Edit50 Allow NULL? 
3GRDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
4GRDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
5GRSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
6GRSFXEPay Item Extension NumberNumericGeneric Edit20 Allow NULL? 
7GRLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
8GRAN8Address NumberNumericGeneric Edit80 Allow NULL? 
9GRMMCUBranchStringGeneric Edit120 Allow NULL? 
10GRITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
11GRLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
12GRAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
13GRTRQTQuantity AvailableNumericGeneric Edit150 Allow NULL? 
14GRUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
15GRTREXExplanation - TransactionStringGeneric Edit300 Allow NULL? 
16GRTRDJDate - Order/TransactionDateGeneric Edit60
17GR79ADGHGDateDateGeneric Edit60
18GRCTRYCenturyNumericGeneric Edit20 Allow NULL? 
19GRFYFiscal YearNumericGeneric Edit20 Allow NULL? 
20GRPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
21GR79AGESIDSource IdNumericGeneric Edit150 Allow NULL? 
22GR79ASRCSourceStringGeneric Edit250 Allow NULL? 
23GR79AEMSCEmission ScopeStringUDC (79A SC)100 Allow NULL? 
24GR79AGCUMCO2-e Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
25GR79AEUQTYUsage QuantityNumericGeneric Edit248 Allow NULL? 
26GR79AEGJEnergy in GJNumericGeneric Edit248 Allow NULL? 
27GR79ACO2QEmission CO2 QuantityNumericGeneric Edit248 Allow NULL? 
28GRREReverse or Void (R/V)CharacterUDC (H09 RE)10 Allow NULL? 
29GR79AGRCDReason CodeStringUDC (79A GR)30 Allow NULL? 
30GR79AGS01Source TypeStringUDC (79A GF)20 Allow NULL? 
31GR79AGS02Actual / EstimateStringUDC (79A G2)20 Allow NULL? 
32GRCOUNCountyStringUDC (00 CT)250 Allow NULL? 
33GRADDSStateStringUDC (00 S)30 Allow NULL? 
34GRCTRCountryStringUDC (00 CN)30 Allow NULL? 
35GRNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
36GRASIIAsset Number-InputStringGeneric Edit260 Allow NULL? 
37GR79AGELTEmission Ledger TypeStringUDC (79A GL)20 Allow NULL? 
38GRURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
39GRURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
40GRURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
41GRURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
42GRURDTUser Reserved DateDateGeneric Edit60
43GRPIDProgram IDStringGeneric Edit100 Allow NULL? 
44GRUSERUser IDStringGeneric Edit100 Allow NULL? 
45GRJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
46GRUPMJDate - UpdatedDateGeneric Edit60
47GRTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
48GR79AVN01Value 01NumericGeneric Edit152 Allow NULL? 
49GRCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
50GRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
51GRBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
52GR79ABV01Base Value 01NumericGeneric Edit152 Allow NULL? 
53GR79AGCRITMeasurement CriterionStringUDC (79A GC)100 Allow NULL? 
54GRMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
55GR79AGBNOBatch NumberNumericGeneric Edit80 Allow NULL? 
56GR79AGCMCalculation MethodStringUDC (79A GM)20 Allow NULL? 

TOP920 | 79A | F79A11 INDEXES

NumberDescription
179A UKID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
279A KCO DCT DOC SFX
ElementAliasDescriptionSequence
1KCODocument CompanyAscending
2DCTDocument TypeAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4SFXDocument Pay ItemAscending
5SFXEPay Item Extension NumberAscending
6LNIDLine NumberAscending
779ADGHGDateAscending
379A CTR ADDS COUN
ElementAliasDescriptionSequence
1CTRCountryAscending
2ADDSStateAscending
3COUNCountyAscending
479A ASII
ElementAliasDescriptionSequence
1ASIIAsset Number-InputAscending
579A MMCU 79ADGHG
ElementAliasDescriptionSequence
1MMCUBranchAscending
279ADGHGDateAscending
3REReverse or Void (R/V)Ascending
679A 79AGESID
ElementAliasDescriptionSequence
179AGESIDSource IdAscending
279AEMSCEmission ScopeAscending
379ADGHGDateAscending
4REReverse or Void (R/V)Ascending
779A 79ASRC 79AEMSC
ElementAliasDescriptionSequence
179ASRCSourceAscending
279AEMSCEmission ScopeAscending
379ADGHGDateAscending
879A MCU 79ADGHG
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
279ADGHGDateAscending
979A 79AGBNO
ElementAliasDescriptionSequence
179AGBNOBatch NumberAscending
1079A 79AGESID
ElementAliasDescriptionSequence
179AGESIDSource IdAscending
279AGCUMCO2-e Unit of MeasureAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
1179A MMCU ITM
ElementAliasDescriptionSequence
1MMCUBranchAscending
2ITMItem Number - ShortAscending
379AGESIDSource IdAscending
479AGCUMCO2-e Unit of MeasureAscending
1279A KCO DCT DOC
ElementAliasDescriptionSequence
1KCODocument CompanyAscending
2DOCDocument (Voucher Invoice etc.)Ascending
3DCTDocument TypeAscending
4SFXDocument Pay ItemAscending
5LNIDLine NumberAscending
1379A AN8 79ADGHG 79AGESID
ElementAliasDescriptionSequence
1AN8Address NumberAscending
279ADGHGDateAscending
379AGESIDSource IdAscending
479AEMSCEmission ScopeAscending
5REReverse or Void (R/V)Ascending
1479A MMCU 79ADGHG 79AGESID
ElementAliasDescriptionSequence
1MMCUBranchAscending
279ADGHGDateAscending
379AGESIDSource IdAscending
479AEMSCEmission ScopeAscending
5REReverse or Void (R/V)Ascending
1579A AN8 MMCU 79ADGHG
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2MMCUBranchAscending
379ADGHGDateAscending
479AGESIDSource IdAscending
579AEMSCEmission ScopeAscending
6REReverse or Void (R/V)Ascending
1679A 79AGESID RE
ElementAliasDescriptionSequence
179AGESIDSource IdAscending
2REReverse or Void (R/V)Ascending