Skip to main content

Product center dimension table

Bi_DimProductCenter_s3

ProductCenterId

VARCHAR(36)

PK

Bi_DimProductCenter_s3

ProductId

VARCHAR(36)

Bi_DimProductCenter_s3

CenterId

VARCHAR(36)

Bi_DimProductCenter_s3

SalePrice

DECIMAL(19,4)

Bi_DimProductCenter_s3

IncludesTax

BOOLEAN

Bi_DimProductCenter_s3

CenterTaxId

VARCHAR(36)

Bi_DimProductCenter_s3

Void

BOOLEAN

Bi_DimProductCenter_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimProductCenter_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimProductCenter_s3

PodName

VARCHAR(20)

Bi_DimProductCenter_s3

OrganizationId

VARCHAR(36)

Bi_DimProductCenter_s3

DesiredInventory

float

Bi_DimProductCenter_s3

OrderInventory

float

Bi_DimProductCenter_s3

AlertInventory

float

Bi_DimProductCenter_s3

ConsumableDesiredInventory

float

Bi_DimProductCenter_s3

ConsumableOrderInventory

float

Bi_DimProductCenter_s3

ConsumableAlertInventory

float

Bi_DimProductCenter_s3

groupid

BIGINT

Bi_DimProductCenter_s3

taxgroupid

VARCHAR(36)

Bi_DimProductCenter_s3

taxgroupname

NVARCHAR(1020)