biuan SAP® BUSINESS ONE SDK
API AMR2
AMR2 - Inventory Revaluation FIFO Rows (Archive) Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11MRV1
Inventory Revaluation Information Array
PRIMARYYes
BaseLineBase Row NumberInt
11
LineNumRow NumberInt
11
QuantityQuantityNum
20
PricePriceNum
20
LineTotalRow TotalNum
20
RToStockReval. Amount Posted to StockNum
20
RActPriceInventory Reval. Current CostNum
20
INMTransNmINM Transaction NumberInt
11OINM
INMInstINM InstanceInt
11OINM
INMTransTyINM Transaction TypeInt
11OINM
-1
INMCreatByINM Document Key CreatedInt
11OINM
INMBaseRefINM Base ReferencenVarChar
11OINM
INMDocDateINM Posting DateDate
8OINM
INMOpenQtyINM Open QuantityNum
20OINM
ObjTypeObject TypenVarChar
20
162
LogInstancLog InstanceInt
11
0
IVLTransSeIVL Transaction Sequence No.Int
11
-1
IVLLayerIDIVL Layer IDInt
11
-1
INMLineNumINM Row Number in DocumentInt
11OINM
INMSubLineINM Subrow NumberInt
11OINM

SELECT statement

SELECT AMR2.DocEntry AS 'Document Internal ID', AMR2.BaseLine AS 'Base Row Number', AMR2.LineNum AS 'Row Number', AMR2.Quantity AS 'Quantity', AMR2.Price AS 'Price', AMR2.LineTotal AS 'Row Total', AMR2.RToStock AS 'Reval. Amount Posted to Stock', AMR2.RActPrice AS 'Inventory Reval. Current Cost', AMR2.INMTransNm AS 'INM Transaction Number', AMR2.INMInst AS 'INM Instance', AMR2.INMTransTy AS 'INM Transaction Type', AMR2.INMCreatBy AS 'INM Document Key Created', AMR2.INMBaseRef AS 'INM Base Reference', AMR2.INMDocDate AS 'INM Posting Date', AMR2.INMOpenQty AS 'INM Open Quantity', AMR2.ObjType AS 'Object Type', AMR2.LogInstanc AS 'Log Instance', AMR2.IVLTransSe AS 'IVL Transaction Sequence No.', AMR2.IVLLayerID AS 'IVL Layer ID', AMR2.INMLineNum AS 'INM Row Number in Document', AMR2.INMSubLine AS 'INM Subrow Number' FROM AMR2 AS AMR2

Related information


Inventory Revaluation Information Array MRV1 SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates