Product batches dimension table
bi_dimProductBatches
Field | Field type | Primary key |
|---|---|---|
batchwid | BIGINT | Yes |
batchpk | DECIMAL(19,0) | |
batchid | VARCHAR(36) | |
batchnumber | VARCHAR(256) | |
ProductId | VARCHAR(36) | |
batchexpiry | TIMESTAMP | |
OrganizationId | VARCHAR(36) | |
Void | BOOLEAN | |
ETLLastUpdatedOn | TIMESTAMP | |
ETLLastUpdatedBy | VARCHAR(56) | |
Podname | VARCHAR(20) | |
groupid | BIGINT |