Q35CompareSalesOrderDetailLine

Cantara Business Function to retrieve details from F4211 optionally replacing some fields with passed in values.

Calls

This function calls the following Q35 functions.

Q35GetSalesOrderDetailLine

Called By

This function is called by the following Q35 functions.

Q35CreateSalesOrderDetailLine

Data Structure

Name	Type	Inclusion	Direction
KCOO_szCompanyKeyOrderNo	COMPANY	OPTIONAL	BOTH
DOCO_mnDocumentOrderInvoiceE	INTEGER	OPTIONAL	BOTH
DCTO_szOrderType	UDC	OPTIONAL	BOTH
SFXO_szOrderSuffix	STRING	OPTIONAL	BOTH
MCU_szCostCenter	BUSINESSUNIT	OPTIONAL	BOTH
CO_szCompany	COMPANY	OPTIONAL	BOTH
OKCO_szCompanyKeyOriginal	COMPANY	OPTIONAL	BOTH
OORN_szOriginalPoSoNumber	STRING	OPTIONAL	BOTH
OCTO_szOriginalOrderType	UDC	OPTIONAL	BOTH
OGNO_mnOriginalLineNumber	FLOAT	OPTIONAL	BOTH
RKCO_szCompanyKeyRelated	COMPANY	OPTIONAL	BOTH
RORN_szRelatedPoSoNumber	STRING	OPTIONAL	BOTH
RCTO_szRelatedOrderType	UDC	OPTIONAL	BOTH
RLLN_mnRelatedPoSoLineNo	FLOAT	OPTIONAL	BOTH
DMCT_szContractNumberDistrib	STRING	OPTIONAL	BOTH
DMCS_mnContractSupplementDist	INTEGER	OPTIONAL	BOTH
AN8_mnAddressNumber	ADDRESSNUMBER	OPTIONAL	BOTH
SHAN_mnAddressNumberShipTo	ADDRESSNUMBER	OPTIONAL	BOTH
PA8_mnAddressNumberParent	ADDRESSNUMBER	OPTIONAL	BOTH
DRQJ_jdDateRequestedJulian	DATE	OPTIONAL	BOTH
TRDJ_jdDateTransactionJulian	DATE	OPTIONAL	BOTH
PDDJ_jdScheduledPickDate	DATE	OPTIONAL	BOTH
OPDJ_jdDateOriginalPromisde	DATE	OPTIONAL	BOTH
ADDJ_jdActualShipDate	DATE	OPTIONAL	BOTH
IVD_jdDateInvoiceJulian	DATE	OPTIONAL	BOTH
CNDJ_jdCancelDate	DATE	OPTIONAL	BOTH
DGL_jdDtForGLAndVouch1	DATE	OPTIONAL	BOTH
RSDJ_jdDateReleaseJulian	DATE	OPTIONAL	BOTH
PEFJ_jdDatePriceEffectiveDate	DATE	OPTIONAL	BOTH
PPDJ_jdDatePromisedShipJu	DATE	OPTIONAL	BOTH
VR01_szReference1	STRING	OPTIONAL	BOTH
VR02_szReference2Vendor	STRING	OPTIONAL	BOTH
ITM_mnIdentifierShortItem	SHORTITEM	OPTIONAL	BOTH
LITM_szIdentifier2ndItem	STRING	OPTIONAL	BOTH
AITM_szIdentifier3rdItem	STRING	OPTIONAL	BOTH
LOCN_szLocation	LOCATION	OPTIONAL	BOTH
LOTN_szLot	STRING	OPTIONAL	BOTH
FRGD_szFromGrade	UDC	OPTIONAL	BOTH
THGD_szThruGrade	UDC	OPTIONAL	BOTH
FRMP_mnFromPotency	FLOAT	OPTIONAL	BOTH
THRP_mnThruPotency	FLOAT	OPTIONAL	BOTH
EXDP_mnDaysPastExpiration	INTEGER	OPTIONAL	BOTH
DSC1_szDescriptionLine1	STRING	OPTIONAL	BOTH
DSC2_szDescriptionLine2	STRING	OPTIONAL	BOTH
LNTY_szLineType	STRING	OPTIONAL	BOTH
NXTR_szStatusCodeNext	UDC	OPTIONAL	BOTH
LTTR_szStatusCodeLast	UDC	OPTIONAL	BOTH
EMCU_szCostCenterHeader	BUSINESSUNIT	OPTIONAL	BOTH
RLIT_szItemNumberRelatedKit	STRING	OPTIONAL	BOTH
KTLN_mnLineNumberKitMaster	FLOAT	OPTIONAL	BOTH
CPNT_mnComponentNumber	FLOAT	OPTIONAL	BOTH
RKIT_mnRelatedKitComponent	INTEGER	OPTIONAL	BOTH
KTP_mnNumbOfCpntPerParent	INTEGER	OPTIONAL	BOTH
SRP1_szSalesReportingCode1	UDC	OPTIONAL	BOTH
SRP2_szSalesReportingCode2	UDC	OPTIONAL	BOTH
SRP3_szSalesReportingCode3	UDC	OPTIONAL	BOTH
SRP4_szSalesReportingCode4	UDC	OPTIONAL	BOTH
SRP5_szSalesReportingCode5	UDC	OPTIONAL	BOTH
PRP1_szPurchasingReportCode1	UDC	OPTIONAL	BOTH
PRP2_szPurchasingReportCode2	UDC	OPTIONAL	BOTH
PRP3_szPurchasingReportCode3	UDC	OPTIONAL	BOTH
PRP4_szPurchasingReportCode4	UDC	OPTIONAL	BOTH
PRP5_szPurchasingReportCode5	UDC	OPTIONAL	BOTH
UOM_szUnitOfMeasureAsInput	UDC	OPTIONAL	BOTH
UORG_mnUnitsTransactionQty	INTEGER	OPTIONAL	BOTH
SOQS_mnUnitsQuantityShipped	INTEGER	OPTIONAL	BOTH
SOBK_mnUnitsQuanBackorHeld	INTEGER	OPTIONAL	BOTH
SOCN_mnUnitsQuantityCanceled	INTEGER	OPTIONAL	BOTH
SONE_mnUnitsQuantityFuture	INTEGER	OPTIONAL	BOTH
UOPN_mnUnitsOpenQuantity	INTEGER	OPTIONAL	BOTH
QTYT_mnQuantityShippedToDate	INTEGER	OPTIONAL	BOTH
QRLV_mnQuantityRelieved	INTEGER	OPTIONAL	BOTH
COMM_cCommittedHS	UDC	OPTIONAL	BOTH
OTQY_cOtherQuantity12	CHARACTER	OPTIONAL	BOTH
UPRC_mnAmtPricePerUnit2	FLOAT	OPTIONAL	BOTH
AEXP_mnAmountExtendedPrice	FLOAT	OPTIONAL	BOTH
AOPN_mnAmountOpen1	FLOAT	OPTIONAL	BOTH
TPC_cTemporaryPriceYN	CHARACTER	OPTIONAL	BOTH
APUM_szUnitOfMeasureEntUP	UDC	OPTIONAL	BOTH
LPRC_mnAmtListPricePerUnit	FLOAT	OPTIONAL	BOTH
UNCS_mnAmountUnitCost	FLOAT	OPTIONAL	BOTH
ECST_mnAmountExtendedCost	FLOAT	OPTIONAL	BOTH
CSTO_cCostOverrideCode	CHARACTER	OPTIONAL	BOTH
TCST_mnExtendedCostTransfer	FLOAT	OPTIONAL	BOTH
INMG_szPrintMessage1	UDC	OPTIONAL	BOTH
PTC_szPaymentTermsCode01	STRING	OPTIONAL	BOTH
RYIN_cPaymentInstrumentA	UDC	OPTIONAL	BOTH
DTBS_cBasedonDate	UDC	OPTIONAL	BOTH
TRDC_mnDiscountTrade	FLOAT	OPTIONAL	BOTH
FUN2_mnTradeDiscountOld	FLOAT	OPTIONAL	BOTH
ASN_szPriceAdjustmentScheduleN	UDC	OPTIONAL	BOTH
PRGR_szPricingCategory	UDC	OPTIONAL	BOTH
CLVL_szPricingCategoryLevel1	STRING	OPTIONAL	BOTH
CADC_mnDiscountCash	FLOAT	OPTIONAL	BOTH
KCO_szCompanyKey	COMPANY	OPTIONAL	BOTH
DOC_mnDocVoucherInvoiceE	INTEGER	OPTIONAL	BOTH
DCT_szDocumentType	UDC	OPTIONAL	BOTH
ODOC_mnOriginalDocumentNo	INTEGER	OPTIONAL	BOTH
ODCT_szOriginalDocumentType	UDC	OPTIONAL	BOTH
OKC_szDocumentCompanyOriginal	COMPANY	OPTIONAL	BOTH
PSN_mnPickSlipNumber	INTEGER	OPTIONAL	BOTH
DELN_mnDeliveryNumber	INTEGER	OPTIONAL	BOTH
TAX1_cTaxableYN	UDC	OPTIONAL	BOTH
TXA1_szTaxArea1	STRING	OPTIONAL	BOTH
EXR1_szTaxExplanationCode1	UDC	OPTIONAL	BOTH
ATXT_cAssociatedText	CHARACTER	OPTIONAL	BOTH
PRIO_cPriorityProcessing	UDC	OPTIONAL	BOTH
RESL_cResolutionCodeBC	CHARACTER	OPTIONAL	BOTH
BACK_cBackordersAllowedYN	CHARACTER	OPTIONAL	BOTH
SBAL_cSubstitutesAllowedYN	CHARACTER	OPTIONAL	BOTH
APTS_cPartialShipmntsAllowY	CHARACTER	OPTIONAL	BOTH
LOB_szLineofBusiness	UDC	OPTIONAL	BOTH
DTYS_szDutyStatus	UDC	OPTIONAL	BOTH
NTR_szNatureOfTransaction	UDC	OPTIONAL	BOTH
VEND_mnPrimaryLastVendorNo	ADDRESSNUMBER	OPTIONAL	BOTH
ANBY_mnBuyerNumber	ADDRESSNUMBER	OPTIONAL	BOTH
CARS_mnCarrier	ADDRESSNUMBER	OPTIONAL	BOTH
MOT_szModeOfTransport	UDC	OPTIONAL	BOTH
COT_szConditionsOfTransport	UDC	OPTIONAL	BOTH
ROUT_szRouteCode	UDC	OPTIONAL	BOTH
STOP_szStopCode	UDC	OPTIONAL	BOTH
ZON_szZoneNumber	UDC	OPTIONAL	BOTH
CNID_szContainerID	STRING	OPTIONAL	BOTH
FRTH_szFreightHandlingCode	UDC	OPTIONAL	BOTH
AFT_cApplyFreightYN	CHARACTER	OPTIONAL	BOTH
SHCM_szShippingCommodityClass	UDC	OPTIONAL	BOTH
SHCN_szShippingConditionsCode	UDC	OPTIONAL	BOTH
SERN_szSerialNumberLot	STRING	OPTIONAL	BOTH
UOM1_szUnitOfMeasurePrimary	UDC	OPTIONAL	BOTH
PQOR_mnUnitsPrimaryQtyOrder	INTEGER	OPTIONAL	BOTH
UOM2_szUnitOfMeasureSecondary	UDC	OPTIONAL	BOTH
SQOR_mnUnitsSecondaryQtyOr	INTEGER	OPTIONAL	BOTH
UOM4_szUnitOfMeasurePricing	UDC	OPTIONAL	BOTH
ITWT_mnAmountUnitWeight	FLOAT	OPTIONAL	BOTH
WTUM_szWeightUnitOfMeasure	UDC	OPTIONAL	BOTH
ITVL_mnAmountUnitVolume	FLOAT	OPTIONAL	BOTH
VLUM_szVolumeUnitOfMeasure	UDC	OPTIONAL	BOTH
RPRC_szRepriceBasketPriceCat	UDC	OPTIONAL	BOTH
ORPR_szOrderRepriceCategory	UDC	OPTIONAL	BOTH
ORP_cOrderRepricedIndicator	CHARACTER	OPTIONAL	BOTH
CMGP_szInventoryCostingMeth	STRING	OPTIONAL	BOTH
GLC_szGlClass	STRING	OPTIONAL	BOTH
CTRY_mnCentury	INTEGER	OPTIONAL	BOTH
FY_mnFiscalYear1	INTEGER	OPTIONAL	BOTH
SO01_cSalesOrderStatus01	CHARACTER	OPTIONAL	BOTH
SO02_cSalesOrderStatus02	CHARACTER	OPTIONAL	BOTH
SO03_cSalesOrderStatus03	CHARACTER	OPTIONAL	BOTH
SO04_cSalesOrderStatus04	CHARACTER	OPTIONAL	BOTH
SO05_cSalesOrderStatus05	CHARACTER	OPTIONAL	BOTH
SO06_cSalesOrderStatus06	CHARACTER	OPTIONAL	BOTH
SO07_cSalesOrderStatus07	CHARACTER	OPTIONAL	BOTH
SO08_cSalesOrderStatus08	CHARACTER	OPTIONAL	BOTH
SO09_cSalesOrderStatus09	CHARACTER	OPTIONAL	BOTH
SO10_cSalesOrderStatus10	CHARACTER	OPTIONAL	BOTH
SO11_cSalesOrderStatus11	CHARACTER	OPTIONAL	BOTH
SO12_cSalesOrderStatus12	CHARACTER	OPTIONAL	BOTH
SO13_cSalesOrderStatus13	CHARACTER	OPTIONAL	BOTH
SO14_cSalesOrderStatus14	CHARACTER	OPTIONAL	BOTH
SO15_cSalesOrderStatus15	CHARACTER	OPTIONAL	BOTH
ACOM_cApplyCommissionYN	CHARACTER	OPTIONAL	BOTH
CMCG_szCommissionCategory	STRING	OPTIONAL	BOTH
RCD_szReasonCode	UDC	OPTIONAL	BOTH
GRWT_mnGrossWeight	FLOAT	OPTIONAL	BOTH
GWUM_szUnitOfMeasureGrossWt	UDC	OPTIONAL	BOTH
SBL_szSubledger	STRING	OPTIONAL	BOTH
SBLT_cSubledgerType	UDC	OPTIONAL	BOTH
LCOD_szCodeLocationTaxStat	UDC	OPTIONAL	BOTH
UPC1_szPriceCode1	UDC	OPTIONAL	BOTH
UPC2_szPriceCode2	UDC	OPTIONAL	BOTH
UPC3_szPriceCode3	UDC	OPTIONAL	BOTH
SWMS_cStatusInWarehouse	CHARACTER	OPTIONAL	BOTH
UNCD_cWoOrderFreezeCode	UDC	OPTIONAL	BOTH
CRMD_cCorrespondenceMethod	UDC	OPTIONAL	BOTH
CRCD_szCurrencyCodeFrom	STRING	OPTIONAL	BOTH
CRR_mnCurrencyConverRateOv	FLOAT	OPTIONAL	BOTH
FPRC_mnAmountListPriceForeign	FLOAT	OPTIONAL	BOTH
FUP_mnAmtForPricePerUnit	FLOAT	OPTIONAL	BOTH
FEA_mnAmountForeignExtPrice	FLOAT	OPTIONAL	BOTH
FUC_mnAmountForeignUnitCost	FLOAT	OPTIONAL	BOTH
FEC_mnAmountForeignExtCost	FLOAT	OPTIONAL	BOTH
URCD_szUserReservedCode	STRING	OPTIONAL	BOTH
URDT_jdUserReservedDate	DATE	OPTIONAL	BOTH
URAT_mnUserReservedAmount	FLOAT	OPTIONAL	BOTH
URAB_mnUserReservedNumber	INTEGER	OPTIONAL	BOTH
URRF_szUserReservedReference	STRING	OPTIONAL	BOTH
TORG_szTransactionOriginator	STRING	OPTIONAL	BOTH
IR01_szIntegrationReference01	STRING	OPTIONAL	BOTH
IR02_szIntegrationReference02	STRING	OPTIONAL	BOTH
IR03_szIntegrationReference03	STRING	OPTIONAL	BOTH
IR04_szIntegrationReference04	STRING	OPTIONAL	BOTH
IR05_szIntegrationReference05	STRING	OPTIONAL	BOTH
SOOR_mnSourceOfOrder	INTEGER	OPTIONAL	BOTH
DEID_mnDemandUniqueKey	INTEGER	OPTIONAL	BOTH
PSIG_szPullSignal	STRING	OPTIONAL	BOTH
RLNU_szReleaseNumber	STRING	OPTIONAL	BOTH
PMDT_mnScheduledShipmentTime	INTEGER	OPTIONAL	BOTH
RLTM_mnTimeRelease	INTEGER	OPTIONAL	BOTH
RLDJ_jdDateRelease	DATE	OPTIONAL	BOTH
DRQT_mnRequestedDeliveryTime	INTEGER	OPTIONAL	BOTH
ADTM_mnActualShipmentTime	INTEGER	OPTIONAL	BOTH
OPTT_mnTimeOriginalPromised	INTEGER	OPTIONAL	BOTH
PDTT_mnPromisedPickTime	INTEGER	OPTIONAL	BOTH
PSTM_mnTimeFuture2	INTEGER	OPTIONAL	BOTH
PMTN_szPromotionID	STRING	OPTIONAL	BOTH
BSC_szBuyingSegmentCode	UDC	OPTIONAL	BOTH
CBSC_szCurrentBuyingSegmentCD	UDC	OPTIONAL	BOTH
DVAN_mnAddressNumberDelivedTo	ADDRESSNUMBER	OPTIONAL	BOTH
RFRV_szRevisionReason	UDC	OPTIONAL	BOTH
SHPN_mnShipmentNumber	INTEGER	OPTIONAL	BOTH
PRJM_mnProjectNumber	INTEGER	OPTIONAL	BOTH
HOLD_szHoldOrdersCode	UDC	OPTIONAL	BOTH
PMTO_cPaymentTermsOverride	CHARACTER	OPTIONAL	BOTH
DUAL_cDualUnitOfMeasureItem	CHARACTER	OPTIONAL	BOTH
LNID_mnLineNumber	FLOAT	OPTIONAL	BOTH
FUF1_cApplyFreight	UDC	OPTIONAL	BOTH
FRTC_cFreightCalculatedYN	CHARACTER	OPTIONAL	BOTH
EUSE_szEndUse	UDC	OPTIONAL	BOTH
PMPN_szProductionNumber	STRING	OPTIONAL	BOTH
SHCCIDLN_mnShipToCusContactNo	INTEGER	OPTIONAL	BOTH
OPPID_mnOpportunityId	INTEGER	OPTIONAL	BOTH
SPATTN_szShipToAttention	STRING	OPTIONAL	BOTH
CATNM_szCatalogName	STRING	OPTIONAL	BOTH
OSTP_szOrganizationTypeStruct	UDC	OPTIONAL	BOTH
EV01_cCompareMode	CHARACTER	REQUIRED	IN
SO18_cSalesOrderStatus	CHARACTER	OPTIONAL	BOTH