TDFILE: FIXED ASSET BUILDING FILE

ElementElement NameTable or FileSQL or Focus
TD001BUILDING KEYTDFILEBLDG_KEY
TD005BUILDING NUMBERTDFILEBLDG_NUM
TD010DROP FLAGTDFILEDROP_FLAG
TD015DELETE FLAGTDFILEDELETE_FLAG
TD025LAST ACTIVITYTDFILEDT_LAST_ACTV
TD026LAST ACTIVITY-6TDFILEDT_LAST_ACTV_6
TD030BLDG NAME LINE 1TDFILEBLDG_NAME
TD035BLDG NAME LINE 2TDFILEBLDG_NAME_2
TD040LOCATIONTDFILELOCATION
TD045CONSTRUCTION TYPETDFILEBLDG_CONSTRUCT_TYP
TD050CONDITIONTDFILEBLDG_CONDITION
TD055STRUCTURAL OBSOLETETDFILESTRUCT_OBSOLETE
TD060FUNCTIONAL OBSOLETETDFILEOBSOLESCENCE
TD065DATE CONSTRUCTEDTDFILEDT_CONSTRUCTED
TD066DATE CONSTRUCTED-6TDFILEDT_CONSTRUCTED_6
TD070FIRST OCCUPY DATETDFILEINIT_OCCUPIED_DT
TD071FIRST OCCUPY DATE-6TDFILEINIT_OCCUPIED_DT_6
TD075PRIMARY FUNCTIONTDFILEPRIMARY_FUNCTION
TD080OTHER LOCATIONTDFILEOTHER_LOCATION
TD090PURPOSE CODE 1TDFILEPURPOSE_CODE_1
TD095PURPOSE PERCENT 1TDFILEPCT_PURPOSE_1
TD100PURPOSE CODE 2TDFILEPURPOSE_CODE_2
TD105PURPOSE PERCENT 2TDFILEPCT_PURPOSE_2
TD110PURPOSE CODE 3TDFILEPURPOSE_CODE_3
TD115PURPOSE PERCENT 3TDFILEPCT_PURPOSE_3
TD120PURPOSE CODE 4TDFILEPURPOSE_CODE_4
TD125PURPOSE PERCENT 4TDFILEPCT_PURPOSE_4
TD130OWNERSHIP/TITLETDFILETITLE_OWNERSHIP
TD135TITLE REFERENCETDFILETITLE_REF
TD140TITLE RECORDED ATTDFILEWHERE_RECORDED
TD145TITLE DATETDFILEDT_TITLE_RECORDED
TD146TITLE DATE-6TDFILEDT_TITLE_RECORDED_
TD150FINANCE METHODTDFILEFINANCE_METHOD
TD155COINSURANCE PERCENTTDFILECOINSURANCE_PCT
TD160REPLACEMENT COSTTDFILEREPLACEMENT_COST
TD165APPRAISED VALUETDFILEAPPRAISED_VALUE
TD170APPRAISED BYTDFILEAPPRAISED_BY
TD175APPRAISED DATETDFILEAPPRAISED_DT
TD176APPRAISED DATE-6TDFILEAPPRAISED_DT_6
TD180OPTIMUM CAPACITYTDFILEOPTIMUM_CAPACITY
TD185AREA UNIT OF MEASTDFILEAREA_UOM
TD190GROSS AREATDFILEGROSS_AREA
TD195PUBLIC AREATDFILEPUBLIC_AREA
TD200USABLE AREATDFILEUSABLE_AREA
TD205REVENUE PROD AREATDFILEREVENUE_PROD_AREA
TD901FMAN BUILDING NUMTDFILEFMAN_BUILDING_NUM
TD902BLDG INS NUMBERTDFILEBLDG_INS_NUMBER

©2000 All Rights Reserved