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) |