D4500450A - Get F42UI11 Basket/Formula Information
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cRetrieveFromCache | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
szComputerID | CTID | char | OPT | INPUT |
mnJobnumberA | JOBS | MATH_NUMERIC | OPT | INPUT |
The job number (work station ID) which executed the particular job. | ||||
mnLineNumberXREF | LNIX | MATH_NUMERIC | OPT | INPUT |
mnDocumentOrderInvoiceE | DOCO | MATH_NUMERIC | OPT | 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 | OPT | 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
| ||||
szCompanyKeyOrderNo | KCOO | char | OPT | 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 | OPT | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnAmountExtendedPrice | AEXP | MATH_NUMERIC | OPT | OUTPUT |
The number of units multiplied by the unit price. | ||||
mnAmountOpen1 | AOPN | MATH_NUMERIC | OPT | OUTPUT |
The amount of the order, invoice, or voucher that is still unpaid or open.
When you enter a document (for example, an order, invoice, or
| ||||
mnDiscountCash | CADC | MATH_NUMERIC | OPT | OUTPUT |
A discount which is passed forward from the manufacturer or mill to the customer based upon the payment terms of the supplier. Enter 10
| ||||
mnCurrencyConverRateOv | CRR | MATH_NUMERIC | OPT | OUTPUT |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
mnDiscountFactor | DSPR | MATH_NUMERIC | OPT | OUTPUT |
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
| ||||
mnAmountExtendedCost | ECST | MATH_NUMERIC | OPT | OUTPUT |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnDaysPastExpiration | 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
| ||||
mnAmountForeignExtPrice | FEA | MATH_NUMERIC | OPT | OUTPUT |
The product of the foreign price times the number of units. | ||||
mnAmountForeignExtCost | FEC | MATH_NUMERIC | OPT | OUTPUT |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
mnAmountListPriceForeign | FPRC | MATH_NUMERIC | OPT | OUTPUT |
The list price in the unit of measure of the base price retrieved from the Base Price File (F4106). This is the price the customer would pay if
| ||||
mnFromPotency | FRMP | MATH_NUMERIC | OPT | OUTPUT |
A number that indicates the minimum potency or percentage of active ingredients acceptable for an item.
The system displays a warning
| ||||
mnAmountForeignUnitCost | FUC | MATH_NUMERIC | OPT | OUTPUT |
Amount - Foreign Unit Cost | ||||
mnAmtForPricePerUnit | FUP | MATH_NUMERIC | OPT | OUTPUT |
The foreign price per unit. | ||||
mnGrossWeight | GRWT | MATH_NUMERIC | OPT | OUTPUT |
Essentially a memo field at present, this value is intended to reflect the fact that many inventory items are always packaged in the same
| ||||
mnAmountUnitVolume | ITVL | MATH_NUMERIC | OPT | OUTPUT |
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
| ||||
mnAmountUnitWeight | ITWT | MATH_NUMERIC | OPT | OUTPUT |
The weight of one unit of an item, expressed in the primary unit of measure. | ||||
mnAmtListPricePerUnit | LPRC | MATH_NUMERIC | OPT | OUTPUT |
The list price in the unit of measure of the base price retrieved from the Base Price File (F4106). This is the price the customer would pay if
| ||||
mnUnitsPrimaryQtyOrder | PQOR | MATH_NUMERIC | OPT | OUTPUT |
The quantity ordered by the customer expressed in the primary stocking unit of measure. | ||||
mnQuantityRelieved | QRLV | MATH_NUMERIC | OPT | OUTPUT |
Unit relieved (future use). | ||||
mnQuantityShippedToDate | QTYT | MATH_NUMERIC | OPT | OUTPUT |
The number of units which have passed through the Sales Update process. In Workorder Processing, this field identifies the total quantity
| ||||
mnUnitsQuanBackorHeld | SOBK | MATH_NUMERIC | OPT | OUTPUT |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
| ||||
mnUnitsQuantityCanceled | SOCN | MATH_NUMERIC | OPT | OUTPUT |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
mnUnitsQuantityFuture | SONE | MATH_NUMERIC | OPT | OUTPUT |
The number of inventory units tentatively committed to this order line. Such tentative commitment may occur through the use of Blanket
| ||||
mnUnitsQuantityShipped | SOQS | MATH_NUMERIC | OPT | OUTPUT |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnExtendedCostTransfer | TCST | MATH_NUMERIC | OPT | OUTPUT |
This is the cost of transferring inventory from one branch to another. The method of calculating this transfer cost is maintained in the Inter
| ||||
mnThruPotency | THRP | MATH_NUMERIC | OPT | OUTPUT |
A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item.
The system displays a
| ||||
mnDiscountTrade | TRDC | MATH_NUMERIC | OPT | OUTPUT |
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
| ||||
mnAmountUnitCost | UNCS | MATH_NUMERIC | OPT | OUTPUT |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnUnitsOpenQuantity | UOPN | MATH_NUMERIC | OPT | OUTPUT |
The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and
| ||||
mnUnitsTransactionQty | UORG | MATH_NUMERIC | OPT | OUTPUT |
The quantity of units affected by this transaction. | ||||
mnAmtPricePerUnit2 | UPRC | MATH_NUMERIC | OPT | OUTPUT |
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
| ||||
mnUserReservedAmount | URAT | MATH_NUMERIC | OPT | OUTPUT |
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. | ||||
cErrorCode | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
szRepriceBasketPriceCat | RPRC | char | OPT | OUTPUT |
You can assign items with common repricing characteristics to a reprice category on Item Branch/Plant Revisions. You can define different
| ||||
szOrderRepriceCategory | ORPR | char | OPT | OUTPUT |
Items with common order repricing characteristics are assigned to an order reprice category on the Item Master Revisions screen.
| ||||
cOrderRepricedIndicator | ORP | char | OPT | OUTPUT |
(Future Use) (internal use) Indicates whether this order line has been processed by the Order Repricing facility. This is used to prevent a
| ||||
jdDatePriceEffectiveDate | PEFJ | JDEDATE | OPT | OUTPUT |
The system uses the Price Effective Date to determine the base price and all advanced price adjustments. The value loaded in this date
| ||||
szUnitOfMeasureEntUP | APUM | char | OPT | OUTPUT |
The basic measurement abbreviation used to designate the quantity of an inventory item.
Examples are:
BA bale
LB - pound
BG bag
| ||||
szRateCodeFrieghtMisc | 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
| ||||
szItemPriceGroup | 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
| ||||
szShippingCommodityClass | SHCM | char | OPT | NONE |
A user defined code (41/E) that represents an item property type or classification (for example, international shipment handling). The
| ||||
szShippingConditionsCode | 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
| ||||
szStopCode | 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
| ||||
szPrimaryUOM | UOM1 | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
|
None |
None |