Skip to main content

Q35GetSalesOrderHeader

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

Data Structure

NameTypeInclusionDirection
DTAI_szErrorMessageSTRINGOPTIONALOUT
DOCO_mnDocumentOrderInvoiceEINTEGERREQUIREDIN
DCTO_szOrderTypeUDCREQUIREDIN
KCOO_szCompanyKeyOrderNoCOMPANYREQUIREDIN
MATH01_mnTotalLinesFLOATOPTIONALOUT
MATH01_mnOpenLinesFLOATOPTIONALOUT
MATH01_mnCanceledLinesFLOATOPTIONALOUT
SFXO_szOrderSuffixSTRINGOPTIONALOUT
MCU_szCostCenterBUSINESSUNITOPTIONALOUT
CO_szCompanyCOMPANYOPTIONALOUT
OKCO_szCompanyKeyOriginalCOMPANYOPTIONALOUT
OORN_szOriginalPoSoNumberSTRINGOPTIONALOUT
OCTO_szOriginalOrderTypeUDCOPTIONALOUT
RKCO_szCompanyKeyRelatedCOMPANYOPTIONALOUT
RORN_szRelatedPoSoNumberSTRINGOPTIONALOUT
RCTO_szRelatedOrderTypeUDCOPTIONALOUT
AN8_mnAddressNumberADDRESSNUMBEROPTIONALOUT
SHAN_mnAddressNumberShipToADDRESSNUMBEROPTIONALOUT
PA8_mnAddressNumberParentADDRESSNUMBEROPTIONALOUT
DRQJ_jdDateRequestedJulianDATEOPTIONALOUT
TRDJ_jdDateTransactionJulianDATEOPTIONALOUT
PDDJ_jdScheduledPickDateDATEOPTIONALOUT
OPDJ_jdDateOriginalPromisdeDATEOPTIONALOUT
ADDJ_jdActualShipDateDATEOPTIONALOUT
CNDJ_jdCancelDateDATEOPTIONALOUT
PEFJ_jdDatePriceEffectiveDateDATEOPTIONALOUT
PPDJ_jdDatePromisedShipJuDATEOPTIONALOUT
VR01_szReference1STRINGOPTIONALOUT
VR02_szReference2VendorSTRINGOPTIONALOUT
DEL1_szDeliveryInstructLine1STRINGOPTIONALOUT
DEL2_szDeliveryInstructLine2STRINGOPTIONALOUT
INMG_szPrintMessage1UDCOPTIONALOUT
PTC_szPaymentTermsCode01STRINGOPTIONALOUT
RYIN_cPaymentInstrumentAUDCOPTIONALOUT
ASN_szPriceAdjustmentScheduleNUDCOPTIONALOUT
PRGP_szPricingGroupUDCOPTIONALOUT
TRDC_mnDiscountTradeFLOATOPTIONALOUT
PCRT_mnPercentRetainage1FLOATOPTIONALOUT
TXA1_szTaxArea1STRINGOPTIONALOUT
EXR1_szTaxExplanationCode1UDCOPTIONALOUT
TXCT_szCertificateTaxExemptSTRINGOPTIONALOUT
ATXT_cAssociatedTextCHARACTEROPTIONALOUT
PRIO_cPriorityProcessingUDCOPTIONALOUT
BACK_cBackordersAllowedYNCHARACTEROPTIONALOUT
SBAL_cSubstitutesAllowedYNCHARACTEROPTIONALOUT
NTR_szNatureOfTransactionUDCOPTIONALOUT
ANBY_mnBuyerNumberADDRESSNUMBEROPTIONALOUT
CARS_mnCarrierADDRESSNUMBEROPTIONALOUT
MOT_szModeOfTransportUDCOPTIONALOUT
COT_szConditionsOfTransportUDCOPTIONALOUT
ROUT_szRouteCodeUDCOPTIONALOUT
STOP_szStopCodeUDCOPTIONALOUT
ZON_szZoneNumberUDCOPTIONALOUT
CNID_szContainerIDSTRINGOPTIONALOUT
FRTH_szFreightHandlingCodeUDCOPTIONALOUT
AFT_cApplyFreightYNCHARACTEROPTIONALOUT
RCD_szReasonCodeUDCOPTIONALOUT
OTOT_mnAmountOrderGrossFLOATOPTIONALOUT
TOTC_mnAmountTotalCostFLOATOPTIONALOUT
WUMD_szUnitOfMeasureWhtDispUDCOPTIONALOUT
VUMD_szUnitOfMeasureVolDispUDCOPTIONALOUT
AUTN_szAuthorizationNoCreditSTRINGOPTIONALOUT
CACT_szAcctNoCrBankSTRINGOPTIONALOUT
CEXP_jdDateExpiredDATEOPTIONALOUT
CRMD_cCorrespondenceMethodUDCOPTIONALOUT
CRRM_cCurrencyModeUDCOPTIONALOUT
CRCD_szCurrencyCodeFromSTRINGOPTIONALOUT
CRR_mnCurrencyConverRateOvFLOATOPTIONALOUT
LNGP_szLanguagePreferenceUDCOPTIONALOUT
FAP_mnAmountForeignOpenFLOATOPTIONALOUT
FCST_mnAmountForeignTotalCFLOATOPTIONALOUT
ORBY_szOrderedBySTRINGOPTIONALOUT
TKBY_szOrderTakenBySTRINGOPTIONALOUT
URCD_szUserReservedCodeSTRINGOPTIONALOUT
URDT_jdUserReservedDateDATEOPTIONALOUT
URAT_mnUserReservedAmountFLOATOPTIONALOUT
URAB_mnUserReservedNumberINTEGEROPTIONALOUT
URRF_szUserReservedReferenceSTRINGOPTIONALOUT
IR01_szIntegrationReference01STRINGOPTIONALOUT
IR02_szIntegrationReference02STRINGOPTIONALOUT
IR03_szIntegrationReference03STRINGOPTIONALOUT
IR04_szIntegrationReference04STRINGOPTIONALOUT
IR05_szIntegrationReference05STRINGOPTIONALOUT
VR03_szReferenceUCISNoSTRINGOPTIONALOUT
SOOR_mnSourceOfOrderINTEGEROPTIONALOUT
PMDT_mnScheduledShipmentTimeINTEGEROPTIONALOUT
RSDT_mnPromisedDeliveryTimeINTEGEROPTIONALOUT
RQSJ_jdDateRequestedShipDATEOPTIONALOUT
PSTM_mnTimeFuture2INTEGEROPTIONALOUT
PDTT_mnPromisedPickTimeINTEGEROPTIONALOUT
OPTT_mnTimeOriginalPromisedINTEGEROPTIONALOUT
DRQT_mnRequestedDeliveryTimeINTEGEROPTIONALOUT
ADTM_mnActualShipmentTimeINTEGEROPTIONALOUT
ADLJ_jdDateActualDeliveryDATEOPTIONALOUT
PBAN_mnAddressNumberPaidByINTEGEROPTIONALOUT
ITAN_mnAddressNumberInvoicedToINTEGEROPTIONALOUT
FTAN_mnAddressNumberFwdedToINTEGEROPTIONALOUT
DVAN_mnAddressNumberDelivedToADDRESSNUMBEROPTIONALOUT
DOC1_mnDocumentOrderInvoiINTEGEROPTIONALOUT
DCT4_szDoctTypeUDCOPTIONALOUT
CORD_mnNumberChangeOrderINTEGEROPTIONALOUT
BSC_szBuyingSegmentCodeUDCOPTIONALOUT
BCRC_szCurrencyCodeBaseSTRINGOPTIONALOUT
HOLD_szHoldOrdersCodeUDCOPTIONALOUT
FUF1_cApplyFreightUDCOPTIONALOUT
AUFT_cAddressNumberForTaxUDCOPTIONALOUT
AUFI_cAddressNumberForTransporUDCOPTIONALOUT
OPBO_szOPBusinessObjectiveUDCOPTIONALOUT
OPTC_mnOPTotalCostFLOATOPTIONALOUT
OPLD_jdOPLatestLineDateDATEOPTIONALOUT
OPBK_mnOPNumberofBackordersINTEGEROPTIONALOUT
OPSB_mnOPNumberofSubstitutesINTEGEROPTIONALOUT
OPPS_szOPPromisedStatusSTRINGOPTIONALOUT
OPPL_cOPPartialOrderShipmentCHARACTEROPTIONALOUT
OPMS_cOPAllowMultiSourceCHARACTEROPTIONALOUT
OPSS_cOPAllowSubstitutesCHARACTEROPTIONALOUT
OPBA_cOPAllowBackordersCHARACTEROPTIONALOUT
OPLL_cOPPartialShipLineItemsCHARACTEROPTIONALOUT
PRAN8_mnPartnerAddressNumberINTEGEROPTIONALOUT
PRCIDLN_mnPartnerContactLineNoINTEGEROPTIONALOUT
OPPID_mnOpportunityIdINTEGEROPTIONALOUT
CCIDLN_mnCustomerContactLineNoINTEGEROPTIONALOUT
SDATTN_szSoldToAttentionSTRINGOPTIONALOUT
SHCCIDLN_mnShipToCusContactNoINTEGEROPTIONALOUT
SPATTN_szShipToAttentionSTRINGOPTIONALOUT
OTIND_cOrderTypeIndicatorCHARACTEROPTIONALOUT
SBLI_cSubledgerInactiveCodeUDCOPTIONALOUT
FUF2_cPostQuantitiesCHARACTEROPTIONALOUT
MORD_cMergeOrdersYNCHARACTEROPTIONALOUT
FRTC_cFreightCalculatedYNCHARACTEROPTIONALOUT
PLST_cPricePickListYNCHARACTEROPTIONALOUT
INVC_mnInvoiceCopiesINTEGEROPTIONALOUT
LNID_mnFirstLineNumberFLOATOPTIONALOUT
LNID_mnLastLineNumberFLOATOPTIONALOUT
JavaScript errors detected

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

If this problem persists, please contact our support.