Home > Technical > Table Definitions > INVTEMPLATEHDR

INVTEMPLATEHDR

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
CTRCODE INT Unique number assigned to the template by the system.
STRTRADECODE VARCHAR(10) The location (can be a group) the template is used by.
TRADUNIT.strTradeCode
STRDESCRIPTION VARCHAR(100) Short description about the template.
DTMWHEN DATETIME When the template was created.
STRWHO VARCHAR(20) Who create the template
STRTRANSTYPE VARCHAR(10) The type of transaction that can use this template.
PO   Purchase Order
STK   Stocktake
TFRI   Transfer Request
GR   Goods Receipt
REQSTK   Required Stock
STRTYPE VARCHAR(10) If this is for a template, the strType will indicate the type of stocktake. Direct/Store
MEMCOMMENT TEXT A full description about the template.
INTMETHOD INT When the template can be used.
0   Days Of Week
1   Day Of Month
2   Manual
YSNSUNDAY VARCHAR(1) 'T' if template can be used on Sunday.
YSNMONDAY VARCHAR(1) 'T' if template can be used on Monday.
YSNTUESDAY VARCHAR(1) 'T' if template can be used on Tuesday.
YSNWEDNESDAY VARCHAR(1) 'T' if template can be used on Wednesday.
YSNTHURSDAY VARCHAR(1) 'T' if template can be used on Thursday.
YSNFRIDAY VARCHAR(1) 'T' if template can be used on Friday.
YSNSATURDAY VARCHAR(1) 'T' if template can be used on Saturday.
STRDAYOFMONTH VARCHAR(50) The day of the month the template can be used.
YSNACTIVE VARCHAR(1) 'T' if the template is active.
 

Primary Key: CTRCODE

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