| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MG_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 4 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 5 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 6 |
CONVERSION_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Conversion Type
1100=Lab Setup
1200=Lab Fixed
1300=Labor Run
1400=Lab PostPr
1500=Mach Setup
1600=Mach Fixed
1700=Mach Run
1800=MC PostPrd
2100=Ovhd 1
2200=Ovhd 2
2300=Ovhd 3
2400=Ovhd 4
|
| 7 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 8 |
TRANS_TIME |
Time(15) |
TIMESTAMP |
Transaction Time
|
| 9 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 10 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 11 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 12 |
PRDN_AREA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area
|
| 13 |
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
|
| 14 |
CONVERSION_AMT |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Conversion Amount
|
| 15 |
RATE_AMOUNT |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Rate Amount
|
| 16 |
RATE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly
UN=Per Unit
|
| 17 |
OP_TIME_RATE |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Operation Time/Rate
|
| 18 |
OP_TIME_RATE_UNIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Operation Time/Rate Unit
DY=Days
HR=Hours
MN=Minutes
UD=Units per Day
UH=Units per Hour
UM=Units per Minute
|
| 19 |
OVERHEAD_RATE |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Conversion Overhead Rate
|
| 20 |
OVERHEAD_PERCENT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Conversion Overhead %
|
| 21 |
OH_RATE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Conversion Ovhd Rate Type
%L=% of Labor Amt
%M=% of Mach Amt
PL=Amt Per Labor Hr
PM=Amt Per Mach Hr
PU=Per Unit Amt
|
| 22 |
OH_LAB_MACH_AMT |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Lab/Mach Amt for Ovhd Cal
|
| 23 |
EARN_COST_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Earned Cost Quantity
|
| 24 |
PRORATE_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Maximum Quantity
|
| 25 |
PERCENT_COMP |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Scrap Prdn Pct
|
| 26 |
DAILY_CAPACITY |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Average Daily Hours
|
| 27 |
CREWSIZE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Crew Size
|
| 28 |
MACH_RESOURCES |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Machine Resources
|
| 29 |
QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity
Default Value: 1
|
| 30 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
|
| 31 |
POSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
Default Value: N
|
| 32 |
PRDN_SPLIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SCC CN#SF800-9.0: New field.
Y/N Table Edit
Default Value: N
|
| 33 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
Y/N Table Edit
|
| 34 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 35 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 36 |
REVALUE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
Y/N Table Edit
Default Value: N
|