Creating Item Templates for Field Groups

The item template field groups identify the item attributes (fields) to be used and the rules for their use. Creating field group templates is the first step in using the configurable item template feature. The item template field groups exist for attributes at the SetID level and at the business unit level.

When an existing field group template appears on a field group component, the system checks to see if the base table definition has changed; that is, if fields have been added to or deleted from the table. In this case, a message informs you which base table has changed. The system displays the Sync button, which gives you the option to synchronize your template with the new base table definition. This function is not required for new field group templates being created because, at the time of creation, all the fields on the base table appear.

When creating field group templates, you not only identify the item attributes (fields) to be used, but you also establish the rules for their use. On all components for field groups, the rows contain the item attributes (fields) and the columns contain the rules that can be applied to most item attributes:

This example illustrates the fields and controls on the Master Item Fields page in Add Mode (partial page). You can find definitions for the fields and controls later on this page.

 Master Item Fields page in Add Mode (partial page)

Page Name

Definition Name

Usage

Change List Maintenance - Search/View Criteria Page

IN_ITM_SCH_TMPL

Configure the search criteria based on the SetID with which the Change list is defined.

Change List Maintenance - Change Value Page

IN_ITM_CHG_TMPL

Change values on multiple fields for a group of items within a SetId and/or across business units. You may also add new values to fields having multiple values for the same Item or Item/Business unit combination.

Change List Maintenance - Add Value Page

IN_ITM_ADD_TMPL

Add child records by selecting records based on Template group.

List Permission Maintenance Page

ITEM_TML_LSTSEC_MNT

Award permission based on roles or user id.

Master Item Fields Page

MASTER_ITM_TML3

Choose fields for your configurable item template from the Master Item Fields (MASTER_ITEM_TBL) record. These fields are the basic setup to add a new item. This page is required for any configurable item template.

Inventory Item Fields Page

INV_ITEMS_TML3

Select fields for your configurable item template from the Inventory Item Fields (INV_ITEMS) record. These fields are inventory-related item attributes applied at the SetID level. The attributes remain consistent for the SetID/item ID combination across all inventory business units.

Master Item Fields Page

Item UOM Fields Page

IN_ITM_UM_TML3

Select fields for your configurable item template from the Item UOM Fields (INV_ITEM_UOM) record. These fields define item dimensions, such as weight and volume, and the units of measure to be applied at the SetID level.

Master Item Fields Page

UOM Type Fields Page

UM_TYPE_IN_TML3

Select the INV_UOM_TYPE field for your configurable item template from the Inventory Unit of Measure Type (UOM_TYPE_INV) record. This field specifies the UOM type (ordering, shipping, and stocking) for an inventory item.

Master Item Fields Page

Substitute Item Fields Page

SUB_ITEM_TML3

Select fields for your configurable item template from the Substitute Item Fields (SUBSTITUTE_ITM) record. These attributes define substitute items at the SetID level.

The Include In Batch check box is not available for this page because substitutes can only be entered for online pages. The Item Loader process cannot use substitutes from the configurable item template.

Master Item Fields Page

Purchasing Attribute Fields Page

PO_ITM_ATR_TML3

Select fields for your configurable item template from the Purchasing Item Attributes (PURCH_ITEM_ATTR) and Purchasing Item Accounts (PUR_ITM_ATTR_CF) records. These item attributes are used to complete the basic setup and ChartField combinations to set up a purchased item within PeopleSoft Purchasing. This component is only available if you have PeopleSoft Purchasing installed in your system.

Asset Attribute Fields Page

PO_ITM_AST_TML3

Select fields for your configurable item template from the Asset Item Attributes (ASSET_ITEM_ATTR) record. These item attributes are used within PeopleSoft Purchasing to identify the receipt items as asset purchases. This component is only available if you have PeopleSoft Purchasing installed in your system.

Purchasing Attribute Fields Page

Item Specification Fields Page

PO_ITM_SPEX_TML3

Select fields for your configurable item template from the Purchasing Item Specifications (ITEM_SPEX_PUR) record. These item attributes are used within PeopleSoft Purchasing to enter item specifications and descriptions. This component is only available if you have PeopleSoft Purchasing installed in your system.

Purchasing Attribute Fields Page

PO BU Item Attribute Fields Page

PO_ITM_BU_TML3

Select fields for your configurable item template from the Purchasing BU Item Attributes (PURCH_ITEM_BU) record. These item attributes are PeopleSoft Purchasing business unit defaults applied at the SetID level. This component is only available if you have PeopleSoft Purchasing installed in your system.

Purchasing Attribute Fields Page

Product Definition Fields Page

PROD_ITEM_TML3

Select fields for your configurable item template from the Product Items (PROD_ITEM) record. These item attributes are needed to define an item as a product at the SetID level for PeopleSoft Order Management and PeopleSoft Enterprise Pricer. This component is only available if you have PeopleSoft Order Management installed.

Margin Amount Fields Page

PROD_ITEM_CUR_TML3

Select fields for your configurable item template from the PROD_ITEM_CURR record. These attributes are used to establish the allowable margin range for a product entered on a sales order schedule after all discounts have been applied. This component is only available if you have PeopleSoft Order Management installed.

Product Definition Fields Page

Attributes By UOM Fields Page

PROD_UOM_TML3

Select fields for your configurable item template from the Product Attributes by Unit of Measure (PROD_UOM_CURR) record. These SetID-level product attributes are used to restrict the units of measure available for use in PeopleSoft Order Management, to define minimum and maximum order quantities, and to define valid order increments. This component is only available if you have PeopleSoft Order Management installed.

Product Definition Fields Page

Price By UOM Fields Page

PROD_UOM_CURR_TML3

Select fields for your configurable item template from the Product Unit of Measure (PROD_UOM) record. These product attributes are used to product prices at the SetID level. This component is only available if you have PeopleSoft Order Management installed.

Manufactured Item Page

ITM_MFG_TML3

Select fields for your configurable item template from the ITEM_MFG record. These attributes are used at the SetID level to define an item for use in the PeopleSoft Manufacturing application.

UPN Attributes Page

ITM_MFG_UPNTML3

If the item has a UPN ID (universal product number ID), use this page to select fields for your configurable item template from the ITEM_MFG_UPN_FS record. These attributes are used at the SetID level to define a item with a UPN ID for use in the PeopleSoft Manufacturing application.

Manufactured Item Page

GPO Attributes Page

ITM_MFG_GPOTML3

If the item has GPO (group purchasing organization) data, use this page to select fields for your configurable item template from the ITEM_MFG_GPO record. These attributes are used at the SetID level to define a item with GPO information for use in the PeopleSoft Manufacturing application.

Manufactured Item Page

Item Supplier Fields Page

ITM_VENDOR_TML3

Select fields for your configurable item template from the ITM_VENDOR record. These item attributes are used to complete the prioritized item-supplier combinations for a purchased item within PeopleSoft Purchasing.

Item Supplier Location Fields Page

ITMVND_LOC_TML3

Select fields for your configurable item template from the ITM_VENDOR_LOC record. These item attributes are used to complete the item-supplier location combinations for a purchased item within PeopleSoft Purchasing.

Item Supplier Fields Page

Item Supplier UOM Fields Page

ITMVND_UOM_TML3

Select fields for your configurable item template from the ITM_VNDR_UOM record. These item attributes are used to establish valid units of measure (UOM) to use when ordering the item from the supplier within PeopleSoft Purchasing.

Item Supplier Fields Page

Item Supplier UOM Price Fields Page

ITVND_UMPR_TML3

Select fields for your configurable item template from the ITM_VNDR_UOM_PR record. These item attributes are used to establish the pricing information for each valid unit of measure (UOM) when ordering the item from the supplier within PeopleSoft Purchasing.

Item Supplier Fields Page

Return to Supplier Fees Fields Page

ITMVND_RTV_TML3

Select fields for your configurable item template from the ITM_VND_RTV_FEE record. These item attributes are used to define any fees charged by the supplier for returning a purchased item within PeopleSoft Purchasing.

Item Supplier Fields Page

Supplier Item MFG Fields Page

ITMVND_MFG_TML3

Select fields for your configurable item template from the ITM_VENDOR_MFG record. These item attributes are used to record the authorized manufacturers for an item-supplier combination of a purchased item within PeopleSoft Purchasing.

Item Supplier Fields Page

Inventory Fields Page

BU_ITM_INV_TML3

Select fields for your configurable item template from the Business Unit Items (BU_ITEMS_INV) record. These fields are defined at the business unit level and are common item attributes across PeopleSoft Inventory business units.

Configuration Fields Page

BU_ITM_CFG_TML3

Select fields for your configurable item template from the Business Unit Item Configuration (BU_ITEMS_CONFIG) record. These fields are defined at the business unit level.

Inventory Fields Page

Utilization Code Fields Page

BU_ITM_UTL_TML3

Select fields for your configurable item template from the Business Unit Item Utilization Codes (BU_ITEM_UTIL_CD) record. These fields are defined at the business unit level and are used for ABC utilization groupings that you want to maintain in your system.

Inventory Fields Page

Weight/Volume Fields Page

BU_ITM_WTV_TML3

Select fields for your configurable item template from the Business Unit Items Weight & Volume (BU_ITEMS_WTVOL) record. These fields are defined at the business unit level.

Inventory Fields Page

Planning Attribute Fields Page

PL_ITEM_ATTR_TML3

Select fields for your configurable item template from the Planning Attributes (PL_ITEM_ATTRIB) record. These fields are defined at the business unit level.

Inventory Fields Page

Prdn Replenishment Loc Fields Page

SF_RPL_LOC_TML3

Select fields for your configurable item templates to be used for production replenishment in PeopleSoft Manufacturing. These fields are from the SF_REPL_INV and SF_WIP_REPL_REQ records. The SP_REPL_INV record defines production replenishment locations. This is required if you use PeopleSoft Flow Production. If you use PeopleSoft Manufacturing without PeopleSoft Flow Production, you can set up production replenishment defaults if you use the replenishment component-issue method.

Inventory Fields Page

Picking Zone Fields Page

PICK_ZONE_TML3

Select fields for your configurable item template from the Picking Zones (PICK_ZONE_INV) record. These fields are defined at the business unit level and are used to group storage locations into picking zones to help direct the picking operations within the PeopleSoft Inventory business unit.

Putaway Zone Fields Page

PTWY_ZONE_TML3

Select fields for your configurable item template from the Putaway Zones (PTWY_ZONE_INV) record. These fields are defined at the business unit level and are used to assign an item to a zone for inventory putaway.

Picking Zone Fields Page

Fixed Picking Location Fields Page

FXD_BIN_LOC_TML3

Select fields for your configurable item template from the Fixed Picking Locations (FIXED_BIN_LOC_INV) record. These fields are defined at the business unit level and are used to assign an item to a fixed picking location.

Picking Zone Fields Page

Default Putaway Loc Fields Page

DEFAULT_LOC_TML3

Select fields for your configurable item template from the Default Putaway Location (DEFAULT_LOC_INV) record. These fields are defined at the business unit level and are used to assign an item to a default putaway location.

Picking Zone Fields Page

Putaway Rule Fields Page

PTWY_IT_RULE_TML3

Select fields for your configurable item template from the Item Putaway Rules (PTWY_IT_RULE_IN) record. These fields are defined at the business unit level and are used to assign putaway rules for the item.

Picking Zone Fields Page

Fulfillment Attribute Fields Page

SETUP_ITM_TML3

Select fields for your configurable item template from the Item Fulfillment Attributes (DF_SETUP_IT_INV) record. These fields are needed to store item demand fulfillment attributes at the business unit level.

Auto Serial Numbering Fields Page

AUTO_NUM_TML3

Select fields for your configurable item template from the Automatic Serial Number Setup for Serialized Items (AUTO_SERIAL_NUM) record. These fields are needed to define the automatic numbering sequence for serialized items.

Fulfillment Attribute Fields Page

Use the Change List Maintenance - Search/View Criteria page (IN_ITM_SCH_TMPL) to configure the search criteria based on the SetID with which the Change list is defined. The page has two sections: the first sections displays Primary search criteria which includes the following fields:

  • From Item ID

  • To Item ID

  • UOM

  • Physical Nature

  • Item Group

  • Family

  • Category ID

The second section displays the Configurable Search Criteria which allows to select fields based on the selected records.

The Change List Maintenance pages consist of Search Criteria, Change Value, and Add Value options to perform corresponding tasks. Through Change List maintenance, the user can specify a field and associated value to be modifiable or read only. User can also leave the field value blank to be entered on run control.

Navigation:

Items > Change List Maintenance > Define Item Change Templates

This example illustrates the fields and controls on the Change List Maintenance — Search/View Criteria. You can find definitions for the fields and controls later on this page.

 Change List Maintenance - Search/View Criteria

Field or Control

Description

View Count

Allows to view count of rows returned on search execution

Modifiable

If the Modifiable checkbox is selected the user can modify(run control user can add new search criteria but cannot delete any) the search criteria in Run control. The user needs to enter a value in the search criteria in case the modifiable checkbox is not selected.

Note: The user cannot delete search criteria in Run control, which is defined in the Change List.

The user cannot search on business unit for which the permission is not granted.

Similarly the run control user will not be able to delete any change value or add value that is defined in the change list. The access to the change list component is mostly provided to super user only.

Use the Change List Maintenance - Change Value page (IN_ITM_CHG_TMPL) to change values on multiple fields for a group of items within a SetId and/or across business units. You may also add new values to fields having multiple values for the same Item or Item/Business unit combination.

Note: The modifications made in the Change List Page through Change Value, Add Value and Search Criteria will have the same implications in the Run Control Page.

Navigation:

Items > Change List Maintenance > Change List > Change Value

This example illustrates the fields and controls on the Change List Maintenance — Change Value Page. You can find definitions for the fields and controls later on this page.

 ChangeValue

Field or Control

Description

Table Name

Displays the Table name based upon selection

Select Fields (link)

Displays a modal secondary page. This page lists all the fields that can be changed on the Record. It also allows users to select or deselect multiple values. The selected values are added to the main page

Note: Whether a field is “modifiable” on Run control or not, it will be added against the field name. If the field is not “Modifiable”, then the Field and Value entered becomes read-only on the corresponding Run control page.

Use the Change List Maintenance - Add Value page (IN_ITM_ADD_TMPL) to add child records by selecting records based on Template group. While adding child records the user needs to associate a Value Template ID for the selected Template group. If the selected Template group consists of multiple records, the user needs to specify the record, which needs to be updated.

Navigation:

Items > Change List Maintenance > Change List > Add Value

This example illustrates the fields and controls on the Change List Maintenance — Add Value Page. You can find definitions for the fields and controls later on this page.

 Change List Maintenance Add Value Page

Field or Control

Description

View and Modify Values

Displays a modal secondary page with the Value template fields for viewing or modifying values. The read-only or editable control of the fields is controlled by the associated field template

Modifiable

The modifiable flag cannot be edited. Only the super user (the user who creates the change list) will be able to view and modify values. The run control user (that is from the run control page) will be able to view the values but not modify the same.

Use the list Permission Maintenance page (ITM_TML_LSTSEC_MNT) to award permission based on roles or user id. Note that the user cannot use role and user id at the same time.

Navigation:

Items > Configurable Item Templates > Manage Template Permissions

This example illustrates the fields and controls on the List permission Maintenance Page. You can find definitions for the fields and controls later on this page.

 List permission Maintenance Page

The Item Change process component is similar to the Change list component. The user can know if the update has happened from the report that is generated in the “Report Manager” link

This example illustrates the fields and controls on the Item Change Process. You can find definitions for the fields and controls later on this page.

 Item Change Process

Field or Control

Description

Report Option

The report options include Error Report, Full Report, and No Report.

If you run the process after selecting the Error Report from the dropdown, the IN_ITEM_CHG BI report generates an error report. Similarly, if you select the Full Report option, the BI IN_ITM_CONS report generates a full report.

Warning! Use extreme care when updating the master data tables, especially when modifying existing item data. The Item Loader process cannot be reversed.

Note: User needs to make sure that no transaction or material movement happens when the Item Change Process is Run

Field or Control

Description

SetID

Select the SetID used to build the configurable item template.

Fields Template

Enter the name of the fields group template.

Include in Group

Deselect this check box to remove all item attributes on this page from this field group template. For example, if you do not use item substitutes then you do not need the fields located in the Substitute Item Field tab on the Master Item field group. This check box is disabled and cannot be used for critical field groups such as the Master Item Fields page.

Include in Batch

Deselect this check box to remove all item attributes on this page from the batch run of the Item Loader process. Some segments are not applicable to the batch mode and this check box enables you to prevent these segments from being loaded.

Copy From Template

Select an existing field group template to be copied into your new field group template. This field is only available when adding a new template.

Copy Fields

Click this button to copy the fields and their check box settings from the template named in the Copy From Template field. This button is only available when adding a new template.

Required

Select this check box to require an entry by the user or system when adding the new item. These fields can be key fields as defined on the table definition or user-defined here (within the field group component). Rows with a required field, either user-defined or table-defined, automatically have the Displayed on Template check box selected.

Note: Special rules exist for these fields; SetID, Item ID, and Description (DESCR60). These three fields are required but do not appear on value group templates. The field values are obtained during data entry of the new item.

Modifiable

Select this check box to enable this item attribute to be changed by the user when the item is entered on the Item Add component.

Displayed on Template

Select this check box to make the item attribute visible on the value group templates where you can enter a default value. These fields may or may not be modifiable.

Use Current Date/Time

For item attributes that are date/time fields, select this check box to populate the field with the current date and time when creating the value group template. The value cannot be changed within the value group template, but it can be changed when adding a new item in the Item Add component.

Use the Master Item Fields page (MASTER_ITM_TML3) to choose fields for your configurable item template from the Master Item Fields (MASTER_ITEM_TBL) record.

These fields are the basic setup to add a new item. This page is required for any configurable item template.

Navigation:

Items > Configurable Item Templates > Field Groups > SetID Level > Item Attributes File by Group

This example illustrates the fields and controls on the Master Item Fields page within the Master Item Field Group. You can find definitions for the fields and controls later on this page.

 Master Item Fields page within the Master Item Field Group

The Master Item Fields page is the first page in the Master Item component.

The Field Group for Master Items

The Master Item component displays the fields within the Master Item field group. This field group gathers together the PeopleSoft records (tables) that are needed to add an item at the SetID level. The first page on this component is required for all configurable item templates.

Each page in this component contains fields keyed by SetID within the following PeopleSoft tables:

Page Name

Table Name

Master Item Fields

MASTER_ITEM_TBL

Classification 2

GS1_CLS2_INV_IT

Inventory Item Fields

INV_ITEMS

Item UOM Fields

INV_ITEM_UOM

UOM Type Fields

UOM_TYPE_INV

Substitute Item Fields

SUBSTITUTE_ITM

Note: The Include In Batch check box is not available for this page because substitutes can only be entered for online pages. The Item Loader process cannot use substitutes from the configurable item template.

Use the Purchasing Attribute Fields page (PO_ITM_ATR_TML3) to select fields for your configurable item template from the Purchasing Item Attributes (PURCH_ITEM_ATTR) and Purchasing Item Accounts (PUR_ITM_ATTR_CF) records.

These item attributes are used to complete the basic setup and ChartField combinations to set up a purchased item within PeopleSoft Purchasing. This component is only available if you have PeopleSoft Purchasing installed in your system.

Navigation:

Items > Configurable Item Templates > Field Groups > SetID Level > PO Item Attribute Details

This example illustrates the fields and controls on the Purchasing Attribute Fields page within the Purchasing Item Attributes Field Group. You can find definitions for the fields and controls later on this page.

 Purchasing Attribute Fields page

The Purchasing Attribute Fields page is the first page in the Purchasing Item Attributes component.

The Field Group for Purchasing Item Attributes

The Purchasing Item Attributes component displays the fields within the Purchasing Item Attributes field group. This field group gathers together the PeopleSoft records (tables) that are needed to add a purchased item at the SetID level. The Purchasing Item Attributes field group is only available if you have PeopleSoft Purchasing installed.

Each page in this component contains fields keyed by SetID within the following PeopleSoft tables:

Page Name

Table Name

Purchasing Attribute Fields

PURCH_ITEM_ATTR and PUR_ITM_ATTR_CF

Asset Attribute Fields

ASSET_ITEM_ATTR

Item Specification Fields

ITEM_SPEX_PUR

PO BU Item Attribute Fields

PURCH_ITEM_BU

Use the Product Definition Fields page (PROD_ITEM_TML3) to select fields for your configurable item template from the Product Items (PROD_ITEM) record.

These item attributes are needed to define an item as a product at the SetID level for PeopleSoft Order Management and PeopleSoft Enterprise Pricer. This component is only available if you have PeopleSoft Order Management installed.

Navigation:

Items > Configurable Item Templates > Field Groups > SetID Level > Product Item Attributes

This example illustrates the fields and controls on the Product Definition Fields page within the Product Item Attributes Field Group. You can find definitions for the fields and controls later on this page.

 Product Definition Fields page

The Product Definition Fields page is the first page in the Product Item Attributes component.

The Field Group for Product Item Attributes

The Product Item Attributes component displays the fields within the Product Item Attributes field group. This field group gathers together the PeopleSoft records (tables) that are needed to define an item as a product at the SetID level for PeopleSoft Order Management and PeopleSoft Enterprise Pricer. The Product Item Attributes field group is only available if you have PeopleSoft Order Management installed.

Each page in this component contains fields keyed by SetID within the following PeopleSoft tables:

Page Name

Table Name

Product Definition Fields

PROD_ITEM

Margin Amount Fields

PROD_ITEM_CURR

Product by UOM Fields

PROD_UOM

Attributes by UOM Fields

PROD_UOM_CURR

Use the Manufactured Item page (ITM_MFG_TML3) to select fields for your configurable item template from the ITEM_MFG record.

These attributes are used at the SetID level to define an item for use in the PeopleSoft Manufacturing application.

Navigation:

Items > Configurable Item Templates > Field Groups > SetID Level > Mfg Item Attributes

This example illustrates the fields and controls on the Manufactured Item page . You can find definitions for the fields and controls later on this page.

 Manufactured Item page

The Manufactured Item page is the first page in the Manufacturer's Item Attributes component.

The Field Group for Manufacturer's Item Attributes

The Manufacturer's Item Attributes component displays the fields within the Manufacturer's Item Attributes field group. This field group gathers together the PeopleSoft records (tables) that are needed to define a manufactured item at the SetID level for PeopleSoft Manufacturing.

Each page in this component contains fields keyed by SetID within the following PeopleSoft tables:

Page Name

Table Name

Manufactured Item

ITEM_MFG

UPN Attributes

ITEM_MFG_UPN_FS

UPN Attributes 2

GS1_UPN_ATT2

GPO Attributes

ITEM_MFG_GPO

Use the Item Supplier Fields page (ITM_VENDOR_TML3) to select fields for your configurable item template from the ITM_VENDOR record.

These item attributes are used to complete the prioritized item-supplier combinations for a purchased item within PeopleSoft Purchasing.

Navigation:

Items > Configurable Item Templates > Field Groups > SetID Level > Item Supplier Attributes

The Item Supplier Fields page is the first page in the Item Supplier Attributes component.

The Field Group for Item Supplier Attributes

The Item Supplier Attributes component displays the fields within the Item Supplier Attributes field group. This field group gathers together the PeopleSoft records (tables) that are needed to define, at the SetID level, supplier information for a purchased item. The Item Supplier Attributes field group is only available if you have PeopleSoft Purchasing installed.

Each page in this component contains fields keyed by SetID within the following PeopleSoft tables:

Page Name

Table Name

Item Supplier Fields

ITM_VENDOR

Item Supplier Location Fields

ITM_VENDOR_LOC

Item Supplier UOM Fields

ITM_VNDR_UOM

Item Supplier UOM Price Fields

ITM_VNDR_UOM_PR

Return to Vendor Fees Fields

ITM_VND_RTV_FEE

Supplier Item MFG Fields

ITM_VENDOR_MFG

Use the Inventory Fields page (BU_ITM_INV_TML3) to select fields for your configurable item template from the Business Unit Items (BU_ITEMS_INV) record.

These fields are defined at the business unit level and are common item attributes across PeopleSoft Inventory business units.

Navigation:

Items > Configurable Item Templates > Field Groups > Business Unit Level > Define BU and Item Attributes

This example illustrates the fields and controls on the Inventory Fields page within the Business Unit Item Field Group. You can find definitions for the fields and controls later on this page.

 Inventory Fields page within the Business Unit Item Field Group

The Inventory Fields page is the first page of the Business Unit Item component.

When inserting a row into the replenishment locations, the system only inserts these locations into business units where the material storage locations are defined. If the material storage location is not defined in one or more of the business units, then the locations are not created for that business unit.

The Field Group for Inventory Business Unit and Item ID Attributes

The Business Unit Item component displays fields within the Business Unit Item field group. This field group gathers together the PeopleSoft records (tables) that are needed to define attributes of an item ID within a PeopleSoft Inventory business unit. These fields are defined at the business unit level and are common item attributes across Inventory business units.

Each page in this component contains fields keyed by business unit within the following PeopleSoft tables:

Page Name

Table Name

Inventory Fields

BU_ITEMS_INV

Configuration Fields

BU_ITEMS_CONFIG

Utilization Code Fields

BU_ITEM_UTIL_CD

Weight/Volume Fields

BU_ITEMS_WTVOL

Planning Attribute Fields

BU_ITEMS_INV

PL_ITEM_ATTRIB

Prdn Replenishment Loc Fields

SF_REPL_INV and SF_WIP_REPL_REQ

Use the Picking Zone Fields page (PICK_ZONE_TML3) to select fields for your configurable item template from the Picking Zones (PICK_ZONE_INV) record.

These fields are defined at the business unit level and are used to group storage locations into picking zones to help direct the picking operations within the PeopleSoft Inventory business unit.

Navigation:

Items > Configurable Item Templates > Field Groups > Business Unit Level > Item Template Attribute Groups

This example illustrates the fields and controls on the Picking Zone Fields page within the Inventory Management Field Group. You can find definitions for the fields and controls later on this page.

 Picking Zone Fields page within the Inventory Management Field Group

The Picking Zone Fields page is the first page in the Inventory Management component.

When inserting a row into putaway zones, fixed picking locations, or default putaway locations, the system only inserts these locations into business units where the material storage locations are defined. If the material storage location is not defined in one or more of the business units, then the locations are not created for that business unit.

The Field Group for Inventory Management

The Inventory Management component displays the fields within the Inventory Management field group. This field group gathers together the PeopleSoft records (tables) that are needed to store stock within a PeopleSoft Inventory business unit and manage day-to-day warehouse operations.

Each page in this component contains fields keyed by business unit within the following PeopleSoft tables:

Page Name

Table Name

Picking Zone Fields

PICK_ZONE_INV

Putaway Zone Fields

PTWY_ZONE_INV

Fixed Picking Location Fields

FIXED_BIN_LOC_INV

Default Putaway Loc Fields

DEFAULT_LOC_INV

Putaway Rule Fields

PTWY_IT_RULE_IN

Use the Fulfillment Attribute Fields page (SETUP_ITM_TML3) to select fields for your configurable item template from the Item Fulfillment Attributes (DF_SETUP_IT_INV) record.

These fields are needed to store item demand fulfillment attributes at the business unit level.

Navigation:

Items > Configurable Item Templates > Field Groups > Business Unit Level > Define Fulfillment Attributes

This example illustrates the fields and controls on the Fulfillment Attribute Fields page within the Inventory Fulfillment Field Group. You can find definitions for the fields and controls later on this page.

 Fulfillment Attribute Fields page within the Inventory Fulfillment Field Group

The Fulfillment Attribute Fields page is the first page in the Inventory Fulfillment component.

The Field Group for Inventory Fulfillment

The Inventory Fulfillment component displays the fields within the Inventory Fulfillment field group. This field group gathers together the PeopleSoft records (tables) that are needed to store item demand fulfillment attributes at the business unit level.

Each page in this component contains fields keyed by business unit within the following PeopleSoft tables:

Page Name

Table Name

Fulfillment Attribute Fields

DF_SETUP_IT_INV

Automatic Serial Numbering Fields

AUTO_SERIAL_NUM