biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / IVI Config File
API CIVI
CIVI - IVI Config File Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
EnableRunEnable RunVarChar
Y) Yes
N) No
1
N
EnblRunDtEnable Run DateDate
8
MsgSourceObject ID of Message SourceInt
11
IsOILMUpdIs OILM UpdatedVarChar
N) No
Y) Yes
1
N
EnblDaysEnable Valid In DaysInt
11
30
LstChkMsgLast Checked OILM MessageInt
11
LstMsgDateLast Build Message DateDate
8
LstHndlMsgLast Handled OILM MessageInt
11
EnableUpdEnable UpdateVarChar
Y) Yes
N) No
1
Y
IgnPreUpdIgnore Previous UpdateVarChar
Y) Yes
N) No
1
N
ForceRSPForce RSP PrecheckVarChar
Y) Yes
N) No
1
N
ReorderFrmReorder 8.8 Messages: From DateDate
8
ReorderToReorder 8.8 Messages: To DateDate
8
InitMapInitialize MAP ItemsVarChar
1
InitStdInitialize STD ItemsVarChar
1

SELECT statement

SELECT CIVI.AbsEntry AS 'Internal Number', CIVI.EnableRun AS 'Enable Run', CIVI.EnblRunDt AS 'Enable Run Date', CIVI.MsgSource AS 'Object ID of Message Source', CIVI.IsOILMUpd AS 'Is OILM Updated', CIVI.EnblDays AS 'Enable Valid In Days', CIVI.LstChkMsg AS 'Last Checked OILM Message', CIVI.LstMsgDate AS 'Last Build Message Date', CIVI.LstHndlMsg AS 'Last Handled OILM Message', CIVI.EnableUpd AS 'Enable Update', CIVI.IgnPreUpd AS 'Ignore Previous Update', CIVI.ForceRSP AS 'Force RSP Precheck', CIVI.ReorderFrm AS 'Reorder 8.8 Messages: From Date', CIVI.ReorderTo AS 'Reorder 8.8 Messages: To Date', CIVI.InitMap AS 'Initialize MAP Items', CIVI.InitStd AS 'Initialize STD Items' FROM CIVI AS CIVI

Related information
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