TAB_DOCUMENT - BoondManager

Entity's document (company, opportunity, project, order, product, purchase, action, delivery, positioning).

Index
Properties

Properties

DOC_TYPE
FILE_NAME
ID_DOCUMENT
ID_ESIGNATURE
ID_PARENT

DOC_TYPE

Tinyint(1)

Entity's type :

0 : Company
1 : Opportunity
2 : Project
3 : Order
4 : Product
5 : Purchase
6 : Action
7 : Delivery
9 : Positioning
10 : Log
11 : Contract
12 : FollowedDocument

Default: 0

FILE_NAME

Varchar(150)

Name.

Default: ''

ID_DOCUMENT

Int(11)

Unique identifier.

ID_ESIGNATURE

Int(11)

Signature related to the document:

Signature: TAB_ESIGNATURE.ID_ESIGNATURE.

Default: 0

ID_PARENT

Int(11)

Entity's identifier :

Company : if TAB_DOCUMENT.DOC_TYPE is 0, cf. TAB_CRMSOCIETE.ID_CRMSOCIETE
Opportunity : if TAB_DOCUMENT.DOC_TYPE is 1, cf. TAB_AO.ID_AO
Project : if TAB_DOCUMENT.DOC_TYPE is 2, cf. TAB_PROJET.ID_PROJET
Order : if TAB_DOCUMENT.DOC_TYPE is 3, cf. TAB_BONDECOMMANDE.ID_BONDECOMMANDE
Product : if TAB_DOCUMENT.DOC_TYPE is 4, cf. TAB_PRODUIT.ID_PRODUIT
Purchase : if TAB_DOCUMENT.DOC_TYPE is 5in [20,21,22,23,24,25,26,27,28,29,105], cf. TAB_ACHAT.ID_ACHAT
Action : if TAB_DOCUMENT.DOC_TYPE is in 6, cf. TAB_ACTION.ID_ACTION
Delivery : if TAB_DOCUMENT.DOC_TYPE is in 7, cf. TAB_MISSIONPROJET.ID_MISSIONPROJET
Positioning : if TAB_DOCUMENT.DOC_TYPE is in 9, cf. TAB_POSITIONNEMENT.ID_POSITIONNEMENT
Log : if TAB_DOCUMENT.DOC_TYPE is 10, cf. TAB_LOG.ID_LOG
Contract : if TAB_DOCUMENT.DOC_TYPE is 11, cf. TAB_CONTRAT.ID_CONTRAT
FollowedDocument : if TAB_DOCUMENT.DOC_TYPE is 12, cf. TAB_FOLLOWED_DOCUMENT.ID_FOLLOWED_DOCUMENT

Default: 0