| # |
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 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 3 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 4 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 5 |
CREW_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
|
| 6 |
MG_SHIFT |
Number(2,0) |
SMALLINT NOT NULL |
MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift.
07/23/98 TKI CN#MG800-5.0
Created to replace SHIFT for the database reconcilation project (8.0)
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
|
| 7 |
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
|
| 8 |
CE_ACT_HRS |
Signed Number(12,5) |
DECIMAL(10,5) NOT NULL |
Actual Hours
|
| 9 |
CE_CREW_RATE |
Signed Number(32,15) |
DECIMAL(30,15) NOT NULL |
Crew Rate
|
| 10 |
CE_SHIFT_PREMIUM |
Signed Number(32,15) |
DECIMAL(30,15) NOT NULL |
Shift Premium
|
| 11 |
CE_EXTENDED_COST |
Signed Number(32,15) |
DECIMAL(30,15) NOT NULL |
Extended Cost
|
| 12 |
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
|