Products Database Table

Distrbuted Access: Lanes( read insert edit delete CanSync Edits-require-TUBT )

Fields

pid

#100, Datatype: Integer

description

#101, Datatype: String 64 bytes
Shopper friendly description of item as might be printed on receipts and invoices

shortname

#102, Datatype: String 20 bytes
A short product description that can be used where space to print may be limited

unitprice

#103, Datatype: Money/Currency
Retail Price. List/base price as shown when price is requested, but may not be actual price charged to customer. This price is typically tax inclusive

r_spid

#104, Datatype: Integer

plucode

#105, Datatype: String 24 bytes
PLU code used by retailer to quickly locate a product. PLU codes are generally considered retailer specific although some industry standardisation does exist.

r_depid

#106, Datatype: Integer
Department Id used to group this product into a broad area

costprice

#108, Datatype: Money/Currency
Last known cost price of single item, typically exclusive of tax

PurchaseControl

#109, Datatype: Integer

pomenabled

#110, Datatype: Integer

mesurement

#111, Datatype: Integer
Unit of measure for this product. Is the product a 'unit' or measured in Kg, gm, L, time ....

tax1flag

#113, Datatype: Integer

mmid

#114, Datatype: Integer

dmid

#115, Datatype: Integer
Unit of measure to be used for display purposes.

bomid

#118, Datatype: Integer

u_fre

#147, Datatype: Money/Currency
Last known freight allocation for this product, exclusive of tax

priceband1

#148 An alternative price step that allows customers or stores to use alternative 'bands'

u_pac

#149, Datatype: Money/Currency
Last known packaging allocation for this product, exclusive of tax

sellflags

#150, Datatype: Integer

NoDiscount

#170, Datatype: Integer

pcat0

#172, Datatype: Integer

pcat1

#173, Datatype: Integer

stockimportance

#178, Datatype: Integer
A number from 1 to 10 indicating broad level of importance of this product. This value is manually set and often used as a broad sorting order

stockflags

#179, Datatype: Integer

WebGroup

#182 The broad group this product should be placed on an eCommerce site

supplysource

#196 Where is product broadly supplied from

Publish

#198, Datatype: Integer
Allow product to be visible to external public systems such as customer websites

Physkey

#210, Datatype: String 44 bytes

poscommand

#218, Datatype: String 240 bytes

priority

#220 Relative priority for ordering and stock control purposes. Products can be assigned to "Core", "On Special", "Other", "Retiring" or "Normal".

OrderMessage

#221 A message that is shown when item is being ordered. Allows communication between a stock controller and ordering staff on a per product basis

NoOrder

#222 This product cannot be ordered, it has been manually blocked. Typically used on products you wish to retire

MinOrderQty

#223 A minimum quantity of items that can be ordered. This value is the retailers minimum and suppliers may apply different minimums.

MaxOrderQty

#224 A maximum quantity of items that can be ordered on a single order. This is the retailers maximum, not a supplier maximum. Typically used to control over ordering.

retire_startdt

#225 The date this product was placed in retirement state

retire_enddt

#226 The date this product will end retirement and enter the deleted state

removaldt

#227 The date after which is item can be physically removed from remote systems.

shelflabel_line1

#228 The first line to be placed on a shelf label

shelflabel_line2

#229 The second line to be placed on a shelf label

shelflabel_line3

#230 The third line to be placed on a shelf label

perishable

#231 Indicates that product is perishable

polarised

#232 Indicates this item is polarised

mirrored

#233 Indicates this item has mirror finishing

marketingcolor_1

#234 A descriptive colour used for marketing descriptions

marketingcolor_2

#235 A descriptive colour used for marketing descriptions

marketingcolor_3

#236 A descriptive colour used for marketing descriptions

marketingcolor_4

#237 A descriptive colour used for marketing descriptions

placement

#238 A general indication of where this item might be found in a store

Possible Values

Value	Description
1	Bulk
2	Cabinet
3	Checkout
4	Display Case
5	Drawer
6	End Cap
7	Freezer
8	Outside
9	Promotion
10	Rack
11	Roof
12	Shelf
13	Wall
14	Window
41	Other #1
42	Other #2
43	Other #3
44	Other #4
45	Other #5

r_u_certid

#239 Organic Certification

PubUrlInst

#240 An internet URL containing installation instructions. Typically used as part of receipts to aid customers

PubUrlTerms

#241 An internet URL containing terms and conditions for warranties or guarantees. Typically used as part of receipts to aid customers

PubUrlUpsell

#242 An internet URL containing additional offers for purchasers of a product. May contain accesories (eg "Carry case", "Desktop stand") or spare parts ("Replacement bulb").

PubUrlMarketing

#243 An internet URL with marketing details of this product. Typically would be included on a quotation to refer them to you website.

OrderIcons

#244 Bitmask indicating additional icons to be displayed when on ordering screens, where supported.

rve

#249, Datatype: Double
Internal system field used for replication, ignore this field.

RmSystemXor

#250

RmSystem

#251, Datatype: String 44 bytes

NationalProduct

#252

ProcessFlags

#253

comments

#256, Datatype: String 250 bytes
Internal general purpose product specific comments

rvel

#257, Datatype: Double
Internal system field used for replication, ignore this field.

priceband2

#302 An alternative price step that allows customers or stores to use alternative 'bands'

priceband3

#303 An alternative price step that allows customers or stores to use alternative 'bands'

priceband4

#304 An alternative price step that allows customers or stores to use alternative 'bands'

priceband5

#305 An alternative price step that allows customers or stores to use alternative 'bands'

priceband6

#306 An alternative price step that allows customers or stores to use alternative 'bands'

priceband7

#307 An alternative price step that allows customers or stores to use alternative 'bands'

priceband8

#308 An alternative price step that allows customers or stores to use alternative 'bands'

priceband9

#309 An alternative price step that allows customers or stores to use alternative 'bands'

priceband10

#310 An alternative price step that allows customers or stores to use alternative 'bands'

priceband11

#311 An alternative price step that allows customers or stores to use alternative 'bands'

priceband12

#312 An alternative price step that allows customers or stores to use alternative 'bands'

PageYield

#313, Datatype: String 48 bytes
Number of pages this product can print or produce

ManuPartCode

#314, Datatype: String 250 bytes
The part code assigned by the original manufacturer

PublishType

#315, Datatype: Integer
A coded number indicating how this product should be used on a website. 0=normal selling item. 1=display purposes only, cannot be added to shopping trolleys

WebSearchRank

#316, Datatype: Integer
Suggested ranking order to display on a web search page. 1=highest

SellingMsg

#317, Datatype: String 250 bytes
Simple text message displayed on screen when item sold

WebsiteControl

#318 Free form text that is sent to website as an indicator for programs. Do not use for general product details

WebDisplayRank

#319 Suggested display order to display on a web. 1=highest/first

ReorderLevel

#320, Datatype: Integer

ReorderMax

#321, Datatype: Integer

glcode

#322

franchiseprice

#325, Datatype: Money/Currency
Franchise Retail Price. Price recommended by head office or franchise owner. This price is not used as part of selling process directly.

proddef

#326, Datatype: Integer

vintage

#327

ordercategory

#328

globalkey

#329

glacct

#330

gldesc

#331

NonStock

#332

maxpurchase

#333

nocredit

#334

ForeignPrice

#335

ForeignCurrency

#336

SitePrice1

#337

SitePrice2

#338

SitePrice3

#339

TransferPrice

#340

LandedPrice

#341

ExtractFlags

#342, Datatype: Integer

decimalplaces

#346, Datatype: Integer
Overrides number of decimal places to print for a product

Possible Values

Value	Description
0	Use system default
32	None
33	1 decimal place
34	2 decimal places
35	3 decimal places
36	4 decimal places

profilevisibility

#347, Datatype: Integer
Bitmask that disables this product from appearing in a lane depending on the lanes profile

model

#348, Datatype: String 40 bytes

shelflabelformat

#349, Datatype: String 44 bytes

r_depid2

#350, Datatype: Integer
Department Id(2) used to group this product into a broad area

r_depid3

#351, Datatype: Integer
Department Id(3) used to group this product into a broad area

r_depid4

#352, Datatype: Integer
Department Id(4) used to group this product into a broad area

length

#353, Datatype: Integer
Length in mm of product

width

#354, Datatype: Integer
Width in mm of product

height

#355, Datatype: Integer
Height in mm of product

shippingcubic

#356, Datatype: Double
Shipping size in cubic metres

ItemColor

#357, Datatype: String 40 bytes
Color of the item itself. A red pen packaged in a blue box would have red in this field

Cartridge

#358, Datatype: String 40 bytes
Name of the cartridge used by this product

CategorisationFlags

#359, Datatype: Integer

internalsupporturl

#361, Datatype: String 240 bytes
A url reference for this product to an internal web page that may contain additional information

bluelight

#362, Datatype: Integer
Mark a product as having blue light attribute. Typically used in the eyewear industry

releasedate

#363, Datatype: DateTime
The date this product is released into your store. Typically used for eCommerce sites

AvailableFromDate

#364, Datatype: DateTime
The date this product is available for purchase. Typically used for eCommerce sites. This date does not stop the POS from selling the item, but a future release might prompt for verification

ClassificationFlags

#365, Datatype: Integer

r_depid5

#371, Datatype: Integer
Department Id(5) used to group this product into a broad area

r_depid6

#372, Datatype: Integer
Department Id(6) used to group this product into a broad area

r_depid7

#373, Datatype: Integer
Department Id(7) used to group this product into a broad area

r_depid8

#374, Datatype: Integer
Department Id(8) used to group this product into a broad area

supplierrrp

#375, Datatype: Money/Currency
RRP as outlined by a supplier or manufacturer

wholesaleprice1

#376, Datatype: Money/Currency
A wholesale price, whatever that means within your environment

wholesaleprice2

#377, Datatype: Money/Currency
A wholesale price, whatever that means within your environment

wholesalePrice3

#378, Datatype: Money/Currency
A wholesale price, whatever that means within your environment

wholesaleprice4

#379, Datatype: Money/Currency
A wholesale price, whatever that means within your environment

rxable

#380, Datatype: Integer
Can this item be used as part of a prescription

Possible Values

Value	Description
0	Unknown
1	Yes
2	No
3	Probably

casephyskey

#381, Datatype: String 44 bytes
Product that is the case of this item

warranty

#382, Datatype: String 140 bytes
Short warranty description as might be printed on customer receipts

manufacturerphyskey

#383, Datatype: String 44 bytes
The original manufacturer of this item

preposcommand

#384, Datatype: String 250 bytes
PosCommand issued before item is added to sale. When used, the product is not usually automatically added to the sale.

firmware

#385, Datatype: String 60 bytes
Current firmware level of product. Typically used as part of product lookup and checking

SellingMsgDist

#386 Simple text message provided by central server that is displayed on screen when item sold.

sellcondition

#387, Datatype: String 80 bytes
A control applied to the product when selected for selling to ensure current POS is able to sell this item

GatewayCrossRm

#520, Datatype: String 220 bytes

GatewayFormula

#522

VisibilityFormula

#523 Formula that controls if product is visible or not

u_AdditionalInfo

#20001

u_BulkQty

#20002

u_r_cartid

#20003, Datatype: Integer

checksheetreqd

#20004

LTSAPmtNoReqd

#20005

RegnoReqd

#20006

f8389009,u_brandname

#8389009, Datatype: String 64 bytes
Brand Name. The actual textual description of the brand.

f8388814

#8388814, Datatype: Integer
Weight, in Grams

MainColour

#8388908, Datatype: Integer
Main colour of item packaging if only one single colour was to be named. A red pen packaged in a blue box would have blue in this field

KnownBrandId

#8389008 Reference to standard brand names. Rarely used

MadeFrom

#8389208 List of materials this item is made from

DesignShape

#8389308 Shape of the item

f8390617

#8390617 English. Descriptive text of item. Short. Expected to be less than 200 letters. Typical use is under reference images on menu pages

webgroup

#8390712

f8390716

#8390716, Datatype: Integer
Special indicator. Used by Websites to indicate product should be marked on special or other agreed purpose.

f8390717

#8390717 Out of Stock indicator. This indicator is manually set as an override to indicate to web sites that this product should be considered out of stock, regardless of any other stock level indication.

f8390718

#8390718 Only available instore indicator. Used to indicate to websites that this product should be marked in-store purchase only

f8390719

#8390719 Delivery Charge indicator. A coded value indicating levels of delivery charge.

f8390720

#8390720 New Product indicator. Used by Websites to indicate this is considered a "new" product for this retailer. The exact meaning and duration of "new" is left to the individual retailer to decide.

WebHighlight

#8390721 Highlight indicator. Used by Websites as a suggestion they should prioritise or highlight this product.

f8391117

#8391117

f8392117

#8392117 English. Keywords for product search

f8391608

#8391608, Datatype: Integer
Gluten Free Indicator

f8391612

#8391612, Datatype: Integer
Vegan Indicator

f8392608

#8392608 Fair Trade Indicator.

f8392609

#8392609 Out of Season Indicator. Set to indicate that a seasonal product is currently out of season.

NZMade

#8392772 New Zealand made indicator

lenstype

#8393608

as_nzs_1067_2003

#8394608, Datatype: Integer

f8394609

#8394609 Prompt Vehicle registration number

f8394610

#8394610 Prompt LTNZ Reference number

f8394611

#8394611 Prompt for external document serial number. This is used for serialised forms that are used as part of selling this item.

f8394613

#8394612 Prompt Customer Details

f8408610

#8408610 Person gender this product is mainly designed for. This is about the product, not the customers gender preference

Possible Values

Value	Description
A	Unisex
F	Female
M	Male
T	Transexual
f	slightly female
m	slighly male
t	slightly transexual

WebHighlightflags

#8480000

WebsiteTag

#8481000, Datatype: String 48 bytes
A short phrase or single word 'tag' that might be applied to a product. Examples might be 'new' 'on special' 'reduced'