# Rptinvoicinginvoicelinesresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptinvoicinginvoicelinesresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountManagerId` | `int32` | Account Manager ID | ☐ | | | `AccountManagerName` | `string` | Account Manager Name | ☐ | | | `Activity` | `string` | Activity | ☐ | | | `ActivityType` | `string` | Activity Type | ☐ | | | `Advance` | `boolean` | Advance | ☑ | | | `CompanyAddressCode` | `string` | Company Address Code | ☐ | | | `CompanyAddressName` | `string` | Company Address Name | ☐ | | | `CurrencySymbol` | `string` | Currency Symbol | ☐ | | | `CustomerExternalCode` | `string` | Customer External Code | ☐ | | | `CustomerId` | `string` | Customer ID | ☐ | | | `CustomerName` | `string` | Customer Name | ☐ | | | `DepartmentExternalCode` | `string` | Department External Code | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `DepartmentName` | `string` | Department Name | ☐ | | | `Description` | `string` | Description | ☐ | | | `Discount` | `decimal` | Discount | ☑ | | | `DiscountType` | `string` | Discount Type | ☐ | | | `DocDate` | `datetimeoffset` | Document Date | ☐ | | | `DocNo` | `string` | Document Number | ☐ | | | `DueDate` | `datetimeoffset` | Due Date | ☐ | | | `ExternalNote` | `string` | External Note | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoiceCurrencyName` | `string` | Invoice Currency Name | ☐ | | | `InvoiceStatusId` | `int32` | Invoice Status ID | ☐ | | | `InvoiceStatusName` | `string` | Invoice Status Name | ☐ | | | `InvoiceToCustomerId` | `string` | Invoice to Customer ID | ☐ | | | `InvoiceToCustomerName` | `string` | Invoice to Customer Name | ☐ | | | `LastPaymentOn` | `datetimeoffset` | Last Payment On | ☐ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `LedgerAccountName` | `string` | Ledger Account Name | ☐ | | | `LedgerAccountNo` | `string` | Ledger Account Number | ☐ | | | `LineDate` | `datetimeoffset` | Line Date | ☐ | | | `LineType` | `int32` | Line Type | ☑ | | | `LocalTotalExclVAT` | `decimal` | Local Total Excl. VAT | ☑ | | | `LocalTotalInclVAT` | `decimal` | Local Total Incl. VAT | ☑ | | | `LocalUnitPrice` | `decimal` | Local Unit Price | ☑ | | | `Month` | `string` | Month | ☐ | | | `OvertimeDetail` | `decimal` | Overtime Detail | ☐ | | | `PaymentCondition` | `string` | Payment Condition | ☐ | | | `PercentageBillableDescription` | `string` | Percentage Billable Description | ☐ | | | `ProjectCurrencyName` | `string` | Project Currency Name | ☐ | | | `ProjectGroup` | `string` | Project Group | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectInvoiceGroup` | `string` | Project Invoice Group | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ProjectProjectId` | `string` | Project Project ID | ☐ | | | `ProjectType` | `string` | Project Type | ☐ | | | `Quantity` | `decimal` | Quantity | ☑ | | | `RelationGroup` | `string` | Relation Group | ☐ | | | `RelationGroupId` | `int32` | Relation Group ID | ☐ | | | `RelationType` | `string` | Relation Type | ☐ | | | `RelationTypeId` | `int32` | Relation Type ID | ☐ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `RevenueMonths` | `int32` | Revenue Months | ☑ | | | `RevenueStart` | `int32` | Revenue Start | ☑ | | | `StructuredReference` | `string` | Structured Reference | ☐ | | | `TaskDepartment` | `string` | Task Department | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskName` | `string` | Task Name | ☐ | | | `TotalExclVAT` | `decimal` | Total Excl. VAT | ☑ | | | `TotalInclVAT` | `decimal` | Total Incl. VAT | ☑ | | | `UnitPrice` | `decimal` | Unit Price | ☑ | | | `UnitType` | `string` | Unit Type | ☐ | | | `Vat` | `decimal` | VAT | ☐ | | | `VatCode` | `string` | VAT Code | ☐ | | | `VatPercentage` | `decimal` | VAT Percentage | ☑ | | | `Year` | `int32` | Year | ☐ | |