D4202310B - Sales Order Detail
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cOrderAction | ACTN | char | REQ | INPUT |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
mnOrderNumber | DOCO | MATH_NUMERIC | REQ | INPUT |
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 | char | REQ | INPUT |
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
| ||||
szOrderCompany | KCOO | char | REQ | INPUT |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnLineNumber | LNID | MATH_NUMERIC | REQ | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szDetailBranchPlant | MCU | char | REQ | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szSupplierReference | VR02 | char | REQ | INPUT |
A field available to record reference numbers, such as the supplier's bid document number, quote document, sales order, work order, or
| ||||
mnShipToAddressNumber | SHAN | MATH_NUMERIC | REQ | INPUT |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
jdTransactionDate | TRDJ | JDEDATE | OPT | INPUT |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
jdRequestedDate | DRQJ | JDEDATE | OPT | INPUT |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdScheduledPickDate | PDDJ | JDEDATE | OPT | INPUT |
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
| ||||
jdPromisedShipDate | PPDJ | JDEDATE | REQ | INPUT |
The promised shipment date for a sales order. This date represents the day that the item can be shipped from the warehouse. | ||||
jdPromisedDeliveryDate | RSDJ | JDEDATE | OPT | INPUT |
The date an item will be delivered to the customer. | ||||
jdOriginalPromisedDate | OPDJ | JDEDATE | REQ | INPUT |
The original promised delivery date for a purchase order. | ||||
jdCancelDate | CNDJ | JDEDATE | OPT | INPUT |
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
| ||||
jdPriceEffectiveDate | PEFJ | JDEDATE | OPT | INPUT |
The system uses the Price Effective Date to determine the base price and all advanced price adjustments. The value loaded in this date
| ||||
mnQuantityShipped | SOQS | MATH_NUMERIC | OPT | INPUT |
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 | MATH_NUMERIC | OPT | INPUT |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
| ||||
mnQuantityCancelled | SOCN | MATH_NUMERIC | OPT | INPUT |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
szTransactionUnitOfMeasure | UOM | char | REQ | INPUT |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnUnitPrice | UPRC | MATH_NUMERIC | REQ | INPUT |
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 | MATH_NUMERIC | REQ | INPUT |
The number of units multiplied by the unit price. | ||||
mnForeignUnitPrice | FUP | MATH_NUMERIC | OPT | INPUT |
The foreign price per unit. | ||||
cPriceOverrideCode | PROV | char | OPT | INPUT |
A value established by the sales order entry program whenever a unit or extended price is entered into an order line item, overriding the
| ||||
mnAdjustmentRevisionLevel | AREV | MATH_NUMERIC | OPT | INPUT |
This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
| ||||
mnDiscountPercentage | DSPR | MATH_NUMERIC | OPT | INPUT |
The factor that the system applies to the unit price of an inventory item to determine the net price. The system retrieves this value from the
| ||||
mnLastIndex | LINX | MATH_NUMERIC | OPT | INPUT |
This is the index that was last used to calculate the annual escalated amount from the previous escalation generation. This field is updated
| ||||
szPaymentTerms | PTC | char | OPT | INPUT |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
cPaymentInstrument | RYIN | char | OPT | INPUT |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
szCurrencyCode | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction. | ||||
mnUnitCost | UNCS | MATH_NUMERIC | OPT | INPUT |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnExtendedCost | ECST | MATH_NUMERIC | OPT | INPUT |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnForeignUnitCost | FUC | MATH_NUMERIC | OPT | INPUT |
Amount - Foreign Unit Cost | ||||
mnForeignExtCost | FEC | MATH_NUMERIC | OPT | INPUT |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
szItemNumber | LITM | char | OPT | INPUT |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
mnShortItemNumber | ITM | MATH_NUMERIC | OPT | INPUT |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szLineType | LNTY | char | OPT | INPUT |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szLastStatus | LTTR | char | OPT | INPUT |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. | ||||
szNextStatus | NXTR | char | OPT | INPUT |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
szLocation | LOCN | char | OPT | INPUT |
The storage location from which goods will be moved. | ||||
szLineofBusiness | LOB | char | OPT | INPUT |
A user defined code (system 40, type LB) identifying a customer's line of business. | ||||
szEndUse | EUSE | char | OPT | INPUT |
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
| ||||
szDutyStatus | DTYS | char | OPT | INPUT |
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.
| ||||
szFreightHandlingCode | FRTH | char | OPT | INPUT |
A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to
| ||||
mnItemWeight | ITWT | MATH_NUMERIC | OPT | INPUT |
The weight of one unit of an item, expressed in the primary unit of measure. | ||||
szWeightUnitOfMeasure | WTUM | char | OPT | INPUT |
The unit of measure that indicates the weight of an individual item. Typical weight units of measure are:
GM Gram
OZ Ounce
LB Pound
| ||||
szModeOfTransport | MOT | char | OPT | INPUT |
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
| ||||
szSubledger | SBL | char | OPT | INPUT |
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 | char | OPT | INPUT |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szPriceCode1 | UPC1 | char | OPT | INPUT |
User defined code (system 40, type P1) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
szPriceCode2 | UPC2 | char | OPT | INPUT |
User defined code (system 40, type P2) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
szPriceCode3 | UPC3 | char | OPT | INPUT |
User defined code (system 40, type P3) you can use to control pricing adjustments. You can associate this code with a preference
| ||||
szOriginalPoSoNumber | OORN | char | OPT | INPUT |
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document
| ||||
szOriginalOrderType | OCTO | char | OPT | INPUT |
This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher
| ||||
szOriginalOrderCompany | OKCO | char | OPT | INPUT |
A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction. | ||||
mnRelatedPoSoLineNo | RLLN | MATH_NUMERIC | OPT | INPUT |
A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill
| ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | INPUT |
The date that specifies the last update to the file record. | ||||
mnPickSlipNumber | PSN | MATH_NUMERIC | OPT | INPUT |
A automatic next number assigned by the system that can be used to track picking information through the system. This number is
| ||||
mnInvoiceDocNumber | DOC | MATH_NUMERIC | OPT | INPUT |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szInvoiceDocType | DCT | char | OPT | INPUT |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szInvoiceDocCompany | KCO | char | OPT | INPUT |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
szUserReservedCode | URCD | char | OPT | INPUT |
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. | ||||
mnOriginalOrderLineNumber | OGNO | MATH_NUMERIC | OPT | INPUT |
A number identifying which line on the original order that the current line matches. | ||||
szRelatedPoSoNumber | RORN | char | OPT | INPUT |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
szRelatedOrderType | RCTO | char | OPT | INPUT |
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
| ||||
szRelatedOrderCompany | RKCO | char | OPT | INPUT |
The key company that is associated with the document number of the related order. | ||||
jdUserReservedDate | URDT | JDEDATE | OPT | INPUT |
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 | MATH_NUMERIC | OPT | INPUT |
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 | MATH_NUMERIC | OPT | INPUT |
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 | char | OPT | INPUT |
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. | ||||
szAlphaName | ALPH | char | OPT | OUTPUT |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
mnParentAddressNumber | PA8 | MATH_NUMERIC | OPT | OUTPUT |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
szSecondItemNumber | LITM | char | OPT | OUTPUT |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szThirdItemNumber | AITM | char | OPT | OUTPUT |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
cPriorityProcessing | PRIO | char | OPT | OUTPUT |
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
| ||||
cBackOrdersAllowed | BACK | char | OPT | OUTPUT |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
| ||||
cOrderShippedFlag | SO02 | char | OPT | OUTPUT |
A code that indicates if the committed inventory for this sales detail line has been relieved from the On Hand Quantity. A value of 1 reflects
| ||||
cTransferDirectShipFlag | SO11 | char | REQ | OUTPUT |
This flag indicates if the order line was created by way of a transfer order or a direct ship order.
Valid values are:
1 Transfer order
2
| ||||
cCommitted | COMM | char | OPT | OUTPUT |
A value that indicates whether you specified from which Location and Lot a particular item was to come. If you specified a storage area, the
| ||||
mnDaysBeforeExpiration | EXDP | MATH_NUMERIC | OPT | OUTPUT |
The number of days allowed before expiration for an item where it still can be used or sold to a specific customer. When negative, this
| ||||
szPurchasingCategoryCode1 | PRP1 | char | OPT | OUTPUT |
A code (table 41/P1) that represents an item property type or classification,such as commodity type, planning family, or so forth. The
| ||||
szPurchasingCategoryCode2 | PRP2 | char | OPT | OUTPUT |
A code (table 41/P2) that represents an item property type or classification,such as commodity type, planning family, or so forth. The
| ||||
szPurchasingCategoryCode3 | PRP3 | char | OPT | OUTPUT |
A code (UDC table 41/P3) that represents an item property type or classification, such as commodity type, planning family, or so forth. The
| ||||
szPurchasingCategoryCode4 | PRP4 | char | OPT | OUTPUT |
A user defined code (41/P4) that represents an item property type or classification, such as commodity type or planning family. The system
| ||||
szRelatedOrderNumber | RORN | char | OPT | OUTPUT |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
szRelatedOrderTypeAPS | RCTO | char | OPT | OUTPUT |
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
| ||||
szRelatedOrderKeyCompany | RKCO | char | OPT | OUTPUT |
The key company that is associated with the document number of the related order. | ||||
szPlanningUnitOfMeasure | UOM | char | REQ | OUTPUT |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnPlanningQuantity | TRQT | MATH_NUMERIC | REQ | OUTPUT |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
jdDateUpdatedAPS | UPMJ | JDEDATE | REQ | OUTPUT |
The date that specifies the last update to the file record. | ||||
mnTimeUpdatedAPS | TDAY | MATH_NUMERIC | REQ | OUTPUT |
The computer clock in hours:minutes:seconds. | ||||
cAPSFlag | EV01 | char | REQ | OUTPUT |
An option that specifies the type of processing for an event. | ||||
cAPSSupplyDemandFlag | EV01 | char | REQ | OUTPUT |
An option that specifies the type of processing for an event. | ||||
szShipComplete | DSC1 | char | REQ | OUTPUT |
Brief information about an item; a remark or an explanation. | ||||
mnRelatedOrderLineNumber | RLLN | MATH_NUMERIC | REQ | OUTPUT |
A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill
| ||||
mnForeignExtPrice | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
cTaxableYN | 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
| ||||
szPriceAdjustmentSchedule | ASN | char | OPT | NONE |
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
szDescriptionLine1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDescriptionLine2 | DSC2 | char | OPT | NONE |
A second, 30-character description, remark, or explanation. | ||||
szLot | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
szPrintMessage1 | 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
| ||||
mnCarrier | 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
| ||||
szSalesReportingCode1 | 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. | ||||
szSalesReportingCode2 | SRP2 | char | OPT | NONE |
One of ten category codes for sales coding purposes. These codes can represent such classifications as color, material content, or
| ||||
szSalesReportingCode3 | 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. | ||||
szSalesReportingCode4 | 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
| ||||
szSalesReportingCode5 | 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
| ||||
mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
szTaxArea | 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
| ||||
szTaxExplanationCode | 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
| ||||
szPartnerItemNo | CITM | char | OPT | NONE |
The cross-reference item number that the system assigns to an item number. A cross-reference number allows you to use a supplier's item
| ||||
szCatalogItem | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szUPCNumber | UPCN | char | OPT | NONE |
The Universal Product Code number which must conform to the UCC structure for UPC numbers. | ||||
szShipToDescriptive | ALKY | char | OPT | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
szSoldToDescriptive | ALKY | char | OPT | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
szProductItem | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
mnQuantityOrdered | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
szPricingUnitOfMeasure | UOM4 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
mnRelatedWOOrderNumber | 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,
| ||||
szRelatedWOBranchPlant | MMCU | char | OPT | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
jdActualShipDate | ADDJ | JDEDATE | OPT | NONE |
The date on which the shipment to the customer is confirmed as shipped. During shipment confirmation, the system updates the Sales
|
None |
None |