| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
BU_ITEMS_INV
|
| 4 |
RESCH_OUT_FACTOR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Reschedule Out Factor [days]
|
| 5 |
RESCH_IN_FACTOR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Reschedule In Factor [days]
|
| 6 |
DEMAND_FENCE_OF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Demand Time Fence [days]
|
| 7 |
PLAN_FENCE_OFF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Planning Time Fence [days]
|
| 8 |
PLAN_HORIZON |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Action Message Cutoff [days]
Default Value: 999
|
| 9 |
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
|
| 10 |
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
|
| 11 |
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
|
| 12 |
TRANSFER_ORD_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 13 |
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
|
| 14 |
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
|
| 15 |
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
|
| 16 |
PUR_ORDER_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 17 |
MFG_MOD_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Order Modifier UOM
|
| 18 |
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
|
| 19 |
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
|
| 20 |
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
|
| 21 |
MFG_ORDER_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 22 |
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
|
| 23 |
SAFETY_LEVEL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Safety Stock Level
|
| 24 |
EXCESS_LEVEL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Excess Stock Level
|
| 25 |
AUTO_APPROVE_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Approve Message
Y/N Table Edit
|
| 26 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
|
| 27 |
PURCHASE_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Purchase Yield
Default Value: 100
|
| 28 |
TRANSFER_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Transfer Yield
Default Value: 100
|
| 29 |
SALES_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Consumption
Y/N Table Edit
Default Value: N
|
| 30 |
PROD_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Consumption
Y/N Table Edit
Default Value: N
|
| 31 |
TRANS_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Consumption
Y/N Table Edit
Default Value: N
|
| 32 |
MSR_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
10/12/01 EGS (CN#PL900-1): Added
Y/N Table Edit
Default Value: N
|
| 33 |
EXTRA_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
09/30/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 34 |
PL_AGG_DMD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Aggregate Demand
Default Value: N
|
| 35 |
RELEASED_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
Released Order
|
| 36 |
FIRMED_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
Firmed Order
|
| 37 |
PL_PRIO_FAMILY |
Character(10) |
VARCHAR2(10) NOT NULL |
Demand Priority Family
|
| 38 |
USE_SHIPTO_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Ship To Locations
Y/N Table Edit
Default Value: N
|
| 39 |
PL_FIXED_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Fixed Period (days)
|
| 40 |
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
|
| 41 |
PL_PROJ_USE_DT |
Date(10) |
DATE |
11/04/02 JC (CN#PL880-1): Added USEUP_DATE label
|
| 42 |
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
|
| 43 |
CAP_FENCE_OFF |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Capacity Fence
|
| 44 |
FCST_FULFILL_SIZE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Forecast Fulfillment Size
|
| 45 |
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
|
| 46 |
EARLY_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Early Fence
|
| 47 |
GBL_EARLY_FENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
09/07/01 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: Y
|
| 48 |
PL_SEARCH_DEPTH |
Number(2,0) |
SMALLINT NOT NULL |
Search Depth
Default Value: 1
|
| 49 |
SPOT_BUY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/24/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 50 |
DP_UOMGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UOMGROUP
Prompt Table:
DP_UOMGROUPS_VW
|
| 51 |
USE_PUR_ORD_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Purchase Order Modifier
Y/N Table Edit
Default Value: N
|
| 52 |
USE_REGION_VNDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Item Supplier By Region
Y/N Table Edit
Default Value: N
|
| 53 |
PL_RESCHEDULE_TOL |
Number(3,0) |
SMALLINT NOT NULL |
Reschedule Tolerance(In days)
Default Value: 0
|
| 54 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
|
| 55 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|