Description of Aptic collection account importfile format - ICAXML version 2.1
Person
Company
Collection case
Journal case
The percent type specifies a percentage from 0 to 100.
Solicitor (internal)
Creditor (external)
Debtor (external)
No
Allow payments
Allow nettings
Accounts type - document root
"counterkey" and "countervalue" are used as an option file counter to ensure that files are imported in correct order and not skipped.
"counterkey" is the chosen name of the counter for this import. It is possible to share between differen import files
by using the same name. "countervalue" is the expected counter value that the system should have after increasing the last
value by one. If it is the first time a counter key is used, the counter value will be used to initialize the counter.
If the expected counter values does not match up with the saved value, the import will fail.
Saved in log but not used otherwise
Saved in log but not used otherwise
TypeCode of party that exports the data
ID of party that exports the data
Journals type - One per import journal. Preferrably used one journal per currency, though it is possible to used different currency per collection account.
3 chars ISO 4217 currency code
Reference code for creditor. If specified for journal, all accounts in this journal need to have the same creditor specified
Portfolio reference number
Reference for the journal. Can be used for identifying a specific journal. The field might not be unique.
Collection account (case) record.
Unique id for referenceing
Type of collection account. Collection case is default.
Reference code for creditor. Must be the same as journal creditor if journal creditor is specified.
Reference code for creditor claim type. This must match a defined claim type on the creditor.
3 chars ISO 4217 currency code
Reference number for the collecion account
Code used to identify the delivering system
Description of the case
Previous used payment reference number
Service code eg. "Inkasso"
Claimant name, if not the creditor
User code for preferred collector
Who we received the case from
Who received the case
Reference code for legal claim type.
Base amount for fee tariff calculation (if it differs from principal amount)
Defines if paid interest will be reported
Defines date from which paid interest will be reported
Data provisions, connected to account
Debtor id number
Debtor juridical type
Debtor role
The creditors customer number on debtor
Place of birth
Birth date
Debtor title
First/company name
Middle name
Infix
Last name
Initials
Name suffix
Care of
Street
House number
House number extension
City
State code
Zip code
Country code 2 chars ISO 3166-1 alpha-2
Country name
Domicile
Municipal code
The date when the address becomes active. Empty value: restriction is not set (if it exists in system, it will be removed).
The date after which the address becomes inactive. Empty value: restriction is not set (if it exists in system, it will be removed).
Home phone
Work phone
Cellular phone
Telefax
Email address
Alternative e-mail address
NACE classification code
Language code
3 chars ISO 4217 currency code
True if debtor is underaged
True if debtor has protected identity
Auto transfer reference number
Auto transfer bank account number
Gender, male = true, female = false
Culture code, e.g. en-GB, en-US, sv-SE
the company type. e.g. AB, HB, Ltd, etc.
Period of limitation - generally set from party parameters with 3 years as default for physical debtors and 10 for juricial debtors
Signal whether person wants digital letters (defaults to true)
Data provisions, connected to debtor
Information about the deceased
Information about bankruptcy
Tax for refund purpose
Type of party issuing the tax
Reference number of party issuing the tax
Tax code, corresponds to cfg_taxtype.taxtypecodeg
The original tax amount paid to authorities
Date when the tax was created
Claimable tax amount already received by client
Tax amount that is not claimable
Note field
Unique id for referenceing
Registration date of debt, default value is the current date that the account is imported.
Invoice description
Reference/invoice number
Debt group code
Overrides account reference in type account_type
Ledger reference
Old account reference
Original principal
Remaining principal
Original interest
Remaining calculated interest
Penalty interest
3 chars ISO 4217 currency code
Exchange rate to use if debt contains a different currency then ledger currency
Exchange date if debt contains a different currency then ledger currency
Bill date
Due date
Payment condition
Interest condition
Interest rate
Interest code - as defined in configuration table cfg_interest
Interest from date
Intererest calculated to this date
Interest stop
Penalty interest rate
Penalty interest code - as defined in configuration table cfg_interest
Penalty interest from date
Penalty intererest calculated to this date
Turn om advanced interest calculation
Period of limitation for interest
Our reference (name)
Your reference (name)
Period of limitation - A debt specific period of limitation, like for a promissory note
Obsolite from 6.2. Limitation date, normally calculated from period of limitaion and bill date
Fixed Interest Term Start
Paid interest
Cut-off date for specific interest calculation
Specific interest code - as defined in configuration table cfg_interest_specificcalcualtiontype
Date for the agreement
Date for when the agreement due date
End date for the agreement
The original effective interest rate, this is only an information field and should not be included in any calculations
Interest information
Tax for refund purpose
Enforceable debt type code - as defined in configuration table cfg_enforceabledebttype
Presents the effective year of the debt
Debt principal type
Original interest
Paid interest
Remaining calculated interest
Interest rate
Interest code - as defined in configuration table cfg_interest
Interest from date
Intererest calculated to this date
Fixed Interest Term Start
Unique id for referenceing
Name of fee - max 50 chars, as defined in fee configuration table cfg_fee
Description - max 50 chars, taken from fee configuration if not specified
Fee date, default value is the current date.
Fee amount (exkl. VAT)
Fee vat
Remaining interest amount
3 chars ISO 4217 currency code
Interest rate
Interest code as defined in configuration table cfg_interets
Interest from date
Interest calculated to this date
Semicolon separated references are equal the 'referencenumber' of debt elements
Date when fee becomes active
Address type: legal, avi, invoice, site, OBJECT or templegal.
Address not valid from this date
Full name
Care of
Street
House number
House number extension
City
State code
Zip code
Country code - 2 chars ISO 3166-1 alpha-2
Country
True if this is the default address
True if existing matching address should be update with new data
True if this address should be considered to be account specific. This address cannot be legal address.
The date when the address becomes active. Empty value: restriction is not set (if it exists in system, it will be removed).
The date after which the address becomes inactive. Empty value: restriction is not set (if it exists in system, it will be removed).
Extra fields specified in configuration table cfg_extrafield
Name of the extra field, defined in cfg_extrafield
Data contents of the extra field
Rental objects attached to the collection account
Object number/reference
Type of rental object
Rental object description. See also property description.
Description of the rental property
The area of the rental property in square meters
The number of rooms in the rental property
Street address of the rental object
House number
House number extension
Address city of the rental object
Address zipcode of the rental object
Country code of the rental object
Date of notice
Evict date
Serving date
Moving date
Energy debt information on collection account
Should the consumer be disconnected
Has the consumer moved
Installation identity description
Power net owner reference number
Serving date
Has the consumer already been disconnected
Disconnection date
Street of facility
House number
House number extension
Zip code of facility
City of facility
Disconnection week
Disconnection year
Contract information on collection account
Contract number
Contract length in months
Start date of the contract
End date of the contract
Description / type of service for this contract
The value of the contract's related object
Termination date of the contract
Reason for the termination (customer specific)
Free text note
Contract document
Pledge information for this collection account
Type of pledge (not needed as the choice of extra information determines type)
Reference or identification number for pledge
If 'true' then all pledges with the same referencenumber is treated as the same pledge
Pledge date
Pledge amount
Description of the pledge
Notes for this pledge
Personal number for guarantor in debtor-element
Full guarantee information
Guarantee information
Mortgage companies information
Movable property information
Real property information
Seizure information
Full guarantee information
Guarantee type
Id number of debtor that this pledge is a general guarantee for
Guarantee information
Guarantee type
Guarantee principal amount, Pledge amount is used if not specified
Guarantee interest amount
Guarantee valid until
Guarantee currency
Remaining principal amount in guarantee
Id number of debtor that this pledge is a general guarantee for
Guarantee interest amount
Interest calulated from date
Interest type code
Interest rate
Remaining interest amount in guarantee
Interest calulated to date
Sets of interests for guarantee
Remaining interest amount in guarantee
Interest rate
Interest type code
Interest calulated from date
Interest calulated to date
Id number of debtor that this pledge is a general guarantee for
Mortgage companies information
Pre defined collateral code
Mortgage companies from amount (obsolite, use mortgagelienpriorities instead)
Mortgage companies to amount (obsolite, use mortgagelienpriorities instead)
All known mortgage lien priorities
Movable property information
Pre defined collateral code
Movable property type
Value amount
Valued at
Valued by
All known mortgage lien priorities
Real property information
Pre defined collateral code
Estate type
Real estate identification
Mortgage companies from amount (obsolite, use mortgagelienpriorities instead)
Mortgage companies to amount (obsolite, use mortgagelienpriorities instead)
Tax value amount
Value amount
Valued at
Valued by
All known mortgage lien priorities
Seizure information
Description of collateral
Type of collateral
Expiration date
Value amount
Valued at
Valued by
Percentage of ownership for the current real property.
Notes shown on collection account
Note text
Note time stamp
System code
User code
Important note = true
System specific owner type id. Only used for migration purpose
System specific note type id. Only used for migration purpose
Information for booking a system action
User code to book action for
User group code to book action for
Priority of message. Default is 100
Message text for collector
Claimant information
Claimants reference number, eg. creditor's client number
Claimants organisation id number
Name of claimant
Address street of claimant
House number
House number extension
Address city of claimant
Address zipcode of claimant
Address state code of claimant
Country code of claimant
Country of claimant
Claimant language code
Claimant phone number
Claimant internal phone number
Claimant fax number
Claimant email
Claimant preferred currency
Bank account information
Bank account owner
Allow to book payments / nettings against bank account
Allow to create disbursements from bankaccount
Allow to create disbursements to bankaccount
Decides if bankaccount should be used as a business account
Id must match cfg_bankaccountclass
Description
Countrycode
Currencycode
Bank account number
Bank code
Bank description
Default bankaccount account, only one default bank account per debtor is allowed
Documents on collection case, like the original invoice
Textual note/description regarding the document
Type of document
Time stamp when the document was produced
Original file name
Base64 encoded file contents
Link to an external repository
Information about data provisions
Dataprovision code
Version number of the dataprovision
Extra information regarding the data provision
Create an object link to the creditor
XML-standart date or empty string.