Q35GetSalesOrderDetailLine
Cantara Business Function
Called By
This function is called by the following Q35 functions.
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 |
LNID_mnLineNumber | FLOAT | OPTIONAL | BOTH |
LNID_mnNextLineNumber | 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 |
OGNO_mnOriginalLineNumber | FLOAT | OPTIONAL | OUT |
RKCO_szCompanyKeyRelated | COMPANY | OPTIONAL | OUT |
RORN_szRelatedPoSoNumber | STRING | OPTIONAL | OUT |
RCTO_szRelatedOrderType | UDC | OPTIONAL | OUT |
RLLN_mnRelatedPoSoLineNo | FLOAT | OPTIONAL | OUT |
DMCT_szContractNumberDistrib | STRING | OPTIONAL | OUT |
DMCS_mnContractSupplementDist | INTEGER | 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 |
IVD_jdDateInvoiceJulian | DATE | OPTIONAL | OUT |
CNDJ_jdCancelDate | DATE | OPTIONAL | OUT |
DGL_jdDtForGLAndVouch1 | DATE | OPTIONAL | OUT |
RSDJ_jdDateReleaseJulian | DATE | OPTIONAL | OUT |
PEFJ_jdDatePriceEffectiveDate | DATE | OPTIONAL | OUT |
PPDJ_jdDatePromisedShipJu | DATE | OPTIONAL | OUT |
VR01_szReference1 | STRING | OPTIONAL | OUT |
VR02_szReference2Vendor | STRING | OPTIONAL | OUT |
ITM_mnIdentifierShortItem | SHORTITEM | OPTIONAL | OUT |
LITM_szIdentifier2ndItem | STRING | OPTIONAL | OUT |
AITM_szIdentifier3rdItem | STRING | OPTIONAL | OUT |
LOCN_szLocation | LOCATION | OPTIONAL | OUT |
LOTN_szLot | STRING | OPTIONAL | OUT |
FRGD_szFromGrade | UDC | OPTIONAL | OUT |
THGD_szThruGrade | UDC | OPTIONAL | OUT |
FRMP_mnFromPotency | FLOAT | OPTIONAL | OUT |
THRP_mnThruPotency | FLOAT | OPTIONAL | OUT |
EXDP_mnDaysPastExpiration | INTEGER | OPTIONAL | OUT |
DSC1_szDescriptionLine1 | STRING | OPTIONAL | OUT |
DSC2_szDescriptionLine2 | STRING | OPTIONAL | OUT |
LNTY_szLineType | STRING | OPTIONAL | OUT |
NXTR_szStatusCodeNext | UDC | OPTIONAL | OUT |
LTTR_szStatusCodeLast | UDC | OPTIONAL | OUT |
EMCU_szCostCenterHeader | BUSINESSUNIT | OPTIONAL | OUT |
RLIT_szItemNumberRelatedKit | STRING | OPTIONAL | OUT |
KTLN_mnLineNumberKitMaster | FLOAT | OPTIONAL | OUT |
CPNT_mnComponentNumber | FLOAT | OPTIONAL | OUT |
RKIT_mnRelatedKitComponent | INTEGER | OPTIONAL | OUT |
KTP_mnNumbOfCpntPerParent | INTEGER | OPTIONAL | OUT |
SRP1_szSalesReportingCode1 | UDC | OPTIONAL | OUT |
SRP2_szSalesReportingCode2 | UDC | OPTIONAL | OUT |
SRP3_szSalesReportingCode3 | UDC | OPTIONAL | OUT |
SRP4_szSalesReportingCode4 | UDC | OPTIONAL | OUT |
SRP5_szSalesReportingCode5 | UDC | OPTIONAL | OUT |
PRP1_szPurchasingReportCode1 | UDC | OPTIONAL | OUT |
PRP2_szPurchasingReportCode2 | UDC | OPTIONAL | OUT |
PRP3_szPurchasingReportCode3 | UDC | OPTIONAL | OUT |
PRP4_szPurchasingReportCode4 | UDC | OPTIONAL | OUT |
PRP5_szPurchasingReportCode5 | UDC | OPTIONAL | OUT |
UOM_szUnitOfMeasureAsInput | UDC | OPTIONAL | OUT |
UORG_mnUnitsTransactionQty | INTEGER | OPTIONAL | OUT |
SOQS_mnUnitsQuantityShipped | INTEGER | OPTIONAL | OUT |
SOBK_mnUnitsQuanBackorHeld | INTEGER | OPTIONAL | OUT |
SOCN_mnUnitsQuantityCanceled | INTEGER | OPTIONAL | OUT |
SONE_mnUnitsQuantityFuture | INTEGER | OPTIONAL | OUT |
UOPN_mnUnitsOpenQuantity | INTEGER | OPTIONAL | OUT |
QTYT_mnQuantityShippedToDate | INTEGER | OPTIONAL | OUT |
QRLV_mnQuantityRelieved | INTEGER | OPTIONAL | OUT |
COMM_cCommittedHS | UDC | OPTIONAL | OUT |
OTQY_cOtherQuantity12 | CHARACTER | OPTIONAL | OUT |
UPRC_mnAmtPricePerUnit2 | FLOAT | OPTIONAL | OUT |
AEXP_mnAmountExtendedPrice | FLOAT | OPTIONAL | OUT |
AOPN_mnAmountOpen1 | FLOAT | OPTIONAL | OUT |
PROV_cPriceOverrideCode | CHARACTER | OPTIONAL | OUT |
TPC_cTemporaryPriceYN | CHARACTER | OPTIONAL | OUT |
APUM_szUnitOfMeasureEntUP | UDC | OPTIONAL | OUT |
LPRC_mnAmtListPricePerUnit | FLOAT | OPTIONAL | OUT |
UNCS_mnAmountUnitCost | FLOAT | OPTIONAL | OUT |
ECST_mnAmountExtendedCost | FLOAT | OPTIONAL | OUT |
CSTO_cCostOverrideCode | CHARACTER | OPTIONAL | OUT |
TCST_mnExtendedCostTransfer | FLOAT | OPTIONAL | OUT |
INMG_szPrintMessage1 | UDC | OPTIONAL | OUT |
PTC_szPaymentTermsCode01 | STRING | OPTIONAL | OUT |
RYIN_cPaymentInstrumentA | UDC | OPTIONAL | OUT |
DTBS_cBasedonDate | UDC | OPTIONAL | OUT |
TRDC_mnDiscountTrade | FLOAT | OPTIONAL | OUT |
FUN2_mnTradeDiscountOld | FLOAT | OPTIONAL | OUT |
ASN_szPriceAdjustmentScheduleN | UDC | OPTIONAL | OUT |
PRGR_szPricingCategory | UDC | OPTIONAL | OUT |
CLVL_szPricingCategoryLevel1 | STRING | OPTIONAL | OUT |
CADC_mnDiscountCash | FLOAT | OPTIONAL | OUT |
KCO_szCompanyKey | COMPANY | OPTIONAL | OUT |
DOC_mnDocVoucherInvoiceE | INTEGER | OPTIONAL | OUT |
DCT_szDocumentType | UDC | OPTIONAL | OUT |
ODOC_mnOriginalDocumentNo | INTEGER | OPTIONAL | OUT |
ODCT_szOriginalDocumentType | UDC | OPTIONAL | OUT |
OKC_szDocumentCompanyOriginal | COMPANY | OPTIONAL | OUT |
PSN_mnPickSlipNumber | INTEGER | OPTIONAL | OUT |
DELN_mnDeliveryNumber | INTEGER | OPTIONAL | OUT |
TAX1_cTaxableYN | UDC | OPTIONAL | OUT |
TXA1_szTaxArea1 | STRING | OPTIONAL | OUT |
EXR1_szTaxExplanationCode1 | UDC | OPTIONAL | OUT |
ATXT_cAssociatedText | CHARACTER | OPTIONAL | OUT |
PRIO_cPriorityProcessing | UDC | OPTIONAL | OUT |
RESL_cResolutionCodeBC | CHARACTER | OPTIONAL | OUT |
BACK_cBackordersAllowedYN | CHARACTER | OPTIONAL | OUT |
SBAL_cSubstitutesAllowedYN | CHARACTER | OPTIONAL | OUT |
APTS_cPartialShipmntsAllowY | CHARACTER | OPTIONAL | OUT |
LOB_szLineofBusiness | UDC | OPTIONAL | OUT |
EUSE_szEndUse | UDC | OPTIONAL | OUT |
DTYS_szDutyStatus | UDC | OPTIONAL | OUT |
NTR_szNatureOfTransaction | UDC | OPTIONAL | OUT |
VEND_mnPrimaryLastVendorNo | ADDRESSNUMBER | 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 |
FUF1_cApplyFreight | UDC | OPTIONAL | OUT |
FRTC_cFreightCalculatedYN | CHARACTER | OPTIONAL | OUT |
SHCM_szShippingCommodityClass | UDC | OPTIONAL | OUT |
SHCN_szShippingConditionsCode | UDC | OPTIONAL | OUT |
SERN_szSerialNumberLot | STRING | OPTIONAL | OUT |
UOM1_szUnitOfMeasurePrimary | UDC | OPTIONAL | OUT |
PQOR_mnUnitsPrimaryQtyOrder | INTEGER | OPTIONAL | OUT |
UOM2_szUnitOfMeasureSecondary | UDC | OPTIONAL | OUT |
SQOR_mnUnitsSecondaryQtyOr | INTEGER | OPTIONAL | OUT |
UOM4_szUnitOfMeasurePricing | UDC | OPTIONAL | OUT |
ITWT_mnAmountUnitWeight | FLOAT | OPTIONAL | OUT |
WTUM_szWeightUnitOfMeasure | UDC | OPTIONAL | OUT |
ITVL_mnAmountUnitVolume | FLOAT | OPTIONAL | OUT |
VLUM_szVolumeUnitOfMeasure | UDC | OPTIONAL | OUT |
RPRC_szRepriceBasketPriceCat | UDC | OPTIONAL | OUT |
ORPR_szOrderRepriceCategory | UDC | OPTIONAL | OUT |
ORP_cOrderRepricedIndicator | CHARACTER | OPTIONAL | OUT |
CMGP_szInventoryCostingMeth | STRING | OPTIONAL | OUT |
GLC_szGlClass | STRING | OPTIONAL | OUT |
CTRY_mnCentury | INTEGER | OPTIONAL | OUT |
FY_mnFiscalYear1 | INTEGER | OPTIONAL | OUT |
SO01_cSalesOrderStatus01 | CHARACTER | OPTIONAL | OUT |
SO02_cSalesOrderStatus02 | CHARACTER | OPTIONAL | OUT |
SO03_cSalesOrderStatus03 | CHARACTER | OPTIONAL | OUT |
SO04_cSalesOrderStatus04 | CHARACTER | OPTIONAL | OUT |
SO05_cSalesOrderStatus05 | CHARACTER | OPTIONAL | OUT |
SO06_cSalesOrderStatus06 | CHARACTER | OPTIONAL | OUT |
SO07_cSalesOrderStatus07 | CHARACTER | OPTIONAL | OUT |
SO08_cSalesOrderStatus08 | CHARACTER | OPTIONAL | OUT |
SO09_cSalesOrderStatus09 | CHARACTER | OPTIONAL | OUT |
SO10_cSalesOrderStatus10 | CHARACTER | OPTIONAL | OUT |
SO11_cSalesOrderStatus11 | CHARACTER | OPTIONAL | OUT |
SO12_cSalesOrderStatus12 | CHARACTER | OPTIONAL | OUT |
SO13_cSalesOrderStatus13 | CHARACTER | OPTIONAL | OUT |
SO14_cSalesOrderStatus14 | CHARACTER | OPTIONAL | OUT |
SO15_cSalesOrderStatus15 | CHARACTER | OPTIONAL | OUT |
ACOM_cApplyCommissionYN | CHARACTER | OPTIONAL | OUT |
CMCG_szCommissionCategory | STRING | OPTIONAL | OUT |
RCD_szReasonCode | UDC | OPTIONAL | OUT |
GRWT_mnGrossWeight | FLOAT | OPTIONAL | OUT |
GWUM_szUnitOfMeasureGrossWt | UDC | OPTIONAL | OUT |
SBL_szSubledger | STRING | OPTIONAL | OUT |
SBLT_cSubledgerType | UDC | OPTIONAL | OUT |
LCOD_szCodeLocationTaxStat | UDC | OPTIONAL | OUT |
UPC1_szPriceCode1 | UDC | OPTIONAL | OUT |
UPC2_szPriceCode2 | UDC | OPTIONAL | OUT |
UPC3_szPriceCode3 | UDC | OPTIONAL | OUT |
SWMS_cStatusInWarehouse | CHARACTER | OPTIONAL | OUT |
UNCD_cWoOrderFreezeCode | UDC | OPTIONAL | OUT |
CRMD_cCorrespondenceMethod | UDC | OPTIONAL | OUT |
CRCD_szCurrencyCodeFrom | STRING | OPTIONAL | OUT |
CRR_mnCurrencyConverRateOv | FLOAT | OPTIONAL | OUT |
FPRC_mnAmountListPriceForeign | FLOAT | OPTIONAL | OUT |
FUP_mnAmtForPricePerUnit | FLOAT | OPTIONAL | OUT |
FEA_mnAmountForeignExtPrice | FLOAT | OPTIONAL | OUT |
FUC_mnAmountForeignUnitCost | FLOAT | OPTIONAL | OUT |
FEC_mnAmountForeignExtCost | FLOAT | 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 |
TORG_szTransactionOriginator | 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 |
SOOR_mnSourceOfOrder | INTEGER | OPTIONAL | OUT |
DEID_mnDemandUniqueKey | INTEGER | OPTIONAL | OUT |
PSIG_szPullSignal | STRING | OPTIONAL | OUT |
RLNU_szReleaseNumber | STRING | OPTIONAL | OUT |
PMDT_mnScheduledShipmentTime | INTEGER | OPTIONAL | OUT |
RLTM_mnTimeRelease | INTEGER | OPTIONAL | OUT |
RLDJ_jdDateRelease | DATE | OPTIONAL | OUT |
DRQT_mnRequestedDeliveryTime | INTEGER | OPTIONAL | OUT |
ADTM_mnActualShipmentTime | INTEGER | OPTIONAL | OUT |
OPTT_mnTimeOriginalPromised | INTEGER | OPTIONAL | OUT |
PDTT_mnPromisedPickTime | INTEGER | OPTIONAL | OUT |
PSTM_mnTimeFuture2 | INTEGER | OPTIONAL | OUT |
PMTN_szPromotionID | STRING | OPTIONAL | OUT |
BSC_szBuyingSegmentCode | UDC | OPTIONAL | OUT |
CBSC_szCurrentBuyingSegmentCD | UDC | OPTIONAL | OUT |
DVAN_mnAddressNumberDelivedTo | ADDRESSNUMBER | OPTIONAL | OUT |
RFRV_szRevisionReason | UDC | OPTIONAL | OUT |
SHPN_mnShipmentNumber | INTEGER | OPTIONAL | OUT |
PRJM_mnProjectNumber | INTEGER | OPTIONAL | OUT |
HOLD_szHoldOrdersCode | UDC | OPTIONAL | OUT |
PMTO_cPaymentTermsOverride | CHARACTER | OPTIONAL | OUT |
DUAL_cDualUnitOfMeasureItem | CHARACTER | OPTIONAL | OUT |
PMPN_szProductionNumber | STRING | OPTIONAL | OUT |
SHCCIDLN_mnShipToCusContactNo | INTEGER | OPTIONAL | OUT |
OPPID_mnOpportunityId | INTEGER | OPTIONAL | OUT |
SPATTN_szShipToAttention | STRING | OPTIONAL | OUT |
CATNM_szCatalogName | STRING | OPTIONAL | OUT |
OSTP_szOrganizationTypeStruct | UDC | OPTIONAL | OUT |
SO16_cSalesOrderStatus16 | CHARACTER | OPTIONAL | OUT |
SO17_cSalesOrderStatus17 | CHARACTER | OPTIONAL | OUT |
SO18_cSalesOrderStatus18 | CHARACTER | OPTIONAL | OUT |
SO19_cSalesOrderStatus19 | CHARACTER | OPTIONAL | OUT |
SO20_cSalesOrderStatus20 | CHARACTER | OPTIONAL | OUT |
VR03_szReferenceUCISNo | STRING | OPTIONAL | OUT |
XDCK_cCrossDockFlag | CHARACTER | OPTIONAL | OUT |
XPTY_mnCrossDockingPriority | INTEGER | OPTIONAL | OUT |
CORD_mnNumberChangeOrder | INTEGER | OPTIONAL | OUT |
PEND_cPendingApprovalFlag | CHARACTER | OPTIONAL | OUT |
MCLN_mnMatrixControlLine | FLOAT | OPTIONAL | OUT |
RSDT_mnPromisedDeliveryTime | INTEGER | OPTIONAL | OUT |
OSEQ_mnSequenceNumber | INTEGER | OPTIONAL | OUT |
MERL_szMeRevisionLevel | STRING | OPTIONAL | OUT |
HDBU_szBusinessUnitHeader9 | BUSINESSUNIT | OPTIONAL | OUT |
DMBU_szBusinessUnitDemand | BUSINESSUNIT | OPTIONAL | OUT |
BCRC_szCurrencyCodeBase | STRING | OPTIONAL | OUT |
ODLN_mnOriginalDocumentLineNo | FLOAT | OPTIONAL | OUT |
XKCO_szCrossDockCmpyKeyOrderNo | COMPANY | OPTIONAL | OUT |
XORN_mnCrossDockOrderNumber | INTEGER | OPTIONAL | OUT |
XCTO_szCrossDockOrderType | UDC | OPTIONAL | OUT |
XLLN_mnCrossDockLineNumber | FLOAT | OPTIONAL | OUT |
POE_szPortOfEntryExit | UDC | OPTIONAL | OUT |
NUMB_mnAssetItemNumber | ASSETNUMBER | OPTIONAL | OUT |
AAID_mnParentNumber | INTEGER | OPTIONAL | OUT |
PRAN8_mnPartnerAddressNumber | INTEGER | OPTIONAL | OUT |
PRCIDLN_mnPartnerContactLineNo | INTEGER | OPTIONAL | OUT |
CCIDLN_mnCustomerContactLineNo | INTEGER | OPTIONAL | OUT |
UKID_mnUniqueKeyIDInternal | INTEGER | OPTIONAL | OUT |
ALLOC_cAllocationFlag | CHARACTER | OPTIONAL | OUT |
FULPID_mnFulfillmentPlanID | INTEGER | OPTIONAL | OUT |
ALLSTS_szAllocationStatus | UDC | OPTIONAL | OUT |
OSCORE_mnOrderScore | FLOAT | OPTIONAL | OUT |
OSCOREO_cScoreOverride | CHARACTER | OPTIONAL | OUT |
CMCO_szCustomerMasterCompany | STRING | OPTIONAL | OUT |
KITID_mnKitIdentifier | INTEGER | OPTIONAL | OUT |
KITAMTDOM_mnAccumulatedAmtInv | FLOAT | OPTIONAL | OUT |
KITAMTFOR_mnAccumulatedAmtInv | FLOAT | OPTIONAL | OUT |
KITDIRTY_cKitComponentDirtyFlg | CHARACTER | OPTIONAL | OUT |
OCITT_cOCInTransitFlag | CHARACTER | OPTIONAL | OUT |
OCCARDNO_mnOCKanbanCardNo | INTEGER | OPTIONAL | OUT |
PNS_mnProductionNumberShort | INTEGER | OPTIONAL | OUT |
XSFX_szCrossDockOrderSuffix | STRING | OPTIONAL | OUT |