PeopleSoft 9
Asset Management

Table Name INSTALLATION_AM

Table Description
INSTALLATION_AM
Columns
Name Datatype Is PK Is FK
TYPE_ADD char(3) Yes No
TYPE_ADJUSTMENT char(3) No No
TYPE_TRANSFER char(3) No No
TYPE_DEPR char(3) No No
TYPE_PRIOR_DEPR char(3) No No
TYPE_RECATEGORIZE char(3) No No
TYPE_RESERVE_ADJ char(3) No No
TYPE_RETIRE char(3) No No
TYPE_REINSTATE char(3) No No
TYPE_LEASE_PAYMENT char(3) No No
TYPE_BOOK_CHANGE char(3) No No
TYPE_SUSPEND char(3) No No
TYPE_RESUME char(3) No No
TYPE_BUDGET_DEPR char(3) No No
TYPE_LEASE_PAY_BUD char(3) No No
TYPE_INFLATION char(3) No No
TYPE_RRC char(3) No No
LAST_INTFC_ID int No No
JV_PROCESS_SW char(1) No No
GROUP_PROC_SW char(1) No No
INFL_ADJ_SW char(1) No No
ACCT_ENT_TMPL_ID char(10) No No
CHILD_TK_PARENT_SW char(1) No No
ARCHIVE_ID char(8) No No
ACCUM_DEPR decimal(26,3) No No
NET_BK_VALUE decimal(26,3) No No
DEPR_CUR decimal(26,3) No No
CURRENT_FY_PDP char(1) No No
CURRENT_FY_PDP_GRP char(1) No No
IMPAIR_FLG char(1) No No
IMP_ZERO_COST_ROWS char(1) No No
LAST_CNTRCT_NO char(5) No No
BATCH_LIMIT int No No
SPACE_MGMT_FLAG char(1) No No
IT char(1) No No
FILE_SIZE decimal(10) No No
DISCO_REQ_TIMEOUT smallint No No
EFFECTIVE_RATE_SW CHAR(1) No No
NEG_DEPR_SW CHAR(1) No No
REVALUE_FLG CHAR(1) No No
ARM_SRC_FLG CHAR(1) No No
CURRENCY_CD CHAR(3) No No
RT_TYPE CHAR(5) No No
FIN_IMPACT_FLG CHAR(1) No No
Index
Name Type Unique Member
PSAINSTALLATION_AM PK Yes
Member(s) of "PSAINSTALLATION_AM" Index
TYPE_ADD

Published December 16, 2006