Home > Item Management > Labels And Tickets > Concepts > 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 |
|
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) |