LOCATION

⚠️ 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	668,315
Columns	97

Columns

#	Column	Type	Nullable	Default	Description
1	BACCOUNT_ID	NUMBER	❌	—	—
2	LOCATION_CD	TEXT	✅	—	—
3	_FIVETRAN_SYNCED	TIMESTAMP_TZ	✅	—	—
4	VRCPT_QTY_THRESHOLD	FLOAT	✅	—	—
5	CORDER_PRIORITY	NUMBER	✅	—	—
6	IS_APACCOUNT_SAME_AS_MAIN	BOOLEAN	✅	—	—
7	CAVALARA_CUSTOMER_USAGE_TYPE	NUMBER	✅	—	—
8	VPAYMENT_INFO_LOCATION_ID	NUMBER	✅	—	—
9	CARACCOUNT_LOCATION_ID	NUMBER	✅	—	—
10	OVERRIDE_REMIT_ADDRESS	BOOLEAN	✅	—	—
11	LOCATION_ID	NUMBER	✅	—	—
12	IS_ADDRESS_SAME_AS_MAIN	BOOLEAN	✅	—	—
13	CINSURANCE	BOOLEAN	✅	—	—
14	OVERRIDE_REMIT_CONTACT	BOOLEAN	✅	—	—
15	CTAX_CALC_MODE	BOOLEAN	✅	—	—
16	ARACCOUNT_ID	NUMBER	✅	—	—
17	CASH_ACCOUNT_ID	NUMBER	✅	—	—
18	SEPARATE_CHECK	BOOLEAN	✅	—	—
19	CMPEXPENSE_SUB_ID	NUMBER	✅	—	—
20	IS_REMIT_ADDRESS_SAME_AS_MAIN	BOOLEAN	✅	—	—
21	DEF_ADDRESS_ID	NUMBER	✅	—	—
22	CMPSALES_SUB_ID	NUMBER	✅	—	—
23	LAST_MODIFIED_BY_SCREEN_ID	TEXT	✅	—	—
24	CEG_VECONOMIC_NATURE	TEXT	✅	—	—
25	IS_ARACCOUNT_SAME_AS_MAIN	BOOLEAN	✅	—	—
26	CFREIGHT_SUB_ID	NUMBER	✅	—	—
27	IS_CONTACT_SAME_AS_MAIN	BOOLEAN	✅	—	—
28	CSHIP_COMPLETE	TEXT	✅	—	—
29	VPRINT_ORDER	BOOLEAN	✅	—	—
30	STATUS	TEXT	✅	—	—
31	DEF_CONTACT_ID	NUMBER	✅	—	—
32	CMPGAIN_LOSS_SUB_ID	NUMBER	✅	—	—
33	VEXPENSE_SUB_ID	NUMBER	✅	—	—
34	VALLOW_APBILL_BEFORE_RECEIPT	BOOLEAN	✅	—	—
35	APRETAINAGE_SUB_ID	NUMBER	✅	—	—
36	CREATED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
37	VPREPAYMENT_PCT	FLOAT	✅	—	—
38	ARSUB_ID	NUMBER	✅	—	—
39	NOTE_ID	TEXT	✅	—	—
40	VRETAINAGE_SUB_ID	NUMBER	✅	—	—
41	VSITE_IDIS_NULL	NUMBER	✅	—	—
42	IS_ACTIVE	BOOLEAN	✅	—	—
43	CARSUB_ID	NUMBER	✅	—	—
44	TAX_REGISTRATION_ID	TEXT	✅	—	—
45	CDISCOUNT_SUB_ID	NUMBER	✅	—	—
46	CMPDISCOUNT_SUB_ID	NUMBER	✅	—	—
47	VRCPT_QTY_MIN	FLOAT	✅	—	—
48	VDEF_CONTACT_ID	NUMBER	✅	—	—
49	OVERRIDE_ADDRESS	BOOLEAN	✅	—	—
50	VPAYMENT_METHOD_ID	TEXT	✅	—	—
51	PAYMENT_LEAD_TIME	NUMBER	✅	—	—
52	VEXPENSE_ACCT_ID	NUMBER	✅	—	—
53	CSALES_SUB_ID	NUMBER	✅	—	—
54	CEG_SIRET	TEXT	✅	—	—
55	VFREIGHT_SUB_ID	NUMBER	✅	—	—
56	_FIVETRAN_DELETED	BOOLEAN	✅	—	—
57	VRCPT_QTY_MAX	FLOAT	✅	—	—
58	VPAYMENT_BY_TYPE	NUMBER	✅	—	—
59	APSUB_ID	NUMBER	✅	—	—
60	VEMAIL_ORDER	BOOLEAN	✅	—	—
61	VAPACCOUNT_LOCATION_ID	NUMBER	✅	—	—
62	LAST_MODIFIED_BY_ID	TEXT	✅	—	—
63	CSALES_ACCT_ID	NUMBER	✅	—	—
64	CTAX_ZONE_ID	TEXT	✅	—	—
65	VTAX_ZONE_ID	TEXT	✅	—	—
66	LAST_MODIFIED_DATE_TIME	TIMESTAMP_TZ	✅	—	—
67	CBRANCH_ID	NUMBER	✅	—	—
68	VTAX_CALC_MODE	TEXT	✅	—	—
69	APACCOUNT_ID	NUMBER	✅	—	—
70	IS_DEFAULT	BOOLEAN	✅	—	—
71	VAPSUB_ID	NUMBER	✅	—	—
72	CMPFREIGHT_SUB_ID	NUMBER	✅	—	—
73	CARACCOUNT_ID	NUMBER	✅	—	—
74	DESCR	TEXT	✅	—	—
75	VAPACCOUNT_ID	NUMBER	✅	—	—
76	TSTAMP	TEXT	✅	—	—
77	OVERRIDE_CONTACT	BOOLEAN	✅	—	—
78	VDEF_ADDRESS_ID	NUMBER	✅	—	—
79	CREATED_BY_ID	TEXT	✅	—	—
80	VREMIT_ADDRESS_ID	NUMBER	✅	—	—
81	VBRANCH_ID	NUMBER	✅	—	—
82	CREATED_BY_SCREEN_ID	TEXT	✅	—	—
83	IS_APPAYMENT_INFO_SAME_AS_MAIN	BOOLEAN	✅	—	—
84	VPAYMENT_LEAD_TIME	NUMBER	✅	—	—
85	VRCPT_QTY_ACTION	TEXT	✅	—	—
86	PSEUDONYMIZATION_STATUS	NUMBER	✅	—	—
87	VCASH_ACCOUNT_ID	NUMBER	✅	—	—
88	CRESEDENTIAL	BOOLEAN	✅	—	—
89	CSATURDAY_DELIVERY	BOOLEAN	✅	—	—
90	LOC_TYPE	TEXT	✅	—	—
91	PAYMENT_BY_TYPE	NUMBER	✅	—	—
92	VDISCOUNT_SUB_ID	NUMBER	✅	—	—
93	PAYMENT_METHOD_ID	TEXT	✅	—	—
94	VSEPARATE_CHECK	BOOLEAN	✅	—	—
95	VREMIT_CONTACT_ID	NUMBER	✅	—	—
96	CGROUND_COLLECT	BOOLEAN	✅	—	—
97	IS_REMIT_CONTACT_SAME_AS_MAIN	BOOLEAN	✅	—	—