Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: SalesInvoice > Tables

SalesInvoicesExploded: Exact Online Sales Invoices (Exploded)

Contents Previous Home Next More

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 SQL 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.

Select Exact Online API URL: /api/v1/{division}/salesinvoice/SalesInvoices?$expand=SalesInvoiceLines

Insert Exact Online API URL: /api/v1/{division}/salesinvoice/SalesInvoices?$expand=SalesInvoiceLines

Update Exact Online API URL: /api/v1/{division}/salesinvoice/SalesInvoices?$expand=SalesInvoiceLines

Delete Exact Online API URL: /api/v1/{division}/salesinvoice/SalesInvoices?$expand=SalesInvoiceLines

Exact Online API Metadata URL: /api/v1/{division}/salesinvoice/$metadata

Field Selection Method: NotRequired

Base Path: SalesInvoiceLines.results[*]

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

string

Creator Full Name

 

Currency

string

Currency

 

Description

string

Description

 

Division

int32

Division

 

Document

guid

Document

 

DocumentNumber

int32

Document Number

 

DocumentSubject

string

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

string

Invoice To Contact Person Full Name

 

InvoiceToName

string

Invoice to Name

 

Journal

string

Journal

 

JournalDescription

string

Journal Description

 

Modified

datetime

Modified

 

Modifier

guid

Modifier

 

ModifierFullName

string

Modified Full Name

 

OrderDate

datetime

Order Date

 

OrderedBy

guid

Ordered by

 

OrderedByContactPerson

guid

Ordered by Contact Person

 

OrderedByContactPersonFullName

string

Ordered by Contact Person Full Name

 

OrderedByName

string

Ordered by Name

 

OrderNumber

int32

Order Number

 

PaymentCondition

string

Payment Condition

 

PaymentConditionDescription

string

Payment Condition Description

 

PaymentReference

string

Payment Reference

 

Remarks

string

Remarks

 

Salesperson

guid

Sales Person

 

SalespersonFullName

string

Sales Person Full Name

 

SilAmountDC

double

 

 

SilAmountFC

double

 

 

SilCostCenter

string

 

 

SilCostCenterDescription

string

 

 

SilCostUnit

string

 

 

SilCostUnitDescription

string

 

 

SilDeliveryDate

datetime

 

 

SilDescription

string

 

 

SilDiscount

double

 

 

SilDivision

int32

 

 

SilEmployee

guid

 

 

SilEmployeeFullName

string

 

 

SilEndTime

datetime

 

 

SilGLAccount

guid

 

 

SilGLAccountDescription

string

 

 

SilID

guid

 

 

SilInvoiceID

guid

 

 

SilItem

guid

 

 

SilItemCode

string

 

 

SilItemDescription

string

 

 

SilLineNumber

int32

 

 

SilNetPrice

double

 

 

SilNotes

string

 

 

SilPricelist

guid

 

 

SilPricelistDescription

string

 

 

SilProject

guid

 

 

SilProjectDescription

string

 

 

SilQuantity

double

 

 

SilSalesOrder

guid

 

 

SilSalesOrderLine

guid

 

 

SilSalesOrderLineNumber

int32

 

 

SilSalesOrderNumber

int32

 

 

SilStartTime

datetime

 

 

SilSubscription

guid

 

 

SilSubscriptionDescription

string

 

 

SilTaxSchedule

guid

 

 

SilTaxScheduleCode

string

 

 

SilTaxScheduleDescription

string

 

 

SilUnitCode

string

 

 

SilUnitDescription

string

 

 

SilUnitPrice

double

 

 

SilVATAmountDC

double

 

 

SilVATAmountFC

double

 

 

SilVATCode

string

 

 

SilVATCodeDescription

string

 

 

SilVATPercentage

double

 

 

StarterSalesInvoiceStatus

int16

Sales Invoice Status (Starter)

 

StarterSalesInvoiceStatusDescription

string

 

 

Status

int16

Status

 

StatusDescription

string

Status Description

 

TaxSchedule

guid

Tax Schedule

 

TaxScheduleCode

string

Tax Schedule Code

 

TaxScheduleDescription

string

Tax Schedule Description

 

Type

int32

Type

 

TypeDescription

string

Type Description

 

VATAmountDC

double

VAT Amount Division Currency

 

VATAmountFC

double

VAT Amount Foreign Currency

 

YourRef

string

Your Reference

 

 

07-11-2021 09:07 Version 20.2.94-PROD+3513