Skip to content

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 — 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