| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
|
| 2 |
CAPACITY |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
SCP- Forecasted Supply stored as capacity.
|
| 3 |
SCP_DSPL_FLD1 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 4 |
SCP_DSPL_FLD2 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 5 |
SCP_DSPL_FLD3 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 6 |
SCP_DSPL_FLD4 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 7 |
SCP_DSPL_FLD5 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 8 |
SCP_DSPL_FLD6 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 9 |
SCP_DSPL_FLD7 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 10 |
SCP_DSPL_FLD8 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 11 |
SCP_DSPL_FLD9 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 12 |
SCP_DSPL_FLD10 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 13 |
SCP_DSPL_FLD11 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 14 |
SCP_DSPL_FLD12 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 15 |
SCP_DSPL_FLD13 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 16 |
SCP_DSPL_FLD14 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 17 |
SCP_DSPL_FLD15 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 18 |
SCP_DSPL_FLD16 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 19 |
SCP_DSPL_FLD17 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 20 |
SCP_DSPL_FLD18 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 21 |
SCP_DSPL_FLD19 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 22 |
SCP_DSPL_FLD20 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 23 |
SCP_DSPL_FLD21 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 24 |
SCP_DSPL_FLD22 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 25 |
SCP_DSPL_FLD23 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 26 |
SCP_DSPL_FLD24 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|
| 27 |
SCP_DSPL_FLD25 |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Created for SCP - Demand/Supply Details Display
|