Product vendors dimension table
Bi_DimProductVendors
Field | Field type | Primary key |
|---|---|---|
ProductVendorWID | BIGINT | Yes |
ProductVendorId | VARCHAR(36) | |
ProductId | VARCHAR(36) | |
VendorId | VARCHAR(36) | |
PurchasePrice | FLOAT | |
IncludesTax | BOOLEAN | |
Discount | NVARCHAR(128) | |
void | BOOLEAN | |
TaxTypeId | VARCHAR(36) | |
VendorProductPartNumber | VARCHAR(8192) | |
CenterId | VARCHAR(36) | |
organizationid | VARCHAR(36) | |
etllastupdatedon | DATETIME | |
etllastupdatedby | VARCHAR(512) | |
PodName | VARCHAR(20) | |
groupID | BIGINT |