| # |
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 |
VARIANCE_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Variance Source
C=Close
O=Re-Open
R=Report
|
| 5 |
TRANS_DATE |
Date(10) |
DATE NOT NULL |
Transaction Date
|
| 6 |
TRANS_TIME |
Time(15) |
TIMESTAMP NOT NULL |
Transaction Time
|
| 7 |
SEQ_NBR2 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
|
| 8 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table:
CM_ELEMENT
|
| 9 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 10 |
VAR_PRDN_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Variance Production Quantity
This field was created on 05/06/2010 and will be used by the Variance Drilldown inquiry to show how Configuration variance and Material Lot Size variance are calculated during the Production Close. If the user has selected to close Production with remaining assemblies, then this field will be the sum of SF_PRDNID_HEADR.COMPLETED_QTY & SCRAP_QTY. Otherwise, it will be set to the value of SF_PRDNID_HEADR.NEW_PRDN_QTY.
|
| 11 |
AOQ |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Average Order Qty
|
| 12 |
VARIANCE_AMOUNT |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Variance Amount
|
| 13 |
VARIANCE_AMOUNT3 |
Signed Number(18,6) |
DECIMAL(16,6) NOT NULL |
Variance Amount with decimal precision of 6 used by Variance Drilldown.
|
| 14 |
TL_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
This Level Cost
|
| 15 |
LL_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Lower Level Cost
|
| 16 |
MG_OUTPUT_ITEM |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
|
| 17 |
MG_OUTPUT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle).
11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
|
| 18 |
MG_OUTPUT_SCHD_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Schedule qty
|
| 19 |
COMPLETED_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Completed Qty
|
| 20 |
COMPONENT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
|
| 21 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 22 |
SF_QTY_PER |
Number(16,10) |
DECIMAL(15,10) NOT NULL |
07/06/99 SCC CN# SF800-9.0: Added label Quantity
|
| 23 |
ISSUE_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
|
| 24 |
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
|
| 25 |
YIELD_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
|
| 26 |
YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Component Yield
|
| 27 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 28 |
QTY_ISS_TO_OP |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Quantity Issued to Operation
|
| 29 |
QTY_SCRAPPED |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Assembly Qty Scrapped at Op
|
| 30 |
OPERATION_YIELD |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Operation Yield
|
| 31 |
SCRAP_REC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Scrap Record Type
COMP=Component
LAB=Labor
OVHD=OVHD
|
| 32 |
EXT_QPA_COST1 |
Signed Number(20,8) |
DECIMAL(18,8) NOT NULL |
Extended Cost
|
| 33 |
EXPECTED_SCRAP |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
03/12/03 EGS (CN#PL880-1): Added
|
| 34 |
WORK_CENTER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Center
|
| 35 |
OP_TIME |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Op Time
|
| 36 |
OP_TIME_UNIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Time Unit
DY=Days
HR=Hours
MN=Minutes
|
| 37 |
TIME_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Time / Resource Type
0100=Planning Labor Setup
0200=Planning Labor Fixed Run
0300=Planning Labor Run
0400=Planning Labor Post Prod
0500=Planning Machine Setup
0600=Planning Machine Fixed Run
0700=Planning Machine Run
0800=Planning Machine Post Prod
1100=Costing Labor Setup
1200=Costing Labor Fixed Run
1300=Costing Labor Run
1400=Costing Labor Post Prod
1500=Costing Machine Setup
1600=Costing Machine Fixed Run
1700=Costing Machine Run
1800=Costing Machine Post Prod
2000=Queue Time
3000=Intransit Time
|
| 38 |
RATE_AMOUNT |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Rate Amount
|
| 39 |
RATE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly
UN=Per Unit
|
| 40 |
DAILY_CAPACITY |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Average Daily Hours
|
| 41 |
OVHD_RATE_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Conversion Ovhd Rate Code
|
| 42 |
OVERHEAD_PERCENT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Conversion Overhead %
|
| 43 |
OVERHEAD_RATE |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Conversion Overhead Rate
|
| 44 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 45 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 46 |
STD_SUB_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Standard Subcontracted Price
|