This data object is used to return all information from the Lease Rental Contract program from within the Fusion business system.

This is found within the Lease Rental Contract program within the Fusion business system.

URL

/frw/LRContract

Field Details…

SQL Field Name Column Description
AddDate This field displays the date on which the contract was added.
AddUser This field displays the user name that added the record.
Address1 This field displays address line one of the address on the contract.
Address2 This field displays address line two of the address on the contract.
BranchCode This field displays branch associated with the LR Contract.
City This field displays the city entered on the LR Contract.
CompanyName This field displays the company name of the customer associated with the LR contract.
ContractNumber This field displays the number attached to a contract.
LeaseContractStatus This field displays the status of a given contract.
ContractType This field displays the type of a given contract (Lease, Rental, Maintenance).
Country This field displays the customer’s country.
County This field displays the customer’s county.
CustomerKey This field displays the identifying number attached to a customer.
CustomerPO This field displays the customer purchase order associated with an invoiced sale.
CVOR This field displays the Commercial Vehicle Operator’s Registration.
Department This field displays the department associated with a LR Contract.
DOT This field displays the Department of Transportation ID number.
EMail This field displays the customer’s email address from the address entry tab.
Fax This field displays the customer’s fax number from the address entry tab.
FixedChargeBillingGroup This field displays the billing group used for fixed charges.
LastUpdateDate This field displays the last date the record was updated.
UpdateUser This field displays the user name of the individual who made the update.
UserDefinedPaymentMethod This field displays the payment method for a customer, as defined by the user.
Phone This field displays the customer’s primary phone number from the address entry tab.
Phone2 This field displays the customer’s secondary phone number from the address entry tab on a contract.
Phone3 This field displays the customer’s tertiary phone number from the address entry tab on a contract.
PostalCode This field displays the customer’s postal code.
Region This field displays the customer’s region or state.
SalesTaxSetting This field displays whether the tax body is defaulted to local or customer’s tax body.
UserName This field displays the salesperson associated with a lease and rental contract.
SubsAllowed This field displays whether the units on the given lease contract are able to substituted.
TaxBody This field displays the tax body associated with a customer address.
TaxStatus This field displays the customer’s tax status on a contract (taxable, exempt, etc.).
VariableChargeBillingGroup This field displays the billing used for variable charges.
WebAddress This field displays the customer’s web address  from the address entry tab on a contract.