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 |
|---|---|---|---|---|---|
Amount |
double |
Amount Division Currency | filters on the platform, writable, ::ancestor. |
||
Amount |
double |
Amount Foreign Currency | filters on the platform, writable, ::ancestor. |
||
Created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
||
Creator |
guid |
Creator | filters on the platform, writable, ::ancestor. |
||
Creator |
varchar2 |
Creator Full Name | filters on the platform, writable, ::ancestor. |
||
Currency |
varchar2 |
Currency | filters on the platform, writable, ::ancestor. |
||
Description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
||
Division |
int32 |
Division | filters on the platform, writable, ::ancestor. |
||
Document |
guid |
Document | filters on the platform, writable, ::ancestor. |
||
Document |
int32 |
Document Number | filters on the platform, writable, ::ancestor. |
||
Document |
varchar2 |
Document Subject | filters on the platform, writable, ::ancestor. |
||
Due |
datetime |
Due Date | filters on the platform, writable, ::ancestor. |
||
Invoice |
datetime |
Invoice Date | filters on the platform, writable, ::ancestor. |
||
Invoice |
guid |
Invoice ID | filters on the platform, writable, ::ancestor. |
||
Invoice |
int32 |
Invoice Number | filters on the platform, writable, ::ancestor. |
||
Invoice |
guid |
Invoice to | filters on the platform, writable, ::ancestor. |
||
Invoice |
guid |
Invoice to Contact Person | filters on the platform, writable, ::ancestor. |
||
Invoice |
varchar2 |
Invoice To Contact Person Full Name | filters on the platform, writable, ::ancestor. |
||
Invoice |
varchar2 |
Invoice to Name | filters on the platform, writable, ::ancestor. |
||
Journal |
varchar2 |
Journal | filters on the platform, writable, ::ancestor. |
||
Journal |
varchar2 |
Journal Description | filters on the platform, writable, ::ancestor. |
||
Modified |
datetime |
Modified | filters on the platform, writable, ::ancestor. |
||
Modifier |
guid |
Modifier | filters on the platform, writable, ::ancestor. |
||
Modifier |
varchar2 |
Modified Full Name | filters on the platform, writable, ::ancestor. |
||
Order |
datetime |
Order Date | filters on the platform, writable, ::ancestor. |
||
Order |
int32 |
Order Number | filters on the platform, writable, ::ancestor. |
||
Ordered |
guid |
Ordered by | filters on the platform, writable, ::ancestor. |
||
Ordered |
guid |
Ordered by Contact Person | filters on the platform, writable, ::ancestor. |
||
Ordered |
varchar2 |
Ordered by Contact Person Full Name | filters on the platform, writable, ::ancestor. |
||
Ordered |
varchar2 |
Ordered by Name | filters on the platform, writable, ::ancestor. |
||
Payment |
varchar2 |
Payment Condition | filters on the platform, writable, ::ancestor. |
||
Payment |
varchar2 |
Payment Condition Description | filters on the platform, writable, ::ancestor. |
||
Payment |
varchar2 |
Payment Reference | filters on the platform, writable, ::ancestor. |
||
Remarks |
varchar2 |
Remarks | filters on the platform, writable, ::ancestor. |
||
Salesperson |
guid |
Sales Person | filters on the platform, writable, ::ancestor. |
||
Salesperson |
varchar2 |
Sales Person Full Name | filters on the platform, writable, ::ancestor. |
||
Sil |
double |
Sales Line Amount Division Currency | writable, Amount |
||
Sil |
double |
Sales Line Amount Foreign Currency | writable, Amount |
||
Sil |
varchar2 |
Sales Line Cost Centre | writable, Cost |
||
Sil |
varchar2 |
itgen_eol_silcostcenterdescription | writable, Cost |
||
Sil |
varchar2 |
Sales Line Cost Unit | writable, Cost |
||
Sil |
varchar2 |
itgen_eol_silcostunitdescription | writable, Cost |
||
Sil |
datetime |
Sales Line Delivery Date | writable, Delivery |
||
Sil |
varchar2 |
Sales Line Description | writable, Description |
||
Sil |
double |
Sales Line Discount | writable, Discount |
||
Sil |
int32 |
Sales Line Division | writable, Division |
||
Sil |
guid |
Sales Line Employee | writable, Employee |
||
Sil |
varchar2 |
Sales Line Employee Full Name | writable, Employee |
||
Sil |
datetime |
Sales Line End Time | writable, End |
||
Sil |
guid |
Sales Line GL Account | writable, GL |
||
Sil |
varchar2 |
itgen_eol_silglaccountdescription | writable, GL |
||
SilID |
guid |
Sales Line ID | writable, ID |
||
Sil |
guid |
Sales Line Invoice ID | writable, Invoice |
||
Sil |
guid |
Sales Line Item | writable, Item |
||
Sil |
varchar2 |
Sales Line Item Code | writable, Item |
||
Sil |
varchar2 |
Sales Line Item Description | writable, Item |
||
Sil |
int32 |
Sales Line Number | writable, Line |
||
Sil |
double |
Sales Line Net Price | writable, Net |
||
Sil |
varchar2 |
Sales Line Notes | writable, Notes |
||
Sil |
guid |
Sales Line Pricelist | writable, Pricelist |
||
Sil |
varchar2 |
itgen_eol_silpricelistdescription | writable, Pricelist |
||
Sil |
guid |
Sales Line Project | writable, Project |
||
Sil |
varchar2 |
itgen_eol_silprojectdescription | writable, Project |
||
Sil |
double |
Sales Line Quantity | writable, Quantity |
||
Sil |
guid |
Sales Order | writable, Sales |
||
Sil |
guid |
Sales Line | writable, Sales |
||
Sil |
int32 |
itgen_eol_silsalesorderlinenumber | writable, Sales |
||
Sil |
int32 |
Sales Line Order Number | writable, Sales |
||
Sil |
datetime |
Sales Line Start Time | writable, Start |
||
Sil |
guid |
Sales Line Subscription | writable, Subscription |
||
Sil |
varchar2 |
itgen_eol_silsubscriptiondescription | writable, Subscription |
||
Sil |
guid |
Sales Line Tax Schedule | writable, Tax |
||
Sil |
varchar2 |
Sales Line Tax Schedule Code | writable, Tax |
||
Sil |
varchar2 |
itgen_eol_siltaxscheduledescription | writable, Tax |
||
Sil |
varchar2 |
Sales Line Unit Code | writable, Unit |
||
Sil |
varchar2 |
Sales Line Unit Description | writable, Unit |
||
Sil |
double |
Sales Line Unit Price | writable, Unit |
||
Sil |
double |
Sales Line VAT Amount Division Currency | writable, VAT |
||
Sil |
double |
Sales Line VAT Amount Foreign Currency | writable, VAT |
||
Sil |
varchar2 |
Sales Line VAT Code | writable, VAT |
||
Sil |
varchar2 |
itgen_eol_silvatcodedescription | writable, VAT |
||
Sil |
double |
Sales Line VAT Percentage | writable, VAT |
||
Starter |
int16 |
Sales Invoice Status (Starter) | writable, ::ancestor. |
||
Starter |
varchar2 |
itgen_eol_startersalesinvoicestatusdescription | writable, ::ancestor. |
||
Status |
int16 |
Status | filters on the platform, writable, ::ancestor. |
||
Status |
varchar2 |
Status Description | filters on the platform, writable, ::ancestor. |
||
Tax |
guid |
Tax Schedule | filters on the platform, writable, ::ancestor. |
||
Tax |
varchar2 |
Tax Schedule Code | filters on the platform, writable, ::ancestor. |
||
Tax |
varchar2 |
Tax Schedule Description | filters on the platform, writable, ::ancestor. |
||
Type |
int32 |
Type | filters on the platform, writable, ::ancestor. |
||
Type |
varchar2 |
Type Description | filters on the platform, writable, ::ancestor. |
||
VAT |
double |
VAT Amount Division Currency | filters on the platform, writable, ::ancestor. |
||
VAT |
double |
VAT Amount Foreign Currency | filters on the platform, writable, ::ancestor. |
||
Your |
varchar2 |
Your Reference | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: