Graphic Ticket and Voucher layouts
 
All tables in the local Data folder are open and may be referenced, but they may not be synched. Ticket and Voucher layouts use a table named csrTrans to print from. This table is created for each print job and is left on disk after the print job is complete. It is created in the Sales\Data folder. You can close Sales and investigate the contents of this file using Helper utility. Tickets and vouchers are printed from Sales by passing the transaction number. The following tables are synched:
 
Tables synched during normal printing (not using the pass reprint or IDCard feature)
Table
Sync field
Notes
access
printing.tmp_passno
If tmp_passno <> 0 and it’s an access product
accomdtn
resrvatn.accommodat
If transact.reserv_no <> 0
accounts
sale_hdr.acct_name
If transact.invoice_no <> 0
alladres
csrSaleTrans.guest_no_a
 
baselodg
resrvatn.base_lodge
If transact.reserv_no <> 0
bookinfo
transact.trans_no and guests.guest_no
 
cc_trans
transact.sale_no
 
csrResDWCards
N/A
Single record table
csrResGuest
guests.guest_no
 
csrSaleGuest
csrTrans.guest_no
 
csrSaleHdr
transact.sale_no
 
csrTrans
transact.trans_no
Primary table for printing.
csrTransGuest
transact.trans_no
 
dailycod
today's month/day
 
defaults
N/A
Single record table
gst_book
guests.guest_no
 
gst_pass
printing.tmp_passno
 
gst_rent
guests.guest_no
 
guests
printing.tmp_gstno
 
invoices
transact.invoice_no
If transact.invoice_no <> 0
items
transact.DCI
 
mktgcode
resrvatn.mktg_code
If transact.reserv_no <> 0
operator
transact.op_code
 
passinfo
printing.tmp_gstno
 
pkup_loc
resrvatn.pickup_loc
If transact.reserv_no <> 0
prefs
N/A
Single record table
prefs_bk
N/A
Single record table
printing
printing.tmp_formno
This field holds the rental contract number generated when FormIsTrans=TRUE is set in the Sales32c.INI file.
 
Note: The rentinfo.form_no field can also be used on Graphic layouts: alltrim(str(rentinfo.form_no,16,0))
rentinfo
transact.trans_no and guests.guest_no
 
resrvatn
sale_hdr.reserv_no
 
sale_hdr
transact.sale_no
 
sales_pt
N/A
Single record table
sh_save
transact.sale_no
 
specials
transact.special
If transact.special not blank
srcecode
resrvatn.srce_code
If transact.reserv_no <> 0
tmp_inv
N/A
Single record table
tr_save
trans_no from Sales
 
transact
trans_no from Sales
 
usercod1
resrvatn.user_code1
If transact.reserv_no <> 0
usercod2
resrvatn.user_code2
If transact.reserv_no <> 0
usercod3
resrvatn.user_code3
If transact.reserv_no <> 0
utility
transact.sale_no
 
wrapcode
resrvatn.wrap_code
If transact.reserv_no <> 0
 
Tables synched using the pass reprint or IDCard feature
Table
Sync field
Notes
defaults
N/A
Single record table
prefs
N/A
Single record table
sales_pt
N/A
Single record table
prefs_bk
N/A
Single record table
alladres
guests.guest_no
 
guests
printing.tmp_gstno
If not an IDCard
guests
gst_pass.guest_no
If it is an IDCard
gst_pass
printing.tmp_passno
 
items
printing.DCI