STG_DBO¶
⚠️ Auto-generated — do not edit this file directly. Re-run
python scripts/generate_docs.pyto refresh it.
🪙 Staging layer
Cleaned and typed — ready for transformation
Schema: STG_DBO — 34 object(s)
| Table / View | Type | Rows | Columns | Description |
|---|---|---|---|---|
| ACCOUNT | BASE TABLE | 1,131 | 33 | — |
| ADDRESS | BASE TABLE | 668,406 | 22 | — |
| APINVOICE | BASE TABLE | 228,530 | 177 | — |
| APPAYMENT | BASE TABLE | 135,730 | 162 | — |
| APREGISTER | BASE TABLE | 352,293 | 132 | — |
| APTAX_TRAN | BASE TABLE | 149,309 | 70 | — |
| ARINVOICE | BASE TABLE | 192,385 | 235 | — |
| ARPAYMENT | BASE TABLE | 209,898 | 169 | — |
| ARREGISTER | BASE TABLE | 387,618 | 126 | — |
| ARTAX_TRAN | BASE TABLE | 195,543 | 70 | — |
| BACCOUNT | BASE TABLE | 668,406 | 42 | — |
| BATCH | BASE TABLE | 1,460,331 | 52 | — |
| BATCH_DOCUMENT_TYPE | BASE TABLE | 77 | 6 | — |
| BRANCH | BASE TABLE | 80 | 27 | — |
| CLIENTS | BASE TABLE | 643,885 | 18 | — |
| CUSTOMER | BASE TABLE | 648,876 | 78 | — |
| ECRITURES | BASE TABLE | 4,474,699 | 47 | — |
| FOURNISSEURS | BASE TABLE | 19,546 | 39 | — |
| GLTRAN | BASE TABLE | 4,160,420 | 73 | — |
| JOURNAL_TRANSACTION | BASE TABLE | 1,420,361 | 7 | — |
| LEDGER | BASE TABLE | 2 | 18 | — |
| LOCATION | BASE TABLE | 668,315 | 97 | — |
| ORGANIZATION | BASE TABLE | 80 | 39 | — |
| ORGANIZATION_BACCOUNT | BASE TABLE | 80 | 38 | — |
| PIECE_ACHAT | BASE TABLE | 694,641 | 38 | — |
| PIECE_CLIENT | BASE TABLE | 490,579 | 44 | — |
| PLAN_COMPTABLE | BASE TABLE | 1,129 | 24 | — |
| SECTIONS_ANALYTIQUES | BASE TABLE | 144,742 | 9 | — |
| SOCIETES | BASE TABLE | 79 | 20 | — |
| SUB | BASE TABLE | 152,353 | 15 | — |
| SUBLEDGER | BASE TABLE | 26 | 14 | — |
| USERS | BASE TABLE | 91 | 54 | — |
| VENDOR | BASE TABLE | 19,714 | 78 | — |
| VENDOR_PAYMENT_METHOD_DETAIL | BASE TABLE | 25,528 | 14 | — |