Exact Financials

 

Connectivity Manual - IFALL - Fixed assets

Fixed assets

As of version 3.31 fixed assets can be imported using the Exact Data Interface System.

The table below documents the fields available in application 'EXACT'. To use this functionality you need to update your EDIS script (see document 01.603.947).

Asset master data - FAS_AST
Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	MASTER_ASSET_ID	Character	8	fas_mast	Asset set	-
3	ASSET_CODE	Character	12	-	Asset	-
4	EUSERID	Character	12	euser	Owner	-
5	CURR_CODE	Character	3	curren	Currency	-
6	CREDITOR	Integer	8	credit	Creditor	-
7	UNITS_OF_PROD	Integer	7	-	Units of production	-
8	COST_CENTER	Character	8	ccent	Cost center	-
9	COST_UNIT	Character	8	cunit	Cost unit	-
10	DESCR	Character	30	-	Description	-
11	AMT_CURR_PURCHASE	Decimal	17	-	Purchase price	-
12	QTY_ACTUAL	Decimal	12	-	Actual quantity	-
13	STATE	Integer	6	1	Status	-
14	DEPARTMENT_CODE	Character	8	fas_dept	Department	-
15	ASSET_TYPE	Integer	6	2	Type	-
16	DATE_PURCHASE	Date	8	-	Date of purchase	-
17	RECEIPT_NR	Character	8	-	Receipt number	-
18	INSURED_VALUE	Decimal	17	-	Insured value	-
19	AMT_SUBSIDY	Decimal	17	-	Subsidy amount	-
20	LOCATION_CODE	Character	8	fas_loc	Location	-
21	DATE_SERVICE	Date	8	-	Date placed in service	-
22	NOTE	Character	1000	-	Note	-
Asset depreciation data - FAS_DEPR
Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	ASSET_CODE	Character	12	fas_ast	Asset	-
3	ASSET_BOOK	Character	8	fas_book	Asset book	-
4	FIN_YR_FIRST_DEPR	Integer	4	-	Year first depreciation	-
5	PERIOD_FIRST_DEPR	Integer	3	-	Period first depreciation	-
6	LIFE_YR	Integer	3	-	Life years	-
7	LIFE_PER	Integer	3	-	Life periods	-
8	ACT_BASE_AMT_CURR	Decimal	17	-	Base amount	-
9	ACT_SALVAGE_VALUE_CURR	Decimal	17	-	Salvage value	-
10	ACT_AMT_CURR_CUM	Decimal	17	-	Amount depreciated	-
11	ORG_PER_DEPR	Integer	6	-	Periods depreciated	-
12	AMT_CURR_FIRST_DEPR	Decimal	17	-	Amount first depreciation	-

1. 1: initiated
   2: active
   4: sold
   6: revaluated
   9: compressed
   10: partially initiated
2. 1: parent asset
   2: normal asset

---

Connectivity Manual > Contents > IFALL > Fixed assets > Fixed assets

---

     

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security  level:	All - 0
Sub category:	Details	Document ID:	18.330.010
Assortment:	Exact Financials	Date:	03-12-2008
Release:		Attachment:
Disclaimer