Cash register dimension table
Table Name | Column Name | Column Type | Primary Key |
---|---|---|---|
Bi_DimCashRegister_s3 | CashRegisterPK | DECIMAL(190) | PK |
Bi_DimCashRegister_s3 | CashRegisterId | VARCHAR(36) | |
Bi_DimCashRegister_s3 | Code | NVARCHAR(128) | |
Bi_DimCashRegister_s3 | Name | NVARCHAR(1024) | |
Bi_DimCashRegister_s3 | Description | NVARCHAR(4096) | |
Bi_DimCashRegister_s3 | Active | BOOLEAN | |
Bi_DimCashRegister_s3 | CenterId | VARCHAR(36) | |
Bi_DimCashRegister_s3 | void | BOOLEAN | |
Bi_DimCashRegister_s3 | LastUpdated | TIMESTAMP | |
Bi_DimCashRegister_s3 | UpdatedBy | VARCHAR(36) | |
Bi_DimCashRegister_s3 | EnableInvoiceMirroring | INT | |
Bi_DimCashRegister_s3 | EtlLastUpdatedOn | TIMESTAMP | |
Bi_DimCashRegister_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |
Bi_DimCashRegister_s3 | PodName | VARCHAR(20) | |
Bi_DimCashRegister_s3 | OrganizationId | VARCHAR(36) | |
Bi_DimCashRegister_s3 | groupid | BIGINT |