BUSINESS_UNITPRDN_AREA_CODESF_PRID_H_VWC4(SQL View) |
Index Back |
|---|---|
Prdn Area in Headr w/o ID01/27/98 dbe - CN# PL750-DI-SCHEW-109 (Production Schedule by Area) - Batch Reschedule. 2/17/99 RAG: CN# PL800-10.0 FPO |
| select distinct business_unit, prdn_area_code from PS_SF_PRDNID_HEADR where ma_prdn_id_flg = 'N' and prod_status in ('10', '15', '20','30') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |