Vendor dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimVendor_s3 | VendorId | VARCHAR(36) | PK | |
Bi_DimVendor_s3 | VendorName | NVARCHAR(512) | ||
Bi_DimVendor_s3 | VendorEmail | NVARCHAR(256) | ||
Bi_DimVendor_s3 | VendorAddress1 | NVARCHAR(256) | ||
Bi_DimVendor_s3 | VendorAddress2 | NVARCHAR(256) | ||
Bi_DimVendor_s3 | VendorCity | NVARCHAR(128) | ||
Bi_DimVendor_s3 | VendorStateOther | NVARCHAR(128) | ||
Bi_DimVendor_s3 | VendorZipCode | NVARCHAR(32) | ||
Bi_DimVendor_s3 | VendorWorkPhone | NVARCHAR(64) | ||
Bi_DimVendor_s3 | TaxCharged | FLOAT | ||
Bi_DimVendor_s3 | OrganizationID | VARCHAR(36) | ||
Bi_DimVendor_s3 | VendorCST | NVARCHAR(256) | ||
Bi_DimVendor_s3 | VendorTIN | NVARCHAR(256) | ||
Bi_DimVendor_s3 | VendorWorkPhoneCountryFk | INT | ||
Bi_DimVendor_s3 | VendorCode | NVARCHAR(512) | ||
Bi_DimVendor_s3 | VendorDesc | NVARCHAR(8000) | ||
Bi_DimVendor_s3 | Void | BOOLEAN | ||
Bi_DimVendor_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimVendor_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimVendor_s3 | PodName | VARCHAR(20) | ||
Bi_DimVendor_s3 | groupid | BIGINT |