PeopleSoft 9
Asset Management

Table Name INTFC_FIN

Table Description
INTFC_FIN
Columns
Name Datatype Is PK Is FK
INTFC_ID int Yes Yes
INTFC_LINE_NUM int Yes Yes
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK CHAR(10) Yes No
DTTM_STAMP PSDATETIME Yes Yes
VOUCHER_ID char(8) Yes Yes
VOUCHER_LINE_NUM int Yes Yes
DISTRIB_LINE_NUM int Yes Yes
OPERATING_UNIT char(8) Yes No
PRODUCT char(6) Yes No
FUND_CODE char(5) Yes No
CLASS_FLD char(5) Yes No
PROGRAM_CODE char(5) Yes No
BUDGET_REF char(8) Yes No
AFFILIATE char(5) Yes No
AFFILIATE_INTRA1 char(10) Yes No
AFFILIATE_INTRA2 char(10) Yes No
PROJECT_ID char(15) Yes No
DEPTID char(10) Yes No
CATEGORY char(5) Yes No
COST_TYPE char(1) Yes No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
CF_SEQNO INT No No
INTFC_TYPE char(3) No Yes
SYSTEM_SOURCE char(3) No No
APPROVAL_SW char(1) No No
PI_ID char(10) No No
INTFC_STATUS char(3) No No
LOAD_STATUS char(3) No No
ORIG_INTFC_ID int No No
ORIG_LINE_NUM int No No
DEFAULT_PROFILE_SW char(1) No No
TRANS_CODE char(5) No No
TRANS_IN_OUT char(1) No No
TRANS_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
IN_SERVICE_DT PSDATE No No
IN_SERVICE_PD smallint No No
IN_SERVICE_FY smallint No No
DEPR_IN_SERVICE_SW char(1) No No
BEGIN_DEPR_DT PSDATE No No
BEGIN_DEPR_PD smallint No No
BEGIN_DEPR_FY smallint No No
BEGIN_FRACTION decimal(15,13) No No
DEPR_CALC_SW char(1) No No
BEGIN_CALC_DT PSDATE No No
BEGIN_CALC_PD smallint No No
BEGIN_CALC_FY smallint No No
CALCULATION_TYPE char(1) No No
LAST_CALC_TYPE char(1) No No
RSV_FRACTION decimal(15,13) No No
RECALC_RSV_SW char(1) No No
SCHED_FRACTION decimal(15,13) No No
YEAR_REM_FRACTION decimal(15,13) No No
DEPR_STATUS char(1) No No
REGULATION char(1) No No
RECOVERY_LIFE decimal(3,1) No No
RECOVERY_SUBTYPE char(2) No No
CONVENTION char(2) No No
LIFE smallint No No
LIFE_REMAINING decimal(15,11) No No
TAX_CLASS_AM char(6) No No
DEPR_PERCENT decimal(9,8) No No
DB_PERCENT decimal(15,14) No No
METHOD char(2) No No
DEPR_SCHED_CD char(10) No No
DEPR_LIMIT_CD char(10) No No
PROPERTY_CD char(1) No No
PROPERTY_TYPE char(1) No No
SALVAGE_VALUE decimal(26,3) No No
TAX_CREDIT_SW char(1) No No
BASIS_RED_TOTAL decimal(26,3) No No
BASIS_RED_RECAP decimal(26,3) No No
SEC179_TAKEN_SW char(1) No No
SEC179_AMT decimal(26,3) No No
ACTIVITY_SW smallint No No
RETIRE_SW smallint No No
QUANTITY decimal(15,4) No No
COST decimal(26,3) No No
CURRENCY_CD char(3) No No
TRANSFER_BU char(5) No No
TRANSFER_ASSET_ID char(12) No No
TRANSFER_BOOK char(10) No No
OPRID char(30) No No
FISCAL_YEAR SMALLINT No No
START_PD smallint No No
END_PD smallint No No
YTD_FLAG char(1) No No
DEPR decimal(26,3) No No
DEPR_YTD decimal(26,3) No No
RETIREMENT_DT PSDATE No No
RETIRE_CONVENTION char(2) No No
END_DEPR_DT PSDATE No No
DISPOSAL_CODE char(1) No No
RETIREMENT_TYPE char(1) No No
RETIREMENT_STATUS char(1) No No
VOLUNTARY char(1) No No
TRADE_IN_ASSET_ID char(12) No No
TRADE_IN_DTTM_STMP PSDATETIME No No
TRADE_IN_AMT decimal(26,3) No No
CASH decimal(26,3) No No
TRADE_IN_VALUE decimal(26,3) No No
LIABILITY_ASSUMED decimal(26,3) No No
NON_LIKE_KIND decimal(26,3) No No
REFERENCE char(30) No No
RETIRE_QUANTITY decimal(15,4) No No
RETIREMENT_AMT decimal(26,3) No No
PROCEEDS decimal(26,3) No No
REMOVAL_COST decimal(26,3) No No
RETIREMENT_RSV decimal(26,3) No No
GAIN_LOSS decimal(26,3) No No
LEASE_REM_PAYMNTS decimal(26,3) No No
OPEN_TRANS_ID decimal(10) No No
CALC_DEPR_STATUS char(1) No No
CALC_DIST_STATUS char(1) No No
MESSAGE_SET_NBR int No No
MESSAGE_NBR int No No
BUSINESS_UNIT_JV char(5) No No
LIFE_END_DT PSDATE No No
DEPR_LOW_LIMIT decimal(26,3) No No
SUSPEND_STATUS char(1) No No
SUSPEND_DT PSDATE No No
RESUME_DT PSDATE No No
SUSPENDED_PERIODS smallint No No
COST_BASIS_LIMIT decimal(26,3) No No
DEPR_AVG_OPTION char(1) No No
UOP_ID char(10) No No
IU_MAP_KEY smallint No No
MC_DEFN_ID char(30) No Yes
GROUP_ASSET_ID char(12) No No
UD_METHOD_ID char(5) No No
INCLUDE_CAP_GAINS char(1) No No
REDUCED_COST decimal(26,3) No No
CAPITAL_G_L decimal(26,3) No No
RET_NON_CAP_AMT2 decimal(26,3) No No
AM_BK_UD_CHAR1 char(10) No No
AM_BK_UD_CHAR2 char(10) No No
AM_BK_UD_DATE1 PSDATE No No
AM_BK_UD_NUM1 decimal(18,3) No No
AM_BK_UD_NUM2 decimal(18,3) No No
INCREASE_RATE decimal(9,6) No No
FULLY_DEPR_SW char(1) No No
ACCOUNTING_MTHD char(3) No No
FUTURE_DEPR_YEARS smallint No No
SALVAGE_VAL decimal(26,3) No No
SALVAGE_PCT decimal(15,14) No No
AUTO_RETIRED_SW char(1) No No
RATE_DIV decimal(15,8) No No
RATE_DIV_2 decimal(15,8) No No
RATE_MULT decimal(15,8) No No
RATE_MULT_2 decimal(15,8) No No
RT_EFFDT PSDATE No No
RT_TYPE char(5) No No
BILL_TO_CUST_ID char(15) No No
ADDRESS_SEQ_NUM INT No No
SHIP_TO_CUST_ID char(15) No No
SHIP_TO_ADDR_NUM INT No No
SHIP_FROM_LOC char(10) No No
SOLD_TO_CUST_ID char(15) No No
SOLD_TO_ADDR_NUM INT No No
BILL_SOURCE_ID char(10) No No
TOT_OBLIGATION decimal(26,3) No No
TXN_CASH decimal(26,3) No No
TXN_COST decimal(26,3) No No
TXN_CURRENCY_CD char(3) No No
TXN_CURRENCY_CD2 char(3) No No
TXN_LIAB_ASSUMED decimal(26,3) No No
TXN_NON_LIKE_KIND decimal(26,3) No No
TXN_PROCEEDS decimal(26,3) No No
TXN_REMOVAL_COST decimal(26,3) No No
TXN_TRADE_IN_VALUE decimal(26,3) No No
DEPR_BONUS_SW char(1) No No
DEPR_BONUS_PCT decimal(5,2) No No
PROCESS_INSTANCE decimal(10) No No
SPECIAL_DEPR_SW char(1) No No
ACCELERATED_TERMS char(10) No No
INITIAL_TERMS char(10) No No
SPECIAL_TERMS char(10) No No
YEAR_CHANGE smallint No No
LIFE_IN_YRS decimal(5,1) No No
MULTI_SHIFT_CODE char(6) No No
MULTI_SHIFT_NBR smallint No No
DEPR_LIMIT_PCT decimal(5,2) No No
DEPR_PASS_LIFE_SW char(1) No No
DEROGATORY_SW char(1) No No
ACCEL_DEPR decimal(26,3) No No
INCREASE_DEPR decimal(26,3) No No
INITIAL_DEPR decimal(26,3) No No
SPEC_DEPR decimal(26,3) No No
STANDARD_DEPR decimal(26,3) No No
IMPAIR_FLG char(1) No No
CC_FLAG char(3) No No
ADJUST_CONVENTION CHAR(2) No No
Index
Name Type Unique Member
PS_INTFC_FIN PK Yes
PSAINTFC_FIN IE1 No
PSCINTFC_FIN IE2 No
PSWINTFC_FIN IE3 No
Member(s) of "PS_INTFC_FIN" Index
INTFC_ID
INTFC_LINE_NUM
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
VOUCHER_ID
VOUCHER_LINE_NUM
DISTRIB_LINE_NUM
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE
AFFILIATE_INTRA1
AFFILIATE_INTRA2
PROJECT_ID
DEPTID
CATEGORY
COST_TYPE
Member(s) of "PSAINTFC_FIN" Index
INTFC_ID
LOAD_STATUS
APPROVAL_SW
INTFC_TYPE
DEFAULT_PROFILE_SW
Member(s) of "PSCINTFC_FIN" Index
PROCESS_INSTANCE
Member(s) of "PSWINTFC_FIN" Index
INTFC_ID
INTFC_LINE_NUM
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP
VOUCHER_ID
VOUCHER_LINE_NUM
DISTRIB_LINE_NUM
OPERATING_UNIT
PRODUCT
FUND_CODE
CLASS_FLD
PROGRAM_CODE
BUDGET_REF
AFFILIATE

Published December 16, 2006