| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
TEMPLATE_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Template Code
|
| 3 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
TMPL_TABLE_NAME |
Character(2) |
VARCHAR2(2) NOT NULL |
Field Used to store table that item template will be updating
1=Master Item Group
10=Item Cost Method
11=Product Attributes Group
12=BU Item Substitutes
13=Purchasing Attributes Group
14=Inventory Management Group
15=Inventory Fulfillment Group
16=Picking/Putaway Zones
17=Fixed Picking Location
18=Default Putaway Location
19=Item Putaway Rules
2=Inventory Items
20=Planning Attributes
21=Replenishment Attributues
22=Automatic Serial Numbering
23=PO BU Item Attributes
24=Item Supplier Attributes Group
3=Inv Item UOM
30=Manufactured Item Group
31=UPN Attributes
32=GPO Attributes
36=Replenishment Location
4=Item UOM Type
5=Substitute Items
6=Business Unit Item Group
7=BU Items Config
8=BU Items Util CD
9=BU Items WtVol
Default Value: 20
|
| 6 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 7 |
RESCH_OUT_FACTOR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Reschedule Out Factor [days]
|
| 8 |
RESCH_IN_FACTOR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Reschedule In Factor [days]
|
| 9 |
DEMAND_FENCE_OF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Demand Time Fence [days]
|
| 10 |
PLAN_FENCE_OFF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Planning Time Fence [days]
|
| 11 |
PLAN_HORIZON |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Action Message Cutoff [days]
Default Value: 999
|
| 12 |
TRANSFER_MIN_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Min Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/26/02: Added label PL_TRANS_MIN_ORDER
|
| 13 |
TRANSFER_MAX_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Max Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/26/02: Added label PL_TRANS_MAX_ORDER
|
| 14 |
TRANS_ORD_MULTIPLE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
Default Value: 1
|
| 15 |
TRANSFER_ORD_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 16 |
PUR_MIN_ORDER |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Ord Qty to Min Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/23/02: Added label PUR_MIN_ORDER2
|
| 17 |
PUR_MAX_ORDER |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/23/02: Added label PUR_MAX_ORDER2
|
| 18 |
PUR_ORDER_MULTIPLE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
Default Value: 1
|
| 19 |
PUR_ORDER_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 20 |
MFG_MOD_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Order Modifier UOM
|
| 21 |
MFG_MIN_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Order to Min Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/23/02: Added label PL_MIN_ORDER
|
| 22 |
MFG_MAX_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/23/02: Added label PL_MAX_ORDER
|
| 23 |
MFG_ORDER_MULTIPLE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
Default Value: 1
|
| 24 |
MFG_ORDER_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 25 |
MFG_LEAD_TIME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
08/04/99 MACN (CN#MG800-4.0) Converted from Y/N field to translate field.
N=Based on Routings
Y=Based on Lead Times
Default Value: N
|
| 26 |
SAFETY_LEVEL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Safety Stock Level
|
| 27 |
EXCESS_LEVEL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Excess Stock Level
|
| 28 |
AUTO_APPROVE_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Approve Message
Y/N Table Edit
|
| 29 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
|
| 30 |
PURCHASE_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Purchase Yield
Default Value: 100
|
| 31 |
TRANSFER_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Transfer Yield
Default Value: 100
|
| 32 |
SALES_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Consumption
Y/N Table Edit
Default Value: N
|
| 33 |
PROD_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Consumption
Y/N Table Edit
Default Value: N
|
| 34 |
TRANS_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Consumption
Y/N Table Edit
Default Value: N
|
| 35 |
MSR_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
10/12/01 EGS (CN#PL900-1): Added
Y/N Table Edit
Default Value: N
|
| 36 |
EXTRA_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
09/30/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 37 |
PL_AGG_DMD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Aggregate Demand
Default Value: N
|
| 38 |
RELEASED_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
Released Order
|
| 39 |
FIRMED_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
Firmed Order
|
| 40 |
PL_PRIO_FAMILY |
Character(10) |
VARCHAR2(10) NOT NULL |
Demand Priority Family
|
| 41 |
USE_SHIPTO_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Ship To Locations
Y/N Table Edit
Default Value: N
|
| 42 |
PL_FIXED_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Fixed Period (days)
|
| 43 |
PL_ITEM_EXPL |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/1/99 (cn# mg800-12) created field
Y/N Table Edit
Default Value: N
|
| 44 |
PL_PROJ_USE_DT |
Date(10) |
DATE |
11/04/02 JC (CN#PL880-1): Added USEUP_DATE label
|
| 45 |
PLANNED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned By
1=Distribution Planning
2=Master Planning
3=Material Planning
4=Not Planned
Default Value: 3
|
| 46 |
CAP_FENCE_OFF |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Capacity Fence
|
| 47 |
FCST_FULFILL_SIZE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Forecast Fulfillment Size
|
| 48 |
FCST_ADJ_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
02/28/02 EBN (CN#PL900-1.0): Added.
1=No Adjustment
2=Allocate to Next Bucket
3=Allocate to Last Bucket
4=Allocate Evenly Across Buckets
5=Allocate Using Calendar Weight
Default Value: 1
|
| 49 |
EARLY_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Early Fence
|
| 50 |
GBL_EARLY_FENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
09/07/01 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: Y
|
| 51 |
PL_SEARCH_DEPTH |
Number(2,0) |
SMALLINT NOT NULL |
Search Depth
Default Value: 1
|
| 52 |
SPOT_BUY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/24/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 53 |
DP_UOMGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UOMGROUP
Prompt Table:
DP_UOMGROUPS_VW
|
| 54 |
USE_PUR_ORD_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Purchase Order Modifier
Y/N Table Edit
Default Value: N
|
| 55 |
USE_REGION_VNDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Item Supplier By Region
Y/N Table Edit
Default Value: N
|
| 56 |
PL_RESCHEDULE_TOL |
Number(3,0) |
SMALLINT NOT NULL |
Reschedule Tolerance(In days)
|