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.

Called By

This function is called by the following Q35 functions.

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