Database status STS-2021.3 → STS-2021.4 (as of 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 |