Projects: Exact Online Projects
insert update delete per partition REST
- Catálogo:
ExactOnlineREST - Esquema:
Project - Llaves Primarias:
ID - Label: Projects
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.
Fuente de la API
- Punto final:
/api/v1/{division}/project/Projects - Metadatos:
/api/v1/{division}/project/$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 Projects. 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 |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | The account for this project. | |
Account |
varchar2 |
Código de la Cuenta | filters on the platform, writable | Code of Account. | |
Account |
guid |
Contacto de la Cuenta | filters on the platform, writable | Contact person of Account. | |
Account |
varchar2 |
Nombre de la Cuenta | filters on the platform, writable | Name of account. | |
Allow |
char |
Permitir la facturación adicional | filters on the platform, writable | Is additional invoice is allowed for project. | |
Allow |
char |
itgen_eol_allowmemberentryonly | filters on the platform, writable | ||
Block |
char |
Introducir la fecha y el coste | filters on the platform, writable | Block time and cost entries. | |
Block |
char |
itgen_eol_blockinvoicing | filtros de la plataforma | ||
Block |
char |
Planificación por bloques | filters on the platform, writable | ||
Block |
char |
Compras en bloque | filtros de la plataforma | ||
Block |
char |
Bloquear la Refacturación | filters on the platform, writable | Block rebilling. | |
Budget |
int16 |
Estado de las horas que superan el presupuesto | filters on the platform, writable | 10-Allowed, 20-Not Allowed. | |
Budget |
int16 |
Tipo de Presupuesto | filters on the platform, writable | Budget type. | |
Budget |
varchar2 |
itgen_eol_budgettypedescription | filters on the platform, writable | Budget type description. | |
Budgeted |
double |
Cantidad Presupuestada | filters on the platform, writable | Budgeted amount of sales in the default currency of the company. | |
Budgeted |
double |
Costos Presupuestados | filters on the platform, writable | Budgeted amount of costs in the default currency of the company. | |
Budgeted |
double |
Ingreso Presupuestado | filters on the platform, writable | Budgeted amount of revenue in the default currency of the company. | |
Classification |
guid |
Classification | filters on the platform, writable | Used only for PSA to link a project classification to the project. | |
Classification |
varchar2 |
Descripción de la Clasificación | filters on the platform, writable | Description of Classification. | |
Code |
varchar2 |
Code | filters on the platform, writable | Code. | |
Costs |
double |
itgen_eol_costsamountfc | writable | Used only for PSA to store the budgetted costs of a project (except for project type Campaign and Non-billable).Positive quantities only. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | filters on the platform, writable | Name of creator. | |
Custom |
varchar2 |
Campo personalizado | filters on the platform, writable | ||
Customer |
varchar2 |
Número OC del Cliente | filters on the platform, writable | Used only for PSA to store the customer's PO number. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description of the project. | |
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 Compañía | filters on the platform, writable | Name of 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. | |
Enable |
char |
itgen_eol_enableworkinprogress | filtros de la plataforma | Whether Work In Progress can be used. | |
End |
datetime |
Fecha Final | filters on the platform, writable | End date of the project.In combination with the start date the status is determined. | |
Fixed |
guid |
Artículo de Precio Fijo | filters on the platform, writable | Item used for fixed price invoicing.To be defined per project.If empty the functionality relies on the setting. | |
Fixed |
varchar2 |
itgen_eol_fixedpriceitemdescription | filters on the platform, writable | Description of FixedPriceItem. | |
Has |
char |
Tiene líneas WBS | filters on the platform, writable | Indicates if whether the Project has WBS. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Include |
int16 |
itgen_eol_includeinvoicespecification | filtros de la plataforma | ||
Include |
char |
itgen_eol_includespecificationininvoicepdf | filtros de la plataforma | ||
Internal |
varchar2 |
Notas internas | filters on the platform, writable | Internal notes not to be printed in invoice. | |
Invoice |
guid |
Dirección de la Factura | filters on the platform, writable | Invoice address. | |
Invoice |
char |
Factura conforme al presupuesto | filters on the platform, writable | Is invoice as quoted. | |
Invoice |
varchar2 |
itgen_eol_invoicedescription | filtros de la plataforma | Description for invoice. | |
Is |
int16 |
itgen_eol_iswbsrequiredforentry | filters on the platform, writable | ||
Manager |
guid |
Manager | filters on the platform, writable | Responsible person for this project. | |
Manager |
varchar2 |
Nombre Completo del Administrador | filters on the platform, writable | Name of Manager. | |
Markup |
double |
Porcentaje de margen | filters on the platform, writable | Purchase markup percentage. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nombre completo modificado | filters on the platform, writable | Name of modifier. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | For additional information about projects. | |
Payment |
varchar2 |
Condición de Pago | filters on the platform, writable | ||
Prepaid |
guid |
Artículo Prepagado | filters on the platform, writable | Used only for PSA.This item is used for prepaid invoicing.If left empty, the functionality relies on a setting. | |
Prepaid |
varchar2 |
itgen_eol_prepaiditemdescription | filters on the platform, writable | Description of PrepaidItem. | |
Prepaid |
int16 |
Tipo Prepagado | filters on the platform, writable | PrepaidType: 1-Retainer, 2-Hour type bundle. | |
Prepaid |
varchar2 |
itgen_eol_prepaidtypedescription | filters on the platform, writable | Description of PrepaidType. | |
Sales |
double |
Cantidad de Tiempo de Ventas | filters on the platform, writable | Budgeted time.Total number of hours estimated for the fixed price project. | |
Source |
guid |
Cita de la fuente | filters on the platform, writable | Source quotation. | |
Start |
datetime |
Fecha Inicial | filters on the platform, writable | Start date of a project.In combination with the end date the status is determined. | |
Time |
double |
Tiempo: cantidad para activar la alerta | filters on the platform, writable | Alert when exceeding (Hours). | |
Type |
int32 |
Type | filters on the platform, writable | Reference to ProjectTypes. | |
Type |
varchar2 |
Descripción del Tipo | filters on the platform, writable | Description of Type. | |
Use |
char |
itgen_eol_usebillingmilestones | filters on the platform, writable | Using billing milestones. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Projects_ |
Account |
Contacts.ID |
Key | |
Projects_ |
Account |
Accounts.ID |
Key | |
Projects_ |
Creator |
Users. |
Key | |
Projects_ |
Fixed |
Items.ID |
Key | |
Projects_ |
Invoice |
Addresses.ID |
Key | |
Projects_ |
Modifier |
Users. |
Key | |
Projects_ |
Prepaid |
Items.ID |
Key | |
Projects_ |
Source |
Quotations. |
Key |
Referenciado por
- Events
Project(Key) - Tasks
Project(Key) - HostingOpportunities
Project(Key) - HostingOpportunitiesRead
Project(Key) - Opportunities
Project(Key) - OpportunitiesRead
Project(Key) - Quotations
Project(Key) - QuotationsBulk
Project(Key) - Documents
Project(Key) - DocumentsBulk
Project(Key) - BankEntryLines
Project(Key) - CashEntryLines
Project(Key) - TransactionLines
Project(Key) - TransactionLinesBulk
Project(Key) - GeneralJournalEntryLines
Project(Key) - ShopOrders
Project(Key) - CostTransactions
Project(Key) - InvoiceTerms
Project(Key) - PjtTimeTransactions
Project(Key) - ProjectAccountMutations
Project(Key) - ProjectHourBudgets
Project(Key) - ProjectPlanning
Project(Key) - ProjectPlanningRecurring
Project(Key) - ProjectRestrictionEmployeeItems
Project(Key) - ProjectRestrictionEmployees
Project(Key) - ProjectRestrictionItems
Project(Key) - ProjectRestrictionRebillings
Project(Key) - ProjectWBS
Project(Key) - ProjectWBSBulk
Project(Key) - RecentCosts
ProjectId(Key) - RecentHours
ProjectId(Key) - WBSActivities
Project(Key) - WBSDeliverables
Project(Key) - WBSExpenses
Project(Key) - PurchaseInvoiceLines
Project(Key) - PurchaseEntryLines
Project(Key) - GoodsReceiptLines
Project(Key) - PurchaseOrderLines
Project(Key) - SalesEntryLines
Project(Key) - SalesInvoiceLines
Project(Key) - SalesInvoiceLinesBulk
Project(Key) - SalesOrderLines
Project(Key) - SalesOrderLinesBulk
Project(Key)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: