Permission Areas: ClientPayment

Column Type Size Flags Table Description
agencyProcessed bool   Required, InsertOnly clientPayment  
payment_recNo long   PKey, Auto-Assign clientPayment  
clientProfile_recNo long   Required, InsertOnly, FKey clientPayment  
clientName_lookup string 256 ReadOnly, Lookup clientPayment  
person_recNo long   FKey clientPayment  
personName_lookup string 256 ReadOnly, Lookup clientPayment  
createVoucher bool     clientPayment  
voucherTripName string 256   clientPayment  
voucherRemarks string     clientPayment  
voucherAmount long     clientPayment  
noReservationRefresh bool     clientPayment  
transactionId string 32 ReadOnly, Lookup clientPayment  
authorizationCode string 16 ReadOnly, Lookup clientPayment  
originalTransactionId string 32   clientPayment  
payment [shared] table   Singleton clientPayment  
recNo long   PKey, InsertOnly, FKey payment  
amount long   Required, InsertOnly payment  
paymentDate Date   Required, InsertOnly payment  
method short   Required, InsertOnly payment Cash = 1, Check = 2, EFT = 3, CreditCard = 4, Other = 99
cardNumber string 64   payment  
expirationDate Date     payment  
nameOnCard string 64   payment  
checkNumber long     payment  
bank_recNo long   FKey payment  
remarks string     payment  
cardNumberToken string 64   payment  
voided bool     payment  
dateCleared Date     payment  
noBankBalanceRefresh bool     payment  
agencyCard_recNo long   InsertOnly, FKey payment  
agencyCard_name string 512 ReadOnly, Lookup payment  
billingAddress string 128   payment  
billingZipPostalCode string 16   payment  
cvvCode string 4   payment  
accountingEntry_recNo long   Auto-Assign payment  
paymentDetail table     payment  
payment_recNo long   PKey, InsertOnly, FKey paymentDetail  
reservation_recNo long   PKey, Required, FKey paymentDetail  
amount long   Required paymentDetail  
paymentAttachmentLink table     payment  
payment_recNo long   PKey, InsertOnly, FKey paymentAttachmentLink  
attachment_recNo long   PKey, Auto-Assign paymentAttachmentLink  
attachment [shared] table   Singleton paymentAttachmentLink  
recNo long   PKey, InsertOnly, FKey attachment  
type short   Required attachment Link = 1, File = 2
description string 256   attachment  
fileNameLinkURL string 256 Required attachment  
fileData byte[]     attachment  
size int     attachment  
compressed bool     attachment  
storeExternal short     attachment Database = 0, PrivateStorage = 1, PublicStorage = 2
createDateTime DateTimeOffset   ReadOnly, Lookup attachment  
visibility short   Required attachment Public = 1, Private = 2, Internal = 3
directUrl string 256 ReadOnly attachment  
subType short   Required attachment Document = 1, Image = 2, Other = 3
paymentTag table     payment  
recNo long   PKey paymentTag  
payment_recNo long   InsertOnly, FKey paymentTag  
tag_recNo long   Required, FKey paymentTag  
name string 64 ReadOnly paymentTag  
value string 1024   paymentTag  
accountingEntry [shared] table   Singleton payment  
recNo long   PKey, InsertOnly, FKey accountingEntry  
createDate Date   InsertOnly accountingEntry  
postDate Date     accountingEntry  
description string 512   accountingEntry  
accountingReference string 64   accountingEntry  
journalEntry_recNo long   Auto-Assign accountingEntry  
accountingEntryDetail table     accountingEntry  
recNo long   PKey accountingEntryDetail  
accountingEntry_recNo long   InsertOnly, FKey accountingEntryDetail  
description string 512   accountingEntryDetail  
accountCategory short   Required accountingEntryDetail None = 0, SupplierBalances = 2, UndepositedFunds = 3, CCProcessingBalances = 5, AgencyCCBalances = 6, BankAccount = 7, Sales = 8, CostOfSales = 9, RetainedEarnings = 10, Other = 99
accountNumber long     accountingEntryDetail  
debitAmount long     accountingEntryDetail  
creditAmount long     accountingEntryDetail  
journalEntry [shared] table   Singleton accountingEntry  
recNo long   PKey, InsertOnly, FKey journalEntry  
remarks string 512   journalEntry  
date Date   Required journalEntry  
type short   Required, InsertOnly journalEntry Standard = 1, YearEnd = 2
journalEntryDetail table     journalEntry  
recNo long   PKey journalEntryDetail  
journalEntry_recNo long   InsertOnly, FKey journalEntryDetail  
generalLedgerAccount_recNo long   Required, FKey journalEntryDetail  
debitAmount long     journalEntryDetail  
creditAmount long     journalEntryDetail  
remarks string 256   journalEntryDetail  
generalLedgerAccountName_lookup string 64 ReadOnly journalEntryDetail  
generalLedgerAccountCategory_lookup short   ReadOnly journalEntryDetail Assets = 1, Liabilities = 2, Capital = 3, Sales = 4, CostOfSales = 5, Expenses = 6
Status code Description
200 Ok
204 No Content
401 Unauthorized
403 Forbidden