BUS_UNIT_MG_VW2

(SQL View)
Index Back

Mfg Business Unit View

05/14/00 SCC Packaging Audit: Changed default for bu_status from 'O' (invalid xlat) to '1'.

select business_unit, business_unit_in, bu_status from PS_BUS_UNIT_TBL_MG

# 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 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
3 BU_STATUS Character(1) VARCHAR2(1) NOT NULL Status
1=Facility Open
2=Facility Closed

Default Value: 1