PeopleSoft 9 Asset Management |
Table Name | BOOK_ARCHIVE |
Table Description |
BOOK_ARCHIVE |
Columns |
Name | Datatype | Is PK | Is FK |
ARCHIVE_ID | char(8) | Yes | No |
BUSINESS_UNIT | char(5) | Yes | Yes |
ASSET_ID | char(12) | Yes | No |
BOOK | char(10) | Yes | Yes |
BEGIN_CALC_DT | PSDATE | No | No |
BEGIN_CALC_FY | smallint | No | No |
BEGIN_CALC_PD | smallint | No | No |
RSV_FRACTION | decimal(15,13) | No | No |
SCHED_FRACTION | decimal(15,13) | No | No |
BEGIN_FRACTION | decimal(15,13) | No | No |
LIFE_REMAINING | decimal(15,11) | No | No |
OLD_ARCHIVE_ID | char(8) | No | No |
Index |
Name | Type | Unique | Member |
PS_BOOK_ARCHIVE | PK | Yes |
![]() |
Member(s) of "PS_BOOK_ARCHIVE" Index |
ARCHIVE_ID |
BUSINESS_UNIT |
ASSET_ID |
BOOK |
Published December 16, 2006 |