📚 SAP Business One SDK Help

Table Name: OFRC

Table Description: Financial Report Categories

Field Description Type Size Related Default Value Constraints
CatId Numerator Int 6 -      
TemplateId Template Int 11 OFRT      
Name Name nVarChar 254 -      
FrgnName Foreign Name nVarChar 254 -      
Levels Account Level Int 6 - 1 1 Level 1
            2 Level 2
            3 Level 3
FatherNum Parent Account Key Int 6 -      
Active Active Account VarChar 1 - N Y Yes
            N No
HasSons Including Children VarChar 1 - N Y Yes
            N No
VisOrder Display Order Int 6 -      
SubSum Subtotal VarChar 1 - N Y Yes
            N No
SubName Subtotal Name nVarChar 100 -      
Furmula Formula VarChar 1 - N Y Yes
            N No
Param_1 Parameter 1 Int 6 - 0    
Param_2 Parameter 2 Int 6 - 0    
Param_3 Parameter 3 Int 6 - 0    
Param_4 Parameter 4 Int 6 - 0    
Param_5 Parameter 5 Int 6 - 0    
Param_6 Parameter 6 Int 6 - 0    
Param_7 Parameter 7 Int 6 - 0    
Param_8 Parameter 8 Int 6 - 0    
Param_9 Parameter 9 Int 6 - 0    
Param_10 Parameter 10 Int 6 - 0    
Param_11 Parameter 11 Int 6 - 0    
Param_12 Parameter 12 Int 6 - 0    
Param_13 Parameter 13 Int 6 - 0    
Param_14 Parameter 14 Int 6 - 0    
Param_15 Parameter 15 Int 6 - 0    
Param_16 Parameter 16 Int 6 - 0    
Param_17 Parameter 17 Int 6 - 0    
Param_18 Parameter 18 Int 6 - 0    
Param_19 Parameter 19 Int 6 - 0    
Param_20 Parameter 20 Int 6 - 0    
Param_21 Parameter 21 Int 6 - 0    
Param_22 Parameter 22 Int 6 - 0    
Param_23 Parameter 23 Int 6 - 0    
Param_24 Parameter 24 Int 6 - 0    
Param_25 Parameter 25 Int 6 - 0    
OP_1 Operator 1 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_2 Operator 2 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_3 Operator 3 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_4 Operator 4 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_5 Operator 5 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_6 Operator 6 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_7 Operator 7 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_8 Operator 8 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_9 Operator 9 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_10 Operator 10 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_11 Operator 11 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_12 Operator 12 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_13 Operator 13 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_14 Operator 14 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_15 Operator 15 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_16 Operator 16 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_17 Operator 17 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_18 Operator 18 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_19 Operator 19 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_20 Operator 20 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_21 Operator 21 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_22 Operator 22 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_23 Operator 23 VarChar 1 -     Without
            + Addition
            - Subtraction
OP_24 Operator 24 VarChar 1 -     Without
            + Addition
            - Subtraction
ProfitLoss Profit and Loss VarChar 1 - N Y Yes
            N No
MoveNeg Move if Negative VarChar 1 - N Y Yes
            N No
Dummy Dummy Title VarChar 1 - N Y Yes
            N No
HideAct Hide Accounts VarChar 1 - N Y Yes
            N No
UserSign User Signature Int 6 OUSR      
ToGroup Move to Group Int 6 - 0    
ToTitle Move to Title Int 6 - 0    
LineNum Line Number nVarChar 6 -      
IndentChar Indent Char. nVarChar 6 -      
Reversal Reversal Sign VarChar 1 - N N No
            Y Yes
TextTitle Text Title VarChar 1 - N N No
            Y Yes
SumType Gross/Correction/Net VarChar 1 - N B Gross
            C Correction
            N Net
NetIncome Net Income VarChar 1 - N N No
            Y Yes
PLTempId Profit & Loss Report Template Int 11 -      
CustName Customized Account Name VarChar 1 - N Y Yes
            N No
ExtFromBS Relevant for Bal. Sht Extract VarChar 1 - N Y Yes
            N No
ExtData Extended Data VarChar 1 - N A Relevant for Asset History Sheet
            L Relevant for Liabilities History Sheet
            N Not Relevant
LegalRef Legal Reference nVarChar 150 -      
PLCatId Profit & Loss Report Category Int 6 - 0    
SignAggr Sign for Aggregation VarChar 1 - E E  
            P Positive
            N Negative
Mandatory Mandatory VarChar 1 - N Y Yes
            N No
AcctReq Account Verification Required VarChar 1 - N Y Yes
            N No
NotPermit Not Permitted for Tax VarChar 1 - N Y Yes
            N No
KPIFactor KPI Factor No. nVarChar 3 OKPF      
CatCode Category Code nVarChar 15 -      
CatClass Category Classification VarChar 1 -      
            A Asset
            L Liabilities
            E Equity
            D Expenses
            R Revenues
Key Unique Field
PRIMARY Yes TemplateId
    CatId