ECRITURES

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

Info

Property	Value
Source	CEGID
Database	RESILIANS_CEGID_DB
Schema	STG_DBO
Layer	🪙 Staging
Type	BASE TABLE
Rows	4,474,699
Columns	47

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_ID	TEXT	✅	—	—
2	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
3	DATE	TIMESTAMP_TZ	✅	—	—
4	REF_NUMBER	TEXT	✅	—	—
5	REFERENCE_NBR_2	TEXT	✅	—	—
6	CODE	TEXT	✅	—	—
7	BATCH_NUMBER	TEXT	✅	—	—
8	NOMSOCIETE	TEXT	✅	—	—
9	REVERSING_ENTRY	BOOLEAN	✅	—	—
10	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
11	DESCRIPTION	TEXT	✅	—	—
12	DEBIT_AMOUNT	FLOAT	✅	—	—
13	TYPE	TEXT	✅	—	—
14	MATCHING	TEXT	✅	—	—
15	AUTO_REVERSING	BOOLEAN	✅	—	—
16	BRANCH_ID	TEXT	✅	—	—
17	ACCOUNT_NAME	TEXT	✅	—	—
18	CODESOCIETE	TEXT	✅	—	—
19	GLTRAN_LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
20	MODULE_3	TEXT	✅	—	—
21	PERIOD_ID	TEXT	✅	—	—
22	GLTRAN_CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
23	LEDGER_ID	TEXT	✅	—	—
24	TRANSACTION_DATE	TIMESTAMP_TZ	✅	—	—
25	TYPE_2	TEXT	✅	—	—
26	MODULE_2	TEXT	✅	—	—
27	BATCH_NUMBER_3	TEXT	✅	—	—
28	SUBACCOUNT	TEXT	✅	—	—
29	BATCH_NUMBER_2	TEXT	✅	—	—
30	MODULE	TEXT	✅	—	—
31	CREDIT_AMOUNT	FLOAT	✅	—	—
32	DUE_DATE	TIMESTAMP_TZ	✅	—	—
33	MATCHINGDATE	TIMESTAMP_NTZ	✅	—	—
34	NOMDELAPLATEFORME	TEXT	✅	—	—
35	TRANSACTION_DESCRIPTION	TEXT	✅	—	—
36	CASH_DISCOUNT_DATE	TIMESTAMP_TZ	✅	—	—
37	LINE_NBR	NUMBER	✅	—	—
38	PAYMENT_REF	TEXT	✅	—	—
39	ACCOUNT_ID	TEXT	✅	—	—
40	ANCIEN_NFEC	TEXT	✅	—	—
41	REFERENCE_NBR	TEXT	✅	—	—
42	CUSTOMER_ORDER_NBR	TEXT	✅	—	—
43	FAMILLEDECRITURES	TEXT	✅	—	—
44	STATUS_2	TEXT	✅	—	—
45	ACCOUNT	NUMBER	✅	—	—
46	STATUS	TEXT	✅	—	—
47	STATUS_3	TEXT	✅	—	—