Fields – Reservation

Field Name	Data Type	Description, Example
DealerId	string	Internal Dealer Identifier (intentionally left blank)
Reservationnumber (key)	integer	Number (customer facing) of the reservation
reservationid (key)	bigint	ID of the reservation record
creationdate	datetime	Date the reservation was created
finalizeddate	datetime	Date the reservation was finalized
reservationstate	string	State of the reservation – Future, Active, Waiting List, Finalized, Canceled, Partial, Unknown
contractsigned	string	Indicates if contract signed or not – True/False
saletype	string	Indicates type of sale
insname	string	Name of insurance provider
insuranceaddress1	string	Insurance provider address line 1
insuranceaddress2	string	Insurance provider address line 2
insurancecity	string	Insurance provider address city
insurancestate	string	Insurance provider address state
insurancezip	string	Insurance provider address zip
insurancephone	string	Insurance provider address phone
insurancefax	string	Insurance provider address fax
insuranceattention	string	Insurance provider address attention
insurancepolicynumber	string	Insurance policy number
insuranceexpirationdate	datetime	Date when policy expires
latefeeoverridden	string	Indicates if date fee is overridden
latefeeoverrideamt	money	Indicates how much of the late fee is overridden
allowcharges	string	Indicates if charges are allowed – True/False
paymenttype	string	Full amount required for payment or pay per period – Full Sum, Per Period
sendstatement	string	Indicates if statement is to be sent each month – True/False
rentalamountcharged	money	Amount already charged to customer
rentalamountfuture	money	Future amount to be charged to customer
rentalamounttotal	money	Amount already charged plus future amount to be charged
repeatingcharged	money	Reoccurring charges customer has already paid
repeatingfuture	money	Reoccurring charges pending customer pay
repeatingtotal	money	Sum of already paid and future payments
onetimecharged	money	One time charge customer has already paid
onetimefuture	money	One time charge has pending
taxescharged	money	Tax amount customer has already paid
taxesfuture	money	Tax amount for pending customer pay
taxestotal	money	Sum of taxes charged and taxes future
chargedtodatetotal	money	Total amount of all charged amounts
estimatedfuturechargestotal	money	Total amount of all future payments
totalcharges	money	Total sum of all charged fields
securitydepositowed	money	Amount remaining for security deposit
securitydeposittaken	money	Amount taken for security deposit
securitydepositapplied	money	Amount applied to security deposit
rentaldepositapplied	money	Amount applied for rental deposit
totaldeposit	money	Sum of rental and security deposit
totaldeposittaken	money	Sum of taken rental and security deposit
totaldepositapplied	money	Sum of applied rental and security deposit
securitydeposit	money	Amount required for security deposit
rentaldeposit	money	Amount required for rental deposit
rentaldeposittaken	money	Amount taken for rental deposit
rentaldepositowed	money	Amount still owed for rental deposit

Example URL Example JSON Result