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