PeopleSoft 9.0 Cash Management |
Table Name | POS_TREE_SOURCE |
Table Description |
POS_TREE_SOURCE |
Columns |
Name | Datatype | Is PK | Is FK |
SETID | CHAR(5) | Yes | Yes |
TREE_NAME | CHAR(18) | Yes | Yes |
SOURCE_SET | CHAR(20) | Yes | Yes |
POS_SOURCE_ID | CHAR(18) | Yes | Yes |
ALIAS_NAME | CHAR(30) | No | Yes |
POS_PHYS_SWAP_VAL | CHAR(30) | No | No |
POS_FX_VAL | CHAR(30) | No | No |
POS_PHYS_BOROW_VAL | CHAR(30) | No | No |
POS_PHYS_LEND_VAL | CHAR(30) | No | No |
POS_OPT_VAL | CHAR(30) | No | No |
POS_BIN_OPT_VAL | CHAR(30) | No | No |
POS_COMODITIES_VAL | CHAR(30) | No | No |
POS_FUTURES_VAL | CHAR(30) | No | No |
POS_GENERIC_VAL | CHAR(30) | No | No |
POS_SELECT_SQL | CHAR(254) | No | No |
POS_FROM_SQL | CHAR(50) | No | No |
POS_WHERE_SQL | CHAR(93) | No | No |
Index |
Name | Type | Unique | Member |
PS_POS_TREE_SOURCE | PK | Yes |
![]() |
Member(s) of "PS_POS_TREE_SOURCE" Index |
SETID |
TREE_NAME |
SOURCE_SET |
POS_SOURCE_ID |
Published April 30, 2007 |