Changes to the database - 4.8 release (April 2020)
ARTICLEDOCUMENTATION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | TRACERID | CHAR(32) |
ASSORTMENTHEAD: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | SUPPLIERID | CHAR(32) |
BRANCH: (changed)
| Type | Column | ColumnType |
|---|---|---|
| removed | ISVATEXEMPT | TINYINT(1) |
| new | PRESCRIPTIONVATEXEMPTEND | DATE |
| new | PRESCRIPTIONVATEXEMPTSTART | DATE |
| new | VATEXEMPTEND | DATE |
| new | VATEXEMPTSTART | DATE |
BRAND: (changed)
| Type | Column | ColumnType |
|---|---|---|
| removed | PURCHASEDISCOUNTPERCENTAGE | DECIMAL(5,2) |
| removed | PURCHASEDISCOUNTPERCENTAGEFORFRAMETYPESUN | DECIMAL(5,2) |
COMPANY: (changed)
| Type | Column | ColumnType |
|---|---|---|
| removed | PURCHASEDISCOUNTPERCENTAGE | DECIMAL(5,2) |
CUSTOMER: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (4.7) | CUSTOMERCODE | VARCHAR(9) |
| amparex (4.8) | CUSTOMERCODE | CHAR(9) |
CUSTOMLENSEPRICELISTPOSITION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DIOPTER | DECIMAL(6,3) |
DEFAULTDISCOUNT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ISAUTOMATICCALCULATION | TINYINT(1) |
| new | ISAUTOMATICINSERT | TINYINT(1) |
DOCUMENTTEMPLATE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | SUBJECT | VARCHAR(100) |
GLASSESCARE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BEVELPOSITIONTYPE | VARCHAR(15) |
| new | BEVELPOSITIONVALUE | DECIMAL(10,2) |
| new | CHAMFERPOSITION | VARCHAR(10) |
| new | CHAMFERVALUE | VARCHAR(10) |
| new | GROOVEDEPTH | DECIMAL(2,2) |
| new | GROOVEWIDTH | DECIMAL(2,2) |
| new | ORDERNOTE | VARCHAR(255) |
| new | POLISH | TINYINT(1) |
GUARANTYDEFAULT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | OTHERPREDEFINEDVALUEID | CHAR(32) |
INVOICE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ISVATEXEMPT | TINYINT(1) |
| new | VATEXEMPTIONREASON | VARCHAR(50) |
ITEMMOVE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (4.7) | CREATION | DATETIME |
| amparex (4.8) | CREATION | DATETIME(3) |
LABELPRINTORDER: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | ARTICLEITEMID | CHAR(32) |
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | COUNT | INT(11) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME |
| new | OWNERBRANCHID | CHAR(32) |
| new | STATUS | VARCHAR(50) |
| new | TYPE | VARCHAR(50) |
LENSEACTION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (4.7) | CONTROLDATE | DATETIME |
| amparex (4.8) | CONTROLDATE | DATE |
| amparex (4.7) | DATE | DATETIME |
| amparex (4.8) | DATE | DATE |
LENSEOPTIONSCOMBINATIONPURCHASEPRICE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | SALESPRICE | DECIMAL(10,2) |
NOAHDASHBOARDALERT: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | ACTIONID | CHAR(32) |
| new | ALERTGUID | CHAR(32) |
| new | APPMODULEID | BIGINT(20) |
| new | ASSIGNEESTAFFID | CHAR(32) |
| new | BRANCHID | CHAR(32) |
| new | CATEGORY | VARCHAR(50) |
| new | CHAINID | CHAR(32) |
| new | CUSTOMERID | CHAR(32) |
| new | DESCRIPTION | VARCHAR(1024) |
| new | GROUPGUID | CHAR(32) |
| new | ICONURL | VARCHAR(1024) |
| new | ID | CHAR(32) |
| new | ISARCHIVED | TINYINT(1) |
| new | ISREAD | TINYINT(1) |
| new | LASTMODIFIEDUTC | DATETIME(3) |
| new | MODIFIED | DATETIME(3) |
| new | MODULEID | BIGINT(20) |
| new | MODULEPARAMETER | VARCHAR(1024) |
| new | NOTIFICATIONACTIONID | CHAR(32) |
| new | PRIORITY | INT(11) |
| new | RECEIVEDUTC | DATETIME(3) |
| new | URL | VARCHAR(1024) |
ORDERING: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ORDERDATA | TEXT |
PRINCIPAL: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | PINCODE | VARBINARY(255) |
| new | PINCODEHASH | VARCHAR(64) |
PROCUREMENT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DISCOUNTEDPRICE | DECIMAL(12,2) |
PROCUREMENTCONDITIONS: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ARTICLETYPEID | CHAR(32) |
SERVERMAINTENANCE: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | APPOINTMENTID | CHAR(32) |
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME(3) |
| new | SERVERID | CHAR(32) |
| new | TYPE | VARCHAR(50) |
SERVICECONFIGURATION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | CREATED | DATETIME |
SPONSORCONTRACT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | TREATMENTKIND | CHAR(50) |
STSSESSION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (4.7) | MODIFIED | DATETIME |
| amparex (4.8) | MODIFIED | DATETIME(3) |
THIRDPARTYAPPROVAL: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | AMOUNTAPPROVED | DECIMAL(12,2) |
| new | AMOUNTSUBMITTED | DECIMAL(12,2) |
TRACER: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | ARTICLEID | CHAR(32) |
| new | ARTICLEITEMID | CHAR(32) |
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | CREATIONDATE | DATETIME |
| new | DESCRIPTION | VARCHAR(255) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME |
| new | MODIFIEDDATA | LONGTEXT |
| new | ORIGINALDATA | BLOB |
| new | ORIGINALFORMAT | VARCHAR(255) |
| new | TREATMENTHEADID | CHAR(32) |
TREATMENTHEAD: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | VERSIONNR | INT(11) |