17 lines
371 B
SQL
17 lines
371 B
SQL
|
|
--
|
|
-- Table structure for ERP Trace
|
|
--
|
|
|
|
CREATE TABLE ERPTrace (
|
|
kistennummer varchar(20) NOT NULL default '',
|
|
artikelnummer varchar(20) NOT NULL default '',
|
|
charge varchar(20) NOT NULL default '',
|
|
menge decimal(10,0) NOT NULL default '0',
|
|
einheit varchar(20) NOT NULL default 'KP',
|
|
rfzts timestamp(14) NOT NULL,
|
|
action varchar(20) NOT NULL default ''
|
|
);
|
|
|
|
|