Package center dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
Bi_DimPackageCenter_s3 | PackageCenterId | varchar(36) | PK | |
Bi_DimPackageCenter_s3 | PackageId | varchar(36) | ||
Bi_DimPackageCenter_s3 | CenterId | varchar(36) | ||
Bi_DimPackageCenter_s3 | PackageVersionId | varchar(36) | ||
Bi_DimPackageCenter_s3 | Price | NUMERIC(19,4) | ||
Bi_DimPackageCenter_s3 | CenterTaxId | varchar(36) | ||
Bi_DimPackageCenter_s3 | AutoRenewalPrice | float | ||
Bi_DimPackageCenter_s3 | RenewalDiscount | varchar(150) | ||
Bi_DimPackageCenter_s3 | Active | BOOLEAN | ||
Bi_DimPackageCenter_s3 | CalculateServiceLevelTax | BOOLEAN | ||
Bi_DimPackageCenter_s3 | EnableItemLevelTax | INT | ||
Bi_DimPackageCenter_s3 | Void | BOOLEAN | ||
Bi_DimPackageCenter_s3 | OrganizationId | varchar(36) | ||
Bi_DimPackageCenter_s3 | tpcImportId | BIGINT | ||
Bi_DimPackageCenter_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimPackageCenter_s3 | EtlLastUpdatedBy | VARCHAR(50) | ||
Bi_DimPackageCenter_s3 | PodName | VARCHAR(20) | ||
Bi_DimPackageCenter_s3 | groupid | BIGINT |