PIECE_CLIENT

⚠️ 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	490,579
Columns	44

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_ID	TEXT	✅	—	—
2	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
3	DATE	TIMESTAMP_TZ	✅	—	—
4	REFERENCE_NBR_2	TEXT	✅	—	—
5	REFERENCE_NBR_3	TEXT	✅	—	—
6	CLOSED_DATE	TIMESTAMP_TZ	✅	—	—
7	DOCUMENT_DESCRIPTION	TEXT	✅	—	—
8	NUMFACTU	TEXT	✅	—	—
9	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
10	DESCRIPTION	TEXT	✅	—	—
11	DESCRIPTION_2	TEXT	✅	—	—
12	SOURCE	TEXT	✅	—	—
13	TYPE	TEXT	✅	—	—
14	BRANCH	TEXT	✅	—	—
15	SOLDE_LC	FLOAT	✅	—	—
16	BATCH_NBR	TEXT	✅	—	—
17	BRANCH_NAME	TEXT	✅	—	—
18	ARACCOUNT	NUMBER	✅	—	—
19	NDAFFAIRE_2	TEXT	✅	—	—
20	TYPE_3	TEXT	✅	—	—
21	CREEPAR	TEXT	✅	—	—
22	TYPE_2	TEXT	✅	—	—
23	LAST_MODIFIED_ON	TIMESTAMP_TZ	✅	—	—
24	DUE_DATE	TIMESTAMP_TZ	✅	—	—
25	DONNEURDORDRE	TEXT	✅	—	—
26	ARSUBACCOUNT	TEXT	✅	—	—
27	PAYMENT_REF	TEXT	✅	—	—
28	SOLDE_DSO	FLOAT	✅	—	—
29	CREATED_ON	TIMESTAMP_NTZ	✅	—	—
30	TOTAL_AMOUNT	FLOAT	✅	—	—
31	NDAFFAIRE	TEXT	✅	—	—
32	CASH_DISCOUNT	FLOAT	✅	—	—
33	APPLICATION_DATE	TIMESTAMP_TZ	✅	—	—
34	CUSTOMER_NAME	TEXT	✅	—	—
35	REFERENCE_NBR	TEXT	✅	—	—
36	CUSTOMER_ID	TEXT	✅	—	—
37	CUSTOMER_ORDER_NBR	TEXT	✅	—	—
38	UNPAID_BALANCE	FLOAT	✅	—	—
39	STATUS	TEXT	✅	—	—
40	CUSTOMER	TEXT	✅	—	—
41	POST_PERIOD	TEXT	✅	—	—
42	TAX_TOTAL	FLOAT	✅	—	—
43	INVOICE_REF_RAPPRO	TEXT	✅	—	—
44	PAYMENT_REF_RAPPRO	TEXT	✅	—	—