Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnStockedQuantity | QTYS | MATH_NUMERIC | NONE | NONE |
The number of units that were placed in stock following receipt routing. |
mnReturnedQuantity | QTYR | MATH_NUMERIC | NONE | NONE |
The number of units that you returned to the supplier through receipt routing.
You can return goods for credit or for replacement. The system
writes these transactions as new lines on the original purchase order. |
mnScrappedQuantity | QTYC | MATH_NUMERIC | NONE | NONE |
The number of units that you scrapped during receipt routing. |
mnReworkedQuantity | QTYW | MATH_NUMERIC | NONE | NONE |
The number of units that will be reworked as a result of receipt routing. |
mnRejectedQuantity | QTYJ | MATH_NUMERIC | NONE | NONE |
The number of units that you rejected during receipt routing. |
mnAdjustedQuantity | QTYA | MATH_NUMERIC | NONE | NONE |
The number of units that you adjusted during the receipt routing. |
mnUnitsOrdered | UORD | MATH_NUMERIC | NONE | NONE |
|
mnUnitsReceived | UREC | MATH_NUMERIC | NONE | NONE |
The original quantity of the order line, plus or minus any changes to that quantity, less all quantities shipped, received and/or vouchered to
date. This number can also be the actual quantity received. |
mnUnitsPaid | UPTD | MATH_NUMERIC | NONE | NONE |
The units paid to date on an invoice or voucher. |
mnAmountOrdered | AODR | MATH_NUMERIC | NONE | NONE |
Indicates the amount ordered. The system updates and writes the value in this field at the time of purchase order entry. |
mnAmountReceived | AREC | MATH_NUMERIC | NONE | NONE |
The value of the goods received to date against the original order line. |
mnAmountPaid | APTD | MATH_NUMERIC | NONE | NONE |
The amount paid to date on an invoice or voucher. |
mnAverageLeadTime | ALTD | MATH_NUMERIC | NONE | NONE |
The average number of days from the date of the purchase order to the date that you receive the item. The system calculates leadtime
after it meets the leadtime quantity percentage during receipt entry or during receipt routing.
You define the leadtime quantity percentage on the
Supplier/Item Relationships form (V43090). |
mnLastLeadTime | LLTD | MATH_NUMERIC | NONE | NONE |
The last actual number of days from the date of the purchase order to the date that you received the item.
For example, if you enter an order
on 12/01/98 and receive that order on 12/05/98 and it was the last order that you received for that item from that supplier, the last leadtime is 4
(12/05/98 - 12/01/98).
NOTE: The system does not calculate leadtime until the quantity meets the leadtime quantity percentage that you
specified on the Supplier/Item Relationships form. |
mnAverageCost | ACST | MATH_NUMERIC | NONE | NONE |
Average unit cost paid for the item. When you run Voucher Match in program (P43134) to match the receipt to a voucher, the system
calculates this cost by using the weighted average for quantity and cost. |
mnLastCost | LCST | MATH_NUMERIC | NONE | NONE |
Indicates the last unit cost paid that you paid for this item from this supplier. The system displays this value in the item's purchasing unit of
measure and updates it each time you match a receipt to a voucher. |
mnNumberOfOrders | NOOD | MATH_NUMERIC | NONE | NONE |
The number of orders you have received from this supplier for a specific item.
For this field, one line on a purchase order is equal to one
order.
For example:
o The system counts a purchase order with two lines that you receive at one time as one purchase order.
o The system
counts a purchase order with one line that you receive as two partial receipts as one purchase order. |
mnAmountOnTime | AONT | MATH_NUMERIC | NONE | NONE |
Indicates the amount of a receipt that was received on time. The system determines this value comparing the promised date in the
purchase order to the receipt date. If a supplier item relationship record (F43090) exists for a supplier and item, the Days Early and Days Late fields
are considered in determining if the amount was received on time. The system updates this field only once per purchase order line and once
when the amount received meets or exceeds the leadtime quantity percentage from the supplier item relationship record. |
mnAmountEarly | AEAR | MATH_NUMERIC | NONE | NONE |
Indicates the amount of a receipt that was received early. The system determines this value by comparing the promised date on the
purchase order to the receipt date. If a supplier item relationship record (F43090) exists for a supplier and item, the Days Early field will be
considered in determining if the receipt is early. The system updates only once per purchase order line and once when the amount received meets
or exceeds the leadtime quantity percentage from the supplier item relationship record. |
mnAmountLate | ALAT | MATH_NUMERIC | NONE | NONE |
Indicates the amount that was received late. The system determines this value by comparing the promised date from the purchase order to
the receipt date.
If a supplier item relationship record (F43090) exists for a supplier and item, the Days Late field is will be considered in
determining if the amount is late. The system updates this field only once per purchase order line and once when the amount received meets or
exceeds the leadtime quantity percentage from the supplier item relationship record. |
mnUnitsOnTime | UONT | MATH_NUMERIC | NONE | NONE |
This field determines the units received on time. The system determines this value by comparing the promised date in the purchase order
to the receipt date. If a supplier item relationship record (F43090) exists for a supplier and item, the Days Late field is considered in
determining if the units are late. The system updates this field once per purchase order line and once when the units received meets or exceeds the
leadtime quantity percentage from the supplier item relationship record. |
mnUnitsEarly | UEAR | MATH_NUMERIC | NONE | NONE |
This field determines the units received early. The system determines this value by comparing the promised date in the purchase order to
the receipt date. If a supplier item relationship record (F43090) exists for a supplier and item, the Days Late field is considered in determining
if the receipt is late. The system updates this field only once per purchase order line and once when the quantity received meets or exceeds
the leadtime quantity percentage from the supplier item relationship record |
mnUnitsLate | ULAT | MATH_NUMERIC | NONE | NONE |
Indicates the units received late. The system determines this value by comparing the promised date in the purchase order to the receipt
date. If a supplier item relationship record (F43090) exists for a supplier and item, the Days Late field is considered in determining if the receipt
is late. The system updates this field only once per purchase order line and once when the quantity received meets or exceeds the
leadtime quantity percentage from the supplier item relationship record |
mnReceiptOnTime | RONT | MATH_NUMERIC | NONE | NONE |
This field determines the number of receipts that were received on time. The system determines this value by comparing the promised
date in the purchase order to the receipt date. If a supplier item relationship record (F43090)
exists for a supplier and item, the Days Late field is
considered in determining if the receipt is late. The system updates this field only once per purchase order line and once when the quantity
received meets or exceeds the leadtime quantity percentage from the supplier item relationship record |
mnReceiptEarly | REAR | MATH_NUMERIC | NONE | NONE |
Indicates the number of receipts that were received early. The system determines this value by comparing the promised date in the
purchase order to the receipt date. If a supplier item relationship record (F43090) exists for a supplier and item, the Days Early field is considered in
determining if the receipt is early. The system updates this field only once per purchase order line and once when the quantity received
meets or exceeds the leadtime quantity percentage from the supplier item relationship record. |
mnReceiptLate | RLAT | MATH_NUMERIC | NONE | NONE |
This field determines the number of receipts that were received late. The system determines this value by comparing the promised date in
the purchase order to the receipt date. If a supplier item relationship record (F43090)
exists for a supplier and item, the Days Late field is
considered in determining if the receipt is late. The system updates this field only once per purchase order line and once when the quantity
received meets or exceeds the leadtime quantity percentage from the supplier item relationship record |
szQTYSFlag | DL01 | char | NONE | NONE |
A user defined name or remark. |
szQTYRFlag | DL01 | char | NONE | NONE |
A user defined name or remark. |
szQTYCFlag | DL01 | char | NONE | NONE |
A user defined name or remark. |
szQTYWFlag | DL01 | char | NONE | NONE |
A user defined name or remark. |
szQTYJFlag | DL01 | char | NONE | NONE |
A user defined name or remark. |
szQTYAFlag | DL01 | char | NONE | NONE |
A user defined name or remark. |
mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:
o Item Number (short) - An eight-digit, computer-assigned item number
o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number
o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number |
szBranchPlant | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
mnSupplierNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
cCostLevel | CLEV | char | NONE | NONE |
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a
different cost for each location and lot within a branch/plant. The system maintains inventory costs in the Inventory Cost table (F4105).
Valid codes
are:
1 Item level
2 Item/Branch level
3 Item/Branch/Location level |
cInquiryMode | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event.
|
szFormulaColumn01 | FMLA | char | NONE | NONE |
A calculation that the system uses to determine an amount or quantity for this column. You can use a single predefined value or multiple
predefined values in conjunction with mathematical operators to enter a formula. Valid mathematical operators
are:
+
Add
-
Subtract
*
Multiply
/
Divide
( )
Left and right parentheses for nesting
For example, you can enter the following formula to have the system calculate on-time
percentages:
20/(20+21+22)
The formula above equals on-time percentages for the following reasons:
o 20 is the value for on-time amounts.
o 21 is the
value for early amounts.
o 22 is the value for late amounts.
|
szFormulaColumn02 | FMLA | char | NONE | NONE |
A calculation that the system uses to determine an amount or quantity for this column. You can use a single predefined value or multiple
predefined values in conjunction with mathematical operators to enter a formula. Valid mathematical operators
are:
+
Add
-
Subtract
*
Multiply
/
Divide
( )
Left and right parentheses for nesting
For example, you can enter the following formula to have the system calculate on-time
percentages:
20/(20+21+22)
The formula above equals on-time percentages for the following reasons:
o 20 is the value for on-time amounts.
o 21 is the
value for early amounts.
o 22 is the value for late amounts.
|
szFormulaColumn03 | FMLA | char | NONE | NONE |
A calculation that the system uses to determine an amount or quantity for this column. You can use a single predefined value or multiple
predefined values in conjunction with mathematical operators to enter a formula. Valid mathematical operators
are:
+
Add
-
Subtract
*
Multiply
/
Divide
( )
Left and right parentheses for nesting
For example, you can enter the following formula to have the system calculate on-time
percentages:
20/(20+21+22)
The formula above equals on-time percentages for the following reasons:
o 20 is the value for on-time amounts.
o 21 is the
value for early amounts.
o 22 is the value for late amounts.
|
szFormulaColumn04 | FMLA | char | NONE | NONE |
A calculation that the system uses to determine an amount or quantity for this column. You can use a single predefined value or multiple
predefined values in conjunction with mathematical operators to enter a formula. Valid mathematical operators
are:
+
Add
-
Subtract
*
Multiply
/
Divide
( )
Left and right parentheses for nesting
For example, you can enter the following formula to have the system calculate on-time
percentages:
20/(20+21+22)
The formula above equals on-time percentages for the following reasons:
o 20 is the value for on-time amounts.
o 21 is the
value for early amounts.
o 22 is the value for late amounts.
|
idPtrToColumnResult | GENLNG | ID | NONE | NONE |
General purpose ID variable. |
mnColumn01Display | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value.
|
mnColumn02Display | MATH02 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance High Value.
|
mnColumn03Display | MATH03 | MATH_NUMERIC | NONE | NONE |
- - - Bad Performance Low Value.
|
mnColumn04Display | MATH04 | MATH_NUMERIC | NONE | NONE |
Event point for Math Numeric. |
mnMultiplierColumn1 | MLTP | MATH_NUMERIC | NONE | NONE |
The factor by which the amounts or unit quantities in a column are multiplied.
The result of the calculation in the Formula field is multiplied by
this factor before it is displayed on the Job Status Inquiry form.
For example, if you want to scale down extremely large numbers to thousands,
enter .001. If you want percentages to be displayed as whole numbers, enter 100.
|
mnMultiplierColumn2 | MLTP | MATH_NUMERIC | NONE | NONE |
The factor by which the amounts or unit quantities in a column are multiplied.
The result of the calculation in the Formula field is multiplied by
this factor before it is displayed on the Job Status Inquiry form.
For example, if you want to scale down extremely large numbers to thousands,
enter .001. If you want percentages to be displayed as whole numbers, enter 100.
|
mnMultiplierColumn3 | MLTP | MATH_NUMERIC | NONE | NONE |
The factor by which the amounts or unit quantities in a column are multiplied.
The result of the calculation in the Formula field is multiplied by
this factor before it is displayed on the Job Status Inquiry form.
For example, if you want to scale down extremely large numbers to thousands,
enter .001. If you want percentages to be displayed as whole numbers, enter 100.
|
mnMultiplierColumn4 | MLTP | MATH_NUMERIC | NONE | NONE |
The factor by which the amounts or unit quantities in a column are multiplied.
The result of the calculation in the Formula field is multiplied by
this factor before it is displayed on the Job Status Inquiry form.
For example, if you want to scale down extremely large numbers to thousands,
enter .001. If you want percentages to be displayed as whole numbers, enter 100.
|
szCertifiedStatus | CERS | char | NONE | NONE |
A code that indicates whether the supplier is certified to sell this item. The code that you enter determines how the system manages orders
that you enter for the supplier and item.
Valid values are:
Please see UDC 43/CR Special handling codes are:
1 The system prohibits you
from purchasing this item from the supplier.
2 The system displays a warning message if you enter an order for the item from the
supplier.
Blank You can place orders for the item from the supplier. |