PeopleSoft 9.0
Cash Management

Table Name POS_WHERE_TBL

Table Description
POS_WHERE_TBL
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 Yes
SEQ_NUMBER SMALLINT Yes No
CURR_POSITION CHAR(3) No No
SEQ_NUM SMALLINT No No
WHERE_TYPE CHAR(2) No No
ALIAS_NAME CHAR(30) No No
FIELD_VALUE_STR CHAR(30) No No
FIELD_VALUE_NBR DECIMAL(26,3) No No
FIELD_VALUE_DATE PSDATE No No
RELATIVE_DATE CHAR(1) No No
COMP_OPERATOR CHAR(2) No No
OPEN_BRCKT CHAR(2) No No
CLOSE_BRCKT CHAR(2) No No
AND_OR_TXT CHAR(3) No No
NODE_SQL CHAR(254) No No
Index
Name Type Unique Member
PS_POS_WHERE_TBL PK Yes
Member(s) of "PS_POS_WHERE_TBL" Index
SETID
TREE_NAME
SOURCE_SET
POS_SOURCE_ID
TREE_NODE
SEQ_NUMBER

Published April 30, 2007