Sie zeigen eine alte Version dieser Seite an. Zeigen Sie die aktuelle Version an.
Unterschiede anzeigen
Seitenhistorie anzeigen
Version 1
Aktuelle »
Datenbankänderungen von Version STS-2021.3 → STS-2021.4 (Stand 10/2021)
ARTICLE: (changed)
Type
| Column
| ColumnType
|
---|
new |
HASCHARGENR |
TINYINT(1) |
new |
HASEXPIRYDATE |
TINYINT(1) |
CUSTOMERPROPERTY: (changed)
Type
| Column
| ColumnType
|
---|
new |
TYPEORVALUEMODIFIED |
DATETIME |
DELIVERYPOSITION: (changed)
Type
| Column
| ColumnType
|
---|
new |
CHARGENR |
VARCHAR(250) |
new |
EXPIRYDATE |
DATETIME |
GLASSESCARE: (changed)
Type
| Column
| ColumnType
|
---|
new |
ORDERBRANCHID |
VARCHAR(32) |
HICOSTCOVERAGELIST: (changed)
Type
| Column
| ColumnType
|
---|
amparex (STS-2021.3) |
DESCRIPTION |
TEXT |
amparex (STS-2021.4) |
DESCRIPTION |
VARCHAR(250) |
new |
PRICEDATE |
DATE |
INVOICEPOSITION: (changed)
Type
| Column
| ColumnType
|
---|
new |
CHARGENR |
VARCHAR(250) |
new |
EXPIRYDATE |
DATETIME |
new |
FROMDATE |
DATE |
removed |
SERVICECONTRACTFROMDATE |
DATE |
removed |
SERVICECONTRACTTODATE |
DATE |
new |
UNTILDATE |
DATE |
LENSEACTION: (changed)
Type
| Column
| ColumnType
|
---|
new |
CLEANINGSYSTEMAMOUNT |
DECIMAL(5,2) |
new |
CLEANINGSYSTEMAMOUNT2 |
DECIMAL(5,2) |
new |
CLEANINGSYSTEMAMOUNT3 |
DECIMAL(5,2) |
PERFORMEDSERVICE: (changed)
Type
| Column
| ColumnType
|
---|
removed |
ADDRESSID |
CHAR(32) |
new |
STATUS |
VARCHAR(10) |
REFRACTIONREPORT: (changed)
Type
| Column
| ColumnType
|
---|
new |
STABILISATIONLEFT |
DECIMAL(10,2) |
new |
STABILISATIONRIGHT |
DECIMAL(10,2) |
SEPAEXPORT: (new)
Type
| Column
| ColumnType
|
---|
new |
BRANCHID |
CHAR(32) |
new |
CHAINID |
CHAR(32) |
new |
CREATION |
DATETIME(3) |
new |
DESCRIPTION |
TEXT |
new |
DOEXPORT |
TINYINT(1) |
new |
ID |
CHAR(32) |
new |
LASTEXPORT |
DATETIME(3) |
new |
LOG |
TEXT |
new |
MODIFIED |
DATETIME(3) |
new |
RELATEDBANKACCOUNTID |
CHAR(32) |
new |
SEPAMANDATEREFERENCE |
CHAR(32) |
new |
STATE |
VARCHAR(32) |
new |
TRANSFERCOUNT |
INT(11) |
new |
TYPE |
VARCHAR(32) |
TPAPPARTICLE: (removed)
Type
| Column
| ColumnType
|
---|
removed |
ARTICLEID |
CHAR(32) |
removed |
BRANCHID |
CHAR(32) |
removed |
CHAINID |
CHAR(32) |
removed |
ID |
CHAR(32) |
removed |
MODIFIED |
DATETIME(3) |
removed |
STOCKAMOUNT |
DECIMAL(10,2) |
removed |
TPAPPOINTMENTID |
CHAR(32) |
TREATMENTHEAD: (changed)
Type
| Column
| ColumnType
|
---|
new |
COMPANYADDRESSID |
CHAR(32) |
new |
CREATIONDATE |
DATE |