TAB_PROVIDER_INVOICE Class

Provider invoice.

Show:

ID_AGENCY

Int(11)

TAB_SOCIETE.ID_SOCIETE.

Agency.

ID_CREATOR

Int(11)

TAB_PROFIL.ID_PROFIL.

Creator.

ID_MAINMANAGER

Int(11)

TAB_PROFIL.ID_PROFIL.

Main manager.

ID_POLE

Int(11)

TAB_POLE.ID_POLE.

Pole.

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

Resource.

ID_PROVIDER_INVOICE

Int(11)

Unique identifier.

PROVIDER_INVOICE_AMOUNT_HT

Decimal(30,10)

Provider invoice amount HT


Default: 0

PROVIDER_INVOICE_AMOUNT_TTC

Decimal(30,10)

Provider invoice amount TTC


Default: 0

PROVIDER_INVOICE_CREATED_AT

Datetime

Provider invoice creation date

PROVIDER_INVOICE_CURRENCY

Int(11)

Provider invoice currency


Default: 0

PROVIDER_INVOICE_CURRENCY_AGENCY

Int(11)

Provider invoice currency agency


Default: 0

PROVIDER_INVOICE_END_DATE

Datetime

Provider invoice end date

PROVIDER_INVOICE_EXCHANGE_RATE

Decimal(30,10)

Provider invoice exchange rate


Default: 1

PROVIDER_INVOICE_EXCHANGE_RATE_AGENCY

Decimal(30,10)

Provider invoice exchange rate agency


Default: 1

PROVIDER_INVOICE_INVOICE_DATE

Datetime

Provider invoice : invoice date

PROVIDER_INVOICE_PAY_DATE

Datetime

Provider invoice pay date

PROVIDER_INVOICE_REFERENCE

Text

Provider invoice reference


Default: ''

PROVIDER_INVOICE_START_DATE

Datetime

Provider invoice start date

PROVIDER_INVOICE_STATE

Int(11)

Provider invoice state


Default: 0

PROVIDER_INVOICE_STATE_REASON

Tinyint(1)

End of process.


Default: 0

PROVIDER_INVOICE_STATE_REASON_COMMENT

Text

Reason end of process.


Default: ''

PROVIDER_INVOICE_STATE_UPDATED_AT

Datetime

Provider invoice update state date

PROVIDER_INVOICE_UPDATED_AT

Datetime

Provider invoice update date