Q35GetSalesOrderDetailLine

Cantara Business Function

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

FLOAT

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

FLOAT

OPTIONAL

OUT

SOQS_mnUnitsQuantityShipped

FLOAT

OPTIONAL

OUT

SOBK_mnUnitsQuanBackorHeld

FLOAT

OPTIONAL

OUT

SOCN_mnUnitsQuantityCanceled

FLOAT

OPTIONAL

OUT

SONE_mnUnitsQuantityFuture

FLOAT

OPTIONAL

OUT

UOPN_mnUnitsOpenQuantity

FLOAT

OPTIONAL

OUT

QTYT_mnQuantityShippedToDate

FLOAT

OPTIONAL

OUT

QRLV_mnQuantityRelieved

FLOAT

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

FLOAT

OPTIONAL

OUT

UOM2_szUnitOfMeasureSecondary

UDC

OPTIONAL

OUT

SQOR_mnUnitsSecondaryQtyOr

FLOAT

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