SalesInvoiceLines: Exact Online Sales Invoice Lines
insert update delete per partition webhook REST
- Catálogo:
ExactOnlineREST - Esquema:
SalesInvoice - Llaves Primarias:
ID - Label: Sales Invoice Lines
Los datos de esta tabla están divididos por el valor de la columna Division.
Permite recuperar y modificar datos utilizando insert, update y delete.
Los cambios llegan a través del tema de webhook SalesInvoices en InvoiceID.
Fuente de la API
- Punto final:
/api/v1/{division}/salesinvoice/SalesInvoiceLines - Metadatos:
/api/v1/{division}/salesinvoice/$metadata
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 5 |
| Número de filas escaneadas por minuto | 7,200 |
| Número de filas de queries puntuales por minuto | 300 |
| Escribir filas por minuto | 300 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SalesInvoiceLines. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Amount |
double |
Importe División Moneda | writable | Amount in the default currency of the company.For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC. | |
Amount |
double |
Cantidad Moneda Extranjera | writable | For normal lines it's the amount excluding VAT. | |
Cost |
varchar2 |
Centro de Costo | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Descripción del Centro de Costo | writable | Description of CostCenter. | |
Cost |
varchar2 |
Unidad de Costo | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Descripción de la Unidad de Costo | writable | Description of CostUnit. | |
Custom |
varchar2 |
Campo personalizado | writable | ||
Customer |
varchar2 |
Código de artículo del cliente | Code the customer uses for this item. | ||
Delivery |
datetime |
Fecha de Entrega | writable | 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 |
varchar2 |
Description | filters on the platform, writable | Description.Can be different for header and lines. | |
Discount |
double |
Discount | writable | Discount given on the default price.Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Número de la Cámara de Comercio de la División | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Número IBAN de la división | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
División: Nombre de la empresa | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Número de la división RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Número de IVA de la división | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Número de identificación fiscal de la división en materia de impuestos sobre los salarios | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etiqueta de división | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nombre de la Adminisración | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nombre del titular de la suscripción | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Número de titular de la suscripción | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nombre abreviado de la división | writable | Short name of the Exact Online division. | |
Employee |
guid |
Employee | filters on the platform, writable | Link to Employee originating from time and cost transactions. | |
Employee |
varchar2 |
Nombre completo del empleado | writable | Name of employee. | |
End |
datetime |
Hora de finalización | writable | EndTime is used to store the last date of a period.EndTime is used in combination with StartTime. | |
Extra |
double |
Importe del recargo por monedas extranjeras | writable | 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. | |
Extra |
double |
Recargo (%) | writable | Extra duty percentage. | |
GL |
guid |
Cuenta de Contabilidad General | filters on the platform, writable | 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. | |
GL |
varchar2 |
Descripción de Cuenta del Libro Mayor | writable | Description of the G/L account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Invoice |
guid |
ID de la Factura | filters on the platform, writable | The InvoiceID identifies the sales invoice.All the lines of a sales invoice have the same InvoiceID. | |
Item |
guid |
Item | filters on the platform, writable | Reference to the item that is sold in this sales invoice line. | |
Item |
varchar2 |
Código del Artículo | writable | Item code. | |
Item |
varchar2 |
Descripción del Elemento | writable | Description of Item. | |
Line |
int32 |
Número de Línea | filters on the platform, writable | Indicates the sequence of the lines within one invoice. | |
Net |
double |
Importe neto División Moneda | writable | Net amount in division currency of sales invoice line. | |
Net |
double |
Importe neto en moneda extranjera | writable | Net amount in foreign currency of sales invoice line. | |
Net |
double |
Precio Neto | writable | Net price of the sales invoice line. | |
Notes |
varchar2 |
Notes | writable | Extra notes. | |
Pricelist |
guid |
Lista de Precios | filters on the platform, writable | Price list. | |
Pricelist |
varchar2 |
Descripción de la Lista de Precios | writable | Description of Pricelist. | |
Project |
guid |
Project | filters on the platform, writable | 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. | |
Project |
varchar2 |
Descripción del Proyecto | writable | Description of Project. | |
Project |
guid |
Estructura de división del proyecto (WBS) | writable | WBS linked to the sales invoice. | |
Project |
varchar2 |
Descripción de la estructura de división del proyecto (WBS) | writable | Description of WBS. | |
Quantity |
double |
Quantity | writable | The number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. | |
Sales |
guid |
Orden de Venta | filters on the platform, writable | Identifies the sales order this invoice line is based on. | |
Sales |
guid |
Línea de Orden de Ventas | filters on the platform, writable | Identifies the sales order line this sales invoice line is based on. | |
Sales |
int32 |
Número de línea del pedido de venta | writable | Then line number of the sales order line on which this invoice line is based on. | |
Sales |
int32 |
Número de Orden de Venta | writable | The order number of the sales order on which this invoice line is based on. | |
Start |
datetime |
Hora de Inicio | writable | StartTime is used to store the first date of a period.StartTime is used in combination with EndTime. | |
Subscription |
guid |
Subscription | filters on the platform, writable | When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines. | |
Subscription |
varchar2 |
Descripción de Suscripción | writable | Description of subscription line. | |
Tax |
guid |
Calendario fiscal | filters on the platform, writable | Obsolete. | |
Tax |
varchar2 |
Código del baremo fiscal | writable | Obsolete. | |
Tax |
varchar2 |
Descripción del calendario fiscal | writable | Obsolete. | |
Unit |
varchar2 |
Código de la Unidad | writable | Code of Unit. | |
Unit |
varchar2 |
Descripción de la Unidad | writable | Description of Unit. | |
Unit |
double |
Precio de la Unidad | writable | Price per unit. | |
VAT |
double |
Importe del IVA, división, Moneda | writable | VAT amount in the default currency of the company. | |
VAT |
double |
Moneda Extranjera de la Cantidad VAT | writable | VAT amount in the currency of the transaction. | |
VAT |
varchar2 |
Código VAT | filters on the platform, writable | The VAT code that is used when the invoice is registered. | |
VAT |
varchar2 |
Descripción del Código VAT | writable | Description of VAT code. | |
VAT |
double |
Porcentaje VAT | writable | 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. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Sales |
Cost |
Costcenters.Code |
Key | |
Sales |
Cost |
Costunits.Code |
Key | |
Sales |
Employee |
Employees.ID |
Key | |
Sales |
GL |
GLAccounts.ID |
Key | |
Sales |
Invoice |
SalesInvoices. |
Key | |
Sales |
Item |
Items.ID |
Key | |
Sales |
Pricelist |
SalesPriceLists.ID |
Key | |
Sales |
Project |
ProjectWBS.ID |
Key | |
Sales |
Project |
Projects.ID |
Key | |
Sales |
Sales |
SalesOrderLines.ID |
Key | |
Sales |
Sales |
SalesOrders. |
Key | |
Sales |
Subscription |
Subscriptions. |
Key | |
Sales |
VAT |
VATCodes.Code |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: