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