MaterialReversals: Exact Online Verwerkte Kostenanalyse Balansregels per Periode |
Catalogus: ExactOnlineREST
Schema: Manufacturing
Primaire Sleutels: ReversalStockTransactionId
Label: Verwerkte Kostenanalyse Balansregels per Periode
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
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.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
CreatedBy |
guid |
{res:itgen_eol_createdby} |
☐ |
ID of creating user. |
CreatedByFullName |
string(240) |
{res:itgen_eol_createdbyfullname} |
☐ |
Name of the creating user. |
CreatedDate |
datetime |
{res:itgen_eol_createddate} |
☐ |
Date this reversal was created. |
Division |
int32 |
Divisie ID |
☑ |
Unique number of the Exact Online division. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
IsBackflush |
boolean |
Is Backflush |
☑ |
Boolean indicating if this reversal was the result of shop order backflushing, processed during a ShopOrderReversal. |
IsBatch |
int16 |
Is Batch |
☐ |
Does the issue reversal's item use batch numbers. |
IsFractionAllowedItem |
int16 |
Is Fraction Toegestaan op Artikel |
☐ |
Indicates if fractions (for example 0.35) are allowed for quantities of the material reversal's item. |
IsSerial |
int16 |
Is Serieel |
☐ |
Does the issue reversal's item use serial numbers. |
Item |
guid |
Artikel |
☐ |
Item reversed. |
ItemCode |
string(30) |
Artikelcode |
☐ |
Code of item reversed. |
ItemDescription |
string(255) |
Artikelomschrijving |
☐ |
Description of item reversed. |
ItemPictureUrl |
string |
Artikelafbeelding (URL) |
☐ |
Picture url of item issued. |
Note |
string |
Notitie |
☐ |
Notes logged with this reversal. |
OriginalStockTransactionId |
guid |
{res:itgen_eol_originalstocktransactionid} |
☐ |
ID of the original stock transaction, which was reversed. |
Quantity |
double |
Aantal |
☐ |
Quantity of this reversal. |
ReversalStockTransactionId |
guid |
{res:itgen_eol_reversalstocktransactionid} |
☑ |
ID of stock transaction related to this material issue. |
ShopOrder |
guid |
Productieorder |
☐ |
ID of shop order reversed from. |
ShopOrderMaterialPlan |
guid |
{res:itgen_eol_shopordermaterialplan} |
☐ |
ID of shop order material plan. |
ShopOrderNumber |
int32 |
Productieordernummer |
☐ |
Number of shop order reversed from. |
StorageLocation |
guid |
Opslaglocatie |
☐ |
ID of storage location reversed to. |
StorageLocationCode |
string |
Opslaglocatiecode |
☐ |
Code of storage location reversed to. |
StorageLocationDescription |
string |
Opslag Locatie Omschrijving |
☐ |
Description of storage location reversed to. |
TransactionDate |
datetime |
Transactiedatum |
☐ |
Effective date of this reversal. |
Unit |
string(8) |
Unit |
☐ |
Unit of measurement abbreviation of item reversed. |
UnitDescription |
string(60) |
Omschrijving Unit |
☐ |
Unit of measurement of item reversed. |
Warehouse |
guid |
Magazijn |
☐ |
ID of warehouse reversed to. |
WarehouseCode |
string |
Magazijncode |
☐ |
Code of warehouse reversed to. |
WarehouseDescription |
string |
Magazijnomschrijving |
☐ |
Description of warehouse reversed to. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455