Invoice.

Show:

Properties

FACT_AMOUNT_PAYABLE

Decimal(30,10)

Total amounbt left to pay including tax


Default: 0

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_NIC

Char(5)

NIC


Default: ''

FACT_CC_NOM

Varchar(100)

Factor contact company name backup value


Default: ''

FACT_CC_NUMBER

Varchar(250)

Number


Default: ''

FACT_CC_PAYS

Varchar(100)

Factor contact country backup value


Default: ''

FACT_CC_SENDING_MODE

Int(11)

Sending mode


Default: -1

FACT_CC_SENDING_MODE_PARAMS

Json

Sending mode additional information

FACT_CC_SIREN

Varchar(95)

SIREN


Default: ''

FACT_CC_SUBDIVISION

Varchar(6)

Factor contact sub division (ISO-3166-2).


Default: ''

FACT_CC_VAT_NUMBER

Varchar(100)

VAT number


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_SUBDIVISION

Varchar(6)

Factor head office sub division (ISO-3166-2).


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_COMMENTAIRE

Text

Information comments.

FACT_CONDREGLEMENT

Tinyint(1)

Payment term backup value


Default: 0

FACT_CREATEDAT

Datetime

Creation date.

FACT_DATE

Date

Creation date.

FACT_DATEREGLEMENTATTENDUE

Date

Expected payment date.

FACT_DATEREGLEMENTRECUE

Date

Performed payment date.

This property can be null.

FACT_DEBUT

Date

Start date.

FACT_DEVISE

Int(11)

Currency.

cf. key id for JSON response data.setting.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

Int(11)

Agency's currency.

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


Default: 0

FACT_ETAT

Int(11)

State.

cf. key id for JSON response data.setting.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_SUBDIVISION

Varchar(6)

Factor sub division (ISO-3166-2).


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_FIN

Date

End date.

FACT_MENTIONS

Text

Legals backup value


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_GENQRFACTURE

Tinyint(1)

Agency qr invoice generation activated


Default: 0

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_QRFACTURETYPE

Tinyint(2)

Agency qr invoice type


Default: 0

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_SUBDIVISION

Varchar(6)

Agency sub division (ISO-3166-2).


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_TYPE_OF

Tinyint(1)

type of invoice (inform on what type of invoice record are added to invoice on creation)


Default: -1 - `0` : ALL (Times + Expenses + Purchases) - `1` : Times - `2` : Expenses - `3` : Purchases - `4` : Expenses + Purchases - `5` : Normal activity + Expenses + Purchases - `6` : Normal activity - `7` : Exceptional activity

FACT_TYPEPAYMENT

Int(11)

Method of payment.

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


Default: -1

FACT_UPDATEDAT

Datetime

Update date.

ID_BONDECOMMANDE

Int(11)


Default: 0

ID_CREATOR

Int(11)


Default: 0

ID_DOCUMENT_CII

Int(11)

TAB_DOCUMENT.ID_DOCUMENT_CII.

Last history document version for cii file


Default: 0

ID_DOCUMENT_FACTURX

Int(11)

TAB_DOCUMENT.ID_DOCUMENT_FACTURX.

Last history document version for facturx file


Default: 0

ID_DOCUMENT_PDF

Int(11)

TAB_DOCUMENT.ID_DOCUMENT_PDF.

Last history document version


Default: 0

ID_ECHEANCIER

Int(11)


Default: 0

ID_FACTURATION

Int(11)

Unique identifier.

ID_PARENT_FACTURATION

Int(11)

TAB_FACTURATION.ID_PARENT_FACTURATION.

Parent invoice (related to credit notes)


Default: 0