Home > Technical > Table Definitions > TAREWEIGHT

TAREWEIGHT

This is part of the Tare Weight functionality and is applicable to weighed scale items. This table stores the details of user defined Tare Weights and will be one of following types:

Tare Weights of the WEIGHT type must be assigned to a TAREWEIGHTGROUP via the TAREWEIGHTGROUPDTL table before they can be assigned to an item in a one-to-many relationship, whereas a specific PERCENTAGE type can be assigned to an item on a one-to-one relationship.

If a weighed item’s tare weight group has multiple Tare Weights assigned then the Point of Sale operator will be presented with a selectable list. The operator must select the Tare Weight to be applied. If a Tare Weight group has only one Tare Weight assigned, then that value will be automatically deducted without the need for user interaction.

PERCENTAGE Tare Weights are deducted after any WEIGHT Tare Weight deductions.

Example:

The following WEIGHT type Tare Weights and values can be defined:

SMALL           1.000

MEDIUM        1.500

LARGE            2.000

The following PERCENTAGE type Tare Weight and value can be defined:

WRAPPER      1.250

Given that an item is scanned, the operator selects the MEDIUM tare weight, and the item is then weighed as 10.000 KG. The value of 1.50 will be deducted from the weighed value and then 1.250 % of the weight will be calculated and deducted giving us our actual weight that is used to calculate the price of the item.

10.000 – 1.500 = 8.500

8.5000 – (8.500 / 100 * 1.250) = 8.39375 KG

Note: The resulting value is subject to the standard rounding rules that are applied to weighted items.

Column Type Description
STRTAREWEIGHTCODE VARCHAR(10)

The Tare Weight code.

STRTAREWEIGHTDESCRIPTION VARCHAR(50)

The Tare Weight description.

STRTAREWEIGHTTYPE VARCHAR(20)

The Tare Weight type using the following values:

WEIGHT

PERCENTAGE

DBLTAREWEIGHT DECIMAL(19,4)

The value of the tare weight (used in conjunction with STRTAREWEIGHTTYPE to represent either a weight or a percentage).

 

Primary Key: STRTAREWEIGHTCODE

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