Database status 4.9 → STS-2021.2 (as of 05/2021)
ARTICLE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (4.10) | COLORCODE | VARCHAR(100) |
| amparex (4.9) | COLORCODE | VARCHAR(50) |
| new | COMMISSIONPERIOD | INT(11) |
| amparex (4.10) | FRAMELENGTH | INT(11) |
| amparex (4.9) | FRAMELENGTH | VARCHAR(50) |
ARTICLEVARIANT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | COMMISSIONPERIOD | INT(11) |
ASSORTMENTPROGRAMMOVEEXPORT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | LOG | TEXT |
BOOKACCOUNT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | EXPORTPARENT | TINYINT(1) |
BOOKENTRY: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BOOKSTACK | VARCHAR(30) |
BOOKMANDATOR: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DEBITORACCOUNTLENGTH | INT(11) |
| new | IMPERSONALACCOUNTLENGTH | INT(11) |
BOOKPERIOD: (changed)
| Type | Column | ColumnType |
|---|---|---|
| removed | SEQUENCE | INT(11) |
BOOKPOSITION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | SALESDEDUCTION | TINYINT(1) |
BRANCH: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
BRANCHORGANIZATION: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | ID | CHAR(32) |
| new | IDENTCODE | VARCHAR(50) |
| new | ISMASTER | TINYINT(1) |
| new | MODIFIED | DATETIME(3) |
| new | NAME | VARCHAR(250) |
CLIENTHOST: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | USERHOME | VARCHAR(255) |
| new | USERNAME | VARCHAR(255) |
COLLECTIVEINVOICE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | SALESDEDUCTION | TINYINT(1) |
COMPANY: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | STOCKFORCREDITPERIOD | INT(11) |
CUSTOMER: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ISINVOICEONLYBYPOST | TINYINT(1) |
CUSTOMERHISTORY: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | LICENSEOWNER | VARCHAR(50) |
| new | STAFFNAME | VARCHAR(250) |
DEFAULTDISCOUNT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | VALIDFROMARTICLEQUANTITYTYPE | VARCHAR(50) |
DEFAULTDISCOUNTCONDITION: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | DEFAULTDISCOUNTID | CHAR(32) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME(3) |
| new | REFERENCEID | CHAR(32) |
| new | REFERENCETYPE | VARCHAR(100) |
DELIVERY: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ASKFORQUOTATION | TINYINT(1) |
| new | ISCOMPLAINT | TINYINT(1) |
| amparex (4.10) | TRACKINGNUMBER | VARCHAR(200) |
| amparex (4.9) | TRACKINGNUMBER | VARCHAR(50) |
GLASSESCARE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | RELAXFACTOR | VARCHAR(20) |
HEARINGCAREDETAIL: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | HEARERARTICLEVARIANTID | CHAR(32) |
| new | OTOPLASTICARTICLEVARIANTID | CHAR(32) |
IMPORTDELIVERYNOTEPOSITION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | MAXRETURNDATE | DATE |
| new | OWNER | VARCHAR(50) |
INDICATION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | SYMPTOMSA | VARCHAR(100) |
| new | SYMPTOMSB | VARCHAR(100) |
| new | SYMPTOMSC | VARCHAR(100) |
| new | SYMPTOMSX | TINYINT(1) |
INVENTORY: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | PARAMETERS | LONGTEXT |
INVENTORYSTATE: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | COMPLETED | TINYINT(4) |
| new | CREATIONDATE | DATETIME |
| new | ERRORLOG | TEXT |
| new | ID | CHAR(32) |
| new | INVENTORYID | CHAR(32) |
| new | INVENTORYTEMPLATEID | CHAR(32) |
| new | MODIFIED | DATETIME |
| new | OWNERID | CHAR(32) |
| new | STATE | VARCHAR(50) |
INVENTORYTEMPLATE: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | DESCRIPTION | TEXT |
| new | EDITABLE | TINYINT(1) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME(3) |
| new | NAME | VARCHAR(255) |
| new | TEMPLATEDATA | LONGTEXT |
INVOICE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | EMAILNOTIFICATIONDATE | DATE |
| new | SALESDEDUCTION | TINYINT(1) |
INVOICEPOSITION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DIRECTSHIPPEDAMOUNT | DECIMAL(12,2) |
| new | PRICECATEGORYID | CHAR(32) |
| new | VATRATE | DECIMAL(5,2) |
LENSEACTION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | VERSIONNR | INT(11) |
LENSEACTIONDETAIL: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | VERSIONNR | INT(11) |
| new | VISIBLEINTREEROOT | TINYINT(1) |
| new | WORNONBOTHSIDES | TINYINT(1) |
LENSECARE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | VERSIONNR | INT(11) |
MARKETINGSELECTIONHEAD: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
NOTIFICATION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | NOAHDASHBOARDALERTID | CHAR(32) |
ORDERING: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (4.10) | TRACKINGNUMBER | VARCHAR(200) |
| amparex (4.9) | TRACKINGNUMBER | VARCHAR(50) |
ORDERPOSITION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | INVOICEPOSITIONID | CHAR(32) |
PERSON: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DONOTDUNENDDATE | DATE |
PERSONALSTATISTICSCHEDULER: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | DESCRIPTION | VARCHAR(255) |
| new | VARCHAR(250) | |
| new | ERRORCOUNT | INT(11) |
| new | ERRORLOG | TEXT |
| new | ID | CHAR(32) |
| new | INTERVALTYPE | VARCHAR(50) |
| new | LASTRUN | DATETIME |
| new | MODIFIED | DATETIME(3) |
| new | NEXTRUN | DATETIME |
| new | OWNERID | CHAR(32) |
| new | PRINCIPALID | CHAR(32) |
| new | STATISTICID | CHAR(32) |
PRESALESSTOCKMANAGEMENT: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | ARTICLEITEMID | CHAR(32) |
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME |
| new | STOCKAMOUNT | DECIMAL(10,2) |
| new | TREATMENTHEADID | CHAR(32) |
PRINCIPAL: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ISTECHNICALUSER | TINYINT(1) |
REFRACTIONREPORT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | HHDLEFT | DECIMAL(6,2) |
| new | HHDRIGHT | DECIMAL(6,2) |
| new | IMPORTTYPE | VARCHAR(50) |
| new | ISIMPORTED | TINYINT(1) |
| new | REFRACTIONTIME | TIME |
SERVER: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DEPLOYMENTDAY | VARCHAR(22) |
| new | DEPLOYVERSION | VARCHAR(20) |
SERVERMAINTENANCE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | LOCKSERVER | TINYINT(1) |
SITE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (4.9) | PARAMETERS | VARCHAR(200) |
STATISTIC: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | LASTMODIFIED | INT(11) |
| removed | QUERYVERSION | VARCHAR(250) |
| new | SOURCEPATH | VARCHAR(250) |
TPAPPOINTMENT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
TPLAYOUT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
TPONLINECONFIGURATION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
TPRESOURCE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
| new | WARNIFNOTAVAILABLE | TINYINT(1) |
TPTEMPLATE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
TPVIEW: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
TPVIEWVISIBLE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
TREATMENTDETAILTHERAPEUTICS: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | SYMPTOMSA | TINYINT(1) |
| new | SYMPTOMSB | TINYINT(1) |
| new | SYMPTOMSC | TINYINT(1) |
| new | SYMPTOMSX | TINYINT(1) |
TREATMENTGROUP: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | ID | CHAR(32) |
| new | KIND | VARCHAR(50) |
| new | MODIFIED | DATETIME(3) |
| new | NOTICE | TEXT |
| new | STATE | VARCHAR(50) |
| new | TREATMENTGROUPNR | VARCHAR(50) |
| new | VERSIONNR | INT(11) |
TREATMENTGROUPREFERENCE: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | ID | CHAR(32) |
| new | MODIFIED | DATETIME(3) |
| new | TREATMENTGROUPID | CHAR(32) |
| new | TREATMENTHEADID | CHAR(32) |
VERSION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | STABLE | TINYINT(1) |
WAITLIST: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHORGANIZATIONID | CHAR(32) |
WORKINGTIMEHEAD: (changed)
| Type | Column | ColumnType |
|---|---|---|
| removed | USEADDITIONALWORKINGTIME | TINYINT(1) |