FILENAME: D9530F50 MASTER
DESCRIPTION: FRSV3.0 IFIXED ASSETS MASTER FILE DESCRIPTIONS
FIELDNAME ALIAS FORMAT DESCRIPTION FIELDTYPE
FIELDNAME
ALIAS
FORMAT
DESCRIPTION
FIELDTYPE
TA003_TART TART_KEY A11 TART KEY
I
TA005 ASSET_STATUS A1 ASSET STATUS
TA010 ASSET_NUM A10 ASSET NUM
I
TA020 DELETE_FLAG A1 DELETE FLAG
TA025 NOTES_FLAG A1 NOTES FLAG
TA030 IN_PROCESS_FLAG A1 IN PROCESS FLAG
TA035 REPRINT_FLAG A1 REPRINT FLAG
TA040 BLDG_COMPON_FLAG A1 BLDG COMPON FLAG
TA050 DT_OF_LAST_ACTV YYMD DATE DT OF LAST ACTV
TA055 LAST_TRAN_TYPE A3 LAST TRAN TYPE
TA060 CREATE_DT YYMD DTE CREATE DT
TA065 CREATE_REF A6 CREATE REF
TA002 ASSET_DESC A20 ASSET DESC
TA110 ASSET_DESC_2 A20 ASSET DESC 2
TA115 CLASS_CODE A6 CLASS CODE
TA120 RELATED_ASSET_NUM A10 RELATED ASSET NUM
TA125 CAPITALIZATION A1 CAPITALIZATION
TA130 COMMODITY_CODE A11 COMMODITY CODE
TA135 OWNER_TITLE_CHG_DT YYMD DATE OWNER TITLE CHG DT
TA140 IN_SERVICE_DT YYMD DATE IN SERVICE DT
TA145 MOVABLE_ATTACHED A1 MOVABLE ATTACHED
TA150 OWNERSHIP_TITLE A1 OWNERSHIP TITLE
TA155 REAL_PERSONAL A1 REAL PERSONAL
TA160 LAST_INVEN_DT YYMD DATE LAST INVEN DT
TA165 NEXT_INVEN_DT YYMD DATE NEXT INVEN DT
TA170 HOW_TAGGED A2 HOW TAGGED
TA175 CONDITION A2 CONDITION
TA180 SPECIAL_LICENSE A2 SPECIAL LICENSE
TA185 FLOOR_SPACE_AREA I9 I4 FLOOR SPACE AREA
TA190 FLOOR_SPACE_UOM A3 FLOOR SPACE UOM
TA195 EXPOSURE_CODE A2 EXPOSURE CODE
TA200 TAG_NUM A10 TAG NUM
I
TA205 CUSTODIAN_NAME A20 CUSTODIAN NAME
TA210 SUB_DEPARTMENT A2 SUB DEPT
TA215 AVAILABILITY A2 AVAILABILITY
TA220 AVAIL_LAST_CHG_DT YYMD DATE AVAIL LAST CHG DT
TA225 INVEN_TYPE A1 INVEN TYPE
TA230 TFR_FROM_ASSET A10 TFR FROM ASSET
TA234 CAPITAL_CAMPUS A2 CAPITAL CAMPUS
TA235 ASSET_ACCOUNT_NUM A6 ASSET ACCOUNT NUM
TA240 ALT_DEPR_ACCT_NUM A10 ALT DEPR ACCT NUM
TA300 VENDOR_NUM A11 VENDOR NUM
TA305 VENDOR_NAME A30 VENDOR NAME
TA310 PO_NUM A7 PO NUM
TA315 PO_LINE_NUM A3 PO LINE NUM
TA320 INVOICE_NUM A14 INVOICE NUM
TA325 QTY D10.2 D5 QTY
TA330 UNIT_OF_MEASURE A3 UNIT OF MEASURE
TA335 NEW_USED A1 NEW USED
TA340 VOUCHER_NUM A7 VOUCHER NUM
TA350 BANK_NUM A2 BANK NUM
TA355 CHECK_NUM A6 CHECK NUM
TA360 ACCT_1_CAMPUS_CODE A2 ACCT 1 CAMPUS CODE
TA362 ACCT_2_CAMPUS_CODE A2 ACCT 2 CAMPUS CODE
TA364 ACCT_3_CAMPUS_CODE A2 ACCT 3 CAMPUS CODE
TA366 ACCT_4_CAMPUS_CODE A2 ACCT 4 CAMPUS CODE
TA368 ACCT_5_CAMPUS_CODE A2 ACCT 5 CAMPUS CODE
TA370 ACCT_6_CAMPUS_CODE A2 ACCT 6 CAMPUS CODE
TA372 ACCT_7_CAMPUS_CODE A2 ACCT 7 CAMPUS CODE
TA374 ACCT_8_CAMPUS_CODE A2 ACCT 8 CAMPUS CODE
TA380 ACQ_ACCOUNT_NUM_1 A10 ACQ ACCOUNT NUM 1
TA382 ACQ_ACCOUNT_NUM_2 A10 ACQ ACCOUNT NUM 2
TA384 ACQ_ACCOUNT_NUM_3 A10 ACQ ACCOUNT NUM 3
TA386 ACQ_ACCOUNT_NUM_4 A10 ACQ ACCOUNT NUM 4
TA388 ACQ_ACCOUNT_NUM_5 A10 ACQ ACCOUNT NUM 5
TA390 ACQ_ACCOUNT_NUM_6 A10 ACQ ACCOUNT NUM 6
TA392 ACQ_ACCOUNT_NUM_7 A10 ACQ ACCOUNT NUM 7
TA394 ACQ_ACCOUNT_NUM_8 A10 ACQ ACCOUNT NUM 8
TA405 ACQ_DT YYMD DATE ACQ DT
TA410 ACQ_METHOD A2 ACQ METHOD
TA415 FUND_SOURCE_1 A2 FUND SOURCE 1
TA420 PCT_OF_FUNDS_1 A3 PCT OF FUNDS 1
TA425 FUND_SOURCE_2 A2 FUND SOURCE 2
TA430 PCT_OF_FUNDS_2 A3 PCT OF FUNDS 2
TA435 FUND_SOURCE_3 A2 FUND SOURCE 3
TA440 PCT_OF_FUNDS_3 A3 PCT OF FUNDS 3
TA445 FUND_SOURCE_4 A2 FUND SOURCE 4
TA450 PCT_OF_FUNDS_4 A3 PCT OF FUNDS 4
TA455 SPONSER_AGENCY A4 SPONSER AGENCY
TA460 PURPOSE_CODE_1 A2 PURPOSE CODE 1
TA465 PCT_PURPOSE_1 A3 PCT PURPOSE 1
TA470 PURPOSE_CODE_2 A2 PURPOSE CODE 2
TA475 PCT_PURPOSE_2 A3 PCT PURPOSE 2
TA480 PURPOSE_CODE_3 A2 PURPOSE CODE 3
TA485 PCT_PURPOSE_3 A3 PCT PURPOSE 3
TA490 PURPOSE_CODE_4 A2 PURPOSE CODE 4
TA495 PCT_PURPOSE_4 A3 PCT PURPOSE 4
TA500 DISP_METHOD A2 DISP METHOD
TA505 DISP_DT YYMD DATE DISP DT
TA510 DISP_NET_AMT D14.2 D7 DISP NET AMT
TA515 MFG_NAME A30 MFG NAME
TA520 MFG_MODEL_NUM A20 MFG MODEL NUM
TA525 SERIAL_NUM A20 SERIAL NUM
TA530 REPLACEMENT_COST D14.2 D7 REPLACEMENT COST
TA535 INSURER_CODE A4 INSURER CODE
TA540 INSURED_VALUE D14.2 D7 INSURED VALUE
TA545 VALUATION_DT YYMD DATE VALUATION DT
TA550 INFLATION_CODE A2 INFLATION CODE
TA555 COINSURANCE_PCT A2 COINSURANCE PCT
TA600 ASSET_CAMPUS_CODE A2 ASSET CAMPUS CODE
TD005_TDRT BLDG A5 BUILDING
TA610 ROOM_FLOOR A6 ROOM FLOOR
TA615 OTHER_LOCATION A20 OTHER LOCATION
TA620 EXECUTIVE_LEVEL A2 EXECUTIVE LEVEL
TA625 DIVISION_SL A2 DIVISION CUST
TA630 SCHOOL A2 SCHOOL
TA635 DEPARTMENT A5 DEPARTMENT
TA640 LAST_TRANSFER_DT YYMD DATE LAST TRANSFER DT
TA700 MAINT_COMPANY A30 MAINT COMPANY
TA705 MAINT_CNTRCT A20 MAINT CNTRCT
TA710 MAINT_RENEWAL_DT YYMD DATE MAINT RENEWAL DT
TA715 MAINT_CNTRCT_AMT D14.2 D7 MAINT CNTRCT AMT
TA720 MAINT_FREQUENCY A2 MAINT FREQUENCY
TA725 WARRANTY_EXPIRE_DT YYMD DATE WARRANTY EXPIRE DT
TA730 LAST_MAINTAINED_DT YYMD DATE LAST MAINTAINED DT
TT510_TTDP DEPR_METHOD A3 DEPR METHOD
TA805 USEFUL_LIFE I6 I2 USEFUL LIFE
TA810 REMAINING_LIFE I6 I2 REMAINING LIFE
TA815 SALVAGE_VALUE D14.2 D7 SALVAGE VALUE
TA820 FIRST_YR_RULE A1 FIRST YEAR RULE
TA825 DEPR_AMT_MANUAL D14.2 D7 DEPR AMT MANUAL
TA830 DEPR_FIRST_YR D14.2 D7 DEPR FIRST YR
TA835 DEPR_LAST_YR D14.2 D7 DEPR LAST YR
TA840 UNRECORDED_DEPR D14.2 D7 UNRECORDED DEPR
TA845 ACCUM_DEPR D14.2 D7 ACCUM DEPR
TA850 FRT_INS_TAX_OT_AMT D14.2 D7 FRT INS TAX OT AMT
TA855 LOCATION_INST_AMT D14.2 D7 LOCATION INSTL AMT
TA860 TOTAL_COST D14.2 D7 TOTAL COST
TA870 BASIS_YRS I6 I2 BASIS YRS
TA875 BASIS_AMT D14.2 D7 BASIS AMT
TA880 NUM_YRS_DEPR_FED I6 I2 NUM YRS DEPR FED
TA885 DEPR_FIRST_YR_CALC D14.2 D7 DEPR FIRST YR CALC
TA890 ACCUM_DEPR_CALC D14.2 D7 ACCUM DEPR CALC
TA895 DEPR_LAST_YR_CALC D14.2 D7 DEPR LAST YR CALC
TA900 NUM_YRS_DEPR_CALC I6 I2 NUM YRS DEPR CALC
TA926 CAPTLZTN_FISCAL_YR A4 CAPTLZTN FISCAL YR
TA95A UC_AMOUNT_1 D12.2 D6 UC AMOUNT 1
TA95B UC_AMOUNT_2 D12.2 D6 UC AMOUNT 2
TA95C UC_AMOUNT_3 D12.2 D6 UC AMOUNT 3
TA95D UC_AMOUNT_4 D12.2 D6 UC AMOUNT 4

 

508 UsableNet Approved (v. 1.2.1)