biuan SAP® BUSINESS ONE SDK
SQL Sales Opportunities / Opportunity / Interest Level
DTW Interest Level
API Sales Opportunities / Interest Level
OOIR - Interest Level Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Num KEY UNIQUESequence No.Int
11
PRIMARYYes
DescriptDescriptionnVarChar
30
SortOrderSortInt
6
100
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OOIR.Num AS 'Sequence No.', OOIR.Descript AS 'Description', OOIR.SortOrder AS 'Sort', OOIR.UserSign AS 'User Signature' FROM OOIR AS OOIR

Related information


Interest Level InterestLevel Property· Table: OOIR
Sets or returns the interest level (for example: warm, cold, general interest, and so on) for the sales opportunity. Field name: IntRate. This is a foreign key to the Interest table (OOIR), not exposed through the DI API.
   Parent: Sales Opportunities SalesOpportunities Object· Table: OOPR
OOIR 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