biuan SAP® BUSINESS ONE SDK
API AMR1
AMR1 - Inventory Revaluation - History - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OMRV
Inventory Revaluation
PRIMARYYes
LineNumRow NumberInt
11
ItemCode KEYItem CodenVarChar
20OITM
Items
ITEMNo
DscriptionItem/Service DescriptionnVarChar
100
QuantityQuantityNum
20
PricePriceNum
20
LineTotalRow TotalNum
20
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
RIncmAcctInv. Reval. Increment AccountnVarChar
15
RDcrmAcctInv. Reval. Decrement AccountnVarChar
15
RToStockReval. Amount Posted to StockNum
20
RActPriceInv. Reval. Actual PriceNum
20
ROnHandIn Stock at Reval.Num
20
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20
162
EvalSystemCost Accounting MethodVarChar
A) Moving Average
S) Standard
F) FIFO
1OITM
Items
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
UnitMsrUnit of MeasurenVarChar
100
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
ProjectProject CodenVarChar
20OPRJ
Project Codes

Table relationship map

SELECT statement

SELECT AMR1.DocEntry AS 'Document Internal ID', AMR1.LineNum AS 'Row Number', AMR1.ItemCode AS 'Item Code', AMR1.Dscription AS 'Item/Service Description', AMR1.Quantity AS 'Quantity', AMR1.Price AS 'Price', AMR1.LineTotal AS 'Row Total', AMR1.WhsCode AS 'Warehouse Code', AMR1.RIncmAcct AS 'Inv. Reval. Increment Account', AMR1.RDcrmAcct AS 'Inv. Reval. Decrement Account', AMR1.RToStock AS 'Reval. Amount Posted to Stock', AMR1.RActPrice AS 'Inv. Reval. Actual Price', AMR1.ROnHand AS 'In Stock at Reval.', AMR1.LogInstanc AS 'Log Instance', AMR1.ObjType AS 'Object Type', AMR1.EvalSystem AS 'Cost Accounting Method', AMR1.OcrCode AS 'Distribution Rule', AMR1.UnitMsr AS 'Unit of Measure', AMR1.OcrCode2 AS 'Distribution Rule2', AMR1.OcrCode3 AS 'Distribution Rule3', AMR1.OcrCode4 AS 'Distribution Rule4', AMR1.OcrCode5 AS 'Distribution Rule5', AMR1.Project AS 'Project Code' FROM AMR1 AS AMR1

Related information


Inventory Revaluation OMRV SQL Table

Items OITM SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Warehouses OWHS 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