Fields for Text Ticket layouts
 
The table below contains field types and their descriptions used for Text Ticket layouts.
 
Field type
Description
Character
A string of characters of a defined length (from 1 to 255) – holds anything that can be typed on the keyboard
Memo
A character field with no size limit (limited by available memory)
Integer
Number with no decimal places; can be positive or negative; numbers from –2147483647 to 2147483647 can be stored in 4 bytes
Currency
Numbers that represent money; are normally displayed with two decimal places but store as four decimal places for calculation; can be positive or negative
Logical
Can be true or false – stored in 1 byte
Numeric
A numeric value either integer or decimal
Double
A double-precision floating-point number
 
The table below contains many of the most common fields used by Text Ticket layouts.
 
Field name
Field description
Field type and size
Tmp_aAddr
Address for account
Character – 25
Tmp_aArea
Area code for account
Character – 5
Tmp_access
Access number
Double – 8
Tmp_aChk1
Account user def check box 1
Logical – 1
Tmp_aChk2
Account user def check box 2
Logical – 1
Tmp_aChk3
Account user def check box 3
Logical – 1
Tmp_aChk4
Account user def check box 4
Logical – 1
Tmp_aChk5
Account user def check box 5
Logical – 1
Tmp_aCity
Account city
Character – 15
Tmp_aCont
Account contact
Character – 25
Tmp_aDate1
Account user-defined date 1
Character – 10
Tmp_addr
Primary guest address 1
Character – 25
Tmp_addr2
Primary guest address 2
Memo – 4
Tmp_aDesc
Account description
Character – 25
Tmp_admisn
Number of admissions per item
Integer – 4
Tmp_aDtime
Account user-defined date 2
Character – 16
Tmp_aLimit
Account credit limit
Double – 8
Tmp_aMemo1
Account user def memo
Memo – 4
Tmp_aName
Account name
Character – 25
Tmp_aNotes
Account notes
Memo – 4
Tmp_aNum1
Account user def numeric 1
Integer – 4
Tmp_aNum2
Account user def numeric 2
Integer – 4
Tmp_aNum3
Account user def numeric 3
Integer – 4
Tmp_aNum4
Account user def numeric 4
Double – 8
Tmp_aNum5
Account user def numeric 5
Double – 8
Tmp_aPhone
Account phone number
Character – 8
Tmp_area
Primary guest area code
Character – 5
Tmp_aState
Account state
Character – 2
Tmp_aTxt1
Account user def text 1
Character – 15
Tmp_aTxt2
Account user def text 2
Character – 15
Tmp_aTxt3
Account user def text 3
Character – 15
Tmp_aTxt4
Account user def text 4
Character – 15
Tmp_aTxt5
Account user def text 5
Character – 15
Tmp_aZip
Account zip code
Character – 10
Tmp_bage
Age of the booked guest
Character – 3
Tmp_bedt
Booking end date
Character – 10
Tmp_betm
Booking end time
Character – 8
Tmp_bifnm
Booking instructor – first name
Character – 10
Tmp_bilnm
Booking instructor – last name
Character – 10
Tmp_birth
Primary guest birth date
Character – 10
Tmp_bloc
Lesson location
Character – 10
Tmp_blvl
Booking level
Character – 1
Tmp_bnum
Booking ID
Double – 8
Tmp_bsdt
Booking start date
Character – 10
Tmp_bstm
Booking start time
Character – 8
Tmp_cat
Category nickname
Character – 10
Tmp_city
Primary guest city
Character – 15
Tmp_copp
Access number and expiration date
Character – 12
Tmp_cprsn
Comp person
Character – 15
Tmp_crsn
Comp reason
Character – 15
Tmp_date
Item start date
Character – 10
Tmp_dept
Department nickname
Character – 10
Tmp_disc
Discount amount
Numeric – 12
Tmp_dusesl
Pass - number of uses left today
Integer – 4
Tmp_edate
Item end or expiration date
Character – 10
Tmp_ext
Item price + tax + fees
Numeric – 12
Tmp_fee
Fee amount
Numeric – 12
Tmp_fname
Primary guest first name
Character – 10
Tmp_formno
Rental Contract Number
Numeric - 12
Tmp_glno
Item GL number
Character – 12
Tmp_gNotes
Primary guest notes
Memo – 4
Tmp_group
Primary guest group
Character – 10
Tmp_gstno
Primary guest number
Double – 8
Tmp_idesc
Item description
Character – 25
Tmp_invno
Invoice number
Double – 8
Tmp_item
Item nickname
Character – 10
Tmp_lname
Primary guest last name
Character – 15
Tmp_loc
Location or salespoint name
Character – 6
Tmp_mod1
Modifier 1 description
Memo – 4
Tmp_mod2
Modifier 2 description
Memo – 4
Tmp_mod3
Modifier 3 description
Memo – 4
Tmp_mod4
Modifier 4 description
Memo – 4
Tmp_mod5
Modifier 5 description
Memo – 4
Tmp_mod6
Modifier 6 description
Memo – 4
Tmp_mod7
Modifier 7 description
Memo – 4
Tmp_mod8
Modifier 8 description
Memo – 4
Tmp_mod9
Modifier 9 description
Memo – 4
Tmp_money1
Pass money1 current value
Currency – 8
Tmp_money2
Pass money2 current value
Currency – 8
Tmp_msg
Line item message
Character – 20
Tmp_oper
Operator log-in name
Character – 6
Tmp_otlvl
Other level
Character – 1
Tmp_parent
Description of modifier’s parent item
Character – 25
Tmp_pasacc
Account associated with pass
Character – 10
Tmp_pasamt
Amount paid for pass
Currency – 8
Tmp_passno
Pass number (for item)
Double – 8
Tmp_pboe
Pass blackout end date
Character – 10
Tmp_pbos
Pass blackout start date
Character – 10
Tmp_pChk1
Primary guest user def chk box 1
Logical – 1
Tmp_pChk2
Primary guest user def chk box 2
Logical – 1
Tmp_pChk3
Primary guest user def chk box 3
Logical – 1
Tmp_pChk4
Primary guest user def chk box 4
Logical – 1
Tmp_pChk5
Primary guest user def chk box 5
Logical – 1
Tmp_pDate1
Primary guest user def date 1
Character – 10
Tmp_pDtime
Primary guest user def date 2
Character – 16
Tmp_phone
Primary guest phone number
Character – 8
Tmp_pMemo1
Primary guest user def memo
Memo – 4
Tmp_pNum1
Primary guest user def numeric 1
Integer – 4
Tmp_pNum2
Primary guest user def numeric 2
Integer – 4
Tmp_pNum3
Primary guest user def numeric 3
Integer – 4
Tmp_pNum4
Primary guest user def numeric 4
Double – 8
Tmp_pNum5
Primary guest user def numeric 5
Double – 8
Tmp_price
Item price
Numeric – 12
Tmp_prnt1
Ticket 1 layout type
Numeric – 1
Tmp_prnt2
Ticket 2 layout type
Numeric – 1
Tmp_prnv1
Voucher 1 layout type
Numeric – 1
Tmp_prnv2
Voucher 2 layout type
Numeric – 1
Tmp_prtmsg
Print message (DirectNet)
Character – 40
Tmp_ptcomp
Pass total comp tickets given
Integer – 4
Tmp_pts1
Pass points1 current value
Integer – 4
Tmp_pts2
Pass Points2 current value
Integer – 4
Tmp_pTxt1
Primary guest user def text 1
Character – 15
Tmp_pTxt2
Primary guest user def text 2
Character – 15
Tmp_pTxt3
Primary guest user def text 3
Character – 15
Tmp_pTxt4
Primary guest user def text 4
Character – 15
Tmp_pTxt5
Primary guest user def text 5
Character – 30
Tmp_pwarn
Number of warnings on pass
Integer – 4
Tmp_qty
Quantity of item sold
Numeric – 4
Tmp_rrsn
Refund reason
Character – 15
Tmp_saleno
Sale number
Double – 8
Tmp_sblvl
Snowboard level
Character – 1
Tmp_sfirst
Saved sale first name
Character – 10
Tmp_slast
Saved sale last name
Character – 15
Tmp_spcd
Special description
Character – 25
Tmp_spct
Special name
Character – 25
Tmp_state
Primary guest state
Character – 2
Tmp_swipe
Swipe number
Character – 22
Tmp_t1gprn
Ticket 1 assigned graphics printer
Character – 32
Tmp_t1lay
Ticket 1 assigned layout
Memo – 4
Tmp_t1prt
Ticket 1 assigned dot matrix printer
Character – 30
Tmp_t1qty
Ticket 1 quantity (for ignore qty)
Integer – 4
Tmp_t1wprn
Ticket 1 Windows printer
Character – 100
Tmp_t2gprn
Ticket 2 assigned graphics printer
Character – 32
Tmp_t2lay
Ticket 2 assigned layout
Memo – 4
Tmp_t2prt
Ticket 2 assigned dot matrix printer
Character – 20
Tmp_t2qty
Ticket 2 quantity (for ignore qty)
Integer – 4
Tmp_t2wprn
Ticket 2 Windows printer
Character – 100
Tmp_tax
Tax amount
Numeric – 12
Tmp_taxa
TaxA amount
Numeric – 12
Tmp_taxb
TaxB amount
Numeric – 12
Tmp_telvl
Telemark level
Character – 1
Tmp_time
Time item was sold
Character – 5
Tmp_totqty
Total quantity sold of the line item
Numeric – 4
Tmp_tranno
Transact number
Double – 8
Tmp_tspan
Number of days an item is good
Integer – 4
Tmp_tuses
Pass - number of total uses left
Integer – 4
Tmp_v1lay
Voucher 1 assigned layout
Memo – 4
Tmp_v1prt
Voucher 1 dot matrix printer
Character – 30
Tmp_v1qty
Voucher 1 quantity (for ignore qty)
Integer – 4
Tmp_v1wprn
Voucher 1 Windows printer
Character – 100
Tmp_v2lay
Voucher 2 assigned layout
Memo – 4
Tmp_v2prt
Voucher 2 dot matrix printer
Character – 30
Tmp_v2qty
Voucher 2 quantity (for ignore qty)
Integer – 4
Tmp_v2wprn
Voucher 2 Windows printer
Character – 100
Tmp_valno
Validation number
Double – 8
Tmp_wusesl
Pass - uses per week left
Integer – 4
Tmp_zip
Primary guest zip code
Character – 10
 
Additionally, you are able to use any field in the guests, alladres, gst_pass, access, alltrans, transact, accounts, invoices, operator and sale_hdr tables.
 
Note: To use a field other than the fields listed above (which are in the Printing table), the local table where the field is located must be determined, the field name must be known and the following format is used:
 
local_table->local_table_field_name
 
Example:
SALES_PT->salespoint retrieves the name of the salespoint from the SALES_PT table.