PeopleSoft 9.0
Cash Management

Table Name TRA_FISCPRD_DTL

Table Description
TRA_FISCPRD_DTL
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
SEQ_NBR DECIMAL(15) Yes No
TRANSACTION_LEG SMALLINT Yes No
PROCESS_INSTANCE DECIMAL(10) Yes No
FISCAL_YEAR SMALLINT Yes No
ACCOUNTING_PERIOD SMALLINT Yes No
AS_OF_DATE PSDATE No No
RUN_DT PSDATE No No
CURRENCY_CD CHAR(3) No No
ORIG_DISCPR_AMT DECIMAL(26,3) No No
DISCPR_END_DT PSDATE No No
DISCPR_ACCR_TO_DT PSDATE No No
DISCPR_ACCR_TO_AMT DECIMAL(26,3) No No
PER_ACCR_DISCPR DECIMAL(26,3) No No
INT_ACCR_END_DT PSDATE No No
INT_ACCR_TO_DT PSDATE No No
INT_ACCR_TO_AMT DECIMAL(26,3) No No
PER_ACCR_INTEREST DECIMAL(26,3) No No
PRINCIPAL_BALANCE DECIMAL(26,3) No No
PRINCIPAL_PAYMENT DECIMAL(26,3) No No
INTEREST_PAYMENT DECIMAL(26,3) No No
FEE_START PSDATE No No
FEE_END PSDATE No No
FEE_AMOUNT DECIMAL(26,3) No No
FEE_ACCR_TO_DT PSDATE No No
FEE_ACCR_TO_AMT DECIMAL(26,3) No No
UNAMORT_FEE_AMT DECIMAL(26,3) No No
PER_ACCR_FEE DECIMAL(26,3) No No
Index
Name Type Unique Member
PS_TRA_FISCPRD_DTL PK Yes
Member(s) of "PS_TRA_FISCPRD_DTL" Index
BUSINESS_UNIT
TR_SOURCE_CD
TR_SOURCE_ID
SEQ_NBR
TRANSACTION_LEG
PROCESS_INSTANCE
FISCAL_YEAR
ACCOUNTING_PERIOD

Published April 30, 2007