biuan SAP® BUSINESS ONE SDK
DTW Distribution Rule
API Distribution Rules Service / Distribution Rule
OOCR - Distribution Rule Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OcrCode KEY UNIQUEFactor CodenVarChar
8
PRIMARYYes
OcrNameFactor DescriptionnVarChar
30
OcrTotalTotal FactorNum
20
DirectDirectVarChar
Y) Yes
N) No
1
N
LockedLockedVarChar
Y) Yes
N) No
1
N
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
DimCodeIn Which DimensionInt
6ODIM
Cost Accounting Dimension
1
AbsEntryNumeratorInt
11
ActiveActiveVarChar
Y) Yes
N) No
1
Y
logInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
updateDateDate of UpdateDate
8

Table relationship map

SELECT statement

SELECT OOCR.OcrCode AS 'Factor Code', OOCR.OcrName AS 'Factor Description', OOCR.OcrTotal AS 'Total Factor', OOCR.Direct AS 'Direct', OOCR.Locked AS 'Locked', OOCR.DataSource AS 'Data Source', OOCR.UserSign AS 'User Signature', OOCR.DimCode AS 'In Which Dimension', OOCR.AbsEntry AS 'Numerator', OOCR.Active AS 'Active', OOCR.logInstanc AS 'Log Instance', OOCR.UserSign2 AS 'Updating User', OOCR.updateDate AS 'Date of Update' FROM OOCR AS OOCR

Related information


Distribution Rule DistributionRule Object· Table: OOCR
Represents a distribution rule for spreading a specific expense, account, journal entry, or other entity among profit centers. Source table: OOCR Mandatory properties: FactorCode, TotalFactor
   Parent: Distribution Rules Service DistributionRulesService Service· Table: OOCR

Distribution Rules Service DistributionRulesService Service· Table: OOCR
The DistributionRulesService service enables you to add, look up and remove distribution rules for spreading a specific expense, account, journal entry, or other entity among profit centers. To see the list of distribution rules, select...

OOCR SQL Table

Cost Accounting Dimension ODIM 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