invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

GoodsReceiptLineBatchNumbers: Exact Online Goods Receipt Line Batch Numbers

read only per partition REST

  • Catalogus: ExactOnlineREST
  • Schema: PurchaseOrder
  • Primaire sleutels: ID
  • Label: Goods Receipt Line Batch Numbers

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /api/v1/{division}/purchaseorder/GoodsReceiptLines?$select=Created,Creator,CreatorFullName,Description,Division,GoodsReceiptID,ID,Item,ItemCode,ItemDescription,ItemUnitCode,LineNumber,Location,LocationCode,LocationDescription,Modified,Modifier,ModifierFullName,Notes,Project,ProjectCode,ProjectDescription,PurchaseOrderID,PurchaseOrderLineID,PurchaseOrderNumber,QuantityOrdered,QuantityReceived,SupplierItemCode,BatchNumbers&$expand=BatchNumbers

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 GoodsReceiptLineBatchNumbers 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
BnrBatchNumber varchar2 Batchnummer writable, BatchNumber
BnrBatchNumberID guid Batchnummer-ID writable, BatchNumberID
BnrCreated datetime Created writable, Created
BnrCreator guid Creator writable, Creator
BnrCreatorFullName varchar2 Aanmaker Volledige Naam writable, CreatorFullName
BnrDivision int32 Division writable, Division
BnrDraftStockTransactionID guid itgen_eol_bnrdraftstocktransactionid writable, DraftStockTransactionID
BnrEndDate datetime Einddatum writable, EndDate
BnrID guid Batchnummer-ID writable, ID
BnrIsBlocked int16 Is Geblokkeerd writable, IsBlocked
BnrIsDraft int16 Is Concept writable, IsDraft
BnrItem guid Item writable, Item
BnrItemCode varchar2 Artikelcode writable, ItemCode
BnrItemDescription varchar2 Artikelomschrijving writable, ItemDescription
BnrModified datetime Modified writable, Modified
BnrModifier guid Modifier writable, Modifier
BnrModifierFullName varchar2 Gewijzigd Volledige Naam writable, ModifierFullName
BnrQuantity double Quantity writable, Quantity
BnrRemarks varchar2 Remarks writable, Remarks
BnrStockCountLine guid Voorraadtellingregel writable, StockCountLine
BnrStockTransactionID guid itgen_eol_bnrstocktransactionid writable, StockTransactionID
BnrStockTransactionType int32 itgen_eol_bnrstocktransactiontype writable, StockTransactionType
BnrStorageLocation guid Opslaglocatie writable, StorageLocation
BnrStorageLocationCode varchar2 itgen_eol_bnrstoragelocationcode writable, StorageLocationCode
BnrWarehouse guid Warehouse writable, Warehouse
BnrWarehouseCode varchar2 Magazijncode writable, WarehouseCode
Created datetime Created filters on the platform, writable, ::ancestor.::ancestor.Created
Creator guid Creator filters on the platform, writable, ::ancestor.::ancestor.Creator
CreatorFullName varchar2 Aanmaker Volledige Naam filters on the platform, writable, ::ancestor.::ancestor.CreatorFullName
Description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.Description
Division int32 Division filters on the platform, writable, ::ancestor.::ancestor.Division
GoodsReceiptID guid Goederenontvangst-ID filters on the platform, writable, ::ancestor.::ancestor.GoodsReceiptID
ID guid ID filters on the platform, writable, ::ancestor.::ancestor.ID
Item guid Item filters on the platform, writable, ::ancestor.::ancestor.Item
ItemCode varchar2 Artikelcode filters on the platform, writable, ::ancestor.::ancestor.ItemCode
ItemDescription varchar2 Artikelomschrijving filters on the platform, writable, ::ancestor.::ancestor.ItemDescription
ItemUnitCode varchar2 Artikel Eenheidscode filters on the platform, writable, ::ancestor.::ancestor.ItemUnitCode
LineNumber int32 Regelnummer filters on the platform, writable, ::ancestor.::ancestor.LineNumber
Location guid Location filters on the platform, writable, ::ancestor.::ancestor.Location
LocationCode varchar2 Locatiecode filters on the platform, writable, ::ancestor.::ancestor.LocationCode
LocationDescription varchar2 Locatieomschrijving filters on the platform, writable, ::ancestor.::ancestor.LocationDescription
Modified datetime Modified filters on the platform, writable, ::ancestor.::ancestor.Modified
Modifier guid Modifier filters on the platform, writable, ::ancestor.::ancestor.Modifier
ModifierFullName varchar2 Gewijzigd Volledige Naam filters on the platform, writable, ::ancestor.::ancestor.ModifierFullName
Notes varchar2 Notes filters on the platform, writable, ::ancestor.::ancestor.Notes
Project guid Project filters on the platform, writable, ::ancestor.::ancestor.Project
ProjectCode varchar2 Projectcode filters on the platform, writable, ::ancestor.::ancestor.ProjectCode
ProjectDescription varchar2 Projectomschrijving filters on the platform, writable, ::ancestor.::ancestor.ProjectDescription
PurchaseOrderID guid Inkoopopdracht ID filters on the platform, writable, ::ancestor.::ancestor.PurchaseOrderID
PurchaseOrderLineID guid Inkooporderregel-ID filters on the platform, writable, ::ancestor.::ancestor.PurchaseOrderLineID
PurchaseOrderNumber int32 Inkoopordernummer filters on the platform, writable, ::ancestor.::ancestor.PurchaseOrderNumber
QuantityOrdered double Hoeveelheid Besteld writable, ::ancestor.::ancestor.QuantityOrdered
QuantityReceived double Hoeveelheid Ontvangen writable, ::ancestor.::ancestor.QuantityReceived
SupplierItemCode varchar2 Leverancier Artikelcode filters on the platform, writable, ::ancestor.::ancestor.SupplierItemCode

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: