biuan SAP® BUSINESS ONE SDK
API LIVI1
LIVI1 - IVI Log Array File Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LogEntry KEY UNIQUEInternal NumberInt
11LIVI
IVI Log File
PRIMARYYes
CalcNumPartial Sequence NumberInt
11
CreateDateCreate DateDate
8
UserToDateUser To DateDate
8
ActuToDateActual To DateDate
8
LastMsgIDLast Calculated OILM MessageInt
11
ResultResult of CalculationVarChar
F) Failure
S) Success
A) Archived
1
F
ResultStrResult String of CalculationnVarChar
127
UserSignUser SignatureInt
6OUSR
Users
IgnFailIgnore Previous FailureVarChar
Y) Yes
N) No
1
N
ReorderFrmReorder 8.8 Messages: From DateDate
8
ReorderToReorder 8.8 Messages: To DateDate
8
StopDateStop DateDate
8
StopTimeStop TimeInt
6

Table relationship map

SELECT statement

SELECT LIVI1.LogEntry AS 'Internal Number', LIVI1.CalcNum AS 'Partial Sequence Number', LIVI1.CreateDate AS 'Create Date', LIVI1.UserToDate AS 'User To Date', LIVI1.ActuToDate AS 'Actual To Date', LIVI1.LastMsgID AS 'Last Calculated OILM Message', LIVI1.Result AS 'Result of Calculation', LIVI1.ResultStr AS 'Result String of Calculation', LIVI1.UserSign AS 'User Signature', LIVI1.IgnFail AS 'Ignore Previous Failure', LIVI1.ReorderFrm AS 'Reorder 8.8 Messages: From Date', LIVI1.ReorderTo AS 'Reorder 8.8 Messages: To Date', LIVI1.StopDate AS 'Stop Date', LIVI1.StopTime AS 'Stop Time' FROM LIVI1 AS LIVI1

Related information


IVI Log File LIVI 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