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

133 COLUMNS | 10 INDEXES | Print definition?920 | 42 | F4201 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F4201SH13310Sales Order Header FileTransaction Files42: Sales ManagementBusiness 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 SHKCOO, SHDOCO, SHDCTO, SHSFXO, SHMCU, SHCO, SHOKCO, SHOORN, SHOCTO, SHRKCO, SHRORN, SHRCTO, SHAN8, SHSHAN, SHPA8, SHDRQJ, SHTRDJ, SHPDDJ, SHOPDJ, SHADDJ, SHCNDJ, SHPEFJ, SHPPDJ, SHVR01, SHVR02, SHDEL1, SHDEL2, SHINMG, SHPTC, SHRYIN, SHASN, SHPRGP, SHTRDC, SHPCRT, SHTXA1, SHEXR1, SHTXCT, SHATXT, SHPRIO, SHBACK, SHSBAL, SHHOLD, SHPLST, SHINVC, SHNTR, SHANBY, SHCARS, SHMOT, SHCOT, SHROUT, SHSTOP, SHZON, SHCNID, SHFRTH, SHAFT, SHFUF1, SHFRTC, SHMORD, SHRCD, SHFUF2, SHOTOT, SHTOTC, SHWUMD, SHVUMD, SHAUTN, SHCACT, SHCEXP, SHSBLI, SHCRMD, SHCRRM, SHCRCD, SHCRR, SHLNGP, SHFAP, SHFCST, SHORBY, SHTKBY, SHURCD, SHURDT, SHURAT, SHURAB, SHURRF, SHUSER, SHPID, SHJOBN, SHUPMJ, SHTDAY, SHIR01, SHIR02, SHIR03, SHIR04, SHIR05, SHVR03, SHSOOR, SHPMDT, SHRSDT, SHRQSJ, SHPSTM, SHPDTT, SHOPTT, SHDRQT, SHADTM, SHADLJ, SHPBAN, SHITAN, SHFTAN, SHDVAN, SHDOC1, SHDCT4, SHCORD, SHBSC, SHBCRC, SHAUFT, SHAUFI, SHOPBO, SHOPTC, SHOPLD, SHOPBK, SHOPSB, SHOPPS, SHOPPL, SHOPMS, SHOPSS, SHOPBA, SHOPLL, SHPRAN8, SHOPPID, SHSDATTN, SHSPATTN, SHOTIND, SHPRCIDLN, SHCCIDLN, SHSHCCIDLN FROM F4201

TOP920 | 42 | F4201 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SHKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2SHDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3SHDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4SHSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
5SHMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
6SHCOCompanyStringGeneric Edit50 Allow NULL? 
7SHOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
8SHOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
9SHOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
10SHRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
11SHRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
12SHRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
13SHAN8Address NumberNumericGeneric Edit80 Allow NULL? 
14SHSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
15SHPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
16SHDRQJDate - RequestedDateGeneric Edit60
17SHTRDJDate - Order/TransactionDateGeneric Edit60
18SHPDDJDate - Scheduled PickDateGeneric Edit60
19SHOPDJDate - Original Promised DeliveryDateGeneric Edit60
20SHADDJDate - Actual Ship DateDateGeneric Edit60
21SHCNDJDate - CancelDateGeneric Edit60
22SHPEFJDate - Price Effective DateDateGeneric Edit60
23SHPPDJDate - Promised ShipmentDateGeneric Edit60
24SHVR01ReferenceStringGeneric Edit250 Allow NULL? 
25SHVR02Reference 2StringGeneric Edit250 Allow NULL? 
26SHDEL1Delivery Instructions Line 1StringGeneric Edit300 Allow NULL? 
27SHDEL2Delivery Instructions Line 2StringGeneric Edit300 Allow NULL? 
28SHINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
29SHPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
30SHRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
31SHASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
32SHPRGPPricing GroupStringUDC (40 PC)80 Allow NULL? 
33SHTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
34SHPCRTPercent - RetainageNumericGeneric Edit73 Allow NULL? 
35SHTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
36SHEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
37SHTXCTCertificate Tax ExemptionStringGeneric Edit200 Allow NULL? 
38SHATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
39SHPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
40SHBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
41SHSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
42SHHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
43SHPLSTPrice Pick List (Y/N)CharacterGeneric Edit10 Allow NULL? 
44SHINVCInvoice CopiesNumericGeneric Edit20 Allow NULL? 
45SHNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
46SHANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
47SHCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
48SHMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
49SHCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
50SHROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
51SHSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
52SHZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
53SHCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
54SHFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
55SHAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
56SHFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
57SHFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
58SHMORDMerge Orders (Y/N)CharacterGeneric Edit10 Allow NULL? 
59SHRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
60SHFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
61SHOTOTAmount - Order GrossNumericGeneric Edit152 Allow NULL? 
62SHTOTCAmount - Total CostNumericGeneric Edit152 Allow NULL? 
63SHWUMDUnit of Measure - Weight DisplayStringUDC (00 UM)20 Allow NULL? 
64SHVUMDUnit of Measure - Volume DisplayStringUDC (00 UM)20 Allow NULL? 
65SHAUTNAuthorization Number - Credit ApprovalStringGeneric Edit100 Allow NULL? 
66SHCACTAccount Number - Credit/BankStringGeneric Edit250 Allow NULL? 
67SHCEXPDate - Expired (Julian)DateGeneric Edit60
68SHSBLISubledger Inactive CodeCharacterUDC (00 SI)10 Allow NULL? 
69SHCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
70SHCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
71SHCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
72SHCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
73SHLNGPLanguageStringUDC (01 LP)20 Allow NULL? 
74SHFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
75SHFCSTAmount - Foreign Total CostNumericGeneric Edit152 Allow NULL? 
76SHORBYOrdered ByStringGeneric Edit100 Allow NULL? 
77SHTKBYOrder Taken ByStringGeneric Edit100 Allow NULL? 
78SHURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
79SHURDTUser Reserved DateDateGeneric Edit60
80SHURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
81SHURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
82SHURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
83SHUSERUser IDStringGeneric Edit100 Allow NULL? 
84SHPIDProgram IDStringGeneric Edit100 Allow NULL? 
85SHJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
86SHUPMJDate - UpdatedDateGeneric Edit60
87SHTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
88SHIR01Integration Reference 01StringGeneric Edit300 Allow NULL? 
89SHIR02Integration Reference 02StringGeneric Edit300 Allow NULL? 
90SHIR03Integration Reference 03StringGeneric Edit300 Allow NULL? 
91SHIR04Integration Reference 04StringGeneric Edit300 Allow NULL? 
92SHIR05Integration Reference 05StringGeneric Edit300 Allow NULL? 
93SHVR03ReferenceStringGeneric Edit250 Allow NULL? 
94SHSOORSource of OrderIntegerGeneric Edit110 Allow NULL? 
95SHPMDTScheduled Shipment TimeNumericGeneric Edit60 Allow NULL? 
96SHRSDTPromised Delivery TimeNumericGeneric Edit60 Allow NULL? 
97SHRQSJDate - Requested ShipDateGeneric Edit60
98SHPSTMTime - Future Time 2NumericGeneric Edit60 Allow NULL? 
99SHPDTTTime - Scheduled PickNumericGeneric Edit60 Allow NULL? 
100SHOPTTTime - Original Promised DeliveryNumericGeneric Edit60 Allow NULL? 
101SHDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
102SHADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
103SHADLJDate - Actual DeliveryDateGeneric Edit60
104SHPBANAddress Number - Paid ByNumericGeneric Edit80 Allow NULL? 
105SHITANAddress Number - Invoiced ToNumericGeneric Edit80 Allow NULL? 
106SHFTANAddress Number - Forwarded ToNumericGeneric Edit80 Allow NULL? 
107SHDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
108SHDOC1Document (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
109SHDCT4Document TypeStringUDC (00 DT)20 Allow NULL? 
110SHCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
111SHBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
112SHBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
113SHAUFTAddress Number to use for TaxCharacterUDC (42B UA)10 Allow NULL? 
114SHAUFIAddress Number to use for TransportationCharacterUDC (42B UA)10 Allow NULL? 
115SHOPBOOP Business ObjectiveStringUDC (34A BO)300 Allow NULL? 
116SHOPTCOP Total CostNumericGeneric Edit154 Allow NULL? 
117SHOPLDOP Latest Line DateDateGeneric Edit60
118SHOPBKOP Number of BackordersNumericGeneric Edit150 Allow NULL? 
119SHOPSBOP Number of SubstitutesNumericGeneric Edit150 Allow NULL? 
120SHOPPSOP Promised StatusStringGeneric Edit300 Allow NULL? 
121SHOPPLOP Partial Order ShipmentCharacterGeneric Edit10 Allow NULL? 
122SHOPMSOP Allow Multi SourceCharacterGeneric Edit10 Allow NULL? 
123SHOPSSOP Allow SubstitutesCharacterGeneric Edit10 Allow NULL? 
124SHOPBAOP Allow BackordersCharacterGeneric Edit10 Allow NULL? 
125SHOPLLOP Partial Ship Line ItemsCharacterGeneric Edit10 Allow NULL? 
126SHPRAN8Partner Address NumberNumericGeneric Edit80 Allow NULL? 
127SHOPPIDOpportunity NumberNumericGeneric Edit150 Allow NULL? 
128SHSDATTNSold To AttentionStringGeneric Edit500 Allow NULL? 
129SHSPATTNShip To AttentionStringGeneric Edit500 Allow NULL? 
130SHOTINDOrder Type IndicatorCharacterGeneric Edit10 Allow NULL? 
131SHPRCIDLNPartner Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
132SHCCIDLNCustomer Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
133SHSHCCIDLNShip To Cust Contact Line Num IDNumericGeneric Edit50 Allow NULL? 

TOP920 | 42 | F4201 INDEXES

NumberDescription
1Order Number Order Type +A (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
2Cust PO Sold To +B
ElementAliasDescriptionSequence
1VR01ReferenceAscending
2AN8Address NumberAscending
3OpportunityID OrdeTypeInd +C
ElementAliasDescriptionSequence
1OPPIDOpportunity NumberAscending
2OTINDOrder Type IndicatorAscending
4SoldTo SoldToSequenceID +D
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2OTINDOrder Type IndicatorAscending
3CCIDLNCustomer Contact Line Number IDAscending
5ShipTo ShipToSequenceID +E
ElementAliasDescriptionSequence
1SHANAddress Number - Ship ToAscending
2OTINDOrder Type IndicatorAscending
3SHCCIDLNShip To Cust Contact Line Num IDAscending
6Company SoldToAddress +F
ElementAliasDescriptionSequence
1COCompanyAscending
2AN8Address NumberAscending
3OTINDOrder Type IndicatorAscending
7Company ShipToAddress +G
ElementAliasDescriptionSequence
1COCompanyAscending
2SHANAddress Number - Ship ToAscending
3OTINDOrder Type IndicatorAscending
8CompanyKeyOrderNo
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
9Order Type
ElementAliasDescriptionSequence
1DCTOOrder TypeAscending
10Addr Num Trans Date Ord Num
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2TRDJDate - Order/TransactionDescending
3DOCODocument (Order No Invoice etc.)Descending