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 |