{address1}

{address2}

{address3}

{alpha_code}

The alphanumeric code for the sale for the barcode

x

x

{amount}

x

{area}

Blank if tblProd.GenAdmit = 'Y'

x

x

{area_description}

Blank if tblProd.GenAdmit = 'Y'

x

{area_1_seat_range}

Contiguous seat ranges

x

{area_1}

Name of first area

x

{area_2_seat_range}

Contiguous seat ranges

x

{area_2}

Name of second area

x

{area_3_seat_range}

Contiguous seat ranges

x

{area_3}

Name of third area

x

{audit}

x

{auth_code}

{book_type}

x

{book_type_short}

First word

x

{business}

x

x

{card_expiry}

Stored as yymm but displayed as mm/yy

x

{card_name}

The name on the credit card

x

{card_number_full}

In its full glory, with no digits obscured

x

{card_number}

Formatted nnnn…nnnn

x

{city_or_blank}

Fourth line of preferred address or WebMailCity, depending on user choice

x

x

{city}

{contact_first_name}

Blank if the sale has no contact patron set

x

{contact_name}

Blank if the sale has no contact patron set

x

{contact_surname}

Blank if the sale has no contact patron set

x

{date}

{due_date}

x

{due_date_long}

x

{due_day}

x

{due_month}

x

{due_year}

x

{entry_label}

x

{expiry_date_long}

Format: d mmm yyyy

x

x

{expiry_date}

Format: dd/mm/yy

x

x

{expiry_day}

x

{expiry_month}

x

{expiry_year}

x

{first_name}

x

x

x

x

{force_area}

Ignores value of tblProd.GenAdmit = 'Y'

x

{force_area_description}

Ignores value of tblProd.GenAdmit = 'Y'

x

{force_row}

Ignores value of tblProd.GenAdmit = 'Y'

x

{force_seat}

Ignores value of tblProd.GenAdmit = 'Y'

x

{issue_date}

x

{issue_date_long}

x

{issue_day}

x

{issue_month}

x

{issue_year}

x

{line1_not_blank}

First line of preferred address or if blank, the line below it

x

{line1_or_blank}

First line of preferred address

x

x

{line2_not_blank}

Second line of preferred address or if blank, the line below it

x

x

{line2_or_blank}

Second line of preferred address

x

x

{line3_not_blank}

Third line of preferred address or if blank, the line below it

x

x

{line3_or_blank}

Third line of preferred address

x

x

{line4_not_blank}

Fourth line of preferred address or if blank, the line below it

x

x

{line5_not_blank}

Fifth line of preferred address or blank (despite the name). The _not_blank series of fields should be used together, and allows the possibility of suppressing blank lines on address labels, because a blank line causes all subsequent lines to be moved up one.

x

x

{mailout}

Mailout if they selected this option during the booking, otherwise Collect (for all sales including non-web sales)

x

{member_category}

x

{merchant_abn_number}

From tblSettings Tax Number

x

x

x

{merchant_address1}

From tblSettings

x

{merchant_address2}

From tblSettings

x

{merchant_gst_number}

From tblSettings Tax Number

x

x

x

{merchant_id}

Where ProprtyName = 'cc_merchant_id'

x

{merchant_name}

CompanyName from tblSettings

x

{merchant_phone}

From tblSettings

x

{message_long}

x

{message_short}

x

{more_areas}

Blank if there are 3 or less areas, otherwise the text: 'plus n more areas'

x

{more_seats}

{name}

x

x

x

{num_code}

The numeric code for the sale (i.e. digits and #) for the barcode

x

x

{paid_total}

Sum for this sale

x

{patron_phone}

{payment_type}

x

{payment}

If = 'Y' then 'PAID', otherwise '****'

x

x

{performance_date}

Format: dd/mm/yy

x

x

x

{performance_date_dd}

Format: dd - i.e. day in month

x

x

{performance_date_long}

Format: d mmm yyyy

x

x

x

{performance_date_mm}

Format: mm - i.e. month number

x

x

{performance_date_month}

Format: mmm i.e. month name Jan, Feb, ...

x

x

{performance_date_yy}

Format: yy - i.e. two-digit year

x

x

{performance_date_yyyy}

Format: yyyy - i.e. four-digit year

x

x

{performance_day}

Format: ddd (I.e. Mon,Tue,Wed, etc.)

x

x

x

{performance_time}

Format: h:nn am/pm

x

x

x

{performance_seat_count}

Sum for this performance

x

{performance}

{phone}

If blank, same as 'business' below

x

x

{postcode}

If = 0 then ''

x

x

{price}

x

{print_serial}

Count of the number of seats printed for this performance. Reprinted tickets will have a higher serial than the original ticket. The highest serial number is likely to be greater than the number of seats sold.

x

{print_time}

Format:yyyy-mm-dd hh:mi:ss

x

{prod_id}

x

x

{product_1}

The first product (alphabetically) on the sale, if any

x

{product_2}

The second product (alphabetically) on the sale, if any

x

{product_name}

Ucase

x

{product_total}

Sum for this sale

x

{production}

x

{rating}

x

{reference}

x

{reprint}

If > 0 then 'REPRINT', otherwise blank

x

x

{row}

Blank if tblProd.GenAdmit = 'Y'

x

x

{sale_id}

x

x

x

{sale_seat_count}

Sum for this sale

x

{seat_total}

Sum for this sale

x

{seat}

Blank if tblProd.GenAdmit = 'Y'

x

x

{seat_type}

x

{section}

x

{section_description}

x

{state_or_blank}

x

x

{state}

{still_to_pay}

Total_due - paid_total

x

{surname}

x

x

x

x

{tag}

x

{tags}

x

{ticket_title}

x

x

{ticket_title_short}

First 12 Chars

x

x

{ticket_title_1}

The first production (alphabetically) on the sale, if any

x

{ticket_title_2}

The second production (alphabetically) on the sale, if any

x

{total_due}

Seat_total + product_total

x

{total_price}

x

{total}

{transaction_date_day}

Format: ddd (ie. Mon,Tue,Wed, etc.)

x

{transaction_date_long}

Format: d mmm yyyy

x

{transaction_date_time}

Format: h:nn am/pm

x

{transaction_date}

Format: dd/mm/yy

x

{transaction_ref}

tblCardTransaction, SequenceNumber

x

{transaction_seq}

tblCardTransaction, SequenceNumber

x

{transaction_text}

tblCardTransaction, SequenceNumber

x

{uid}

Patron UID

x

x

x

x

x

x

{user}

Currently logged in Operator

x

x

x

{valid_for}

Expiry Date, or Production Name if Expiry Date is blank

x

{value}

NumSeats or VoucherValue ; 'n seats' or '$d.cc'

x

{venue}

Ucase

x

x

x

{venue_address}

x

{venue_serial}

Count of the number of seats with area/row/seat ID <= this seat. Reprinted tickets will have the same serial as the original ticket, but changes to the performance seating plan will make previously printed serials invalid. This serial depends on the seat coordinates, so the first one is not guaranteed to be 1 and they are not guaranteed to be consecutive (but they probably will be for GA productions).

x

{venue_short}

Ucase, If EntryLabel <> '' then First 14 Chars

x

{voucher_id}

x