STG_DBO

⚠️ Auto-generated — do not edit this file directly. Re-run python scripts/generate_docs.py to refresh it.

🪙 Staging layer

Cleaned and typed — ready for transformation

Schema: STG_DBO — 147 object(s)

Table / View	Type	Rows	Columns	Description
ACHATS	BASE TABLE	207,715	237	—
ACHATS_NOTIF_ROLE_IDS	BASE TABLE	0	5	—
ACHATS_W027	BASE TABLE	0	24	—
ACHATS_W028	BASE TABLE	0	24	—
ACHATS_W029	BASE TABLE	0	24	—
ACHATS_W030	BASE TABLE	0	24	—
ACHATS_W031	BASE TABLE	0	24	—
ACHATS_W032	BASE TABLE	1,742	24	—
CLIENTS	BASE TABLE	5,795,965	65	—
FACTURE_AVOIR__3ID_DESAMIANTAGE000163	BASE TABLE	1	32	—
FACTURE_AVOIR__3ID_NORD000118	BASE TABLE	10	32	—
FACTURE_AVOIR__AB000132	BASE TABLE	10	32	—
FACTURE_AVOIR__ACA000112	BASE TABLE	39	32	—
FACTURE_AVOIR__ACA__TOULON000113	BASE TABLE	2	32	—
FACTURE_AVOIR__ADAV__AVIGNON000099	BASE TABLE	24	32	—
FACTURE_AVOIR__AIF000139	BASE TABLE	8	32	—
FACTURE_AVOIR__ALR000142	BASE TABLE	35	32	—
FACTURE_AVOIR__ALSACE_INTER000129	BASE TABLE	30	32	—
FACTURE_AVOIR__ALSACE_RENO000130	BASE TABLE	29	32	—
FACTURE_AVOIR__APA000140	BASE TABLE	19	32	—
FACTURE_AVOIR__AQA000127	BASE TABLE	55	32	—
FACTURE_AVOIR__ARA000160	BASE TABLE	16	32	—
FACTURE_AVOIR__ARM000107	BASE TABLE	20	32	—
FACTURE_AVOIR__ARM__LILLE000119	BASE TABLE	0	32	—
FACTURE_AVOIR__ARM__VANNES000120	BASE TABLE	0	32	—
FACTURE_AVOIR__ASSISTANCE_DROME_ARDECHE_VAUCLUSE000098	BASE TABLE	12	32	—
FACTURE_AVOIR__ASSISTANCE_ISERE000156	BASE TABLE	25	32	—
FACTURE_AVOIR__ASSISTANCE_LOIRE000020	BASE TABLE	1	32	—
FACTURE_AVOIR__ASSISTANCE_LORRAINE000164	BASE TABLE	6	32	—
FACTURE_AVOIR__ASSISTANCE_SAVOIE000157	BASE TABLE	30	32	—
FACTURE_AVOIR__ASTID_LES_3A000179	BASE TABLE	30	32	—
FACTURE_AVOIR__AUA__VICHY000138	BASE TABLE	0	32	—
FACTURE_AVOIR__AUBE_ASSISTANCE000155	BASE TABLE	13	32	—
FACTURE_AVOIR__AUVERGNE_ASSISTANCE000097	BASE TABLE	11	32	—
FACTURE_AVOIR__AUVERGNE_RHONE_ALPES_DESAMIANTAGE000171	BASE TABLE	2	32	—
FACTURE_AVOIR__AVL000159	BASE TABLE	9	32	—
FACTURE_AVOIR__BA000131	BASE TABLE	10	32	—
FACTURE_AVOIR__BRETAGNE_AMIANTE_ASSISTANCE000169	BASE TABLE	11	32	—
FACTURE_AVOIR__CLA000100	BASE TABLE	17	32	—
FACTURE_AVOIR__COTE_D_OPAL_ASSISTANCE000178	BASE TABLE	0	32	—
FACTURE_AVOIR__CTSA_EMBELLISSEMENT000149	BASE TABLE	4	32	—
FACTURE_AVOIR__CTSA_SINISTRE000146	BASE TABLE	18	32	—
FACTURE_AVOIR__CTSA_SINISTRES_MAINE_ANJOU000172	BASE TABLE	2	32	—
FACTURE_AVOIR__EDIFICE000174	BASE TABLE	22	32	—
FACTURE_AVOIR__FINANCIERE_LIFE000183	BASE TABLE	18	32	—
FACTURE_AVOIR__FINISTERE_NORD_ASSISTANCE000176	BASE TABLE	18	32	—
FACTURE_AVOIR__GILLI_SERVICES000180	BASE TABLE	22	32	—
FACTURE_AVOIR__GROUPE_3ID000153	BASE TABLE	1	32	—
FACTURE_AVOIR__HESTIA_MANAGEMENT_1000012	BASE TABLE	0	32	—
FACTURE_AVOIR__HESTIA_MANAGEMENT_2000185	BASE TABLE	0	32	—
FACTURE_AVOIR__HOME_LIFE000126	BASE TABLE	36	32	—
FACTURE_AVOIR__INT000007	BASE TABLE	2	32	—
FACTURE_AVOIR__JDC_I000115	BASE TABLE	37	32	—
FACTURE_AVOIR__JDC_I__BOULOGNE000117	BASE TABLE	0	32	—
FACTURE_AVOIR__JDC_R000116	BASE TABLE	31	32	—
FACTURE_AVOIR__LA000143	BASE TABLE	19	32	—
FACTURE_AVOIR__LORRAINE_INTERVENTION000150	BASE TABLE	20	32	—
FACTURE_AVOIR__MAINE_ET_LOIRE_ASSISTANCE000177	BASE TABLE	9	32	—
FACTURE_AVOIR__MASTERCLEAN_INTERVENTION000124	BASE TABLE	9	32	—
FACTURE_AVOIR__MI000114	BASE TABLE	40	32	—
FACTURE_AVOIR__MORBIHAN_ASSISTANCE000154	BASE TABLE	2	32	—
FACTURE_AVOIR__MPA000125	BASE TABLE	27	32	—
FACTURE_AVOIR__NI000135	BASE TABLE	20	32	—
FACTURE_AVOIR__NMA000161	BASE TABLE	24	32	—
FACTURE_AVOIR__NORD_AMIANTE_ASSISTANCE000166	BASE TABLE	2	32	—
FACTURE_AVOIR__NORMANDIE_EMBELLISSEMENT000152	BASE TABLE	4	32	—
FACTURE_AVOIR__NORMANDIE_FORMATION_PROPRETE000010	BASE TABLE	6	32	—
FACTURE_AVOIR__NORMANDIE_INTERVENTION000151	BASE TABLE	5	32	—
FACTURE_AVOIR__NP000136	BASE TABLE	5	32	—
FACTURE_AVOIR__NR000137	BASE TABLE	37	32	—
FACTURE_AVOIR__NUWA_ENVIRONNEMENT000158	BASE TABLE	11	32	—
FACTURE_AVOIR__PBA000122	BASE TABLE	11	32	—
FACTURE_AVOIR__PCA000141	BASE TABLE	24	32	—
FACTURE_AVOIR__PLA000128	BASE TABLE	20	32	—
FACTURE_AVOIR__POITOU_CHARENTE_BAT__POITIERS000144	BASE TABLE	17	32	—
FACTURE_AVOIR__PRCC000175	BASE TABLE	14	32	—
FACTURE_AVOIR__REAS_CTSA_SINISTRES000173	BASE TABLE	10	32	—
FACTURE_AVOIR__RESILIANS_DEVELOPPEMENT000014	BASE TABLE	1	32	—
FACTURE_AVOIR__RESILIANS_RESEAU000011	BASE TABLE	1	32	—
FACTURE_AVOIR__RESILIANS_SERVICES000186	BASE TABLE	0	32	—
FACTURE_AVOIR__RESILIANS_SOLUTION000201	BASE TABLE	0	32	—
FACTURE_AVOIR__RESILIANS_SOLUTION000201_DSK	BASE TABLE	1	4	—
FACTURE_AVOIR__RESILIANS_SOLUTION000201_IDT	BASE TABLE	2	4	—
FACTURE_AVOIR__RESILIANS_SOLUTION000201_LCK	BASE TABLE	0	8	—
FACTURE_AVOIR__RESILIANS_SOLUTION000201_PAG	BASE TABLE	0	6	—
FACTURE_AVOIR__RESILIANS_SOLUTION000201_PGT	BASE TABLE	0	7	—
FACTURE_AVOIR__RESILIANS_SOLUTION000201_SEC	BASE TABLE	0	23	—
FACTURE_AVOIR__SARTHE_ASSISTANCE000202	BASE TABLE	2	32	—
FACTURE_AVOIR__SARTHE_ASSISTANCE000202_DSK	BASE TABLE	1	4	—
FACTURE_AVOIR__SARTHE_ASSISTANCE000202_IDT	BASE TABLE	2	4	—
FACTURE_AVOIR__SARTHE_ASSISTANCE000202_LCK	BASE TABLE	0	8	—
FACTURE_AVOIR__SARTHE_ASSISTANCE000202_PAG	BASE TABLE	3	6	—
FACTURE_AVOIR__SARTHE_ASSISTANCE000202_PGT	BASE TABLE	3	7	—
FACTURE_AVOIR__SARTHE_ASSISTANCE000202_SEC	BASE TABLE	2	23	—
FACTURE_AVOIR__SOA000106	BASE TABLE	23	32	—
FACTURE_AVOIR__TISSOT000162	BASE TABLE	21	32	—
FACTURE_AVOIR__TTB_DESAMIANTAGE_GILLI000181	BASE TABLE	19	32	—
FACTURE_AVOIR__VAD__BREST000168	BASE TABLE	0	32	—
FACTURE_AVOIR__VA_DEVELOPPEMENT000167	BASE TABLE	35	32	—
FACTURE_AVOIR__VENDEE_ASSISTANCE000165	BASE TABLE	23	32	—
FACTURE_AVOIR__VET_9000170	BASE TABLE	3	32	—
FACTURE_AVOIR__VITALE_ASSISTANCE000123	BASE TABLE	1	32	—
INT_ACHATS_NOTIF_ROLE_IDS	BASE TABLE	197	5	—
INT_ACHATS_W011	BASE TABLE	0	24	—
INT_ACHATS_W012	BASE TABLE	0	24	—
INT_ACHATS_W013	BASE TABLE	0	24	—
INT_ACHATS_W014	BASE TABLE	0	24	—
INT_ACHATS_W015	BASE TABLE	0	24	—
INT_ACHATS_W016	BASE TABLE	0	24	—
INT_ACHATS_W017	BASE TABLE	4	24	—
INT_ACHATS_W018	BASE TABLE	4	24	—
INT_ACHATS_W019	BASE TABLE	0	24	—
INT_ACHATS_W020	BASE TABLE	0	24	—
INT_ACHATS_W021	BASE TABLE	0	24	—
INT_ACHATS_W022	BASE TABLE	0	24	—
NOUVEAU_BAC_1000199	BASE TABLE	0	32	—
NOUVEAU_BAC_1000199_DSK	BASE TABLE	1	4	—
NOUVEAU_BAC_1000199_IDT	BASE TABLE	2	4	—
NOUVEAU_BAC_1000199_LCK	BASE TABLE	0	8	—
NOUVEAU_BAC_1000199_PAG	BASE TABLE	0	6	—
NOUVEAU_BAC_1000199_PGT	BASE TABLE	0	7	—
NOUVEAU_BAC_1000199_SEC	BASE TABLE	0	23	—
RESILIANS_SOLUTIONS000200	BASE TABLE	0	32	—
RESILIANS_SOLUTIONS000200_DSK	BASE TABLE	1	4	—
RESILIANS_SOLUTIONS000200_IDT	BASE TABLE	2	4	—
RESILIANS_SOLUTIONS000200_LCK	BASE TABLE	0	8	—
RESILIANS_SOLUTIONS000200_PAG	BASE TABLE	0	6	—
RESILIANS_SOLUTIONS000200_PGT	BASE TABLE	0	7	—
RESILIANS_SOLUTIONS000200_SEC	BASE TABLE	0	23	—
RH	BASE TABLE	345	94	—
RH_AUD	BASE TABLE	668	10	—
RH_COMMENTAIRES	BASE TABLE	0	5	—
RH_DEL	BASE TABLE	0	5	—
RH_DSK	BASE TABLE	1	4	—
RH_EVNT	BASE TABLE	236	9	—
RH_HTRY	BASE TABLE	6	8	—
RH_IDT	BASE TABLE	3	4	—
RH_LCK	BASE TABLE	0	8	—
RH_PAG	BASE TABLE	696	6	—
RH_PGT	BASE TABLE	696	7	—
RH_SEC	BASE TABLE	345	22	—
RH_SHOT	BASE TABLE	0	8	—
RH_STTR	BASE TABLE	0	9	—
RH_STTW	BASE TABLE	0	7	—
RH_VRS	BASE TABLE	0	6	—
RH_W001	BASE TABLE	0	24	—
RH_W002	BASE TABLE	0	24	—