VENDOR

⚠️ 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	19,714
Columns	78

Columns

#	Column	Type	Nullable	Default	Description
1	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
2	IS_BRANCH	BOOLEAN	✅	—	—
3	ALLOW_OVERRIDE_RATE	BOOLEAN	✅	—	—
4	CEG_SIRET	TEXT	✅	—	—
5	LANDED_COST_VENDOR	BOOLEAN	✅	—	—
6	VENDOR_CLASS_ID	TEXT	✅	—	—
7	VSTATUS	TEXT	✅	—	—
8	USR_VALIDATE_IBAN	BOOLEAN	✅	—	—
9	CLASS_ID	TEXT	✅	—	—
10	SALES_TAX_SUB_ID	NUMBER	✅	—	—
11	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
12	TAX_AGENCY	BOOLEAN	✅	—	—
13	TYPE	TEXT	✅	—	—
14	IGNORE_CONFIGURED_DISCOUNTS	BOOLEAN	✅	—	—
15	RETAINAGE_APPLY	BOOLEAN	✅	—	—
16	RETAINAGE_PCT	FLOAT	✅	—	—
17	ACCT_REFERENCE_NBR	TEXT	✅	—	—
18	SVATINPUT_TAX_ENTRY_REF_NBR	TEXT	✅	—	—
19	CEG_APECODE	TEXT	✅	—	—
20	BASE_CURY_ID	TEXT	✅	—	—
21	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
22	TAX_USE_VENDOR_CUR_PRECISION	BOOLEAN	✅	—	—
23	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
24	ALLOW_OVERRIDE_CURY	BOOLEAN	✅	—	—
25	AUTO_GENERATE_TAX_BILL	BOOLEAN	✅	—	—
26	IS_CUSTOMER_OR_COMBINED	BOOLEAN	✅	—	—
27	PURCH_TAX_SUB_ID	NUMBER	✅	—	—
28	PREPAYMENT_SUB_ID	NUMBER	✅	—	—
29	DEF_ADDRESS_ID	NUMBER	✅	—	—
30	PURCH_TAX_ACCT_ID	NUMBER	✅	—	—
31	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
32	CORG_BACCOUNT_ID	NUMBER	✅	—	—
33	PRIMARY_CONTACT_ID	NUMBER	✅	—	—
34	TSTAMP	TEXT	✅	—	—
35	POACCRUAL_SUB_ID	NUMBER	✅	—	—
36	SVATOUTPUT_TAX_ENTRY_REF_NBR	TEXT	✅	—	—
37	DELETED_DATABASE_RECORD	BOOLEAN	✅	—	—
38	SVATREVERSAL_METHOD	TEXT	✅	—	—
39	CREATED_BY_ID	TEXT	✅	—	—
40	STATUS	TEXT	✅	—	—
41	IS_LABOR_UNION	BOOLEAN	✅	—	—
42	PARENT_BACCOUNT_ID	NUMBER	✅	—	—
43	DEF_CONTACT_ID	NUMBER	✅	—	—
44	TAX_EXPENSE_SUB_ID	NUMBER	✅	—	—
45	PREPAYMENT_ACCT_ID	NUMBER	✅	—	—
46	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
47	DISC_TAKEN_ACCT_ID	NUMBER	✅	—	—
48	TERMS_ID	TEXT	✅	—	—
49	VORG_BACCOUNT_ID	NUMBER	✅	—	—
50	CURY_ID	TEXT	✅	—	—
51	TAX_REPORT_FIN_PERIOD	BOOLEAN	✅	—	—
52	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
53	CONSOLIDATING_BACCOUNT_ID	NUMBER	✅	—	—
54	CEG_NATURE	TEXT	✅	—	—
55	DISC_TAKEN_SUB_ID	NUMBER	✅	—	—
56	FOREIGN_ENTITY	BOOLEAN	✅	—	—
57	PSEUDONYMIZATION_STATUS	NUMBER	✅	—	—
58	LINE_DISCOUNT_TARGET	TEXT	✅	—	—
59	ACCT_CD	TEXT	✅	—	—
60	SALES_TAX_ACCT_ID	NUMBER	✅	—	—
61	LEGAL_NAME	TEXT	✅	—	—
62	ACCT_NAME	TEXT	✅	—	—
63	INCLUDED	BOOLEAN	✅	—	—
64	UPD_CLOSED_TAX_PERIODS	BOOLEAN	✅	—	—
65	NOTE_ID	TEXT	✅	—	—
66	CURY_RATE_TYPE_ID	TEXT	✅	—	—
67	TAX_REPORT_PRECISION	NUMBER	✅	—	—
68	BACCOUNT_ID	NUMBER	✅	—	—
69	TAX_REPORT_ROUNDING	TEXT	✅	—	—
70	TAX_REGISTRATION_ID	TEXT	✅	—	—
71	DEF_LOCATION_ID	NUMBER	✅	—	—
72	ATTRIBUTE_SSTRAITANT	NUMBER	✅	—	—
73	ATTRIBUTE_CODESAGE	TEXT	✅	—	—
74	TAX_PERIOD_TYPE	TEXT	✅	—	—
75	VENDOR_1099	BOOLEAN	✅	—	—
76	CONSOLIDATE_TO_PARENT	BOOLEAN	✅	—	—
77	PREBOOK_SUB_ID	NUMBER	✅	—	—
78	NOTE_TEXT	TEXT	✅	—	—