biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Validation of Recalc. From To
API VLG1
VLG1 - Validation of Recalc. From To Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal Unique KeyInt
11IVLG
Inventory Revaluation Log File		PRIMARYYes
RecNumRecord NumberInt
11
FromSysDatFrom System DateDate
8
FromDocNumFrom Document NumberInt
11OINM
FromDocTypFrom Document TypeInt
6
ToSysDateTo System DateDate
8
ToDocNumTo Document NumberInt
11OINM
ToDocTypeTo Document TypeInt
6
CalRecOINMCalculated Record in OINMInt
11
LastCalcTSLast Calculated Trans. Seq.Int
11
SumTranValSum of Transaction ValueNum
20
StrFldGeneral String FieldnVarChar
50
NumFldGeneral Number FieldInt
11

SELECT statement

SELECT VLG1.AbsEntry AS 'Internal Unique Key', VLG1.RecNum AS 'Record Number', VLG1.FromSysDat AS 'From System Date', VLG1.FromDocNum AS 'From Document Number', VLG1.FromDocTyp AS 'From Document Type', VLG1.ToSysDate AS 'To System Date', VLG1.ToDocNum AS 'To Document Number', VLG1.ToDocType AS 'To Document Type', VLG1.CalRecOINM AS 'Calculated Record in OINM', VLG1.LastCalcTS AS 'Last Calculated Trans. Seq.', VLG1.SumTranVal AS 'Sum of Transaction Value', VLG1.StrFld AS 'General String Field', VLG1.NumFld AS 'General Number Field' FROM VLG1 AS VLG1

Related information


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