WORK_CENTER_CODEPRODUCTION_IDOP_SEQUENCE10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
N=No
Y=Yes
PR=Production
RW=Rework
SV=Service
TD=Teardown
SF_DSP_LIST_VW(SQL View) |
Index Back |
|---|---|
Online Disp List Inquiry9/20 RS : View Created for Online Dispatch List Inquiry 2/25/98 RS : Added keys 05/27/99 ST CN# SF800-13.0 Added PRODUCTION_TYPE to view |
| SELECT a.work_center_code , a.production_id , a.Op_sequence , b.inv_item_id , b.prod_status , a.task_code , a.Op_overlap , a.send_ahead_qty , a.subcontracted , a.op_start_dt , a.op_start_time , a.qty_iss_to_op , a.qty_comp_and_thru , a.op_end_dt , a.qty_iss_to_op-a.qty_comp_and_thru , a.op_end_time , a.op_completed , b.config_code , b.production_type , a.assy_starts_qty , a.expectd_cmpl_qty , a.fixed_scrap_qty FROM PS_SF_OP_LIST a , ps_sf_prdnid_headr b |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WORK_CENTER_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 2 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 3 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | 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 |
| 6 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Task Code |
| 7 | OP_OVERLAP | Number(5,1) | DECIMAL(4,1) NOT NULL | CN#PL800-20.0 MACN 06/14/99- Changed the short name |
| 8 | SEND_AHEAD_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Send Ahead Quantity |
| 9 | SUBCONTRACTED | Character(1) | VARCHAR2(1) NOT NULL |
Subcontracted
N=No Y=Yes |
| 10 | OP_START_DT | Date(10) | DATE | Operation Start Date |
| 11 | OP_START_TIME | Time(15) | TIMESTAMP | Operation's Start Time |
| 12 | QTY_ISS_TO_OP | Number(12,4) | DECIMAL(11,4) NOT NULL | Quantity Issued to Operation |
| 13 | QTY_COMP_AND_THRU | Number(12,4) | DECIMAL(11,4) NOT NULL | Qty Completed and Thru Oper |
| 14 | OP_END_DT | Date(10) | DATE | Operation Due Date |
| 15 | QTY_REMAIN | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Remaining Quantity |
| 16 | OP_END_TIME | Time(15) | TIMESTAMP | Operation's Due Time |
| 17 | OP_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL | Operation Completed |
| 18 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 19 | 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 |
| 20 | ASSY_STARTS_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Assembly Starts Qty |
| 21 | EXPECTD_CMPL_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Expected Completions Qty |
| 22 | FIXED_SCRAP_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | YBO Enhancement |