Q35CompareSalesOrderDetailLine

Cantara Business Function

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	FLOAT	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	FLOAT	OPTIONAL	BOTH
SOQS_mnUnitsQuantityShipped	FLOAT	OPTIONAL	BOTH
SOBK_mnUnitsQuanBackorHeld	FLOAT	OPTIONAL	BOTH
SOCN_mnUnitsQuantityCanceled	FLOAT	OPTIONAL	BOTH
SONE_mnUnitsQuantityFuture	FLOAT	OPTIONAL	BOTH
UOPN_mnUnitsOpenQuantity	FLOAT	OPTIONAL	BOTH
QTYT_mnQuantityShippedToDate	FLOAT	OPTIONAL	BOTH
QRLV_mnQuantityRelieved	FLOAT	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	FLOAT	OPTIONAL	BOTH
UOM2_szUnitOfMeasureSecondary	UDC	OPTIONAL	BOTH
SQOR_mnUnitsSecondaryQtyOr	FLOAT	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

×