SF_CLS_PRDN_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ROW_USE |
Number(3,0) | SMALLINT NOT NULL | ROW USE |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 7 | 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 |
| 8 | PRDN_DUE_DATE | Date(10) | DATE | Prdn Due Date |
| 9 | PRDN_DUE_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 10 | COMP_CLOSE_DT | Date(10) | DATE | Date of Completion |
| 11 | LAB_CLOSE_DT | Date(10) | DATE | Labor Close Date |
| 12 | 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 |
| 13 | MA_PRDN_ID_FLG | Character(1) | VARCHAR2(1) NOT NULL |
10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No Y=Yes |
| 14 | NEW_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production Start Qty |
| 15 | COMPLETED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
| 16 | SCRAP_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 17 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 18 | COMP_SHORT_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Component shortage exist
Y/N Table Edit |
| 19 | REMAINING_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Remaining Amount |
| 20 | NEW_PRDN_STATUS | Character(10) | VARCHAR2(10) NOT NULL | New production status |
| 21 | PRNT_POTENTIAL_VAR | Character(1) | VARCHAR2(1) NOT NULL | Print Potential Variances |