BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
PRODUCTION_IDDefault Value: NEXT
Prompt Table: DM_PRD_AN_VW
PRODUCTION_TYPEPR=Production
RW=Rework
SV=Service
TD=Teardown
Default Value: PR
SF_PRDN_ADD_VW(SQL View) |
Index Back |
|---|---|
Add Production ID/* 1/22/01, Used in PRDN_ID_MAINT to add new production |
| SELECT a.business_unit , a.production_id , a.production_type FROM PS_SF_PRDNID_HEADR a WHERE a.ma_prdn_id_flg = 'Y' AND a.prod_status <= '30' |
| # | 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 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Default Value: NEXT Prompt Table: DM_PRD_AN_VW |
| 3 | PRODUCTION_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown Default Value: PR |