biuan SAP® BUSINESS ONE SDK
API Distribution Rule Lines / Distribution Rule Line
OCR1 - Distribution Rule - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OcrCode KEY UNIQUEFactor CodenVarChar
8OOCR
Distribution Rule
PRIMARYYes
PrcCode KEYCenter CodenVarChar
8OPRC
Cost Center
PROF_IDNo
PrcAmountTotal in CenterNum
20
OcrTotalTotal FactorNum
20
DirectDirectVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
ValidFromEffective FromDate
8
19000101
ValidToEffective ToDate
8
logInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
updateDateDate of UpdateDate
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


Distribution Rule Line 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
Distribution Rule OOCR SQL Table

Cost Center OPRC 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