Home > Technical > Table Definitions > ITEMBUYER

ITEMBUYER

Buyer codes are used to control what items a user can see and also the value of purchase orders those users can place. BUYERHDR contains the header record for a set of rules, BUYERDTL provides the order limits for a buying code while ITEMBUYER provides a link that says which buyers can see which items.

Column Type Description
LINTITEMNUMBER INT The item number which belongs in the buying group.
ITEM.lintItemNumber
STRBUYERCODE VARCHAR(10) The buying group to which the item belongs.

link.gif (858 bytes) BUYERHDR.strCode

 

Primary Key: LINTITEMNUMBER + STRBUYERCODE

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