Home > Item Management > Labels And Tickets > Concepts > Data Type

Data Type

The Sell price fields come from the SELL table for the location the ticket is printed for; most of the other fields are populated from the ITEM table. The difference between ‘normal’ and ‘sell’ price is excluding any promotions and we support up to 5 price levels.

Note: Customer related data types are not currently supported.

Data Type

 

Address 1

strAddr1

Address 2

strAddr2

APN

strAPN

Barcode APN

Barcode APN

Barcode Customer

Barcode Customer

Barcode IPN

Barcode IPN

Barcode IPN+Sell

Barcode IPN+Sell

Barcode Order

Barcode Order

Barcode Order+Sell

Barcode Order+Sell

Barcode Serial

strBarcodeText

Batch#

Batch#

Birthday

dtmBirthday

Bonus Description

strBonusDescription

Bonus IPN

lintBonusItemNumber

Bonus Label

strBonusLabel

Bonus Label+Description

strBonusLabel + strBonusDescription

Bonus Order Code

strBonusOrderCode

BrandName

strProductBrandName /strBrandName

Brand+Description

strBrandName + strItemDescription

Card Number

strCardNum

Carton Size

intCartonSize

Category

strCategory

City

strCity

Classification

Classification

Comments

memComments

Comments 2

memComments2

Currency Code - Primary

strCurrencyCode

Currency Code - Secondary

strCurrencyCode2

Customer Number

lintCustomerNum

Customer Points

Customer Points

Department

strDeptCode

Description

Description

Driving Licence

strDriversLicence

Email

strEmail

Employment

strEmployment

English Description

strEnglishDescription

Family Code

strFamilyCode

Family Code + Desc

strFamilyCode + strFamilyDescription

Family Group Desc

strFamilyGroup

Family Name

strBrandName + strItemDescription

Fax

strFax

Fit

strProductFit

First Name

strFirstName

Form Of Product

strFormOfProduct

Full Address

strAddr1 + strAddr2 + strCity + strState + strPostcode

Full Description

strBrandName + strItemDescription + strColour + strSize+strFit

Full Name

strTitle + strFirstName + strLastName

Full Postal Address

strAddr1Post + strAddr2Post + strCityPost + strStatePost + strPostcodePost

Grade

Grade

Group

Group

Initials

strInitials

Item Number

lintItemNumber

Last Name

strLastName

Long Description

strLongDescription

Manufacturer

strManufacturer

Manufacturer Country

strManufacturerCountry

Max Stock Qty

dblMaxStockQty

Min Stock Qty

dblMinStockQty

Minimum Order Qty

intMinOrder

Mobile

strMobile

Normal Sell Price 1

curSell strDollars strCents

Normal Sell Price 1 (Cents)

curSell strCents

Normal Sell Price 1 (Dollars)

curSell strDollars

Normal Sell Price 2

Normal Sell Price 2

Normal Sell Price 2 (Cents)

Normal Sell Price 2 (Cents)

Normal Sell Price 2 (Dollars)

Normal Sell Price 2 (Dollars)

Normal Sell Price 3

Normal Sell Price 3

Normal Sell Price 3 (Cents)

Normal Sell Price 3 (Cents)

Normal Sell Price 3 (Dollars)

Normal Sell Price 3 (Dollars)

Normal Sell Price 4

Normal Sell Price 4

Normal Sell Price 4 (Cents)

Normal Sell Price 4 (Cents)

Normal Sell Price 4 (Dollars)

Normal Sell Price 4 (Dollars)

Normal Sell Price 5

Normal Sell Price 5

Normal Sell Price 5 (Cents)

Normal Sell Price 5 (Cents)

Normal Sell Price 5 (Dollars)

Normal Sell Price 5 (Dollars)

Order Code

strOrderCode

Password

strPassword

Phone

strPhone

Points

intPoints

POS 12 Description

POS 12 Description

POS 20 Description

POS 20 Description

Postal Address 1

strAddr1Post

Postal Address 2

strAddr2Post

Postal City

strCityPost

Postal Postcode

strPostcodePost

Postal State

strStatePost

Prefer Name

strPreferName

Price Per Unit Code

Price Per Unit Code

Price Per Unit Sell 1

Price Per Unit Sell 1

Price Per Unit Sell 2

Price Per Unit Sell 2

Price Per Unit Sell 3

Price Per Unit Sell 3

Price Per Unit Sell 4

Price Per Unit Sell 4

Price Per Unit Sell 5

Price Per Unit Sell 5

Product Reference 1

strProductReference1

Product Reference 2

strProductReference2

Product Reference 3

strProductReference3

Product Reference 4

strProductReference4

Product Reference 5

strProductReference5

Profit Flag

strProfitFlag

Rate Of Sale

dblRateOfSale

Registered Trademark

strRegisteredTrademark

Save 1

Save 1

Save 1 (Cents)

Save 1 (Cents)

Save 1 (Dollars)

Save 1 (Dollars)

Save 2

Save 2

Save 2 (Cents)

Save 2 (Cents)

Save 2 (Dollars)

Save 2 (Dollars)

Save 3

Save 3

Save 3 (Cents)

Save 3 (Cents)

Save 3 (Dollars)

Save 3 (Dollars)

Save 4

Save 4

Save 4 (Cents)

Save 4 (Cents)

Save 4 (Dollars)

Save 4 (Dollars)

Save 5

Save 5

Save 5 (Cents)

Save 5 (Cents)

Save 5 (Dollars)

Save 5 (Dollars)

Save Label

strSaveLabel

Save Value

strSaveValue

Season

strSeasonCode

Sell End Date

dtmSell End

Sell Price 1

curSell strDollars strCents

Sell Price 1 (Cents)

curSell strCents

Sell Price 1 (Dollars)

curSell  strDollars

Sell Price 2

Sell Price 2

Sell Price 2 (Cents)

Sell Price 2 (Cents)

Sell Price 2 (Dollars)

Sell Price 2 (Dollars)

Sell Price 3

Sell Price 3

Sell Price 3 (Cents)

Sell Price 3 (Cents)

Sell Price 3 (Dollars)

Sell Price 3 (Dollars)

Sell Price 4

Sell Price 4

Sell Price 4 (Cents)

Sell Price 4 (Cents)

Sell Price 4 (Dollars)

Sell Price 4 (Dollars)

Sell Price 5

Sell Price 5

Sell Price 5 (Cents)

Sell Price 5 (Cents)

Sell Price 5 (Dollars)

Sell Price 5 (Dollars)

Serial# - Supplier

strOrigSerialNumber

Serial# - Ours

strOurSerialNumber

Serial# - Full

strReadableText

Size

strSize

Size+Description

strSize + strFit + strItemDescription

Size+Fit

strSize+strFit

Specification

strSpecification

State

strState

Store Code

Store Code

Subgroup

Subgroup

Supplier Code

SupplierCode

Tax Exemption Number

strTaxexempt

Ticket Type

Ticket Type

Ticket Date

dtmTicketDate

Title

strTitle

Unit Of Measure

strUnitOfMeasure

Use By Date

dtmUseByDate

Valid From

dtmValidFrom

Valid To

dtmValidTo

Variety

strColour

Warranty Descriptions

memWarrantyDescriptions

Warranty Sell

curWarrantySell

Warranty Sells

memWarrantySells

Work Phone

strWorkPhone

Year

strYearCode

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