invantive documentation
Forum di supporto InvantiveAccedi / Registrati

PurchaseReturnLineBatchNumbers: Exact Online Purchase Return Line Batch Numbers

read only per partition REST

  • Catalogo: ExactOnlineREST
  • Schema: PurchaseOrder
  • Chiavi primarie: ID
  • Label: Purchase Return Line Batch Numbers

I dati in questa tabella sono partizionati per valore della colonna Division.

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Punto finale: /api/v1/{division}/purchaseorder/PurchaseReturnLines?$select=CreateCredit,Created,Creator,CreatorFullName,Division,EntryID,GoodsReceiptLineID,ID,Item,ItemCode,ItemDescription,LineNumber,Location,LocationCode,LocationDescription,Modified,Modifier,ModifierFullName,Notes,PurchaseOrderLineID,PurchaseOrderNumber,ReceiptNumber,ReceivedQuantity,ReturnQuantity,ReturnReasonCodeDescription,ReturnReasonCodeID,SupplierItemCode,UnitCode,BatchNumbers&$expand=BatchNumbers

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 5
Righe di scansione completa al minuto 7,200
Numero di righe di Query al minuto 300
Scrittura di righe al minuto 300

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella PurchaseReturnLineBatchNumbers. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
BnrBatchNumber varchar2 Numero del lotto writable, BatchNumber
BnrBatchNumberID guid ID numero di lotto writable, BatchNumberID
BnrCreated datetime Created writable, Created
BnrCreator guid Creator writable, Creator
BnrCreatorFullName varchar2 Nome completo dell'autore writable, CreatorFullName
BnrDivision int32 Division writable, Division
BnrDraftStockTransactionID guid itgen_eol_bnrdraftstocktransactionid writable, DraftStockTransactionID
BnrEndDate datetime Data di fine writable, EndDate
BnrID guid ID numero di lotto writable, ID
BnrIsBlocked int16 È bloccato writable, IsBlocked
BnrIsDraft int16 È una bozza writable, IsDraft
BnrItem guid Item writable, Item
BnrItemCode varchar2 Codice articolo writable, ItemCode
BnrItemDescription varchar2 Descrizione dell'articolo writable, ItemDescription
BnrModified datetime Modified writable, Modified
BnrModifier guid Modifier writable, Modifier
BnrModifierFullName varchar2 Nome completo modificato writable, ModifierFullName
BnrQuantity double Quantity writable, Quantity
BnrRemarks varchar2 Remarks writable, Remarks
BnrStockCountLine guid Linea di conteggio delle scorte writable, StockCountLine
BnrStockTransactionID guid itgen_eol_bnrstocktransactionid writable, StockTransactionID
BnrStockTransactionType int32 itgen_eol_bnrstocktransactiontype writable, StockTransactionType
BnrStorageLocation guid Luogo di archiviazione writable, StorageLocation
BnrStorageLocationCode varchar2 itgen_eol_bnrstoragelocationcode writable, StorageLocationCode
BnrWarehouse guid Warehouse writable, Warehouse
BnrWarehouseCode varchar2 Codice del magazzino writable, WarehouseCode
CreateCredit char itgen_eol_createcredit filters on the platform, writable, ::ancestor.::ancestor.CreateCredit
Created datetime Created filters on the platform, writable, ::ancestor.::ancestor.Created
Creator guid Creator filters on the platform, writable, ::ancestor.::ancestor.Creator
CreatorFullName varchar2 Nome completo del creatore filters on the platform, writable, ::ancestor.::ancestor.CreatorFullName
Division int32 Division filters on the platform, writable, ::ancestor.::ancestor.Division
EntryID guid ID di ingresso filters on the platform, writable, ::ancestor.::ancestor.EntryID
GoodsReceiptLineID guid ID riga di entrata merci filters on the platform, writable, ::ancestor.::ancestor.GoodsReceiptLineID
ID guid ID filters on the platform, writable, ::ancestor.::ancestor.ID
Item guid Item filters on the platform, writable, ::ancestor.::ancestor.Item
ItemCode varchar2 Codice articolo filters on the platform, writable, ::ancestor.::ancestor.ItemCode
ItemDescription varchar2 Descrizione dell'articolo filters on the platform, writable, ::ancestor.::ancestor.ItemDescription
LineNumber int32 Numero della linea filters on the platform, writable, ::ancestor.::ancestor.LineNumber
Location guid Location filters on the platform, writable, ::ancestor.::ancestor.Location
LocationCode varchar2 Codice località filters on the platform, writable, ::ancestor.::ancestor.LocationCode
LocationDescription varchar2 Descrizione della posizione 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 Nome completo modificato filters on the platform, writable, ::ancestor.::ancestor.ModifierFullName
Notes varchar2 Notes filters on the platform, writable, ::ancestor.::ancestor.Notes
PurchaseOrderLineID guid ID riga dell'ordine di acquisto filters on the platform, writable, ::ancestor.::ancestor.PurchaseOrderLineID
PurchaseOrderNumber int32 Numero dell'ordine di acquisto filters on the platform, writable, ::ancestor.::ancestor.PurchaseOrderNumber
ReceiptNumber int32 Numero di ricevuta filters on the platform, writable, ::ancestor.::ancestor.ReceiptNumber
ReceivedQuantity double Quantità ricevuta filters on the platform, writable, ::ancestor.::ancestor.ReceivedQuantity
ReturnQuantity double Quantità da restituire filters on the platform, writable, ::ancestor.::ancestor.ReturnQuantity
ReturnReasonCodeDescription varchar2 itgen_eol_returnreasoncodedescription filters on the platform, writable, ::ancestor.::ancestor.ReturnReasonCodeDescription
ReturnReasonCodeID guid ID codice motivo del reso filters on the platform, writable, ::ancestor.::ancestor.ReturnReasonCodeID
SupplierItemCode varchar2 Codice articolo del fornitore filters on the platform, writable, ::ancestor.::ancestor.SupplierItemCode
UnitCode varchar2 Codice dell'unità filters on the platform, writable, ::ancestor.::ancestor.UnitCode

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: