USR$INV ADDWBILLLINE
Материал из GedeminWiki
CREATE TABLE USR$INV_ADDWBILLLINE ( DOCUMENTKEY DINTKEY NOT NULL, RESERVED DINTEGER, MASTERKEY DMASTERKEY, FROMCARDKEY DINTKEY, QUANTITY DQUANTITY, REMAINS DQUANTITY, DISABLED DDISABLED, USR$GRASSWEIGHT DQUANTITY, USR$QUANTPACK DQUANTITY, USR$SUMALLNCU DCURRENCY, USR$SUMNCU DCURRENCY, USR$SUMNDSNCU DCURRENCY, USR$SUMWITHNDSNCU DCURRENCY, USR$SUMWITHNDSCUR DCURRENCY, USR$SUMNDSCUR DCURRENCY, USR$SUMSALENCU DCURRENCY, USR$ISFIXEDCOST DBOOLEAN, USR$SUMCONTRPRICECUR DCURRENCY, USR$SUMCONTRPRICENCU DCURRENCY, USR$SUMEXTRANDS DCURRENCY, USR$SUMEXTRA DCURRENCY, USR$SUMEXTTAXSALE DCURRENCY, USR$SUMEXTRASERVICE DCURRENCY, USR$SUMROUND DCURRENCY, USR$SUMSELNCU DCURRENCY, USR$SUMTRADE DCURRENCY, USR$SUMSELLNDS DCURRENCY, USR$SUMOILNCU DCURRENCY, USR$CARGOCLASS DTEXT10, USR$CARGOCODE DTEXT10, USR$DOCUMENTS DTEXT40, USR$SUMEQ DCURRENCY, USR$SUMRETAILNCU DCURRENCY, USR$COSTRETAIL_PREV DCURRENCY, USR$ISEXPORT DBOOLEAN DEFAULT '0', USR$ISSPEND DBOOLEAN DEFAULT '0', USR$NUMORDER DINTEGER, USR$EVAT_COMMENTKEY USR$EVAT_D_COMMENT, USR$MOG_CUSTOMSUM DCURRENCY, USR$MOG_TRANSSUM DCURRENCY, USR$MOG_OVERHEADSUM DCURRENCY, USR$MOG_CUSTNDSSUM DCURRENCY, USR$MOG_TRANSRBSUM DCURRENCY, USR$QUANTROPE DCURRENCY, USR$RETQUANT DCURRENCY, USR$SELLCOST_PREV DCURRENCY, PRIMARY KEY (DOCUMENTKEY) );