| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_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 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 5 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 6 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 7 |
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
|
| 8 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 9 |
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.
|
| 10 |
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
|
| 11 |
VARIANCE_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Variance Source
C=Close
O=Re-Open
R=Report
|
| 12 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 13 |
TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 14 |
TRANS_TIME |
Time(15) |
TIMESTAMP |
Transaction Time
|
| 15 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 16 |
EP_RESOURCE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Enterprise Planning Resource
|
| 17 |
QTY_USED |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
The amount material consumed.
|
| 18 |
ORDER_MULTIPLE |
Number(6,0) |
INTEGER NOT NULL |
Order Quantity Multiple
|
| 19 |
RESCH_IN_FACTOR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Reschedule In Factor [days]
|
| 20 |
RESCH_OUT_FACTOR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Reschedule Out Factor [days]
|
| 21 |
PLAN_FENCE_OFF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Planning Time Fence [days]
|
| 22 |
PLAN_HORIZON |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Action Message Cutoff [days]
|
| 23 |
DEMAND_FENCE_OF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Demand Time Fence [days]
|
| 24 |
MPS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
MPS Item
|
| 25 |
EOQ |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Economic Order Quantity
|
| 26 |
QTY_MAXIMUM |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Maximum Qty
|
| 27 |
PLANNED_LOSS |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Planned Loss
|
| 28 |
SAFETY_STOCK |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Safety Stock
|
| 29 |
EXCESS_INVENTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Excess Inventory
N=None
R=Repair
S=Score
|
| 30 |
RT_FORECAST_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Forecast Sort
|
| 31 |
RT_NET_FCST_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Net Forecast Sort
|
| 32 |
RT_CUST_ORDERS_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Customer Orders Sort
|
| 33 |
RT_IU_ORDERS_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Inter-Unit Orders Sort
|
| 34 |
RT_TOT_ORDERS_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Total Orders Sort
|
| 35 |
RT_DEP_DMD_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Dependent Demand Sort
|
| 36 |
RT_TOT_DMD_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Total Demand Sort
|
| 37 |
RT_PROD_SUPPLY_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Production Supply Sort
|
| 38 |
RT_PURC_SUPPLY_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Purchased Supply Sort
|
| 39 |
RT_XFER_SUPPLY_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Transfer Supply Sort
|
| 40 |
RT_ACT_SUPPLY_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Actual Supply Sort
|
| 41 |
RT_PLN_PROD_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Planned Production Sort
|
| 42 |
RT_PLN_PURC_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Planned Purchases Sort
|
| 43 |
RT_PLN_XFER_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Planned Transfers Sort
|
| 44 |
RT_NEW_PLN_ORD_SRT |
Number(2,0) |
SMALLINT NOT NULL |
New Planned Orders Sort
|
| 45 |
RT_TOT_SUPPLY_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Total Supply Sort
|
| 46 |
RT_PLN_OH_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Planned On Hand Sort
|
| 47 |
RT_PROJ_OH_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Projected On Hand Sort
|
| 48 |
RT_ATP_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Available to Promise Sort
|
| 49 |
RT_CUM_ATP_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Cummulative ATP Sort
|
| 50 |
RT_DAYS_SUPPLY_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Days Supply Sort
|
| 51 |
RT_SAFETY_STK_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Safety Stock Sort
|
| 52 |
RT_EXCESS_INV_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Excess Inventory Sort
|
| 53 |
RT_TGT_INV_LVL_SRT |
Number(2,0) |
SMALLINT NOT NULL |
Target Inventory Level Sort
|
| 54 |
RT_FORECAST_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Forecast Title
|
| 55 |
RT_NET_FCST_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Net Forecast Title
|
| 56 |
RT_CUST_ORDERS_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Orders Title
|
| 57 |
RT_IU_ORDERS_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Inter-Unit Orders Title
|
| 58 |
RT_TOT_ORDERS_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Total Orders Title
|
| 59 |
RT_DEP_DMD_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Dependent Demand Title
|
| 60 |
RT_TOT_DMD_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Total Demand Title
|
| 61 |
RT_PROD_SUPPLY_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Production Supply Title
|
| 62 |
RT_PURC_SUPPLY_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Purchased Supply Title
|
| 63 |
RT_XFER_SUPPLY_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Transfer Supply Title
|
| 64 |
RT_ACT_SUPPLY_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Actual Supply Title
|
| 65 |
RT_PLN_PROD_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Planned Production Title
|
| 66 |
RT_PLN_PURC_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Planned Purchases Title
|
| 67 |
RT_PLN_XFER_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Planned Transfers Title
|
| 68 |
RT_NEW_PLN_ORD_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
New Planned Orders Title
|
| 69 |
RT_TOT_SUPPLY_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Total Supply Title
|
| 70 |
RT_PLN_OH_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Planned On Hand Title
|
| 71 |
RT_PROJ_OH_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Projected On Hand Title
|
| 72 |
RT_ATP_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Available to Promise Title
|
| 73 |
RT_CUM_ATP_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Cumulative ATP Title
|
| 74 |
RT_DAYS_SUPPLY_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Days Supply Title
|
| 75 |
RT_SAFETY_STK_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Safety Stock Title
|
| 76 |
RT_EXCESS_INV_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Excess Inventory Title
|
| 77 |
RT_TGT_INV_LVL_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Target Inventory Level Title
|
| 78 |
RT_PROJ_INVTRN_TTL |
Character(30) |
VARCHAR2(30) NOT NULL |
Projected Inventory Turns Ttl
|
| 79 |
RT_FORECAST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Actual Forecast
Y/N Table Edit
|
| 80 |
RT_NET_FCST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Forecast
Y/N Table Edit
|
| 81 |
RT_CUST_ORDERS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Orders
Y/N Table Edit
|
| 82 |
RT_IU_ORDERS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Inter-Unit Orders
Y/N Table Edit
|
| 83 |
RT_TOT_ORDERS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Orders
Y/N Table Edit
|
| 84 |
RT_DEP_DMD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependent Demand
Y/N Table Edit
|
| 85 |
RT_TOT_DMD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Demand
Y/N Table Edit
|
| 86 |
RT_PROD_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Supply
Y/N Table Edit
|
| 87 |
RT_PURC_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchased Supply
Y/N Table Edit
|
| 88 |
RT_XFER_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Supply
Y/N Table Edit
|
| 89 |
RT_ACT_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Actual Supply
Y/N Table Edit
|
| 90 |
RT_PLN_PROD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned Production
Y/N Table Edit
|
| 91 |
RT_PLN_PURC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned Purchases
Y/N Table Edit
|
| 92 |
RT_PLN_XFER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned Transfers
Y/N Table Edit
|
| 93 |
RT_NEW_PLN_ORD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
New Planned Orders
Y/N Table Edit
|
| 94 |
RT_TOT_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
All Supply
Y/N Table Edit
|
| 95 |
RT_PLN_OH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned On Hand
Y/N Table Edit
|
| 96 |
RT_PROJ_OH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Projected On Hand
Y/N Table Edit
|
| 97 |
RT_ATP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Available to Promise
Y/N Table Edit
|
| 98 |
RT_CUM_ATP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cummulative ATP
Y/N Table Edit
|
| 99 |
RT_DAYS_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Days Supply
Y/N Table Edit
|
| 100 |
RT_SAFETY_STK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Safety Stock
Y/N Table Edit
|
| 101 |
RT_EXCESS_INV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Excess Inventory Flag
Y/N Table Edit
|
| 102 |
RT_TGT_INV_LVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Target Inventory Level
Y/N Table Edit
|
| 103 |
RT_PROJ_INVTRN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Projected Inventory Turns
Y/N Table Edit
|
| 104 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 105 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 106 |
EG |
Character(1) |
VARCHAR2(1) NOT NULL |
Engineering
|
| 107 |
EP |
Character(1) |
VARCHAR2(1) NOT NULL |
Enterprise Planning
|
| 108 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 109 |
SOURCE_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
|
| 110 |
REF_ROUTING_ITEM |
Character(18) |
VARCHAR2(18) NOT NULL |
Reference Routing Item
|
| 111 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 112 |
RECNAME_0 |
Character(15) |
VARCHAR2(15) NOT NULL |
Level 0 Record
|
| 113 |
UPGRADE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade Type
A=All
C=Current
H=History
|
| 114 |
CUTOFF_DT |
Date(10) |
DATE |
The settlement cutoff date for a given bank/counterparty.
|
| 115 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 116 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|