PeopleSoft 9.0
Cash Management

Table Name POS_IMPCT_HDR

Table Description
POS_IMPCT_HDR
Columns
Name Datatype Is PK Is FK
TREE_NAME CHAR(18) Yes No
TREE_NODE CHAR(20) Yes No
POS_SOURCE_ID CHAR(18) Yes No
SOURCE_SET CHAR(20) Yes No
VALUE_DT PSDATE Yes No
CALC_DT PSDATE Yes No
CURRENCY_CD CHAR(3) Yes Yes
BUSINESS_UNIT_BANK CHAR(5) Yes No
BANK_SETID CHAR(5) Yes No
BANK_CD CHAR(5) Yes No
BANK_ACCT_KEY CHAR(4) Yes No
POS_HIST_FLAG CHAR(1) Yes No
DESCR50 CHAR(50) No No
CALC_TM PSTIME No No
POS_IMPCT_ORIG DECIMAL(26,3) No No
POS_IMPCT_WEIGHT DECIMAL(26,3) No No
POSITION_CURRENCY CHAR(3) No No
POS_DEF_SRC_SET CHAR(1) No No
LOCK_VALUE_FLAG CHAR(1) No No
Index
Name Type Unique Member
PS_POS_IMPCT_HDR PK Yes
PSAPOS_IMPCT_HDR IE1 No
Member(s) of "PS_POS_IMPCT_HDR" Index
TREE_NAME
TREE_NODE
POS_SOURCE_ID
SOURCE_SET
VALUE_DT
CALC_DT
CURRENCY_CD
BUSINESS_UNIT_BANK
BANK_SETID
BANK_CD
BANK_ACCT_KEY
POS_HIST_FLAG
Member(s) of "PSAPOS_IMPCT_HDR" Index
TREE_NAME
TREE_NODE
CALC_DT
VALUE_DT
POSITION_CURRENCY

Published April 30, 2007