SF_PRDN_AREA(SQL Table) |
Index Back |
|---|---|
Production Areas11/25/98 whs (sf800-4.0) Added FieldChange code to STORAGE_AREA and NON_OWN_STOR_AREA to hide/unhide storage location levels based on ST_LEVEL_DISPLAY. Add SaveEdit code to STORAGE_AREA to fix loc_edit check. |
| # | 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 Prompt Table: SP_BUMGOP_NONVW |
| 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
Prompt Table: MG_STR_AREA_VW |
| 5 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table: MG_STR_LEV1_VW |
| 6 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table: MG_STR_LEV2_VW |
| 7 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table: MG_STR_LEV3_VW |
| 8 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table: MG_STR_LEV4_VW |
| 9 | NON_OWN_STOR_AREA | Character(5) | VARCHAR2(5) NOT NULL |
Non Own Storage Area
Prompt Table: MG_NSTR_AREA_VW |
| 10 | NON_OWN_STOR_LEV1 | Character(4) | VARCHAR2(4) NOT NULL |
Non Owned Storage Level 1
Prompt Table: MG_NSTR_LEV1_VW |
| 11 | NON_OWN_STOR_LEV2 | Character(4) | VARCHAR2(4) NOT NULL |
Non Own Storage Level 2
Prompt Table: MG_NSTR_LEV2_VW |
| 12 | NON_OWN_STOR_LEV3 | Character(4) | VARCHAR2(4) NOT NULL |
Non Own Storage Level 3
Prompt Table: MG_NSTR_LEV3_VW |
| 13 | NON_OWN_STOR_LEV4 | Character(4) | VARCHAR2(4) NOT NULL |
Non Own Storage Level 4
Prompt Table: MG_NSTR_LEV4_VW |
| 14 | PRDN_AREA_TEXT | Long Character | CLOB | Production Area Text |