SF_COMP_ISS_VW(SQL View) |
Index Back |
|---|---|
Component Issue View9/2/97 rlk - Change viewtext to pull pick_line_no, not picklist_line_no from sf_iss_transfer. Recreated view in db as well. 9/23/97 meg - changed pick_line_no back to picklist_line_no. 02/17/98 Lee - added RLV: SF_COMP_ISS_LVW 02/23/98 arg - moved picklist_line_no, added keys 02/03/99 meg - added mg_orig_comp_id 02/19/99 meg - made component_id thru to_stor_level4 key fields. 11/05/02 meg CN#MG880. Added serial_in_prdn. |
| SELECT DISTINCT SIT.business_unit , SIT.pick_batch_id , SIT.picklist_line_no , SIT.component_id , SIT.production_id , SIT.op_sequence , SIT.mg_orig_comp_id , SIT.qty_code , SIT.to_storage_area , SIT.to_stor_level_1 , SIT.to_stor_level_2 , SIT.to_stor_level_3 , SIT.to_stor_level_4 , SIT.non_own_flag , SIT.config_code , SIT.inv_item_id , SIT.production_type , SIT.prdn_area_code , SIT.new_start_date , SIT.new_start_time , SIT.work_center_code , SIT.descr , SIT.subcontracted , SIT.qty_short , SIT.serial_in_prdn FROM PS_SF_ISS_TRANSFER SIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PICK_BATCH_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
| 3 | PICKLIST_LINE_NO |
Number(7,0) | INTEGER NOT NULL | Pick List Sorting Line Number |
| 4 | COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
Prompt Table: %EDITTABLE2 |
| 5 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 6 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 7 | MG_ORIG_COMP_ID |
Character(18) | VARCHAR2(18) NOT NULL | original component ID |
| 8 | QTY_CODE |
Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 9 | TO_STORAGE_AREA |
Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 10 | TO_STOR_LEVEL_1 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 11 | TO_STOR_LEVEL_2 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 12 | TO_STOR_LEVEL_3 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 13 | TO_STOR_LEVEL_4 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 14 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes |
| 15 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 16 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 17 | 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 |
| 18 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 19 | NEW_START_DATE | Date(10) | DATE | Start Date |
| 20 | NEW_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 21 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 22 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 23 | SUBCONTRACTED | Character(1) | VARCHAR2(1) NOT NULL |
Subcontracted
N=No Y=Yes |
| 24 | QTY_SHORT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Short |
| 25 | SERIAL_IN_PRDN | Character(1) | VARCHAR2(1) NOT NULL | Serial in Production |