Home > Technical > Table Definitions > INVTEMPLATEDTL

INVTEMPLATEDTL

Inventory templates allow you to specify a set of items for which the system can generate stocktakes, purchase orders, and so on. INVTEMPLATEHDR contains details about when the template can be used while INVTEMPLATEDTL has the actual items.

Column Type Description
LINTTEMPCODE INT The template code to which this detail belongs.

INVTEMPLATEHDR.ctrCode

CTRCODE INT A unique number generated by the system.
STRDEPTCODE VARCHAR(10) Only items in this department will be used.

DEPT.strDeptCode

STRCATCODE VARCHAR(10) Only items in this category will be used.

CATEGORY.strCatCode

STRGROUPCODE VARCHAR(10) Only items in this group will be used.

GROUPS.strGroupCode

STRSUBGROUPCODE VARCHAR(10) Only items in this subgroup will be used.

SUBGROUP.strSubGroupCode

STRCLASSCODE VARCHAR(10) Only items in this classification will be used.

CLASS.strClassCode

STRFAMILYCODE VARCHAR(10) Only items in this family will be used.

link.gif (858 bytes) FAMILY.strFamilyCode

LINTITEMNUMBER INT Only items with this item number will be used.

ITEM.lintItemNumber

STRSUPPLIERCODE VARCHAR(10) Only items from this supplier will be used.

SUPPLIER.strSupplierCode

STRMANUFACTURER VARCHAR(10) Only items from this manufacturer will be used.

SUPPLIER.strSupplierCode

STRPRODUCTBRANDNAME VARCHAR(30) Only items with this brandname will be used.
STRPRODUCTDESCRIPTION VARCHAR(30) Only items with this description will be used.
STRPRODUCTVARIETY VARCHAR(30) Only items with this variety will be used.
STRPRODUCTSIZE VARCHAR(10) Only items with this size will be used.
STRSEASONCODE VARCHAR(10) Only items in this season will be used.
STRYEARCODE VARCHAR(10) Only items in this year will be used.
INTCONSIGNMETHOD INT Indicates whether or not consignment items should be included.
0   All items
1   Consignment Items Only
2   Non-Consignment Items Only
LINTSAMPLETRANS INT Not currently used.
 

Primary Key: LINTTEMPCODE + CTRCODE

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