This data object is used to return the detail for all charges associated with a given unit on an LR invoice from the Fusion business system.

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

URL

/frw/LRBillingHistoryDetail

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 to the system.
BillingRateFrequency This field displays the frequency at which the given fixed charge on the LR invoice is billed.
Branch This field displays the branch in which the given LR invoice was created.
Charge This field displays the name of the given charge on the LR invoice.
ChargeDescription This field displays the description of the given charge on the LR invoice.
ChargeType This field displays the type of the given charge on the LR invoice, Fixed, Variable, Miscellaneous, or Fuel.
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 LR contract on the given LR invoice.
ContractSalesperson This field displays the salesperson listed on the given LR contract.
Cost This field displays the cost of the given charge on the LR invoice.
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.
ExtendedCost This field displays the extended cost (cost * quantity) of the given charge on the LR invoice.
ExtendedRate This field displays the extended rate (rate * quantity) of the given charge on the 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 in the system.
LastUpdateUser This field displays the user name of the user who last updated the given LR invoice in the system.
MeterType This field displays the meter type of the given variable charge on the LR invoice.
Quantity This field displays the quantity of the given charge on the LR invoice.
Rate This field displays the rate charged to the customer for the given charge on the LR invoice.
Status This field displays the status of the given LR invoice as invoiced or voided.
StockNumber This field displays the stock number of the unit on the given LR invoice.
UnitNumber This field displays the unit number of the unit on the given LR invoice.
UnitSalesperson This field displays the salesperson listed with the given unit on the given LR contract.
UnitStatus This field displays the status of the unit at the time of the given LR invoice.
IsVoided This field displays whether the given LR invoice has been voided.