PeopleSoft 9.0 Cash Management |
Table Name | POS_SQL_DTL |
Table Description |
POS_SQL_DTL |
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 |
TREE_NODE | char(20) | Yes | No |
POSITION_CURRENCY | CHAR(3) | No | No |
WEIGHTING | DECIMAL(8,5) | No | No |
POS_DEF_SRC_SET | CHAR(1) | No | No |
RECNAME | CHAR(15) | No | No |
CURRENCY_FIELDNAME | CHAR(18) | No | No |
POS_SELECT_SQL | CHAR(254) | No | No |
POS_WHERE_SQL | CHAR(93) | No | No |
POS_FROM_SQL | CHAR(50) | No | No |
VERSION_NUMBER | INT | No | No |
SQLTEXT | TEXT | No | No |
Index |
Name | Type | Unique | Member |
PS_POS_SQL_DTL | PK | Yes |
![]() |
Member(s) of "PS_POS_SQL_DTL" Index |
SETID |
TREE_NAME |
SOURCE_SET |
POS_SOURCE_ID |
TREE_NODE |
Published April 30, 2007 |