CREATE TABLE SUPERMAG.SMCARD
(
ARTICLE VARCHAR2(50 BYTE) NOT NULL,
GLOBALARTICLE VARCHAR2(50 BYTE),
ARRIVEDFROM NUMBER(10),
BORNIN RAW(16) NOT NULL,
NAME VARCHAR2(255 BYTE) NOT NULL,
SHORTNAME VARCHAR2(255 BYTE),
IDMEASUREMENT NUMBER(5) NOT NULL,
IDCLASS NUMBER(10) NOT NULL,
IDSCALE NUMBER(5),
SUBARTICLE VARCHAR2(255 BYTE),
ACCEPTED NUMBER(5) DEFAULT 0 NOT NULL,
DATATYPE NUMBER(5) DEFAULT 0 NOT NULL,
DATASUBTYPE NUMBER(5) DEFAULT (-1) NOT NULL,
SCALELOAD CHAR(1 BYTE) DEFAULT '0' NOT NULL,
CASHLOAD CHAR(1 BYTE) DEFAULT '0' NOT NULL,
RECEIPTOK CHAR(1 BYTE) DEFAULT '1' NOT NULL,
STORAGE NUMBER(5) DEFAULT 0 NOT NULL,
DEADLINE NUMBER(5),
LOSSES NUMBER(8,4) DEFAULT 0 NOT NULL,
SCRAP NUMBER(8,4) DEFAULT 0 NOT NULL,
WASTE NUMBER(8,4) DEFAULT 0 NOT NULL,
MESNAME VARCHAR2(20 BYTE),
MESABBREV VARCHAR2(6 BYTE),
COUNTRY VARCHAR2(255 BYTE) DEFAULT 'Россия',
CARDCOMMENT VARCHAR2(255 BYTE),
FLAGS NUMBER(10) DEFAULT 0 NOT NULL,
CUTPRICEDAYS NUMBER(5) DEFAULT 0 NOT NULL,
SUPPLYPRICEPERCENTP NUMBER(8,4),
SUPPLYPRICEPERCENTM NUMBER(8,4),
MINPROFIT NUMBER(19,4) DEFAULT 0 NOT NULL,
IDTHREETORG NUMBER(10),
IDONETORG NUMBER(10),
IDSPIRITCODE NUMBER(10),
QUANTITYDEVIATION NUMBER(14,3) DEFAULT (0) NOT NULL,
IDMARKETINGGROUP NUMBER(10),
SKLAD VARCHAR2(10 BYTE),
USETIME NUMBER(5),
USETIMEDIM NUMBER(5) DEFAULT (3) NOT NULL,
IDMEASWEIGHT NUMBER(5),
IDMEASDIM NUMBER(5),
WEIGHT NUMBER(14,3),
WIDTH NUMBER(14,3),
LENGTH NUMBER(14,3),
HEIGHT NUMBER(14,3),
STATEREGULATION NUMBER(5),
IDLOSSESGROUP NUMBER(10)
)