invantive documentation
Invantive Support ForumsLog In / Sign Up

DepreciationMethodsEx: Exact Online Depreciation Methods

insert update per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Primary Keys: code_attr
  • Label: Depreciation Methods

The data in this table is partitioned per value of the Division column.

Can retrieve data and change data using insert and update.

Summary

Additional where-clause columns supported:

  • division
  • downloadid
  • code

API Source

  • XML service: DepreciationMethods
  • XML topic: DepreciationMethods
  • XML path: /

Parameters

Name Data Type Required Default Documentation
division int32 Company code.
Params_Code varchar2 Code.
Params_DownloadID varchar2 Data subscription token.

Table Columns

The columns of the table DepreciationMethodsEx are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
AMOUNT number Amount /eExact/DepreciationMethods/DepreciationMethod/Amount/ Amount for methods: 21 - Fixed Amount On import: Can not be modified if depreciation method is already linked to an asset.
CODE_ATTR varchar2 Code /eExact/DepreciationMethods/DepreciationMethod/code
COUNTRY_CODE_ATTR varchar2 Country Code /eExact/DepreciationMethods/DepreciationMethod/Country/code
COUNTRY_DESCRIPTION varchar2(255) Country Description /eExact/DepreciationMethods/DepreciationMethod/Country/Description/
COUNTRY_DESCRIPTION_TERMID_ATTR number Country Description Term ID /eExact/DepreciationMethods/DepreciationMethod/Country/Description/termid
DEPRECIATIONINTERVAL varchar2 Depreciation Interval /eExact/DepreciationMethods/DepreciationMethod/DepreciationInterval/
DESCRIPTION varchar2(255) Description /eExact/DepreciationMethods/DepreciationMethod/Description/
DESCRIPTION_TERMID_ATTR number Description Term ID /eExact/DepreciationMethods/DepreciationMethod/Description/termid
DIVISION_CODE varchar2 Administration ID Internal unique number of the Exact Online administration.
DIVISION_HID int64 Administration Number of the Exact Online administration. Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administration Name Name of the Exact Online administration. Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with Exact Online.
MAXPERCENTAGE number Maximum Percentage /eExact/DepreciationMethods/DepreciationMethod/MaxPercentage/ The percentage as a number from -1 to 1, for example 0.19 = 19%
PERCENTAGE number Percentage /eExact/DepreciationMethods/DepreciationMethod/Percentage/
PERCENTAGE2 number Percentage 2 /eExact/DepreciationMethods/DepreciationMethod/Percentage2/ The percentage as a number from -1 to 1, for example 0.19 = 19%
PERIODS number Periods /eExact/DepreciationMethods/DepreciationMethod/Periods/ Number of periods for methods: 1 - Linear depreciation, 2 - Linear (until residual value), 30 - Sum of the year digits (fixed decr. amt), 40 - Normal annuity method, On import: Can not be modified if depreciation method is already linked to an asset.
ROWNUM int64 Row Number Number of the row within the results, starting at 1.
TYPE varchar2 Type /eExact/DepreciationMethods/DepreciationMethod/Type/ Values: 1 - Linear depreciation, 2 - Linear (until residual value), 4 - No depreciation, 10 - Degressive to linear, 11 - Degressive (fixed perc. of book value), 21 - Fixed Amount, 30 - Sum of the year digits (fixed decr. amt), 40 - Normal annuity method, 3 - Linear depreciation (Belgium only), 12 - Degressive to linear (Belgium only). On import: Can not be modified if depreciation method is already linked to an asset.
YEARS number Years /eExact/DepreciationMethods/DepreciationMethod/Years/ Number of years for methods: 1 - Linear depreciation, 2 - Linear (until residual value), 30 - Sum of the year digits (fixed decr. amt), 40 - Normal annuity method, 3 - Linear depreciation (Belgium only). On import: Can not be modified if depreciation method is already linked to an asset.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: