Q35GetSalesOrderDetailLine

Cantara Business Function

Called By

This function is called by the following Q35 functions.

Q35CompareSalesOrderDetailLine

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