Agency's settings.

Show:

Properties

GRPCONF_ACHATALLOWMULTITVA

Tinyint(1)

Enable/disable multiple tax rates on purchases

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_ACHATCONDREGLEMENT

Tinyint(1)

Default value of TAB_ACHAT.ACHAT_CONDREGLEMENT.


Default: 0

GRPCONF_ACHATLISTETAUXTVA

Tinytext

Default purchases tax rates of TAB_ACHAT.ACHAT_LISTETAUXTVA.

Tax rates are separated by | character.

Example:

20|10|5.5

GRPCONF_ACHATTAUXTVA

Decimal(15,5)

Default purchases tax rate of TAB_ACHAT.ACHAT_TAUXTVA.


Default: 0

GRPCONF_ACHATTYPEPAYMENT

Tinyint(2)

Default value of TAB_ACHAT.ACHAT_TYPEPAYMENT.


Default: 0

GRPCONF_ALERTDECOMPTE

Tinyint(1)

Enable/disable to show warnings when absences exceed their counters :

  • 1 : Enable
  • 0 : Disable


Default: 1

GRPCONF_ALERTESTEMPS

Text

List of alerts for timesheets.

Each alert is described by :

  • Type of alert :moreThanNumberOfWorkingDays, lessThanNumberOfWorkingDays, moreThanAbsenceAccountAcquired, wrongAbsences, noDeliveryOnProject, projectDoesNotExist, deliveryDoesNotExist, outsideContractDates, outsideDeliveryDates, outsideDocumentDates
  • Type of resource not concerned by this alert : cf. key id for JSON response data.settings.typeOf.resource of API /application/dictionary
  • Blocking alert : 1 if blocking alert else 0
  • Type of alert, Type of resource not concerned by this alert & Blocking alert and separated by '|' character

Alerts are separated by # character.

Example:

"moreThanNumberOfWorkingDays|1|0#moreThanAbsenceAccountAcquired|1|0#wrongAbsences|1|0#noDeliveryOnProject|1|0#projectDoesNotExist|1|0#deliveryDoesNotExist|1|0#outsideContractDates|1|0#outsideDeliveryDates|1|0#outsideDocumentDates|1|0#"

GRPCONF_APIACCESS

Tinyint(1)

Enable/disable to access api from X-Jwt-Client :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_AUTOFACTURATION

Tinyint(1)

Enable/disable to create automatically invoices whose TAB_BONDECOMMANDE.BDC_AUTOCREATION is 1 :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_AVANTAGESEXCEPTION

Text

List of advantages that could be paid for exceptional activity.

Each advantage is described by :

Advantages are separated by # character.

GRPCONF_BAREMESEXCEPTION

Text

List of exceptional scales.

Each scale is described by :

Scales are separated by # character.

Example:

"2|Astreinte|10_11|0"

GRPCONF_BDCALLOWMULTITVA

Tinyint(1)

Enable/disable multiple tax rates on orders

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_BDCEXPENSESEXCLUDINGTAX

Tinyint(1)

Enable/disable to reinvoice expenses including tax or excluding tax

  • 1 : Excluding tax
  • 0 : Including tax


Default: 0

GRPCONF_BDCLISTETAUXTVA

Tinytext

Default orders tax rates of TAB_BONDECOMMANDE.BDC_LISTETAUXTVA.

Tax rates are separated by | character.

Example:

20|10|5.5

GRPCONF_BDCSENDINGMODE

Tinyint(2)

Sending mode :


Default: -1

GRPCONF_BDCSHOWHEADOFFICE

Tinyint(1)

Distinguish head office and billing details on each orders invoice.


Default: 1

GRPCONF_BDCTAUXTVA

Decimal(15,5)

Default order tax rate of TAB_BONDECOMMANDE.BDC_TAUXTVA.


Default: 0

GRPCONF_CALCULDECOMPTE

Tinyint(1)

Absences accounts calculation method.

  • 0 : Method 1, Absences taken on the period until current month and asked on the period from current month
  • 1 : Method 2, Absences taken an asked on all the period


Default: 0

GRPCONF_CALENDRIER

Varchar(100)

Calendar.


Default: 'France_Sans_Pentecote'

GRPCONF_CERTIFICATIONACTIVITE

Tinyint(1)

Enable/disable certification on activity expense :

  • 1 : Enable
  • 0 : Disable


Default: 1

GRPCONF_CHANGE

Decimal(30,10)

Exchange rate.


Default: 1

GRPCONF_CHARGE

Decimal(15,5)

Charge factor.


Default: 1.5

GRPCONF_CTRALLOWTEMPSEXCEPTION

Tinyint(1)

Enable/disable exceptional activity configuration on contracts :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_CTRAUTOFILLEXPENSES

Tinyint(1)

Enable/disable prefill of expenses with contractual expenses details :

  • 1 : Enable
  • 0 : Disable


Default: 1

GRPCONF_CTRDUREEHEBDOMADAIRE

Decimal(15,5)


Default: 0

GRPCONF_CTRSALARYTYPE

Tinyint(1)

Type of salary filled on contracts :

  • 1 : Annual
  • 0 : Monthly


Default: 1

GRPCONF_DATEMAILFRAIS

Tinyint(2)

Enable/disable the creation of expenses and sending to resources :

  • 0 : Disable
  • integer : Enable on the specified day of the month
  • 99 : Enable on the last day of the month


Default: 0

GRPCONF_DATEMAILTEMPS

Tinyint(2)

Enable/disable the creation of timesheets and sending to resources :

  • 0 : Disable
  • integer : Enable on the specified day of the month
  • 99 : Enable on the last day of the month


Default: 0

GRPCONF_DEFAULTCANDIDATETYPEOF

Tinyint(2)

Default Candidat TypeOf :


Default: -1

GRPCONF_DEFAULTRESOURCETYPEOF

Tinyint(2)

Default Resource TypeOf :


Default: 0

GRPCONF_DELTAFACTURATION

Tinyint(2)

Advance/delay on monthly invoices creation.

Shall be a positive or negative integer that represents the advance/delay number of days from the end of the month.


Default: 0

Example:

-1

GRPCONF_DEVISALLOWMULTITVA

Tinyint(1)

Enable/disable multiple tax rates on quotations

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_DEVISCONDREGLEMENT

Tinyint(1)

Default value of TAB_DEVIS.DEVIS_CONDREGLEMENT.


Default: 0

GRPCONF_DEVISE

Tinyint(2)

Currency.


Default: 0

GRPCONF_DEVISLISTETAUXTVA

Tinytext

Default quotations tax rates

Tax rates are separated by | character.

Example:

20|10|5.5

GRPCONF_DEVISSHOWAOREFERENCE

Tinyint(1)


Default: 1

GRPCONF_DEVISSHOWFOOTER

Tinyint(1)

Default value of TAB_DEVIS.DEVIS_SHOWFOOTER.


Default: 1

GRPCONF_DEVISSHOWNUMBER

Tinyint(1)

Default value of TAB_DEVIS.DEVIS_SHOWNUMBER.


Default: 0

GRPCONF_DEVISSHOWTVAIC

Tinyint(1)

Default value of TAB_DEVIS.DEVIS_SHOWTVAIC.


Default: 0

GRPCONF_DEVISTAUXTVA

Decimal(15,5)

Default quotations tax rate


Default: 0

GRPCONF_DEVISVALIDITE

Tinyint(4)

Quotations validity duration in days.

Used to calculate TAB_DEVIS.DEVIS_DATEACCORDATTENDU from TAB_DEVIS.DEVIS_DATE.


Default: 15

GRPCONF_DOWNLOADCENTER

Tinyint(1)

Enable/disabled download center module :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_ETATAFTERMAILFACTURATION

Tinyint(1)

Bill's state to apply after sending an automatic email to contact.

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


Default: -1

GRPCONF_ETATBEFOREMAILFACTURATION

Tinyint(1)

Bill's state that will send an automatic email to contact.

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


Default: -1

GRPCONF_ETATFIXEFACTURATION

Varchar(250)

List of bill's locking state :


Default: ''

Example:

"1|4|5"

GRPCONF_HASH

Char(20)

Client Key to use with x-JWT-Hash Security Schemes.

cf. API /application/dictionary.


Default: ''

GRPCONF_INTRANET

Tinyint(1)

Enable/disable intranet module :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_JDATERESSOURCEPLANNER

Tinyint(2)

J Day used to calculate planned data :

  • 0 : Actual day
  • integer : Specified day of the month
  • 99 : The last day of the month


Default: 0

GRPCONF_MAILBCCFACTURATION

Text

Sender BCC email when sending PDF invoices :

  • currentManager : Invoice sender manager
  • mainManager : Invoice main manager
  • projectManager : Project main manager


Default: ''

GRPCONF_MAILCCFACTURATION

Text

Sender CC email when sending PDF invoices :

  • currentManager : Invoice sender manager
  • mainManager : Invoice main manager
  • projectManager : Project main manager


Default: ''

GRPCONF_MAILFACTURATION

Varchar(250)

Sender email when sending PDF invoices :

  • `` : Bill's main manager
  • string : Specific email


Default: ''

GRPCONF_MASKREFACHAT

Varchar(250)

References masks of purchases :

  • Empties references will take the mask's value
  • Only characters following this RegExp are allowed [a-zA-Z0-9\[\]_\-\/]{0,}

These variables can be used for each mask :

  • [AA] : Year in two numbers
  • [AAAA] : Year in four numbers
  • [MM] : Month in two numbers
  • [JJ] : Day in to two numbers
  • [ID_ACHAT] : Opportunity's unique identifier*, cf. TAB_ACHAT.ID_ACHAT*
  • [CCC] : Company's three first letters
  • [RRR] : Main manager's trigram


Default: ''

Example:

: "PURCHASE[ID_ACHAT]"

GRPCONF_MASKREFAO

Varchar(250)

References masks of opportunities following their type :

  • Masks are separated by | character in this order : Technical Assistance's mask | Package's mask | Recruitment's mask | Product's mask
  • Only characters following this RegExp are allowed [a-zA-Z0-9\[\]_\-\/]{0,}
  • Empties references will take the mask's value following their type

These variables can be used for each mask :

  • [AA] : Year in two numbers
  • [AAAA] : Year in four numbers
  • [MM] : Month in two numbers
  • [JJ] : Day in to two numbers
  • [ID_AO] : Opportunity's unique identifier*, cf. TAB_AO.ID_AO*
  • [CCC] : Company's three first letters
  • [RRR] : Main manager's trigram


Default: ''

Example:

: "TA[ID_AO]|PACKAGE[ID_AO]|RECRUITMENT[ID_AO]|PRODUCT[ID_AO]"

GRPCONF_MASKREFDEVIS

Varchar(250)

References masks of quotations :

  • Only characters following this RegExp are allowed [a-zA-Z0-9\[\]\{\}_\-\/]{1,}
  • This mask is followed with a space and the start numbering quotations

These variables can be used for each mask :

  • [AA] : Year in two numbers, this variable is used to calculate the next reference
  • [AAAA] : Year in four numbers, this variable is used to calculate the next reference
  • {AA} : Year in two numbers, this variable is not used to calculate the next reference
  • {AAAA} : Year in four numbers, this variable is not used to calculate the next reference


Default: ''

Example:

: "Q[AA]_{MM} 10000000"

GRPCONF_MASKREFFACTURATION

Varchar(250)

References masks of invoices :

  • Only characters following this RegExp are allowed [a-zA-Z0-9\[\]\{\}_\-\/]{1,}
  • This mask is followed with a space and the start numbering invoices

These variables can be used for each mask :

  • [AA] : Year in two numbers, this variable is used to calculate the next reference
  • [AAAA] : Year in four numbers, this variable is used to calculate the next reference
  • {AA} : Year in two numbers, this variable is not used to calculate the next reference
  • {AAAA} : Year in four numbers, this variable is not used to calculate the next reference


Default: ''

Example:

: "F[AA]_{MM} 10000000"

GRPCONF_MASKREFPROJET

Varchar(250)

References masks of projects following their type :

  • Masks are separated by | character in this order : Technical Assistance's mask | Package's mask | Recruitment's mask | Product's mask
  • Only characters following this RegExp are allowed [a-zA-Z0-9\[\]_\-\/]{0,}
  • Empties references will take the mask's value following their type

These variables can be used for each mask :

  • [AA] : Year in two numbers
  • [AAAA] : Year in four numbers
  • [MM] : Month in two numbers
  • [JJ] : Day in to two numbers
  • [ID_AO] : Opportunity's unique identifier*, cf. TAB_AO.ID_AO*
  • [REF_AO] : Opportunity's reference*, cf. TAB_AO.AO_REF*
  • [ID_PRJ] : Project's unique identifier*, cf. TAB_PROJET.ID_PROJET*
  • [CCC] : Company's three first letters
  • [RRR] : Main manager's trigram


Default: ''

Example:

: "TA_[REF_AO]|PACKAGE_[REF_AO]|RECRUITMENT_[REF_AO]|PRODUCT_[REF_AO]"

GRPCONF_MENTIONSABSENCES

Text

Requests of absences default legals.

GRPCONF_MENTIONSTEMPS

Text

Timesheets default legals.

GRPCONF_NBJRSOUVRE

Smallint

Number of working days.


Default: 217

GRPCONF_NUMBEROFFAILEDLOGIN

Tinyint(1)

Number of wrong credentials from the last login from X-Jwt-Client :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_PRJALLOWAVANTAGES

Tinyint(1)

Enable/disabl advantages configuration on deliveries.


Default: 0

GRPCONF_PRJALLOWJALONS

Tinyint(1)

Enable/disable to create alones markers on projects where TAB_PROJET.PRJ_TYPE = 2 :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_PRJALLOWTEMPSEXCEPTION

Tinyint(1)

Enable/disable exceptional activity configuration on deliveries :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_PRODUITALLOWMULTITVA

Tinyint(1)

Enable/disable multiple tax rates on products

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_PRODUITLISTETAUXTVA

Tinytext

Default products tax rates of TAB_PRODUIT.PRODUIT_LISTETAUXTVA.

Tax rates are separated by | character.

Example:

20|10|5.5

GRPCONF_PRODUITTAUXTVA

Decimal(15,5)

Default products tax rate of TAB_PRODUIT.PRODUIT_TAUXTVA.


Default: 0

GRPCONF_QUESTIONSABSENCES

Text

Requests of absences questions.

It is a list of questions separated by | character.

Example:

"Question 1?|Question 2?"

GRPCONF_SHOWDECOMPTE

Tinyint(1)

Enable/disable resources to see their absences counters :

  • 1 : Enable
  • 0 : Disable


Default: 0

GRPCONF_STARTDECOMPTE

Tinyint(2)

Default starting month of absences counters period.

Shall be an integer between 1 and 12.


Default: 1

Example:

6

GRPCONF_STRICTDATEFACTURATION

Tinyint(1)

Make strict dates for invoices


Default: 0

GRPCONF_TAUXHORAIRE

Decimal(15,5)

Default resources work unit rate.


Default: 1

GRPCONF_TAUXHORAIREAO

Decimal(15,5)

Default opportunities & projects work unit rate.


Default: 1

GRPCONF_TAUXREFACTURATION

Decimal(15,5)

Rebilling rate between agencies.


Default: 1

GRPCONF_TIMEZONE

Varchar(250)


Default: 'Europe/Paris'

GRPCONF_VALIDATIONABSENCES

Varchar(250)

Requests of absences default validation circuit.

It is a list of validator separated by | character.

A validator's value is :

  • integer : TAB_USER.ID_USER, obligatory the unique identifier of another user
  • 0 : Manager N
  • -1 : Manager N+1
  • -2 : Manager N+2
  • -3 : Manager N+3


Default: ''

Example:

"0|-1|100"

GRPCONF_VALIDATIONFRAIS

Varchar(250)

Expenses default validation circuit.

It is a list of validator separated by | character.

A validator's value is :

  • integer : TAB_USER.ID_USER, obligatory the unique identifier of another user
  • 0 : Manager N
  • -1 : Manager N+1
  • -2 : Manager N+2
  • -3 : Manager N+3


Default: ''

Example:

"0|-1|100"

GRPCONF_VALIDATIONTEMPS

Varchar(250)

Timesheets default validation circuit.

It is a list of validator separated by | character.

A validator value can be :

  • integer : TAB_USER.ID_USER, obligatory the unique identifier of another user
  • 0 : Manager N
  • -1 : Manager N+1
  • -2 : Manager N+2
  • -3 : Manager N+3


Default: ''

Example:

"0|-1|100"

GRPCONF_WEB

Varchar(100)

Unique URL suffix.


Default: ''