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

67 COLUMNS | 1 INDEXES | Print definition?910 | 43Q | F43Q90 TABLE

43Q: Strategic Sourcing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F43Q90SC671Sourcing ConstantsFiles43Q: 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 SCUKID, SCRFXDT, SCRFIDT, SCAT1, SCAT6, SCNTYP, SCLOCN, SCSLNT, SCSTLT, SCNSLT, SCDEFTIME, SCDEFMSRE, SCEVTDEF, SCEVTMSRE, SCEVTEND, SCENDMSRE, SCBIDQNIF, SCEDITRESP, SCEDITXTS, SCBROAL, SCBMBSP, SCCBORPO, SCDISBDHP, SCDBQW, SCDSPB, SCMBDA, SCRLQR, SCSEVT, SCSIOB, SCBROALRFI, SCDBQWRFI, SCDBHPRFI, SCEDTRSRFI, SCEDTXTRFI, SCSCREVENT, SCCDTYLS, SCSYSEEDA, SCPBIDCOD, SCDISABDS, SCSHOWDTLS, SCDISPBID, SCDISPTOTL, SCDISPQUES, SCBIDURL, SCINVTCS, SCCRESMSG, SCCLESMSG, SCPESMSG, SCRESMSG, SCEESMSG, SCAESMSG, SCXESMSG, SCUBSMSG, SCPSMSG, SCBROLE, SCSROLE, SCURCD, SCURDT, SCURAT, SCURAB, SCURRF, SCTORG, SCUSER, SCPID, SCJOBN, SCUPMJ, SCTDAY FROM F43Q90

TOP910 | 43Q | F43Q90 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SCUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
2SCRFXDTRFx Document TypeStringUDC (00 DT)20 Allow NULL? 
3SCRFIDTRFI Document TypeStringUDC (00 DT)20 Allow NULL? 
4SCAT1Search TypeStringUDC (01 ST)30 Allow NULL? 
5SCAT6Search TypeStringUDC (01 ST)30 Allow NULL? 
6SCNTYPContact TypeStringUDC (01 CT)30 Allow NULL? 
7SCLOCNLocationStringGeneric Edit200 Allow NULL? 
8SCSLNTService Line TypeStringGeneric Edit20 Allow NULL? 
9SCSTLTStock Line TypeStringGeneric Edit20 Allow NULL? 
10SCNSLTNon-Stock Line TypeStringGeneric Edit20 Allow NULL? 
11SCDEFTIMEEvent Preview Default TimeNumericGeneric Edit40 Allow NULL? 
12SCDEFMSREEvent Preview Default Time MeasureStringUDC (43Q TM)20 Allow NULL? 
13SCEVTDEFEvent Start Default TimeNumericGeneric Edit40 Allow NULL? 
14SCEVTMSREEvent Start Default Time MeasureStringUDC (43Q TM)20 Allow NULL? 
15SCEVTENDEvent End Default TimeNumericGeneric Edit40 Allow NULL? 
16SCENDMSREEvent End Default Time MeasureStringUDC (43Q TM)20 Allow NULL? 
17SCBIDQNIFBid Question Number Increment FactorNumericGeneric Edit30 Allow NULL? 
18SCEDITRESPAllow Edit of Posted ResponsesCharacterGeneric Edit10 Allow NULL? 
19SCEDITXTSAllow Manual ExtensionsCharacterGeneric Edit10 Allow NULL? 
20SCBROALBid Required On All LinesCharacterGeneric Edit10 Allow NULL? 
21SCBMBSPBidder Must Beat Start PriceCharacterGeneric Edit10 Allow NULL? 
22SCCBORPOCreate Blanket Or POStringUDC (43Q BP)20 Allow NULL? 
23SCDISBDHPDisplay Bid History PageCharacterGeneric Edit10 Allow NULL? 
24SCDBQWDisplay Bid Question WeightsCharacterGeneric Edit10 Allow NULL? 
25SCDSPBDisplay Start Price to BiddersCharacterGeneric Edit10 Allow NULL? 
26SCMBDAMultiple Bids AllowedCharacterGeneric Edit10 Allow NULL? 
27SCRLQRRequested Line Qty Req On All Qty LinesCharacterGeneric Edit10 Allow NULL? 
28SCSEVTSealed EventCharacterGeneric Edit10 Allow NULL? 
29SCSIOBShow Identity of BiddersCharacterGeneric Edit10 Allow NULL? 
30SCBROALRFIBid Required On All Lines RFICharacterGeneric Edit10 Allow NULL? 
31SCDBQWRFIDisplay Bid Question Weights RFICharacterGeneric Edit10 Allow NULL? 
32SCDBHPRFIDisplay RFI Bid History PageCharacterGeneric Edit10 Allow NULL? 
33SCEDTRSRFIAllow Edit of Posted Responses RFICharacterGeneric Edit10 Allow NULL? 
34SCEDTXTRFIAllow Manual Extensions RFICharacterGeneric Edit10 Allow NULL? 
35SCSCREVENTScore RFI EventCharacterGeneric Edit10 Allow NULL? 
36SCCDTYLSCommodity Level SearchStringUDC (43Q CC)20 Allow NULL? 
37SCSYSEEDASystem End Effective DateJDE UTimeGeneric Edit110
38SCPBIDCODDefault Price Bid Question CodeStringGeneric Edit180 Allow NULL? 
39SCDISABDSDisplay All BidsCharacterGeneric Edit10 Allow NULL? 
40SCSHOWDTLSShow Award DetailsCharacterGeneric Edit10 Allow NULL? 
41SCDISPBIDDisplay Bid ScoresCharacterGeneric Edit10 Allow NULL? 
42SCDISPTOTLDisplay Total Bid PriceCharacterGeneric Edit10 Allow NULL? 
43SCDISPQUESDisplay Bid QuestionsCharacterGeneric Edit10 Allow NULL? 
44SCBIDURLBidder URLStringGeneric Edit2560 Allow NULL? 
45SCINVTCSInvite Terms and ConditionsStringUDC (40 PM)100 Allow NULL? 
46SCCRESMSGEvent Invite Send MessageStringUDC (40 PM)100 Allow NULL? 
47SCCLESMSGEvent Cancel Send MessageStringUDC (40 PM)100 Allow NULL? 
48SCPESMSGEvent Pause Send MessageStringUDC (40 PM)100 Allow NULL? 
49SCRESMSGEvent Resume Send MessageStringUDC (40 PM)100 Allow NULL? 
50SCEESMSGEvent End Send MessageStringUDC (40 PM)100 Allow NULL? 
51SCAESMSGEvent Award Send MessageStringUDC (40 PM)100 Allow NULL? 
52SCXESMSGEvent Extend Send MessageStringUDC (40 PM)100 Allow NULL? 
53SCUBSMSGUnsuccessful Bid Send MessageStringUDC (40 PM)100 Allow NULL? 
54SCPSMSGPassword Send MessageStringUDC (40 PM)100 Allow NULL? 
55SCBROLEBidder RoleStringGeneric Edit150 Allow NULL? 
56SCSROLESupplier RoleStringGeneric Edit150 Allow NULL? 
57SCURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
58SCURDTUser Reserved DateDateGeneric Edit60
59SCURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
60SCURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
61SCURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
62SCTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
63SCUSERUser IDStringGeneric Edit100 Allow NULL? 
64SCPIDProgram IDStringGeneric Edit100 Allow NULL? 
65SCJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
66SCUPMJDate - UpdatedDateGeneric Edit60
67SCTDAYTime of DayNumericGeneric Edit60 Allow NULL? 

TOP910 | 43Q | F43Q90 INDEXES

NumberDescription
1UKID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending