PeopleSoft 9 Asset Management |
Table Name | FIN_OPEN_PERIOD |
Table Description |
FIN_OPEN_PERIOD |
Columns |
Name | Datatype | Is PK | Is FK |
PSFT_PRODUCT | char(2) | Yes | No |
BUSINESS_UNIT | char(5) | Yes | No |
LEDGER_GROUP | char(10) | Yes | Yes |
TRANSACTION_TYPE | char(3) | Yes | No |
LEDGER_CODE | char(10) | Yes | No |
GL_ADJUST_TYPE | char(4) | No | No |
CALENDAR_ID | char(2) | No | No |
OPEN_YEAR_FROM | smallint | No | No |
OPEN_PERIOD_FROM | smallint | No | No |
BEGIN_LAG_DAYS | smallint | No | No |
OPEN_FROM_DATE | PSDATE | No | No |
OPEN_YEAR_TO | smallint | No | No |
OPEN_PERIOD_TO | smallint | No | No |
END_LAG_DAYS | smallint | No | No |
OPEN_TO_DATE | PSDATE | No | No |
Index |
Name | Type | Unique | Member |
PS_FIN_OPEN_PERIOD | PK | Yes |
![]() |
PSAFIN_OPEN_PERIOD | IE1 | No |
![]() |
Member(s) of "PS_FIN_OPEN_PERIOD" Index |
PSFT_PRODUCT |
BUSINESS_UNIT |
LEDGER_GROUP |
TRANSACTION_TYPE |
LEDGER_CODE |
Member(s) of "PSAFIN_OPEN_PERIOD" Index |
BUSINESS_UNIT |
LEDGER_CODE |
TRANSACTION_TYPE |
LEDGER_GROUP |
OPEN_YEAR_FROM |
OPEN_PERIOD_FROM |
OPEN_YEAR_TO |
OPEN_PERIOD_TO |
GL_ADJUST_TYPE |
Published December 16, 2006 |