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) |