biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Interest / Interest
DTW Interest
API Sales Opportunity Interests Setup Service / Sales Opportunity Interest Setup
OOIN - Interest 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 OOIN.Num AS 'Sequence No.', OOIN.Descript AS 'Description', OOIN.SortOrder AS 'Sort', OOIN.UserSign AS 'User Signature' FROM OOIN AS OOIN

Related information


Sales Opportunity Interest Setup SalesOpportunityInterestSetup Object· Table: OOIN
Represents an area of interest for the sales opportunity. Source table: OOIN Mandatory properties: Description
   Parent: Sales Opportunity Interests Setup Service SalesOpportunityInterestsSetupService Service· Table: OOIN

Sales Opportunity Interests Setup Service SalesOpportunityInterestsSetupService Service· Table: OOIN
The SalesOpportunityInterestsSetupService service enables you to add, look up and remove interests in the interests master data table. Interests can be assigned to sales opportunities; the interest describes an area of interest to the sales...

OOIN 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