Home > Technical > Table Definitions > BUYINGREVIEWDTL

BUYINGREVIEWDTL

Contains Buying Review detail information.

Column Type Description
INTREVIEWCODE INT Links to the Buying Review code
BUYINGREVIEWHDR.ctrCode
STRTRADECODE VARCHAR(50) Selling location Tradecode
TRADUNIT.strTradeCode
LINTITEMNUMBER INT Item number
ITEM.lintItemNumber
STRCOSTTRADECODE VARCHAR(10) Cost location Tradecode
TRADUNIT.strTradeCode
STRSUPPLIERCODE VARCHAR(10) Supplier code
SUPPLIER.strSupplierCode
STRORDERCODE VARCHAR(20) Supplier order code
STORERNG.strOrderCode
STRPOS20DESCRIPTION VARCHAR(20) Long Item POS Description
ITEM.strPOS20Description
STRPRODUCTSIZE VARCHAR(10) The size of the item
ITEM.strProductSize
INTCARTONSIZE DECIMAL(9,3) Number of units in the carton
COST.intCartonSize
STRSALESTAXCODE VARCHAR(10) Item sales Tax Code
ITEMTAXGROUP.strSalesGroupCode
CUROLDCOST DECIMAL(19,4) Old cost value
STRCOSTTYPE CHAR Cost type (N for Normal, O for other)
DTMEXPIRE DATETIME Cost expiry date
CUROLDSELL DECIMAL(19,4) Old sell value
STRSELLTYPE CHAR Sell type (N for Normal, O for other)
DBLMARGIN DECIMAL(19,4) Item sell margin %
STRDEPTCODE VARCHAR(10) The department code to which the item belongs
ITEM.strDeptCode
STRCATCODE VARCHAR(10) The category code to which the item belongs
ITEM.strCatCode
STRGROUPCODE VARCHAR(10) The group code to which the item belongs
ITEM.strGroupCode
STRSUBGROUPCODE VARCHAR(10) The sub-group code to which the item belongs
ITEM.strSubGroupCode
CURNEWCOST DECIMAL(19,4) New cost value
CURNEWSELL DECIMAL(19,4) New sell value
CURRRP DECIMAL(19,4) Import RRP (Recommended Retail Price) from the supplier file
STRAPN VARCHAR(20) The EAN/ UPC/ PLU number
APN.strAPN
DBLNEWMARGIN DECIMAL(19,4) New item sell margin %
STRCOSTCURRENCYCODE VARCHAR(10) Currency code for the cost value
CURRENCYCODE.strCurrencyCode
STRSELLCURRENCYCODE VARCHAR(10) Currency code for the sell value
CURRENCYCODE.strCurrencyCode
STRTAXSYSTEMCODE VARCHAR(10) Tax system in use at the Sell location
TRADUNIT.strTaxSystemCode
YSNLINKED VARCHAR(1) Indicates if the item is linked to another item
LINTLINKEDITEM INT Item code of the linked item
ITEM.lintItemNumber
DTMSELLEXPIRE DATETIME For future use
 

Primary Key: INTREVIEWCODE + STRTRADECODE + LINTITEMNUMBER

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