Invoice.

Show:

FACT_AVOIR

Tinyint(1)

Enable/disable this invoice to be a credit note :

  • 1 : Enable
  • 0 : Disable


Default: 0

FACT_CC_ADR1

Varchar(250)

Factor contact address 1 backup value


Default: ''

FACT_CC_ADR2

Varchar(250)

Factor contact address 2 backup value


Default: ''

FACT_CC_ADR3

Varchar(250)

Factor contact address 3 backup value


Default: ''

FACT_CC_CONTACT

Varchar(200)

Factor contact name backup value


Default: ''

FACT_CC_CP

Char(10)

Factor contact zipcode backup value


Default: ''

FACT_CC_NOM

Varchar(100)

Factor contact company name backup value


Default: ''

FACT_CC_PAYS

Varchar(100)

Factor contact country backup value


Default: ''

FACT_CC_VILLE

Varchar(100)

Factor contact town backup value


Default: ''

FACT_CH_ADR1

Varchar(250)

Factor head office address 1 backup value


Default: ''

FACT_CH_ADR2

Varchar(250)

Factor head office address 2 backup value


Default: ''

FACT_CH_ADR3

Varchar(250)

Factor head office address 3 backup value


Default: ''

FACT_CH_CONTACT

Varchar(200)

Factor head office name backup value


Default: ''

FACT_CH_CP

Char(10)

Factor head office zipcode backup value


Default: ''

FACT_CH_NOM

Varchar(100)

Factor head office company name backup value


Default: ''

FACT_CH_PAYS

Varchar(100)

Factor head office country backup value


Default: ''

FACT_CH_VILLE

Varchar(100)

Factor head office town backup value


Default: ''

FACT_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

FACT_CHANGEAGENCE

Decimal(30,10)

Agency's exchange rate.


Default: 1

FACT_CLOTURE

Tinyint(1)

Enable/disable to close this invoice :

  • 1 : Enable
  • 0 : Disable


Default: 0

FACT_CONDREGLEMENT

Tinyint(1)

Payment term backup value


Default: 0

FACT_DATEREGLEMENTATTENDUE

Date

Expected payment date.

FACT_DATEREGLEMENTRECUE

Date

Performed payment date.

This property can be null.

FACT_DEVISE

Tinyint(2)

Currency.

cf. key id for JSON response data.settings.currency of API /application/dictionary


Default: 0

FACT_DEVISE_LABEL

Varchar(250)

Currency label backup value


Default: ''

FACT_DEVISE_SYMBOLE

Varchar(250)

Currency symbol backup value


Default: ''

FACT_DEVISEAGENCE

Tinyint(2)

Agency's currency.

cf. key id for JSON response data.settings.currency of API /application/dictionary


Default: 0

FACT_ETAT

Tinyint(1)

State.

cf. key id for JSON response data.settings.state.invoice of API /application/dictionary.


Default: 0

FACT_FACTOR_ADR

Varchar(250)

Factor address backup value


Default: ''

FACT_FACTOR_CP

Char(10)

Factor zipcode backup value


Default: ''

FACT_FACTOR_NAF

Varchar(100)

Factor ape code backup value


Default: ''

FACT_FACTOR_NIC

Char(5)

Factor internal ranking number backup value


Default: ''

FACT_FACTOR_PAYS

Varchar(100)

Factor country backup value


Default: ''

FACT_FACTOR_RCS

Varchar(100)

Factor registered office backup value


Default: ''

FACT_FACTOR_SIREN

Varchar(95)

Factor national identification number backup value


Default: ''

FACT_FACTOR_SOCIETE

Varchar(100)

Factor agency name backup value


Default: ''

FACT_FACTOR_STATUT

Varchar(100)

Factor legal status backup value


Default: ''

FACT_FACTOR_TVA

Varchar(100)

Factor vat backup value


Default: ''

FACT_FACTOR_VILLE

Varchar(100)

Factor town backup value


Default: ''

FACT_FILEVERSION

Int(11)

File version


Default: ''

FACT_REF

Varchar(250)

Reference.


Default: ''

FACT_RIB_BIC

Char(11)

BIC backup value


Default: ''

FACT_RIB_DESCRIPTION

Text

RIB backup value


Default: ''

FACT_RIB_IBAN

Char(34)

IBAN backup value


Default: ''

FACT_SHOWCOMMENTAIRE

Tinyint(1)

Enable/disable to show information comments on PDF :

  • 1 : Enable
  • 0 : Disable


Default: 0

FACT_SOCIETE_ADR

Varchar(250)

Agency address backup value


Default: ''

FACT_SOCIETE_CP

Char(10)

Agency zipcode backup value


Default: ''

FACT_SOCIETE_EMAIL

Varchar(100)

Agency email backup value


Default: ''

FACT_SOCIETE_NAF

Varchar(100)

Agency ape code backup value


Default: ''

FACT_SOCIETE_NIC

Char(5)

Agency internal ranking number.


Default: ''

FACT_SOCIETE_PAYS

Varchar(100)

Agency country backup value


Default: ''

FACT_SOCIETE_RAISON

Varchar(100)

Agency name backup value


Default: ''

FACT_SOCIETE_RCS

Varchar(100)

Agency registered office backup value


Default: ''

FACT_SOCIETE_SIREN

Varchar(95)

Agency national identification number backup value


Default: ''

FACT_SOCIETE_STATUT

Varchar(100)

Agency legal status backup value


Default: ''

FACT_SOCIETE_TEL

Char(20)

Agency phone backup value


Default: ''

FACT_SOCIETE_TVA

Varchar(100)

Agency vat backup value


Default: ''

FACT_SOCIETE_VILLE

Varchar(100)

Agency town backup value


Default: ''

FACT_TAUXREMISE

Decimal(15,5)

Discount rate.


Default: 0

FACT_TOTALHT

Decimal(30,10)

Total excluding tax backup value


Default: 0

FACT_TOTALTTC

Decimal(30,10)

Total including tax backup value


Default: 0

FACT_TYPEPAYMENT

Tinyint(2)

Method of payment.

cf. key id for JSON response data.settings.paymentMethod of API /application/dictionary.


Default: 0

ID_DOCUMENT_PDF

Int(11)

TAB_DOCUMENT.ID_DOCUMENT_PDF.

Last history document version


Default: 0