TAB_PROVIDER_INVOICE Class

Provider invoice.

Show:

ID_AGENCY

Int(11)

TAB_SOCIETE.ID_SOCIETE.

Agency.

ID_COORDONNEES

Int(11)

TAB_COORDONNEES.ID_COORDONNEES.

Provider Company's billing details.


Default: null

ID_CREATOR

Int(11)

TAB_PROFIL.ID_PROFIL.

Creator.

ID_CRMCONTACT

Int(11)

TAB_CRMCONTACT.ID_CRMCONTACT.

Provider contact.


Default: null

ID_CRMSOCIETE

Int(11)

TAB_CRMSOCIETE.ID_CRMSOCIETE.

Provider company.


Default: null

ID_INVOICING_CONNECTION

Int(11)

TAB_INVOICING_CONNECTION.ID_INVOICING_CONNECTION.

Invoicing connection.


Default: null

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_CREDIT_NOTE

Bool

Credit note.


Default: 0

PROVIDER_INVOICE_CURRENCY

Int(11)

Provider invoice currency


Default: 0

PROVIDER_INVOICE_CURRENCY_AGENCY

Int(11)

Provider invoice currency agency


Default: 0

PROVIDER_INVOICE_DUE_DATE

Date

Due date.


Default: null

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_EXTERNAL_ID

Varchar(100)

External ID.


Default: null

PROVIDER_INVOICE_INVOICE_DATE

Datetime

Provider invoice : invoice date

PROVIDER_INVOICE_PAY_DATE

Datetime

Provider invoice pay date

PROVIDER_INVOICE_PIN_SCHEME

Varchar(25)

Pin scheme.


Default: null

PROVIDER_INVOICE_PIN_VALUE

Varchar(25)

Pin value.


Default: null

PROVIDER_INVOICE_REFERENCE

Text

Provider invoice reference


Default: ''

PROVIDER_INVOICE_SOURCE

Varchar(25)

Source.


Default: 0

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

PROVIDER_INVOICE_VAT_NUMBER

Varchar(25)

VAT number.


Default: null