MaterialReversals: Exact Online Processed Cost Analysis Balance Lines per Period
insert update delete per partition REST
- Catalogue :
ExactOnlineREST - Schéma :
Manufacturing - Clés primaires :
ReversalStockTransactionId - Label: Processed Cost Analysis Balance Lines per Period
Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.
Permet de récupérer et de modifier des données à l'aide de insert, update et delete.
Source de l'API
- Point de terminaison :
/api/v1/{division}/manufacturing/MaterialReversals - Métadonnées :
/api/v1/{division}/manufacturing/$metadata
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 7,200 |
| Nombre de lignes de requêtes ponctuelles par minute | 300 |
| Nombre d'enregistrements écrits par minute | 300 |
Le résultat peut être mis en cache côté client.
Colonnes de table
Les colonnes de la table MaterialReversals sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Created |
guid |
itgen_eol_createdby | filters on the platform, writable | ID of creating user. | |
Created |
varchar2 |
itgen_eol_createdbyfullname | filters on the platform, writable | Name of the creating user. | |
Created |
datetime |
itgen_eol_createddate | filters on the platform, writable | Date this reversal was created. | |
Division |
int32 |
ID de l'entreprise | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Numéro d'enregistrement à la Chambre de commerce de la division | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Numéro IBAN de la division | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division - Nom de l'entreprise | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numéro de division RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Numéro de TVA de la division | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Numéro d'identification fiscale de la division | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Étiquette de division | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nom de l'administration | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nom du titulaire de l'abonnement | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numéro d'abonné | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nom abrégé de la division | writable | Short name of the Exact Online division. | |
Is |
char |
C'est le « backflush » | filters on the platform, writable | Boolean indicating if this reversal was the result of shop order backflushing, processed during a ShopOrderReversal. | |
Is |
int16 |
Est-ce un traitement par lots ? | filters on the platform, writable | Does the issue reversal's item use batch numbers. | |
Is |
int16 |
Les fractions sont-elles autorisées sur cet article ? | filters on the platform, writable | Indicates if fractions (for example 0.35) are allowed for quantities of the material reversal's item. | |
Is |
int16 |
Est-ce que « Serial » | filters on the platform, writable | Does the issue reversal's item use serial numbers. | |
Item |
guid |
Item | filters on the platform, writable | Item reversed. | |
Item |
varchar2 |
Code de l'article | filters on the platform, writable | Code of item reversed. | |
Item |
varchar2 |
Description de l’article | filters on the platform, writable | Description of item reversed. | |
Item |
varchar2 |
Image de l'article (URL) | writable | Picture url of item issued. | |
Note |
varchar2 |
Note | filters on the platform, writable | Notes logged with this reversal. | |
Original |
guid |
itgen_eol_originalstocktransactionid | filters on the platform, writable | ID of the original stock transaction, which was reversed. | |
Quantity |
double |
Quantity | filters on the platform, writable | Quantity of this reversal. | |
Reversal |
guid |
itgen_eol_reversalstocktransactionid | filters on the platform, writable | ID of stock transaction related to this material issue. | |
Shop |
guid |
Commande d'atelier | filters on the platform, writable | ID of shop order reversed from. | |
Shop |
guid |
itgen_eol_shopordermaterialplan | filters on the platform, writable | ID of shop order material plan. | |
Shop |
int32 |
Numéro de commande | filters on the platform, writable | Number of shop order reversed from. | |
Storage |
guid |
Emplacement de stockage | filters on the platform, writable | ID of storage location reversed to. | |
Storage |
varchar2 |
Code d'emplacement de stockage | filters on the platform, writable | Code of storage location reversed to. | |
Storage |
varchar2 |
Description du lieu de stockage | filters on the platform, writable | Description of storage location reversed to. | |
Transaction |
datetime |
Date de transaction | filters on the platform, writable | Effective date of this reversal. | |
Unit |
varchar2 |
Unit | filters on the platform, writable | Unit of measurement abbreviation of item reversed. | |
Unit |
varchar2 |
Description d'unité | filters on the platform, writable | Unit of measurement of item reversed. | |
Warehouse |
guid |
Warehouse | filters on the platform, writable | ID of warehouse reversed to. | |
Warehouse |
varchar2 |
Code d'entrepôt | filters on the platform, writable | Code of warehouse reversed to. | |
Warehouse |
varchar2 |
Description de l'entrepôt | filters on the platform, writable | Description of warehouse reversed to. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Material |
Created |
Users. |
Key | |
Material |
Item |
Items.ID |
Key | |
Material |
Shop |
ShopOrderMaterialPlans.ID |
Key | |
Material |
Shop |
ShopOrders.ID |
Key | |
Material |
Storage |
StorageLocations.ID |
Key | |
Material |
Unit |
Units.Code |
Key | |
Material |
Warehouse |
Warehouses.ID |
Key |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :