Fields – ReservationItem
| Field Name | Data Type | Description, Example |
|---|---|---|
| DealerId | string | Internal Dealer Identifier (intentionally left blank) |
| reservationitemid (key) | bigint | ID of the reservation item record |
| reservationid (key) | bigint | ID of the reservation |
| rentalitemid (key) | bigint | ID of the rental item |
| state | string | Sate of the reservation item – Unknown, Future, Active, Waiting, Closed, Pending Active, Pending Closed, Transferred, ‘blank’ |
| securitydeposit | money | Amount of security deposit |
| rentaldeposit | money | Amount of rental deposit |
| startmileage | bigint | Milage at the start of the rental |
| endmileage | bigint | Milage at the end of the rental |
| rateamt | money | Rate of the rental |
| ratetype | string | Type of rate – By Period, By Period and Length, By Period and Area |
| perperiodamt | money | Rental amount per period |
| conditionbefore | string | Condition of item before rental |
| conditionafter | string | Condition of item after rental |
| rentaldeposittaken | money | Amount taken for the rental deposit |
| rentaldepositapplied | money | Amount applied to deposit for the rental |
| contractstartdate | datetime | Date when rental contract started |
| contractenddate | datetime | Date when rental contract ended |
| actualstartdate | datetime | Date when rental actually started |
| actualenddate | datetime | Date when rental actually ended |
| rentalperiods | double | Number of periods accrued during the rental |
| periodscharged | double | Number of periods charged for the rental |
| timeperiod | integer | ID of the time period type |
| timeperioddescription | string | Description of the time period type |
| totalamount | money | Total amount charged for the item rental |
| chargeablewidth | double | Charge amount for width of rental space |
| chargeablelength | double | Charge amount for length of rental space |
| totalamountoverride | string | Indicates if total amount was overridden – True/False |
| noenddate | string | Indicates if the item rental has an end date |
| rentalratedescription | test | Description of the rental rate |
| stocknumber | test | Stock number of the rental item |
| majorunitid | integer | Major unit ID of the rental item |