SPL_RES_DETAIL(SQL Table) |
Index Back |
|---|---|
Resource Details01/16/03 JC (CN#PL880-1): Added |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 3 | RESRC_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Resource Type
10=Primary Crew 20=Alt Crew 30=Primary Machine 40=Alt Machine 50=Primary Tool 60=Alternate Tool |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | CREW_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
| 6 | MACHINE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Machine Code |
| 7 | TOOL_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Tool ID |
| 8 | SPL_RESOURCE_DTTM |
DateTime(26) | TIMESTAMP | 01/16/03 JC (CN#PL880-1): Added |
| 9 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 10 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 11 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 12 | WORK_CENTER_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 13 | SPL_RES_NEEDED | Number(12,4) | DECIMAL(11,4) NOT NULL | 01/16/03 JC (CN#PL880-1): Added |
| 14 | SPL_RES_RELEASED | Number(12,4) | DECIMAL(11,4) NOT NULL | 01/16/03 JC (CN#PL880-1): Added |
| 15 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 16 | SPL_RES_END_DTTM | DateTime(26) | TIMESTAMP | 01/16/03 JC (CN#PL880-1): Added |
| 17 | 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 |
| 18 | REMAINING_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 JNW (CN#PL900-1.0): Added |
| 19 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 20 | SPL_RES_TOTAL | Number(12,4) | DECIMAL(11,4) NOT NULL | 01/16/03 JC (CN#PL880-1): Added |
| 21 | PL_NO_DETAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL | PL_NO_DETAIL_FLG |
| 22 | PL_RES_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
12/18/02 EGS (CN#PL880-1): Added
10=Crew 30=Machine 50=Tool 70=Work Center |
| 23 | PROCESS_DATE | Date(10) | DATE | Process Date |