Datenbankänderungen von Version STS-2022.1 → STS-2022.2 (Stand 05/2022)
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 |
EMAIL |
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) |