| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|
| mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
^ |
| szPrimaryItemNumber | UITM | char | NONE | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. |
| szSecondItemNumber | LITM | char | NONE | 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.
|
| szThirdItemNumber | AITM | char | NONE | 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. |
| szDescription | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation.
|
| szDescriptionLine2 | DSC2 | char | NONE | NONE |
A second, 30-character description, remark, or explanation.
|
| szItemFlashMessage | IFLA | char | NONE | NONE |
User defined code system 40, type FL, which is used to flash a warning message about a particular item. |
| szPrimaryUOM | UOM1 | char | NONE | 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). |
| szSecondaryUOM | UOM2 | char | NONE | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. |
| szPurchasingUOM | UOM3 | char | NONE | NONE |
A code (table 00/UM) that identifies the unit of measure in which you usually purchase the item. |
| szPricingUOM | UOM4 | char | NONE | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. |
| szShippingUOM | UOM6 | char | NONE | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually ship the item. |
| szWeightUOM | UWUM | char | NONE | 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. |
| szVolumeUOM | UVM1 | char | NONE | 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. |
| cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event.
|
| szErrorMessageID | DTAI | char | NONE | 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.
|
| 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.
|
| cBackOrdersAllowedYN | BACK | char | NONE | 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.
|
| cStockingType | STKT | char | NONE | 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). |
| cBulkPackedFlag | BPFG | char | NONE | NONE |
A code that indicates if the item is a bulk liquid product. If it is a bulk product, you must perform temperature and density/gravity
conversions. To record the movement of bulk products, you must use forms designed specifically for bulk products. If you try to record movement using
standard inventory forms, the system prevents the movement. Valid values are:
P Packaged
B Bulk liquid
If you leave this field blank, the
system uses P. |
| cInventoryCostLevel | 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 |
| szLineType | LNTY | char | NONE | 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 |
| cLotProcessType | SRCE | char | NONE | 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. |
| mnShelfLifeDays | SLD | MATH_NUMERIC | NONE | NONE |
The number of days that an item can remain in inventory before it expires. The system adds this number to the date that the item is received
to determine the expiration date for the item. If you do not enter a value here, you must enter an expiration date each time you receive the lot
item. |
| szGLClassCode | GLPT | char | NONE | 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
you do not want to specify a class code, you can enter **** (four asterisks) in this field.
You can use automatic accounting instructions (AAIs) to
predefine classes of automatic offset accounts for the Inventory Management, Procurement, and Sales Order Management systems. You
might assign G/L class codes as follows:
IN20 Direct Ship Orders
IN60 Transfer Orders
IN80 Stock Sales
The system can generate
accounting entries based upon a single transaction. For example, a single sale of a stock item can trigger the generation of accounting entries
similar to the following:
Sales-Stock (Debit) xxxxx.xx
A/R Stock Sales (Credit) xxxxx.xx
Posting Category: IN80
Stock Inventory
(Debit) xxxxx.xx
Stock COGS (Credit) xxxxx.xx
The system uses the class code and the document type to find the AAI. |
| cContractItem | CONT | char | NONE | NONE |
An indication, updated internally, that there are one or more formal contracts in place which specify a quantity and price at which this item is
to be sold to specific customers. |
| szProductionUOM | UOM8 | char | NONE | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you produce the item. |
| szFromGrade | FRGD | char | NONE | NONE |
A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item.
The system displays a warning message if
you try to purchase or issue items with grades that do not meet the minimum grade acceptable. The system does not allow you to sell items
with grades that do not meet the minimum acceptable level. |
| szThruGrade | THGD | char | NONE | NONE |
A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item.
The system displays a warning message if
you try to purchase or issue items with grades that exceed the maximum grade acceptable. The system does not allow you to sell items with
grades that exceed the maximum grade acceptable. |
| mnFromPotency | FRMP | MATH_NUMERIC | NONE | NONE |
A number that indicates the minimum potency or percentage of active ingredients acceptable for an item.
The system displays a warning
message if you try to purchase or issue items that do not meet the minimum acceptable potency. The system does not allow you to sell items
that do not meet the minimum acceptable potency. |
| mnThruPotency | THRP | MATH_NUMERIC | NONE | NONE |
A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item.
The system displays a
warning message if you try to purchase or issue items that have a potency that exceeds the maximum potency acceptable. The system does
not allow you to sell items that have a potency that exceeds the maximum potency acceptable. |
| cPriceLevel | PLEV | char | NONE | 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 |
| cGradePotencyPricing | PRPO | char | NONE | NONE |
A user defined code (41/05) that groups several items that contain the same requirements for the Stock Valuation system. Valuation
methods are set up by item or pool. The items assigned to the pool use the pool's designated valuation methods for extracting and valuing the
inventory.
Enter a valid user defined code (41/05) if you want this item to be valued within a pool rather than as an individual item. |
| cRoundToWholeNumber | SNS | char | NONE | 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. |
| cKitPricingMethod | PMTH | char | NONE | 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
|
| szComponentUOM | UOM9 | char | NONE | 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. |
| szStandardUOMConversion | TFLA | char | NONE | 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 |
| mnBuyer | BUYR | MATH_NUMERIC | NONE | NONE |
The address number of the person responsible for setting up and maintaining the correct stocking levels for the item. |
| mnPlannerNumber | ANPL | MATH_NUMERIC | NONE | NONE |
The address number of the material planner for this item. |
| szPrintMessage | INMG | char | NONE | NONE |
A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of
operation during holiday periods, and special delivery instructions. |
| cCommitmentMethod | CMGL | char | NONE | NONE |
A code that indicates the method that the system uses to commit lot items from inventory. Valid codes are:
1 The normal commitment
method for inventory. The system commits inventory from the primary location and then from secondary locations.
The system commits
inventory from the locations with the most inventory before committing inventory from locations with the least. The system commits backorders to
the primary location.
2 The inventory commitment method by lot number. The system commits inventory by lot number, starting with the
lowest lot number and committing orders to available lots.
3 The inventory commitment method by lot expiration date. The system commits
inventory from the locations with the earliest expiration date first. The system considers only locations with expiration dates greater than or equal
to the sales order or parts list requested date. |
| cCheckAvailability | CKAV | char | NONE | 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.
|
| cSerialNumberReqsted | SRNR | char | NONE | 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 | NONE | 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. |
| cPurchasePriceLevel | PPLV | char | NONE | 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. |
| szTemplate | TMPL | char | OPT | NONE |
A template name that you can use when entering items on Item Master Revisions (P4101). This name is case sensitive. If you use any
capital letters in the template name when you add it, you must enter those letters in capitals whenever you search for or attach the template to Item
Master Revisions. |
| szSegment1 | SEG1 | char | OPT | NONE |
The first section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not exceed
25 characters. |
| szSegment2 | SEG2 | char | OPT | NONE |
The second section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not
exceed 25 characters. |
| szSegment3 | SEG3 | char | OPT | NONE |
The third section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not exceed
25 characters. |
| szSegment4 | SEG4 | char | OPT | NONE |
The fourth section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not exceed
25 characters. |
| szSegment5 | SEG5 | char | OPT | NONE |
The fifth section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not exceed
25 characters. |
| szSegment6 | SEG6 | char | OPT | NONE |
The sixth section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not exceed
25 characters. |
| szSegment7 | SEG7 | char | OPT | NONE |
The seventh section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not
exceed 25 characters. |
| szSegment8 | SEG8 | char | OPT | NONE |
The eighth section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not
exceed 25 characters. |
| szSegment9 | SEG9 | char | OPT | NONE |
The ninth section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not exceed
25 characters. |
| szSegment10 | SEG0 | char | OPT | NONE |
The tenth section of a segmented item. You can assign up to 10 segments to an item as long as the sum of the segments does not exceed
25 characters. |
| cMatrixControlled | MIC | char | OPT | NONE |
A user defined code (41/MA) that specifies the relationship between a matrix item and its parent. This code also determines whether the
system displays the item in matrix detail information.
|
| cDualUnitOfMeasureItem | DUAL | char | OPT | NONE |
An option that indicates that the system must maintain inventory balances and record transactions for an item in a secondary unit of
measure that does not have a fixed conversion to the primary unit of measure. Typically, you choose this option when the item is ordered or sold by
a packaged quantity and priced by weight or volume.
Note: For a dual unit of measure item, the system might require a tolerance check for
inventory transactions (excluding inventory adjustments) between the primary unit of measure and the secondary unit of measure. |
| cDualPickingProcessOption | DPPO | char | OPT | NONE |
An option that determines for a dual unit of measure item whether the system uses the primary or secondary unit of measure for the following
processes:
o Picking
o Sales order availability checking
o Committing inventory for sales
o Splitting purchase order lines
To use the
primary unit of measure, do not choose this option. To use the secondary unit of measure, choose this option. |
| mnDualTolerance | DLTL | MATH_NUMERIC | OPT | NONE |
A number, expressed as a percentage, that the system uses to ensure that the primary and dual quantities on a transaction are within a
certain range of the standard conversion. For example, assume that you enter three percent as the dual tolerance for an item and that a case of
the item weighs approximately 100 pounds. When the system confirms shipment for a case of the item, you must enter a weight between 97
and 103 pounds to be within dual tolerance. The system does not check dual tolerance for inventory adjustments due to evaporation or
shrinkage. |