Order.

Show:

BDC_ACCORDCLIENT

Tinyint(1)

Enable/disable customer agreement :

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_ATTACHTIMESHEETS

Tinyint(1)

Enable/disable to attach an archive of the signed timesheets to the invoicing emails:

  • 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_BLOCKGENERATION

Tinyint(1)

Enable/disable to block invoice generation until all signed timesheets are available:

  • 1 : Enable
  • 0 : Disable


Default: 0

BDC_CONDREGLEMENT

Tinyint(1)

Terms of payment.

cf. key id for JSON response data.settings.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_ETAT

Tinyint(2)

State.

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


Default: 1

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.settings.taxRate of API /application/dictionary.

Tax rates are separated by | character.

Example:

20|10|5.5

BDC_MONITORTIMESHEETS

Tinyint(1)

Enable/disable the monitoring of signed timesheets for invoicing:

  • 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_REFCLIENT

Varchar(250)

Customer number.


Default: ''

BDC_SENDINGMODE

Tinyint(2)

Sending mode


Default: -1

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.settings.taxRate of API /application/dictionary.


Default: 0

BDC_TYPEREGLEMENT

Tinyint(1)

Type of billing :

  • 0 : Schedules
  • 1 : Monthly


Default: 0