Q35CreateSalesOrderDetailLine
Cantara Business Function which creates FQ354202 records which are eventually processed to Sales Order Detail lines (F4211) by Q35ProcessSalesOrder
Note
The actual complete detailed validation for the Sales Order line occurs during Q35ProcessSalesOrder , not at the time these FQ354202 are created.
Important:
Not all of the data parameters written to the FQ354202 records are used when creating Sales Order Detail Lines.
The parameters that will be used are indicated by the column labelled Utilized in SalesOrderDetailLines in the table below.
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 | Utilized in SalesOrderDetailLines |
---|---|---|---|---|
EV01_cSuppressErrors | CHARACTER | OPTIONAL | IN | |
DTAI_szErrorMessage | STRING | OPTIONAL | OUT | |
EDUS_szUserID | STRING | REQUIRED | IN | |
EDTN_szTransactionNumber | STRING | REQUIRED | IN | |
KCOO_szCompanyKeyOrderNo | COMPANY | OPTIONAL | BOTH | Yes |
DOCO_mnDocumentOrderInvoiceE | INTEGER | OPTIONAL | BOTH | Yes |
DCTO_szOrderType | UDC | OPTIONAL | BOTH | Yes |
SFXO_szOrderSuffix | STRING | OPTIONAL | BOTH | Yes |
MCU_szCostCenter | BUSINESSUNIT | OPTIONAL | BOTH | Yes |
CO_szCompany | COMPANY | OPTIONAL | BOTH | Yes |
OKCO_szCompanyKeyOriginal | COMPANY | OPTIONAL | BOTH | Yes |
OORN_szOriginalPoSoNumber | STRING | OPTIONAL | BOTH | Yes |
OCTO_szOriginalOrderType | UDC | OPTIONAL | BOTH | Yes |
OGNO_mnOriginalLineNumber | FLOAT | OPTIONAL | BOTH | Yes |
RKCO_szCompanyKeyRelated | COMPANY | OPTIONAL | BOTH | Yes |
RORN_szRelatedPoSoNumber | STRING | OPTIONAL | BOTH | Yes |
RCTO_szRelatedOrderType | UDC | OPTIONAL | BOTH | Yes |
RLLN_mnRelatedPoSoLineNo | FLOAT | OPTIONAL | BOTH | Yes |
DMCT_szContractNumberDistrib | STRING | OPTIONAL | BOTH | Yes |
DMCS_mnContractSupplementDist | INTEGER | OPTIONAL | BOTH | Yes |
AN8_mnAddressNumber | ADDRESSNUMBER | OPTIONAL | BOTH | Yes |
SHAN_mnAddressNumberShipTo | ADDRESSNUMBER | OPTIONAL | BOTH | Yes |
PA8_mnAddressNumberParent | ADDRESSNUMBER | OPTIONAL | BOTH | Yes |
DRQJ_jdDateRequestedJulian | DATE | OPTIONAL | BOTH | Yes |
TRDJ_jdDateTransactionJulian | DATE | OPTIONAL | BOTH | Yes |
PDDJ_jdScheduledPickDate | DATE | OPTIONAL | BOTH | Yes |
OPDJ_jdDateOriginalPromisde | DATE | OPTIONAL | BOTH | Yes |
ADDJ_jdActualShipDate | DATE | OPTIONAL | BOTH | Yes |
IVD_jdDateInvoiceJulian | DATE | OPTIONAL | BOTH | Yes |
CNDJ_jdCancelDate | DATE | OPTIONAL | BOTH | Yes |
DGL_jdDtForGLAndVouch1 | DATE | OPTIONAL | BOTH | Yes |
RSDJ_jdDateReleaseJulian | DATE | OPTIONAL | BOTH | Yes |
PEFJ_jdDatePriceEffectiveDate | DATE | OPTIONAL | BOTH | Yes |
PPDJ_jdDatePromisedShipJu | DATE | OPTIONAL | BOTH | Yes |
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 | |
PROV_cPriceOverrideCode | CHARACTER | 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 | Yes |
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 | Yes |
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 | Yes |
FUP_mnAmtForPricePerUnit | FLOAT | OPTIONAL | BOTH | Yes |
FEA_mnAmountForeignExtPrice | FLOAT | OPTIONAL | BOTH | Yes |
FUC_mnAmountForeignUnitCost | FLOAT | OPTIONAL | BOTH | Yes |
FEC_mnAmountForeignExtCost | FLOAT | OPTIONAL | BOTH | Yes |
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 | |
EDLN_mnLineNumber | FLOAT | OPTIONAL | OUT | |
LNID_mnLineNumber | FLOAT | OPTIONAL | BOTH | |
FUF1_cApplyFreight | UDC | OPTIONAL | BOTH | |
FRTC_cFreightCalculatedYN | CHARACTER | OPTIONAL | BOTH | |
EUSE_szEndUse | UDC | OPTIONAL | BOTH | Yes |
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 | |
ACTN_cActionCode | CHARACTER | REQUIRED | BOTH | |
EV01_cCompareMode | CHARACTER | OPTIONAL | IN | |
SO18_cSalesOrderStatus18 | CHARACTER | OPTIONAL | BOTH |