TAB_FRAISDETAILS - BoondManager

Delivery/Contract expenses details.

Index
Properties

Properties

FRSDETAILS_MONTANT
FRSDETAILS_TYPE
FRSDETAILS_TYPEFRSREF
ID_FRAISDETAILS
ID_PARENT
ID_SOCIETE
PARENT_TYPE

FRSDETAILS_MONTANT

Decimal(30,10)

Amount including tax.

Default: 0

FRSDETAILS_TYPE

Tinyint(1)

Type :

0 : Daily expense
1 : Monthly expense

Default: 0

FRSDETAILS_TYPEFRSREF

Int(11)

Reference :

0 : Kilometric expense
integer : cf. TAB_TYPEFRAIS.TYPEFRS_REF.

Default: 0

ID_FRAISDETAILS

Int(11)

Unique identifier.

ID_PARENT

Int(11)

Entity's identifier :

Contract : if TAB_FRAISDETAILS.PARENT_TYPE is 0, cf. TAB_CONTRAT.ID_CONTRAT
Delivery : if TAB_FRAISDETAILS.PARENT_TYPE is 1, cf. TAB_MISSIONPROJET.ID_MISSIONPROJET

Default: 0

ID_SOCIETE

Int(11)

TAB_SOCIETE.ID_SOCIETE.

Agency.

Default: 0

PARENT_TYPE

Tinyint(1)

Entity's type :

0 : Contract
1 : Delivery

Default: 0