Introduction
Changes in v105
This article contains a list of changes introduced with 1.05 ETL connector
Adding new table DimTaxRate
|
Table |
Column |
Description |
Datatype |
|
DimTaxRate |
TaxRateKey |
This is PK of table |
bigint |
|
DimTaxRate |
TaxId |
TaxId |
bigint |
|
DimTaxRate |
DateFrom |
tax rate start date |
date |
|
DimTaxRate |
DateTo |
tax rate end date |
date |
|
DimTaxRate |
ValueType |
Value or percentage |
nvarchar |
|
DimTaxRate |
ValueType |
Value or percentage |
sysname |
|
DimTaxRate |
Value |
Value |
decimal |
|
DimTaxRate |
IsDeleted |
if it is deleted |
bit |
|
DimTaxRate |
InAllClubs |
if it is in all clubs |
bit |
|
DimTaxRate |
MetaJobId |
NULL |
bigint |
|
DimTaxRate |
MetaDateInserted |
NULL |
datetime |
|
DimTaxRate |
MetaDateUpdated |
NULL |
datetime |
Adding new table DimProductTax
|
Table |
Column |
Description |
Datatype |
|
DimProductTax |
ProductTaxKey |
This is PK of table |
bigint |
|
DimProductTax |
ProductKey |
PK to DimProduct |
int |
|
DimProductTax |
TaxId |
Technical column with taxid |
bigint |
|
DimProductTax |
TaxName |
Name of tax |
nvarchar |
|
DimProductTax |
TaxName |
Name of tax |
sysname |
|
DimProductTax |
IsDeleted |
If tax is deleted |
bit |
|
DimProductTax |
MetaJobId |
NULL |
bigint |
|
DimProductTax |
MetaDateInserted |
NULL |
datetime |
|
DimProductTax |
MetaDateUpdated |
NULL |
datetime |
Adding new table DimCustomerTransactionType
|
Table |
Column |
Description |
Datatype |
|
DimCustomerTransactionType |
CustomerTransactionTypeKey |
This is PK of table |
bigint |
|
DimCustomerTransactionType |
CustomerTransactionTypeName |
Name of Customer Transaction Type |
nvarchar |
|
DimCustomerTransactionType |
CustomerTransactionTypeName |
Name of Customer Transaction Type |
sysname |
|
DimCustomerTransactionType |
CustomerTransactionTypeCode |
Code |
nvarchar |
|
DimCustomerTransactionType |
CustomerTransactionTypeCode |
Code |
sysname |
|
DimCustomerTransactionType |
IsDeleted |
NULL |
bit |
|
DimCustomerTransactionType |
IsVat |
Id type is Vat related |
bit |
|
DimCustomerTransactionType |
IsDebitSide |
If type is debit |
bit |
|
DimCustomerTransactionType |
AccountingCode |
Accounting Code |
nvarchar |
|
DimCustomerTransactionType |
AccountingCode |
Accounting Code |
sysname |
Other changes:
Renaming column UserTransactionTypeId in table FactCustomerTransaction to CustomerTransactionTypeKey
It became FK to DimCustomerTransactionType
Adding new columns to table DictDebtors
- ContractKey FK to DimContract
- AmountToSettle Amount to settle by debtor
Changes in v1.04
Adding new table DimState
| DimState | StateKey | Private Key of this table | int |
| DimState | SateId | NULL | bigint |
| DimState | StateNativeName | NULL | nvarchar |
| DimState | StateNativeName | NULL | sysname |
| DimState | StateEnglishName | NULL | nvarchar |
| DimState | StateEnglishName | NULL | sysname |
| DimState | StateSymbol | NULL | nvarchar |
| DimState | StateSymbol | NULL | sysname |
| DimState | MetaJobId | NULL | bigint |
| DimState | MetaDateInserted | NULL | datetime |
| DimState | MetaDateUpdated | NULL | datetime |