| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 3 |
VARIANCE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
9/9/02 CRC: added variance type '15' for Yield Variance
01=Configuration Variance
02=Usage Variance
03=Component Yield Variance
04=Labor Lot Size Variance
05=Process Routing Variance
06=Efficiency Variance
07=Rate Variance
08=Material Lot Size Variance
09=Rework Expense
10=Rework Labor Expense
11=Outside Processing PPV
12=Mix Variance
13=Teardown Material Expense
14=Teardown Conversion Expense
15=Yield Variance
16=Co-Product Rate Var
17=Material Rate Variance
|
| 4 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 5 |
COMPONENT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
|
| 6 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 7 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 8 |
VARIANCE_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Variance Source
C=Close
O=Re-Open
R=Report
|
| 9 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 10 |
TRANS_TIME |
Time(15) |
TIMESTAMP |
Transaction Time
|
| 11 |
SEQ_NBR_CM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 12 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 13 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 14 |
CURR_SCHED_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED
|
| 15 |
SCHED_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Component Scheduled Qty
|
| 16 |
ISSUE_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
|
| 17 |
COMPLETED_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Completed Qty
|
| 18 |
SCRAP_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Scrapped Qty
|
| 19 |
NEW_PRDN_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Production Start Qty
|
| 20 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 21 |
CM_UNIT_COST_STD_O |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Standard Cost per Unit OLD
|
| 22 |
CM_UNIT_COST_STD_C |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Current Standard Cost
|
| 23 |
VARIANCE_AMOUNT |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Variance Amount
|
| 24 |
VARIANCE_AMOUNT3 |
Signed Number(18,6) |
DECIMAL(16,6) NOT NULL |
Variance Amount with decimal precision of 6 used by Variance Drilldown.
|