PeopleSoft 9.0
Cash Management

Table Name STL_APPRVL_WL

Table Description
STL_APPRVL_WL
Columns
Name Datatype Is PK Is FK
BUSPROCNAME CHAR(30) Yes Yes
ACTIVITYNAME CHAR(30) Yes Yes
EVENTNAME CHAR(30) Yes Yes
WORKLISTNAME CHAR(30) Yes Yes
INSTANCEID INT Yes Yes
TRANSACTIONID INT Yes Yes
APPR_INSTANCE INT Yes No
BUSINESS_UNIT CHAR(5) No No
BANK_CD CHAR(5) No No
CURRENCY_CD CHAR(3) No No
AMOUNT DECIMAL(26,3) No No
SETTLEMENT_DT PSDATE No No
PYMNT_METHOD CHAR(3) No No
Index
Name Type Unique Member
PS_STL_APPRVL_WL PK Yes
Member(s) of "PS_STL_APPRVL_WL" Index
BUSPROCNAME
ACTIVITYNAME
EVENTNAME
WORKLISTNAME
INSTANCEID
TRANSACTIONID
APPR_INSTANCE

Published April 30, 2007