PeopleSoft 9.0
Cash Management

Table Name TR_FEE_SEQ

Table Description
TR_FEE_SEQ
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
TR_SOURCE_CD char(1) Yes Yes
TR_SOURCE_ID char(12) Yes Yes
FEE_SEQ_NUM DECIMAL(15) Yes No
BANK_CD CHAR(5) No No
BANK_ACCT_KEY CHAR(4) No No
CURRENCY_CD CHAR(3) No No
SETTLEMENT_ID CHAR(5) No No
FA_FEE_CODE CHAR(6) No No
FEE_STRUCTURE CHAR(5) No No
FEE_AMOUNT DECIMAL(26,3) No No
TRANSACTION_DT PSDATE No No
VALUE_DT PSDATE No No
FEE_START PSDATE No No
FEE_END PSDATE No No
FEE_STATUS CHAR(1) No No
INT_BASIS CHAR(2) No No
ACCTG_TMPL_ID_CF CHAR(15) No No
ACCTG_TMPL_ID_POS CHAR(15) No No
SELLBUY_FLAG CHAR(1) No No
PYMNT_METHOD CHAR(3) No No
FORMAT_ID CHAR(10) No No
OPRID_ENTERED_BY CHAR(30) No No
DTTM_ENTERED PSDATETIME No No
Index
Name Type Unique Member
PS_TR_FEE_SEQ PK Yes
Member(s) of "PS_TR_FEE_SEQ" Index
BUSINESS_UNIT
TR_SOURCE_CD
TR_SOURCE_ID
FEE_SEQ_NUM

Published April 30, 2007