| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
SEARCH_TEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Template
|
| 3 |
CHART_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Chart Number
|
| 4 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 5 |
SAVE_TEMPLATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Save Template
Y/N Table Edit
Default Value: Y
|
| 6 |
DELETE_TEMPLATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Template
Y/N Table Edit
Default Value: N
|
| 7 |
SCM_ANALYTICS_SD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Analytic
B1=Supply and Demand
D1=Demand
PAR=Par Replenishment Orders
S1=Supply
|
| 8 |
CHART_TITLE |
Character(60) |
VARCHAR2(60) NOT NULL |
Chart Title
|
| 9 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
IN_SDA_CTLKP_VW
|
| 10 |
IN_SDA_ACTION_CMB |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Actions
02=View Chart Only
03=View Chart and Data
04=View Data Only
05=Change Chart Properties
06=Refresh Chart Data
|
| 11 |
ATP_SUPPLY_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Optional Sources of Supply
|
| 12 |
ATP_DEMAND_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Optional Sources of Demand
|
| 13 |
IN_SDA_GROUPBOX_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Demand Search Criteria
|
| 14 |
IN_SDA_GROUPBOX_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Demand Search Criteria
|
| 15 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
Default Value: IN_SDA_OPR_CFG.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 16 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: IN_SDA_OPR_CFG.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 17 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 18 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
BU_ITM_INV_VW2
|
| 19 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
INV_ITEM_GROUP
|
| 20 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
Prompt Table:
INV_ITEM_FAM
|
| 21 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
IN_PARLOC_VW4
|
| 22 |
CART_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Par Location Group
Prompt Table:
IN_PARGROUP_VW4
|
| 23 |
DATE_RANGE_OPT1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Date Option
10=As of Date
20=Date Range
30=Number of Days
Default Value: IN_SDA_OPR_CFG.DATE_RANGE_OPT1
|
| 24 |
ASOFDATE |
Date(10) |
DATE |
As of Date
Default Value: %Date
|
| 25 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 26 |
DATE_TO |
Date(10) |
DATE |
Date To
|
| 27 |
NUM_DAYS_BEFORE1 |
Number(4,0) |
SMALLINT NOT NULL |
Before Today
Default Value: IN_SDA_OPR_CFG.NUM_DAYS_BEFORE1
|
| 28 |
NUM_DAYS_AFTER1 |
Number(4,0) |
SMALLINT NOT NULL |
After Today
Default Value: IN_SDA_OPR_CFG.NUM_DAYS_AFTER1
|
| 29 |
NBR_INTERVALS1 |
Number(2,0) |
SMALLINT NOT NULL |
Number of Intervals
Default Value: IN_SDA_OPR_CFG.NBR_INTERVALS
|
| 30 |
DAYS_INTERVAL1 |
Number(3,0) |
SMALLINT NOT NULL |
Days Interval
Default Value: IN_SDA_OPR_CFG.DAYS_INTERVAL
|
| 31 |
INCL_SO_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Orders
Y/N Table Edit
Default Value: IN_SDA_OPR_CFG.INCL_SO_DEMAND
|
| 32 |
INCL_WO_DMD |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Workorder Demand
Y/N Table Edit
Default Value: N
|
| 33 |
INCL_MSR_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Material Stock Requests
Y/N Table Edit
Default Value: IN_SDA_OPR_CFG.INCL_MSR_DEMAND
|
| 34 |
INCL_OTHER_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Other Demand Sources
Y/N Table Edit
Default Value: IN_SDA_OPR_CFG.INCL_OTHER_DEMAND
|
| 35 |
INCL_PLANND_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Scheduled Production
Y/N Table Edit
Default Value: N
|
| 36 |
INCL_IUT_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Transfers Demand
Y/N Table Edit
Default Value: IN_SDA_OPR_CFG.INCL_IUT_DEMAND
|
| 37 |
INCL_PRDN_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Component Demand
Y/N Table Edit
Default Value: IN_SDA_OPR_CFG.INCL_PRDN_DEMAND
|
| 38 |
INCL_PO_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
Y/N Table Edit
Default Value: IN_SDA_OPR_CFG.INCL_PO_SUPPLY
|
| 39 |
INCL_PURCHASING |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
Y/N Table Edit
Default Value: N
|
| 40 |
INCL_PRDN_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Orders
Y/N Table Edit
Default Value: IN_SDA_OPR_CFG.INCL_PRDN_SUPPLY
|
| 41 |
INCL_IUT_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Transfers Supply
Y/N Table Edit
Default Value: IN_SDA_OPR_CFG.INCL_IUT_SUPPLY
|
| 42 |
INCL_MSR |
Character(1) |
VARCHAR2(1) NOT NULL |
Material Stock Requests
Y/N Table Edit
Default Value: Y
|
| 43 |
INCL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Purchase Orders
Y/N Table Edit
Default Value: Y
|
| 44 |
INCL_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Requisitions
Y/N Table Edit
Default Value: Y
|
| 45 |
INCL_MTL_RETURN |
Character(1) |
VARCHAR2(1) NOT NULL |
Material Return
Y/N Table Edit
Default Value: N
|
| 46 |
X_AXIS_DATA_OPT1 |
Character(2) |
VARCHAR2(2) NOT NULL |
X-Axis Data
10=Status
20=Scheduled Date
Default Value: 10
|
| 47 |
Y_AXIS_DATA_OPT1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price
20=Quantity
30=Number of Orders
Default Value: IN_SDA_OPR_CFG.Y_AXIS_DATA_OPT5
|
| 48 |
CHART_TITLE1 |
Character(60) |
VARCHAR2(60) NOT NULL |
Chart Title
|
| 49 |
CHARTTYPE5 |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart
S=Stacked Bar Chart
Default Value: B
|
| 50 |
IN_FULFILL_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled
|
| 51 |
PO_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
|
| 52 |
PROD_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
|
| 53 |
SELECT_PENDING |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Pending
Y/N Table Edit
Default Value: N
|
| 54 |
SELECT_UNFULFILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
Y/N Table Edit
Default Value: Y
|
| 55 |
SELECT_RELEASABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
Y/N Table Edit
Default Value: Y
|
| 56 |
SELECT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Released state.
Y/N Table Edit
Default Value: Y
|
| 57 |
SELECT_CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.
Y/N Table Edit
Default Value: Y
|
| 58 |
SELECT_SHIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Picked state.
Y/N Table Edit
Default Value: N
|
| 59 |
SELECT_DEPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the RFID Tag Generation should include data in a Depleted state.
Y/N Table Edit
Default Value: N
|
| 60 |
PEND_APPR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
PENDING APPROVAL FLAG
Y/N Table Edit
Default Value: Y
|
| 61 |
APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 62 |
OPEN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OPEN FLAG
Y/N Table Edit
Default Value: Y
|
| 63 |
DISPATCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispatched
D=Dispatched
N=No
Y/N Table Edit
Default Value: Y
|
| 64 |
COMPLETED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Completed
N=Not Completed
Y=Complete
Y/N Table Edit
Default Value: N
|
| 65 |
DENY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
DENY FLAG
Y/N Table Edit
Default Value: N
|
| 66 |
PEND_CAN_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Pending Cancel
N=No
PX=Pending Cancel
Y/N Table Edit
Default Value: N
|
| 67 |
CANCEL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel PO
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 68 |
LINE_APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lines Approved
Y/N Table Edit
Default Value: Y
|
| 69 |
LINE_DENIED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Denied
Y/N Table Edit
Default Value: N
|
| 70 |
PREVIEW_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preview
Y/N Table Edit
Default Value: N
|
| 71 |
INIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Initial Flag
I=Initial
N=No
Y/N Table Edit
Default Value: N
|
| 72 |
INCL_RCPT_NOTPTWY |
Character(1) |
VARCHAR2(1) NOT NULL |
Received but Not Putaway
Y/N Table Edit
Default Value: Y
|
| 73 |
SEL_ENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Entered
Y/N Table Edit
Default Value: N
|
| 74 |
SEL_FIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Firmed
Y/N Table Edit
Default Value: Y
|
| 75 |
SEL_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Y/N Table Edit
Default Value: Y
|
| 76 |
SEL_IN_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Close In-Process Productions
Y/N Table Edit
Default Value: Y
|
| 77 |
SEL_PEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Pending-Cmpl Productions
Y/N Table Edit
Default Value: Y
|
| 78 |
SEL_CMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Completed Productions
Y/N Table Edit
Default Value: Y
|
| 79 |
SEL_LAB |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Labor-Closed Productions
Y/N Table Edit
Default Value: Y
|
| 80 |
IN_CHARTCOLOR1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 5
|
| 81 |
IN_CHARTCOLOR2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 13
|
| 82 |
IN_CHARTCOLOR3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 15
|
| 83 |
IN_CHARTCOLOR4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 10
|
| 84 |
IN_CHARTCOLOR5 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 17
|
| 85 |
IN_CHARTCOLOR6 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 17
|
| 86 |
IN_CHARTCOLOR7 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 1
|
| 87 |
IN_CHARTCOLOR8 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 2
|
| 88 |
IN_CHARTCOLOR9 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 17
|
| 89 |
IN_CHARTCOLOR10 |
Character(3) |
VARCHAR2(3) NOT NULL |
Chart Color
1=Blue
10=Red
11=White
12=Yellow
13=Red Orange
14=Yellow Green
15=Blue Violet
16=Purple
17=Yellow Orange
2=Cyan
3=Dark Gray
4=Gray
5=Green
6=Light Gray
7=Magenta
8=Orange
9=Pink
Default Value: 3
|