Kitlabels
Report KitLabels
- Filename: KitLabels
- Title: Kit labels
- Sample: 177
Synopsis
Kit labels list
SQL
SELECT
Artcode, QTY, MLotNo, NAME2,
'*'+Artcode+'*' as BArtcode,
'*'+MLotNo+'*' as BMLotNo
FROM
CGROUP
LEFT OUTER JOIN Article on (CGROUP.ARTCODE=ARTICLE.NAME)
WHERE
(CGROUP.ID=:KitID)
Parameters
- KitID ID of CGROUP record.
- NumberOfCopies Number of copies.