TAB_POSITIONDETAILS - BoondManager

Additional turnover & investment on opportunity/positioning.

Index
Properties

Properties

ID_PARENT
ID_POSITIONDETAILS
PARENT_TYPE
POSDETAILS_INVESTISSEMENT
POSDETAILS_TARIF
POSDETAILS_TITRE
POSDETAILS_TYPE_ADDITIONNEL

ID_PARENT

Int(11)

Entity's identifier :

Opportunity : if TAB_POSITIONDETAILS.PARENT_TYPE is 0, cf. TAB_AO.ID_AO
Positioning : if TAB_POSITIONDETAILS.PARENT_TYPE is 1, cf. TAB_POSITIONNEMENT.ID_POSITIONNEMENT

Default: 0

ID_POSITIONDETAILS

Int(11)

Unique identifier.

PARENT_TYPE

Tinyint(1)

Entity's type :

0 : Opportunity
1 : Positioning

Default: 0

POSDETAILS_INVESTISSEMENT

Decimal(30,10)

Investment excluding tax.

Default: 0

POSDETAILS_TARIF

Decimal(30,10)

Turnover excluding tax.

Default: 0

POSDETAILS_TITRE

Varchar(150)

Title.

Default: ''

POSDETAILS_TYPE_ADDITIONNEL

Int(11)

Additional turnover and cost type id for opportunity/positioning :

Default: -1