Код:
ALTER TRIGGER SUPERMAG.SMCARDPROPSCHECKROLE DISABLE;
alter trigger supermag.smstoreunitsiu disable;
insert into supermag.smcard (ARTICLE, BORNIN, NAME, IDMEASUREMENT, IDCLASS, ACCEPTED, DATATYPE, DATASUBTYPE, SCALELOAD, CASHLOAD,
RECEIPTOK, STORAGE, LOSSES, SCRAP, WASTE, FLAGS, CUTPRICEDAYS,MINPROFIT, QUANTITYDEVIATION, USETIMEDIM, GLOBALARTICLE,
ARRIVEDFROM, SHORTNAME, IDSCALE, SUBARTICLE, DEADLINE, MESNAME,MESABBREV, COUNTRY, CARDCOMMENT, SUPPLYPRICEPERCENTP,
SUPPLYPRICEPERCENTM, IDTHREETORG, IDONETORG, IDSPIRITCODE, IDMARKETINGGROUP, SKLAD, USETIME, IDMEASWEIGHT, IDMEASDIM,
WEIGHT, WIDTH, LENGTH, HEIGHT, STATEREGULATION, IDLOSSESGROUP,ICING) values (
'SAB0006774FS105L'
,'0',
'SAB 0006774F B4 Платье Жен Черный L'
,0,
'40'
,1, 0, -1, 0, 1, 1, 0, 0, 0, 0, 64, 0, 0, 0, 3,
'SAB0006774FS105L'
,null,
'SAB 0006774F B4 Платье Жен Черный L'
, null, null, null, 'штука', 'шт', null, null, 1, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
commit;
INSERT into supermag.smstoreunits(barcode, barcodetype, unitname, article, quantity, facequantity, flags, subarticle, nestedbar, weight, tareweight,
tarewidth, tarelength, tareheight, maxy) VALUES(
'100025258333'
,1,'шт',
'SAB0006774FS105L'
,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
commit;
alter trigger supermag.smstoreunitsiu enable;
ALTER TRIGGER SUPERMAG.SMCARDPROPSCHECKROLE ENABLE;