TR_DASH_STATE(SQL Table) |
Index Back |
---|---|
Treasury Dashboard user state |
# | 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 | 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 |
3 | DISPLAY_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Display Summary
Y/N Table Edit Default Value: Y |
4 | DISPLAY_CHART | Character(1) | VARCHAR2(1) NOT NULL |
Display Chart
Y/N Table Edit Default Value: Y |
5 | DISPLAY_DRILL | Character(1) | VARCHAR2(1) NOT NULL |
Display Detail
Y/N Table Edit Default Value: N |