PeopleSoft 9.0
Cash Management

Table Name POS_MGR_PREF

Table Description
POS_MGR_PREF
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes No
POS_CALC_PREF CHAR(15) Yes No
OPRID CHAR(30) No No
DESCR60 CHAR(60) No No
PRIVATE_PREF_CB CHAR(1) No No
VALUE_DT PSDATE No No
SOURCE_SET_DT PSDATE No No
TIME_SET CHAR(10) No No
CURRENCY_CD CHAR(3) No No
BUSINESS_UNIT_BANK CHAR(5) No No
BUSINESS_UNIT CHAR(5) No No
SOURCE_SET CHAR(20) No No
BANK_SETID CHAR(5) No No
BANK_CD CHAR(5) No No
BANK_ACCT_KEY CHAR(4) No No
RECALC_SW CHAR(2) No No
TIME_SPAN_SW CHAR(2) No No
POS_USECPY_HIST_CB CHAR(1) No No
POS_ZERODAY_CB CHAR(1) No No
CALC_DT PSDATE No No
CALC_DT2 PSDATE No No
INSTRMNT_TEMPLATE CHAR(10) No No
INSTRUMENT_TYPE CHAR(10) No No
BAX_TEMPLATE_ID CHAR(12) No No
TR_WR_TEMPLATE_ID CHAR(12) No No
TR_TRANSFER_TYPE CHAR(2) No No
TR_TRANSFER_BAX CHAR(2) No No
TO_CURRENCY CHAR(3) No No
REVALUE_DATE_TYPE CHAR(2) No No
POS_DEFAULT_WEIGHT CHAR(1) No No
LOCK_REMINDER CHAR(1) No No
LOAD_EXT_DATA_CB CHAR(1) No No
POS_RUN_REPORT CHAR(1) No No
PT_FORMAT_TYPE CHAR(3) No No
Index
Name Type Unique Member
PS_POS_MGR_PREF PK Yes
PS0POS_MGR_PREF IE1 No
Member(s) of "PS_POS_MGR_PREF" Index
SETID
POS_CALC_PREF
Member(s) of "PS0POS_MGR_PREF" Index
OPRID
SETID
POS_CALC_PREF

Published April 30, 2007