biuan SAP® BUSINESS ONE SDK
API OFRC
OFRC - Financial Report Categories Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CatIdNumeratorInt
6
TemplateId KEY UNIQUETemplateInt
11OFRT
Financial Report Templates
PRIMARYYes
NameNamenVarChar
127
FrgnNameForeign NamenVarChar
127
LevelsAccount LevelInt
1) Level 1
2) Level 2
3) Level 3
6
1
FatherNumParent Account KeyInt
6
ActiveActive AccountVarChar
Y) Yes
N) No
1
N
HasSonsIncluding ChildrenVarChar
Y) Yes
N) No
1
N
VisOrderDisplay OrderInt
6
SubSumSubtotalVarChar
Y) Yes
N) No
1
N
SubNameSubtotal NamenVarChar
100
FurmulaFormulaVarChar
Y) Yes
N) No
1
N
Param_1Parameter 1Int
6
0
Param_2Parameter 2Int
6
0
Param_3Parameter 3Int
6
0
Param_4Parameter 4Int
6
0
Param_5Parameter 5Int
6
0
Param_6Parameter 6Int
6
0
Param_7Parameter 7Int
6
0
Param_8Parameter 8Int
6
0
Param_9Parameter 9Int
6
0
Param_10Parameter 10Int
6
0
Param_11Parameter 11Int
6
0
Param_12Parameter 12Int
6
0
Param_13Parameter 13Int
6
0
Param_14Parameter 14Int
6
0
Param_15Parameter 15Int
6
0
Param_16Parameter 16Int
6
0
Param_17Parameter 17Int
6
0
Param_18Parameter 18Int
6
0
Param_19Parameter 19Int
6
0
Param_20Parameter 20Int
6
0
Param_21Parameter 21Int
6
0
Param_22Parameter 22Int
6
0
Param_23Parameter 23Int
6
0
Param_24Parameter 24Int
6
0
Param_25Parameter 25Int
6
0
OP_1Operator 1VarChar
1
OP_2Operator 2VarChar
1
OP_3Operator 3VarChar
1
OP_4Operator 4VarChar
1
OP_5Operator 5VarChar
1
OP_6Operator 6VarChar
1
OP_7Operator 7VarChar
1
OP_8Operator 8VarChar
1
OP_9Operator 9VarChar
1
OP_10Operator 10VarChar
1
OP_11Operator 11VarChar
1
OP_12Operator 12VarChar
1
OP_13Operator 13VarChar
1
OP_14Operator 14VarChar
1
OP_15Operator 15VarChar
1
OP_16Operator 16VarChar
1
OP_17Operator 17VarChar
1
OP_18Operator 18VarChar
1
OP_19Operator 19VarChar
1
OP_20Operator 20VarChar
1
OP_21Operator 21VarChar
1
OP_22Operator 22VarChar
1
OP_23Operator 23VarChar
1
OP_24Operator 24VarChar
1
ProfitLossProfit and LossVarChar
Y) Yes
N) No
1
N
MoveNegMove if NegativeVarChar
Y) Yes
N) No
1
N
DummyDummy TitleVarChar
Y) Yes
N) No
1
N
HideActHide AccountsVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
ToGroupMove to GroupInt
6
0
ToTitleMove to TitleInt
6
0
LineNumLine NumbernVarChar
6
IndentCharIndent Char.nVarChar
6
ReversalReversal SignVarChar
N) No
Y) Yes
1
N
TextTitleText TitleVarChar
N) No
Y) Yes
1
N
SumTypeGross/Correction/NetVarChar
B) Gross
C) Correction
N) Net
1
N
NetIncomeNet IncomeVarChar
N) No
Y) Yes
1
N
PLTempIdProfit & Loss Report TemplateInt
11
CustNameCustomized Account NameVarChar
Y) Yes
N) No
1
N
ExtFromBSRelevant for Bal. Sht ExtractVarChar
Y) Yes
N) No
1
N
ExtDataExtended DataVarChar
A) Relevant for Asset History Sheet
L) Relevant for Liabilities History Sheet
N) Not Relevant
1
N
LegalRefLegal ReferencenVarChar
127
PLCatIdProfit & Loss Report CategoryInt
6
0
SignAggrSign for AggregationVarChar
E)
P) Positive
N) Negative
1
E
MandatoryMandatoryVarChar
Y) Yes
N) No
1
N
AcctReqAccount Verification RequiredVarChar
Y) Yes
N) No
1
N
NotPermitNot Permitted for TaxVarChar
Y) Yes
N) No
1
N
KPIFactorKPI Factor No.nVarChar
3OKPF
KPI Factor
CatCodeCategory CodenVarChar
15
CatClassCategory ClassificationVarChar
1

Table relationship map

SELECT statement

SELECT OFRC.CatId AS 'Numerator', OFRC.TemplateId AS 'Template', OFRC.Name AS 'Name', OFRC.FrgnName AS 'Foreign Name', OFRC.Levels AS 'Account Level', OFRC.FatherNum AS 'Parent Account Key', OFRC.Active AS 'Active Account', OFRC.HasSons AS 'Including Children', OFRC.VisOrder AS 'Display Order', OFRC.SubSum AS 'Subtotal', OFRC.SubName AS 'Subtotal Name', OFRC.Furmula AS 'Formula', OFRC.Param_1 AS 'Parameter 1', OFRC.Param_2 AS 'Parameter 2', OFRC.Param_3 AS 'Parameter 3', OFRC.Param_4 AS 'Parameter 4', OFRC.Param_5 AS 'Parameter 5', OFRC.Param_6 AS 'Parameter 6', OFRC.Param_7 AS 'Parameter 7', OFRC.Param_8 AS 'Parameter 8', OFRC.Param_9 AS 'Parameter 9', OFRC.Param_10 AS 'Parameter 10', OFRC.Param_11 AS 'Parameter 11', OFRC.Param_12 AS 'Parameter 12', OFRC.Param_13 AS 'Parameter 13', OFRC.Param_14 AS 'Parameter 14', OFRC.Param_15 AS 'Parameter 15', OFRC.Param_16 AS 'Parameter 16', OFRC.Param_17 AS 'Parameter 17', OFRC.Param_18 AS 'Parameter 18', OFRC.Param_19 AS 'Parameter 19', OFRC.Param_20 AS 'Parameter 20', OFRC.Param_21 AS 'Parameter 21', OFRC.Param_22 AS 'Parameter 22', OFRC.Param_23 AS 'Parameter 23', OFRC.Param_24 AS 'Parameter 24', OFRC.Param_25 AS 'Parameter 25', OFRC.OP_1 AS 'Operator 1', OFRC.OP_2 AS 'Operator 2', OFRC.OP_3 AS 'Operator 3', OFRC.OP_4 AS 'Operator 4', OFRC.OP_5 AS 'Operator 5', OFRC.OP_6 AS 'Operator 6', OFRC.OP_7 AS 'Operator 7', OFRC.OP_8 AS 'Operator 8', OFRC.OP_9 AS 'Operator 9', OFRC.OP_10 AS 'Operator 10', OFRC.OP_11 AS 'Operator 11', OFRC.OP_12 AS 'Operator 12', OFRC.OP_13 AS 'Operator 13', OFRC.OP_14 AS 'Operator 14', OFRC.OP_15 AS 'Operator 15', OFRC.OP_16 AS 'Operator 16', OFRC.OP_17 AS 'Operator 17', OFRC.OP_18 AS 'Operator 18', OFRC.OP_19 AS 'Operator 19', OFRC.OP_20 AS 'Operator 20', OFRC.OP_21 AS 'Operator 21', OFRC.OP_22 AS 'Operator 22', OFRC.OP_23 AS 'Operator 23', OFRC.OP_24 AS 'Operator 24', OFRC.ProfitLoss AS 'Profit and Loss', OFRC.MoveNeg AS 'Move if Negative', OFRC.Dummy AS 'Dummy Title', OFRC.HideAct AS 'Hide Accounts', OFRC.UserSign AS 'User Signature', OFRC.ToGroup AS 'Move to Group', OFRC.ToTitle AS 'Move to Title', OFRC.LineNum AS 'Line Number', OFRC.IndentChar AS 'Indent Char.', OFRC.Reversal AS 'Reversal Sign', OFRC.TextTitle AS 'Text Title', OFRC.SumType AS 'Gross/Correction/Net', OFRC.NetIncome AS 'Net Income', OFRC.PLTempId AS 'Profit & Loss Report Template', OFRC.CustName AS 'Customized Account Name', OFRC.ExtFromBS AS 'Relevant for Bal. Sht Extract', OFRC.ExtData AS 'Extended Data', OFRC.LegalRef AS 'Legal Reference', OFRC.PLCatId AS 'Profit & Loss Report Category', OFRC.SignAggr AS 'Sign for Aggregation', OFRC.Mandatory AS 'Mandatory', OFRC.AcctReq AS 'Account Verification Required', OFRC.NotPermit AS 'Not Permitted for Tax', OFRC.KPIFactor AS 'KPI Factor No.', OFRC.CatCode AS 'Category Code', OFRC.CatClass AS 'Category Classification' FROM OFRC AS OFRC

Related information


KPI Factor OKPF SQL Table

Financial Report Templates OFRT 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