PROCESS_INSTANCEBUSINESS_UNITPRODUCTION_IDINV_ITEM_IDCONFIG_CODE10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
PR=Production
RW=Rework
SV=Service
TD=Teardown
CE_PRDN_OPN_TMP(SQL Table) |
Index Back |
|---|---|
Open Production Temp TableUsed in Cost Update (SFPREVAL.cbl) to minimize access to SF_PRDNID_HEADR to select open production. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 6 | 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 |
| 7 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 8 | 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 |
| 9 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 10 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 11 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
| 12 | ORIG_UOM | Character(3) | VARCHAR2(3) NOT NULL | Original Unit of Measure |
| 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 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 16 | SF_YIELD_COST_FLG | Character(1) | VARCHAR2(1) NOT NULL | Yield Cost Flag |