PeopleSoft 9
Asset Management

Table Name DEPR_ALLOC_TBL

Table Description
DEPR_ALLOC_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
CALENDAR_ID char(2) Yes No
FISCAL_YEAR smallint Yes No
START_PD smallint Yes No
END_PD smallint Yes No
ACCOUNTING_PERIOD smallint Yes No
PD_ALLOC decimal(18,15) No No
PD_ALLOC_TOTAL decimal(18,15) No No
BEGIN_DT PSDATE No No
END_DT PSDATE No No
Index
Name Type Unique Member
PS_DEPR_ALLOC_TBL PK Yes
PSADEPR_ALLOC_TBL IE1 No
PSBDEPR_ALLOC_TBL IE2 No
Member(s) of "PS_DEPR_ALLOC_TBL" Index
SETID
CALENDAR_ID
FISCAL_YEAR
START_PD
END_PD
ACCOUNTING_PERIOD
Member(s) of "PSADEPR_ALLOC_TBL" Index
FISCAL_YEAR
START_PD
END_PD
Member(s) of "PSBDEPR_ALLOC_TBL" Index
FISCAL_YEAR
ACCOUNTING_PERIOD

Published December 16, 2006