This data object is used to return the lease rental billing history information for each unit on a given LR invoice from the Fusion business system.

This is found within the Lease Rental Billing History program in the Fusion business system.

URL

/frw/LRBillingHistory

Field Details…

SQL Field Name Column Description
AddDate This field displays the date on which the given LR invoice was added to the system.
AddUser This field displays the user name of the user who added the given LR invoice.
Branch This field displays the branch in which the given LR invoice was created.
CompanyName This field displays the company name of the customer associated with the given LR invoice.
ContractNumber This field displays the contract number of the given invoiced LR contract.
ContractSalesperson This field displays the salesperson listed on the given LR contract.
CustomerKey This field displays the identifying number of the customer associated with the given LR invoice.
Department This field displays the department in which the given LR invoice was created.
Division This field displays the division in which the given LR invoice was created.
FixedChargeBillingGroup This field displays the billing group used for the fixed charges on the given LR invoice.
FixedChargeEndDate This field displays the end of the period for which billing on fixed charges was calculated for the given LR invoice.
FixedChargeStartDate This field displays the beginning of the period for which billing on fixed charges was calculated for the given LR invoice.
InvoiceDate This field displays the date on which the given LR invoice was invoiced.
InvoiceNumber This field displays the invoice number of the given LR invoice.
LastUpdateDate This field displays the date on which the given LR invoice was last updated.
LastUpdateUser This field displays the user name of the user who last updated the given LR invoice.
Make This field displays the make of the given unit on the LR invoice.
MeterAtBilling This field displays the current meter reading of the given unit at the time the given LR invoice was billed.
Model This field displays the model of the given unit on the LR invoice.
PostingPeriod This field displays the period in which the given LR invoice was posted.
PreviouslyBilledMeter This field displays the meter reading of the given unit the last time it was billed on an LR invoice or, if no previous billings exist, the starting meter reading of the unit.
UnitFixedChargeTotal This field displays the total amount of the fixed charges associated with the given unit on the LR invoice.
UnitMiscChargeTotal This field displays the total amount of the miscellaneous charges associated with the given unit on the LR invoice.
UnitNumber This field displays the unit number of the given unit on the invoiced LR contract.
UnitSalesperson This field displays the salesperson listed with the given unit on the given LR contract.
UnitTotal This field displays the total amount of the charges associated with the given unit on the LR invoice.
UnitVariableChargeTotal This field displays the total amount of the variable charges associated with the given unit on the LR invoice.
VariableChargeBillingGroup This field displays the billing group used for the variable charges on the given LR invoice.
VariableChargeEndDate This field displays the end of the period for which billing on variable charges was calculated for the given LR invoice.
VariableChargeStartDate This field displays the beginning of the period for which billing on variable charges was calculated for the given LR invoice.
VIN This field displays the vehicle identification number of the given unit on the LR invoice.
IsVoided This field displays whether the given LR invoice has been voided.
Year This field displays the year of the given unit on the LR invoice.