Home > Technical > Table Definitions > RANGE
A record exists for each item that is available from each supplier. A particular item may have many range records, one for each supplier. These items will have the same IPN number, linking them together.
|
Column |
Type |
Description |
||||||
|
INT |
Unique number assigned by the system. |
|||||||
|
VARCHAR(10) |
Supplier from which the item can be purchased. |
|||||||
|
VARCHAR(20) |
The supplier’s order code for this item. |
|||||||
|
STRDESCRIPTION |
VARCHAR(50) |
Supplier’s description for this item. |
||||||
|
STRSIZE |
VARCHAR(10) |
Supplier’s size for this item. |
||||||
|
STRPOS |
VARCHAR(20) |
Supplier’s POS description. |
||||||
|
STRSTATUS |
VARCHAR(10) |
Status indicating availability. Specific codes will vary from supplier to supplier. |
||||||
|
DBLRECOMMENDEDMARGIN |
DECIMAL(19,4) |
Not currently used. |
||||||
|
INT |
IPN of the product. An item may have several RANGE records, but all will have the same IPN. Assigned by the system. This will be use as ITEM.lintItemNumber. |
|||||||
|
STRSUGGESTPOS12 |
VARCHAR(12) |
Suggested short POS description for this item. This will be used as the ITEM.strPOS12Description. |
||||||
|
STRSUGGESTPOS20 |
VARCHAR(20) |
Suggested long POS description for this item. This will be used as the ITEM.strPOS20Description. |
||||||
|
STRSUGGESTDEPT |
VARCHAR(10) |
Suggested department for this item. This will be used as the
ITEM.strDeptCode. |
||||||
|
STRSUGGESTCAT |
VARCHAR(10) |
Suggested category for this item. This will be used as the
ITEM.strCatCode. |
||||||
|
STRSUGGESTGROUP |
VARCHAR(10) |
Suggested group for this item. This will be used as the ITEM.strGroupCode. |
||||||
|
STRSUGGESTFAMILY |
VARCHAR(10) |
Suggested family group for this item. This will be used as the
ITEM.strFamilyCode. |
||||||
|
STRMANUFACTURER |
VARCHAR(10) |
The original manufacturer of the item. |
||||||
|
STRTAXCODE |
VARCHAR(10) |
No longer used. |
||||||
|
STRLIQUORTAXCODE |
VARCHAR(10) |
No longer used. |
||||||
|
STRUNITOFMEASURE |
VARCHAR(10) |
Unit of measure. This will be used as ITEM.strUnitOfMeasure. |
||||||
|
STRCLASSCODE |
VARCHAR(10) |
The classification of the item. This will be used as ITEM.strClassCode. |
||||||
|
STRWETDRY |
VARCHAR(10) |
Indicates if this is a wet or dry item. D/W. |
||||||
|
DECIMAL(19,7) |
The weight of a single unit in kg. |
|||||||
|
DTMDATEENTERED |
DATETIME |
The date the record was created. |
||||||
|
YSNNEW |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGED |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEAPN |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGECARTONCOST |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGECARTONSIZE |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEDEAL |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEDESC |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGELOCATION |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEMANUFACTURER |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEMARGIN |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEMINORDER |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEORDER |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEPOS |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGESIZE |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGESTATUS |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGESUPPLIER |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGETAX |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEUNITOFMEASURE |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEWETDRY |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGEUNITWEIGHT |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGELIQUORTAX |
VARCHAR(1) |
No longer used. |
||||||
|
YSNCHANGECLASS |
VARCHAR(1) |
No longer used. |
||||||
|
DBLTAXRATE |
DECIMAL(19,4) |
No longer used. |
||||||
|
YSNCHANGETAXRATE |
VARCHAR(1) |
No longer used. |
||||||
|
DTMDELETED |
DATETIME |
Date the product was deleted by the supplier. |
||||||
|
STRSUPPDEPTCODE |
VARCHAR(10) |
The supplier’s department code. |
||||||
|
STRSUPPCATCODE |
VARCHAR(10) |
The supplier’s category code. |
||||||
|
STRSUPPGROUPCODE |
VARCHAR(10) |
The supplier’s group code. |
||||||
|
VARCHAR(10) |
The supplier’s code for the original manufacturer |
|||||||
|
YSNCONVERTEDMANUFACTURER |
VARCHAR(1) |
‘T’ if we are able to successfully convert strSuppSupplierCode to our supplier. |
||||||
|
CURRRP |
DECIMAL(19,4) |
The supplier’s recommended sell price. |
||||||
|
YSNCHARGESERVICE |
VARCHAR(1) |
‘T’ if supplier charges Service Fee. |
||||||
|
YSNCHARGEULLAGE |
VARCHAR(1) |
‘T’ if supplier charges Ullage. |
||||||
|
STRTYPE |
CHAR |
|
||||||
| DBLTAREWEIGHT | DECIMAL(19,4) | The weight of the packaging associated with the item. This is used when doing stocktake by weight. | ||||||
| YSNCHANGETAREWEIGHT | VARCHAR(1) | No longer used. | ||||||
| YSNSHOPPED | VARCHAR(1) | ‘T’ if the item exists in the ITEM table. | ||||||
| DBLUNITVOLUME | DECIMAL(19,6) | The volume in litre of the unit item. | ||||||
| STRSUGGESTPRODUCTBRAND | VARCHAR(30) | The suggested brandname of the product. This will be used as the ITEM.strProductBrandName. | ||||||
| STRSUGGESTPRODUCTDESCRIPTION | VARCHAR(30) | The suggested description of the product. This will be used as the ITEM.strProductDescription | ||||||
| STRSUGGESTPRODUCTVARIETY | VARCHAR(30) | The suggested colour/variety of the product. This will be used as the ITEM.strProductVariety. | ||||||
| STRSUGGESTPRODUCTSIZE | VARCHAR(10) | The suggested size of the product. This will be used as the ITEM.strProductSize. | ||||||
| YSNPREFERRED | VARCHAR(1) | 'T' if this product is preferred. The system will use this flag to determine where a product should be purchased from. If the same product is available from two different suppliers, the system will use the one with this flag set to 'T'. A similar flag is available on the SUPPLIER table. | ||||||
| YSNCHANGEPREFERRED | VARCHAR(1) | No longer used. | ||||||
| STRSUGGESTSUBGROUP | VARCHAR(10) | Suggested
group for this item. This will be used as the ITEM.strSubGroupCode. SUBGROUP.strSubGroupCode
|
||||||
| STRTAXCODE1 | VARCHAR(10) | No longer used. See ITEMTAX. | ||||||
| STRTAXCODE2 | VARCHAR(10) | No longer used. See ITEMTAX. | ||||||
| STRTAXCODE3 | VARCHAR(10) | No longer used. See ITEMTAX. | ||||||
| INTCHANGEFLAG | INT | An incrementing number that changes each time the item is changed. This can be used by EOD processes to determine which items have changed since the last time the EOD process was run. | ||||||
| INTNEWFLAG | INT | Similar to INTCHANGEFLAG but indicates that the item is new. | ||||||
| INTCHANGEDESC | INT | Similar to INTCHANGEFLAG but indicates that the item is new. | ||||||
| INTCHANGECOST | INT | Similar to INTCHANGEFLAG but indicates that the item's costs have been changed. | ||||||
|
INTCHANGESTATUS |
INT |
Similar to INTCHANGEFLAG but indicates that the item's strStatus has changed |
||||||
|
STRAGENTCODE |
VARCHAR(10) |
The code of the agent who helps us purchase this item. |
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |