invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

FA_HDR: AccountView Fixed assets

read only per partition

  • Catalogus: AccountView
  • Label: Fixed assets

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel FA_HDR worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
ACCT_CD varchar2(10) Accumulated depreciation account
ACCT_DE varchar2(10) Depreciation expense account
ACCT_FA varchar2(10) Asset account
ACCT_REV varchar2(10) Revaluation account
ACCT_SELL varchar2(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 varchar2(10) Depreciation method
CNG_DATE datetime Datum van wijziging
CNG_NR int32 Nummer wijzigen
CNG_USR varchar2(20) Employee last modified
COMMENT1 varchar2(40) Remark
COST_CODE varchar2(10) Cost centre code
COST_ORIG varchar2(25) Asset location
COV_AMT int64 Insured amount
COZB_GRP varchar2(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 Aankoopdatum
DATE_STOP datetime Sales date
FA_CODE varchar2(10) Asset code
FA_DESC varchar2(40) Asset description
FA_GRP varchar2(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 varchar2(10) Depreciation method (tax)
FOZB_GRP varchar2(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 varchar2(4) Image
INP_DATE datetime Datum van inschrijving
INP_USR varchar2(20) Entered by employee
INS_AMT int64 Premium
INS_END datetime Insured until
INS_JN char Insured
INS_NR varchar2(40) Policy number
INS_START datetime Insurance start date
INS_SUB varchar2(10) Insurer
PARENT_ID varchar2(10) Main asset
PART_CODE varchar2(10) Partner
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PER_OUT int32 Period out of use
PER_PCHS int32 Acquisition period
PER_SELL int32 Sales period
SERIAL_NR varchar2(20) Serienummer
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