Skip to main content

FQ354202 - Q35 Sales Order Detail

Cantara Table Object used to save requests to create Sales Order Details for later processing to standard JDE tables via standard JDE Master Business Functions.

Fields

NameAliasType
EdiUserIdEDUSSTRING
EdiTransactNumberEDTNSTRING
EdiLineNumberEDLNFLOAT
EdiSuccessfullyProcessEDSPCHARACTER
ActionCode2ACTNCHARACTER
DataItemDTAISTRING
CompanyKeyOrderNoKCOOCOMPANY
DocumentOrderInvoiceEDOCOINTEGER
OrderTypeDCTOUDC
LineNumberLNIDFLOAT
OrderSuffixSFXOSTRING
CostCenterMCUBUSINESSUNIT
CompanyCOCOMPANY
CompanyKeyOriginalOKCOCOMPANY
OriginalPoSoNumberOORNSTRING
OriginalOrderTypeOCTOUDC
OriginalLineNumberOGNOFLOAT
CompanyKeyRelatedRKCOCOMPANY
RelatedPoSoNumberRORNSTRING
RelatedOrderTypeRCTOUDC
RelatedPoSoLineNoRLLNFLOAT
ContractNumberDistributiDMCTSTRING
ContractSupplementDistriDMCSINTEGER
AddressNumberAN8ADDRESSNUMBER
AddressNumberShipToSHANADDRESSNUMBER
AddressNumberParentPA8ADDRESSNUMBER
DateRequestedJulianDRQJDATE
DateTransactionJulianTRDJDATE
DateOriginalPromisdeOPDJDATE
ActualShipDateADDJDATE
DateInvoiceJulianIVDDATE
CancelDateCNDJDATE
DtForGLAndVouch1DGLDATE
DateReleaseJulianRSDJDATE
DatePriceEffectiveDatePEFJDATE
DatePromisedShipJuPPDJDATE
Reference1VR01STRING
Reference2VendorVR02STRING
IdentifierShortItemITMSHORTITEM
Identifier2ndItemLITMSTRING
Identifier3rdItemAITMSTRING
LocationLOCNLOCATION
LotLOTNSTRING
FromGradeFRGDUDC
ThruGradeTHGDUDC
FromPotencyFRMPFLOAT
ThruPotencyTHRPFLOAT
DaysPastExpirationEXDPINTEGER
DescriptionLine1DSC1STRING
DescriptionLine2DSC2STRING
LineTypeLNTYSTRING
StatusCodeNextNXTRUDC
StatusCodeLastLTTRUDC
CostCenterHeaderEMCUBUSINESSUNIT
ItemNumberRelatedKitRLITSTRING
LineNumberKitMasterKTLNFLOAT
ComponentNumberCPNTFLOAT
RelatedKitComponentRKITINTEGER
NumbOfCpntPerParentKTPINTEGER
SalesReportingCode1SRP1UDC
SalesReportingCode2SRP2UDC
SalesReportingCode3SRP3UDC
SalesReportingCode4SRP4UDC
SalesReportingCode5SRP5UDC
PurchasingReportCode1PRP1UDC
PurchasingReportCode2PRP2UDC
PurchasingReportCode3PRP3UDC
PurchasingReportCode4PRP4UDC
PurchasingReportCode5PRP5UDC
UnitOfMeasureAsInputUOMUDC
UnitsTransactionQtyUORGINTEGER
UnitsQuantityShippedSOQSINTEGER
UnitsQuanBackorHeldSOBKINTEGER
UnitsQuantityCanceledSOCNINTEGER
UnitsQuantityFutureSONEINTEGER
UnitsOpenQuantityUOPNINTEGER
QuantityShippedToDateQTYTINTEGER
QuantityRelievedQRLVINTEGER
CommittedHSCOMMUDC
OtherQuantity12OTQYCHARACTER
AmtPricePerUnit2UPRCFLOAT
AmountOpen1AOPNFLOAT
PriceOverrideCodePROVCHARACTER
TemporaryPriceYNTPCCHARACTER
UnitOfMeasureEntUPAPUMUDC
AmtListPricePerUnitLPRCFLOAT
AmountUnitCostUNCSFLOAT
AmountExtendedCostECSTFLOAT
CostOverrideCodeCSTOCHARACTER
ExtendedCostTransferTCSTFLOAT
PrintMessage1INMGUDC
PaymentTermsCode01PTCSTRING
PaymentInstrumentARYINUDC
BasedonDateDTBSUDC
DiscountTradeTRDCFLOAT
TradeDiscountOldFUN2FLOAT
PriceAdjustmentScheduleNASNUDC
PricingCategoryPRGRUDC
PricingCategoryLevel1CLVLSTRING
DiscountCashCADCFLOAT
CompanyKeyKCOCOMPANY
DocVoucherInvoiceEDOCINTEGER
DocumentTypeDCTUDC
OriginalDocumentTypeODCTUDC
DocumentCompanyOriginalOKCCOMPANY
PickSlipNumberPSNINTEGER
DeliveryNumberDELNINTEGER
TaxableYNTAX1UDC
TaxArea1TXA1STRING
TaxExplanationCode1EXR1UDC
AssociatedTextATXTCHARACTER
PriorityProcessingPRIOUDC
ResolutionCodeBCRESLCHARACTER
BackordersAllowedYNBACKCHARACTER
SubstitutesAllowedYNSBALCHARACTER
PartialShipmntsAllowYAPTSCHARACTER
LineofBusinessLOBUDC
EndUseEUSEUDC
DutyStatusDTYSUDC
NatureOfTransactionNTRUDC
PrimaryLastVendorNoVENDADDRESSNUMBER
BuyerNumberANBYADDRESSNUMBER
CarrierCARSADDRESSNUMBER
ModeOfTransportMOTUDC
ConditionsOfTransportCOTUDC
RouteCodeROUTUDC
StopCodeSTOPUDC
ZoneNumberZONUDC
ContainerIDCNIDSTRING
FreightHandlingCodeFRTHUDC
ApplyFreightYNAFTCHARACTER
ApplyFreightFUF1UDC
FreightCalculatedYNFRTCCHARACTER
ShippingCommodityClassSHCMUDC
ShippingConditionsCodeSHCNUDC
SerialNumberLotSERNSTRING
UnitOfMeasurePrimaryUOM1UDC
UnitsPrimaryQtyOrderPQORINTEGER
UnitOfMeasureSecondaryUOM2UDC
UnitsSecondaryQtyOrSQORINTEGER
UnitOfMeasurePricingUOM4UDC
AmountUnitWeightITWTFLOAT
WeightUnitOfMeasureWTUMUDC
AmountUnitVolumeITVLFLOAT
VolumeUnitOfMeasureVLUMUDC
RepriceBasketPriceCatRPRCUDC
OrderRepriceCategoryORPRUDC
OrderRepricedIndicatorORPCHARACTER
InventoryCostingMethCMGPSTRING
CenturyCTRYINTEGER
FiscalYear1FYINTEGER
SalesOrderStatus01SO01CHARACTER
SalesOrderStatus02SO02CHARACTER
SalesOrderStatus03SO03CHARACTER
SalesOrderStatus05SO05CHARACTER
SalesOrderStatus06SO06CHARACTER
SalesOrderStatus07SO07CHARACTER
SalesOrderStatus08SO08CHARACTER
SalesOrderStatus09SO09CHARACTER
SalesOrderStatus10SO10CHARACTER
SalesOrderStatus11SO11CHARACTER
SalesOrderStatus12SO12CHARACTER
SalesOrderStatus13SO13CHARACTER
SalesOrderStatus14SO14CHARACTER
SalesOrderStatus15SO15CHARACTER
ApplyCommissionYNACOMCHARACTER
CommissionCategoryCMCGSTRING
ReasonCodeRCDUDC
GrossWeightGRWTFLOAT
UnitOfMeasureGrossWtGWUMUDC
SubledgerSBLSTRING
SubledgerTypeSBLTUDC
PriceCode1UPC1UDC
PriceCode2UPC2UDC
PriceCode3UPC3UDC
StatusInWarehouseSWMSCHARACTER
WoOrderFreezeCodeUNCDUDC
CorrespondenceMethodCRMDUDC
CurrencyCodeFromCRCDSTRING
CurrencyConverRateOvCRRFLOAT
AmountListPriceForeignFPRCFLOAT
AmtForPricePerUnitFUPFLOAT
AmountForeignExtPriceFEAFLOAT
AmountForeignUnitCostFUCFLOAT
UserReservedCodeURCDSTRING
UserReservedDateURDTDATE
UserReservedAmountURATFLOAT
UserReservedReferenceURRFSTRING
UserIdUSERSTRING
ProgramIdPIDSTRING
WorkStationIdJOBNSTRING
DateUpdatedUPMJDATE
TimeOfDayTDAYINTEGER
IntegrationReference01IR01STRING
IntegrationReference02IR02STRING
IntegrationReference03IR03STRING
IntegrationReference04IR04STRING
IntegrationReference05IR05STRING
SourceOfOrderSOORINTEGER
DemandUniqueKeyDEIDINTEGER
PullSignalPSIGSTRING
ScheduledShipmentTimePMDTINTEGER
TimeReleaseRLTMINTEGER
ActualShipmentTimeADTMINTEGER
TimeOriginalPromisedOPTTINTEGER
PromisedPickTimePDTTINTEGER
TimeFuture2PSTMINTEGER
PromotionIDPMTNSTRING
BuyingSegmentCodeBSCUDC
CurrentBuyingSegmentCodeCBSCUDC
RevisionReasonRFRVUDC
ShipmentNumberSHPNINTEGER
ProjectNumberPRJMINTEGER
HoldOrdersCodeHOLDUDC
PaymentTermsOverridePMTOCHARACTER
DualUnitOfMeasureItemDUALCHARACTER
ProductionNumberPMPNSTRING
GlClassGLCSTRING
CodeLocationTaxStatLCODUDC
TransactionOriginatorTORGSTRING
ReleaseNumberRLNUSTRING
AmountExtendedPriceAEXPFLOAT
OriginalDocumentNoODOCINTEGER
AmountForeignExtCostFECFLOAT
UserReservedNumberURABINTEGER
RequestedDeliveryTimeDRQTINTEGER
AddressNumberDeliveredToDVANADDRESSNUMBER
ScheduledPickDatePDDJDATE
SalesOrderStatus04SO04CHARACTER
DateReleaseRLDJDATE
ShipToCusContactLineNumIDSHCCIDLNINTEGER
OpportunityIdOPPIDINTEGER
ShipToAttentionSPATTNSTRING
CatalogNameCATNMSTRING
SalesOrderStatus18SO18CHARACTER
OrganizationTypeStructurOSTPUDC
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.