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 |