Description of Aptic purchase reservation importfile format
Person
Company
Payment
Credit
Swedish Autogiro
Dutch Incasso
Dutch SEPA
Annuity
Flat
Invoice
Credit invoice
Interest invoice
Final invoice creditdebt
Ok
Denied
Pending
Only with regress
Reservations - 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 ledger 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
Reservation data.
Reservation id
Reservation status
Reference code for creditor. Must be the same a journal creditor if journal creditor is specified.
3 chars ISO 4217 currency code
Reference number
Customer number/reference
Code specifying delivery system - max 15 chars
Payment reference (OCR or KID number)
Service code - "Invoicing" or "ReceivableLdg"
Claimant name, if other than creditor
True if invoice should be loanable
Percentage of invoice to loan
True if invoice is purchasable (default) yes
Invoiced at date
Code specifying payment way
Print code
Form code
Receiver reference
True if invoice is an aconto/proforma incvoice (default=false)
Campaign code for customer accounts in system module Credit. Deprecated.
Pay this invoice by using revolving credit in system module Credit. Deprecated.
Payment product for purchase (controls how the purchase is to be handled within the system).
Data provisions, connected to reservation
Customer number/reference
Customer id number
Customer juridical type
Customer role
Place of birth
Date of birth
Gender
Culture code, e.g. en-GB, en-US, sv-SE
Customer title
First/company name
Middle name
Last name
Name suffix
Care of
Street
House number
House number extension
City
State code
Zip code
Full address in one field
Do not perform any checkups on the address, assume it's correct
Country code 2 chars ISO 3166-1 alpha-2
Country name
Domicile
Municipal code
VAT registration number
GLN - Global Location Number
LEI - Legal Entity Identifier
NACE classification code
Receiver identity for electronic invoicing
Home phone
Work phone
Cellular phone
Telefax
Email address
Language code
3 chars ISO 4217 currency code
Code for preferred channel
True if customer is underaged
Auto transfer reference number (obsolete, use autotransfer element instead)
Auto transfer bank account number (obsolete, use autotransfer element instead)
True if matching existing customer should be updated with new info
Data provisions, connected to customer
Debt principal type, default is invoice when amount >= 0 and credit invoice otherwise
Invoice description
Reference/invoice number
Original invoice number if this is a credit invoice
Payment reference
Ledger reference
Remaining calculated interest
Specified amount rounding (will be calculated from settings if not specified)
Specified amount rounding in G/L currency (will be calculated from settings if not specified)
3 chars ISO 4217 currency code
Exchange rate used
Order date
Bill date
Due date
Our order number
Your order number
Seller
Mark on delivered goods
Delivery method
Delivery condition
Delivery date
Delivery note id
Credit card transaction id
Message
Payment condition
Interest condition
Store reference
Receipt number
Cash register number
Interest rate
Interest code - as defined in configuration table cfg_interest
Interest from date
Intererest calculated to this date
Our reference (name)
Your reference (name)
Period of limitation - generally set from party parameters with 3 years as default for physical customers and 10 for juricial customers
Limitation date, normally calculated from period of limitaion and bill date
Receiver full name
Receiver street
Receiver house number
Receiver house number extension
Receiver city
Receiver state code
Receiver zip code
Receiver country code - 2 chars ISO 3166-1 alpha-2
Receiver full address
Delivery full name
Delivery street
Delivery house number
Delivery house number extension
Delivery city
Delivery state code
Delivery zip code
Delivery country code - 2 chars ISO 3166-1 alpha-2
Delivery full address
Any xml data specifying the invoice, not directly used by Aptic but stored for later use by for example letter exports
Row is not a real invoice row, just a summary row holding total principal and vat amount
True if row is a text information row only (without any amounts)
Row reference number
Invoice item number
Debt fee code (e.g. INVOICECHARGE, PACKANDSHIP)
Description / text
Call number
Call length
EAN article code
Order count
Delivered item count
Remaining item count
Unit type id as defined in configuration table cfg_unittype
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
Total net amount on row (incl. VAT)
Total net amount on row (incl. 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)
Account chart code
VAT account chart code
Account dimension 1
Account dimension 2
Account dimension 3
Account dimension 4
Account dimension 5
Account dimension 6
Account dimension 7
Account dimension 8
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
Fee amount (exkl. VAT)
Fee amount i G/L currency
Fee vat
Fee vat in G/L currency
Remaining interest amount
Exchange rate used
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
Address type; legal, avi or invoice
Address not valid from this date
Full name
Care of
Street
House number
House number extension
City
State code
Zip code
Full address in one field
Do not perform any checkups on the address, assume it's correct
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
Transactions aleady made to the invoice
Type of transaction
Transaction amount in invoice currency
Transaction amount in G/L currency
Transaction specification id
True (default) if accounting should be performed
Debit account chart code
Payment source. Only used if transaction type is 4
External payment reference. Only used if transaction type is 4
Paymentplan/installment of the invoice
Type of paymentplan
Date of first installment
No of installments
Monthly amount (calculated from periodcount if excluded)
Amount of first payment
Interest rate (default value from creditor if excluded)
Interest code as defined in configuration table cfg_interets (default value from creditor if excluded)
True (default) if paymentplan is approved
One time initial fee amount
Repeating period/notice fee amount
Existing direct debit setup for the customer
Type of auto transfer
Auto transfer reference number
Auto transfer bank account number
Date when auto transfer was requested
Date when auto transfer was approved
Date when auto transfer was signed
Date when auto transfer is valid from
Date when auto transfer is valid to
Extra fields specified in configuration table cfg_extrafield
Name of the extra field, defined in cfg_extrafield
Data contents of the extra field
Notes shown on ledger record
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
Claimant information if not the creditor
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 number
IBAN number
BIC code
Swift number
BLZ
Description
Countrycode
Currencycode
Bank code
Bank description
Information about data provisions
Dataprovision code
Version number of the dataprovision
Extra information regarding the data provision