| # |
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 |
PRDN_AREA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area
Prompt Table:
SF_PRDN_AREA
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
SF_PA_NOID_VW
|
| 4 |
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
|
| 5 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 6 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
Prompt Table:
%EDITTABLE
|
| 7 |
WORK_CENTER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Center
Prompt Table:
EN_WORK_CENTER
|
| 8 |
CREW_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
|
| 9 |
MACHINE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Machine Code
|
| 10 |
SF_ENTRY_DATE |
Date(10) |
DATE |
Entry Date
|
| 11 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 12 |
CM_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Book
Prompt Table:
CM_BU_BOOK_TBL
|
| 13 |
CE_COST_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Type
|
| 14 |
COST_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table:
CE_VERSION5_VW
|
| 15 |
CONVERSION_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Conversion Code
|
| 16 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
Default Value: %DateTime
|
| 17 |
CREW_RPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Crew Reporting
Y/N Table Edit
Default Value: N
|
| 18 |
MACH_RPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Machine Reporting
Y/N Table Edit
Default Value: N
|
| 19 |
CREWSIZE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Crew Size
|
| 20 |
MACH_RESOURCES |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Machine Resources
|
| 21 |
CE_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
source
|
| 22 |
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
|
| 23 |
CE_ACT_HRS |
Signed Number(12,5) |
DECIMAL(10,5) NOT NULL |
Actual Hours
|
| 24 |
RATE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly
UN=Per Unit
|
| 25 |
RATE_AMOUNT |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Rate Amount
|
| 26 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 27 |
CE_POSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Posted
6=Cost for 661
N=Cost Pending Calculation
Y=Cost Calculated
|