biuan SAP® BUSINESS ONE SDK
API OSCM
OSCM - Special Ledger - Analytical Accounting Configuration Rules: Material Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RuleID KEY UNIQUERule Identification NumberInt
6
PRIMARYYes
RuleTypeRule Type NumberInt
6
2
ParentIDParent Rule IDInt
6OSCM
Special Ledger - Analytical Accounting Configuration Rules: Material
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 OSCM.RuleID AS 'Rule Identification Number', OSCM.RuleType AS 'Rule Type Number', OSCM.ParentID AS 'Parent Rule ID', OSCM.Status AS 'Rule Status', OSCM.Priority AS 'Rule Priority', OSCM.Name AS 'Rule Name', OSCM.CreateDate AS 'Date of Rule Generation', OSCM.UpdateDate AS 'Date of Rule Change', OSCM.UserSign AS 'Rule Created By', OSCM.UserSign2 AS 'Rule Changed By', OSCM.ExtCond AS 'Extended Special Data' FROM OSCM AS OSCM

Related information


Special Ledger - Analytical Accounting Configuration Rules: Material OSCM 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