PeopleSoft Inventory Selected Reports

Ship From

The address from which the shipment originated.

Consign To

The shipment destination (ship to customer or location) entered on the order or in the Build Bill of Lading component.

Carrier

The carrier transporting the shipment.

Driver ID

The identification of the driver.

Vehicle ID

The identification of the vehicle.

Seal Number

The number of the seal.

Includes Order(s)

The orders included in the bill of lading. If the shipment is an intercompany transfer requiring export shipping documentation, the word export appears next to the orders.

Route Code

The transportation route to which the shipment is assigned.

Quantity/UOM (quantity/unit of measure)

Displays the quantity that is expected to ship. If the BOL is created for demand lines that are in an earlier fulfillment state than Shipped, then the system is calculating the expected shipping quantity. This field displays:

• For unfulfilled demand lines, the quantity requested less the quantity backordered.

• For releasable and released demand lines, the planned release quantity.

  This is the quantity reserved, promised, or allocated. For non-soft reserve, non ATP items, the override quantity is used if entered on the Shortage Workbench, a fulfillment engine EIP, or Fulfillment Workbench.

• For confirmed demand lines, the quantity picked.

• For shipped or depleted demand lines, the quantity shipped (QTY_SHIPPED).

Commodity Code/Harmonized Tariff Code

The commodity code or tariff code entered in the Build Bill of Lading component. Domestic bills of lading have commodity codes; export bills of lading have harmonized tariff codes.

Shipment Weight/UOM

The shipping weight entered in the Build Bill of Lading component.

Shipment Volume/UOM

The shipping volume entered in the Build Bill of Lading component.

Supplier (Name and Address)

The name and address of the PeopleSoft Inventory business unit that shipped the stock.

Date of Direct Shipment to Canada

The actual shipment date for the shipping ID.

Other References

The customer's PO (purchase order) number.

Consignee (Name and Address)

The name and address of the ship to customer entered on the order. For an interunit transfer, this is the name and address of the in-transit ownership unit or the customer ID that you defined for intercompany processing on the InterUnit Ownership page.

Purchaser's Name and Address

The name and address of the purchaser (same as the consignee address).

Country of Transhipment

This field is left blank.

Country of Origin of Goods

The point of origin defined on the Build Bill of Lading - Export Info page.

Transportation: Give Mode and Place of Direct Shipment to Canada

The mode of transportation (ship via code) and the point of origin code entered on the Build Bill of Lading - Export Info page.

Conditions of Sale and Terms of Payment

This field is left blank.

Currency of Settlement

The currency code that you entered in the Currency Settlement field on the Build Bill of Lading - Bill of Lading page.

Specification of Commodities

The harmonized tariff code and code description from the Build Bill of Lading - Export Details page.

Quantity

The quantity shipped, as entered on the Build Bill of Lading - Export Details page.

Unit Price

The price per unit of the item.

Net

The shipping weight from the Build Bill of Lading - Export Details page.

Gross

The packing weight calculated for the item.

Exporter's Name and Address and Origination (Name and Address)

The name and address of the PeopleSoft Inventory business unit that shipped the stock.

Status

The item's status, as defined on the Define Business Unit Item - General: Common page.

Date Timestamp and Sequence Number

The date and time that the consumption transaction occurred, and the identifier for transactions occurring within the same date timestamp.

Transaction (transaction group)

The transaction group to which the consumption transaction belongs.

Quantity

The transaction quantity in the item's standard UOM.

Processed

Indicates whether the Voucher Build process has processed the consumption transaction for the creation of a voucher in PeopleSoft Payables.

Total Qty Received (total quantity received)

The total quantity of the item received into the business unit. If the report lists multiple items, a total appears for each item.

Total Qty Consumed (total quantity consumed)

The total quantity of the item that was consumed. If the report lists multiple items, a total appears for each item.

Bus. Unit (business unit)

The business unit that you entered on the Consumer Charge Sheet Report page.

Consumer ID

The consumer ID assigned to the consumer for which this consumer charge sheet was printed.

Name

The name of the consumer for which this report was printed.

Location Code

The location at which the consumer's service event took place.

Service ID

The service ID assigned to the consumer's service event for which this report was printed.

Service Start

The date and time of the consumer's service event.

Item Usage QTY (item usage quantity)

The quantity of the item used, according to the associated consumer usage entry.

Item Usage Cost

The cost of the item usage recorded at the time of usage entry. This is the Item Usage Qty times the Unit Cost.

Item Ship QTY (item ship quantity)

The quantity of the item shipped to the location, expressed in the item's standard UOM.

Item Shipment Cost

The cost of the shipped items. This value is derived from the average cost defined on the Define Business Unit Item - General page.

Item Receipt QTY (item receipt quantity)

The quantity of the item that was received. You define this value on the Receiving page.

Item Receipt Cost

Cost of the items received. This value is derived from the PO price that you defined on the Receipt Distributions page.

Delta QTY (delta quantity)

The quantity of items that did not reconcile for the row. This value is the difference between the Item Usage Quantity and the Item Receipt Quantity.

Lost Charge

The total cost of items that could not be reconciled for the row. This value is the Item Usage Cost - (Item Receipt Cost + Item Shipment Cost)

Location Usage Cost

Total item usage costs for the location ID.

Location Shipment Cost

Total item shipment costs for the location ID.

Location Receipt Cost

Total item receipt costs for the location ID.

Grand Usage Cost

Total usage item costs for all location IDs included in the report.

Grand Shipment Cost

Total item shipment costs for all location IDs included in the report.

Grand Receipt Cost

Total item receipt costs for all location IDs included in the report.

SEQ. No (sequence number)

Numeric sequence in which the items were used in the service event as identified by the service event ID.

Cost-Used

Cost of the items used in the service event sequence.

Item Usage QTY (item usage quantity)

Quantity of the item used in the service event as a whole.

Item Usage Cost

Cost of the items used in the service event as a whole.

Location Usage Cost

Total item usage costs for the location ID.

Demand Source

The identification code associated with the shipped item's demand source, derived from the MSR created by the Create Par Replenishment Requests process.

Demand Source BU (demand source business unit)

The business unit associated with the shipped item's demand source.

Order No (order number)

The MSR order number issued for the shipped item.

Order Line

The MSR order line number associated with the shipped item.

Schedule Line

The MSR order schedule line number associated with the shipped item.

Demand Line

The demand line number associated with the shipped item.

Ship Date

The date on which the item was shipped.

QTY-Shipped (quantity shipped) and UOM

The quantity of a shipped item and the associated UOM.

Cost-Shipment

The cost of the shipped item.

Item Ship QTY (item ship quantity)

The total quantity of shipped items.

Item Shipment Cost

The total cost of the shipped items.

Location Usage Cost

The total item shipment costs for the location ID.

BU-PO (purchase order business unit)

The PO business unit associated with the received item.

Receiver ID

The receipt number associated with the received item.

Receiver Line

The receipt line number associated with the received item.

Ship SEQ (receiver ship sequence)

The sequence in which the received item was shipped.

Distribute Line

The distribution line associated with the received item.

Receipt Date

The date on which the item was received into the system.

QTY-Receipt (quantity receipt)

The quantity of items received according to the item's receipt.

Cost-Receipt

The cost of the items received according to the item's receipt.

Item Receipt QTY (item receipt quantity)

The total quantity of items received, according to the item's receipt.

Item Receipt Cost

The total cost of the items received, according to the item's receipt.

Location Usage Cost

The total item receipt cost for the location ID.

Grand Usage Cost

Total item usage cost for all location IDs included in the report.

Grand Shipment Cost

Total item shipment cost for all location IDs included in the report.

Grand Receipt Cost

Total item receipt cost for all location IDs included in the report.

Area, Lev1, Lev2, Lev3, and Lev4

The storage location.

Storage UOM

The UOM for items stocked in the storage location.

Quantity

For non-blind counts, this column indicates the system balance for the storage location. For blind counts, this column is blank.

[Quantity UOM]

The UOM for the quantity count, as specified on the Define Item - Units of Measure page.

Count Date/Time

The date and time that the count occurred.

Staged

The staged date for staged date-controlled items.

Serial ID

The serial ID belonging to a serial-controlled item.

Lot ID

Identification number assigned to the lot (for lot-controlled items).

Container

The container ID for an item residing in a container.

Tag ID

The sequential number automatically assigned to each counting event detail line when you run the Counting Sheet process.

Invoice Number

Number of the invoice.

Invoice Date

Date of the invoice.

Your References

The customer PO number.

Our References

The PeopleSoft order number.

Exporter

The name and address of the business unit from which the shipment was sent.

Consignee

The name and address of the ship to customer.

Buyer

The name and address of the ship to specified for the shipping ID (for interunit transfers) or the bill to customer (for sales orders).

Incoterms (international commercial terms)

Indicates whether the buyer (destination) or seller (origination) is responsible for carriage and insurance for the shipment.

Terms of Payment

Specifies when payment for the shipment is due.

Transport ID

The method of transportation (by air, by truck, and so forth).

Place of Loading/Place of Discharge/Place of Destination

These fields indicate where the shipment was loaded, where it was unloaded, and the location of its final destination.

Date of Disposal

The scheduled arrival date.

Date of dispatch required

The requested date.

Invoice Currency

The currency in which the prices on the invoice appear.

Order Line/On Pack No (on packing slip number)

The order line number and the shipping container in which it appears.

Shipping ID

The shipping ID appears below the order line number.

Schedule Line Of Pack List No (schedule line of packing list number)

The order's shipment schedule line number, from the packing slip.

Item ID/Description

The item and its corresponding description.

Quantity/Unit of Measure

The quantity shipped, which is expressed in the shipping UOM.

Unit Price

The price per unit of the item, calculated by PeopleSoft Cost Management and used for PeopleSoft Inventory.

Amount

The total price for the quantity of the shipped item.

Comments - Other Information

If you entered any comments on the order, they appear here.

Total of goods

The total price for all items in the shipment.

Freight Charges/ Miscellaneous Shipping Charges/ Total Charges

These charges reflect any freight or miscellaneous charges that were added to the shipment.

Total Amount

The total amount due for the shipment.

Reorder Qty (reorder quantity)

The optimal quantity that you selected on the Fixed Picking Locations page, minus the total on-hand quantity in that storage location.

Item/Std UOM (standard unit of measure)

Item IDs appear in ascending alphanumeric order.

BU Own Qty (business unit owned quantity) /Calc Own Qty/Difference (calculated owned quantity)

This column lists three values per item: the business unit's recorded owned quantity (BU_ITEMS_INV.qty_owned, the calculated owned quantity, and the difference between the two values. The system computes the calculated owned quantity with the formula:

Calc Own Qty = Calc OH Qty less PI Non-Own – Conf Non-Own less Staged Non-Own

The calculated values for the variables in this formula appear for each item in other columns of the Business Unit Level Balances report. For details about each variable, see the associated column heading documented in this section.

BU OH Qty (business unit on-hand quantity)/ Calc OH Qty (calculated on-hand quantity)/ Difference

This column lists three values per item: the business unit's recorded quantity on hand (BU_ITEMS_INV.qty_onhand), the calculated quantity on hand, and the difference between the two values. The system computes the calculated quantity on hand with the formula:

Calc OH Qty = PI Base + Conf Avail + Conf Unavail + Staged Avail + Staged Unavail

The calculated values for the variables in this formula appear for each item in other columns of the Business Unit Level Balances report. For details about each variable, see the associated column heading documented in this section.

BU Res Qty (business unit reserved quantity)/− Calc Res Qty (calculated reserved quantity)/ Difference

This column lists three values per item: the business unit's recorded quantity reserved (BU_ITEMS_INV.qty_reserved), the calculated quantity reserved, and the difference between the two values. The system computes the calculated quantity reserved with the formula:

Calc Res Qty = Cust Resv + Conf Avail + WIP Avail + Staged Avail + Prod Resv

The calculated values for the variables in this formula appear for each item in other columns of the Business Unit Level Balances report. For details about each variable, see the associated column heading documented in this section.

BU Avail Qty (business unit available quantity)/− Calc Avail (calculated available)/ Difference

This column lists three values per item: the business unit's recorded quantity available (BU_ITEMS_INV.qty_available), the calculated quantity available, and the difference between the two values. The system computes the calculated quantity available with the formula:

Calc Avail = Calc OH Qty less Calc Res Qty less Conf Unavail less PI Unavail less Staged Unavail

The calculated values for the variables in this formula appear for each item in other columns of the Business Unit Level Balances report. For details about each variable, see the associated column heading documented in this section.

BU Qty On Hand (business unit quantity on hand)/ BU Qty Reserved (business unit quantity reserved)/ BU Qty Available (business unit quantity available)

For each item, this column lists the values recorded in the primary quantity fields from the BU_ITEMS_INV record: qty_onhand, qty_reserved, and qty_available.

PI Base / Conf Avail (confirmed available)/ Conf Unavail (confirmed unavailable)/ Staged Avail (staged available)

For each item, this column lists the values for four variables used in the Calc OH Qty, Calc Res Qty, or Calc Avail equation.

PI base represents the total stock quantity in the item's standard UOM that is recorded for each storage location in the business unit. This value is the sum of the qty_base field values for all of the item's storage location records in the PHYSICAL_INV table.

Confirmed available represents the total stock quantity confirmed as picked but not depleted that has an Open inventory status and was picked from a nettable storage location. If you select the Incl Non-Open in Avail Qty option for the business unit, this quantity also includes the total stock quantity confirmed as picked but not depleted that has a Restricted status and was picked from a nettable storage location. Until the Deplete On Hand Qty (Depletion) process runs, this stock quantity is included in the business unit's quantity on hand and quantity reserved. An item's confirmed available value is derived from a joining of the DEMAND_PHYS_INV and the IN_DEMAND tables.

Confirmed unavailable represents the total stock quantity confirmed as picked but not depleted that (1) has a Non-Open inventory status, with the Incl Non-Open in Avail Qty option not selected for the business unit, or (2) was picked from a non-nettable storage location. Until the Deplete On Hand Qty (Depletion) process runs, this stock quantity is included in the business unit's quantity on hand. An item's confirmed unavailable value is derived from a joining of the DEMAND_PHYS_INV and the IN_DEMAND tables.

Staged available represents the total stock quantity in the item's standard UOM that was confirmed as picked, then canceled or short shipped but not put away. This quantity includes only those stock quantities that were picked from nettable locations with an inventory status of (1) Open or (2) the Restricted with the Incl Non-Open in Avail Qty option selected for the business unit. If a demand line is canceled or short shipped after the demand quantity is confirmed as picked, the canceled demand quantity or short-shipped quantity is staged for putaway processing in the STAGED_ITEM_INV table. Until the Complete Putaway process (INPPPTWY) runs, this stock quantity (recorded in STAGED_ITEM_INV.qty_base field) is included in the business unit's quantity reserved.

Staged Unavail (staged unavailable)/ Cust Resv (customer reserved)/ WIP Avail (work in progress available)/ Prod Resv (production reserved)

For each item, this column lists the values for four variables used in the Calc OH Qty, the Calc Res Qty, or the Calc Avail equation.

Staged Unavail represents the total stock quantity in the item's standard UOM that was confirmed as picked, then canceled or short shipped but not put away. This quantity includes only stock picked from non-nettable locations or stock with an inventory status of Restricted and with the Incl Non-Open in Avail Qty option not selected for the business unit. If a demand line is canceled or short shipped after the demand quantity was confirmed as picked, the canceled demand quantity or short-shipped quantity is staged for putaway processing in the STAGED_ITEM_INV table.

Cust Resv represents the total stock quantity in the item's standard UOM that has been lot allocated or soft reserved by the Reserve Materials process (IN_FUL_RSV) and is greater than 0 only for those items with soft reservations selected. This value is the sum of the item's qty_alloc_base field values for lot-allocated demand lines (lot_alloc_flg = 'Y') on the IN_DEMAND table. Until the Deplete On Hand Qty (Depletion) process runs, the customer reserved quantity is included in the business unit's quantity reserved.

WIP Avail represents the total stock quantity in the item's standard UOM (qty_base) that is stored in work-in-progress storage locations. If the Incl Non-Open in Avail Qty option is selected for the business unit, the work-in-progress available value includes stock with Open (avail_status = 1), Restricted (avail_status = 2), and Hold (avail_status = 3) inventory status in nettable locations. If the Incl Non-Open in Avail Qty option is not selected, the WIP Avail value includes only stock quantity with an Open status in nettable work-in-progress locations. Stock quantity that is transferred to work-in-progress storage locations is considered a part of the business unit's quantity reserved, because it can be used only for production purposes. An item's work-in-progress available value is derived from a joining of the PHYSICAL_INV and STOR_LOC_INV tables, where nettable_flg = Y and wip_loc_flg = Y.

Prod Resv represents the total stock quantity in non-WIP storage locations (wip_loc_flg = N) that has been reserved for production by the Material Picking Plans process (SFS6000) in PeopleSoft Manufacturing. If Incl Non-Open in Avail Qty is selected for the business unit, the Prod Resv value includes stock with Open (avail_status = 1), Restricted (avail_status = 2), and Hold (avail_status = 3) inventory status in nettable locations. If the Incl Non-Open in Avail Qty option is not selected, production reserved includes only stock quantity with an Open inventory status (avail_status = 1) in nettable (nettable_flg = Y) locations. The production reserved value is in the item's standard UOM (qty_picked) and is derived from a joining of the SF_ISS_TRANSFERS, PHYSICAL_INV, and STOR_LOC_INV tables, where stor_Loc_inv.wip_loc_flg = N and stor_loc_inv.nettable_flg = Y and physical_inv.avail_status <> 4.

PI Unavail (PHYSICAL_INV unavailable) /PI Non-Own/Conf Non-Own (confirmed non-owned) /Staged Non-Own (staged non-owned)

For each item, this column lists the values used in the Calc Available and Calc Own Qty equations.

PI Unavail represents the total stock quantity stored in non-nettable storage locations (nettable_flg = N), plus the total stock quantity stored in nettable locations and having an inventory status that is not included in the business unit's available quantity. If the Incl Non-Open in Avail Qty option is selected for the business unit, PHYSICAL_INV unavail includes stock quantity in nettable locations with a Rejected inventory status (avail_status = 4). If the Incl Non-Open in Avail Qty option is not selected, the PHYSICAL_INV unavailable value includes stock quantity in nettable locations with an inventory status of Restricted (avail_status = 2), Hold (avail_status = 3), or Rejected (avail_status = 4). The PHYSICAL_INV unavailable value is in the item's standard UOM (qty_base) and is derived from a joining of the PHYSICAL_INV and STOR_LOC_INV tables.

PI Non Own represents the total non-owned stock quantity in the item's standard UOM that is recorded for each storage location in the business unit. This value is the sum of the qty_base field values for all non-owned stock recorded in the item's storage location records in the PHYSICAL_INV table.

Conf Non-Own represents the total non-owned stock quantity that is confirmed as picked but not depleted, has an Open inventory status, and was picked from a nettable storage location. If the Incl Non-Open in Avail Qty option is selected for the business unit, this quantity also includes the total stock quantity confirmed as picked but not depleted that has a Restricted status and was picked from a nettable storage location. Until the Deplete On Hand Qty (Depletion) process runs, this stock quantity is included in the business unit's quantity on hand and quantity reserved. The configured non-owned value is derived from a joining of the DEMAND_PHYS_INV and the IN_DEMAND tables.

Staged Non-Own represents the total non-owned stock quantity in the item's standard UOM that was confirmed as picked, then canceled or short shipped but not put away. This quantity includes only those stock quantities that were picked from nettable locations and had inventory status of (1) Open or (2) Restricted with the Incl Non-Open in Avail Qty option selected for the business unit. If a demand line is canceled or short shipped after the demand quantity is confirmed as picked, the canceled demand quantity or short-shipped quantity is staged for putaway processing in the STAGED_ITEM_INV table. Until the Complete Putaway process runs, this stock quantity (recorded in STAGED_ITEM_INV.qty_base field) is included in the business unit's quantity reserved.

Demand Src (demand source) / Source BU (source business unit)

This column lists two of the eight key fields for the demand line: the demand source and the business unit ID of the demand source. Demand source is a two-letter identifier indicating how the demand was generated. Values are:

IN: Demand entered using the Create/Update Stock Request component and the Create Par Replenishment Requests process (INPGCDMD) in PeopleSoft Inventory.

OM: Demand entered using the sales order entry pages in PeopleSoft Order Management.

PL: Demand from a planning requisition message originating in PeopleSoft Supply Planning and entered by the Apply Planning Messages process.

PO: Demand created from the PeopleSoft Purchasing sourcing process, which checks a defined Distribution Network to secure needed stock across PeopleSoft Inventory business units. The PO demand source code is also used to identify miscellaneous demand from such PeopleSoft Inventory sources as external uploads or par location replenishment requests.

PR: Demand created directly from a purchase requisition originating in PeopleSoft Purchasing.

RT: Demand based on a return-to-supplier request originating in PeopleSoft Purchasing.

SF: Demand created by a production request originating in PeopleSoft Manufacturing.

Order Number/Item

This column lists two of the eight key fields for the demand line: the order number and the item ID.

Order Line/Sched Line (schedule line)

This column lists two of the eight key fields for the demand line: the order line number and the schedule line number.

Dem Ln (demand line)

This column lists one of the eight key fields for the demand line: the demand line number. Any number greater than 1 indicates a backorder.

Qty Requested (quantity requested)/ Qty Backordered (quantity backordered)

This column lists two quantity values for demand lines in the IN_DEMAND table: the quantity requested (qty_requested) in the ordering UOM and the portion of the requested quantity that was backordered (qty_backorder) in the ordering UOM. If a negative quantity exists in either of these fields, an error message prints in the last column of the report.

Qty Allocated (quantity allocated)/ Qty Allocated Std (quantity allocated in the standard unit of measure)

This column lists two quantity values for demand lines in the IN_DEMAND table: the quantity allocated (qty_allocated) in the ordering UOM and the quantity allocated in the item's standard UOM (qty_alloc_base). If a negative quantity exists in either of these quantity fields, an error message prints in the last column of the report.

Qty Picked (quantity picked) / Qty Picked Std (quantity picked standard UOM)

This column lists two quantity values for demand lines: the quantity picked (qty_picked) in the ordering UOM and the quantity picked in the item's standard UOM (qty_pick_base). The quantity picked (qty_picked) and the quantity picked in the standard UOM (qty_pick_base) are listed on the IN_DEMAND table. If a negative quantity exists in either of these fields, an error message prints in the last column of the report.

Qty Shipped (quantity shipped)/ Qty Shipped Std (quantity shipped standard)/Qty Shipped Conv (quantity shipped converted)

This column lists three quantity values for demand lines in the IN_DEMAND table: the quantity shipped in the item's ordering UOM (qty_shipped), the quantity shipped in the item's standard UOM (qty_ship_base), and the quantity shipped in the item's converted UOM (Qty_Shipped_Conv). If a negative quantity exists in any of these fields, an error message prints in the last column of the report.

Last Qty Shipped (last quantity shipped)/Last Qty Ship Base(last quantity ship base)/ Std Ord Shp (UOM)

This column lists two values for the demand lines in the IN_DEMAND table: the quantity requested that has been shipped less any undershipment quantity that was putaway (LAST_QTY_SHIP) and the quantity requested that has been shipped less any undershipment quantity that was putaway, expressed in the item's standard UOM (LAST_QTY_SHIP_BASE). Std Ord Ship (UOM) displays the standard, ordering, and shipping UOM for these quantities.

Messages

This column lists an error message indicating that a negative quantity value exists for the demand line, if applicable.

Item/Std UOM (standard unit of measure)

Item IDs are listed in ascending alphanumeric order.

Lot/Container ID

This column lists two values: the lot IDs for each item and the container ID, if applicable. If the item is not lot controlled, the report lists the default value established on the Installation Options - Inventory page.

Serial ID/Staged Date

This column lists two values: serial ID and staged date. If the item is serial controlled, the report lists the serial ID for each unit. If the item is not serial controlled, the report lists the default value established on the Installation Options - Inventory page. If the item is staged date controlled, the report lists the staged date for the item. If the item is not staged date controlled, the report lists the default value established on the Installation Options - Inventory page.

Area, Lev1, Lev2, Lev3, and Lev4

These five columns define the item's storage location.

Phys Inv Qty Std

This column displays negative values found in the PHYSICAL_INV.qty_base field. The report process checks the setting that allows negative quantities, which was established for the business unit on the Inventory Definition - Business Unit Options page. If you do not select the Show All Detail option on the Inventory Balance Report page, only negative quantities found for business units that do not allow transactions to drive storage location quantities negative are printed. In this case, any negative balance printed in this column indicates a quantity discrepancy.

When you select the Show All Details option, all balances are printed, regardless of whether negative balances exist in the storage location.

Phys Inv Res Std

This column displays values found in the PHYSICAL_INV.qty_reserved_base field. Any negative balance printed in this column indicates a quantity discrepancy.

Phys Inv Qty

This column displays negative values found in the PHYSICAL_INV.qty field. The report process checks the setting that allows negative quantities, which was established for the business unit on the Inventory Definition - Business Unit Options page. If you do not select the Show All Detail option on the Inventory Balance Report page, only negative quantities found for business units that do not allow transactions to drive storage location quantities negative are printed. In this case, any negative balance printed in this column indicates a quantity discrepancy.

When you select the Show All Details option, all balances are printed, regardless of whether negative balances exist in the storage location.

Phys Inv Qty Res

This column displays values found in the PHYSICAL_INV.qty_reserved field. Any negative balance printed in this column indicates a quantity discrepancy.

Item

This column lists the lot-controlled item IDs in ascending alphanumeric order.

Lot

This column lists the lot IDs for each item in ascending alphanumeric order.

Lot Status

This column lists the lot status (LOT_CONTROL_INV.avail_status ) of the lot-controlled item:

1 = Open

2 = Restricted

3 = Hold

4 = Rejected

Qty On Hand (quantity on hand)/ − Calc OH Qty (calculated on-hand quantity)/ Difference

This column lists three values per item: the business unit's recorded lot quantity on hand (LOT_CONTROL_INV.qty_onhand), the calculated quantity on hand, and the difference between the two values. The calculated quantity on hand is the sum of the qty_base field values for lot-controlled items in the PHYSICAL_INV table.

Qty Allocated (quantity allocated)/ − Calc Allocations (calculated allocations)/ Difference

This column lists three values per item: the business unit's recorded lot quantity allocated (LOT_CONTROL_INV.qty_allocated), the calculated quantity allocated, and the difference between the two values. The calculated quantity allocated is the sum of the qty_reserved_base field values for lot-controlled items in the PHYSICAL_INV table, where the lot-controlled item has an Open status (PHYSICAL_INV.avail_status = 1) and the storage location is nettable (STOR_LOC_INV.nettable_flg = Y) and non-WIP (STOR_LOC_INV.wip_loc_flg = N).

Qty Available (quantity available)/ − Calc Avail (calculated quantity available)/ Difference

This column lists three values per item: the business unit's recorded lot quantity available (LOT_CONTROL_INV.qty_available), the calculated lot quantity available, and the difference between the two values. The calculated lot quantity available is the sum of the PHYSICAL_INV.qty_base field values minus the sum of the PHYSICAL_INV.qty_reserve_base field values, where the lot-controlled item has an Open status (PHYSICAL_INV.avail_status = 1) and the storage location is nettable (STOR_LOC_INV.nettable_flg = 1) and non-WIP (STOR_LOC_INV.wip_loc_flg = N).

Qty On Hand (quantity on hand)/ Qty Allocated (quantity allocated)/ Qty Available (quantity available)

This column lists three values per item: the business unit's recorded lot quantity on hand (LOT_CONTROL_INV.qty_onhand), the business unit's recorded lot quantity allocated (LOT_CONTROL_INV.qty_allocated), and the business unit's recorded lot quantity available (LOT_CONTROL_INV.qty_available).

Item

This column lists the item IDs in ascending alphanumeric order.

Lot

This column lists the lot IDs for each lot-controlled item in ascending alphanumeric order.

Staged Date

If the item is staged date-controlled, this column lists the date that the item was staged for putaway processing (the date that the Load Staged Items process inserted the item record into the STAGED_ITEM_INV table.) If the item is not staged date-controlled, this column lists the default value established on the Installation Options - Inventory page.

Serial ID

If the item is serial controlled, this column lists the serial ID for each unit. If the item is not serial controlled, this column lists the default value established on the Installation Options - Inventory page.

Area, Lev 1, Lev 2, Lev 3, and Lev 4

The storage location for each lot-controlled item.

Phy Inv Qty Base

The amount of lot-controlled stock in the storage location, in the item's standard UOM. This is the value recorded in the qty_base field in the PHYSICAL_INV table. For serial-controlled units, this value should always be 1.

Demand Src (demand source)/ Source BU (source business unit)

This column lists two of the eight key fields for the demand line: the demand source and the business unit ID of the demand source. Demand source is a two-letter identifier indicating how the demand was generated. Values are:

IN: Demand entered using the Create/Update Stock Request component and the Create Par Replenishment Requests process in PeopleSoft Inventory.

OM: Demand entered using the sales order entry pages in PeopleSoft Order Management.

PL: Demand from a planning requisition message originating in PeopleSoft Supply Planning and entered by the Apply Planning Messages process.

PO: Demand created from the PeopleSoft Purchasing sourcing process, which checks a defined Distribution Network to secure needed stock across PeopleSoft Inventory business units. The PO demand source code is also used to identify miscellaneous demand from various PeopleSoft Inventory sources, such as external uploads or par location replenishment requests.

PR: Demand created directly from a purchase requisition originating in PeopleSoft Purchasing.

RT: Demand based on a return-to-vendor request originating in PeopleSoft Purchasing.

SF: Demand created by a production request originating in PeopleSoft Manufacturing.

Order Number/Item

This column lists two of the eight key fields for the demand line: the order number and the item ID.

Order Line/Sched Line (schedule line)

This column lists two of the eight key fields for the demand line: the order line number and the schedule line number.

Dem Ln (demand line)

This column lists the demand line number. Any number greater than 1 indicates a backorder.

Qty Picked (IN_DEMAND.qyt_pick_base)/ Qty Picked Std (DEMAND_PHYS_INV.qty_base)

This column lists the picked quantity in the item's standard UOM from the IN_DEMAND table and the DEMAND_PHYS_INV table.

Last Qty Ship Base (IN_DEMAND.last_qty_ship_base)/ Calculated Last Quantity Ship (DEMAND_PHYS_INV. last_qty_ship_base)/ Difference

This column lists the last quantity shipped in the item's standard UOM from the IN_DEMAND table, the DEMAND_PHYS_INV table, and the difference between them. This value is calculated as the quantity requested that has been shipped minus any undershipment quantity that was putaway.

Std UOM

Displays the item's standard UOM.

Messages

If a difference exists between the compared quantity values, a message prints in this column to indicate a roll-up error.

Area, Lev 1, Lev 2, Lev 3, and Lev 4

Identifies the material storage location of the reserved quantities in PHYSICAL_INV.

Location Reserved Quantity

The total of reserved quantity from the material storage locations of the business unit. This is from the QTY_RESERVED field on the PHYSICAL_INV table.

Calc Reserved Quantity

The total quantity reserved to specific storage locations to fulfill demand lines in the DEMAND_PHYS_INV and SF_ISS_TRANSFER tables.

Difference

Displays any difference between the reserved quantity from the PHYSICAL_INV table and the DEMAND_PHYS_INV and SF_ISS_TRANSFER tables.

Monthly Avg

The average monthly use of the item for the year reported.

YTD Qty Issued (year-to-date quantity issued)

The quantity of the item issued so far for the year.

YTD Item Cost

The total cost of the item so far for the year.

Curr

The currency associated with the year-to-date item cost.

Location Code/Par Location

The location that you selected for the label on the originating run control page.

Unit of Measure

The ordering UOM if the printing selection is Pick Batch ID or Order Number. If the printing selection is Par Location or Item ID, then this is the standard UOM defined for the item on the Define Item - General: Common page.

Quantity

Because the item usage labels are printed in the dispensing UOM the quantity is always 1.

Comp Lot ID (component lot ID)

The lot ID for the components of a parent item.

Lot Availability Date

The date the lot became available for fulfillment in PeopleSoft Inventory or for consumption in PeopleSoft Manufacturing.

Lot Expiration Date

The Lot ID expiration date.

Comp Qty (component quantity) and Comp UOM (component unit of measure)

The number of components used in each parent item, and the corresponding UOM.

Component ID

The item ID of a component used to build a parent item.

From Production ID

The production ID from which this component was routed.

InterUnit ID

The number assigned by the system for a receipt resulting from an interunit transfer event.

Production ID

The production ID for components manufactured or assembled using PeopleSoft Manufacturing.

Purchase Order

The purchase order that was received in PeopleSoft Purchasing.

Receiver ID, Receiver Line, and Recv No (receiver number)

The receiver information for items received.

RMA ID

The RMA number associated with an internal issue or a receipt from a customer.

RMA Line No (returned material authorization line number)

The RMA line number associated with an item received from a customer.

Source Bus Unit (source business unit)

The source business unit for a receipt resulting from an interunit transfer.

Lot ID

The identification number assigned to the lot upon its creation in PeopleSoft Manufacturing or receipt into PeopleSoft Purchasing or Inventory.

Status

The lot status, defined on the Lot Control Information page.

Creation Date

The date the lot was originally created.

Availability Date

The date the lot becomes available for fulfillment or consumption, maintained on the Lot Control Information page.

Retest Date

The date the lot should be retested. This information is maintained on the Lot Control Information page.

Expiration Date

The date the lot expires. This information is maintained on the Lot Control Information page.

Parent/Output Item

The item ID of the parent or multiple-output item in which the item-lot combination was used.

Parent Lot ID

The lot ID for the parent item in which the item-lot combination was used.

Lot Availability Date

The date the lot became available for fulfillment in PeopleSoft Inventory or for consumption in PeopleSoft Manufacturing.

Lot Expiration Date

The Lot ID expiration date.

Parent Qty (parent quantity) and Parent UOM

The number of parent item assemblies that were completed and the associated UOM.

Production ID

The production ID for parent items manufactured or assembled using PeopleSoft Manufacturing.

RTV ID (return-to-vendor ID)

The return-to-vendor ID for a return-to-vendor transaction.

RTV Line (return-to-vendor line)

The return-to-vendor line number for a return-to-vendor transaction.

Serial ID

The serial ID of the item, if applicable.

To Production ID

The production ID to which this component was directly routed.

Supplier and Supplier ID

The supplier name and ID for an return-to-vendor transaction.

Exporter Name and Address

The name, address, and tax identification number of the PeopleSoft Inventory business unit that shipped the stock.

Blanket Period (DD/MM/YY)

This field is left blank.

Producer Name and Address

The exporter's name and address (same information as above).

Importer Name and Address

The name, address, and tax identification number of the ship to customer entered on the order. For an interunit transfer, this is the name and address of the in-transit ownership unit or the customer ID that you defined for intercompany processing on the InterUnit Ownership page.

Description of Good(s)

The description of the harmonized tariff code entered for the items on the Build Bill of Lading - Export Details page.

HS Tariff Classification

The harmonized tariff code that you entered for the items shipped on the Build Bill of Lading - Export Details page.

Preference Criterion

The preference criterion entered for this shipment on the Build Bill of Lading - Bill of Lading page.

Producer

The producer option that you selected for this shipment on the Build Bill of Lading - Bill of Lading page.

Net Cost

The net cost of the shipment.

Country

The country of origin.

Quantity

Displays the quantity that is expected to ship. If the certificate is created for demand lines that are in an earlier fulfillment state than Shipped, then the system is calculating the expected shipping quantity. This field displays:

• For unfulfilled demand lines, the quantity requested less the quantity backordered.

• For releasable and released demand lines, the planned release quantity.

  This is the quantity reserved, promised, or allocated. For non-soft reserve, non ATP items, the override quantity is used if entered on the Shortage Workbench, a fulfillment engine EIP, or Fulfillment Workbench.

• For confirmed demand lines, the quantity picked.

• For shipped or depleted demand lines, the quantity shipped (QTY_SHIPPED).

Type

The level at which the negative balance occurred. Values are: Unit, Location, or Lot.

Qty Available (quantity available)

The negative quantity balance for the business unit, storage location (on-hand quantity minus allocated quantity), or item-lot combination.

Qty Onhand (quantity on hand)

The quantity on hand for the business unit or item-lot combination. This column appears only if the item is negative at the unit or lot level.

Qty Owned (quantity owned)

The quantity owned by the business unit. This column appears only if the item is negative at the unit level.

Qty Reserved (quantity reserved)

The quantity reserved for the business unit. This column appears only if the item is negative at the unit level.

UOM

The standard UOM for the item, as defined on the Define Item - General: Common page.

Lot ID

For lot-controlled items, the identification number assigned to the lot.

Area, Lev1, Lev2, Lev3, and Lev4

The storage area and levels.

Container ID

The specific container for which the negative balance occurred.

Serial ID

The serial ID belonging to a serial-controlled item with a negative balance.

Staged Dt (staged date)

For staged date-controlled items, the staged date that you assigned to the item with a negative balance.

Bill To

The address of the bill to customer.

Ship To

The address of the ship to customer.

Order Number

The material stock request or sales order number for the items on this packing slip.

Ship Via

The shipment method for the order.

FOB

The freight terms code.

Export

If the shipment is an intercompany transfer that requires export shipping documentation, the word export appears to the right of the freight terms code.

Line-Sched (line and schedule numbers)

The line number and corresponding shipment schedule line number for the order.

Product Number/Description

The item ID and corresponding description defined for the item on the Define Item - General: Common page.

Actual Ship Date

The date the order was actually shipped. If the packing slip is created for demand lines that are in an earlier fulfillment state than Shipped, then the system prints the schedule ship date or today's date if the schedule ship date is earlier than today.

Qty Ordered (quantity ordered)

The quantity of the item that was ordered, expressed in the ordering UOM.

Qty Shipped Base (quantity shipped base)

Displays the quantity that is expected to ship, expressed in the standard UOM. If the packing slip is created for demand lines that are in an earlier fulfillment state than Shipped, then the system is calculating the expected shipping quantity. This field displays:

• For unfulfilled demand lines, the quantity requested less the quantity backordered.

• For releasable and released demand lines, the planned release quantity.

  This is the quantity reserved, promised, or allocated. For non-soft reserve, non ATP items, the override quantity is used if entered on the Shortage Workbench, a fulfillment engine EIP, or Fulfillment Workbench.

• For confirmed demand lines, the quantity picked.

• For shipped or depleted demand lines, the quantity shipped (QTY_SHIPPED).

Qty Backorder (quantity backordered)

The quantity of the item on backorder, expressed in the ordering UOM.

Product Kit/Description

If the item is part of a product kit, this field identifies the kit and its corresponding description.

Kit Line Nbr (kit line number)

If the item is part of a product kit, this field identifies the kit line number assigned to the item.

Storage Rule Description, Storage Temperature and Humidity

Storage rules information of the item.

Manufacturer and Manufacturer Item ID

The item manufacturer information.

Lot ID, Lot Expiration Date and Qty Shipped Base

The lot information for the item.

Notes or Comments

Comments or notes could be printed on the packing slip. This information can come from:

• Inventory Comments: These comments are added directly to the material stock request in PeopleSoft Inventory.

  These comments are limited to 254 characters.

• Requisition Comments: These comments are from the PeopleSoft Purchasing system. If the demand line on this packing slip originated from a requisition then any comments on the requisition are printed here. Requisition header and ship-to comments are printed at the top of the packing slip. Requisition line comments are printed below each line.

  The packing slip displays only the first five lines of requisition comments with a maximum of 100 characters per line. The number of actual characters printed may be less than 500 due to carriage returns.

  A requisition comment only displays on the packing slip if you have selected the Send to supplier check box on the various comment pages within PeopleSoft Purchasing.

• Sales Order Notes: These notes are from the PeopleSoft Order Management system. If the demand line on this packing slip was built from a sales order, then header, line, schedule, customer, or product notes can be printed here. Sales order header and customer notes are printed at the top of the packing slip. Sales order line, schedule and product notes are printed below each line. If a sales order has a product kit, select the Print Parent Product Notes check box on the Packing Slip run control page to display the parent product ID notes.

  Sales order notes are limited to 254 characters.

  The notes only print if you have selected the packing list as one of the documents to print the note using the various note pages within PeopleSoft Order Management.

DS (demand source)

The PeopleSoft application from which the order originated.

SrcBU (source business unit)

The business unit from which the order originated.

Order No. (order number)

The number assigned to the order upon its creation.

Line

The order line associated with the order.

Sched (schedule)

The schedule line number associated with the order.

Location

The internal location receiving the order.

Ship To

The customer to which the order line is being shipped.

Item ID

The identification number assigned to the item.

Carrier ID

The carrier transporting the order line.

Ship Via

The shipment method.

Qty Reserved

The item quantity reserved during the Reserve Materials process.

Qty Requested (quantity requested)

The item quantity requested during order entry.

Priority

The priority ranking assigned to the order.

Load ID

The load to which the order line is assigned.

Route and Stop No. (stop number)

The route and route stop to which the order line is assigned.

Export

Indicates whether the shipment is an intercompany transfer requiring export shipping documentation. The field is Y for export shipments and N for shipments not being exported.

ASRS ID

The automated storage and retrieval system ID assigned on the Material Storage Locations page.

Area, Lev1, Lev2, Lev3, and Lev4

The material storage location.

Total Weight

If you selected a weight UOM on the Setup Fulfillment page and if weights have been defined for the item, the total weight of the selected orders appears.

Total Volume

If you selected a volume UOM on the Setup Fulfillment page and volumes have been defined for the item, the total volume of the selected orders appears.

Lot ID

The identification number assigned to a lot-controlled item.

Availability Date

Appears if the scheduled ship date for a lot-controlled item is before the date on which the lot becomes available for fulfillment. Availability date is maintained on the Lot Control Information page.

Expiration Date

Appears if the scheduled ship date for a lot-controlled item is after the date on which the lot expires. Expiration date is maintained on the Lot Control Information page.

Serial ID

The identification number assigned to a serial-controlled item.

Configuration Code

The identification number assigned to a configured item.

Notes or Comments

Comments or notes could be printed on the picking plan. This information can come from:

• Inventory Comments: These comments are added directly to the material stock request in PeopleSoft Inventory.

  These comments are limited to 254 characters.

• Requisition Comments: These comments are from the Peoplesoft Purchasing system. If the demand line on this picking plan originated from a requisition then any comments on the requisition are printed here. Requisition header and ship-to comments are printed at the top of the picking plan. Requisition line comments are printed below each line.

  The picking plan displays only the first five lines of requisition comments with a maximum of 100 characters per line. The number of actual characters printed may be less than 500 due to carriage returns.

  A requisition comment only displays on the picking plan if you have selected the Send to supplier check box on the various comment pages within PeopleSoft Purchasing.

• Sales Order Notes: These notes are from the PeopleSoft Order Management system. If the demand line on this picking plan was built from a sales order, then header, line, schedule, customer, or product notes can be printed here. Sales order header and customer notes are printed at the top of the picking plan. Sales order line, schedule and product notes are printed below each line.

  Sales order notes are limited to 254 characters.

  The notes only print if you have selected the picking plan as one of the documents to print the note using the various note pages within PeopleSoft Order Management.

Pick Zone

If picking zones have been defined for the business unit, and if you elected on the Additional Options page to sort the location summary by zones, the zone to which the item is assigned appears. (This zone also appears on the basic Picking Plan report, assuming that zones have been defined and were used in the selection of a storage location from which to pick.)

Qty Avail (quantity available)

The total available quantity of the item in the business unit.

Total Qty Requested (total quantity requested)

The sum of the net requested quantity on the approved, non-soft-reserved order lines that meet the parameters established on the Picking Shortage Report page.

Line

The order line number.

Sched (schedule)

The schedule line number.

Dmnd (demand)

The demand line number. A demand line number greater than 1 indicates a backorder line.

Ship To

The ship to customer ID and description.

Sched Ship (scheduled ship date)

The date the order line is scheduled to ship.

Qty Requested (quantity requested)/ Qty to Pick (Order UOM) (quantity to pick, in order unit of measure)

The quantity originally requested on the order line appears in the item's order UOM. If the quantity to pick has been adjusted on the Shortage Workbench or if the Reserve Materials process has partially promised an ATP-reserved order line that does not allow backorders, this value also appears in the ordering UOM.

Allow Partial Qty (allow partial quantity)

The setting of the order's partial quantity option appears: Y (yes) or N (no). If an order line does not allow partial quantities, you cannot adjust the quantity to pick.

Counting Event ID

The number identifying the counting event for which you ran the Reconciliation report.

Print if Percent Error >= [x] and Dollar Error >= [y]

The reconciliation tolerance for the counting event, as specified on the Counting Event Header page.

Item

The identifying number and description of the item.

Staged

For staged date-controlled items, the staged date assigned to the item.

Area, Lev1, Lev2, Lev3, and Lev4

The storage location.

Serial ID

The serial ID belonging to a serial-controlled item.

Lot ID

For lot-controlled items, the identification number assigned to the lot.

Container

The container ID, if the item is stored in a container.

System Qty (system quantity)

The quantity currently maintained by PeopleSoft Inventory in PHYSICAL_INV.qty_base.

Count Qty/Count Date & Time (count quantity/count date and time)

The count quantity, converted to the standard UOM, and the date and time the count data was collected.

Percent Error

The percentage error between the count quantity and the system quantity.

Current $ Error (current US dollar error)

The cost difference between the count quantity and the system quantity.

Hist % Error (historical percentage error)

The average percentage error for the counting event item record when it was included in previous counting events.

Replenish ID

The replenishment identifier generated by the PeopleSoft Inventory processes.

Replenish Type

The PeopleSoft Inventory process that created the replenishment request, either reorder point or ad hoc.

Demand Src (demand source)

For ad hoc replenishment, the demand source of the stock request that generated the replenishment request.

Src BU (source business unit)

For ad hoc replenishment, the source business unit of the stock request that generated the replenishment request.

Order No (order number)

For ad hoc replenishment, the order number of the stock request that generated the replenishment request.

1a. Exporter

The name and address of the PeopleSoft Inventory business unit that shipped the stock.

Date of Exportation

The actual shipment date.

Bill of Lading/Air WayBill No. (air waybill number)

The bill of lading identification number.

b. Exporter's EIN (IRS) No.

The tax identification number of the PeopleSoft Inventory business unit that shipped the stock.

c. Parties To Transaction

Enter Y or N in the Parties to Transaction field on the Build Bill of Lading - Export Info page to mark the Yes or No box.

4a. Ultimate Consignee

The ultimate consignee that you defined on the Build Bill of Lading - Export Info page.

b. Intermediate Consignee

The intermediate consignee that you defined on the Build Bill of Lading - Export Info page.

5. Forwarding Agent

The forwarding agent that you defined on the Build Bill of Lading - Export Info page.

6. Point (State) of Origin or FTZ No.

The point of origin state that you defined on the Build Bill of Lading - Export Info page.

7. Country of Ultimate Destination

The destination country that you entered on the Build Bill of Lading - Export Info page.

8. Loading Pier

The loading pier that you defined on the Build Bill of Lading - Export Info page.

9. Mode of Transport

The ship via code that you entered as the mode of transportation on the Build Bill of Lading - Export Info page.

10. Exporting Carrier

The carrier that you entered as the exporting carrier on the Build Bill of Lading - Export Info page.

11. Port of Export

The port of export that you defined on the Build Bill of Lading - Export Info page.

12. Port of Unloading

The port of unloading that you defined on the Build Bill of Lading - Export Info page.

13. Containerized

If you selected the Containerized option on the Build Bill of Lading - Export Info page, the Yes check box is selected; otherwise, the No check box is selected.

D/F (16) (domestic/foreign)

This field indicates whether the goods are domestic or foreign.

Schedule B Number (17)

For each item shipped, this section defines the harmonized tariff code and code description on the Build Bill of Lading component.

Check Digit

This field is left blank.

Quantity - Schedule B Unit(s) (18)

The quantity shipped, as entered in the Build Bill of Lading component.

Displays the quantity that is expected to ship. If the report is created for demand lines that are in an earlier fulfillment state than Shipped, then the system is calculating the expected shipping quantity. This field displays:

• For unfulfilled demand lines, the quantity requested less the quantity backordered.

• For releasable and released demand lines, the planned release quantity.

  This is the quantity reserved, promised, or allocated. For non-soft reserve, non ATP items, the override quantity is used if entered on the Shortage Workbench, a fulfillment engine EIP, or Fulfillment Workbench.

• For confirmed demand lines, the quantity picked.

• For shipped or depleted demand lines, the quantity shipped (QTY_SHIPPED).

Shipping Weight (Kilos) (19)

The shipping weight from the Build Bill of Lading component, converted into kilograms.

Origin

The address of the business unit shipping the material.

Destination

The address to which the material should be shipped. For internal orders, this is the location code; for external orders, it's the customer ship to address; and for interunit orders, it's the destination business unit.

Business Unit

The PeopleSoft Inventory business unit shipping the items.

Shipping ID

The identification number assigned to the shipment.

Ship Line No (shipping line number)

The line number assigned to each item in the shipping ID. If the shipment is an intercompany transfer requiring export shipping documentation, the word export appears next to the shipping line number.

Order Number/InterUnit ID

A shipping line is created by attaching an MSR order line to the shipment using the Shipping/Issues component. The order number is the number of the original stock request. If the stock request is for an interunit transfer, the interunit ID assigned by the system also prints.

Demand Src/Source BU (demand source/source business unit)

The PeopleSoft application and business unit from which the order originated.

Order Line

The stock request order line associated with this shipping line number.

Schedule Line/Reason Code

The stock request shipment schedule line associated with this shipping line number and the reason code recorded for shipment.

Ship Date/Ship Time

The date and time of shipment assigned to this shipping line by the Shipping/Issues component. If the report is created for demand lines that are in an earlier fulfillment state than Shipped, then the system prints the schedule ship date or today's date if the schedule ship date is earlier than today.

Item ID/Description

The identification number and description assigned to the item.

Qty Shipped - Ordering UOM (quantity shipped in the ordering unit of measure)

The quantity of the item that was shipped, expressed in the ordering UOM.

Qty Shipped - Shipping UOM (quantity shipped in the shipping unit of measure)

The quantity of the item that was shipped, expressed in the shipping UOM. This value only appears if it is different from the ordering UOM.

For both the Quantity Shipped fields above, the quantity might be the expected shipment quantity. If the shipping document report is created for demand lines that are in an earlier fulfillment state than Shipped, then the system is calculating the expected shipping quantity. This field displays:

• For unfulfilled demand lines, the quantity requested less the quantity backordered.

• For releasable and released demand lines, the planned release quantity.

  This is the quantity reserved, promised, or allocated. For non-soft reserve, non ATP items, the override quantity is used if entered on the Shortage Workbench, a fulfillment engine EIP, or Fulfillment Workbench.

• For confirmed demand lines, the quantity picked.

• For shipped or depleted demand lines, the quantity shipped (QTY_SHIPPED).

Contract ID

The supplier's contract ID.

Route/Route Stop

The transportation route and route stop assigned to the shipment. These codes only appear if the business unit in which the order originated uses routes.

Ship From

The PeopleSoft Inventory business unit and address from which the shipment was sent.

Carrier

The carrier transporting the shipment.

Bill of Lading No (bill of lading number)

Indicates which bills of lading are included in the shipping manifest.

Consign To

The shipment destination (ship to customer or location) that you entered on the order.

Quantity/UOM

The quantity shipped, expressed in the shipping UOM.

Commodity Code/Harmonized Tariff Cd (harmonized tariff code)

The commodity or tariff code that you entered in the Build Bill of Lading component. Domestic bills of lading have commodity codes (that you defined on the Commodity Code page); export bills of lading have harmonized tariff codes (that you defined on the Harmonized Tariff Code page).

Shipment Weight/UOM

The shipping weight that you entered in the Build Bill of Lading component.

Shipment Volume/UOM

The shipping volume that you entered in the Build Bill of Lading component.

Total Quantity Shipped, Total Weight Shipped, and Total Volume Shipped

The total quantity, weight, and volume shipped for all items on the shipping manifest.

Qty Onhand (quantity on hand)

The total on-hand quantity for the item at the business unit level.

Onhand Value

The current value of the total on-hand quantity at the business unit level.

# of Dmd Trans (number of demand transactions)

The total number of demand transactions for the item during the specified date range.

# of Dmd Units (number of demand units)

The total number of units transacted to fulfill demand during the specified date range.

Total Dmd Value (total demand value)

The value of the total transacted demand for the specified date range.

# of Sup Trans (number of supply transactions)

The total number of supply transactions for the item during the specified date range.

# of Sup Units (number of supply units)

The total number of units received to fulfill supply requests.

Total Sup Value (total supply value)

The value of the total transacted supply for the specified date range.

Status

The item's current status

Inv Item (inventory item)

Indicates whether the item is an inventory item: Y(yes) or N (no).

Item Group

The group to which the item is assigned.

Item Family

The family to which the item is assigned.

Source

The source code for how the item is supplied: Make, Buy, Floor Stock, Expense, or Service.

Leadtime

The average amount of time between the date that an order is received for the item and the date that the item is shipped.

Safety Stock

The amount of safety stock required to be kept on hand for the item.

Qty Available (quantity available)/ Qty Onhand (quantity onhand)

The first line indicates the quantity available in the business unit; the second line indicates the quantity on hand in the business unit.

Qty Intransit (quantity intransit)/ Qty Reserved (quantity reserved)

The first line indicates the quantity of the item in transit to the business unit (if it is specified as the ownership business unit for interunit transfers); the second line indicates the quantity of the item reserved at the business unit level.

Area, Lev1, Lev2, Lev3, and Lev4

The storage location.

Status

The storage location's status, as defined on the Material Storage Locations page. The options are Hold or Open.

Closed

Indicates whether the location has been marked as closed (Y) or open (N) on the Material Storage Locations page.

Loc Type (location type)

The storage location type, as specified on the Material Storage Locations page. Establish storage location type codes on the Storage Location Types page.

Wt Cap (weight capacity)

The maximum weight for the storage location type, as specified on the Material Storage Locations page.

ASRS ID (automatic storage and retrieval system ID)

The automated storage and retrieval system ID, as assigned on the Material Storage Locations page.

Cntr Type (container type)

The type of container allowed in the storage location, as specified on the Material Storage Locations page. If no container type is specified, any type of container can be stored in the location.

Dim UOM (dimensions unit of measure)

The UOM for the location's height, length, and width, as defined on the Inventory Options page.

Height, Width, and Length

The dimensions of the storage location, as specified on the Material Storage Locations page.

Non Own

Indicates whether the location stores owned items (N), or non-owned or consigned items (Y), as specified on the Material Storage Locations page.

Nett (nettable)

Indicates whether the location stores items that are nettable (Y) or non-nettable (N), as specified on the Material Storage Locations page.

Susp (suspended)

Indicates whether processing of items at this location has been suspended (Y) or not (N), as specified on the Material Storage Locations page.

Phys Cyc (physical cycle)

Indicates whether the Phys/Cyc option (which signals that the location is undergoing a physical count) has been toggled on (Y) or off (N) on the Material Storage Locations page. If toggled on (Y), PeopleSoft Inventory makes the storage location unavailable for putaway, transfers and picking.

Insp Loc (inspection location)

Indicates whether inspections occur at this location, as specified on the Material Storage Locations page.

WIP Loc (work-in-progress location)

Indicates whether the location is a work-in-progress location, as specified on the Material Storage Locations page.

Exporter

The name and address of the PeopleSoft Inventory business unit that shipped the stock.

Date of Exportation

The actual shipment date.

Bill of Lading/Air WayBill No.

The bill of lading identification number.

Consigned To

The name and address of the ship to customer that you entered on the order. For an interunit transfer, this is the name and address of the in-transit ownership unit or the customer ID defined for intercompany processing on the InterUnit Ownership page.

Notify: Intermediate Consignee

The intermediate consignee that you defined on the Build Bill of Lading - Export Info page.

Forwarding Agent

The forwarding agent that you defined on the Build Bill of Lading - Export Info page.

Country of Origin

The point of origin that you defined on the Build Bill of Lading - Export Info page.

Mode of Transport

The ship via code that you entered on the Build Bill of Lading - Export Info page.

Exporting Carrier

The carrier that you entered on the Build Bill of Lading - Export Info page.

Port of Export

The port of export that you defined on the Build Bill of Lading - Export Info page.

Port of Unloading

The port of unloading that you defined on the Build Bill of Lading - Export Info page.

Containerized

If you selected the Containerized option on the Build Bill of Lading - Export Info page, the Yes check box appears selected; otherwise, the No check box appears selected.

Description

The commodity or harmonized tariff code and description for each item.

Quantity

Displays the quantity that is expected to ship, as entered on the Build Bill of Lading component. If the certificate is created for demand lines that are in an earlier fulfillment state than Shipped, then the system is calculating the expected shipping quantity. This field displays:

• For unfulfilled demand lines, the quantity requested less the quantity backordered.

• For releasable and released demand lines, the planned release quantity.

  This is the quantity reserved, promised, or allocated. For non-soft reserve, non ATP items, the override quantity is used if entered on the Shortage Workbench, a fulfillment engine EIP, or Fulfillment Workbench.

• For confirmed demand lines, the quantity picked.

• For shipped or depleted demand lines, the quantity shipped (QTY_SHIPPED).

Shipping Weight

The shipping weight from the Build Bill of Lading component.

Utilization Group

Currently, only the cycle counting utilization group (CYCL) is available.

Update

Y indicates that you ran the Utilization Type Calculation process in Update mode and that the utilization type changes documented in the report were applied to the records in the item tables. N indicates that the results of the calculation were generated for reporting purposes only and have not been applied to the item tables.

Historical Start Date

The date specified on the Utilization Type Calculation page to use with any utilization rules that calculate historical quantities or amounts over a period of time. This field appears only if one or more historical rule parameters were used to determine the utilization type classifications.

Forecast Horizon Date

The date specified on the Utilization Type Calculation Process page to use with forecasted quantity and forecasted amount rules. This field appears only if one or more of the forecast rule parameters were used to determine the utilization type classifications.

Forecast Set

The set specified on the Utilization Type Calculation Process page to use with forecasted quantity and forecasted amount rules. This field appears only if one or more of the forecast rule parameters were used to determine the utilization type classifications.

# of Items Assigned

The number of items assigned to each utilization type, as calculated during the last run of the Utilization Type Calculation process. The total number of items assigned is reported.

% of Total Items

The percentage of the total items represented by each row of the # of Items Assigned column.

Cycle Counts / Year

The number of cycle counts scheduled for each utilization type as defined by the cycle interval that you specified on the Counting Event Setup - Utilization Types page in the Counting Event Setup component. The number of cycle counts is calculated by dividing 365 days by the number of days in the cycle interval.

Total # of Item Counts / Year

The total number of item counts that you will perform for the year on the basis of the utilization type assignments. Calculate this value by summing the # of Items Assigned multiplied by the Cycle Counts/Year for each utilization type.

Utilization Group

Currently, only the cycle counting utilization group (CYCL) is available.

Update

Y indicates that you ran the Utilization Type Calculation process (INPEUTIL) in Update mode and that the utilization type changes documented in the report were applied to the records in the item tables. N indicates that the results of the calculation were generated for reporting purposes only and have not been applied to the item tables.

Historical Start Date

The date specified on the Utilization Type Calculation page to use with any utilization rules that calculate historical quantities or amounts over a period of time. This field appears only if one or more historical rule parameters were used to determine the utilization type classifications.

Forecast Horizon Date

The date that you specified on the Utilization Type Calculation page to use with forecasted quantity and forecasted amount rules. This field appears only if one or more of the forecast rule parameters were used to determine the utilization type classifications.

Forecast Set

The set that you specified on the Utilization Type Calculation page to use with forecasted quantity and forecasted amount rules. This field appears only if one or more of the forecast rule parameters were used to determine the utilization type classifications.

Util Type (utilization type)

The utilization type calculated for the item. The report sorts the records alphabetically by utilization type, listing the corresponding item IDs in ascending order.

Item

The item ID for which the utilization type was calculated. The report sorts the records alphabetically by utilization type, listing the corresponding item IDs in ascending order.

Quantity Onhand

The system on-hand balance for the inventory item.

Unit Cost

The unit cost for the item. The unit cost is derived as follows:

• For non-cost items, the unit cost is zero.

• For perpetual average cost items, the unit cost is the most current unit cost in the Perpetual Average Cost table (CM_PERPAVG_COST.CM_UNIT_COST).

• For periodic average cost items, the unit cost is the default average cost for the business unit (BU_ITEMS_INV.AVERAGE_COST).

• For standard cost items, the unit cost is derived by summing the effective-dated costs from all cost elements for the item except those belonging to Transaction Groups 030 through 039 (Issues and Shipments).

  The sum of CM_STDCOSTD_VW.TL_COST and CM_STDCOSTD_VW.LL.COST.

• For actual cost items, the unit cost is the default actual cost for the business unit (BU_ITEMS_INV.DFLT_ACTUAL_COST).

Stock Type

The stock type is set up on the Define Item - General: Classifications page.

Source Cd (source code)

Indicates whether the item was made, bought, or used as floor stock. Set up an item's source code on the Define Business Unit Item - Manufacturing: General page.

Classification Information

The classification values that led to the assignment of the utilization type.

Prev Util Type (previous utilization type)

The previous utilization type of the item before you ran the Utilization Type Calculation process.