SF_PRDN_PG2_TMP(SQL Table) |
Index Back |
|---|---|
Prdn Peg to Schedule Work |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | 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 |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Production Area
Prompt Table: SF_PRDN_AREA |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: SF_PA_NOID_VW |
| 6 | NEW_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production Start Qty |
| 7 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 8 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 9 | PRDN_START_DATE | Date(10) | DATE |
Prdn Start Date
Prompt Table: SF_PRDN_SD_VW |
| 10 | PRDN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL |
Prdn Start Shift
Prompt Table: %EDITTABLE2 |
| 11 | PRDN_DUE_DATE | Date(10) | DATE |
Prdn Due Date
Prompt Table: SF_PRDN_ED_VW |
| 12 | PRDN_DUE_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL |
Prdn Due Shift
Prompt Table: SF_PRDN_ESH_VW |
| 13 | COMPLETED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
| 14 | SCRAP_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 15 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
| 16 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
| 17 | SELECT_CB | Character(1) | VARCHAR2(1) NOT NULL |
Select Check Box
N=No Y=Yes Y/N Table Edit |