biuan SAP® BUSINESS ONE SDK
API OSCR
OSCR - Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RuleID KEY UNIQUERule Identification NumberInt
6
PRIMARYYes
RuleTypeRule Type NumberInt
6
1
ParentIDParent Rule IDInt
6OSCR
Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses
StatusRule StatusVarChar
1
PriorityRule PriorityInt
6
100
NameRule NamenVarChar
100
CreateDateDate of Rule GenerationDate
8
UpdateDateDate of Rule ChangeDate
8
UserSignRule Created ByInt
6OUSR
Users
UserSign2Rule Changed ByInt
6OUSR
Users
ExtCondExtended Special DatanVarChar
127

Table relationship map

SELECT statement

SELECT OSCR.RuleID AS 'Rule Identification Number', OSCR.RuleType AS 'Rule Type Number', OSCR.ParentID AS 'Parent Rule ID', OSCR.Status AS 'Rule Status', OSCR.Priority AS 'Rule Priority', OSCR.Name AS 'Rule Name', OSCR.CreateDate AS 'Date of Rule Generation', OSCR.UpdateDate AS 'Date of Rule Change', OSCR.UserSign AS 'Rule Created By', OSCR.UserSign2 AS 'Rule Changed By', OSCR.ExtCond AS 'Extended Special Data' FROM OSCR AS OSCR

Related information


Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses OSCR 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