PeopleSoft 9.0
Cash Management

Table Name POS_TREE_SQL

Table Description
POS_TREE_SQL
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) No Yes
TREE_NAME CHAR(18) No Yes
SOURCE_SET CHAR(20) No Yes
POS_SOURCE_ID char(18) No Yes
TREE_NODE CHAR(20) No No
POS_DEAL_SRC_SET CHAR(1) No No
INCLUDE_DEAL_CHK CHAR(1) No No
VERSION_NUMBER INT No No
POS_IS_DEAL_SRC CHAR(1) No No
SQLTEXT TEXT No No
Index
Name Type Unique Member
XPKPOS_TREE_SQL PK Yes
PS_POS_TREE_SQL IE1 No
Member(s) of "XPKPOS_TREE_SQL" Index
Member(s) of "PS_POS_TREE_SQL" Index
SETID
TREE_NAME
SOURCE_SET
POS_SOURCE_ID
TREE_NODE
VERSION_NUMBER

Published April 30, 2007