Skip to main content
Skip table of contents

FQ354201 - Q35 Sales Order Header

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

Fields

NameAliasType
EdiUserIdEDUSSTRING
EdiTransactNumberEDTNSTRING
EdiSuccessfullyProcessEDSPCHARACTER
DataItemDTAISTRING
CompanyKeyOrderNoKCOOCOMPANY
DocumentOrderInvoiceEDOCOINTEGER
OrderTypeDCTOUDC
OrderSuffixSFXOSTRING
CostCenterMCUBUSINESSUNIT
CompanyCOCOMPANY
CompanyKeyOriginalOKCOCOMPANY
OriginalPoSoNumberOORNSTRING
OriginalOrderTypeOCTOUDC
CompanyKeyRelatedRKCOCOMPANY
RelatedPoSoNumberRORNSTRING
RelatedOrderTypeRCTOUDC
AddressNumberAN8ADDRESSNUMBER
AddressNumberShipToSHANADDRESSNUMBER
AddressNumberParentPA8ADDRESSNUMBER
DateRequestedJulianDRQJDATE
DateTransactionJulianTRDJDATE
ScheduledPickDatePDDJDATE
DateOriginalPromisdeOPDJDATE
ActualShipDateADDJDATE
CancelDateCNDJDATE
DatePriceEffectiveDatePEFJDATE
DatePromisedShipJuPPDJDATE
Reference1VR01STRING
Reference2VendorVR02STRING
DeliveryInstructLine1DEL1STRING
DeliveryInstructLine2DEL2STRING
PrintMessage1INMGUDC
PaymentTermsCode01PTCSTRING
PaymentInstrumentARYINUDC
PriceAdjustmentScheduleNASNUDC
PricingGroupPRGPUDC
DiscountTradeTRDCFLOAT
PercentRetainage1PCRTFLOAT
TaxArea1TXA1STRING
TaxExplanationCode1EXR1UDC
CertificateTaxExemptTXCTSTRING
AssociatedTextATXTCHARACTER
PriorityProcessingPRIOUDC
BackordersAllowedYNBACKCHARACTER
SubstitutesAllowedYNSBALCHARACTER
NatureOfTransactionNTRUDC
BuyerNumberANBYADDRESSNUMBER
CarrierCARSADDRESSNUMBER
ModeOfTransportMOTUDC
ConditionsOfTransportCOTUDC
RouteCodeROUTUDC
StopCodeSTOPUDC
ZoneNumberZONUDC
ContainerIDCNIDSTRING
FreightHandlingCodeFRTHUDC
ApplyFreightYNAFTCHARACTER
ReasonCodeRCDUDC
AmountOrderGrossOTOTFLOAT
AmountTotalCostTOTCFLOAT
UnitOfMeasureWhtDispWUMDUDC
UnitOfMeasureVolDispVUMDUDC
AuthorizationNoCreditAUTNSTRING
AcctNoCrBankCACTSTRING
DateExpiredCEXPDATE
CorrespondenceMethodCRMDUDC
CurrencyModeCRRMUDC
CurrencyCodeFromCRCDSTRING
CurrencyConverRateOvCRRFLOAT
LanguagePreferenceLNGPUDC
AmountForeignOpenFAPFLOAT
AmountForeignTotalCFCSTFLOAT
OrderedByORBYSTRING
OrderTakenByTKBYSTRING
UserReservedCodeURCDSTRING
UserReservedDateURDTDATE
UserReservedAmountURATFLOAT
UserReservedNumberURABINTEGER
UserReservedReferenceURRFSTRING
TransactionOriginatorTORGSTRING
UserIdUSERSTRING
ProgramIdPIDSTRING
WorkStationIdJOBNSTRING
DateUpdatedUPMJDATE
TimeOfDayTDAYINTEGER
IntegrationReference01IR01STRING
IntegrationReference02IR02STRING
IntegrationReference03IR03STRING
IntegrationReference04IR04STRING
IntegrationReference05IR05STRING
ReferenceUCISNoVR03STRING
SourceOfOrderSOORINTEGER
ScheduledShipmentTimePMDTINTEGER
PromisedDeliveryTimeRSDTINTEGER
DateRequestedShipRQSJDATE
TimeFuture2PSTMINTEGER
PromisedPickTimePDTTINTEGER
TimeOriginalPromisedOPTTINTEGER
RequestedDeliveryTimeDRQTINTEGER
ActualShipmentTimeADTMINTEGER
DateActualDeliveryADLJDATE
AddressNumberPaidByPBANINTEGER
AddressNumberInvoicedToITANINTEGER
AddressNumberForwardedToFTANINTEGER
AddressNumberDeliveredToDVANADDRESSNUMBER
DocumentOrderInvoiDOC1INTEGER
DoctTypeDCT4UDC
NumberChangeOrderCORDINTEGER
BuyingSegmentCodeBSCUDC
CurrencyCodeBaseBCRCSTRING
HoldOrdersCodeHOLDUDC
ApplyFreightFUF1UDC
AddressNumberForTaxAUFTUDC
AddressNumberForTransportationAUFIUDC
OPBusinessObjectiveOPBOUDC
OPTotalCostOPTCFLOAT
OPLatestLineDateOPLDDATE
OPNumberofBackordersOPBKINTEGER
OPNumberofSubstitutesOPSBINTEGER
OPPromisedStatusOPPSSTRING
OPPartialOrderShipmentOPPLCHARACTER
OPAllowMultiSourceOPMSCHARACTER
OPAllowSubstitutesOPSSCHARACTER
OPAllowBackordersOPBACHARACTER
OPPartialShipLineItemsOPLLCHARACTER
PartnerAddressNumberPRAN8INTEGER
PartnerContactLineNumIDPRCIDLNINTEGER
OpportunityIdOPPIDINTEGER
CustomerContactLineNumberIDCCIDLNINTEGER
SoldToAttentionSDATTNSTRING
ShipToCusContactLineNumIDSHCCIDLNINTEGER
ShipToAttentionSPATTNSTRING
OrderTypeIndicatorOTINDCHARACTER
JavaScript errors detected

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

If this problem persists, please contact our support.