PIECE_ACHAT

⚠️ 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	694,641
Columns	38

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	CLOSED_DATE	TIMESTAMP_TZ	✅	—	—
6	NUMFACTU	TEXT	✅	—	—
7	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
8	DESCRIPTION	TEXT	✅	—	—
9	DESCRIPTION_2	TEXT	✅	—	—
10	SOURCE	TEXT	✅	—	—
11	LIEN_DOCU_WARE	TEXT	✅	—	—
12	TYPE	TEXT	✅	—	—
13	BRANCH	TEXT	✅	—	—
14	SOLDE_LC	FLOAT	✅	—	—
15	BATCH_NBR	TEXT	✅	—	—
16	VENDOR	TEXT	✅	—	—
17	BRANCH_NAME	TEXT	✅	—	—
18	APACCOUNT	NUMBER	✅	—	—
19	TYPE_3	TEXT	✅	—	—
20	CREEPAR	TEXT	✅	—	—
21	TYPE_2	TEXT	✅	—	—
22	LAST_MODIFIED_ON	TIMESTAMP_TZ	✅	—	—
23	NOMDELAPLATEFORME	TEXT	✅	—	—
24	PAYMENT_REF	TEXT	✅	—	—
25	VENDOR_2	TEXT	✅	—	—
26	ACCOUNT_ID	TEXT	✅	—	—
27	SOLDE_DSO	FLOAT	✅	—	—
28	CREATED_ON	TIMESTAMP_NTZ	✅	—	—
29	TOTAL_AMOUNT	FLOAT	✅	—	—
30	APSUBACCOUNT	TEXT	✅	—	—
31	NDAFFAIRE	TEXT	✅	—	—
32	CASH_DISCOUNT	FLOAT	✅	—	—
33	IDDOCU_WARE	NUMBER	✅	—	—
34	VENDOR_REF	TEXT	✅	—	—
35	REFERENCE_NBR	TEXT	✅	—	—
36	POST_PERIOD	TEXT	✅	—	—
37	TAX_TOTAL	FLOAT	✅	—	—
38	APPROVEDFOR_PAYMENT	BOOLEAN	✅	—	—