BUSINESS_UNITWORK_CENTER_CODEPRODUCTION_ID10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
PR=Production
RW=Rework
SV=Service
TD=Teardown
Prompt Table: CP_CONFIG_VW
SF_DSP_PID_VW(SQL View) |
Index Back |
|---|---|
PID Prompt in Online Disp List5/18/98 RS (EPNT103-I79KI) : Created 12/17/98 lee 8.0 enhancement force rank #1785. Sort by PID in descending order. 05/27/99 ST CN# SF800-13.0 Added Production Type to view. 06/08/99 SPL CN# MG800-11.0 Added configuration code to record. |
| select a.business_unit, a.work_center_code, a.production_id, b.prod_status, b.prdn_area_code, b.inv_item_id, b.production_type, b.config_code from PS_SF_OP_LIST a, ps_sf_prdnid_headr b where a.business_unit= b.business_unit and a.production_id = b.production_id and b.ma_prdn_id_flg = 'Y' and b.prod_status between '20' and '40' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WORK_CENTER_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 3 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | PROD_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Production Status
10=Entered 15=Firmed 20=Released 30=In Process 40=Pend Cmpl 50=Completed 60=Clsd/Labor 70=Clsd/Acctg 90=Canceled |
| 5 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | 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 |
| 8 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table: CP_CONFIG_VW |