Additional turnover & investment on project/delivery.

Show:

ID_ACHAT

Int(11)

TAB_ACHAT.ID_ACHAT.

Purchase.


Default: 0

ID_MISSIONDETAILS

Int(11)

Unique identifier.

ID_PARENT

Int(11)

Entity's identifier :


Default: 0

MISDETAILS_DATE

Date

Production date.

MISDETAILS_ETAT

Tinyint(1)

State :

  • 0 : Not add this additional turnover and costs to production data
  • 1 : Add this additional turnover and costs to production data


Default: 1

MISDETAILS_INVESTISSEMENT

Decimal(30,10)

Investment excluding tax.


Default: 0

MISDETAILS_TARIF

Decimal(30,10)

Turnover excluding tax.


Default: 0

MISDETAILS_TITRE

Varchar(150)

Title.


Default: ''

MISDETAILS_TYPE_ADDITIONNEL

Int(11)

Additional turnover and cost type id for purchase :


Default: -1

PARENT_TYPE

Tinyint(1)

Entity's type :

  • 0 : Project
  • 1 : Delivery


Default: 0