Order.

Show:

BDC_ACCORDCLIENT

Tinyint(1)

Enable/disable customer agreement :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_ATTACH_EXPENSES

Tinyint(1)

Enable/disable to attach the expenses file to the invoice:

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_ATTACH_SIGNED_TIMESHEETS

Tinyint(1)

Enable/disable to attach the signed timesheets to the invoicing (wi:

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_ATTACH_UNSIGNED_TIMESHEETS

Tinyint(1)

Enable/disable to attach the unsigned timesheets to the invoicing (if no signed timesheet):

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_AUTOCREATION

Tinyint(1)

Enable/disable to create automatically invoices from agency's settings :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_BILLINGINSTRUCTIONS

Text

Billing instructions

BDC_COMMENTAIRE

Text

Information comments.

BDC_COMMENTS_ON_PDF

Tinyint(1)

Enable/disable show comments by default on times reports customer pdf

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_CONDREGLEMENT

Int(11)

Terms of payment.

cf. key id for JSON response data.setting.paymentTerm of API /application/dictionary.


Default: 0

BDC_COPYCOMMENTS

Tinyint(1)

Enable/disable to copy order comments in each new invoice :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_CREATEDAT

Date

Creation date.

BDC_DATE

Date

Date.

BDC_ETAT

Int(11)

State.

cf. key id for JSON response data.setting.state.order of API /application/dictionary.


Default: 1

BDC_GROUPEXPENSES

Tinyint(1)

Enable/disable to group invoices items related to expenses:

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_GROUPMISSION

Tinyint(1)

Enable/disable to group invoices items :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_LANGUE

Char(3)

Language on PDF invoices.

Allowed languages are "fr" & "en".


Default: 'fr'

BDC_LISTETAUXTVA

Tinytext

Tax rates.

cf. JSON response data.setting.taxRate of API /application/dictionary.

Tax rates are separated by | character.

Example:

20|10|5.5

BDC_MENTIONS

Text

Invoices legals.

BDC_MERGE_INVOICE_ATTACHMENTS

Tinyint(1)

Enable/disable merge invoice attachments in invoice pdf file

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_MONTANTHT

Decimal(30,10)

Turnover to invoice excluding tax.


Default: 0

BDC_MONTANTTTC

Decimal(30,10)

Turnover to invoice including tax.


Default: 0

BDC_REF

Varchar(250)

Reference.


Default: ''

BDC_REFCLIENT

Varchar(250)

Customer number.


Default: ''

BDC_REQUEST_TIMESHEETS_SIGNATURE

Tinyint(1)

Enable/disable to request the timesheets signature:

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_RESOURCE_FULLNAME_ON_PDF

Tinyint(1)

Enable/disable show resource fullname by default on times reports customer pdf

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SEPARATEAE

Tinyint(1)

Enable/disable the creation of separate invoices for from exceptional activities :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SEPARATETPSFRS

Tinyint(1)

Enable/disable to create separate invoices for from timesheets, expenses & purchases :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWCOMMENTS

Tinyint(1)

Enable/disable to show comments on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWFACTOR

Tinyint(1)

Enable/disable to show "Factor" part on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWFOOTER

Tinyint(1)

Enable/disable to show the footer on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWINTNAME

Tinyint(1)

Enable/disable to show resources name on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWJRSOUVRES

Tinyint(1)

Enable/disable to show resources number of working days worked in PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWNUMBER

Tinyint(1)

Enable/disable to show order's number on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWPRJREFERENCE

Tinyint(1)

Enable/disable to show project's reference on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWRIB

Tinyint(1)

Enable/disable to show bank details on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWTARIFJRS

Tinyint(1)

Enable/disable to show resources daily prices on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_SHOWTVAIC

Tinyint(1)

Enable/disable to show V.A.T number on PDF invoices :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_TAUXTVA

Decimal(15,5)

Tax rate.

cf. JSON response data.setting.taxRate of API /application/dictionary.


Default: 0

BDC_TYPEPAYMENT

Int(11)


Default: -1

BDC_TYPEREGLEMENT

Tinyint(1)

Type of billing :

  • 0 : Schedules
  • 1 : Monthly


Default: 0

BDC_UPDATEDAT

Datetime

Update date.

BDC_USE_WORK_UNIT_ON_PDF

Tinyint(1)

Enable/disable use work unit type for regular duration by default on times reports customer pdf

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_WORK_UNIT_TYPE_NAME_ON_PDF

Tinyint(1)

Enable/disable show work unit type name by default on times reports customer pdf

  • 1 : Enable
  • 0 : Disable


Default: 0

ID_BONDECOMMANDE

Int(11)

Unique identifier.

ID_COORDONNEES

Int(11)

TAB_COORDONNEES.ID_COORDONNEES.

Company's billing details.


Default: 0

ID_CREATOR

Int(11)


Default: 0

ID_CRMSOCIETE

Int(11)

TAB_CRMSOCIETE.ID_CRMSOCIETE.

Company's factor.


Default: 0

ID_HEADOFFICE

Int(11)

TAB_COORDONNEES.ID_COORDONNEES.

Company's head office.


Default: 0

ID_PROJET

Int(11)

TAB_PROJET.ID_PROJET.

Company's factor.


Default: 0

ID_RESPUSER

Int(11)

TAB_USER.ID_USER.

Main manager.


Default: 0

ID_RIB

Int(11)

TAB_RIB.ID_RIB.

Bank details.


Default: 0