Vendor dimension table
bi_dimvendor
Field | Description | Field Type | Primary Key |
|---|---|---|---|
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
taxcharged | double precision | ||
vendoraddress1 | varchar ( 1024 ) | ||
vendoraddress2 | varchar ( 1024 ) | ||
vendorcity | varchar ( 512 ) | ||
vendorcode | varchar ( 1024 ) | ||
vendorcst | varchar ( 1024 ) | ||
vendordesc | varchar ( 65535 ) | ||
vendoremail | varchar ( 1024 ) | ||
vendorid | varchar ( 144 ) | ||
vendorname | varchar ( 1024 ) | ||
vendorstateother | varchar ( 512 ) | ||
vendortin | varchar ( 1024 ) | ||
vendorwid | bigint | ||
vendorworkphone | varchar ( 128 ) | ||
vendorworkphonecountryfk | integer | ||
vendorzipcode | varchar ( 128 ) | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |