OORL - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Sales Opportunities /

Relationships

DTW Administration / Setup / Sales Opportunities / Relationships

API OORL / / Relationships

OORL - Relationships Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
OrlCode ^KEY ^UNIQUE	Relationship Code	Int		11			PRIMARY	Yes
OrlDesc	Relationship Description	nVarChar		100

SELECT statement

SELECT
   OORL.OrlCode AS 'Relationship Code', 
   OORL.OrlDesc AS 'Relationship Description'
FROM OORL AS OORL

Related information

Relationships Object· Table: OORL

Relationships is a business object that represents the relationships list from which a relationship definition can be associated with a partner in a sales opportunity. This object enables you to: Add a relationship to the list. Retrieve a...

OORL SQL Table

biuan SAP® BUSINESS ONE

Object
Relationships

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Property

Browser

RelationshipCode

DTW DB

RelationshipDescription

DTW DB

UserFields

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