PeopleSoft 9.0
Cash Management

Table Name TR_FISCPRD_CLS

Table Description
TR_FISCPRD_CLS
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
CALENDAR_ID CHAR(2) Yes Yes
FISCAL_YEAR SMALLINT Yes No
ACCOUNTING_PERIOD SMALLINT Yes No
CLS_FISCPRD_ACCTG CHAR(1) No No
ORIG_OPRID CHAR(30) No No
ORIG_DTTM PSDATETIME No No
LAST_MAINT_OPRID CHAR(30) No No
LAST_MAINT_DTTM PSDATETIME No No
RESET_OPRID CHAR(30) No No
RESET_DTTM PSDATETIME No No
DESCR60 CHAR(60) No No
Index
Name Type Unique Member
PS_TR_FISCPRD_CLS PK Yes
Member(s) of "PS_TR_FISCPRD_CLS" Index
BUSINESS_UNIT
CALENDAR_ID
FISCAL_YEAR
ACCOUNTING_PERIOD

Published April 30, 2007