PL_PROD_HDR_TMP(SQL Table) |
Index Back |
|---|---|
PL_PROD_HDR_TMPCN#PL-6.01-04 JJO added ep_group_code for future use CN# PL750-GPENN-68 JNW added production_area CN# R-AROBER-78F7 RAG Added Col Prod_Status CN# EN-6.00 PCL Added BOM Code |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EP_GROUP_CODE | Character(6) | VARCHAR2(6) NOT NULL | Group Code |
| 3 | PRODUCTION_TASK | Character(254) | VARCHAR2(254) NOT NULL | Production ID from Red Pepper |
| 4 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 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 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 8 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 9 | NEW_START_DATE | Date(10) | DATE | Start Date |
| 10 | NEW_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 11 | NEW_END_DATE | Date(10) | DATE | Due Date |
| 12 | NEW_END_TIME | Time(15) | TIMESTAMP | Due Time |
| 13 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |
| 14 | FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both N=No Y=Yes |
| 15 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 16 | 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 |