TR_DASH_STATE3(SQL Table) |
Index Back |
---|---|
Position Impacts Header Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | TR_DASH_GROUP | Character(1) | VARCHAR2(1) NOT NULL |
Dashboard Group
1=All Dashboards 2=Cash Position 3=Deal Management 4=Operational Default Value: 1 |
3 | TR_DASH_LIST | Character(2) | VARCHAR2(2) NOT NULL |
Dashboard list
01=Cash Position by Bank 02=Cash Position by Currency 03=Investment Mix 04=Debt Mix 05=Fixed vs. Floating rate Invest 06=Fixed vs. Floating rate Debt 07=Open Foreign Exchange Contract 08=Payments by Source 09=Payments by Status 1=Cash Position by Bank 10=Payments by Bank 11=Payments by Payment Method 12=Status of Bank Statement loads 14=Payments 15=CP By Bank 16=CP By BU 17=CP By Currency 18=CP By Source Set Default Value: 1 |
4 | DISPLAY_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Display Summary
Y/N Table Edit Default Value: Y |
5 | DISPLAY_CHART | Character(1) | VARCHAR2(1) NOT NULL |
Display Chart
Y/N Table Edit Default Value: Y |
6 | DISPLAY_DRILL | Character(1) | VARCHAR2(1) NOT NULL |
Display Detail
Y/N Table Edit Default Value: N |
7 | TR_CHART_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Chart Type
1=2D Bar 2=3D Bar Default Value: 1 |
8 | TR_CONTRACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Contract Type
B=Contract (Buy) S=Contract (Sell) Default Value: B |