TAB_GROUPECONFIG Class
Agency's settings.
Properties
- GRPCONF_ACHATALLOWMULTITVA
- GRPCONF_ACHATCONDREGLEMENT
- GRPCONF_ACHATLISTETAUXTVA
- GRPCONF_ACHATTAUXTVA
- GRPCONF_ACHATTYPEPAYMENT
- GRPCONF_ADVANCEDBI
- GRPCONF_AI
- GRPCONF_AI
- GRPCONF_ALERTDECOMPTE
- GRPCONF_ALERTESTEMPS
- GRPCONF_APIACCESS
- GRPCONF_APPSNOCODE
- GRPCONF_AUTOFACTURATION
- GRPCONF_AVANTAGESEXCEPTION
- GRPCONF_BANKING
- GRPCONF_BAREMESEXCEPTION
- GRPCONF_BDC_COMMENTS_ON_PDF
- GRPCONF_BDC_MERGE_INVOICE_ATTACHMENTS
- GRPCONF_BDC_RESOURCE_FULLNAME_ON_PDF
- GRPCONF_BDC_USE_WORK_UNIT_ON_PDF
- GRPCONF_BDC_WORK_UNIT_TYPE_NAME_ON_PDF
- GRPCONF_BDCALLOWMULTITVA
- GRPCONF_BDCATTACHEXPENSES
- GRPCONF_BDCATTACHSIGNEDTIMESHEETS
- GRPCONF_BDCATTACHUNSIGNEDTIMESHEETS
- GRPCONF_BDCCONDREGLEMENT
- GRPCONF_BDCCOPYCOMMENTS
- GRPCONF_BDCEXPENSESEXCLUDINGTAX
- GRPCONF_BDCGROUPEXPENSES
- GRPCONF_BDCGROUPMISSION
- GRPCONF_BDCIDCRMSOCIETE
- GRPCONF_BDCIDRIB
- GRPCONF_BDCLISTETAUXTVA
- GRPCONF_BDCMENTIONS
- GRPCONF_BDCREQUESTTIMESHEETSSIGNATURE
- GRPCONF_BDCSENDINGMODE
- GRPCONF_BDCSEPARATEAE
- GRPCONF_BDCSEPARATETPSFRS
- GRPCONF_BDCSHOWCOMMENTS
- GRPCONF_BDCSHOWFACTOR
- GRPCONF_BDCSHOWFOOTER
- GRPCONF_BDCSHOWHEADOFFICE
- GRPCONF_BDCSHOWINTNAME
- GRPCONF_BDCSHOWJRSOUVRES
- GRPCONF_BDCSHOWNUMBER
- GRPCONF_BDCSHOWPRJREFERENCE
- GRPCONF_BDCSHOWRIB
- GRPCONF_BDCSHOWTARIFJRS
- GRPCONF_BDCSHOWTVAIC
- GRPCONF_BDCTAUXTVA
- GRPCONF_BDCTYPEPAYMENT
- GRPCONF_CALCULDECOMPTE
- GRPCONF_CALENDRIER
- GRPCONF_CERTIFICATIONACTIVITE
- GRPCONF_CHANGE
- GRPCONF_CHARGE
- GRPCONF_CTRALLOWTEMPSEXCEPTION
- GRPCONF_CTRAUTOFILLEXPENSES
- GRPCONF_CTRDUREEHEBDOMADAIRE
- GRPCONF_CTRSALARYTYPE
- GRPCONF_DATEMAILFRAIS
- GRPCONF_DATEMAILTEMPS
- GRPCONF_DEFAULTCANDIDATETYPEOF
- GRPCONF_DEFAULTRESOURCETYPEOF
- GRPCONF_DELTAFACTURATION
- GRPCONF_DEVISALLOWMULTITVA
- GRPCONF_DEVISCONDREGLEMENT
- GRPCONF_DEVISE
- GRPCONF_DEVISLISTETAUXTVA
- GRPCONF_DEVISMENTIONS
- GRPCONF_DEVISSHOWAOREFERENCE
- GRPCONF_DEVISSHOWFOOTER
- GRPCONF_DEVISSHOWNUMBER
- GRPCONF_DEVISSHOWSIRET
- GRPCONF_DEVISSHOWTVAIC
- GRPCONF_DEVISTAUXTVA
- GRPCONF_DEVISVALIDITE
- GRPCONF_DOWNLOADCENTER
- GRPCONF_ETATAFTERMAILFACTURATION
- GRPCONF_ETATBEFOREMAILFACTURATION
- GRPCONF_ETATFIXEFACTURATION
- GRPCONF_GENQRFACTURE
- GRPCONF_HASH
- GRPCONF_INTRANET
- GRPCONF_JDATERESSOURCEPLANNER
- GRPCONF_LABS
- GRPCONF_MAILBCCFACTURATION
- GRPCONF_MAILCCFACTURATION
- GRPCONF_MAILFACTURATION
- GRPCONF_MASKREFACHAT
- GRPCONF_MASKREFAO
- GRPCONF_MASKREFDEVIS
- GRPCONF_MASKREFFACTURATION
- GRPCONF_MASKREFPROJET
- GRPCONF_MENTIONSABSENCES
- GRPCONF_MENTIONSFRAIS
- GRPCONF_MENTIONSTEMPS
- GRPCONF_NBJRSOUVRE
- GRPCONF_NUMBEROFFAILEDLOGIN
- GRPCONF_PRJALLOWAVANTAGES
- GRPCONF_PRJALLOWJALONS
- GRPCONF_PRJALLOWTEMPSEXCEPTION
- GRPCONF_PRODUITALLOWMULTITVA
- GRPCONF_PRODUITLISTETAUXTVA
- GRPCONF_PRODUITTAUXTVA
- GRPCONF_QRFACTURETYPE
- GRPCONF_QUESTIONSABSENCES
- GRPCONF_SHOWDECOMPTE
- GRPCONF_STARTDECOMPTE
- GRPCONF_STRICTDATEFACTURATION
- GRPCONF_TAUXHORAIRE
- GRPCONF_TAUXHORAIREAO
- GRPCONF_TAUXREFACTURATION
- GRPCONF_TIMEZONE
- GRPCONF_VALIDATIONABSENCES
- GRPCONF_VALIDATIONFRAIS
- GRPCONF_VALIDATIONTEMPS
- GRPCONF_WEB
- ID_GROUPECONFIG
- ID_SOCIETE
GRPCONF_ACHATALLOWMULTITVA
Tinyint(1)Enable/disable multiple tax rates on purchases
1: Enable0: Disable
Default: 0
GRPCONF_ACHATLISTETAUXTVA
TinytextDefault 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_ADVANCEDBI
Tinyint(1)Enable/disabled advanced bi module :
1: Enable0: Disable
Default: 0
GRPCONF_AI
Tinyint(1)Enable/disabled artificial intelligence module :
1: Enable0: Disable
Default: 0
GRPCONF_ALERTDECOMPTE
Tinyint(1)Enable/disable to show warnings when absences exceed their counters :
1: Enable0: Disable
Default: 1
GRPCONF_ALERTESTEMPS
TextList 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.setting.typeOf.resource of API /application/dictionary
- Blocking alert :
1if blocking alert else0 - Type of alert, Type of resource not concerned by this alert & Blocking alert are 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: Enable0: Disable
Default: 0
GRPCONF_APPSNOCODE
Tinyint(1)Enable/disabled apps no code module :
1: Enable0: Disable
Default: 0
GRPCONF_AUTOFACTURATION
Tinyint(1)Enable/disable to create automatically invoices :
1: Enable0: Disable
Default: 0
GRPCONF_AVANTAGESEXCEPTION
TextList of advantages that could be paid for exceptional activity.
Each advantage is described by :
- Work unit's type : cf. TAB_TYPEHEURE.TYPEH_REF, with TAB_TYPEHEURE.ID_SOCIETE = TAB_GROUPECONFIG.ID_SOCIETE
- Advantage's type : cf. TAB_TYPEAVANTAGE.TYPEA_REF, with TAB_TYPEAVANTAGE.ID_SOCIETE = TAB_GROUPECONFIG.ID_SOCIETE
- Work unit's type & advantage's type are listed in this order and separated by '|' character
Advantages are separated by # character.
GRPCONF_BANKING
Tinyint(1)Enable/disabled administrator banking module :
1: Enable0: Disable
Default: 0
GRPCONF_BAREMESEXCEPTION
TextList of exceptional scales.
Each scale is described by :
- Scale's unique identifier
- Scale's name
- Work unit's type : List of TAB_TYPEHEURE.TYPEH_REF separated by '_' character, with TAB_TYPEHEURE.TYPEH_TYPEACTIVITE ∈ {3,4} & TAB_TYPEHEURE.ID_SOCIETE = TAB_GROUPECONFIG.ID_SOCIETE
- Enable/disable to add it by default to each new contract :
1: Enable0: Disable
- Scale's unique identifier/name, work unit's type & add it by default activation are listed in this order and separated by '|' character
Scales are separated by # character.
Example:
"2|Astreinte|10_11|0"
GRPCONF_BDC_COMMENTS_ON_PDF
Tinyint(1)Enable/disable show comments by default on times reports customer pdf
1: Enable0: Disable
Default: 0
GRPCONF_BDC_MERGE_INVOICE_ATTACHMENTS
Tinyint(1)Enable/disable merge invoice attachments
1: Enable0: Disable
Default: 0
GRPCONF_BDC_RESOURCE_FULLNAME_ON_PDF
Tinyint(1)Enable/disable show resource fullname by default on times reports customer pdf
1: Enable0: Disable
Default: 0
GRPCONF_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: Enable0: Disable
Default: 0
GRPCONF_BDC_WORK_UNIT_TYPE_NAME_ON_PDF
Tinyint(1)Enable/disable show work unit type name by default on times reports customer pdf
1: Enable0: Disable
Default: 0
GRPCONF_BDCALLOWMULTITVA
Tinyint(1)Enable/disable multiple tax rates on orders
1: Enable0: Disable
Default: 0
GRPCONF_BDCATTACHEXPENSES
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_ATTACH_EXPENSES.
Default: 0
GRPCONF_BDCATTACHSIGNEDTIMESHEETS
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_ATTACH_SIGNED_TIMESHEETS.
Default: 0
GRPCONF_BDCATTACHUNSIGNEDTIMESHEETS
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_ATTACH_UNSIGNED_TIMESHEETS.
Default: 0
GRPCONF_BDCCONDREGLEMENT
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_CONDREGLEMENT.
Default: 0
GRPCONF_BDCEXPENSESEXCLUDINGTAX
Tinyint(1)Enable/disable to reinvoice expenses including tax or excluding tax
1: Excluding tax0: Including tax
Default: 0
GRPCONF_BDCGROUPEXPENSES
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_GROUPEXPENSES.
Default: 0
GRPCONF_BDCLISTETAUXTVA
TinytextDefault orders tax rates of TAB_BONDECOMMANDE.BDC_LISTETAUXTVA.
Tax rates are separated by | character.
Example:
20|10|5.5
GRPCONF_BDCREQUESTTIMESHEETSSIGNATURE
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_REQUEST_TIMESHEETS_SIGNATURE.
Default: 0
GRPCONF_BDCSENDINGMODE
Int(11)Sending mode : cf. key id for JSON response data.setting.sendingMode of API /application/dictionary.
Default: -1
GRPCONF_BDCSEPARATETPSFRS
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_SEPARATETPSFRS.
Default: 0
GRPCONF_BDCSHOWHEADOFFICE
Tinyint(1)Distinguish head office and billing details on each orders invoice.
Default: 1
GRPCONF_BDCSHOWJRSOUVRES
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_SHOWJRSOUVRES.
Default: 0
GRPCONF_BDCSHOWPRJREFERENCE
Tinyint(1)Default value of TAB_BONDECOMMANDE.BDC_SHOWPRJREFERENCE.
Default: 0
GRPCONF_BDCTAUXTVA
Decimal(15,5)Default order tax rate of TAB_BONDECOMMANDE.BDC_TAUXTVA.
Default: 0
GRPCONF_BDCTYPEPAYMENT
Int(11)Default value of TAB_BONDECOMMANDE.BDC_TYPEPAYMENT; cf. key id for JSON response data.setting.paymentMethod of API /application/dictionary
Default: -1
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 month1: Method 2, Absences taken an asked on all the period
Default: 0
GRPCONF_CERTIFICATIONACTIVITE
Tinyint(1)Enable/disable certification on activity expense :
1: Enable0: Disable
Default: 1
GRPCONF_CTRALLOWTEMPSEXCEPTION
Tinyint(1)Enable/disable exceptional activity configuration on contracts :
1: Enable0: Disable
Default: 0
GRPCONF_CTRAUTOFILLEXPENSES
Tinyint(1)Enable/disable prefill of expenses with contractual expenses details :
1: Enable0: Disable
Default: 1
GRPCONF_CTRDUREEHEBDOMADAIRE
Decimal(15,5)Default value of TAB_CONTRAT.CTR_DUREEHEBDOMADAIRE.
Default: 0
GRPCONF_CTRSALARYTYPE
Tinyint(1)Type of salary filled on contracts :
1: Annual0: Monthly
Default: 1
GRPCONF_DATEMAILFRAIS
Tinyint(2)Enable/disable the creation of expenses and sending to resources :
0: Disableinteger: Enable on the specified day of the month99: 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: Disableinteger: Enable on the specified day of the month99: Enable on the last day of the month
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: Enable0: Disable
Default: 0
GRPCONF_DEVISE
Int(11)Currency. cf. key id for JSON response data.setting.currency of API /application/dictionary
Default: 0
GRPCONF_DEVISLISTETAUXTVA
TinytextDefault quotations tax rates
Tax rates are separated by | character.
Example:
20|10|5.5
GRPCONF_DEVISSHOWAOREFERENCE
Tinyint(1)Default value of TAB_DEVIS.DEVIS_SHOWAOREFERENCE.
Default: 1
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: Enable0: Disable
Default: 0
GRPCONF_ETATAFTERMAILFACTURATION
Int(11)Bill's state to apply after sending an automatic email to contact.
cf. key id for JSON response data.setting.state.invoice of API /application/dictionary
Default: -1
GRPCONF_ETATBEFOREMAILFACTURATION
Int(11)Bill's state that will send an automatic email to contact.
cf. key id for JSON response data.setting.state.invoice of API /application/dictionary
Default: -1
GRPCONF_ETATFIXEFACTURATION
Varchar(250)List of bill's locking state :
- cf. key id for JSON response data.setting.state.bill of API /application/dictionary
- Each state is separated by
|character
Default: ''
Example:
"1|4|5"
GRPCONF_JDATERESSOURCEPLANNER
Tinyint(2)J Day used to calculate planned data :
0: Actual dayinteger: Specified day of the month99: The last day of the month
Default: 0
GRPCONF_MAILBCCFACTURATION
TextSender BCC email when sending PDF invoices :
currentManager: Invoice sender managermainManager: Invoice main managerprojectManager: Project main manager
Default: ''
GRPCONF_MAILCCFACTURATION
TextSender CC email when sending PDF invoices :
currentManager: Invoice sender managermainManager: Invoice main managerprojectManager: 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_NUMBEROFFAILEDLOGIN
Tinyint(1)Number of wrong credentials from the last login from X-Jwt-Client :
1: Enable0: 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: Enable0: Disable
Default: 0
GRPCONF_PRJALLOWTEMPSEXCEPTION
Tinyint(1)Enable/disable exceptional activity configuration on deliveries :
1: Enable0: Disable
Default: 0
GRPCONF_PRODUITALLOWMULTITVA
Tinyint(1)Enable/disable multiple tax rates on products
1: Enable0: Disable
Default: 0
GRPCONF_PRODUITLISTETAUXTVA
TinytextDefault 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
TextRequests 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: Enable0: 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_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"