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