|
|
API OFRC
OFRC - Financial Report Categories Table
KPI Factor OKPF SQL Table
Financial Report Templates OFRT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CatId | Numerator | Int | 6 |
|---|---|---|---|---|---|---|---|---|
| TemplateId KEY UNIQUE | Template | Int | 11 | OFRT Financial Report Templates | PRIMARY | Yes | ||
| Name | Name | nVarChar | 127 | |||||
| FrgnName | Foreign Name | nVarChar | 127 | |||||
| Levels | Account Level | Int | 1) Level 1 2) Level 2 3) Level 3 | 6 | 1 | |||
| FatherNum | Parent Account Key | Int | 6 | |||||
| Active | Active Account | VarChar | Y) Yes N) No | 1 | N | |||
| HasSons | Including Children | VarChar | Y) Yes N) No | 1 | N | |||
| VisOrder | Display Order | Int | 6 | |||||
| SubSum | Subtotal | VarChar | Y) Yes N) No | 1 | N | |||
| SubName | Subtotal Name | nVarChar | 100 | |||||
| Furmula | Formula | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | |||||
| OP_2 | Operator 2 | VarChar | 1 | |||||
| OP_3 | Operator 3 | VarChar | 1 | |||||
| OP_4 | Operator 4 | VarChar | 1 | |||||
| OP_5 | Operator 5 | VarChar | 1 | |||||
| OP_6 | Operator 6 | VarChar | 1 | |||||
| OP_7 | Operator 7 | VarChar | 1 | |||||
| OP_8 | Operator 8 | VarChar | 1 | |||||
| OP_9 | Operator 9 | VarChar | 1 | |||||
| OP_10 | Operator 10 | VarChar | 1 | |||||
| OP_11 | Operator 11 | VarChar | 1 | |||||
| OP_12 | Operator 12 | VarChar | 1 | |||||
| OP_13 | Operator 13 | VarChar | 1 | |||||
| OP_14 | Operator 14 | VarChar | 1 | |||||
| OP_15 | Operator 15 | VarChar | 1 | |||||
| OP_16 | Operator 16 | VarChar | 1 | |||||
| OP_17 | Operator 17 | VarChar | 1 | |||||
| OP_18 | Operator 18 | VarChar | 1 | |||||
| OP_19 | Operator 19 | VarChar | 1 | |||||
| OP_20 | Operator 20 | VarChar | 1 | |||||
| OP_21 | Operator 21 | VarChar | 1 | |||||
| OP_22 | Operator 22 | VarChar | 1 | |||||
| OP_23 | Operator 23 | VarChar | 1 | |||||
| OP_24 | Operator 24 | VarChar | 1 | |||||
| ProfitLoss | Profit and Loss | VarChar | Y) Yes N) No | 1 | N | |||
| MoveNeg | Move if Negative | VarChar | Y) Yes N) No | 1 | N | |||
| Dummy | Dummy Title | VarChar | Y) Yes N) No | 1 | N | |||
| HideAct | Hide Accounts | VarChar | Y) Yes N) No | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| 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 | N) No Y) Yes | 1 | N | |||
| TextTitle | Text Title | VarChar | N) No Y) Yes | 1 | N | |||
| SumType | Gross/Correction/Net | VarChar | B) Gross C) Correction N) Net | 1 | N | |||
| NetIncome | Net Income | VarChar | N) No Y) Yes | 1 | N | |||
| PLTempId | Profit & Loss Report Template | Int | 11 | |||||
| CustName | Customized Account Name | VarChar | Y) Yes N) No | 1 | N | |||
| ExtFromBS | Relevant for Bal. Sht Extract | VarChar | Y) Yes N) No | 1 | N | |||
| ExtData | Extended Data | VarChar | A) Relevant for Asset History Sheet L) Relevant for Liabilities History Sheet N) Not Relevant | 1 | N | |||
| LegalRef | Legal Reference | nVarChar | 127 | |||||
| PLCatId | Profit & Loss Report Category | Int | 6 | 0 | ||||
| SignAggr | Sign for Aggregation | VarChar | E) P) Positive N) Negative | 1 | E | |||
| Mandatory | Mandatory | VarChar | Y) Yes N) No | 1 | N | |||
| AcctReq | Account Verification Required | VarChar | Y) Yes N) No | 1 | N | |||
| NotPermit | Not Permitted for Tax | VarChar | Y) Yes N) No | 1 | N | |||
| KPIFactor | KPI Factor No. | nVarChar | 3 | OKPF KPI Factor | ||||
| CatCode | Category Code | nVarChar | 15 | |||||
| CatClass | Category Classification | VarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
