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

DTW Administration / Setup / Business Partners / Business Partner Groups

API OCRG / / Business Partner Groups

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
GroupCode ^KEY ^UNIQUE	Group No.	Int		6			PRIMARY	Yes
GroupName ^KEY ^UNIQUE	Group Name	nVarChar		20			GROUP_NAME	Yes
GroupType ^KEY	Group Type	VarChar	C) Customer Group S) Vendor Group	1		C	GROUP_TYPE	No
Locked	Locked	VarChar	Y) Yes N) No	1		N
DataSource	Data Source	VarChar	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
UserSign	User Signature	Int		6	OUSR Users
PriceList	Price List	Int		6	OPLN Price Lists
DiscRel	Effective Discount	VarChar	L) Lowest Discount H) Highest Discount A) Average S) Total M) Discount Multiples	1		L

Table relationship map

SELECT statement

SELECT
   OCRG.GroupCode AS 'Group No.', 
   OCRG.GroupName AS 'Group Name', 
   OCRG.GroupType AS 'Group Type', 
   OCRG.Locked AS 'Locked', 
   OCRG.DataSource AS 'Data Source', 
   OCRG.UserSign AS 'User Signature', 
   OCRG.PriceList AS 'Price List', 
   OCRG.DiscRel AS 'Effective Discount'
FROM OCRG AS OCRG

Related information

BusinessPartnerGroups Object· Table: OCRG

BusinessPartnerGroups represents the setup of customer and vendor Groups. Used for classifing business partners according to groups, such as, sector or size. Source table: OCRG.

OCRG SQL Table

OPLN SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
BusinessPartnerGroups

Enumeration

BoBusinessPartnerGroupTypes

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Property

Browser

Code

DTW DB

Name

DTW DB

Type

DTW DB

UserFields

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