Datenbankänderungen von Version STS-2021.4 → STS-2022.1 (Stand 01/2022)
BRANCH: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (STS-2021.4) | DEBITORACCOUNTNUMBERCUSTOMER | VARCHAR(50) |
| amparex (STS-2022.1) | DEBITORACCOUNTNUMBERCUSTOMER | VARCHAR(16) |
| amparex (STS-2021.4) | DEBITORACCOUNTNUMBERHI | VARCHAR(50) |
| amparex (STS-2022.1) | DEBITORACCOUNTNUMBERHI | VARCHAR(16) |
CUSTOMER: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DONOTASKFORDATAUNTIL | DATE |
EBILLINGARCHIVE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | INVOICENUMBER | VARCHAR(200) |
| new | PROCESSINDICATOR | VARCHAR(50) |
| new | RAWDATA | MEDIUMBLOB |
HICOSTCOVERAGE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | OPPOSITESIDEVALUES | TINYINT(1) |
IMPORTDELIVERYNOTEPOSITION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (STS-2021.4) | ARTICLENAME | VARCHAR(50) |
| amparex (STS-2022.1) | ARTICLENAME | VARCHAR(200) |
NOTIFICATION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | NOTIFICATIONTEXT | TEXT |
OAUTHTOKEN: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | ACCESSTOKEN | BLOB |
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | ENCRYPTIONTYPE | VARCHAR(255) |
| new | EXPIRYTIME | BIGINT(20) UNSIGNED |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME(3) |
| new | REFRESHTOKEN | BLOB |
| new | SERVICECONFIGURATIONID | CHAR(32) |
PRINCIPAL: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ISMASTERUSER | TINYINT(1) |
| new | NUMBEROFPASSWORDRESETCODETRIES | TINYINT(4) |
| new | PASSWORDRESETCODE | VARCHAR(10) |
| new | PASSWORDRESETEMAILORSMS | VARCHAR(30) |
SCHEDULEDTASK: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | INTERNALDATA | VARCHAR(50) |
TPVIEW: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | FIRSTDAYOFWEEK | INT(11) |
XBOOKACCOUNT: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | CHAINID | CHAR(32) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME(3) |
| new | RELATEDID | CHAR(32) |
XBOOKPOSITION: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BOOKACCOUNTID | CHAR(32) |
| new | BOOKENTRYID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME(3) |