PeopleSoft 9.0
Cash Management

Table Name POS_T_DTL_TBL

Table Description
POS_T_DTL_TBL
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes Yes
TIME_SET CHAR(10) Yes Yes
SEQ_NUM SMALLINT Yes No
START_PERIOD_DEF CHAR(2) No No
START_DT PSDATE No No
START_PRIOD_OFFSET CHAR(2) No No
PERIOD_TYPE_START CHAR(2) No No
PERIOD_TYPE_END CHAR(2) No No
END_PERIOD_DEF CHAR(2) No No
REPEAT_FREQ CHAR(2) No No
REPEAT_TYPE CHAR(2) No No
REPEAT_RELATIVE CHAR(2) No No
REPEAT_NUMBER SMALLINT No No
REPEAT_TIMES SMALLINT No No
DESCR50 CHAR(50) No No
Index
Name Type Unique Member
PS_POS_T_DTL_TBL PK Yes
Member(s) of "PS_POS_T_DTL_TBL" Index
SETID
TIME_SET
SEQ_NUM

Published April 30, 2007