Skip to main content

Accepted values in ERP files

The exact values and formats Afakto accepts for identifiers, item types, payment methods, countries, currencies, dates and amounts.

Some columns of the buyers, receivables and client journal files only accept a fixed list of values. Enter them exactly as shown below.

Buyer identifier type (ID_TYPE)

Value

Use it for

SIREN

French company identifier (9 digits)

SIRET

French establishment identifier (14 digits)

VAT

Intra-community VAT number for EU buyers

COMMERCIAL_REGISTER

Commercial register number

DUNS_BRADSTREET

D-U-N-S number

NATIONAL_REGISTRATION_NUMBER or NRN or any code from the list below (*)

Other national registration number

ID_NUMBER must match the selected type. For example, a VAT number when ID_TYPE is VAT or a Siret when ID_TYPE is SIRET.

*List of other accepted codes for National Registration Number

  • AL: NIPT

  • AR: CUIT

  • AT: FN

  • BA: RNBA

  • BF: RNBF

  • BG: BULSTAT

  • BI: RNBI

  • BJ: RNBJ

  • BO: NITBO

  • BR: CNPJ

  • BY: INNBY

  • CD: RNCD

  • CE: RCEE (or RCEE)

  • CF: RNCF

  • CG: RNCG

  • CH: COCCHE

  • CI: RNCI

  • CL: RUTCL

  • CM: RNCM

  • CN: USCC

  • CO: NITCO

  • CR: CEDULA

  • CY: RNCY

  • CZ: ICO

  • DJ: RNDJ

  • DO: REGFISC

  • DZ: RNDZ

  • EC: RUCEC

  • EG: RNEG

  • ES: (no code)

  • EE: RCEE

  • FO: RNFO

  • GA: RNGA

  • GI: CNGI

  • GL: GERNO

  • GN: RNGN

  • GQ: RNGQ

  • GT: CIT

  • GU: RNGU

  • GW: RNGW

  • HK: RNHK

  • HN: RTN

  • HR: OIB

  • HU: RNHU

  • IE: CNIE

  • IL: RNIL

  • IN: RNIN

  • IS: RNIS

  • IT: COFIS

  • JP: CRJP

  • KR: RNKR

  • KW: CRNOKW

  • LI: DELTA

  • LT: RCLT

  • LU: RCLU

  • LV: RCLV

  • MA: RNMA

  • MD: IDNOMD

  • ME: RNME

  • MG: RNMG

  • MK: RNMK

  • ML: RNML

  • MO: RNMO

  • MR: RNMR

  • MT: CNMT

  • MX: RFC

  • NE: RNNE

  • NI: RUCNI

  • NL: KVK

  • NO: RNNO

  • NZ: RNNZ

  • OM: CRNOOM

  • PA: RUCPA

  • PE: RUCPE

  • PF: PFNUM

  • PH: PHI

  • PY: RUC

  • QA: CRNOQA

  • RU: OGRN

  • RW: RNRW

  • SA: CRNOSA

  • SE: RNSE

  • SG: PASS

  • SK: ICOSK

  • SM: COESM

  • SN: RNSN

  • SV: NITSV

  • TD: RNTD

  • TG: RNTG

  • TH: THA

  • TN: RNTN

  • TR: TAXTR

  • TW: RNTW

  • UA: OKPOUA

  • US: EIN

  • UY: RUTUY

  • VE: RIF

  • YT: YTNUM

  • ZA: RNZA

Item type (INV_TYPE)

Value

Use it for

INVOICE

Invoices, entered with positive amount

other accepted values

Facture client, Facture, FAC, 01

CREDIT_NOTE

Credit notes, entered with a negative amount

other accepted values

Note de crédit avoir client, Credit memo, Avoir, AVF, 21

PAYMENT

Payments, including unallocated payments.

Can be positive or negative

other accepted values

Payment not allocated, Unallocated payment, Unallocated, Check, Paiement, Paiement non alloué, Règlement client, Règlement, Advance, Impayé, Règlement factor, Paiement factor, Factor payment, BQ_FACTOR, 06, 22

OTHER

Any adjustments or other accounting item.

Can be positive or negative

Payment method (PAYMENT_METHOD)

Value

Meaning

BANK_TRANSFER

Bank transfer. Recommanded default value

BANK_CHECK

Cheque

BAO

Billet à ordre (promissory note)

DRAFT

Accepted bill of exchange

DRAFT_NOT_ACCEPTED

Bill of exchange not accepted

POSTAL_TRANSFER

Postal transfer

OTHERS

Any other method

Countries and currencies

  • ADDRESS_COUNTRY: 2-letter ISO country code (recommended). For example, FR for France or AU for Australia.

    You can also use the 3-letter ISO code (FRA) or the country name in English or French (France, Germany, Allemagne). If the country isn't recognized, the buyer is still imported without a country. The line appears in the import errors with the note "country dropped, buyer kept", so you can correct it.

  • ADDRESS_STATE: only for buyers located in the United States or Canada. For example CA for California, QC for Quebec.

  • CURRENCY: ISO 3-letter code. For example EUR, USD, GBP.

Dates

INV_DATE, DUE_DATE and CLEARING_DATE accept the follwoing formats:

  • YYYY-MM-DD, for example 2023-05-15

  • DD/MM/YYYY, for example 15/05/2023

  • dd.MM.yyyy, for example 15.05.2023

DUE_DATE is mandatory for invoices and bills of exchange.

Amounts

Accepted formats: 1500 or 1812.59 or 1812,59 or 1 812,59 or 57,802.75.

Negative amounts: use a leading minus sign: -100.

⚠️ Do not use a thousands separator without decimals (1,500 is read as 1.5), nor the 1.234,56 format. When possible, prefer a plain number with a dot as decimal separator (1812.59).

  • AMOUNT: total amount of the item including VAT, in the currency of the document.

  • BALANCE: amount still due on the item. Repeat the AMOUNT value if you do not have any partial payments.

  • PAYMENT_TERMS: number of days, for example 30, 60 or 90. Mandatory if you can't integrate the DUE_DATE.

  • CREDIT_LIMIT_AMOUNT: Amounts must be specified in multiples of 1,000.

    • delegated insurance (Coface, Atradius, etc.): credit limit granted by the insurer. Not needed if your insurer is connected to Afakto.

    • internal insurance (the factor is the insurer): amount to request from the factor, in the transaction currency, to cover the buyer's outstanding.

Related articles

Did this answer your question?