MaterialReversals: Exact Online Processed Cost Analysis Balance Lines per Period
insert update delete per partition REST
- Catalogus:
ExactOnlineREST - Schema:
Manufacturing - Primaire sleutels:
ReversalStockTransactionId - Label: Processed Cost Analysis Balance Lines per Period
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
API-bron
- Eindpunt:
/api/v1/{division}/manufacturing/MaterialReversals - Metagegevens:
/api/v1/{division}/manufacturing/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 7,200 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel MaterialReversals worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | 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 |
Divisie ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Divisie Kamer van Koophandel Nummer | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Divisie IBAN Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisie Bedrijfsnaam | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Divisie RSIN Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Divisie BTW Nummer | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Divisie Loonbelastingnummer | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administratie Naam | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Naam Abonnementhouder | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnementhoudernummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Divisie Korte Naam | writable | Short name of the Exact Online division. | |
Is |
char |
Is Backflush | filters on the platform, writable | Boolean indicating if this reversal was the result of shop order backflushing, processed during a ShopOrderReversal. | |
Is |
int16 |
Is Batch | filters on the platform, writable | Does the issue reversal's item use batch numbers. | |
Is |
int16 |
Is Fraction Toegestaan op Artikel | filters on the platform, writable | Indicates if fractions (for example 0.35) are allowed for quantities of the material reversal's item. | |
Is |
int16 |
Is Serieel | 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 |
Artikelcode | filters on the platform, writable | Code of item reversed. | |
Item |
varchar2 |
Artikelomschrijving | filters on the platform, writable | Description of item reversed. | |
Item |
varchar2 |
Artikelafbeelding (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 |
Productieorder | 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 |
Productieordernummer | filters on the platform, writable | Number of shop order reversed from. | |
Storage |
guid |
Opslaglocatie | filters on the platform, writable | ID of storage location reversed to. | |
Storage |
varchar2 |
Opslaglocatiecode | filters on the platform, writable | Code of storage location reversed to. | |
Storage |
varchar2 |
Opslag Locatie Omschrijving | filters on the platform, writable | Description of storage location reversed to. | |
Transaction |
datetime |
Transactiedatum | 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 |
Omschrijving 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 |
Magazijncode | filters on the platform, writable | Code of warehouse reversed to. | |
Warehouse |
varchar2 |
Magazijnomschrijving | filters on the platform, writable | Description of warehouse reversed to. |
Toetsen
| Key | Column | Verwijst naar | 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 |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: