Service center dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimServiceCenter_s3 | ServiceCenterId | VARCHAR(36) | PK | |
Bi_DimServiceCenter_s3 | ServiceId | VARCHAR(36) | ||
Bi_DimServiceCenter_s3 | CenterId | VARCHAR(36) | ||
Bi_DimServiceCenter_s3 | ServicePrice | DECIMAL(19,4) | ||
Bi_DimServiceCenter_s3 | IncludesTax | BOOLEAN | ||
Bi_DimServiceCenter_s3 | CenterTaxId | VARCHAR(36) | ||
Bi_DimServiceCenter_s3 | SSGValue | FLOAT | ||
Bi_DimServiceCenter_s3 | DemandGroupId | VARCHAR(36) | ||
Bi_DimServiceCenter_s3 | MemberServicePrice | DECIMAL(19,4) | ||
Bi_DimServiceCenter_s3 | Void | BOOLEAN | ||
Bi_DimServiceCenter_s3 | ShowInCatalog | BOOLEAN | ||
Bi_DimServiceCenter_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimServiceCenter_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimServiceCenter_s3 | PodName | VARCHAR(20) | ||
Bi_DimServiceCenter_s3 | OrganizationId | VARCHAR(36) | ||
Bi_DimServiceCenter_s3 | groupid | BIGINT | ||
Bi_DimServiceCenter_s3 | taxgroupid | VARCHAR(36) | ||
Bi_DimServiceCenter_s3 | taxgroupname | NVARCHAR(1020) |