# SalesInvoicesExploded: Exact Online Sales Invoices (Exploded) - Catalog: `ExactOnlineREST` - Schema: `SalesInvoice` - Primary Keys: `SilID` - Label: Sales Invoices (Exploded) The data in this table is partitioned per value of the `Division` column. This is a read-only view. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## View Columns The columns of the view `SalesInvoicesExploded` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AmountDC` | `double` | Amount Division Currency | ☐ | | | `AmountFC` | `double` | Amount Foreign Currency | ☐ | | | `Created` | `datetime` | Created | ☐ | | | `Creator` | `guid` | Creator | ☐ | | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | | | `Currency` | `varchar2` | Currency | ☐ | | | `Description` | `varchar2` | Description | ☐ | | | `Division` | `int32` | Division | ☑ | | | `Document` | `guid` | Document | ☐ | | | `DocumentNumber` | `int32` | Document Number | ☐ | | | `DocumentSubject` | `varchar2` | Document Subject | ☐ | | | `DueDate` | `datetime` | Due Date | ☐ | | | `InvoiceDate` | `datetime` | Invoice Date | ☐ | | | `InvoiceID` | `guid` | Invoice ID | ☑ | | | `InvoiceNumber` | `int32` | Invoice Number | ☐ | | | `InvoiceTo` | `guid` | Invoice to | ☐ | | | `InvoiceToContactPerson` | `guid` | Invoice to Contact Person | ☐ | | | `InvoiceToContactPersonFullName` | `varchar2` | Invoice To Contact Person Full Name | ☐ | | | `InvoiceToName` | `varchar2` | Invoice to Name | ☐ | | | `Journal` | `varchar2` | Journal | ☐ | | | `JournalDescription` | `varchar2` | Journal Description | ☐ | | | `Modified` | `datetime` | Modified | ☐ | | | `Modifier` | `guid` | Modifier | ☐ | | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | | | `OrderDate` | `datetime` | Order Date | ☐ | | | `OrderedBy` | `guid` | Ordered by | ☐ | | | `OrderedByContactPerson` | `guid` | Ordered by Contact Person | ☐ | | | `OrderedByContactPersonFullName` | `varchar2` | Ordered by Contact Person Full Name | ☐ | | | `OrderedByName` | `varchar2` | Ordered by Name | ☐ | | | `OrderNumber` | `int32` | Order Number | ☐ | | | `PaymentCondition` | `varchar2` | Payment Condition | ☐ | | | `PaymentConditionDescription` | `varchar2` | Payment Condition Description | ☐ | | | `PaymentReference` | `varchar2` | Payment Reference | ☐ | | | `Remarks` | `varchar2` | Remarks | ☐ | | | `Salesperson` | `guid` | Sales Person | ☐ | | | `SalespersonFullName` | `varchar2` | Sales Person Full Name | ☐ | | | `SilAmountDC` | `double` | Sales Line Amount Division Currency | ☐ | | | `SilAmountFC` | `double` | Sales Line Amount Foreign Currency | ☐ | | | `SilCostCenter` | `varchar2` | Sales Line Cost Centre | ☐ | | | `SilCostCenterDescription` | `varchar2` | | ☐ | | | `SilCostUnit` | `varchar2` | Sales Line Cost Unit | ☐ | | | `SilCostUnitDescription` | `varchar2` | | ☐ | | | `SilDeliveryDate` | `datetime` | Sales Line Delivery Date | ☐ | | | `SilDescription` | `varchar2` | Sales Line Description | ☐ | | | `SilDiscount` | `double` | Sales Line Discount | ☐ | | | `SilDivision` | `int32` | Sales Line Division | ☐ | | | `SilEmployee` | `guid` | Sales Line Employee | ☐ | | | `SilEmployeeFullName` | `varchar2` | Sales Line Employee Full Name | ☐ | | | `SilEndTime` | `datetime` | Sales Line End Time | ☐ | | | `SilGLAccount` | `guid` | Sales Line GL Account | ☐ | | | `SilGLAccountDescription` | `varchar2` | | ☐ | | | `SilID` | `guid` | Sales Line ID | ☑ | | | `SilInvoiceID` | `guid` | Sales Line Invoice ID | ☑ | | | `SilItem` | `guid` | Sales Line Item | ☐ | | | `SilItemCode` | `varchar2` | Sales Line Item Code | ☐ | | | `SilItemDescription` | `varchar2` | Sales Line Item Description | ☐ | | | `SilLineNumber` | `int32` | Sales Line Number | ☐ | | | `SilNetPrice` | `double` | Sales Line Net Price | ☐ | | | `SilNotes` | `varchar2` | Sales Line Notes | ☐ | | | `SilPricelist` | `guid` | Sales Line Pricelist | ☐ | | | `SilPricelistDescription` | `varchar2` | | ☐ | | | `SilProject` | `guid` | Sales Line Project | ☐ | | | `SilProjectDescription` | `varchar2` | | ☐ | | | `SilQuantity` | `double` | Sales Line Quantity | ☐ | | | `SilSalesOrder` | `guid` | Sales Order | ☐ | | | `SilSalesOrderLine` | `guid` | Sales Line | ☐ | | | `SilSalesOrderLineNumber` | `int32` | | ☐ | | | `SilSalesOrderNumber` | `int32` | Sales Line Order Number | ☐ | | | `SilStartTime` | `datetime` | Sales Line Start Time | ☐ | | | `SilSubscription` | `guid` | Sales Line Subscription | ☐ | | | `SilSubscriptionDescription` | `varchar2` | | ☐ | | | `SilTaxSchedule` | `guid` | Sales Line Tax Schedule | ☐ | | | `SilTaxScheduleCode` | `varchar2` | Sales Line Tax Schedule Code | ☐ | | | `SilTaxScheduleDescription` | `varchar2` | | ☐ | | | `SilUnitCode` | `varchar2` | Sales Line Unit Code | ☐ | | | `SilUnitDescription` | `varchar2` | Sales Line Unit Description | ☐ | | | `SilUnitPrice` | `double` | Sales Line Unit Price | ☐ | | | `SilVATAmountDC` | `double` | Sales Line VAT Amount Division Currency | ☐ | | | `SilVATAmountFC` | `double` | Sales Line VAT Amount Foreign Currency | ☐ | | | `SilVATCode` | `varchar2` | Sales Line VAT Code | ☐ | | | `SilVATCodeDescription` | `varchar2` | | ☐ | | | `SilVATPercentage` | `double` | Sales Line VAT Percentage | ☐ | | | `StarterSalesInvoiceStatus` | `int16` | Sales Invoice Status (Starter) | ☐ | | | `StarterSalesInvoiceStatusDescription` | `varchar2` | | ☐ | | | `Status` | `int16` | Status | ☐ | | | `StatusDescription` | `varchar2` | Status Description | ☐ | | | `TaxSchedule` | `guid` | Tax Schedule | ☐ | | | `TaxScheduleCode` | `varchar2` | Tax Schedule Code | ☐ | | | `TaxScheduleDescription` | `varchar2` | Tax Schedule Description | ☐ | | | `Type` | `int32` | Type | ☐ | | | `TypeDescription` | `varchar2` | Type Description | ☐ | | | `VATAmountDC` | `double` | VAT Amount Division Currency | ☐ | | | `VATAmountFC` | `double` | VAT Amount Foreign Currency | ☐ | | | `YourRef` | `varchar2` | Your Reference | ☐ | |