AccountsIncremental: Exact Online Accounts (Incremental)
popular read only per partition
- Catalog:
ExactOnlineREST - Schema:
Incremental - Primary Keys:
ID - Label: Accounts (Incremental)
The data in this table is partitioned per value of the Division column.
Can only retrieve data.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 426 |
| Full scan rows per minute | 12,900 |
| Point query rows per minute | 138 |
The result can be cached on the client.
Table Columns
The columns of the table AccountsIncremental 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 |
|---|---|---|---|---|---|
Account |
guid |
Account Manager | |||
Account |
int32 |
Account Manager HID | |||
Accountant |
guid |
Accountant | |||
Activity |
guid |
Activity Sector | |||
Activity |
guid |
Activity Subsector | |||
Address |
varchar2 |
Address Line 1 | |||
Address |
varchar2 |
Address Line 2 | |||
Address |
varchar2 |
Address Line 3 | |||
Address |
int16 |
Address Source | |||
Automatic |
int16 |
Automatic Process Proposed Entry | |||
BRIN |
guid |
BRIN | |||
BSN |
varchar2 |
Social Security Number | |||
Blocked |
char |
Blocked | |||
Business |
guid |
Business Type | |||
Can |
char |
Can Drop Ship | |||
Chamber |
varchar2 |
Chamber of Commerce | |||
City |
varchar2 |
City | |||
Classification |
varchar2 |
Classification | |||
Classification1 |
guid |
Classification 1 | |||
Classification2 |
guid |
Classification 2 | |||
Classification3 |
guid |
Classification 3 | |||
Classification4 |
guid |
Classification 4 | |||
Classification5 |
guid |
Classification 5 | |||
Classification6 |
guid |
Classification 6 | |||
Classification7 |
guid |
Classification 7 | |||
Classification8 |
guid |
Classification 8 | |||
Code |
varchar2 |
Code | |||
Code |
varchar2 |
Code at Supplier | |||
Company |
guid |
Company Size | |||
Consolidation |
int16 |
Consolidation Scenario | |||
Controlled |
datetime |
Date Checked | |||
Cost |
int16 |
Cost Paid | |||
Costcenter |
varchar2 |
Cost Centre | |||
Country |
varchar2 |
Country | |||
Created |
datetime |
Created | |||
Creator |
guid |
Creator | |||
Credit |
double |
Credit Line for Purchase | |||
Credit |
double |
Credit Line for Sales | |||
Currency |
varchar2 |
Currency | |||
Custom |
varchar2 |
Custom Field | |||
Customer |
datetime |
Customer Since | |||
Datev |
varchar2 |
DATEV Creditor Code | |||
Datev |
varchar2 |
DATEV Debtor Code | |||
Delivery |
int16 |
Delivery Advice | Delivery advice. | ||
Discount |
double |
Discount for Purchase | |||
Discount |
double |
Discount for Sales | |||
Division |
int32 |
Division | |||
Document |
guid |
Document | |||
Duns |
varchar2 |
DUNS Number | |||
EORI |
varchar2 |
EORI Number | |||
Email |
varchar2 |
||||
Enable |
char |
Enable Sales Payment Link | filters on the platform, writable | ||
End |
datetime |
End Date | |||
Established |
datetime |
Established Date | |||
Fax |
varchar2 |
Fax | |||
GLAP |
guid |
Accounts Payables General Ledger | |||
GLAR |
guid |
Accounts Receivables General Ledger | |||
GL |
guid |
GL Account for Purchase | |||
GL |
guid |
GL Account for Sales | |||
Gln |
varchar2 |
GLN Number | |||
Has |
char |
Has Withholding Tax Sales | |||
ID |
guid |
ID | |||
Ignore |
char |
Ignore DATEV Warning Message | |||
Incoterm |
varchar2 |
Incoterm Address Purchase | filters on the platform | ||
Incoterm |
varchar2 |
Incoterm Address Sales | filters on the platform | ||
Incoterm |
varchar2 |
Incoterm Code Purchase | filters on the platform | ||
Incoterm |
varchar2 |
Incoterm Code Sales | filters on the platform | ||
Incoterm |
int16 |
Incoterm Version Purchase | filters on the platform | ||
Incoterm |
int16 |
Incoterm Version Sales | filters on the platform | ||
Intra |
varchar2 |
Intrastat Area | |||
Intra |
varchar2 |
Intrastat Delivery Term | |||
Intra |
varchar2 |
Intrastat System | |||
Intra |
varchar2 |
Intrastat Transaction A | |||
Intra |
varchar2 |
Intrastat Transaction B | |||
Intra |
varchar2 |
Intrastat Transport Method | |||
Invoice |
guid |
Invoice Account | |||
Invoice |
int32 |
Invoice Attachment Type | |||
Invoicing |
int32 |
Invoicing Method | |||
Is |
int16 |
Is Accountant | |||
Is |
int16 |
Is Agency | |||
Is |
int16 |
Is Anonymised | |||
IsBank |
char |
Is Bank | |||
Is |
int16 |
Is Competitor | |||
Is |
char |
Is Extra Duty | |||
Is |
int16 |
Is Mailing | |||
Is |
char |
Is Member | |||
Is |
char |
Is Pilot | |||
Is |
char |
Is Purchase | |||
Is |
char |
Is Reseller | |||
Is |
char |
Is Sales | |||
Is |
char |
Is Supplier | |||
Language |
varchar2 |
Language | |||
Latitude |
double |
Latitude | |||
Lead |
guid |
Lead Purpose | |||
Lead |
guid |
Lead Source | |||
Logo |
blob |
Logo | |||
Logo |
varchar2 |
Logo File Name | |||
Logo |
varchar2 |
Logo Thumbnail (URL) | |||
Logo |
varchar2 |
Logo (URL) | |||
Longitude |
double |
Longitude | |||
Main |
guid |
Main Contact | |||
Modified |
datetime |
Modified | |||
Modifier |
guid |
Modifier | |||
Name |
varchar2 |
Name | |||
OIN |
varchar2 |
OIN Number | |||
Parent |
guid |
Parent | |||
Pay |
varchar2 |
Pay-as-you-Earn | |||
Payment |
varchar2 |
Payment Condition Purchase | |||
Payment |
varchar2 |
Payment Condition Sales | |||
Peppol |
varchar2 |
Peppol Identifier | |||
Peppol |
int32 |
Peppol Identifier Type | |||
Phone |
varchar2 |
Phone | |||
Phone |
varchar2 |
Phone Extension | |||
Postcode |
varchar2 |
Postal Code | |||
Price |
guid |
Price List | |||
Purchase |
varchar2 |
Purchase Currency | |||
Purchase |
int32 |
Purchase Lead Days | |||
Purchase |
varchar2 |
Purchase VAT Code | |||
RSIN |
varchar2 |
RSIN Number | |||
Recepient |
char |
Recipient of Commissions | |||
Remarks |
varchar2 |
Remarks | |||
Reseller |
guid |
Reseller | |||
Sales |
varchar2 |
Sales Currency | |||
Sales |
guid |
Sales Tax Schedule | |||
Sales |
varchar2 |
Sales VAT Code | |||
Search |
varchar2 |
Search Code | |||
Security |
int32 |
Security Level | |||
Separate |
int16 |
Separate Invoice per Project | |||
Separate |
int16 |
Separate Invoice per Subscription | |||
Shipping |
int32 |
Shipping Lead Days | |||
Shipping |
guid |
Shipping Method | |||
Show |
char |
Show Remark for Sales | Whether to show the remarks. | ||
Source |
int16 |
Source | |||
Start |
datetime |
Start Date | |||
State |
varchar2 |
State | |||
Status |
varchar2 |
Status | |||
Status |
datetime |
Status Since | |||
Timestamp |
int64 |
Timestamp | |||
Trade |
varchar2 |
Tradename | |||
Type |
varchar2 |
Type | |||
Unique |
varchar2 |
Unique Taxpayer Reference | |||
VAT |
varchar2 |
VAT Liability | |||
VAT |
varchar2 |
VAT Number | |||
Website |
varchar2 |
Website |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: