Layouts : Reference : Tables and fields available for use from layouts : Tables and fields available from Graphic layouts : Graphic Receipts and Invoice layouts
 
Graphic Receipts and Invoice layouts
 
All tables in the local Data folder are open and may be referenced, but they may not be synched. The following tables are synched:
 
Table
Sync field
Notes
csrResDWCards
N/A
Single record table
defaults
N/A
Single record table
prefs
N/A
Single record table
prefs_bk
N/A
Single record table
tmp_inv
N/A
Single record table
cc_trans
printing.sale_no
 
sale_hdr
printing.Sale_no
 
sh_save
printing.Sale_no
 
tr_save
printing.Sale_no
 
transact
printing.Sale_no
 
utility
printing.sale_no
 
alladres
printing.tmp_gstno
If tmp_gstno <> 0
guests
printing.tmp_gstno
If tmp_gstno <> 0
access
printing.tmp_passno
If tmp_passno <> 0 and access product
gst_pass
printing.tmp_passno
If tmp_passno <> 0 and pass product
accomdtn
resrvatn.accommodat
If sale_hdr.reserv_no <> 0
baselodg
resrvatn.base_lodge
If sale_hdr.reserv_no <> 0
mktgcode
resrvatn.mktg_code
If sale_hdr.reserv_no <> 0
pkup_loc
resrvatn.pickup_loc
If sale_hdr.reserv_no <> 0
srcecode
resrvatn.srce_code
If sale_hdr.reserv_no <> 0
usercod1
resrvatn.user_code1
If sale_hdr.reserv_no <> 0
usercod2
resrvatn.user_code2
If sale_hdr.reserv_no <> 0
usercod3
resrvatn.user_code3
If sale_hdr.reserv_no <> 0
wrapcode
resrvatn.wrap_code
If sale_hdr.reserv_no <> 0
accounts
sale_hdr.acct_name
If transact.invoice_no <> 0
resrvatn
sale_hdr.reserv_no
 
items
transact DCI
 
invoices
transact.invoice_no
 
operator
transact.Op_code
 
specials
transact.special
 
csrTransGuest
transact.trans_no