# Rptcontractlines_Result - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptcontractlines_Result` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountManagerName` | `string` | Account Manager Name | ☐ | | | `ContactName` | `string` | Contact Name | ☐ | | | `ContractCreationDate` | `datetimeoffset` | Contract Creation Date | ☐ | | | `ContractCreatorName` | `string` | Contract Creator Name | ☐ | | | `ContractDate` | `datetimeoffset` | Contract Date | ☐ | | | `ContractIdName` | `string` | Contract ID Name | ☑ | | | `ContractLineType` | `int32` | Contract Line Type | ☑ | | | `ContractName` | `string` | Contract Name | ☐ | | | `ContractTypeName` | `string` | Contract Type Name | ☐ | | | `CustomerName` | `string` | Customer Name | ☐ | | | `CustomerRefName` | `string` | Customer Reference Name | ☐ | | | `DepartmentName` | `string` | Department Name | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `ExpirationDate` | `datetimeoffset` | Expiration Date | ☐ | | | `ItemIdName` | `string` | Item ID Name | ☐ | | | `ItemName` | `string` | Item Name | ☐ | | | `LastModificationDate` | `datetimeoffset` | Last Modification Date | ☑ | | | `LedgerAccountName` | `string` | Ledger Account Name | ☐ | | | `LineCreationDate` | `datetimeoffset` | Line Creation Date | ☑ | | | `LineCreatorName` | `string` | Line Creator Name | ☐ | | | `LineDate` | `datetimeoffset` | Line Date | ☑ | | | `LineName` | `string` | Line Name | ☐ | | | `LocationName` | `string` | Location Name | ☐ | | | `OwnerName` | `string` | Owner Name | ☐ | | | `RelationGroup` | `string` | Relation Group | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `StatusName` | `string` | Status Name | ☐ | | | `TotalHours` | `decimal` | Total Hours | ☑ | | | `TotalPrice` | `decimal` | Total Price | ☑ | | | `UnitPrice` | `decimal` | Unit Price | ☑ | | | `UnitQuantity` | `decimal` | Unit Quantity | ☑ | |