USR$GD GOOD

Справочник ТМЦ (диалог)

CREATE TABLE GD_GOOD 
(
  ID    	DINTKEY,
  GROUPKEY	DMASTERKEY,
  NAME  	DNAME,
  ALIAS 	DNULLALIAS,
  SHORTNAME	DTEXT40,
  DESCRIPTION	VARCHAR(500) CHARACTER SET WIN1251 COLLATE PXW_CYRL,
  BARCODE	DBARCODE COLLATE PXW_CYRL,
  VALUEKEY	DINTKEY,
  TNVDKEY	DFOREIGNKEY,
  DISCIPLINE	DACCOUNTINGDISCIPLINE,
  ISASSEMBLY	DBOOLEAN,
  CREATORKEY	DFOREIGNKEY,
  CREATIONDATE	DCREATIONDATE,
  EDITORKEY	DFOREIGNKEY,
  EDITIONDATE	DEDITIONDATE,
  RESERVED	DRESERVED,
  DISABLED	DDISABLED,
  AFULL	        DSECURITY,
  ACHAG  	DSECURITY,
  AVIEW 	DSECURITY,
  USR$INV_WEIGHT	DCURRENCY,
  USR$CONTENT	        DTEXT1024 COLLATE PXW_CYRL,
  USR$FULLNAME	        DTEXT180 COLLATE PXW_CYRL,
  USR$OUTVALUEKEY	USR$INV_DVALUE,
  USR$MN_ASHES          DCURRENCY,
  USR$MN_CALCIUM	DCURRENCY,
  USR$MN_CALORIE	DCURRENCY,
  USR$MN_CAROTIN	DCURRENCY,
  USR$MN_CELLULOSE	DCURRENCY,
  USR$MN_EMPTY  	DCURRENCY,
  USR$MN_FAT    	DCURRENCY,
  USR$MN_FULL   	DCURRENCY,
  USR$MN_IRON   	DCURRENCY,
  USR$MN_MAGNESIUM	DCURRENCY,
  USR$MN_MEASURE	DCURRENCY,
  USR$MN_NATRIUM	DCURRENCY,
  USR$MN_PHOSPHORUS	DCURRENCY,
  USR$MN_PORTIONS	DCURRENCY,
  USR$MN_POTASSIUM	DCURRENCY,
  USR$MN_PROTEIN	DCURRENCY,
  USR$MN_STARCH  	DCURRENCY,
  USR$MN_UGLEVOD	DCURRENCY,
  USR$MN_VITAMIN_C	DCURRENCY,
  USR$MN_VITAMIN_PP	DCURRENCY,
  USR$MN_VITAMIN_A	DCURRENCY,
  USR$MN_VITAMIN_B1	DCURRENCY,
  USR$MN_VITAMIN_B2	DCURRENCY,
  USR$MN_WATER   	DCURRENCY,
  USR$MN_ONLY   	DBOOLEAN DEFAULT '0',
  USR$MN_MAINGOODKEY	USR$GS_DGOOD,
  USR$MN_SUGAR  	DCURRENCY,
  USR$PICTURE   	DBMP,
  USR$MN_LOSSKOEFF	DQUANTITY,
  USR$INV_LOSS  	DPERCENT,
  USR$INV_PERCROPE	DPERCENT,
  USR$FOREIGNNAME	DTEXT120 COLLATE PXW_CYRL,
  USR$NATURALLOSSGROUP	USR$GROUPLOSS,
  USR$INV_OPTPERC	DCURRENCY,
  USR$INV_ACCOUNTKEY	USR$INV_DACCACCOUNTKEY,
  USR$CLITICALDAYS	DINTEGER,
  USR$INV_PERCKEY	USR$INV_DPERCKEY,
  USR$INV_REFFORMTORGKEY	USR$INV_DREFFORMTORGKEY,
  USR$INV_COEFF  	DCURRENCY,
  USR$PF_PRICE  	DCURRENCY,
  USR$PF_ISFRAC  	DBOOLEAN,
  USR$MAXDISCPERC	DCURRENCY,
  USR$PF_ISWEIGHT	DBOOLEAN,
  USR$PF_WEIGHTCODE	DTEXT20 COLLATE PXW_CYRL,
CONSTRAINT GD_PK_GOOD PRIMARY KEY (ID)
);