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

63 COLUMNS | 1 INDEXES | Print definition?920 | 43Q | F43Q10 TABLE

43Q: Strategic Sourcing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F43Q10EH631Event HeaderFiles43Q: Strategic SourcingBusiness 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 EHEVNU, EHDCTO, EHKCOO, EHMCU, EHEVFT, EHEVTN, EHEVST, EHEPSX, EHEVSX, EHEHW, EHEPM, EHEETM, EHPTC, EHABV, EHHSLS, EHFHSL, EHCRDC, EHTX, EHTAX, EHOMCU, EHALKY, EHEDITXTS, EHOEDT, EHSEVT, EHBROAL, EHMBDA, EHORBY, EHALPH, EHPH3, EHEMAL, EHMCEV, EHDBQW, EHDSPB, EHEDITRESP, EHDISABDS, EHSHOWDTLS, EHDISPBID, EHDISPTOTL, EHDISPQUES, EHCCUKID, EHRLQR, EHSIOB, EHDISBDHP, EHSCREVENT, EHBMBSP, EHCBORPO, EHINMG, EHURCD, EHURDT, EHURAT, EHURAB, EHURRF, EHTORG, EHUSER, EHPID, EHJOBN, EHUPMJ, EHTDAY, EHCMDCDE, EHEVDS, EHAR1, EHSHAN, EHTQW FROM F43Q10

TOP920 | 43Q | F43Q10 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1EHEVNUEvent NumberNumericGeneric Edit80 Allow NULL? 
2EHDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3EHKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4EHMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5EHEVFTEvent FormatStringUDC (43Q EF)30 Allow NULL? 
6EHEVTNEvent NameStringGeneric Edit250 Allow NULL? 
7EHEVSTEvent StatusStringUDC (43Q ES)20 Allow NULL? 
8EHEPSXEvent Preview Start TimeJDE UTimeGeneric Edit110
9EHEVSXEvent Start TimeJDE UTimeGeneric Edit110
10EHEHWHeader WeightingNumericGeneric Edit74 Allow NULL? 
11EHEPMEvent Payment MethodStringUDC (43Q PM)20 Allow NULL? 
12EHEETMEvent End TimeJDE UTimeGeneric Edit110
13EHPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
14EHABVAllow Bidder To View AttachmentCharacterGeneric Edit10 Allow NULL? 
15EHHSLSHeader Score into Line ScoreNumericGeneric Edit74 Allow NULL? 
16EHFHSLFactor Header Score Into LineCharacterGeneric Edit10 Allow NULL? 
17EHCRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
18EHTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
19EHTAXTax IDStringGeneric Edit200 Allow NULL? 
20EHOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
21EHALKYLong Address NumberStringGeneric Edit200 Allow NULL? 
22EHEDITXTSAllow Manual ExtensionsCharacterGeneric Edit10 Allow NULL? 
23EHOEDTOriginal End DateJDE UTimeGeneric Edit110
24EHSEVTSealed EventCharacterGeneric Edit10 Allow NULL? 
25EHBROALBid Required On All LinesCharacterGeneric Edit10 Allow NULL? 
26EHMBDAMultiple Bids AllowedCharacterGeneric Edit10 Allow NULL? 
27EHORBYOrdered ByStringGeneric Edit100 Allow NULL? 
28EHALPHName - AlphaStringGeneric Edit400 Allow NULL? 
29EHPH3Phone NumberStringGeneric Edit200 Allow NULL? 
30EHEMALElectronic AddressStringGeneric Edit2560 Allow NULL? 
31EHMCEVMultiple Currency EventCharacterGeneric Edit10 Allow NULL? 
32EHDBQWDisplay Bid Question WeightsCharacterGeneric Edit10 Allow NULL? 
33EHDSPBDisplay Start Price to BiddersCharacterGeneric Edit10 Allow NULL? 
34EHEDITRESPAllow Edit of Posted ResponsesCharacterGeneric Edit10 Allow NULL? 
35EHDISABDSDisplay All BidsCharacterGeneric Edit10 Allow NULL? 
36EHSHOWDTLSShow Award DetailsCharacterGeneric Edit10 Allow NULL? 
37EHDISPBIDDisplay Bid ScoresCharacterGeneric Edit10 Allow NULL? 
38EHDISPTOTLDisplay Total Bid PriceCharacterGeneric Edit10 Allow NULL? 
39EHDISPQUESDisplay Bid QuestionsCharacterGeneric Edit10 Allow NULL? 
40EHCCUKIDCommodity Code Unique IDNumericGeneric Edit150 Allow NULL? 
41EHRLQRRequested Line Qty Req On All Qty LinesCharacterGeneric Edit10 Allow NULL? 
42EHSIOBShow Identity of BiddersCharacterGeneric Edit10 Allow NULL? 
43EHDISBDHPDisplay Bid History PageCharacterGeneric Edit10 Allow NULL? 
44EHSCREVENTScore RFI EventCharacterGeneric Edit10 Allow NULL? 
45EHBMBSPBidder Must Beat Start PriceCharacterGeneric Edit10 Allow NULL? 
46EHCBORPOCreate Blanket Or POStringUDC (43Q BP)20 Allow NULL? 
47EHINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
48EHURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
49EHURDTUser Reserved DateDateGeneric Edit60
50EHURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
51EHURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
52EHURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
53EHTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
54EHUSERUser IDStringGeneric Edit100 Allow NULL? 
55EHPIDProgram IDStringGeneric Edit100 Allow NULL? 
56EHJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
57EHUPMJDate - UpdatedDateGeneric Edit60
58EHTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
59EHCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
60EHEVDSEvent DescriptionStringGeneric Edit550 Allow NULL? 
61EHAR1Phone PrefixStringGeneric Edit60 Allow NULL? 
62EHSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
63EHTQWTotal Question WeightNumericGeneric Edit74 Allow NULL? 

TOP920 | 43Q | F43Q10 INDEXES

NumberDescription
1EVNU DCTO KCOO (Primary/Unique)
ElementAliasDescriptionSequence
1EVNUEvent NumberAscending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending