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 |