biuan SAP® BUSINESS ONE SDK
SQL Administration / Administration / Internal Recon. Upgrade 2007A
DTW Administration / Setup / Banking / Credit Cards / Internal Recon. Upgrade 2007A
API Admin Info / Budget Alert
CASE - Internal Recon. Upgrade 2007A Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEIntl ID for Inconsistent AmtInt
11
PRIMARYYes
CreateDateCreation DateDate
8
CreateTimeCreation TimeInt
6
UserSignUser SignatureInt
6OUSR
Users
MessageShow Message?VarChar
Y)
N)
S)
1
N

Table relationship map

SELECT statement

SELECT CASE.AbsEntry AS 'Intl ID for Inconsistent Amt', CASE.CreateDate AS 'Creation Date', CASE.CreateTime AS 'Creation Time', CASE.UserSign AS 'User Signature', CASE.Message AS 'Show Message?' FROM CASE AS CASE

Related information


Budget Alert BudgetAlert Property· Table: CASE
Determines the alert type in case of deviation from budget. Applicable in case the valid value of CalculateBudget is tYES and the valid value of BlockBudget is either bb_Block or bb_MonthlyAlertOnly. Field name: BgtWarning.
   Parent: Admin Info AdminInfo Object· Table: OADM
CASE 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates