Home > Technical > Table Definitions > RANGE

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

LINTRANGECODE

INT

Unique number assigned by the system.

STRSUPPLIERCODE

VARCHAR(10)

Supplier from which the item can be purchased.
link.gif (858 bytes) SUPPLIER.strSupplierCode

STRORDERCODE

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.

LINTITEMNUMBER

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.
link.gif (858 bytes) DEPT.strDeptCode

STRSUGGESTCAT

VARCHAR(10)

Suggested category for this item. This will be used as the ITEM.strCatCode.
link.gif (858 bytes) CATEGORY.strCatCode 

STRSUGGESTGROUP

VARCHAR(10)

Suggested group for this item. This will be used as the ITEM.strGroupCode.
link.gif (858 bytes) GROUPS.strGroupCode

STRSUGGESTFAMILY

VARCHAR(10)

Suggested family group for this item. This will be used as the ITEM.strFamilyCode.
link.gif (858 bytes) FAMILY.strFamilyCode

STRMANUFACTURER

VARCHAR(10)

The original manufacturer of the item.
link.gif (858 bytes) SUPPLIER.strSupplierCode

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.
link.gif (858 bytes) UNITOFMEASURE.strUnitOfMeasure

STRCLASSCODE

VARCHAR(10)

The classification of the item. This will be used as ITEM.strClassCode.
link.gif (858 bytes) CLASS.strClassCode

STRWETDRY

VARCHAR(10)

Indicates if this is a wet or dry item. D/W.

DBLUNITWEIGHT

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.

STRSUPPSUPPLIERCODE

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

D

Direct Supplied

W

Warehouse

C

Direct Supplied but charged through Warehouse

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.
link.gif (858 bytes) 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.

link.gif (858 bytes) SUPPLIER.strSupplierCode


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