PrintedSalesInvoices: Exact Online Printed Sales Invoices
insert per partition REST
- Catálogo:
ExactOnlineREST - Esquema:
SalesInvoice - Llaves Primarias:
ID - Label: Printed Sales Invoices
Los datos de esta tabla están divididos por el valor de la columna Division.
Permite recuperar y modificar datos mediante insert.
Fuente de la API
- Punto final:
/api/v1/{division}/salesinvoice/PrintedSalesInvoices - 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.
Parámetros
| Name | Tipo de Datos | Required | Default | Documentation |
|---|---|---|---|---|
division |
int32 |
ID of the division to retrieve data for. |
Columnas de la Tabla
A continuación se muestran las columnas de la tabla PrintedSalesInvoices. 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 |
|---|---|---|---|---|---|
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. | |
Document |
guid |
Document | writable | Contains the id of the document that was created. | |
Document |
varchar2 |
Error al crear el documento | writable | Contains the error message if an error occurred during the creation of the document. | |
Document |
varchar2 |
Creación del documento completada con éxito | writable | Contains information if a document was successfully created. | |
Document |
guid |
Diseño del documento | writable | Based on this layout a PDF is created and attached to an Exact Online document and an email. | |
Email |
varchar2 |
Error al crear un correo electrónico | writable | Contains the error message if an error occurred during the creation of the email. | |
Email |
varchar2 |
Éxito en la creación de correos electrónicos | writable | Contains confirmation that an email was sent.If an email cannot be delivered this property will still show confirmation that the email was sent. | |
Email |
guid |
Diseño del correo electrónico | writable | Based on this layout the email text is produced. | |
Extra |
varchar2 |
Texto adicional | writable | Extra text that can be added to the printed document and email. | |
Invoice |
datetime |
Fecha de la Factura | writable | Date of the invoice. | |
Invoice |
guid |
ID de la Factura | writable | Primary key, Reference to EntryID of SalesInvoice. | |
Peppol |
varchar2 |
Error de creación de Peppol | filters on the platform, writable | Error during Peppol creation. | |
Peppol |
varchar2 |
Éxito en la creación de Peppol | filters on the platform, writable | Whether Peppol creation succeeded. | |
Postbox |
varchar2 |
Error al crear un mensaje en Postbox | writable | Contains the error message if an error occurred during the sending of a postbox message. | |
Postbox |
varchar2 |
Se ha creado correctamente el mensaje de Postbox | writable | Contains information if a postbox message was successfully sent. | |
Postbox |
guid |
Remitente del buzón | writable | The postbox from where the message is sent. | |
Reporting |
int32 |
Reportando Período | writable | Reporting period. | |
Reporting |
int32 |
Reportando Año | writable | Reporting year. | |
Send |
char |
Enviar un correo electrónico al cliente | writable | Set to True if an email containing the invoice should be sent to the invoice customer.This option overrules SendInvoiceToCustomerPostbox. | |
Send |
char |
Enviar la factura al buzón del cliente | writable | Set to True if a postbox message containing the invoice should be sent to the invoice customer. | |
Send |
char |
Enviar factura a través de Peppol | filters on the platform, writable | Whether to send via Peppol. | |
Send |
char |
Enviar los resultados según la cuenta | writable | Set to True if the output preference should be taken from the account.It will be either Document only, Email or Digital postbox.This option overrules both SendEmailToCustomer and SendInvoiceToCustomerPostbox. | |
Sender |
varchar2 |
Dirección de correo electrónico del remitente | writable | Email address from which the email will be sent.If not specified, the company email address will be used. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: