Permission Areas: SupplierPayment

Column Type Size Flags Table Description
recNo long   PKey paymentRecon  
fileData byte[]     paymentRecon  
provider short   Required paymentRecon Onyx = 1, Paymode = 2
supplierProfile_recNo long     paymentRecon  
supplierProfile_Name string 256 ReadOnly, Lookup paymentRecon  
bank_recNo long     paymentRecon  
achCheckNo string 48   paymentRecon  
paymentDate Date     paymentRecon  
paymentMethod short     paymentRecon Cash = 1, Check = 2, EFT = 3, CreditCard = 4, Other = 99
serviceFeeAmount long   Required paymentRecon  
description string 128   paymentRecon  
supplierPayment_recNo long     paymentRecon  
lastAttemptErrorCount int     paymentRecon  
periodEndDate Date     paymentRecon  
serverTrigger short     paymentRecon AutoRecon = 1, Finalize = 2
paymentReconDetail table     paymentRecon  
recNo long   PKey paymentReconDetail  
paymentRecon_RecNo long   InsertOnly, FKey paymentReconDetail  
commissionAmount long   Required paymentReconDetail  
commissionRate short     paymentReconDetail Percentage values have an implied 2 digits after the decimal point. A value of 25% is represented as 2500
chainCode string 2   paymentReconDetail  
arcNo long     paymentReconDetail  
cityCode string 4   paymentReconDetail  
voidReservation bool   Required paymentReconDetail  
issueDate Date     paymentReconDetail  
traveler string 256   paymentReconDetail  
confirmation string 64   paymentReconDetail  
totalFare long   Required paymentReconDetail  
startDate Date     paymentReconDetail  
endDate Date     paymentReconDetail  
notes string 128   paymentReconDetail  
recordLocator string 32   paymentReconDetail  
providerName string 256   paymentReconDetail  
street1 string 128   paymentReconDetail  
street2 string 128   paymentReconDetail  
city string 64   paymentReconDetail  
stateProvince string 8   paymentReconDetail  
zipPostalCode string 16   paymentReconDetail  
country string 4   paymentReconDetail  
phone string 256   paymentReconDetail  
travelCategory_recNo short   Required paymentReconDetail Air = 1, Hotel = 2, Car = 3, Cruise = 4, Tour = 5, Rail = 6, Transfer = 7, Insurance = 8, ServiceFee = 9, Excursion = 10, ClientVoucher = 11, GiftCertificate = 12, SupplierVoucher = 13, Misc = 99
status short   Required paymentReconDetail Unreconciled = 0, Reconciled = 1, MultiMatches = 2, Duplicate = 3
reservation_recNo long     paymentReconDetail  
errorMessage string 256   paymentReconDetail  
errorTimeStamp DateTimeOffset     paymentReconDetail  
reservation table   Singleton paymentReconDetail  
recNo long   InsertOnly, FKey reservation  
providerName_Lookup string 256 ReadOnly, Lookup reservation  
providerInfoName_Lookup string 256 ReadOnly, Lookup reservation  
supplierName_Lookup string 256 ReadOnly, Lookup reservation  
supplierInfoName_Lookup string 256 ReadOnly, Lookup reservation  
travelerName string 512   reservation  
primaryTravelerName_Lookup string 512 ReadOnly reservation  
confirmationNo string 64   reservation  
totalFare long     reservation  
commissionAmount long     reservation  
startDateTime DateTime     reservation  
supplierRemarks string     reservation  
Status code Description
200 Ok
204 No Content
401 Unauthorized
403 Forbidden