invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesInvoicesExploded: Exact Online Sales Invoices (Exploded)

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: SalesInvoice
  • Primary Keys: SilID
  • Label: Sales Invoices (Exploded)

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

API Source

  • Endpoint: /api/v1/{division}/salesinvoice/SalesInvoices?$expand=SalesInvoiceLines
  • Metadata: /api/v1/{division}/salesinvoice/$metadata

Performance Characteristics

Characteristic Value
Average access latency (ms) 5
Full scan rows per minute 7,200
Point query rows per minute 300
Write rows per minute 300

The result can be cached on the client.

Table Columns

The columns of the table SalesInvoicesExploded are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
AmountDC double Amount Division Currency filters on the platform, writable, ::ancestor.::ancestor.AmountDC
AmountFC double Amount Foreign Currency filters on the platform, writable, ::ancestor.::ancestor.AmountFC
Created datetime Created filters on the platform, writable, ::ancestor.::ancestor.Created
Creator guid Creator filters on the platform, writable, ::ancestor.::ancestor.Creator
CreatorFullName varchar2 Creator Full Name filters on the platform, writable, ::ancestor.::ancestor.CreatorFullName
Currency varchar2 Currency filters on the platform, writable, ::ancestor.::ancestor.Currency
Description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.Description
Division int32 Division filters on the platform, writable, ::ancestor.::ancestor.Division
Document guid Document filters on the platform, writable, ::ancestor.::ancestor.Document
DocumentNumber int32 Document Number filters on the platform, writable, ::ancestor.::ancestor.DocumentNumber
DocumentSubject varchar2 Document Subject filters on the platform, writable, ::ancestor.::ancestor.DocumentSubject
DueDate datetime Due Date filters on the platform, writable, ::ancestor.::ancestor.DueDate
InvoiceDate datetime Invoice Date filters on the platform, writable, ::ancestor.::ancestor.InvoiceDate
InvoiceID guid Invoice ID filters on the platform, writable, ::ancestor.::ancestor.InvoiceID
InvoiceNumber int32 Invoice Number filters on the platform, writable, ::ancestor.::ancestor.InvoiceNumber
InvoiceTo guid Invoice to filters on the platform, writable, ::ancestor.::ancestor.InvoiceTo
InvoiceToContactPerson guid Invoice to Contact Person filters on the platform, writable, ::ancestor.::ancestor.InvoiceToContactPerson
InvoiceToContactPersonFullName varchar2 Invoice To Contact Person Full Name filters on the platform, writable, ::ancestor.::ancestor.InvoiceToContactPersonFullName
InvoiceToName varchar2 Invoice to Name filters on the platform, writable, ::ancestor.::ancestor.InvoiceToName
Journal varchar2 Journal filters on the platform, writable, ::ancestor.::ancestor.Journal
JournalDescription varchar2 Journal Description filters on the platform, writable, ::ancestor.::ancestor.JournalDescription
Modified datetime Modified filters on the platform, writable, ::ancestor.::ancestor.Modified
Modifier guid Modifier filters on the platform, writable, ::ancestor.::ancestor.Modifier
ModifierFullName varchar2 Modified Full Name filters on the platform, writable, ::ancestor.::ancestor.ModifierFullName
OrderDate datetime Order Date filters on the platform, writable, ::ancestor.::ancestor.OrderDate
OrderNumber int32 Order Number filters on the platform, writable, ::ancestor.::ancestor.OrderNumber
OrderedBy guid Ordered by filters on the platform, writable, ::ancestor.::ancestor.OrderedBy
OrderedByContactPerson guid Ordered by Contact Person filters on the platform, writable, ::ancestor.::ancestor.OrderedByContactPerson
OrderedByContactPersonFullName varchar2 Ordered by Contact Person Full Name filters on the platform, writable, ::ancestor.::ancestor.OrderedByContactPersonFullName
OrderedByName varchar2 Ordered by Name filters on the platform, writable, ::ancestor.::ancestor.OrderedByName
PaymentCondition varchar2 Payment Condition filters on the platform, writable, ::ancestor.::ancestor.PaymentCondition
PaymentConditionDescription varchar2 Payment Condition Description filters on the platform, writable, ::ancestor.::ancestor.PaymentConditionDescription
PaymentReference varchar2 Payment Reference filters on the platform, writable, ::ancestor.::ancestor.PaymentReference
Remarks varchar2 Remarks filters on the platform, writable, ::ancestor.::ancestor.Remarks
Salesperson guid Sales Person filters on the platform, writable, ::ancestor.::ancestor.Salesperson
SalespersonFullName varchar2 Sales Person Full Name filters on the platform, writable, ::ancestor.::ancestor.SalespersonFullName
SilAmountDC double Sales Line Amount Division Currency writable, AmountDC
SilAmountFC double Sales Line Amount Foreign Currency writable, AmountFC
SilCostCenter varchar2 Sales Line Cost Centre writable, CostCenter
SilCostCenterDescription varchar2 itgen_eol_silcostcenterdescription writable, CostCenterDescription
SilCostUnit varchar2 Sales Line Cost Unit writable, CostUnit
SilCostUnitDescription varchar2 itgen_eol_silcostunitdescription writable, CostUnitDescription
SilDeliveryDate datetime Sales Line Delivery Date writable, DeliveryDate
SilDescription varchar2 Sales Line Description writable, Description
SilDiscount double Sales Line Discount writable, Discount
SilDivision int32 Sales Line Division writable, Division
SilEmployee guid Sales Line Employee writable, Employee
SilEmployeeFullName varchar2 Sales Line Employee Full Name writable, EmployeeFullName
SilEndTime datetime Sales Line End Time writable, EndTime
SilGLAccount guid Sales Line GL Account writable, GLAccount
SilGLAccountDescription varchar2 itgen_eol_silglaccountdescription writable, GLAccountDescription
SilID guid Sales Line ID writable, ID
SilInvoiceID guid Sales Line Invoice ID writable, InvoiceID
SilItem guid Sales Line Item writable, Item
SilItemCode varchar2 Sales Line Item Code writable, ItemCode
SilItemDescription varchar2 Sales Line Item Description writable, ItemDescription
SilLineNumber int32 Sales Line Number writable, LineNumber
SilNetPrice double Sales Line Net Price writable, NetPrice
SilNotes varchar2 Sales Line Notes writable, Notes
SilPricelist guid Sales Line Pricelist writable, Pricelist
SilPricelistDescription varchar2 itgen_eol_silpricelistdescription writable, PricelistDescription
SilProject guid Sales Line Project writable, Project
SilProjectDescription varchar2 itgen_eol_silprojectdescription writable, ProjectDescription
SilQuantity double Sales Line Quantity writable, Quantity
SilSalesOrder guid Sales Order writable, SalesOrder
SilSalesOrderLine guid Sales Line writable, SalesOrderLine
SilSalesOrderLineNumber int32 itgen_eol_silsalesorderlinenumber writable, SalesOrderLineNumber
SilSalesOrderNumber int32 Sales Line Order Number writable, SalesOrderNumber
SilStartTime datetime Sales Line Start Time writable, StartTime
SilSubscription guid Sales Line Subscription writable, Subscription
SilSubscriptionDescription varchar2 itgen_eol_silsubscriptiondescription writable, SubscriptionDescription
SilTaxSchedule guid Sales Line Tax Schedule writable, TaxSchedule
SilTaxScheduleCode varchar2 Sales Line Tax Schedule Code writable, TaxScheduleCode
SilTaxScheduleDescription varchar2 itgen_eol_siltaxscheduledescription writable, TaxScheduleDescription
SilUnitCode varchar2 Sales Line Unit Code writable, UnitCode
SilUnitDescription varchar2 Sales Line Unit Description writable, UnitDescription
SilUnitPrice double Sales Line Unit Price writable, UnitPrice
SilVATAmountDC double Sales Line VAT Amount Division Currency writable, VATAmountDC
SilVATAmountFC double Sales Line VAT Amount Foreign Currency writable, VATAmountFC
SilVATCode varchar2 Sales Line VAT Code writable, VATCode
SilVATCodeDescription varchar2 itgen_eol_silvatcodedescription writable, VATCodeDescription
SilVATPercentage double Sales Line VAT Percentage writable, VATPercentage
StarterSalesInvoiceStatus int16 Sales Invoice Status (Starter) writable, ::ancestor.::ancestor.StarterSalesInvoiceStatus
StarterSalesInvoiceStatusDescription varchar2 itgen_eol_startersalesinvoicestatusdescription writable, ::ancestor.::ancestor.StarterSalesInvoiceStatusDescription
Status int16 Status filters on the platform, writable, ::ancestor.::ancestor.Status
StatusDescription varchar2 Status Description filters on the platform, writable, ::ancestor.::ancestor.StatusDescription
TaxSchedule guid Tax Schedule filters on the platform, writable, ::ancestor.::ancestor.TaxSchedule
TaxScheduleCode varchar2 Tax Schedule Code filters on the platform, writable, ::ancestor.::ancestor.TaxScheduleCode
TaxScheduleDescription varchar2 Tax Schedule Description filters on the platform, writable, ::ancestor.::ancestor.TaxScheduleDescription
Type int32 Type filters on the platform, writable, ::ancestor.::ancestor.Type
TypeDescription varchar2 Type Description filters on the platform, writable, ::ancestor.::ancestor.TypeDescription
VATAmountDC double VAT Amount Division Currency filters on the platform, writable, ::ancestor.::ancestor.VATAmountDC
VATAmountFC double VAT Amount Foreign Currency filters on the platform, writable, ::ancestor.::ancestor.VATAmountFC
YourRef varchar2(60) Your Reference filters on the platform, writable, ::ancestor.::ancestor.YourRef

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: