Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
nIndexNumber | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due.
|
nNumberOfKeys | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due.
|
cCacheActionCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cCacheCodeError | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
runtime error message handling.
1 = suppress runtime error message handling. |
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
|
cRecordFoundInTable | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnIdentifierShortItem | 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
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 |
szIdentifier2ndItem | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
alternative item numbers. The three types of item numbers are:
Item Number (short)
An 8-digit, computer-assigned item number.
2nd Item Number
A
25-digit, user defined, alphanumeric item number.
3rd Item Number
Another 25-digit, user defined, alphanumeric item number.
In addition to
these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous
cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or
supplier numbers.
|
szIdentifier3rdItem | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
numbers are as follows:
1. Item Number (short) - An 8-digit, computer-assigned item number.
2. 2nd Item Number - The 25-digit, free-form, user
defined alphanumeric item number.
3. 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number.
In addition to
these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to
alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier
numbers. |
szDescriptionLine1 | DSC1 | char | OPT | INPUT |
Brief information about an item; a remark or an explanation.
|
szDescriptionLine2 | DSC2 | char | OPT | NONE |
A second, 30-character description, remark, or explanation.
|
szLineType | 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
General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under
which a line prints on reports, and it is included in calculations. Codes include the following:
S
Stock item
J
Job cost
N
Nonstock item
F
Freight
T
Text information
M
Miscellaneous charges and credits
W
Work order |
szUnitOfMeasurePrimary | 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
(each) or KG (kilogram). |
szUnitOfMeasureSecondary | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. |
szUnitOfMeasurePurchas | UOM3 | char | OPT | NONE |
A code (table 00/UM) that identifies the unit of measure in which you usually purchase the item. |
szUnitOfMeasurePricing | UOM4 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. |
szUnitOfMeasureShipping | UOM6 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually ship the item. |
szUnitOfMeasureProduction | UOM8 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you produce the item. |
szUnitOfMeasureAllocation | UOM9 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure for an item when the item serves as a component, for example, for a bill of
material or work order parts list. |
szUnitOfMeasureWeight | UWUM | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to indicate weight for this item. You can specify ounces,
grams, kilograms, and so on, as weight standards. The system uses this unit of measure for the item or overrides it for an individual item or
container. |
szUnitOfMeasureVolume | UVM1 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure by metric conversion for ambient volume. For example, the unit of measure
code for a gallon might be GL, or for a liter it might be LT. |
cRoundToWholeNo | SNS | char | OPT | NONE |
A code that determines whether the system performs rounding for planning purposes. Valid values are:
R Round either up or down to the
nearest whole number.
U Round up to the nearest whole number.
Blank Do not round.
Example of value R: If the calculated requirements for
an item are 4.6, the system rounds the quantity required to 5.0. If the calculated requirements are 4.4, the system rounds the quantity required
to 4.0.
Example of value U: If the calculated requirements for an item are greater than 4.0 and less than or equal to 5.0, the system rounds the
quantity required to 5.0. |
cStockingType | STKT | char | OPT | NONE |
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
types are hard-coded and you should not change them:
0 Phantom item
B Bulk floor stock
C Configured item
E Emergency/corrective
maintenance
F Feature
K Kit parent item
N Nonstock
The first character of Description 2 in the user defined code table indicates if the item
is purchased (P) or manufactured (M). |
cBackordersAllowedYN | BACK | char | OPT | NONE |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
Branch/Plant (P41026) programs, by customer using the Customer Billing Instructions program (P03013), or by branch/plant using the
Branch/Plant Constants program (P41001). Valid values are:
On
Allow backorders for this item.
Off
Do not allow backorders for this item, regardless of
the backorders code that is assigned to the customer.
|
cCheckAvailabilityYN | CKAV | char | OPT | NONE |
A code that specifies whether the system performs availability checking. You might want to turn on availability checking for certain items.
For other items, if you assume that an adequate supply is available, leave availability checking turned off. For PeopleSoft World, valid values
are:
Y
The system performs availability checking.
N
The system does not perform availability checking.
For PeopleSoft EnterpriseOne, a
check mark indicates that availability checking is turned on.
|
cCostLevel | CLEV | char | OPT | 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 |
cPriceLevel | PLEV | char | OPT | NONE |
A code that indicates whether the system maintains standard sales prices for an item, different sales prices for each branch/plant, or
different sales prices for each location and lot within a branch/plant. The system maintains sales prices in the Base Price file (F4106). Valid codes
are:
1 Item level
2 Item/Branch level
3 Item/Branch/Location level |
cMethodOfPriceCalcula | PMTH | char | OPT | NONE |
A code that determines how the system calculates the price for kit items or configured items. Valid values are:
Blank
Use for items that are
neither kit items nor configured items.
1
The system accumulates the base prices of components with the configured price adjustments, and
then discounts the total.
2
The system accumulates the base price of the parent item with the configured price adjustments, and then discounts
the total.
3
The system accumulates the configured price adjustments, and then discounts the total.
4
The system accumulates the individually
discounted price of the components with the configured price adjustments.
Note: Configured price adjustments are only included in the
calculation for a configured item. Also, the system only discounts costs if you are using the Advanced Pricing system.
The following is an example of
how the system uses the various methods:
Parent Item: 125
Component A: 50
Component B: 100
Configured Cost Adjustment 1: 15
Configured
Cost Adjustment 2: 10
Advanced Price Discount: 10%
Methods:
1: 50 + 100 = 150 + 15 + 10 = 175 - 17.50 = 157.5
2: 125 + 15 + 10 = 150 - 15 = 135
3:
15 + 10 + 25 - 2.5 = 22.5
4: (50 - 5) + (100 - 10) = 135 + 15 + 10 = 160
|
cMethodOfCostCalcula | CMETH | char | OPT | NONE |
A code that indicates how the system calculates the cost for a configured item. Valid values are:
1
The system accumulates the base costs
of the components with the configured cost adjustments, and then discounts the total.
2
The system accumulates the base cost of the parent
item with the configured cost adjustments, and then discounts the total.
3
The system accumulates the configured cost adjustments, and then
discounts the total.
4
The system accumulates the individually discounted costs of the components with the configured cost adjustments.
Note:
The system discounts the costs only if you are using the Advanced Pricing system.
The following is an example of how the system uses the
various methods:
Parent Item: 125
Component A: 50
Component B: 100
Configured Cost Adjustment 1: 15
Configured Cost Adjustment 2:
10
Advanced Price Discount: 10%
Methods:
1: 50 + 100 = 150 + 15 + 10 = 175 - 17.50 = 157.5
2: 125 + 15 + 10 = 150 - 15 = 135
3: 15 + 10 + 25 - 2.5 = 22.5
4:
(50 - 5) + (100 - 10) = 135 + 15 + 10 = 160
|
szItemSpecificUOM | TFLA | char | OPT | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
unit of measure
1 Bypass the item-specific unit of measure and use the standard unit of measure |
szPricingCategory | 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
structures that direct the system to incorporate discounts or markups on items on sales and purchase orders. The discounts or markups are
based on the quantity, dollar amount, or weight of the item ordered. When you assign a price group to an item, the item takes on the same pricing
structure defined for the inventory price group.
You must assign an inventory price group to the supplier or customer, as well as to the item, for
the system to interactively calculate discounts and markups on sales orders and purchase orders. |
szRepriceBasketPriceCat | RPRC | char | OPT | NONE |
You can assign items with common repricing characteristics to a reprice category on Item Branch/Plant Revisions. You can define different
categories based on location. Repricing is a technique that the system uses to:
o Accumulate items on order that belong to a common
repricing category during a batch program
o Compare the aggregate quantities of items on order to the appropriate quantity breaks in the
reprice category
If the items qualify for an additional discount, that discount is reflected as a change in unit and extended price for each
qualifying item in the original order line. |
szOrderRepriceCategory | ORPR | char | OPT | NONE |
Items with common order repricing characteristics are assigned to an order reprice category on the Item Master Revisions screen.
Categories can be varied at the Location level (fold area). Order repricing is a technique in which items within an order that belong to the same
repricing category are accumulated during a batch program and their aggregate quantities are compared to the appropriate quantity "breaks" in
the reprice category. Typical quantity breaks in this situation might be the total weight or the total dollar value of the order as whole. If the
items qualify for additional discount, that discount is reflected as a flat dollar amount in a new discount line. This facility supplements the repricing
function and operates in the same batch program. |
cSerialNumberRequired | SRNR | char | OPT | NONE |
A code that specifies whether you must attach a serial number to this item at receipt or sale for basic serial number processing, or whether
memo lot information is required for advanced serial number processing. Advanced serial number processing allows you to use a serial
number to track an item through purchasing and sales. For basic serial number processing, valid values are:
Y
Yes, the system requires a serial
number for all transactions pertaining to this item in related inventory, sales, and purchase order programs.
N
No, the system does not require
a serial number.
To specify lots for items with serial numbers, valid values are:
3
Supplier lot number is required (purchasing only).
4
Supplier
lot number is required (purchasing only). Memo lot 1 is also required.
5
Supplier lot number is required (purchasing only). Memo lot 1 and
memo lot 2 are also required.
6
Non-serialized item number (CSMS only).
Values 3 through 5 specify whether lot assignment is required for items
with serial numbers. You can require assignment of up to three lot numbers, including supplier lot, memo lot 1, and memo lot 2.
|
cLotStatusCode | LOTS | char | OPT | NONE |
A user defined code (41/L) that indicates the status of the lot. If you leave this field blank, it indicates that the lot is approved. All other codes
indicate that the lot is on hold.
You can assign a different status code to each location in which a lot resides on Item/Location Information or
Location Lot Status Change. |
cLotProcessType | SRCE | char | OPT | NONE |
A code that indicates whether lot or serial number is assigned. Lot and serial number processes use the Lot Master table (F4108).
Valid
codes are:
0 Lot assignment is optional. You can manually assign numbers. Quantity can be greater than one. (Default)
1 Lot assignment is
required. The system assigns numbers using the system date in YYMMDD format. Quantity can be greater than one.
2 Lot assignment is
required. The system assigns numbers in ascending order using Next Numbers. Quantity can be greater than one.
3 Lot assignment is
required. You must manually assign numbers. Quantity can be greater than one.
4 Serial number assignment is optional except during shipment
confirmation. Quantity must not exceed one.
5 Serial number assignment is required. The system assigns numbers using the system date
in YYMMDD format. Quantity must not exceed one.
6 Serial number assignment is required. The system assigns numbers in ascending
order using Next Numbers. Quantity must not exceed one.
7 Serial number assignment is required. You must manually assign numbers.
Quantity must not exceed one. |
mnLeadtimeLevel | LTLV | MATH_NUMERIC | OPT | NONE |
A value that represents the leadtime for an item at its assigned level in the production process, as defined on Plant Manufacturing Data.
The system uses this value to calculate the start dates for work orders using fixed leadtimes.
Level leadtime is different for purchased and
manufactured items:
Purchased - The number of calendar days required for the item to arrive at your branch/plant after the supplier receives your
purchase order.
Manufactured - The number of workdays required to complete the fabrication or assembly of an item after all the
components are available.
You can enter level leadtime manually on Manufacturing Values Entry, or you can use the Leadtime Rollup program to
calculate it. To calculate level leadtime using the Leadtime Rollup program, you must first enter a quantity in the Manufacturing Leadtime Quantity
field in the Item Branch table (F4102). |
mnLeadtimeMfg | LTMF | MATH_NUMERIC | OPT | NONE |
The total number of days required to build an item from its lowest level components to the final assembly. This value is the total of the level
leadtimes for all manufactured items, plus the highest manufacturing leadtime for all its components.
If all components are purchased, the
manufacturing leadtime equals the item's level leadtime. Purchased item leadtimes are not included in the calculation of manufacturing
leadtimes.
You can enter the manufacturing leadtime manually or you can have the system calculate it when you run the Leadtime Rollup program. |
mnLeadtimeCum | LTCM | MATH_NUMERIC | OPT | NONE |
The total number of days required to build an item from its lowest level components to the final assembly. The system calculates the value
differently for manufactured and purchased items.
Manufactured - The total of all level leadtimes for all manufactured items,plus the highest
cumulative leadtime of all its components.
Purchased - The item's level leadtime. Purchased item leadtimes are included in the calculation of
cumulative leadtimes.
You can enter this value manually or you can have the system calculate it when you run the Leadtime Rollup program. |
mnMfgLeadtimeQty | MLQ | MATH_NUMERIC | OPT | NONE |
The quantity that determines the leadtime level for a manufactured item. Each of the routing steps for the item are extended by this quantity.
For the system to calculate the leadtime level, the quantity in this field must be a value other than zero. |
mnLeadtimePerUnit | LTPU | MATH_NUMERIC | OPT | NONE |
The total number of hours required to build one unit as specified on the routing. This value is factored by the time basis code.
You can enter
this value manually or you can have the system calculate it when you run the Leadtime Rollup program. The system overwrites this value
when you run the Leadtime Rollup program.
The system uses this field to calculate start dates for work orders when you use variable leadtimes. |
cFixedVariableLeadtime | MRPP | char | OPT | NONE |
A code that determines whether the system uses fixed or variable leadtimes.
This code works in conjunction with the value from either the
Level Leadtime field or the Leadtime Per Unit field. Valid codes are:
F Fixed leadtime - The system calculates work order start dates using the
value from the Leadtime Level field.
V Variable leadtime - The system calculates work order start dates using the value from the Leadtime
Per Unit field. |
cIssueTypeCode | ITC | char | OPT | NONE |
A code that indicates how the system issues each component in the bill of material from stock. In Shop Floor Management, it indicates how
the system issues a part to a work order. Valid values are:
I Manual issue
F Floor stock (there is no issue)
B Backflush (when the part is
reported as complete)
P Preflush (when the parts list is generated)
U Super backflush (at the pay-point operation)
S Sub-contract item (send
to supplier)
Blank Shippable end item
You can issue a component in more than one way within a specific branch/plant by using different
codes on the bill of material and the work order parts list. The bill of material code overrides the branch/plant value. |
cCrossDockFlag | XDCK | char | OPT | NONE |
A code that associates items or order lines with cross-dock processing. This code might indicate whether an item or an order line is eligible
for cross-docking, whether it was cross-docked, or whether it needs to be cross-docked. When it is assigned to an item or item-branch, this
code indicates that the item or the item in the branch/plant is eligible for cross-docking. When it is assigned to an order line, this code
indicates that the order line needs to be cross docked. Valid values are:
1
Yes, cross-docking is on
0 (blank)
No, cross-docking is off
|
cLevelPurchasingPrice | PPLV | char | OPT | NONE |
A code that indicates where to retrieve the purchase price for an item when you enter a purchase order. Valid codes are:
1 Use the
supplier/item price from the Purchase Price table (F41061).
2 Use the supplier/item/branch price from the Purchase Price table (F41061).
3 Use
the inventory cost from the Inventory Cost table (F4105). This cost is based on the inventory cost level and the purchasing cost method you
specify for the item.
The first two codes are applicable only if you set up supplier costs in the Procurement system. If you do not set up
supplier costs, the system uses the inventory cost as the default for the purchase order. |
cConstraintsFlag | APSC | char | OPT | NONE |
A code that specifies that the entity is constraint-based and can be planned by SCP.
|