EN_PHYS_INV_VW

(SQL View)
Index Back

ENG Physical Inv Table - Vw


select business_unit, storage_area, stor_level_1, stor_level_2, stor_level_3, stor_level_4, qty from PS_PHYSICAL_INV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_IN

2 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_AREA_VW

3 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
4 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
5 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
6 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
7 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity