CP_LOT_PRPT_VW3

(SQL View)
Index Back

Inventory Lot ID Prompt View 2

Inventory Lot ID Prompt View 2

select BUSINESS_UNIT, INV_ITEM_ID, INV_LOT_ID, CONFIG_CODE, DESCR from PS_LOT_CONTROL_INV where AVAIL_STATUS <> '3'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
4 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description