| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 3 |
LOAD_CHARTS_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Charts Option
0=No Auto Load
1=Auto Load Startup Template
2=Auto Load Last Saved Charts
Default Value: 2
|
| 4 |
SEARCH_TEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Template
Prompt Table:
IN_SDA_MTLKP_VW
|
| 5 |
SEARCH_TEMPLATE2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Search Template
Prompt Table:
IN_SDA_CTLKP_VW
|
| 6 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
IN_SDWC_SW_VW
|
| 7 |
IN_SDA_START_PAGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Start Page
C=Combo-Source Charts
CS=Combo-Source Search
M=Dashboard - Main
MS=Multi-Chart Search
Default Value: M
|
| 8 |
SAVE_TEMPLATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Save Template
Y/N Table Edit
Default Value: Y
|
| 9 |
DISPLAY_MESSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Warning Messages
Y/N Table Edit
Default Value: Y
|
| 10 |
IN_SAVE_HISTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Save History
Y/N Table Edit
Default Value: N
|
| 11 |
REFRESH_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Refresh Data
Y/N Table Edit
Default Value: N
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 13 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 14 |
DATE_RANGE_OPT1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Date Option
10=As of Date
20=Date Range
30=Number of Days
Default Value: 10
|
| 15 |
SET_TO_CURR_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Set As Of Date to Current Date
Y/N Table Edit
Default Value: Y
|
| 16 |
NUM_DAYS_BEFORE1 |
Number(4,0) |
SMALLINT NOT NULL |
Before Today
|
| 17 |
NUM_DAYS_AFTER1 |
Number(4,0) |
SMALLINT NOT NULL |
After Today
|
| 18 |
SEL_PID |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Production IDs
Y/N Table Edit
Default Value: Y
|
| 19 |
SEL_PA |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Prdn Area Schedules
Y/N Table Edit
Default Value: Y
|
| 20 |
CHARTTYPE1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart
EP=Exploding Pie Chart
HB=Horizontal Bar Chart
P=Pie Chart
Default Value: P
|
| 21 |
CHARTTYPE2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart
EP=Exploding Pie Chart
HB=Horizontal Bar Chart
P=Pie Chart
Default Value: B
|
| 22 |
CHARTTYPE3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart
EP=Exploding Pie Chart
HB=Horizontal Bar Chart
P=Pie Chart
Default Value: B
|
| 23 |
CHARTTYPE4 |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart
EP=Exploding Pie Chart
HB=Horizontal Bar Chart
P=Pie Chart
Default Value: B
|
| 24 |
X_AXIS_DATA_OPT1 |
Character(2) |
VARCHAR2(2) NOT NULL |
X-Axis Data
10=Status
20=Scheduled Date
Default Value: 10
|
| 25 |
X_AXIS_DATA_OPT2 |
Character(2) |
VARCHAR2(2) NOT NULL |
X-Axis Data
10=Status
20=Scheduled Date
Default Value: 20
|
| 26 |
X_AXIS_DATA_OPT3 |
Character(2) |
VARCHAR2(2) NOT NULL |
X-Axis Data
10=Status
20=Scheduled Date
Default Value: 20
|
| 27 |
X_AXIS_DATA_OPT4 |
Character(2) |
VARCHAR2(2) NOT NULL |
X-Axis Data
10=Status
20=Scheduled Date
Default Value: 10
|
| 28 |
Y_AXIS_DATA_OPT1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price
20=Quantity
30=Number of Orders
Default Value: 10
|
| 29 |
Y_AXIS_DATA_OPT2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price
20=Quantity
30=Number of Orders
Default Value: 10
|
| 30 |
Y_AXIS_DATA_OPT3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price
20=Quantity
30=Number of Orders
Default Value: 20
|
| 31 |
Y_AXIS_DATA_OPT4 |
Character(2) |
VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price
20=Quantity
30=Number of Orders
Default Value: 10
|
| 32 |
IN_LEGEND_POS1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Legend Position
B=Bottom
L=Left
N=None
R=Right
T=Top
Default Value: B
|
| 33 |
IN_LEGEND_POS2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Legend Position
B=Bottom
L=Left
N=None
R=Right
T=Top
Default Value: B
|
| 34 |
IN_LEGEND_POS3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Legend Position
B=Bottom
L=Left
N=None
R=Right
T=Top
Default Value: B
|
| 35 |
IN_LEGEND_POS4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Legend Position
B=Bottom
L=Left
N=None
R=Right
T=Top
Default Value: B
|
| 36 |
DAYS_INTERVAL |
Number(2,0) |
SMALLINT NOT NULL |
Days Interval
Default Value: 10
|
| 37 |
NBR_INTERVALS |
Number(2,0) |
SMALLINT NOT NULL |
Number of Intervals
Default Value: 10
|
| 38 |
INCL_SO_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Orders
Y/N Table Edit
Default Value: Y
|
| 39 |
INCL_MSR_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Material Stock Requests
Y/N Table Edit
Default Value: Y
|
| 40 |
INCL_IUT_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Transfers Demand
Y/N Table Edit
Default Value: Y
|
| 41 |
INCL_OTHER_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Other Demand Sources
Default Value: Y
|
| 42 |
INCL_PRDN_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Component Demand
Y/N Table Edit
Default Value: Y
|
| 43 |
INCL_PO_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
Y/N Table Edit
Default Value: Y
|
| 44 |
INCL_PRDN_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Orders
Y/N Table Edit
Default Value: Y
|
| 45 |
INCL_IUT_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Transfers Supply
Y/N Table Edit
Default Value: Y
|
| 46 |
CHARTTYPE5 |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart
S=Stacked Bar Chart
Default Value: B
|
| 47 |
CHARTTYPE6 |
Character(2) |
VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart
S=Stacked Bar Chart
Default Value: B
|
| 48 |
Y_AXIS_DATA_OPT5 |
Character(2) |
VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price
20=Quantity
Default Value: 20
|
| 49 |
Y_AXIS_DATA_OPT6 |
Character(2) |
VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price
20=Quantity
Default Value: 20
|
| 50 |
SELECT_PENDING |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Pending
Y/N Table Edit
Default Value: N
|
| 51 |
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
|
| 52 |
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
|
| 53 |
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
|
| 54 |
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
|
| 55 |
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
|
| 56 |
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
|
| 57 |
PEND_APPR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
PENDING APPROVAL FLAG
Y/N Table Edit
Default Value: Y
|
| 58 |
APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 59 |
OPEN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OPEN FLAG
Y/N Table Edit
Default Value: Y
|
| 60 |
DISPATCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispatched
D=Dispatched
N=No
Y/N Table Edit
Default Value: Y
|
| 61 |
COMPLETED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Completed
N=Not Completed
Y=Complete
Y/N Table Edit
Default Value: N
|
| 62 |
DENY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
DENY FLAG
Y/N Table Edit
Default Value: N
|
| 63 |
PEND_CAN_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Pending Cancel
N=No
PX=Pending Cancel
Y/N Table Edit
Default Value: N
|
| 64 |
CANCEL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel PO
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 65 |
LINE_APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Lines Approved
Y/N Table Edit
Default Value: Y
|
| 66 |
LINE_DENIED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Denied
Y/N Table Edit
Default Value: N
|
| 67 |
PREVIEW_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preview
Y/N Table Edit
Default Value: N
|
| 68 |
INIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Initial Flag
I=Initial
N=No
Y/N Table Edit
Default Value: N
|
| 69 |
INCL_RCPT_NOTPTWY |
Character(1) |
VARCHAR2(1) NOT NULL |
Received but Not Putaway
Y/N Table Edit
Default Value: Y
|
| 70 |
SEL_ENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Entered
Y/N Table Edit
Default Value: N
|
| 71 |
SEL_FIRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Firmed
Y/N Table Edit
Default Value: Y
|
| 72 |
SEL_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Y/N Table Edit
Default Value: Y
|
| 73 |
SEL_IN_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Close In-Process Productions
Y/N Table Edit
Default Value: Y
|
| 74 |
SEL_PEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Pending-Cmpl Productions
Y/N Table Edit
Default Value: Y
|
| 75 |
SEL_CMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Completed Productions
Y/N Table Edit
Default Value: Y
|
| 76 |
SEL_LAB |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Labor-Closed Productions
Y/N Table Edit
Default Value: Y
|
| 77 |
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
|
| 78 |
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
|
| 79 |
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
|
| 80 |
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
|
| 81 |
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
|
| 82 |
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
|
| 83 |
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
|
| 84 |
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
|
| 85 |
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
|
| 86 |
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
|