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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEYDocument NumberInt
11
NUMNo
DocDatePosting DateDate
8
Ref1Reference 1nVarChar
11
Ref2Reference 2nVarChar
11
CommentsRemarksnVarChar
127
JrnlMemoJournal RemarksnVarChar
50
TransIdTransaction NumberInt
11OJDT
Journal Entry
DocTimeGeneration TimeInt
6
RevalTypeInventory Revaluation TypeVarChar
P) Price Change
M) Material Debit/Credit
1
P
UpdateDateUpdate DateDate
8
CreateDateCreation DateDate
8
Series KEYSeriesInt
6NNM1
Documents Numbering - Series
0SERIESNo
TaxDateDocument DateDate
8
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto. Incr.
D) Data Document
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
StationIDWorkstation IDInt
11CSTN
Workstation ID
RIncmAcctInvent. Reval. Expense AccountnVarChar
15
RExpnAcctInvent. Reval. Expense AccountnVarChar
15
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20
162
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
VersionNumVersion NumbernVarChar
11
InflaRevalInflation-Based RevaluationVarChar
1
N
SupplCodeSupplementary CodenVarChar
127
CardCodeCustomer/Vendor CodenVarChar
15
CardNameCustomer/Vendor NamenVarChar
100
CreatedByEntry Creation OriginVarChar
M) Created Manually by User
W) Created by Product Cost Recalculation Wizard
1
M

Table relationship map

SELECT statement

SELECT AMRV.DocEntry AS 'Internal Number', AMRV.DocNum AS 'Document Number', AMRV.DocDate AS 'Posting Date', AMRV.Ref1 AS 'Reference 1', AMRV.Ref2 AS 'Reference 2', AMRV.Comments AS 'Remarks', AMRV.JrnlMemo AS 'Journal Remarks', AMRV.TransId AS 'Transaction Number', AMRV.DocTime AS 'Generation Time', AMRV.RevalType AS 'Inventory Revaluation Type', AMRV.UpdateDate AS 'Update Date', AMRV.CreateDate AS 'Creation Date', AMRV.Series AS 'Series', AMRV.TaxDate AS 'Document Date', AMRV.DataSource AS 'Data Source', AMRV.UserSign AS 'User Signature', AMRV.UserSign2 AS 'Updating User', AMRV.StationID AS 'Workstation ID', AMRV.RIncmAcct AS 'Invent. Reval. Expense Account', AMRV.RExpnAcct AS 'Invent. Reval. Expense Account', AMRV.LogInstanc AS 'Log Instance', AMRV.ObjType AS 'Object Type', AMRV.SeqCode AS 'Sequence Code', AMRV.Serial AS 'Serial Number', AMRV.SeriesStr AS 'Series String', AMRV.SubStr AS 'Subseries String', AMRV.VersionNum AS 'Version Number', AMRV.InflaReval AS 'Inflation-Based Revaluation', AMRV.SupplCode AS 'Supplementary Code', AMRV.CardCode AS 'Customer/Vendor Code', AMRV.CardName AS 'Customer/Vendor Name', AMRV.CreatedBy AS 'Entry Creation Origin' FROM AMRV AS AMRV

Related information


Documents Numbering - Series NNM1 SQL Table

Workstation ID CSTN SQL Table

Journal Entry OJDT SQL Table

Users OUSR 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