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

SQL Sales Opportunities / Distribution Rule - Rows

API Distribution Rule Lines / Distribution Rule Line

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
OcrCode ^KEY ^UNIQUE	Factor Code	nVarChar		8	OOCR Distribution Rule		PRIMARY	Yes
PrcCode ^KEY	Center Code	nVarChar		8	OPRC Cost Center		PROF_ID	No
PrcAmount	Total in Center	Num		20
OcrTotal	Total Factor	Num		20
Direct	Direct	VarChar	Y) Yes N) No	1		N
UserSign	User Signature	Int		6	OUSR Users
ValidFrom	Effective From	Date		8		19000101
ValidTo	Effective To	Date		8
logInstanc	Log Instance	Int		11
UserSign2	Updating User	Int		6	OUSR Users
updateDate	Date of Update	Date		8

Table relationship map

SELECT statement

SELECT
   OCR1.OcrCode AS 'Factor Code', 
   OCR1.PrcCode AS 'Center Code', 
   OCR1.PrcAmount AS 'Total in Center', 
   OCR1.OcrTotal AS 'Total Factor', 
   OCR1.Direct AS 'Direct', 
   OCR1.UserSign AS 'User Signature', 
   OCR1.ValidFrom AS 'Effective From', 
   OCR1.ValidTo AS 'Effective To', 
   OCR1.logInstanc AS 'Log Instance', 
   OCR1.UserSign2 AS 'Updating User', 
   OCR1.updateDate AS 'Date of Update'
FROM OCR1 AS OCR1

Related information

DistributionRuleLine Object· Table: OCR1

Specifies a profit center to which to assign part of any cost or expense that is tied to a distribution rule. Source table: OCR1 All properties are mandatory.

Parent: Distribution Rule Lines DistributionRuleLines Collection
OOCR SQL Table

OPRC SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Collection
DistributionRuleLines

Object
DistributionRuleLine

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

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