SalesInvoiceLinesIncremental: Exact Online Sales Invoice Lines (Incremental) |
Catalog: ExactOnlineREST
Schema: Incremental
Primary Keys: ID
Label: Sales Invoice Lines (Incremental)
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.
Field Selection Method: NotRequired
View Columns
The columns of the view SalesInvoiceLinesIncremental are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
AmountDC |
double |
Amount Division Currency |
☐ |
Amount in the default currency of the company. For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC. |
AmountDiscount |
double |
Amount Discount |
☐ |
Discount amount in the default currency of the company. |
AmountDiscountExclVat |
double |
Amount Discount excluding VAT |
☐ |
Discount amount excluding VAT in the default currency of the company. |
AmountFC |
double |
Amount Foreign Currency |
☑ |
Amount in the currency of the transaction. |
AmountFCExclVat |
double |
Amount Foreign Currency excluding VAT |
☐ |
Amount exclude VAT in the currency of the transaction. |
CostCenter |
string |
Cost Center |
☐ |
Reference to Cost center. |
CostUnit |
string |
Cost Unit |
☐ |
Reference to Cost unit. |
Created |
datetime |
Created |
☐ |
|
Creator |
guid |
Creator |
☐ |
User ID of creator. |
Currency |
string |
Currency |
☐ |
Currency code. |
CustomerItemCode |
string |
|
☐ |
Code the customer uses for this item. |
DeliverTo |
guid |
Deliver to |
☐ |
Reference to the delivery customer. For an existing sales order this value can not be changed. |
DeliverToAddress |
guid |
Deliver To Address |
☐ |
Delivery address. |
DeliverToContactPerson |
guid |
Deliver to Contact Person |
☐ |
Reference to contact person of delivery customer. |
DeliveryDate |
datetime |
Delivery Date |
☐ |
Delivery date of an item in a sales invoice. This is used for VAT on prepayments, only if sales order is not used in the license. |
Description |
string |
Description |
☐ |
Description. Can be different for header and lines. |
Discount |
double |
Discount |
☐ |
Discount given on the default price. Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item. |
DiscountType |
int16 |
Discount Type |
☐ |
Leading field of total discount. 1=Discount percentage, 2=Discount amount excl. VAT, 3=Discount amount incl. VAT, 4=Total amount excl. VAT, 5=Total amount incl. VAT. |
Division |
int32 |
Division |
☑ |
Division code. |
Document |
guid |
Document |
☐ |
Document that is manually linked to the sales order. |
DueDate |
datetime |
Due Date |
☐ |
The due date for payments. This date is calculated based on the EntryDate and the Paymentcondition. |
Employee |
guid |
Employee |
☐ |
Link to Employee originating from time and cost transactions. |
EndTime |
datetime |
End Time |
☐ |
EndTime is used to store the last date of a period. EndTime is used in combination with StartTime. |
ExtraDutyAmountFC |
double |
Extra Duty Amount Foreign Currency |
☐ |
Extra duty amount in the currency of the transaction. Both extra duty amount and VAT amount need to be specified in order to differ this property from automatically calculated. |
ExtraDutyPercentage |
double |
Extra Duty (%) |
☐ |
Extra duty percentage. |
GAccountAmountFC |
double |
|
☐ |
A positive value of the amount indicates that the amount is to be paid by the customer to your G bank account.In case of a credit invoice the amount should have negative value when retrieved or posted to Exact. |
GLAccount |
guid |
General Ledger Account |
☐ |
The GL Account of the sales invoice line. This field is mandatory. This field is generated based on the revenue account of the item (or the related item group). G/L Account is also used to determine whether the costcenter / costunit is mandatory. |
ID |
guid |
ID |
☑ |
Primary key. |
IncotermAddress |
string |
|
☐ |
|
IncotermCode |
string |
|
☐ |
|
IncotermVersion |
int16 |
|
☐ |
|
InvoiceDate |
datetime |
Invoice Date |
☐ |
Official date for the invoice. When the invoice is entered it's equal to the field 'EntryDate'. During the printing process the invoice date can be entered. |
InvoiceID |
guid |
Invoice ID |
☑ |
The InvoiceID identifies the sales invoice. All the lines of a sales invoice have the same InvoiceID. |
InvoiceNumber |
int32 |
Invoice Number |
☐ |
Assigned at entry or at printing depending on setting. The number assigned is based on the freenumbers as defined for the Journal. When printing the field InvoiceNumber is copied to the fields EntryNumber and InvoiceNumber of the sales entry. |
InvoiceTo |
guid |
Invoice to |
☐ |
Reference to the customer who will receive the invoice. For an existing sales order this value can not be changed. |
InvoiceToContactPerson |
guid |
Invoice to Contact Person |
☐ |
Reference to the contact person of the customer who will receive the invoice. |
IsExtraDuty |
boolean |
Is Extra Duty |
☐ |
Indicates whether the invoice has extra duty. |
Item |
guid |
Item |
☐ |
Reference to the item that is sold in this sales invoice line. |
Journal |
string |
Journal |
☐ |
The journal code. Every invoice should be linked to a sales journal. |
LineNumber |
int32 |
Line Number |
☐ |
Indicates the sequence of the lines within one invoice. |
Modified |
datetime |
Modified |
☐ |
|
Modifier |
guid |
Modifier |
☐ |
User ID of modifier. |
NetPrice |
double |
Net Price |
☐ |
Net price of the sales invoice line. |
Notes |
string |
Notes |
☐ |
Extra notes. |
OrderDate |
datetime |
Order Date |
☐ |
Order date. |
OrderedBy |
guid |
Ordered by |
☐ |
Customer who ordered the invoice. |
OrderedByContactPerson |
guid |
Ordered by Contact Person |
☐ |
Contact person of customer who ordered the invoice. |
OrderNumber |
int32 |
Order Number |
☐ |
Number of sales order. |
PaymentCondition |
string(2) |
Payment Condition |
☐ |
The payment condition used for due date and discount calculation. |
PaymentReference |
string(60) |
Payment Reference |
☐ |
Payment reference for sales invoice. |
Pricelist |
guid |
Price List |
☐ |
Price list. |
Project |
guid |
Project |
☐ |
The project to which the sales transaction line is linked. The project can be different per line. Sometimes also the project in the header is filled although this is not really used. |
ProjectWBS |
guid |
Project WBS |
☐ |
WBS linked to the sales invoice. |
Quantity |
double |
Quantity |
☐ |
The number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactor. |
Remarks |
string |
Remarks |
☐ |
|
SalesChannel |
guid |
Sales Channel |
☐ |
Reference to sales channel. |
SalesOrder |
guid |
Sales Order |
☐ |
Identifies the sales order this invoice line is based on. |
SalesOrderLine |
guid |
Sales Order Line |
☐ |
Identifies the sales order line this sales invoice line is based on. |
Salesperson |
guid |
Sales Person |
☐ |
Reference to sales person. |
StartTime |
datetime |
Start Time |
☐ |
StartTime is used to store the first date of a period. StartTime is used in combination with EndTime. |
Status |
int16 |
Status |
☐ |
The status of the entry. 10 = draft. During the creation of an invoice draft records occur in the draft modus if during an invoice a new page with lines is triggered. If the user leaves the invoice in an abnormal way the draft invoices can be recovered. Draft invoices are not included in financial reports, balances etc. 20 = open. Open invoices can be changed. New invoices get the status open by default. 50 = processed. Processed invoices can't be changed anymore. Processing is done via printing. Processed invoices can't be reopened. |
Subscription |
guid |
Subscription |
☐ |
When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines. |
Timestamp |
int64 |
Timestamp |
☑ |
|
Type |
int16 |
Type |
☐ |
Indicates the type of invoice Values: 8020 - Sales invoices, 8021 - Sales credit note, 8023 - Direct sales invoice, 8024 - Direct credit note. Type 8023 and 8024 are only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. |
UnitCode |
string |
Unit Code |
☐ |
Code of Unit. |
UnitPrice |
double |
Unit Price |
☐ |
Price per unit. |
VATAmountDC |
double |
VAT Amount Division Currency |
☐ |
VAT amount in the default currency of the company. |
VATAmountFC |
double |
VAT Amount Foreign Currency |
☐ |
VAT amount in the currency of the transaction. |
VATCode |
string |
VAT Code |
☐ |
The VAT code that is used when the invoice is registered. |
VATPercentage |
double |
VAT Percentage |
☐ |
The VAT percentage of the VAT code. This is the percentage at the moment the invoice is created. It's also used for the default calculation of VAT amounts and VAT base amounts. |
Warehouse |
guid |
Warehouse |
☐ |
Reference to warehouse. Mandatory for direct sales invoice/credit note, cannot be set for normal sales invoice/credit note. |
WithholdingTaxAmountFC |
double |
Withholding Tax Amount (Foreign Currency) |
☐ |
Withholding tax amount applied to sales invoice. Not supported in The Netherlands. |
WithholdingTaxBaseAmount |
double |
Withholding Tax Base Amount |
☐ |
Withholding tax base amount to calculate withholding amount. Not supported in The Netherlands. |
WithholdingTaxPercentage |
double |
Withholding Tax (%) |
☐ |
Withholding tax percentage applied to sales invoice. Not supported in The Netherlands. |
YourRef |
string |
Your Reference |
☐ |
Invoice number of the customer. |
15-06-2022 19:32 Version 22.0.232-PROD+3445