# Rptinvoicingopeninvoicesresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptinvoicingopeninvoicesresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Balance` | `decimal` | Balance | ☑ | | | `Credit` | `decimal` | Credit | ☑ | | | `CurrencySymbol` | `string` | Currency Symbol | ☐ | | | `CustomerCustomerId` | `string` | Customer Customer ID | ☐ | | | `CustomerId` | `int32` | Customer ID | ☑ | | | `CustomerName` | `string` | Customer Name | ☐ | | | `Date` | `datetimeoffset` | Date | ☑ | | | `Debet` | `decimal` | Debit | ☑ | | | `Due0D` | `decimal` | Due 0 Days | ☑ | | | `Due14D` | `decimal` | Due 14 Days | ☑ | | | `Due30D` | `decimal` | Due 30 Days | ☑ | | | `Due3M` | `decimal` | Due 3 Months | ☑ | | | `Due3MPlus` | `decimal` | Due Over 3 Months | ☑ | | | `DueDate` | `datetimeoffset` | Due Date | ☐ | | | `HoldingName` | `string` | Holding Name | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoiceNo` | `string` | Invoice Number | ☐ | | | `InvoiceToCustomerId` | `string` | Invoice to Customer ID | ☐ | | | `InvoiceToCustomerName` | `string` | Invoice to Customer Name | ☐ | | | `PaymentComment` | `string` | Payment Comment | ☐ | | | `StructuredReference` | `string` | Structured Reference | ☐ | |