Description of Aptic Credit transaction importfile format - ICTXML version 1.0
Transaction import 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
Journals type - One per import journal. Preferrably used one journal per currency, though it is possible to used different currency per transaction.
3 chars ISO 4217 currency code
Reference code for creditor. If specified for journal, all transactions in this journal need to have the same creditor specified
Date when the journal is created
Some external reference or journal number. For tracing only
Comment from sending system. Information only
The sum of all debt transactions in this journal
The sum of all credit transactions in this journal
Transaction record.
Reference code for creditor. Must be the same a journal creditor if journal creditor is specified.
3 chars ISO 4217 currency code
Exchange rate to use for account adjustment transaction (if provided it will override exchange rate in ARC).
Exchange date to use for account adjustment transaction (if provided without exchange rate it will be used for fetching exchange rate in ARC).
Credit account number
Customer number/reference
Credit card number used for this transaction
Credit card holder
Total amount incl. VAT for this transaction
Date for this transaction
Document date when the actual invoice was created
Transaction type. 121 for payments and 120 for purchases (default)
Referencenumber for this transaction
Place of purchase if store isn't used
Price per item incl. vat.
Number of units of the items purchased
Units of item in clear text
Rounding amount for this transaction
Description of this transaction in clear text
The store that handled the purchase. This store must be in Aptic ARC
Receipt number of the purchase
Cash register number that handled the purchase
Invoicenumber from purchase processing system. Only stored as information in Aptic ARC.
External invoicenumber from purchase processing system. Only stored as information in Aptic ARC.
External payment reference from purchase processing system. Only stored as information in Aptic ARC.
Due date from purchase processing system. Only stored as information in Aptic ARC.
Payment condition from purchase processing system. Only stored as information in Aptic ARC.
Message from purchase processing system. Only stored as information in Aptic ARC.
Our order number from purchase processing system. Only stored as information in Aptic ARC.
Your order number from purchase processing system. Only stored as information in Aptic ARC.
Our reference contact from purchase processing system. Only stored as information in Aptic ARC.
Your reference contact from purchase processing system. Only stored as information in Aptic ARC.
Delivery method from purchase processing system. Only stored as information in Aptic ARC.
Delivery condition from purchase processing system. Only stored as information in Aptic ARC.
Delivery date from purchase processing system. Only stored as information in Aptic ARC.
Delivery number from purchase processing system. Only stored as information in Aptic ARC.
Print code to control printing of invoice.
Receiver full name
Receiver street
Receiver city
Receiver state code
Receiver zip code
Receiver country code - 2 chars ISO 3166-1 alpha-2
Receiver full address
True if row is a text information row only (without any amounts)
Row reference number
Invoice item number
Description / text
Debt fee code (e.g. INVOICECHARGE, PACKANDSHIP)
EAN article code
Order count
Delivered item count
Remaining item count
Units of item in clear text
Net price per item (excl. VAT)
Net price per item (excl. VAT) in G/L currency
Discounted amount
Total net amount on row (excl. VAT)
Total net amount on row (excl. VAT) in G/L currency
VAT amount
VAT amount in G/L currency
VAT code as defined in configuration table cfg_vattype (e.g. SE25, SE0)