Sales Order Maintenance interface for JD Edwards
About the Sales Order Maintenance interface
The Sales Order Maintenance interface is used to create a sales order, add a line to a sales order, or cancel a sales order line. Depending upon the processing options, it can be used to create regular sales orders, transfer orders (ST/OT), RMA (Return Material Authorization) orders, etc.
If calling the function asynchronously, it is the user's responsibility to retrieve the order number if it is required for another call. This interface does not support configured items.
This guide applies to the newest version of the ERP.
Name | Function Name | Description |
---|---|---|
DD3N4206 | PO Retrieval - Sales Order Maintenance | |
BD3N4206 | PORetrievalSalesOrderMaint | PO Retrieval - Sales Order Maintenance |
DD3N4210 | dcLINK Sales Order Maintenance | |
ND3N4210 | dcLINKSalesOrderMaintenance | dcLINK Sales Order Maintenance |
DD3N4210 | dcLINK Sales Order Maintenance | |
ND3N4210 | dcLINKSalesOrderEdit | dcLINK Sales Order Edit |
DD3N4210 | dcLINK Sales Order Maintenance | |
ND3N4210 | dcLINKSalesOrderMobile | dcLINK Sales Order Mobile |
About the typical interface flow
The interface generally operates according to the following process.
A user first create a sales order from a script. The script passes up a cdcLinkActionCode_EV01 of “C”, the proper processing option version, branch plant, order type, second item, quantity, and ship to. The order header and the order detail for that line are created.
The user then adds a line to the order for a different item. The script passes up an Action Code of “A”, the proper processing option version, branch plant, order number, order type, item, quantity, and ship to.
As a result, the order contains two detail lines.
Alternate flows
The following alternate behaviors may occur instead of the standard interface process.
-
Adding items to sales orders that were created by customer service users.
-
Canceling lines.
-
Performing RMA (returns) orders from the warehouse.
Processing options
This interface utilizes the following processing options.
The DreamWriter defaults to ZJDE0001 if not otherwise specified in the parameter list on the call.
Defaults tab
-
Order Type (szDefaultOrderType_DCTO) - This is an enterprise system-required processing option. It must contain a valid order type that is defined in the 00/DT UDC, as well as be set up with an appropriate line type in the Order Activity Rules. It can be overwritten by passing it into the interface.
-
Line Type (szDefaultLineType_LNTY) - This field sets the standard Line Type for each line of the order. As with order type, the Order Activity Rules must be set up.
-
Beginning Status (szDefaultBeginningStatus_LTTR) – This field sets the Last Status of the sales order line, and in conjunction with the Order Activity Rules, sets the Next Status of the line.
-
Override Next Status (szOverrideNextStatus_NXTR) - This field overrides the Next Status of the line. As usual, it must be set up as an available next status in the Order Activity Rules for that Order Type/Line Type combination.
-
Line Number Increment (mnDefaultLineIncrement_LNIX) - If left blank, the default line increment is “1.000”.
-
Reason Code (szDefaultReasonCode_RCD) – This processing option is the default value used for Reason Code in the SO Header when a value is not passed in for the szReasonCode_RCD input parameter. The value must exist in the UDC table 42/RC.
-
Override Transaction Unit of Measure (cUsePricingUOM_EV01) - This processing option will override the default unit of measure in the Item Master.
-
Default Transaction Unit of Measure (szDefaultTransactionUom_UOM) - This processing option determines whether the Primary UoM is used, or the Pricing UoM is used as set up in the Item Master.
-
Address Book Revisions (cAddNewCustomersToAB_EV17) – This field should be set to blank.
-
Update Header to Detail (cLoadHeaderToDetail_EV18) - This option should be set to “1”.
-
Header Branch Plant (cDefaultShipToBranch_EV02) - This field should be left set to blank. If this is to be used, then the UserID should be set up in the P400951 application and passed into the BF szUserId_USER parameter.
-
Default Branch Plant (szDefaultBranchPlant_MCU) – This option is self-explanatory. If all sales orders for a particular version are to have the same branch plant, it can be set here. This Branch Plant field value will override the B/P set in option 11.
Order Holds tab
All options on this tab deal with the Hold Code. If a Hold Code is passed into the interface, any hold codes set up in the processing options will take precedence.
Commitment tab
-
Activate Availability Checking (cAvailabilityCheck_EV12) - This field can be set to blank, “1”, or “2”. If it is set to blank, the sales order line will be created with the entire quantity, without checking to see if there is quantity available. If it is set to “1”, it will check availability and backorder any quantity not available. If it is set to “2”, it will check availability and create the line with the entire quantity anyway.
-
Commit to Quantity 1 or Quantity 2 (cOtherQuantity1or2_EV13) – This option can be set to blank, “1”, or “2”. This determines which bucket the commitments are applied to, if the Activate Availability Checking is set to “1” or “2”. For example, if this is set to “1”, and Activate Availability Checking is turned on in the Detailed Availability application (P41202), the quantity on the sales order will appear under the column “On SO Other 1”.
-
Display Supply and Demand Inquiry Form (cAutoDisplaySDInquiry_EV20) - This field must be set to blank.
Process tab
-
Status Code Limit for Changes (szNonUpdatableStatus_NXT2) - If this option is set, nothing can be modified on the sales order if the line status exceeds this value. It also cannot be cancelled.
-
Subsystem Processing (cAutoPrintOrCommit_EV14) – This option turns on various subsystem jobs. Valid values are: blank - performs no processing, “1” - uses the subsystem to print pick slips, “2” - uses the subsystem to print invoices, “3” - uses the subsystem to commit inventory, “4” - performs online commitment processing, or “5” - used for store & forward processing.Note: Values of “4” and “5” are not supported by this interface.
-
Display Before Accept (cDisplayBeforeAcceptCK01) - This option must be left blank.
-
Order Template Processing (cOrderTemplateAddress_EV21) - This option must be left blank.
-
Blanket/Quote Order Processing (cAutoBlanketRelease_EV24) – This option must be left blank.
-
Agreement Processing (cAgreementProcessing_SCH1) - A blank would be the best setting for this option. It cannot be set to “2”.
-
Customer Self-Service Functionality (cShoppingCartMode_CART) - This option must be left blank.
-
Cost or Base Price Markup (cCostMarkup_FFU2) – This can be set to blank, “1”, or “2”, but it only affects Transfer Orders (ST/OT).
-
Ship and Debit Processing (cCallR45100Mode_EV01) - This option determines how the ship and debit agreements are handled. Valid values are: blank - no processing, “1”- for subsystem processing, and “2”- for batch processing.
Versions tab
-
Pick Slip Print Subsystem (R42520) (szR42520Vers_VL01) - If Subsystem Processing (Process Tab) is set to “1”, a version should be specified here.
-
Pick Slip Print on Demand (R42520) (szOnDemandPickSlipVers_VL03) – A version should be entered.
-
Adv Order/Basket Reprice (R42750) (szR42750Vers_VL04) - If pricing is used, a version should be entered here.
-
Preference Profile (R40400) (szP40400Vers_VL06) - If Preference Profile Processing is turned on (Preference Tab), a version should be specified here.
-
Print Invoice (R42565) (szR42565Vers_VL12) - If Subsystem Processing (Process Tab) is set to “2”, a version should be specified here.
-
Online/Subsystem Commitment (R42997) (cAutoBlanketRelease_EV24) – If Subsystem Processing (Process Tab) is set to “3” or “4”, a version should be specified here.
-
Sales Order Batch Transaction Editor (R4210Z) (szR42107Vers_VL14) - If Subsystem Processing (Process Tab) is set to “5”, a version should be specified here.
-
Ship and Debit (R45100) (szR45100Version_VERS) - If Ship and Debit Processing (Process Tab) is set to “1” or “2”, a version should be specified here.
Preference tab
-
Preference Profile Processing (cUsePrefProcess_EV22) - If this is set to blank, it will not retrieve the preference profiles. If it is set to “1”, it will retrieve the profiles.
-
Inventory Commitment Preference (cCommitPreference_EV23) – If this is set to blank, it will not retrieve the Inventory Commitment profiles. If it is set to “1”, it will retrieve the profiles.
Transfers tab
-
Activate Transfer Order Entry (cTransferOrderEntry_EV25) - If Transfer Orders are to be created (ST/OT), this should be set to a “1”. For regular sales orders, this should be set to blank.
-
Mandatory Landed Cost (cMandatoryLandedCost_EV01) – If Activate Transfer Order Entry is turned on, and this option is set to “1”, then Landed Cost is a required parameter. If Activate Transfer Order Entry is not turned on, then this option does not affect the interface.
Warehouse tab
-
Request Processing Mode (cWhseRequestMode_PRSU) - This can be set to: blank to not generate a pick request, “1” to generate a pick request, or “2” to generate and create requests through the subsystem.
-
Subsystem Print Pick Request (szWhsePickVersion_VL13) – If Request Processing Mode is set to “2”, a version for R46171 should be entered.
-
Override Next Status (szWhseOverrideNextSts_NXTEV1) - A valid Next Status can be entered here.
Interbranch tab
-
Intercompany Invoice (cIntercompanyInvoice_EV01.]) - If set to blank, no intercompany invoice will be supported. If set to “1”, it will create intercompany invoices.
-
Interbranch Order Types (szInterBranchOrderType_VL12) – The Order Type values for these orders must be entered here.
Prepayment tab
-
Prepayment Processing (cActivatePrepayProcess_EV01) - This option must be set to blank.
-
Process Authorization (cHowToProcessAuthorizatn_EV02) – This option should be set to blank or “2”.
-
Process Settlement (cHowToProcessSettlement_EV03) - This option should be set to blank or “2”.
-
Authorize Prepayment Transaction Version (cActivatePrepayProcess_EV01) - If Process Authorization is set to “2”, the version to be used should be set here.
-
Settle Prepayment Transaction Version (szAuthorizeVersion_VERS) - If Process Settlement is set to “2”, the version to be used should be set here.
-
Enter a Next Status Override Code for Authorized Lines/Settled Lines (szAuthorizedNextStatus_NXTR) - Valid Next Statuses (as set up in the Order Activity Rules) can be entered here.
Processing option data structure
The interface retrieves these parameters by calling BD3N4206. They are passed back in the following data structure.
Type | Description | Parameter |
---|---|---|
String | szPOVersion_VERS | Input |
String | szDefaultOrderType_DCTO | Output |
String | szDefaultLineType_LNTY | Output |
String | szDefaultBeginningStatus_LTTR | Output |
String | szOverrideNextStatus_NXTR | Output |
Numeric | mnDefaultLineIncrement_LNIX | Output |
String | szDefaultReasonCode_RCD | Output |
String | szDefaultTransactionUom_UOM | Output |
Char | cUsePricingUoM_EV01 | Output |
Char | cAddNewCustomersToAB_EV17 | Output |
Char | cLoadHeaderToDetail_EV18 | Output |
Char | cDefaultShipToBranch_EV02 | Output |
String | szDefaultBranchPlant_MCU | Output |
String | szOrderTemplate_ORTP | Output |
String | szOrganizationTypeStruct_OSTP | Output |
String | szDupOrderType_DCT | Output |
String | szDupBeginningStatus_LTT2 | Output |
String | szDupNextStatus_NXT2 | Output |
Char | cCopyTextOption_EV16 | Output |
String | szCreditHold_HOLD | Output |
String | szOrderMarginCheck_HOLD1 | Output |
String | szLineMarginCheck_HOLD2 | Output |
String | szMinimumOrderCheck_HOLD3 | Output |
String | szMaximumOrderCheck_HOLD4 | Output |
String | szPartialOrderHold_HOLD5 | Output |
String | szProductAllocHold_HCOD | Output |
String | szAuthorizeHoldCode_HOLD | Output |
String | szSettleHoldCode_HOLD | Output |
String | szOrderProcessHold_S4210100 | Output |
Char | cDisableOrHideCost_EV03 | Output |
Char | cDisableOrHidePrice_EV04 | Output |
Char | cDisablePricingRelated_EV01 | Output |
Char | cDisableStatusCodes_EV05 | Output |
Char | cEHideClosedLines_EV06 | Output |
Char | cHideCreditCardInfo_EV07 | Output |
Char | cHideFreightInfo_EV08 | Output |
Char | cHideCommission_EV09 | Output |
Char | cHideKitComponents_EV11 | Output |
Char | cAvailabilityCheck_EV12 | Output |
Char | cOtherQuantity1or2_EV13 | Output |
Char | cAutoDisplaySDInquiry_EV20 | Output |
Numeric | mnToleranceLimit_TFCT | Output |
String | szCurrencyCodeFrom_CRCD | Output |
Date | jdDateTransactionJulian_TRDJ | Output |
String | szNonUpdatableStatus_NXT2 | Output |
Char | cAutoPrintOrCommit_EV14 | Output |
Char | cHeadorOrDetailFirst_EV19 | Output |
Char | cAutoReprice_VC01A | Output |
Char | cDisplayBeforeAccept_CK01 | Output |
Char | cOrderTemplateAddress_EV21 | Output |
Char | cAutoBlanketRelease_EV24 | Output |
Char | cAgreementProcessing_SCH1 | Output |
Char | cShoppingCartMode_CART | Output |
Char | cCostMarkup_FFU2 | Output |
Char | cCallR45100Mode_EV01 | Output |
String | szSubstituteItemXRef_XRT | Output |
String | szComplementaryItemXRef_XRT2 | Output |
String | szReplacementItemXRef_XRT3 | Output |
Char | cUsedSubsItemPrice_EV15 | Output |
String | szR42520Vers_VL01 | Output |
String | szP4021Vers_VL02 | Output |
String | szOnDemandPickSlipVers_VL03 | Output |
String | szR42750Vers_VL04 | Output |
String | szP42230Vers_VL05 | Output |
String | szP40400Vers_VL06 | Output |
String | szChkPriceAvailVers_VL07 | Output |
String | szP4310Vers_VL08 | Output |
String | szSupplierMasterVers_VL09 | Output |
String | szBOMInquiryVersion_VL10 | Output |
String | szP4801Vers_VL11 | Output |
String | szR42565Vers_VL12 | Output |
String | szR42997Vers_VL13 | Output |
String | szP32942Vers_VL13 | Output |
String | szR4210ZVers_VL14 | Output |
String | szP42050Vers_VL15 | Output |
String | szP4915Vers_VL16 | Output |
String | szP03013Vers_VL17 | Output |
String | szR45100Version_VERS | Output |
Char | cUsePrefProcess_EV22 | Output |
Char | cCommitPreference_EV23 | Output |
Char | cTransferOrderEntry_EV25 | Output |
Char | cTurnOffTaxable_EV01 | Output |
Char | cMandatoryLandedCost_EV01 | Output |
String | szCSIFromStatusCode_NXTEV1 | Output |
String | szCSIThruStatusCode_LTTR | Output |
Char | cCSIStatusRangeBased_STBOW | Output |
Char | cCSIDteRangeBasedOn_DTBOW | Output |
Char | cCSIDisplayTextLines_EV01 | Output |
Char | cCSIDisplayBackorderOrCan_EV02 | Output |
String | szCustomerItemNumber_XRT4 | Output |
Char | cWhseRequestMode_PRSU | Output |
String | szWhsePickVersion_VL13 | Output |
String | szWhseOverrideNextSts_NXTEV1 | Output |
Char | cStoreAndForwardMode_SO15 | Output |
Char | cWOPlannerEmail_EV01 | Output |
Char | cBuyerEmail_EV02 | Output |
Char | cActiveMultSchedule_EV01 | Output |
String | szScheduleLine_LNTY | Output |
Char | cIntercompanyInvoice_EV01 | Output |
String | szInterBranchOrderType_VL12 | Output |
String | szTypeTransaction_TYTN | Output |
Char | cBeforeImageProcessing_BIPROC | Output |
Char | cActivatePrepayProcess_EV01 | Output |
Char | cHowToProcessAuthorizatn_EV02 | Output |
Char | cHowToProcessSettlement_EV03 | Output |
String | szAuthorizeVersion_VERS | Output |
String | szSettleVersion_VERS | Output |
String | szAuthorizedNextStatus_NXTR | Output |
String | szSettledNextStatus_NXTR | Output |
Char | cDefaultUserID_EV01 | Output |
Char | cOverrideSoldToShipTo_EV01 | Output |
Char | cOverrideCarrierNumber_EV01 | Output |
String | szApprovalHoldCode_HOLD1 | Output |
String | szExclusiveAdjustmentHold_HOLD | Output |
Char | cFreeGoodCatWarning_EV01 | Output |
Char | cAdjustVolumeTrans_EV01 | Output |
Char | cPromptForCustomerSeg_CSIP | Output |
Char | cCheckAscendingDateRule_ASDC | Output |
Char | cMultiBlanketSelect_MLTSBRLF | Output |
Char | cSingleBlanketSelect_SBSELECT | Output |
String | szCrossReferencePromotion_XRT | Output |
String | szR45900Version_VL18 | Output |
String | szP00391Version_VL19 | Output |
String | szCustomerSegmentItem_CSIV | Output |
String | szProductVariantsVersion_VERS | Output |
String | szPreferenceSchedule_PRSN | Output |
Char | cUseAuditLog_EV01 | Output |
Char | cRequiredReasonCode_EV02 | Output |
Char | cRequiredApprovalProcess_EV03 | Output |
Numeric | mnVolumeTolerancePerc_INCRAM | Output |
Char | eEnableGrossProfitPricing_EV01 | Output |
String | szAdjustmentReasonCode_ARSN | Output |
Char | cProfitMarginResolveTest_EV01 | Output |
Char | cAssignPromotionID_EV01 | Output |
Char | cOrderPromising_EV01 | Output |
Char | cInventoryParent_SEGB | Output |
String | szOrderProcessingVer_VL24 | Output |
Char | cSoldToRecordType_TYC | Output |
Char | cShipToRecordType_TYC | Output |
String | szInactiveCustomerHold_INHLD | Output |
String | szInactiveCustomerType_INAT1 | Output |
String | szProductCatalogVersion_VERPC | Output |
String | szLotGroup_LOTGRP | Output |
Char | cAutoDisplayAvailableBlanket_EV01 | Output |
String | szR4277702Version_VER1 | Output |
String | szP4131Version_VER1 | Output |
String | szR4277705Version_VER1 | Output |
Char | cCalculateOrderScore_YN01 | Output |
Char | cResolveSLRules_YN01 | Output |
Processing
The characteristics of an item determine which fields are required by the interface. Some characteristics are set at the item master level, and some are set at the item/branch level. The item/branch level always takes precedence over the item master. Refer to the Special Processing Interface Usage Guide for more information.
If the order is a transfer order, then a purchase order will be created. The purchase order number will appear in the RORN field in the F4201 and the F4211. The purchase order can be viewed via application P4310 on the G43A11 menu, or through the UTB in tables F4301 and F4311.
If the order is created in a warehouse branch/plant, and the proper processing options are set, the picking requests will also be created.
Action code usage
The Inventory Activity interface can be used as a single-line transaction.
Verify the processing
After configuring and running the interface in JDE, you should verify that the processing operations completed successfully. Note that this interface does not typically create CARDEX entries.
To verify that the interface worked as intended, complete one of the following actions in JDE.
-
In the P4210 application, look for your order.
-
In the UTB, view the F4211 and F4201 tables.
About using Action codes
Action codes are important in this interface. They differ from other dcLINK interface components.
The following action codes are the only valid values for the cdcLINKActionCode_EV01A input.
-
C is used to create a sales order.
-
A is used to add a line to an existing sales order.
-
D is used to delete or cancel a sales order line.
Sales Order Maintenance
The following action codes (cdcLINKActionCode_EV01/cActionCode_ACTION) are valid for this interface.
Action code | Description |
---|---|
A, C | A = Add line, C = Create new order |
Z | Z = Execute Zero price functionality |
Sales Order Edit
The following action codes (cdcLINKActionCode_EV01/cActionCode_ACTION) are valid for this interface.
Action code | Description |
---|---|
E | E = Edit order |
H, D, Z | H = Header update, D = Detail update, Z = Execute Zero price functionality |
Sales Order Mobile
The following action codes (cdcLINKActionCode_EV01) are valid for this interface.
Action code | Description |
---|---|
A, C | A = Add line, C = Create new order |
H, D, Z | H = Header update, D = Detail update, Z = Execute Zero price functionality |
Input data structure
The following table describes the input data structure for DD3N4220. Any required input settings are displayed in boldface text.
Name | Default values | R/O | Alias | Notes |
---|---|---|---|---|
cdcLINKActionCode_EV01 | C | X | EV01 | Valid values are: “A” = add line, “C” = create order, “D” = cancel line. “E” is for Edit Sales Order |
cActionCode_ACTION | 1 | X | ACTION | Valid values are “Z” = Zero Price functionality, “H” = Header update, “D” detail update. |
jdDateUpdated_UPMJ | Current Date | X | UPMJ | Retrieved from GetAuditInfo. |
mnTimeOfDay_TDAY | Current Time | X | UPMT | Retrieved from GetAuditInfo. |
szUserId_USER | Current User | X | USER | Retrieved from GetAuditInfo. |
szWorkStationId_JOBN | Current Workstation | X | JOBN | Retrieved from GetAuditInfo. |
mnJobNumber_JOBS | O | JOBS | ||
szProgramId_PID | ND3N4210 | X | PID | Defaulted in program if not passed in. |
szVersion_VERS | ZJDE0001 | X | VERS | Defaulted in program if not passed in. |
cSuppressErrMsg_EV01 | O | EV01 | ||
cErrorCode_ERRC | Blanks | X | ERRC | Defaulted in program. |
szErrorMessageKey_EKEY | Blanks | X | EKEY | Defaulted in program. |
iDebugLevel_INT01 | O | INT01 | Displays M&D Debug statements if the value is greater than “0”. | |
szBranchPlant_MCU | C | MCU | The only time that this is not required if is if it is set up in the processing options (Defaults Tab). | |
mnOrderNumber_DOCO | C | DOCO | This is required for the Add and Delete functions. | |
szOrderType_DCTO | X | DCTO | This will default from the processing options. | |
szCompany_KCOO | X | KCOO | This will default from the Business Unit Master (F0006). | |
szOrderSuffix_SFXO | O | SFXO | ||
szLineType_LNTY | O | LNTY | This will default from the processing options. | |
mnLineNumber_LNID | O | LNID | ||
szIdentifier2ndItem_LITM | C | LITM | Either 2nd Item or Short Item MUST be passed in. Minimum of one value. | |
mnIdentifierShortItem_ITM | C | ITM | Either 2nd Item or Short Item MUST be passed in. Minimum of one value. | |
szUnitOfMeasure_UOM | O | UOM | ||
mnTransactionQty_UORG | R | UORG | Quantity must be entered. | |
mnUnitPrice_UPRC | O | UPRC | ||
mnExtendedPrice_AEXP | O | AEXP | ||
szLocation_LOCN | O | LOCN | ||
szLot_LOTN | O | LOTN | ||
mnSoldToAddress_AN8 | O | AN8 | This will be retrieved from the Ship To. | |
mnAddressNumberShipTo_SHAN | C | SHAN | Ship To is required, unless the order is a transfer order. | |
szCurrencyCodeFrom_CRCD | O | CRCD | ||
mnExchangeRate_CRR | O | CRR | ||
szCurrencyCodeTo_CRDC | O | CRDC | ||
cCurrencyMode_CRRM | O | CRRM | ||
szCustomerPO_VR01 | O | VR01 | ||
jdOrderDate_TRDJ | O | TRDJ | ||
jdDateRequested_DRQJ | X | DRQJ | This defaults to today's date. | |
jdPScheduledPickDate_PDDJ | O | PDDJ | ||
jdPromisedShipDate_PPDJ | O | PPDJ | ||
jdCancelDate_CNDJ | O | CNDJ | ||
jdPromisedDeliveryDate_RSDJ | O | RSDJ | ||
mnQuantityShipped_SOQS | O | SOQS | ||
mnQuantityBackordered_SOBK | O | SOBK | ||
mnQuantityCanceled_SOCN | O | SOCN | ||
mnUnitCost_UNCS | O | UNCS | ||
mnExtendedCost_ECST | O | ECST | ||
mSupplier_VEND | O | VEND | ||
szDescription1_DSC1 | O | DSC1 | ||
szDescription2_DSC2 | O | DSC2 | ||
szLastStatusCode_LTTR | O | LTTR | ||
szNextStatusCode_NXTR | O | NXTR | ||
szLandedCost_PRP5 | O | PRP5 | ||
szPricingUoM_UOM4 | O | UOM4 | ||
szWeightUnitOfMeasure_WTUM | O | WTUM | ||
mnExtendedWeight_ITWT | O | ITWT | ||
cTaxableYN_TAX1 | O | TAX1 | ||
cPaymentInstrument_RYIN | O | RYIN | ||
szPrintMessage_INMG | O | INMG | ||
szAgreementNumber_DMCT | O | DMCT | ||
mnAgreementSupplement_DMCS | O | DMCS | ||
szModeOfTransport_MOT | O | MOT | ||
mnCarrier_CARS | O | CARS | ||
szDutyStatus_DTYS | O | DTYS | ||
szLineOfBusiness_LOB | O | LOB | ||
szEndUse_EUSE | O | EUSE | ||
szRevenueBusinessUnit_EMCU | O | EMCU | ||
szPriceCode1_UPC1 | O | UPC1 | ||
szPriceCode2_UPC2 | O | UPC2 | ||
szPriceCode3_UPC3 | O | UPC3 | ||
szItemPriceGroup_PRGR | O | PRGR | ||
szPaymentTerms_PTC | O | PTC | ||
cPriorityCode_PRIO | O | PRIO | ||
szReasonCode_RCD | O | RCD | The Reason Code is used in the SO Header. This parameter is validated against UDC table 42/RC. | |
mnCashDiscount_CADC | O | CADC | ||
szGLOffset_GLPT | O | GLPT | ||
szSubledger_SBL | O | SBL | ||
cSubledgerType_SBLT | O | SBLT | ||
szSalesCatalogSection_SRP1 | O | SRP1 | ||
szSubSection_SRP2 | O | SRP2 | ||
szSalesCategoryCode3_SRP3 | O | SRP3 | ||
szSalesCategoryCode4_SRP4 | O | SRP4 | ||
szSalesCategoryCode5_SRP5 | O | SRP5 | ||
cApplyFreightYN_AFT | O | AFT | ||
szShippingCommodityClass_SHCM | O | SHCM | ||
szShippingConditions_SHCN | O | SHCN | ||
szRateCode_FRAT | O | FRAT | ||
szRouteCode_ROUT | O | ROUT | ||
szStopCode_STOP | O | STOP | ||
szZoneNumber_ZON | O | ZON | ||
mnExtendedVolume_ITVL | O | ITVL | ||
szVolumeUnitOfMeasure_VLUM | O | VLUM | ||
cApplyCommissionYN_ACOM | O | ACOM | ||
mnSalesperson1_SLSM | O | SLSM | ||
mnRate1_SLCM | O | SLCM | ||
mnSalesperson2_SLM2 | O | SLM2 | ||
mnRate2_SLC2 | O | SLC2 | ||
szTaxExplanationCode_EXR1 | O | EXR1 | ||
szTaxArea1_TXA1 | O | TXA1 | ||
szUserReservedCode_URCD | O | URCD | ||
jdUserReservedDate_URDT | O | URDT | ||
mnUserReservedAmount_URAT | O | URAT | ||
mnUserReservedNumber_URAB | O | URAB | ||
szUserReservedReference_URRF | O | URRF | ||
mnTradeDiscount_TRDC | O | TRDC | ||
szCostPricingGroup_PRGP | O | PRGP | ||
szAccountNumber_CACT | O | CACT | ||
jdExpiredDate_CEXP | O | CEXP | ||
szAuthorizationNo_AUTN | O | AUTN | ||
szDeliveryInstructLine1_DEL1 | O | DEL1 | ||
szDeliveryInstructLine2_DEL2 | O | DEL2 | ||
szFreightHandlingCode_FRTH | O | FRTH | ||
szTransferToBranchPlant_TMCU | C | TMCU | This is required if the order is a transfer order as specified in the processing options. | |
szComputerID_CTID | X | CTID | This is defaulted in the interface. | |
szPurchasingReportCode1_PRP1 | O | PRP1 | ||
szPurchasingReportCode2_PRP2 | O | PRP2 | ||
szPurchasingReportCode3_PRP3 | O | PRP3 | ||
szPurchasingReportCode4_PRP4 | O | PRP4 | ||
mnProcessID_PEID | O | PEID | This is an internal parameter - not to be passed in. | |
mnTransactionID_TCID | O | TCID | This is an internal parameter - not to be passed in. | |
szCertificateTaxExempt_TXCT | O | TXCT | ||
mnInvoiceCopies_INVC | O | INVC | ||
mnBuyerNumber_ANBY | O | ANBY | ||
cPricePickListYN_PLST | O | PLST | ||
szHoldOrdersCode_HOLD | O | HOLD | ||
mnPOExchangeRate_CRRD | O | CRRD | Unused. | |
mnSecondaryQuantity_SQOR | O | SQOR | ||
szSecondaryUnitOfMeasure_UOM2 | O | UOM2 | ||
mnRequestedDeliveryTime_DRQT | O | DRQT | ||
mnPromisedPickTime_PDTT | O | PDDT | ||
mnScheduledShipmentTime_PMDT | O | PMDT | ||
mnPromisedDeliveryTime_RSDT | O | RSDT | ||
szPortOfEntryExit_POE | O | POE | ||
mnRetShipmentNumber_SHPN | ||||
mnToShipmentNumber_SHPN | ||||
szMobileOrderNumber_DS50 | ||||
szProductionNumber_PMPN | ||||
mnProductionNumberShort_PNS | ||||
cSuppressPNGenerate_EV01 | ||||
mnGenerateProdNumShort_PNS | ||||
cPMPNEnabled_PNYN | ||||
szReference2_VR02 | ||||
szReference3_VR03 | ||||
Lot/Serial Control | Refer to Special Processing Interface Usage Guide for additional information on Lot/Serial Control. | |||
DUAL Unit of Measure Parameters | Refer to Special Processing Interface Usage Guide for DUAL Unit of Measure parameter details. | |||
Globally Unique Identifier (GUID) Fields | GUID values are all optional unless a business must comply with FDA 21 CFR Part 11 auditing requirements. Refer to Special Processing Interface Usage Guide for GUID Input Data Structure details. | |||
Lot/Serial Control | Refer to Special Processing Interface Usage Guide for additional information on Lot/Serial Control. |
R = Required
O = Optional
X = Required but will default in if not passed
C = Conditional (see explanation for conditions)
Required fields
The following fields are each required for the interface in certain circumstances.
-
Action Code (cdcLINKActionCode_EV01) field: Required (but, if left blank, it will default to a “C”). See the Action Code Usage section for more information.
-
Version (szVersion_VERS) field: We recommend passing this in, particularly since it specifies the default Order Type and other important fields.
-
Branch Plant (szBranchPlant_MCU) field: Must be passed in, unless it is specified in the processing options. It is good form to pass this in.
-
Order Number (mnOrderNumber_DOCO) field: Required if adding a line or deleting a line. If it is passed in when creating an order, the number passed in is validated (using Order Number, Order Type, and Company) as an original order number. If it is not passed in when creating an order, it will automatically be generated, based on a next number (Next Number System 42. The number will depend on how they are set up).
-
Order Company (szCompany_KCOO) field: If not passed in, this be retrieved from the Business Unit Master. It is standard practice to pass this in.
-
Order Type (szOrderType_DCTO) field: If not passed in, this will be retrieved from the processing options.
-
Item Number (szIdentifier2ndItem_LITM) field: Either the 2nd Item number or the Short Item number must be passed in.
-
Quantity (mnTransactionQty_UORG) field: Required.
-
Ship To (mnAddressNumberShipTo_SHAN) field: Required unless the order is a transfer order (as set in the processing options). In this case, the Transfer To Branch Plant field will be a required field.
-
Transfer To Branch Plant (szTransferToBranchPlant_TMCU) field: Required only if the order is a transfer order (as set in the processing options).
Transaction test scenarios
The following test scenarios demonstrate a variety of ways this interface could be used, and the fields that would be passed for each scenario.
The data structure fields are in the left column and the corresponding values for each scenario are listed by column.
Field name | Sales Order Maintenance test | Sales Order Edit test | Sales Order Mobile: New order | Sales Order Mobile: Add line |
---|---|---|---|---|
cdcLINKActionCode_EV01 | C | E | C | A |
cActionCode_ACTION | D | D | ||
szVersion_VERS | ZJDE0001 | ZJDE0001 | ZJDE0001 | |
szBranchPlant_MCU | 30 | 30 | 30 | 30 |
mnOrderNumber_DOCO | 3451 | 3198 | ||
szOrderType_DCTO | ST | S4 | S4 | S4 |
szCompany_KCOO | 1 | |||
szLineType_LNTY | S | |||
mnLineNumber_LNID | 2 | |||
szIdentifier2ndItem_LITM | 222 | 220 | 210 | 210 |
szUnitOfMeasure_UOM | EA | EA | EA | |
mnTransactionQty_UORG | 10 | 5 | 15 | |
szLocation_LOCN | 1 A 2 | |||
szLot_LOTN | ROY5000 | |||
mnSoldToAddress_AN8 | 4343 | 4242 | 4242 | |
mnAddressNumberShipTo_SHAN | 4343 | 4242 | 4242 | |
szLastStatusCode_LTTR | 560 | |||
szNextStatusCode_NXTR | 575 | |||
szTransferToBranchPlant_TMCU | M30 | |||
szReference2_VR02 | Advanced Inventory | Advanced Inventory |
Common error messages
The following common error messages can be generated by this interface.
Error message | Description |
---|---|
1 | Action Invalid |
2 |
Record Invalid
In the context of this BF, this error is returned when an error has been detected from one of these three business functions: dcLINK Set User ID, dcLINK Utility Set Audit Info, or dcLINK Utility Write Signature Capture Record.
|
3 | Blanks Invalid |
138T | Action Code Invalid |
303A | Branch Plant Required |
272 | Tax Area Invalid |
267 | Item Number Invalid |
150Z | Branch Plant Not In Same Company |
41 | Order Number - Invalid |
041| | Ship to address number in invalid |
508 | Line Number Must Be Unique |
056P | Order quantity cannot be zero |
302 | Item Master Record Not Found |
128X | Invalid UDC value |
078H | Update to table &1 failed |
200S | Shipment information unavailable |
113C | Reserved by &1 |
4046 | Sales Order Detail not found |
072T | Sales Order Header not found |
041H | Sold to address number is invalid |
006J | Invalid Unit of Measure |
2486 | Payment Instrument Invalid |
504 | Print Message Not Set Up |
4104 | Invalid Carrier Number |
130 | Payment Terms Code Invalid |
2545 | Invalid Approval Route Code |
748 | Tax Explanation Code Invalid |
491A | Freight Handling Code Invalid |
99 | Invalid Hold Code |
Business service
The business service has a different structure than the rest of the process. It has both internal objects and publish objects.
Publish objects are used to make calls to the process, and contain managers that are indirectly accessible from the external system. Internal objects have processors that are not accessible from the external system.
The interface user needs to get the WSDL file from the web logic server in order to call the service. Every business service parameter requires a unique calling method to process the transaction.
The following objects are incorporated in the business service.
Name | Object type | Description |
---|---|---|
JD3N421A | OMW object | dsi Sales Order Maintenance Processor |
Value Object | dsiInternalGetSalesOrderMaintenance | |
Business Service Class | dsiSalesOrderMaintenanceProcessor | |
JPD3N42A | OMW Object | dsi Sales Order Maintenance Manager |
Value Object | dsiGetSalesOrderMaintenanceInfo | |
Value Object | dsiShowSalesOrderMaintenanceInfo | |
Publish Business Service Class | dsiSalesOrderMaintenanceManager | |
JD3N421E | OMW object | dsi Sales Order Edit Processor |
Value Object | dsiInternalGetSalesOrderEdit | |
Business Service Class | dsiSalesOrderEditProcessor | |
JPD3N42E | OMW Object | dsi Sales Order Edit Manager |
Value Object | dsiGetSalesOrderEditInfo | |
Value Object | dsiShowSalesOrderEditInfo | |
Publish Business Service Class | dsiSalesOrderEditManager | |
JD3N421M | OMW object | dsi Sales Order Mobile Processor |
Value Object | dsiInternalGetSalesOrderMobile | |
Business Service Class | dsiSalesOrderEditProcessor | |
OMW Object | dsi Sales Order Mobile Manager | |
Value Object | dsiGetSalesOrderMobileInfo | |
Value Object | dsiShowSalesOrderMobileInfo | |
Publish Business Service Class | dsiSalesOrderMobileManager |
To test this business service, please refer to Transaction test scenarios. For best practices, to avoid errors with the platform, send only those parameters that have associated values. Also note that the user must add the SoapUI header tag for JD Edwards when calling the web service from any location.
References
The interface calls the following related functions.
Object name | Description |
---|---|
BD3N0009 | dcLINK Utility – Turn Debug On and Off |
BD3NSETA | dcLINK Set Audit Info |
BD3NSETU | dcLINK Set User ID |
BD3N4206 | PO Retrieval – Sales Order Maintenance |
FD3N5001 | dcLINK Order Number |
ND3NGUID | dcLINK Utility Write Signature Capture |
Loading...
There was a problem loading this topic