Q35GetSalesOrderHeader

Cantara Business Function to retrieve details of Sales Order Headers from JDE Table F4201.

Data Structure

Name	Type	Inclusion	Direction
DTAI_szErrorMessage	STRING	OPTIONAL	OUT
DOCO_mnDocumentOrderInvoiceE	INTEGER	REQUIRED	IN
DCTO_szOrderType	UDC	REQUIRED	IN
KCOO_szCompanyKeyOrderNo	COMPANY	REQUIRED	IN
MATH01_mnTotalLines	FLOAT	OPTIONAL	OUT
MATH01_mnOpenLines	FLOAT	OPTIONAL	OUT
MATH01_mnCanceledLines	FLOAT	OPTIONAL	OUT
SFXO_szOrderSuffix	STRING	OPTIONAL	OUT
MCU_szCostCenter	BUSINESSUNIT	OPTIONAL	OUT
CO_szCompany	COMPANY	OPTIONAL	OUT
OKCO_szCompanyKeyOriginal	COMPANY	OPTIONAL	OUT
OORN_szOriginalPoSoNumber	STRING	OPTIONAL	OUT
OCTO_szOriginalOrderType	UDC	OPTIONAL	OUT
RKCO_szCompanyKeyRelated	COMPANY	OPTIONAL	OUT
RORN_szRelatedPoSoNumber	STRING	OPTIONAL	OUT
RCTO_szRelatedOrderType	UDC	OPTIONAL	OUT
AN8_mnAddressNumber	ADDRESSNUMBER	OPTIONAL	OUT
SHAN_mnAddressNumberShipTo	ADDRESSNUMBER	OPTIONAL	OUT
PA8_mnAddressNumberParent	ADDRESSNUMBER	OPTIONAL	OUT
DRQJ_jdDateRequestedJulian	DATE	OPTIONAL	OUT
TRDJ_jdDateTransactionJulian	DATE	OPTIONAL	OUT
PDDJ_jdScheduledPickDate	DATE	OPTIONAL	OUT
OPDJ_jdDateOriginalPromisde	DATE	OPTIONAL	OUT
ADDJ_jdActualShipDate	DATE	OPTIONAL	OUT
CNDJ_jdCancelDate	DATE	OPTIONAL	OUT
PEFJ_jdDatePriceEffectiveDate	DATE	OPTIONAL	OUT
PPDJ_jdDatePromisedShipJu	DATE	OPTIONAL	OUT
VR01_szReference1	STRING	OPTIONAL	OUT
VR02_szReference2Vendor	STRING	OPTIONAL	OUT
DEL1_szDeliveryInstructLine1	STRING	OPTIONAL	OUT
DEL2_szDeliveryInstructLine2	STRING	OPTIONAL	OUT
INMG_szPrintMessage1	UDC	OPTIONAL	OUT
PTC_szPaymentTermsCode01	STRING	OPTIONAL	OUT
RYIN_cPaymentInstrumentA	UDC	OPTIONAL	OUT
ASN_szPriceAdjustmentScheduleN	UDC	OPTIONAL	OUT
PRGP_szPricingGroup	UDC	OPTIONAL	OUT
TRDC_mnDiscountTrade	FLOAT	OPTIONAL	OUT
PCRT_mnPercentRetainage1	FLOAT	OPTIONAL	OUT
TXA1_szTaxArea1	STRING	OPTIONAL	OUT
EXR1_szTaxExplanationCode1	UDC	OPTIONAL	OUT
TXCT_szCertificateTaxExempt	STRING	OPTIONAL	OUT
ATXT_cAssociatedText	CHARACTER	OPTIONAL	OUT
PRIO_cPriorityProcessing	UDC	OPTIONAL	OUT
BACK_cBackordersAllowedYN	CHARACTER	OPTIONAL	OUT
SBAL_cSubstitutesAllowedYN	CHARACTER	OPTIONAL	OUT
NTR_szNatureOfTransaction	UDC	OPTIONAL	OUT
ANBY_mnBuyerNumber	ADDRESSNUMBER	OPTIONAL	OUT
CARS_mnCarrier	ADDRESSNUMBER	OPTIONAL	OUT
MOT_szModeOfTransport	UDC	OPTIONAL	OUT
COT_szConditionsOfTransport	UDC	OPTIONAL	OUT
ROUT_szRouteCode	UDC	OPTIONAL	OUT
STOP_szStopCode	UDC	OPTIONAL	OUT
ZON_szZoneNumber	UDC	OPTIONAL	OUT
CNID_szContainerID	STRING	OPTIONAL	OUT
FRTH_szFreightHandlingCode	UDC	OPTIONAL	OUT
AFT_cApplyFreightYN	CHARACTER	OPTIONAL	OUT
RCD_szReasonCode	UDC	OPTIONAL	OUT
OTOT_mnAmountOrderGross	FLOAT	OPTIONAL	OUT
TOTC_mnAmountTotalCost	FLOAT	OPTIONAL	OUT
WUMD_szUnitOfMeasureWhtDisp	UDC	OPTIONAL	OUT
VUMD_szUnitOfMeasureVolDisp	UDC	OPTIONAL	OUT
AUTN_szAuthorizationNoCredit	STRING	OPTIONAL	OUT
CACT_szAcctNoCrBank	STRING	OPTIONAL	OUT
CEXP_jdDateExpired	DATE	OPTIONAL	OUT
CRMD_cCorrespondenceMethod	UDC	OPTIONAL	OUT
CRRM_cCurrencyMode	UDC	OPTIONAL	OUT
CRCD_szCurrencyCodeFrom	STRING	OPTIONAL	OUT
CRR_mnCurrencyConverRateOv	FLOAT	OPTIONAL	OUT
LNGP_szLanguagePreference	UDC	OPTIONAL	OUT
FAP_mnAmountForeignOpen	FLOAT	OPTIONAL	OUT
FCST_mnAmountForeignTotalC	FLOAT	OPTIONAL	OUT
ORBY_szOrderedBy	STRING	OPTIONAL	OUT
TKBY_szOrderTakenBy	STRING	OPTIONAL	OUT
URCD_szUserReservedCode	STRING	OPTIONAL	OUT
URDT_jdUserReservedDate	DATE	OPTIONAL	OUT
URAT_mnUserReservedAmount	FLOAT	OPTIONAL	OUT
URAB_mnUserReservedNumber	INTEGER	OPTIONAL	OUT
URRF_szUserReservedReference	STRING	OPTIONAL	OUT
IR01_szIntegrationReference01	STRING	OPTIONAL	OUT
IR02_szIntegrationReference02	STRING	OPTIONAL	OUT
IR03_szIntegrationReference03	STRING	OPTIONAL	OUT
IR04_szIntegrationReference04	STRING	OPTIONAL	OUT
IR05_szIntegrationReference05	STRING	OPTIONAL	OUT
VR03_szReferenceUCISNo	STRING	OPTIONAL	OUT
SOOR_mnSourceOfOrder	INTEGER	OPTIONAL	OUT
PMDT_mnScheduledShipmentTime	INTEGER	OPTIONAL	OUT
RSDT_mnPromisedDeliveryTime	INTEGER	OPTIONAL	OUT
RQSJ_jdDateRequestedShip	DATE	OPTIONAL	OUT
PSTM_mnTimeFuture2	INTEGER	OPTIONAL	OUT
PDTT_mnPromisedPickTime	INTEGER	OPTIONAL	OUT
OPTT_mnTimeOriginalPromised	INTEGER	OPTIONAL	OUT
DRQT_mnRequestedDeliveryTime	INTEGER	OPTIONAL	OUT
ADTM_mnActualShipmentTime	INTEGER	OPTIONAL	OUT
ADLJ_jdDateActualDelivery	DATE	OPTIONAL	OUT
PBAN_mnAddressNumberPaidBy	INTEGER	OPTIONAL	OUT
ITAN_mnAddressNumberInvoicedTo	INTEGER	OPTIONAL	OUT
FTAN_mnAddressNumberFwdedTo	INTEGER	OPTIONAL	OUT
DVAN_mnAddressNumberDelivedTo	ADDRESSNUMBER	OPTIONAL	OUT
DOC1_mnDocumentOrderInvoi	INTEGER	OPTIONAL	OUT
DCT4_szDoctType	UDC	OPTIONAL	OUT
CORD_mnNumberChangeOrder	INTEGER	OPTIONAL	OUT
BSC_szBuyingSegmentCode	UDC	OPTIONAL	OUT
BCRC_szCurrencyCodeBase	STRING	OPTIONAL	OUT
HOLD_szHoldOrdersCode	UDC	OPTIONAL	OUT
FUF1_cApplyFreight	UDC	OPTIONAL	OUT
AUFT_cAddressNumberForTax	UDC	OPTIONAL	OUT
AUFI_cAddressNumberForTranspor	UDC	OPTIONAL	OUT
OPBO_szOPBusinessObjective	UDC	OPTIONAL	OUT
OPTC_mnOPTotalCost	FLOAT	OPTIONAL	OUT
OPLD_jdOPLatestLineDate	DATE	OPTIONAL	OUT
OPBK_mnOPNumberofBackorders	INTEGER	OPTIONAL	OUT
OPSB_mnOPNumberofSubstitutes	INTEGER	OPTIONAL	OUT
OPPS_szOPPromisedStatus	STRING	OPTIONAL	OUT
OPPL_cOPPartialOrderShipment	CHARACTER	OPTIONAL	OUT
OPMS_cOPAllowMultiSource	CHARACTER	OPTIONAL	OUT
OPSS_cOPAllowSubstitutes	CHARACTER	OPTIONAL	OUT
OPBA_cOPAllowBackorders	CHARACTER	OPTIONAL	OUT
OPLL_cOPPartialShipLineItems	CHARACTER	OPTIONAL	OUT
PRAN8_mnPartnerAddressNumber	INTEGER	OPTIONAL	OUT
PRCIDLN_mnPartnerContactLineNo	INTEGER	OPTIONAL	OUT
OPPID_mnOpportunityId	INTEGER	OPTIONAL	OUT
CCIDLN_mnCustomerContactLineNo	INTEGER	OPTIONAL	OUT
SDATTN_szSoldToAttention	STRING	OPTIONAL	OUT
SHCCIDLN_mnShipToCusContactNo	INTEGER	OPTIONAL	OUT
SPATTN_szShipToAttention	STRING	OPTIONAL	OUT
OTIND_cOrderTypeIndicator	CHARACTER	OPTIONAL	OUT
SBLI_cSubledgerInactiveCode	UDC	OPTIONAL	OUT
FUF2_cPostQuantities	CHARACTER	OPTIONAL	OUT
MORD_cMergeOrdersYN	CHARACTER	OPTIONAL	OUT
FRTC_cFreightCalculatedYN	CHARACTER	OPTIONAL	OUT
PLST_cPricePickListYN	CHARACTER	OPTIONAL	OUT
INVC_mnInvoiceCopies	INTEGER	OPTIONAL	OUT
LNID_mnFirstLineNumber	FLOAT	OPTIONAL	OUT
LNID_mnLastLineNumber	FLOAT	OPTIONAL	OUT