Home > Technical > Table Definitions > LABEL

LABEL

Contains a record for each label available in the system. The actual objects (text, images, data) which appear on the label are stored in LABDET.

Column Type Description
STRLABELCODE VARCHAR(10) A unique code assigned by the user.
STRLABELDESCRIPTION VARCHAR(50) Label description.
STRLABELSIZE VARCHAR(15) Description of the label size.
YSNNEW VARCHAR(1) No longer used.
YSNCHANGED VARCHAR(1) No longer used.
DBLTOPMARGIN FLOAT The margin between the top of the page and the first label, in cm.
DBLLEFTMARGIN FLOAT The margin between the left of the page and the first label, in cm.
DBLHORIZONTALGAP FLOAT No longer used.
DBLVERTICALGAP FLOAT No longer used.
DBLLABELHEIGHT FLOAT The height, in cm, of a single label.
DBLLABELWIDTH FLOAT The width, in cm, of a single label.
INTLABELSACROSS INT The number of labels across the page.
INTLABELSDOWN INT The number of labels down the page.
INTORIENTATION INT The orientation of the page. 0 = Portrait, 1= Landscape.
YSNLABELONLY VARCHAR(1) ‘T’ if no data needs to be extracted for this label. Set by the system.
STRPAPERTYPE VARCHAR(64) The name of the paper to be used for the labels, for example A4, US Letter, and so on.
DBLPAGEWIDTH DECIMAL(19,4) The width, in cm, of the paper. Only used if strPaperType is 'Custom'.
DBLPAGEHEIGHT DECIMAL(19,4) The height, in cm, of the paper. Only used if strPaperType is 'Custom'.
INTUNITTYPE INT Always 0.
 

Primary Key: STRLABELCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)