Skip to main content
Skip table of contents

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.

Data Structure

NameTypeInclusionDirection
DTAI_szErrorMessageSTRINGOPTIONALOUT
DOCO_mnDocumentOrderInvoiceEINTEGERREQUIREDIN
DCTO_szOrderTypeUDCREQUIREDIN
KCOO_szCompanyKeyOrderNoCOMPANYREQUIREDIN
LNID_mnLineNumberFLOATOPTIONALBOTH
LNID_mnNextLineNumberFLOATOPTIONALOUT
SFXO_szOrderSuffixSTRINGOPTIONALOUT
MCU_szCostCenterBUSINESSUNITOPTIONALOUT
CO_szCompanyCOMPANYOPTIONALOUT
OKCO_szCompanyKeyOriginalCOMPANYOPTIONALOUT
OORN_szOriginalPoSoNumberSTRINGOPTIONALOUT
OCTO_szOriginalOrderTypeUDCOPTIONALOUT
OGNO_mnOriginalLineNumberFLOATOPTIONALOUT
RKCO_szCompanyKeyRelatedCOMPANYOPTIONALOUT
RORN_szRelatedPoSoNumberSTRINGOPTIONALOUT
RCTO_szRelatedOrderTypeUDCOPTIONALOUT
RLLN_mnRelatedPoSoLineNoFLOATOPTIONALOUT
DMCT_szContractNumberDistribSTRINGOPTIONALOUT
DMCS_mnContractSupplementDistINTEGEROPTIONALOUT
AN8_mnAddressNumberADDRESSNUMBEROPTIONALOUT
SHAN_mnAddressNumberShipToADDRESSNUMBEROPTIONALOUT
PA8_mnAddressNumberParentADDRESSNUMBEROPTIONALOUT
DRQJ_jdDateRequestedJulianDATEOPTIONALOUT
TRDJ_jdDateTransactionJulianDATEOPTIONALOUT
PDDJ_jdScheduledPickDateDATEOPTIONALOUT
OPDJ_jdDateOriginalPromisdeDATEOPTIONALOUT
ADDJ_jdActualShipDateDATEOPTIONALOUT
IVD_jdDateInvoiceJulianDATEOPTIONALOUT
CNDJ_jdCancelDateDATEOPTIONALOUT
DGL_jdDtForGLAndVouch1DATEOPTIONALOUT
RSDJ_jdDateReleaseJulianDATEOPTIONALOUT
PEFJ_jdDatePriceEffectiveDateDATEOPTIONALOUT
PPDJ_jdDatePromisedShipJuDATEOPTIONALOUT
VR01_szReference1STRINGOPTIONALOUT
VR02_szReference2VendorSTRINGOPTIONALOUT
ITM_mnIdentifierShortItemSHORTITEMOPTIONALOUT
LITM_szIdentifier2ndItemSTRINGOPTIONALOUT
AITM_szIdentifier3rdItemSTRINGOPTIONALOUT
LOCN_szLocationLOCATIONOPTIONALOUT
LOTN_szLotSTRINGOPTIONALOUT
FRGD_szFromGradeUDCOPTIONALOUT
THGD_szThruGradeUDCOPTIONALOUT
FRMP_mnFromPotencyFLOATOPTIONALOUT
THRP_mnThruPotencyFLOATOPTIONALOUT
EXDP_mnDaysPastExpirationINTEGEROPTIONALOUT
DSC1_szDescriptionLine1STRINGOPTIONALOUT
DSC2_szDescriptionLine2STRINGOPTIONALOUT
LNTY_szLineTypeSTRINGOPTIONALOUT
NXTR_szStatusCodeNextUDCOPTIONALOUT
LTTR_szStatusCodeLastUDCOPTIONALOUT
EMCU_szCostCenterHeaderBUSINESSUNITOPTIONALOUT
RLIT_szItemNumberRelatedKitSTRINGOPTIONALOUT
KTLN_mnLineNumberKitMasterFLOATOPTIONALOUT
CPNT_mnComponentNumberFLOATOPTIONALOUT
RKIT_mnRelatedKitComponentINTEGEROPTIONALOUT
KTP_mnNumbOfCpntPerParentINTEGEROPTIONALOUT
SRP1_szSalesReportingCode1UDCOPTIONALOUT
SRP2_szSalesReportingCode2UDCOPTIONALOUT
SRP3_szSalesReportingCode3UDCOPTIONALOUT
SRP4_szSalesReportingCode4UDCOPTIONALOUT
SRP5_szSalesReportingCode5UDCOPTIONALOUT
PRP1_szPurchasingReportCode1UDCOPTIONALOUT
PRP2_szPurchasingReportCode2UDCOPTIONALOUT
PRP3_szPurchasingReportCode3UDCOPTIONALOUT
PRP4_szPurchasingReportCode4UDCOPTIONALOUT
PRP5_szPurchasingReportCode5UDCOPTIONALOUT
UOM_szUnitOfMeasureAsInputUDCOPTIONALOUT
UORG_mnUnitsTransactionQtyINTEGEROPTIONALOUT
SOQS_mnUnitsQuantityShippedINTEGEROPTIONALOUT
SOBK_mnUnitsQuanBackorHeldINTEGEROPTIONALOUT
SOCN_mnUnitsQuantityCanceledINTEGEROPTIONALOUT
SONE_mnUnitsQuantityFutureINTEGEROPTIONALOUT
UOPN_mnUnitsOpenQuantityINTEGEROPTIONALOUT
QTYT_mnQuantityShippedToDateINTEGEROPTIONALOUT
QRLV_mnQuantityRelievedINTEGEROPTIONALOUT
COMM_cCommittedHSUDCOPTIONALOUT
OTQY_cOtherQuantity12CHARACTEROPTIONALOUT
UPRC_mnAmtPricePerUnit2FLOATOPTIONALOUT
AEXP_mnAmountExtendedPriceFLOATOPTIONALOUT
AOPN_mnAmountOpen1FLOATOPTIONALOUT
PROV_cPriceOverrideCodeCHARACTEROPTIONALOUT
TPC_cTemporaryPriceYNCHARACTEROPTIONALOUT
APUM_szUnitOfMeasureEntUPUDCOPTIONALOUT
LPRC_mnAmtListPricePerUnitFLOATOPTIONALOUT
UNCS_mnAmountUnitCostFLOATOPTIONALOUT
ECST_mnAmountExtendedCostFLOATOPTIONALOUT
CSTO_cCostOverrideCodeCHARACTEROPTIONALOUT
TCST_mnExtendedCostTransferFLOATOPTIONALOUT
INMG_szPrintMessage1UDCOPTIONALOUT
PTC_szPaymentTermsCode01STRINGOPTIONALOUT
RYIN_cPaymentInstrumentAUDCOPTIONALOUT
DTBS_cBasedonDateUDCOPTIONALOUT
TRDC_mnDiscountTradeFLOATOPTIONALOUT
FUN2_mnTradeDiscountOldFLOATOPTIONALOUT
ASN_szPriceAdjustmentScheduleNUDCOPTIONALOUT
PRGR_szPricingCategoryUDCOPTIONALOUT
CLVL_szPricingCategoryLevel1STRINGOPTIONALOUT
CADC_mnDiscountCashFLOATOPTIONALOUT
KCO_szCompanyKeyCOMPANYOPTIONALOUT
DOC_mnDocVoucherInvoiceEINTEGEROPTIONALOUT
DCT_szDocumentTypeUDCOPTIONALOUT
ODOC_mnOriginalDocumentNoINTEGEROPTIONALOUT
ODCT_szOriginalDocumentTypeUDCOPTIONALOUT
OKC_szDocumentCompanyOriginalCOMPANYOPTIONALOUT
PSN_mnPickSlipNumberINTEGEROPTIONALOUT
DELN_mnDeliveryNumberINTEGEROPTIONALOUT
TAX1_cTaxableYNUDCOPTIONALOUT
TXA1_szTaxArea1STRINGOPTIONALOUT
EXR1_szTaxExplanationCode1UDCOPTIONALOUT
ATXT_cAssociatedTextCHARACTEROPTIONALOUT
PRIO_cPriorityProcessingUDCOPTIONALOUT
RESL_cResolutionCodeBCCHARACTEROPTIONALOUT
BACK_cBackordersAllowedYNCHARACTEROPTIONALOUT
SBAL_cSubstitutesAllowedYNCHARACTEROPTIONALOUT
APTS_cPartialShipmntsAllowYCHARACTEROPTIONALOUT
LOB_szLineofBusinessUDCOPTIONALOUT
EUSE_szEndUseUDCOPTIONALOUT
DTYS_szDutyStatusUDCOPTIONALOUT
NTR_szNatureOfTransactionUDCOPTIONALOUT
VEND_mnPrimaryLastVendorNoADDRESSNUMBEROPTIONALOUT
ANBY_mnBuyerNumberADDRESSNUMBEROPTIONALOUT
CARS_mnCarrierADDRESSNUMBEROPTIONALOUT
MOT_szModeOfTransportUDCOPTIONALOUT
COT_szConditionsOfTransportUDCOPTIONALOUT
ROUT_szRouteCodeUDCOPTIONALOUT
STOP_szStopCodeUDCOPTIONALOUT
ZON_szZoneNumberUDCOPTIONALOUT
CNID_szContainerIDSTRINGOPTIONALOUT
FRTH_szFreightHandlingCodeUDCOPTIONALOUT
AFT_cApplyFreightYNCHARACTEROPTIONALOUT
FUF1_cApplyFreightUDCOPTIONALOUT
FRTC_cFreightCalculatedYNCHARACTEROPTIONALOUT
SHCM_szShippingCommodityClassUDCOPTIONALOUT
SHCN_szShippingConditionsCodeUDCOPTIONALOUT
SERN_szSerialNumberLotSTRINGOPTIONALOUT
UOM1_szUnitOfMeasurePrimaryUDCOPTIONALOUT
PQOR_mnUnitsPrimaryQtyOrderINTEGEROPTIONALOUT
UOM2_szUnitOfMeasureSecondaryUDCOPTIONALOUT
SQOR_mnUnitsSecondaryQtyOrINTEGEROPTIONALOUT
UOM4_szUnitOfMeasurePricingUDCOPTIONALOUT
ITWT_mnAmountUnitWeightFLOATOPTIONALOUT
WTUM_szWeightUnitOfMeasureUDCOPTIONALOUT
ITVL_mnAmountUnitVolumeFLOATOPTIONALOUT
VLUM_szVolumeUnitOfMeasureUDCOPTIONALOUT
RPRC_szRepriceBasketPriceCatUDCOPTIONALOUT
ORPR_szOrderRepriceCategoryUDCOPTIONALOUT
ORP_cOrderRepricedIndicatorCHARACTEROPTIONALOUT
CMGP_szInventoryCostingMethSTRINGOPTIONALOUT
GLC_szGlClassSTRINGOPTIONALOUT
CTRY_mnCenturyINTEGEROPTIONALOUT
FY_mnFiscalYear1INTEGEROPTIONALOUT
SO01_cSalesOrderStatus01CHARACTEROPTIONALOUT
SO02_cSalesOrderStatus02CHARACTEROPTIONALOUT
SO03_cSalesOrderStatus03CHARACTEROPTIONALOUT
SO04_cSalesOrderStatus04CHARACTEROPTIONALOUT
SO05_cSalesOrderStatus05CHARACTEROPTIONALOUT
SO06_cSalesOrderStatus06CHARACTEROPTIONALOUT
SO07_cSalesOrderStatus07CHARACTEROPTIONALOUT
SO08_cSalesOrderStatus08CHARACTEROPTIONALOUT
SO09_cSalesOrderStatus09CHARACTEROPTIONALOUT
SO10_cSalesOrderStatus10CHARACTEROPTIONALOUT
SO11_cSalesOrderStatus11CHARACTEROPTIONALOUT
SO12_cSalesOrderStatus12CHARACTEROPTIONALOUT
SO13_cSalesOrderStatus13CHARACTEROPTIONALOUT
SO14_cSalesOrderStatus14CHARACTEROPTIONALOUT
SO15_cSalesOrderStatus15CHARACTEROPTIONALOUT
ACOM_cApplyCommissionYNCHARACTEROPTIONALOUT
CMCG_szCommissionCategorySTRINGOPTIONALOUT
RCD_szReasonCodeUDCOPTIONALOUT
GRWT_mnGrossWeightFLOATOPTIONALOUT
GWUM_szUnitOfMeasureGrossWtUDCOPTIONALOUT
SBL_szSubledgerSTRINGOPTIONALOUT
SBLT_cSubledgerTypeUDCOPTIONALOUT
LCOD_szCodeLocationTaxStatUDCOPTIONALOUT
UPC1_szPriceCode1UDCOPTIONALOUT
UPC2_szPriceCode2UDCOPTIONALOUT
UPC3_szPriceCode3UDCOPTIONALOUT
SWMS_cStatusInWarehouseCHARACTEROPTIONALOUT
UNCD_cWoOrderFreezeCodeUDCOPTIONALOUT
CRMD_cCorrespondenceMethodUDCOPTIONALOUT
CRCD_szCurrencyCodeFromSTRINGOPTIONALOUT
CRR_mnCurrencyConverRateOvFLOATOPTIONALOUT
FPRC_mnAmountListPriceForeignFLOATOPTIONALOUT
FUP_mnAmtForPricePerUnitFLOATOPTIONALOUT
FEA_mnAmountForeignExtPriceFLOATOPTIONALOUT
FUC_mnAmountForeignUnitCostFLOATOPTIONALOUT
FEC_mnAmountForeignExtCostFLOATOPTIONALOUT
URCD_szUserReservedCodeSTRINGOPTIONALOUT
URDT_jdUserReservedDateDATEOPTIONALOUT
URAT_mnUserReservedAmountFLOATOPTIONALOUT
URAB_mnUserReservedNumberINTEGEROPTIONALOUT
URRF_szUserReservedReferenceSTRINGOPTIONALOUT
TORG_szTransactionOriginatorSTRINGOPTIONALOUT
IR01_szIntegrationReference01STRINGOPTIONALOUT
IR02_szIntegrationReference02STRINGOPTIONALOUT
IR03_szIntegrationReference03STRINGOPTIONALOUT
IR04_szIntegrationReference04STRINGOPTIONALOUT
IR05_szIntegrationReference05STRINGOPTIONALOUT
SOOR_mnSourceOfOrderINTEGEROPTIONALOUT
DEID_mnDemandUniqueKeyINTEGEROPTIONALOUT
PSIG_szPullSignalSTRINGOPTIONALOUT
RLNU_szReleaseNumberSTRINGOPTIONALOUT
PMDT_mnScheduledShipmentTimeINTEGEROPTIONALOUT
RLTM_mnTimeReleaseINTEGEROPTIONALOUT
RLDJ_jdDateReleaseDATEOPTIONALOUT
DRQT_mnRequestedDeliveryTimeINTEGEROPTIONALOUT
ADTM_mnActualShipmentTimeINTEGEROPTIONALOUT
OPTT_mnTimeOriginalPromisedINTEGEROPTIONALOUT
PDTT_mnPromisedPickTimeINTEGEROPTIONALOUT
PSTM_mnTimeFuture2INTEGEROPTIONALOUT
PMTN_szPromotionIDSTRINGOPTIONALOUT
BSC_szBuyingSegmentCodeUDCOPTIONALOUT
CBSC_szCurrentBuyingSegmentCDUDCOPTIONALOUT
DVAN_mnAddressNumberDelivedToADDRESSNUMBEROPTIONALOUT
RFRV_szRevisionReasonUDCOPTIONALOUT
SHPN_mnShipmentNumberINTEGEROPTIONALOUT
PRJM_mnProjectNumberINTEGEROPTIONALOUT
HOLD_szHoldOrdersCodeUDCOPTIONALOUT
PMTO_cPaymentTermsOverrideCHARACTEROPTIONALOUT
DUAL_cDualUnitOfMeasureItemCHARACTEROPTIONALOUT
PMPN_szProductionNumberSTRINGOPTIONALOUT
SHCCIDLN_mnShipToCusContactNoINTEGEROPTIONALOUT
OPPID_mnOpportunityIdINTEGEROPTIONALOUT
SPATTN_szShipToAttentionSTRINGOPTIONALOUT
CATNM_szCatalogNameSTRINGOPTIONALOUT
OSTP_szOrganizationTypeStructUDCOPTIONALOUT
SO16_cSalesOrderStatus16CHARACTEROPTIONALOUT
SO17_cSalesOrderStatus17CHARACTEROPTIONALOUT
SO18_cSalesOrderStatus18CHARACTEROPTIONALOUT
SO19_cSalesOrderStatus19CHARACTEROPTIONALOUT
SO20_cSalesOrderStatus20CHARACTEROPTIONALOUT
VR03_szReferenceUCISNoSTRINGOPTIONALOUT
XDCK_cCrossDockFlagCHARACTEROPTIONALOUT
XPTY_mnCrossDockingPriorityINTEGEROPTIONALOUT
CORD_mnNumberChangeOrderINTEGEROPTIONALOUT
PEND_cPendingApprovalFlagCHARACTEROPTIONALOUT
MCLN_mnMatrixControlLineFLOATOPTIONALOUT
RSDT_mnPromisedDeliveryTimeINTEGEROPTIONALOUT
OSEQ_mnSequenceNumberINTEGEROPTIONALOUT
MERL_szMeRevisionLevelSTRINGOPTIONALOUT
HDBU_szBusinessUnitHeader9BUSINESSUNITOPTIONALOUT
DMBU_szBusinessUnitDemandBUSINESSUNITOPTIONALOUT
BCRC_szCurrencyCodeBaseSTRINGOPTIONALOUT
ODLN_mnOriginalDocumentLineNoFLOATOPTIONALOUT
XKCO_szCrossDockCmpyKeyOrderNoCOMPANYOPTIONALOUT
XORN_mnCrossDockOrderNumberINTEGEROPTIONALOUT
XCTO_szCrossDockOrderTypeUDCOPTIONALOUT
XLLN_mnCrossDockLineNumberFLOATOPTIONALOUT
POE_szPortOfEntryExitUDCOPTIONALOUT
NUMB_mnAssetItemNumberASSETNUMBEROPTIONALOUT
AAID_mnParentNumberINTEGEROPTIONALOUT
PRAN8_mnPartnerAddressNumberINTEGEROPTIONALOUT
PRCIDLN_mnPartnerContactLineNoINTEGEROPTIONALOUT
CCIDLN_mnCustomerContactLineNoINTEGEROPTIONALOUT
UKID_mnUniqueKeyIDInternalINTEGEROPTIONALOUT
ALLOC_cAllocationFlagCHARACTEROPTIONALOUT
FULPID_mnFulfillmentPlanIDINTEGEROPTIONALOUT
ALLSTS_szAllocationStatusUDCOPTIONALOUT
OSCORE_mnOrderScoreFLOATOPTIONALOUT
OSCOREO_cScoreOverrideCHARACTEROPTIONALOUT
CMCO_szCustomerMasterCompanySTRINGOPTIONALOUT
KITID_mnKitIdentifierINTEGEROPTIONALOUT
KITAMTDOM_mnAccumulatedAmtInvFLOATOPTIONALOUT
KITAMTFOR_mnAccumulatedAmtInvFLOATOPTIONALOUT
KITDIRTY_cKitComponentDirtyFlgCHARACTEROPTIONALOUT
OCITT_cOCInTransitFlagCHARACTEROPTIONALOUT
OCCARDNO_mnOCKanbanCardNoINTEGEROPTIONALOUT
PNS_mnProductionNumberShortINTEGEROPTIONALOUT
XSFX_szCrossDockOrderSuffixSTRINGOPTIONALOUT
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.