| # |
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 |
MACHINE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Machine Code
|
| 9 |
CREW_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
|
| 10 |
SF_ENTRY_DATE |
Date(10) |
DATE |
Entry Date
|
| 11 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 12 |
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
Prompt Table:
MG_SHIFTS_VW
|
| 13 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
Default Value: %DateTime
|
| 14 |
CREW_RPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Crew Reporting
Y/N Table Edit
Default Value: N
|
| 15 |
MACH_RPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Machine Reporting
Y/N Table Edit
Default Value: N
|
| 16 |
CREWSIZE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Crew Size
|
| 17 |
MACH_RESOURCES |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Machine Resources
|
| 18 |
LAB_SETUP |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Setup
|
| 19 |
LAB_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Run
|
| 20 |
LAB_FIXED_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Fixed Run
|
| 21 |
LAB_POSTPROD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Post Production
|
| 22 |
MACH_SETUP |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Setup
|
| 23 |
MACH_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Run
|
| 24 |
MACH_FIXED_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Fixed Run
|
| 25 |
MACH_POSTPROD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Post Production
|
| 26 |
LAB_SCHED_HRS |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Scheduled Hours
|
| 27 |
MACH_SCHED_HRS |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Scheduled Hours
|
| 28 |
CE_POSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Posted
6=Cost for 661
N=Cost Pending Calculation
Y=Cost Calculated
Default Value: N
|