{"id":6683,"date":"2024-09-05T16:16:19","date_gmt":"2024-09-05T16:16:19","guid":{"rendered":"https:\/\/techhub.saworks.io\/?post_type=docs&p=6683"},"modified":"2025-08-14T10:17:31","modified_gmt":"2025-08-14T10:17:31","slug":"8-modifications-de-la-base-de-donnees","status":"publish","type":"docs","link":"https:\/\/techhub.saworks.io\/fr\/docs\/comptabilite\/specification-comptable-possible\/8-modifications-de-la-base-de-donnees\/","title":{"rendered":"8. Modifications de la base de donn\u00e9es"},"content":{"rendered":"\n
\n

8.1 Table du Plan Comptable (acc_coa)<\/strong><\/h3>\n\n\n\n

Cette table stocke le Plan Comptable<\/strong> d’une organisation.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Nom de colonne<\/th>Type de donn\u00e9es<\/th>Description<\/th><\/tr><\/thead>
id<\/code><\/td>int<\/td>Identifiant unique<\/td><\/tr>
gl_code<\/code><\/td>varchar(45)<\/td>Code du compte g\u00e9n\u00e9ral<\/td><\/tr>
category<\/code><\/td>varchar(45)<\/td>Cat\u00e9gorie du compte : \u201cactif\u201d, \u201crevenu\u201d, \u201cd\u00e9pense\u201d, \u201cpassif\u201d ou \u201ccapitaux propres\u201d<\/td><\/tr>
parent_id<\/code><\/td>int<\/td>R\u00e9f\u00e9rence \u00e0 l\u2019id<\/code> de la table m_acc_coa<\/code> pour permettre une hi\u00e9rarchie<\/td><\/tr>
name<\/code><\/td>varchar(45)<\/td>Nom du compte<\/td><\/tr>
type<\/code><\/td>varchar(45)<\/td>\u201cheader\u201d ou \u201cdetail\u201d. Les comptes de type \u201cheader\u201d ne peuvent pas avoir de transactions<\/td><\/tr>
description<\/code><\/td>varchar(500)<\/td>Description du compte<\/td><\/tr>
disabled<\/code><\/td>Boolean<\/td>Indique si le compte est d\u00e9sactiv\u00e9 (non supprim\u00e9). Aucun mouvement manuel ne peut y \u00eatre enregistr\u00e9<\/td><\/tr>
manual_entries_allowed<\/code><\/td>Boolean<\/td>Indique si des \u00e9critures manuelles peuvent \u00eatre pass\u00e9es sur ce compte<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

8.2 Modifications du produit de pr\u00eat (m_product_loan)<\/strong><\/h3>\n\n\n\n

Cette table stocke les r\u00e8gles comptables associ\u00e9es \u00e0 un produit de pr\u00eat.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Nom de colonne<\/th>Type de donn\u00e9es<\/th>Description<\/th><\/tr><\/thead>
accounting_rule<\/code><\/td>varchar(45)<\/td>Type de comptabilit\u00e9 : \u201caucune\u201d, \u201cencaisse\u201d ou \u201caccrual\u201d (comptabilit\u00e9 d\u2019exercice)<\/td><\/tr>
\u27a1\ufe0f Choisir \u201caucune\u201d d\u00e9sactive l\u2019enregistrement de toutes les transactions comptables.<\/td><\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

8.3 Table de liaison produit-plan comptable (acc_product_coa_mapping)<\/strong><\/h3>\n\n\n\n

Cette table fait le lien entre les codes GL<\/strong> utilis\u00e9s par un produit de pr\u00eat ou d\u2019\u00e9pargne.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Nom de colonne<\/th>Type de donn\u00e9es<\/th>Description<\/th><\/tr><\/thead>
id<\/code><\/td>int<\/td>Identifiant<\/td><\/tr>
acc_id<\/code><\/td>int<\/td>Cl\u00e9 \u00e9trang\u00e8re vers acc_coa<\/code><\/td><\/tr>
product_id<\/code><\/td>int<\/td>R\u00e9f\u00e9rence vers un produit de pr\u00eat ou d\u2019\u00e9pargne<\/td><\/tr>
product_type<\/code><\/td>varchar(45)<\/td>\u201cloan\u201d ou \u201csaving\u201d<\/td><\/tr>
financial_account_type<\/code><\/td>varchar(45)<\/td>Type de compte financier (ex : \u201cCash\u201d, \u201cInt\u00e9r\u00eats sur pr\u00eat\u201d)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

8.4 \u00c9critures comptables (acc_journal_entry)<\/strong><\/h3>\n\n\n\n

Cette table stocke toutes les \u00e9critures comptables<\/strong> g\u00e9n\u00e9r\u00e9es dans le syst\u00e8me (automatiquement ou manuellement).<\/p>\n\n\n\n

<\/div>\n\n\n\n
Nom de colonne<\/th>Type de donn\u00e9es<\/th>Description<\/th><\/tr><\/thead>
id<\/code><\/td>int<\/td>Cl\u00e9 primaire de l\u2019\u00e9criture<\/td><\/tr>
coa_id<\/code><\/td>int<\/td>Cl\u00e9 \u00e9trang\u00e8re vers la table acc_coa<\/code><\/td><\/tr>
entry_date<\/code><\/td>datetime<\/td>Date de l\u2019\u00e9criture (peut \u00eatre antidat\u00e9e)<\/td><\/tr>
batch_id<\/code><\/td>varchar(45)<\/td>Identifiant de lot, peut \u00eatre un UUID g\u00e9n\u00e9r\u00e9 par Java<\/td><\/tr>
type<\/code><\/td>varchar(45)<\/td>\u201cdebit\u201d ou \u201ccredit\u201d<\/td><\/tr>
amount<\/code><\/td>float<\/td>Montant<\/td><\/tr>
description<\/code><\/td>varchar(500)<\/td>Notes utilisateur pour les \u00e9critures manuelles<\/td><\/tr>
branch_id<\/code><\/td>int<\/td>Agence associ\u00e9e \u00e0 l\u2019\u00e9criture<\/td><\/tr>
reversal_id<\/code><\/td>int<\/td>Cl\u00e9 \u00e9trang\u00e8re vers une \u00e9criture invers\u00e9e<\/td><\/tr>
is_reversed<\/code><\/td>Boolean<\/td>Indique si l\u2019\u00e9criture a \u00e9t\u00e9 invers\u00e9e (une seule fois possible)<\/td><\/tr>
entity_type<\/code><\/td>varchar(45)<\/td>\u201cLoan\u201d ou \u201cSavings\u201d pour les \u00e9critures syst\u00e8me, null pour les \u00e9critures manuelles<\/td><\/tr>
entity_id<\/code><\/td>int<\/td>Cl\u00e9 \u00e9trang\u00e8re facultative vers un pr\u00eat ou un compte d\u2019\u00e9pargne<\/td><\/tr>
system_generated<\/code><\/td>Boolean<\/td>Indique si l\u2019\u00e9criture a \u00e9t\u00e9 g\u00e9n\u00e9r\u00e9e automatiquement<\/td><\/tr>
created_date<\/code><\/td>date<\/td>Date r\u00e9elle de cr\u00e9ation de l\u2019\u00e9criture<\/td><\/tr>
created_by<\/code><\/td>varchar(45)<\/td>Cl\u00e9 \u00e9trang\u00e8re vers l\u2019utilisateur ayant cr\u00e9\u00e9 l\u2019\u00e9criture (manuelle)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

8.5 Cl\u00f4ture des comptes d\u2019agence (acc_closure)<\/strong><\/h3>\n\n\n\n

Cette table stocke les d\u00e9tails de cl\u00f4ture comptable<\/strong> par agence et par date.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Nom de colonne<\/th>Type de donn\u00e9es<\/th>Description<\/th><\/tr><\/thead>
id<\/code><\/td>int<\/td>Identifiant<\/td><\/tr>
closing_date<\/code><\/td>date<\/td>Date de cl\u00f4ture<\/td><\/tr>
office_id<\/code><\/td>int<\/td>Identifiant de l\u2019agence concern\u00e9e<\/td><\/tr>
created_by<\/code><\/td>varchar(45)<\/td>Utilisateur ayant effectu\u00e9 la cl\u00f4ture<\/td><\/tr>
created_date<\/code><\/td>date<\/td>Date de cr\u00e9ation de l\u2019enregistrement<\/td><\/tr>
last_updated_date<\/code><\/td>date<\/td>Derni\u00e8re mise \u00e0 jour<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

8.1 Table du Plan Comptable (acc_coa) Cette table stocke le Plan Comptable d’une organisation. Nom de colonne Type de donn\u00e9es Description id int Identifiant unique […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":6631,"menu_order":4,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"doc_badge":[],"class_list":["post-6683","docs","type-docs","status-publish","hentry"],"author_avatar":"https:\/\/secure.gravatar.com\/avatar\/6a70e7c73db9f245e650948d09d74f61?s=96&d=mm&r=g","author_name":"Annick N'dri","_links":{"self":[{"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/docs\/6683"}],"collection":[{"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/comments?post=6683"}],"version-history":[{"count":0,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/docs\/6683\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/docs\/6631"}],"wp:attachment":[{"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/media?parent=6683"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/doc_tag?post=6683"},{"taxonomy":"doc_badge","embeddable":true,"href":"https:\/\/techhub.saworks.io\/fr\/wp-json\/wp\/v2\/doc_badge?post=6683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}