# FA_HDR: Fixed assets - Name: `FA_HDR` - Catalog: `AccountView` - Label: Fixed assets - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `FA_HDR` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_CD` | `string(10)` | Accumulated depreciation account | ☐ | | | `ACCT_DE` | `string(10)` | Depreciation expense account | ☐ | | | `ACCT_FA` | `string(10)` | Asset account | ☐ | | | `ACCT_REV` | `string(10)` | Revaluation account | ☐ | | | `ACCT_SELL` | `string(10)` | Sales account | ☐ | | | `AMT_SELL` | `int64` | Sales value | ☐ | | | `CAMT_CUM` | `decimal` | Cumulative total | ☐ | | | `CAMT_CYR` | `int64` | Depreciation amount current year | ☐ | | | `CAMT_LYR` | `int64` | Depreciated up to prior year | ☐ | | | `CAMT_PCHS` | `int64` | Acquisition value | ☐ | | | `CAMT_REM` | `int64` | Residual value | ☐ | | | `CBOOK_BEG` | `int64` | Book value opening balance | ☐ | | | `CBOOK_VAL` | `int64` | Book value | ☐ | | | `CDEP_METH` | `string(10)` | Depreciation method | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COMMENT1` | `string(40)` | Remark | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `COST_ORIG` | `string(25)` | Asset location | ☐ | | | `COV_AMT` | `int64` | Insured amount | ☐ | | | `COZB_GRP` | `string(10)` | Property tax group | ☐ | | | `CTERM_CYR` | `int32` | Depreciation periods current year | ☐ | | | `CTERM_LYR` | `int32` | Depreciated periods up to prior year | ☐ | | | `DATE_OUT` | `datetime` | Date taken out of use | ☐ | | | `DATE_PCHS` | `datetime` | Purchase date | ☐ | | | `DATE_STOP` | `datetime` | Sales date | ☐ | | | `FA_CODE` | `string(10)` | Asset code | ☐ | | | `FA_DESC` | `string(40)` | Asset description | ☐ | | | `FA_GRP` | `string(10)` | Asset group code | ☐ | | | `FAMT_CUM` | `decimal` | Cumulative total (tax) | ☐ | | | `FAMT_CYR` | `int64` | Depreciation amount current year (tax) | ☐ | | | `FAMT_LYR` | `int64` | Depreciated up to prior year (tax) | ☐ | | | `FAMT_PCHS` | `int64` | Acquisition value (tax) | ☐ | | | `FAMT_REM` | `int64` | Residual value (tax) | ☐ | | | `FBOOK_BEG` | `int64` | Book value opening balance (tax) | ☐ | | | `FBOOK_VAL` | `int64` | Book value (tax) | ☐ | | | `FDEP_METH` | `string(10)` | Depreciation method (tax) | ☐ | | | `FOZB_GRP` | `string(10)` | Property tax group (tax) | ☐ | | | `FTERM_CYR` | `int32` | Depreciation periods current year (tax) | ☐ | | | `FTERM_LYR` | `int32` | Depreciated periods up to prior year (tax) | ☐ | | | `IMG_FILE` | `string(4)` | Image | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `INS_AMT` | `int64` | Premium | ☐ | | | `INS_END` | `datetime` | Insured until | ☐ | | | `INS_JN` | `boolean` | Insured | ☐ | | | `INS_NR` | `string(40)` | Policy number | ☐ | | | `INS_START` | `datetime` | Insurance start date | ☐ | | | `INS_SUB` | `string(10)` | Insurer | ☐ | | | `PARENT_ID` | `string(10)` | Main asset | ☐ | | | `PART_CODE` | `string(10)` | Partner | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PER_OUT` | `int32` | Period out of use | ☐ | | | `PER_PCHS` | `int32` | Acquisition period | ☐ | | | `PER_SELL` | `int32` | Sales period | ☐ | | | `SERIAL_NR` | `string(20)` | Serial number | ☐ | | | `VCAMT_LYR` | `int64` | Depreciated up to PY (import) | ☐ | | | `VCAMT_PCHS` | `int64` | Acquisition value (import) | ☐ | | | `VCAMT_REM` | `int64` | Residual value (import) | ☐ | | | `VCAMT_SUBS` | `int64` | Subsidy (import) | ☐ | | | `VCTERM_LYR` | `int32` | Depreciated periods up to PY (import) | ☐ | | | `VFAMT_LYR` | `int64` | Depreciated up to PY (tax) (import) | ☐ | | | `VFAMT_PCHS` | `int64` | Acquisition value (tax) (import) | ☐ | | | `VFAMT_REM` | `int64` | Residual value (tax) (import) | ☐ | | | `VFAMT_SUBS` | `int64` | Subsidy (tax) (import) | ☐ | | | `VFTERM_LYR` | `int32` | Depreciated periods up to PY (tax) (import) | ☐ | | | `VTRN_DATE` | `datetime` | Acquisition date (import) | ☐ | | | `VTRN_PER` | `int32` | Acquisition period (import) | ☐ | | | `YEAR_OUT` | `int32` | Year out of use | ☐ | | | `YEAR_PCHS` | `int32` | Acquisition year | ☐ | | | `YEAR_SELL` | `int32` | Sales year | ☐ | |