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_ |
varchar2 |
Accumulated depreciation account | |||
ACCT_ |
varchar2 |
Depreciation expense account | |||
ACCT_ |
varchar2 |
Asset account | |||
ACCT_ |
varchar2 |
Revaluation account | |||
ACCT_ |
varchar2 |
Sales account | |||
AMT_ |
int64 |
Sales value | |||
CAMT_ |
decimal |
Cumulative total | |||
CAMT_ |
int64 |
Depreciation amount current year | |||
CAMT_ |
int64 |
Depreciated up to prior year | |||
CAMT_ |
int64 |
Acquisition value | |||
CAMT_ |
int64 |
Residual value | |||
CBOOK_ |
int64 |
Book value opening balance | |||
CBOOK_ |
int64 |
Book value | |||
CDEP_ |
varchar2 |
Depreciation method | |||
CNG_ |
datetime |
Datum van wijziging | |||
CNG_NR |
int32 |
Nummer wijzigen | |||
CNG_ |
varchar2 |
Employee last modified | |||
COMMENT1 |
varchar2 |
Remark | |||
COST_ |
varchar2 |
Cost centre code | |||
COST_ |
varchar2 |
Asset location | |||
COV_ |
int64 |
Insured amount | |||
COZB_ |
varchar2 |
Property tax group | |||
CTERM_ |
int32 |
Depreciation periods current year | |||
CTERM_ |
int32 |
Depreciated periods up to prior year | |||
DATE_ |
datetime |
Date taken out of use | |||
DATE_ |
datetime |
Aankoopdatum | |||
DATE_ |
datetime |
Sales date | |||
FA_ |
varchar2 |
Asset code | |||
FA_ |
varchar2 |
Asset description | |||
FA_GRP |
varchar2 |
Asset group code | |||
FAMT_ |
decimal |
Cumulative total (tax) | |||
FAMT_ |
int64 |
Depreciation amount current year (tax) | |||
FAMT_ |
int64 |
Depreciated up to prior year (tax) | |||
FAMT_ |
int64 |
Acquisition value (tax) | |||
FAMT_ |
int64 |
Residual value (tax) | |||
FBOOK_ |
int64 |
Book value opening balance (tax) | |||
FBOOK_ |
int64 |
Book value (tax) | |||
FDEP_ |
varchar2 |
Depreciation method (tax) | |||
FOZB_ |
varchar2 |
Property tax group (tax) | |||
FTERM_ |
int32 |
Depreciation periods current year (tax) | |||
FTERM_ |
int32 |
Depreciated periods up to prior year (tax) | |||
IMG_ |
varchar2 |
Image | |||
INP_ |
datetime |
Datum van inschrijving | |||
INP_ |
varchar2 |
Entered by employee | |||
INS_ |
int64 |
Premium | |||
INS_ |
datetime |
Insured until | |||
INS_JN |
char |
Insured | |||
INS_NR |
varchar2 |
Policy number | |||
INS_ |
datetime |
Insurance start date | |||
INS_ |
varchar2 |
Insurer | |||
PARENT_ |
varchar2 |
Main asset | |||
PART_ |
varchar2 |
Partner | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PER_ |
int32 |
Period out of use | |||
PER_ |
int32 |
Acquisition period | |||
PER_ |
int32 |
Sales period | |||
SERIAL_ |
varchar2 |
Serienummer | |||
VCAMT_ |
int64 |
Depreciated up to PY (import) | |||
VCAMT_ |
int64 |
Acquisition value (import) | |||
VCAMT_ |
int64 |
Residual value (import) | |||
VCAMT_ |
int64 |
Subsidy (import) | |||
VCTERM_ |
int32 |
Depreciated periods up to PY (import) | |||
VFAMT_ |
int64 |
Depreciated up to PY (tax) (import) | |||
VFAMT_ |
int64 |
Acquisition value (tax) (import) | |||
VFAMT_ |
int64 |
Residual value (tax) (import) | |||
VFAMT_ |
int64 |
Subsidy (tax) (import) | |||
VFTERM_ |
int32 |
Depreciated periods up to PY (tax) (import) | |||
VTRN_ |
datetime |
Acquisition date (import) | |||
VTRN_ |
int32 |
Acquisition period (import) | |||
YEAR_ |
int32 |
Year out of use | |||
YEAR_ |
int32 |
Acquisition year | |||
YEAR_ |
int32 |
Sales year |