biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Partners / Partners
DTW Partners
API Partners Setups Service / Partners Setup
OPRT - Partners Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PrtId KEY UNIQUESequence No.Int
11
PRIMARYYes
NameNamenVarChar
15
RelatnTypeRelationship TypenVarChar
20
RelatCardRelated BPnVarChar
15OCRD
Business Partner
MemoDetailsnVarChar
50
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
DefaultORLDefault RelationshipInt
11

Table relationship map

SELECT statement

SELECT OPRT.PrtId AS 'Sequence No.', OPRT.Name AS 'Name', OPRT.RelatnType AS 'Relationship Type', OPRT.RelatCard AS 'Related BP', OPRT.Memo AS 'Details', OPRT.DataSource AS 'Data Source', OPRT.UserSign AS 'User Signature', OPRT.DefaultORL AS 'Default Relationship' FROM OPRT AS OPRT

Related information


Partners Setup PartnersSetup Object· Table: OPRT
Define partners for sales opportunities. Source table: OPRT.
   Parent: Partners Setups Service PartnersSetupsService Service· Table: OPRT

Partners Setups Service PartnersSetupsService Service· Table: OPRT
The PartnersSetupsService service enables you to add, look up, update, and remove partners. Source table: OPRT.

OPRT SQL Table

Business Partner OCRD 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