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