Q35GetSalesOrderDetailLine

Cantara Business Function to retrieve details of Sales Order Lines from JDE Table F4211.

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