SF_PA_HDR2_VW

(SQL View)
Index Back

Production Areas HDR View

02/02/99 SCC CN#SF800-9.0: Added 10 fields for wip locations to view.

select business_unit, prdn_area_code, prdn_area_desc, storage_area, stor_level_1, stor_level_2, stor_level_3, stor_level_4, non_own_stor_area, non_own_stor_lev1, non_own_stor_lev2, non_own_stor_lev3, non_own_stor_lev4 from PS_SF_PRDN_AREA

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
3 PRDN_AREA_DESC Character(30) VARCHAR2(30) NOT NULL Description
4 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
5 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
6 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
7 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
8 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
9 NON_OWN_STOR_AREA Character(5) VARCHAR2(5) NOT NULL Non Own Storage Area
10 NON_OWN_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL Non Owned Storage Level 1
11 NON_OWN_STOR_LEV2 Character(4) VARCHAR2(4) NOT NULL Non Own Storage Level 2
12 NON_OWN_STOR_LEV3 Character(4) VARCHAR2(4) NOT NULL Non Own Storage Level 3
13 NON_OWN_STOR_LEV4 Character(4) VARCHAR2(4) NOT NULL Non Own Storage Level 4