biuan SAP® BUSINESS ONE SDK
DTW Opportunity - Interests
API Sales Opportunities / Sales Opportunities Interests
OPR4 - Opportunity - Interests Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OprId KEY UNIQUESequence No.Int
11
PRIMARYYes
LineRow No.Int
6
IntIdInterest IDInt
11OOIN
Interest
PrmryPrimary InterestVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT OPR4.OprId AS 'Sequence No.', OPR4.Line AS 'Row No.', OPR4.IntId AS 'Interest ID', OPR4.Prmry AS 'Primary Interest' FROM OPR4 AS OPR4

Related information


Sales Opportunities Interests SalesOpportunitiesInterests Object· Table: OPR4
SalesOpportunitiesInterests is a child object of the SalesOpportunities object and represents the interests range of sales opportunity. Source table: OPR4.
   Parent: Sales Opportunities SalesOpportunities Object· Table: OOPR
Interest OOIN 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