# ContractLines: ionBIZ Contract Lines - Catalog: `ionBIZ` - Label: Contract Lines - Retrieve: true ## Table Columns The columns of the table `ContractLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `ContractId` | `int32` | Contract ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `Date` | `datetimeoffset` | Date | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsExtraLine` | `boolean` | Is Extra Line | ☐ | | | `ItemId` | `int32` | Item ID | ☐ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `ModificationDeltaDate` | `datetimeoffset` | Modification Delta Date | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Name` | `string` | Name | ☐ | | | `OldUnitAmount` | `decimal` | Old Unit Amount | ☐ | | | `OldUnitPrice` | `decimal` | Old Unit Price | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `Percentage` | `decimal` | Percentage | ☐ | | | `PercentageLineIds` | `string` | Percentage Line IDs | ☐ | | | `Print` | `boolean` | Print | ☐ | | | `QuoteLineId` | `int32` | Quote Line ID | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `ToProcessForInvoicing` | `boolean` | To Process for Invoicing | ☐ | | | `TotalHours` | `int64` | Total Hours | ☐ | | | `UnitAmount` | `decimal` | Unit Amount | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | |