|
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. |
| 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. |