DD3N4210 - dcLink Sales Order Maintenance
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cdcLINKActionCode_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cActionCode_ACTION | ACTION | char | OPT | NONE |
A code that indicates the activity you want to perform. Valid codes are:
A Add new record
C Change existing record
D Delete existing
| ||||
jdDateUpdated_UPMJ | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeLastUpdated_UPMT | UPMT | MATH_NUMERIC | OPT | NONE |
The time that specifies when the program executed the last update to this record. | ||||
szUserId_USER | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szWorkStationId_JOBN | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
mnJobnumber_JOBS | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
szProgramId_PID | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szVersion_VERS | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
cSuppressErrorMessage_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorCode_ERRC | ERRC | char | OPT | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
szErrorMessageKey_EKEY | EKEY | char | OPT | NONE |
A 4-digit number assigned to all errors.
When this number is used in the error message facility (F7 from any form), you may enter a specific
| ||||
iDebugLevel_INT01 | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
szBranchPlant_MCU | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
mnOrderNumber_DOCO | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderType_DCTO | DCTO | char | OPT | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szCompany_KCOO | KCOO | char | OPT | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
szOrderSuffix_SFXO | SFXO | char | OPT | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
szLineType_LNTY | LNTY | char | OPT | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
mnLineNumber_LNID | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szIdentifier2ndItem_LITM | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
mnIdentifierShortItem_ITM | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szUnitOfMeasure_UOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnTransactionQty_UORG | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnUnitPrice_UPRC | UPRC | MATH_NUMERIC | OPT | NONE |
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
| ||||
mnExtendedPrice_AEXP | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
szLocation_LOCN | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szLot_LOTN | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
mnSoldToAddress_AN8 | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnAddressNumberShipTo_SHAN | SHAN | MATH_NUMERIC | OPT | NONE |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
szCurrencyCodeFrom_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
mnExchangeRate_CRR | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
szCurrencyCodeTo_CRDC | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
cCurrencyMode_CRRM | CRRM | char | OPT | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
szCustomerPO_VR01 | VR01 | char | OPT | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
| ||||
jdOrderDate_TRDJ | TRDJ | JDEDATE | OPT | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
jdDateRequested_DRQJ | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdPScheduledPickDate_PDDJ | PDDJ | JDEDATE | OPT | NONE |
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
| ||||
jdPromisedShipDate_PPDJ | PPDJ | JDEDATE | OPT | NONE |
The promised shipment date for a sales order. This date represents the day that the item can be shipped from the warehouse. | ||||
jdCancelDate_CNDJ | CNDJ | JDEDATE | OPT | NONE |
The date that the order should be canceled if the goods have not been sent to the customer or the goods have not been received from the
| ||||
jdPromisedDeliveryDate_RSDJ | RSDJ | JDEDATE | OPT | NONE |
The date an item will be delivered to the customer. | ||||
mnQuantityShipped_SOQS | SOQS | MATH_NUMERIC | OPT | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnQuantityBackordered_SOBK | SOBK | MATH_NUMERIC | OPT | NONE |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
| ||||
mnQuantityCanceled_SOCN | SOCN | MATH_NUMERIC | OPT | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
mnUnitCost_UNCS | UNCS | MATH_NUMERIC | OPT | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnExtendedCost_ECST | ECST | MATH_NUMERIC | OPT | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mSupplier_VEND | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
szDescription1_DSC1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDescription2_DSC2 | DSC2 | char | OPT | NONE |
A second, 30-character description, remark, or explanation. | ||||
szLastStatusCode_LTTR | LTTR | char | OPT | NONE |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. | ||||
szNextStatusCode_NXTR | NXTR | char | OPT | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
szLandedCost_PRP5 | PRP5 | char | OPT | NONE |
A user defined code (41/P5) that indicates the landed cost rule for an item.
The landed cost rule determines purchasing costs that exceed
| ||||
szPricingUoM_UOM4 | UOM4 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
szWeightUnitOfMeasure_WTUM | WTUM | char | OPT | NONE |
The unit of measure that indicates the weight of an individual item. Typical weight units of measure are:
GM Gram
OZ Ounce
LB Pound
| ||||
mnExtendedWeight_ITWT | ITWT | MATH_NUMERIC | OPT | NONE |
The weight of one unit of an item, expressed in the primary unit of measure. | ||||
cTaxableYN_TAX1 | TAX1 | char | OPT | NONE |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
| ||||
cPaymentInstrument_RYIN | RYIN | char | OPT | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
szPrintMessage_INMG | INMG | char | OPT | NONE |
A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of
| ||||
szAgreementNumber_DMCT | DMCT | char | OPT | NONE |
A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement
| ||||
mnAgreementSupplement_DMCS | DMCS | MATH_NUMERIC | OPT | NONE |
The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual
| ||||
szModeOfTransport_MOT | MOT | char | OPT | NONE |
A user defined code (00/TM) that describes the nature of the carrier being used to transport goods to the customer. For example, by rail, by
| ||||
mnCarrier_CARS | CARS | MATH_NUMERIC | OPT | NONE |
The address number for the preferred carrier of the item. The customer or your organization might prefer a certain carrier due to route or
| ||||
szDutyStatus_DTYS | DTYS | char | OPT | NONE |
A user defined code (system 40, type DS) identifying the duty status of an order line. You should only specify this value for duty reporting.
| ||||
szLineOfBusiness_LOB | LOB | char | OPT | NONE |
A user defined code (system 40, type LB) identifying a customer's line of business. | ||||
szEndUse_EUSE | EUSE | char | OPT | NONE |
User defined code (system 40, type EU) identifying the end use of an order line and used for duty reporting only. The system supplies a
| ||||
szRevenueBusinessUnit_EMCU | EMCU | char | OPT | NONE |
A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job,
| ||||
szPriceCode1_UPC1 | UPC1 | char | OPT | NONE |
User defined code (system 40, type P1) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
szPriceCode2_UPC2 | UPC2 | char | OPT | NONE |
User defined code (system 40, type P2) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
szPriceCode3_UPC3 | UPC3 | char | OPT | NONE |
User defined code (system 40, type P3) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
szItemPriceGroup_PRGR | PRGR | char | OPT | NONE |
A user defined code (system 40/type PI) that identifies an inventory price group for an item.
Inventory price groups have unique pricing
| ||||
szPaymentTerms_PTC | PTC | char | OPT | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
cPriorityCode_PRIO | PRIO | char | OPT | NONE |
A code that tells the system to handle this customer's orders on a priority basis. Use this value to set up print pick slips so you can choose
| ||||
szReasonCode_RCD | RCD | char | OPT | NONE |
A user defined code (42/RC) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning
| ||||
mnCashDiscount_CADC | CADC | MATH_NUMERIC | OPT | NONE |
A discount which is passed forward from the manufacturer or mill to the customer based upon the payment terms of the supplier. Enter 10
| ||||
szGLOffset_GLPT | GLPT | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
| ||||
szSubledger_SBL | SBL | char | OPT | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType_SBLT | SBLT | char | OPT | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szSalesCatalogSection_SRP1 | SRP1 | char | OPT | NONE |
One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or use. | ||||
szSubSection_SRP2 | SRP2 | char | OPT | NONE |
One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or
| ||||
szSalesCategoryCode3_SRP3 | SRP3 | char | OPT | NONE |
One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or use. | ||||
szSalesCategoryCode4_SRP4 | SRP4 | char | OPT | NONE |
One of ten category codes to be used for sales coding purposes. These codes can represent such classifications as color, material
| ||||
szSalesCategoryCode5_SRP5 | SRP5 | char | OPT | NONE |
One of ten category codes to be used for sales coding purposes. These codes can represent such classifications as color, material
| ||||
cApplyFreightYN_AFT | AFT | char | OPT | NONE |
An option that specifies whether the system performs freight calculations during processing. Valid values are:
On
The system performs
| ||||
szShippingCommodityClass_SHCM | SHCM | char | OPT | NONE |
A user defined code (41/E) that represents an item property type or classification (for example, international shipment handling). The
| ||||
szShippingConditions_SHCN | SHCN | char | OPT | NONE |
A code (table 41/C) that represents an item property type or classification,such as special shipping conditions. The system uses this code
| ||||
szRateCode_FRAT | FRAT | char | OPT | NONE |
The user defined code (system 41/type RT) for freight rate. This designates the amount that the customer is charged for postage, freight, or
| ||||
szRouteCode_ROUT | ROUT | char | OPT | NONE |
The route field is a user defined code (system 42, type RT) that represents the delivery route on which the customer resides. This field is
| ||||
szStopCode_STOP | STOP | char | OPT | NONE |
The stop code is a user defined code (system 42, type SP) that represents the stop on a delivery route. This field is one of several factors
| ||||
szZoneNumber_ZON | ZON | char | OPT | NONE |
The zone field is a user defined code (system 40, type ZN) that represents the delivery area in which the customer resides. This field is one
| ||||
mnExtendedVolume_ITVL | ITVL | MATH_NUMERIC | OPT | NONE |
The cubic units occupied by one inventory item. The definition of the unit itself (cubic feet, yards, meters, and so on) is defined in the volume
| ||||
szVolumeUnitOfMeasure_VLUM | VLUM | char | OPT | NONE |
The unit of measure for the cubic space occupied by an inventory item. Typical volume unit of measures are:
ML Milliliter
OZ Fluid Ounce
| ||||
cApplyCommissionYN_ACOM | ACOM | char | OPT | NONE |
Used to indicate whether the sales value or gross margin earned in this order detail line should be included in the calculation of
| ||||
mnSalesperson1_SLSM | SLSM | MATH_NUMERIC | OPT | NONE |
The first of two salespeople who have responsibility for or can receive a commission on sales to this customer.
You create this code by
| ||||
mnRate1_SLCM | SLCM | MATH_NUMERIC | OPT | NONE |
The percentage commission rate that the system uses in computing commission liability on sales made by salesperson 01. | ||||
mnSalesperson2_SLM2 | SLM2 | MATH_NUMERIC | OPT | NONE |
The second of two salespeople who have responsibility for or can receive a commission on sales to this customer.
You create this code by
| ||||
mnRate2_SLC2 | SLC2 | MATH_NUMERIC | OPT | NONE |
The percentage commission rate that the system uses in computing commission liability on sales made by salesperson 02. | ||||
szTaxExplanationCode_EXR1 | EXR1 | char | OPT | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
szTaxArea1_TXA1 | TXA1 | char | OPT | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
szUserReservedCode_URCD | URCD | char | OPT | NONE |
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
jdUserReservedDate_URDT | URDT | JDEDATE | OPT | NONE |
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedAmount_URAT | URAT | MATH_NUMERIC | OPT | NONE |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedNumber_URAB | URAB | MATH_NUMERIC | OPT | NONE |
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szUserReservedReference_URRF | URRF | char | OPT | NONE |
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future. | ||||
mnTradeDiscount_TRDC | TRDC | MATH_NUMERIC | OPT | NONE |
Percentage by which the system reduces the price of each item. This is the only discount that will be applied. You can override it if you
| ||||
szCostPricingGroup_PRGP | PRGP | char | OPT | NONE |
A user defined code (system 40/type PC) identifying the pricing group associated with this customer or supplier:
o For sales orders, you
| ||||
szAccountNumber_CACT | CACT | char | OPT | NONE |
The first of three fields available to record credit card transactions. This field allows you to record the customer's account number with the
| ||||
jdExpiredDate_CEXP | CEXP | JDEDATE | OPT | NONE |
This field is to record the account number and expiration date of credit cards used by your customers who make purchases from you. It is
| ||||
szAuthorizationNo_AUTN | AUTN | char | OPT | NONE |
This field lets you record the authorization number provided by the credit card company or bank which issued the card. | ||||
szDeliveryInstructLine1_DEL1 | DEL1 | char | OPT | NONE |
One of two fields that you use to enter delivery instructions. | ||||
szDeliveryInstructLine2_DEL2 | DEL2 | char | OPT | NONE |
The second of two fields that you use to enter delivery instructions. | ||||
szFreightHandlingCode_FRTH | FRTH | char | OPT | NONE |
A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to
| ||||
szTransferToBranchPlant_TMCU | TMCU | char | OPT | NONE |
szComputerID_CTID | CTID | char | OPT | NONE |
szPurchasingReportCode1_PRP1 | PRP1 | char | OPT | NONE |
A code (table 41/P1) that represents an item property type or classification,such as commodity type, planning family, or so forth. The
| ||||
szPurchasingReportCode2_PRP2 | PRP2 | char | OPT | NONE |
A code (table 41/P2) that represents an item property type or classification,such as commodity type, planning family, or so forth. The
| ||||
szPurchasingReportCode3_PRP3 | PRP3 | char | OPT | NONE |
A code (UDC table 41/P3) that represents an item property type or classification, such as commodity type, planning family, or so forth. The
| ||||
szPurchasingReportCode4_PRP4 | PRP4 | char | OPT | NONE |
A user defined code (41/P4) that represents an item property type or classification, such as commodity type or planning family. The system
| ||||
mnProcessID_PEID | PEID | MATH_NUMERIC | OPT | NONE |
A code that identifies the Inter-Process Communication ID. | ||||
mnTransactionID_TCID | TCID | MATH_NUMERIC | OPT | NONE |
szCertificateTaxExempt_TXCT | TXCT | char | OPT | NONE |
The number that tax authorities issue to tax-exempt individuals and companies to identify their tax-exempt status. | ||||
mnInvoiceCopies_INVC | INVC | MATH_NUMERIC | OPT | NONE |
The number of invoice copies required by the customer. The system prints the number of invoices specified in this field. The system
| ||||
mnBuyerNumber_ANBY | ANBY | MATH_NUMERIC | OPT | NONE |
The address book number that identifies who is responsible for setting up and maintaining the correct stocking levels for each inventory
| ||||
cPricePickListYN_PLST | PLST | char | OPT | NONE |
An option that indicates whether price information appears on the customer's pick list, purchase order, or sales order. Valid values
| ||||
szHoldOrdersCode_HOLD | HOLD | char | OPT | NONE |
A user defined code (42/HC) that identifies why an order is on hold. | ||||
mnPOExchangeRate_CRRD | CRRD | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
| ||||
mnSecondaryQuantity_SQOR | SQOR | MATH_NUMERIC | OPT | NONE |
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens. | ||||
szSecondaryUnitOfMeasure_UOM2 | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
szGuidUniqueID_GUID | CFRGUID | char | OPT | NONE |
szGuidApprover1_USR1 | USR1 | char | OPT | NONE |
The Address Book number of a user authorized to approve and submit batches to post for a group of secured users. Secured users are
| ||||
szGuidFullName1_FULLNAME1 | FULLNAME1 | char | OPT | NONE |
szGuidApprover2_USR2 | USR2 | char | OPT | NONE |
The address book number of a user restricted from approving and posting batches. The Approved By user is the only person allowed to
| ||||
szGuidFullName2_FULLNAME2 | FULLNAME2 | char | OPT | NONE |
mnGuidReasonCode1_REASON1 | REASON1 | MATH_NUMERIC | OPT | NONE |
szGuidCommentField_COMMENTS | COMMENTS | char | OPT | NONE |
mnGuidReasonCode2_REASON2 | REASON2 | MATH_NUMERIC | OPT | NONE |
szGuidCommentField2_2COMMENTS | 2COMMENTS | char | OPT | NONE |
szGuidScriptID_FMNMVERS | FMNMVERS | char | OPT | NONE |
szGuidTextMessage_TEXTMES | TEXTMES | char | OPT | NONE |
mnRequestedDeliveryTime_DRQT | DRQT | MATH_NUMERIC | OPT | NONE |
The time requested for delivery. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and enter
| ||||
mnPromisedPickTime_PDTT | PDTT | MATH_NUMERIC | OPT | NONE |
The time when the order is scheduled to be picked. Enter the time in the 24-hour format and include a leading zero if necessary. For
| ||||
mnScheduledShipmentTime_PMDT | PMDT | MATH_NUMERIC | OPT | NONE |
The scheduled time of a shipment. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and
| ||||
mnPromisedDeliveryTime_RSDT | RSDT | MATH_NUMERIC | OPT | NONE |
The promised time for a delivery. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and
| ||||
szPortOfEntryExit_POE | POE | char | OPT | NONE |
The port from which or to which the goods were shipped. For VAT reporting, certain countries require information about the port of exit or
|
None |
None |