biuan SAP® BUSINESS ONE SDK
SQL Finance / Extend Cat. f. Financial Rep.
API FRC1
FRC1 - Extend Cat. f. Financial Rep. Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CatIdNumeratorInt
6
TemplateId KEY UNIQUETemplateInt
11OFRT
Financial Report Templates		PRIMARYYes
AcctCode KEYAccount CodenVarChar
15OACT
G/L Accounts		ACCNT_CODENo
VisOrderDisplay OrderInt
6
CFWIdCash Flow Line Item IDInt
11OCFW
Cash Flow Line Item
CalcMethodCalculation MethodnVarChar
BOP) Beginning of Period
EOP) End of Period
CPID) Current Period In Debit
CPIC) Current Period In Credit
CPIB) Current Period In Both
30
SlpCodeSales Unit CodeInt
11OSLP
Sales Employee
PrcCodeCost Center CodenVarChar
8OPRC
Cost Center
CalMethod2Calculation Method 2nVarChar
30
CalMethod3Calculation Method 3nVarChar
30
LinkedLinkedVarChar
B) Balance
D) Debit
C) Credit
1
B
SignSignVarChar
E)
P) Positive
N) Negative
1
E

Table relationship map

SELECT statement

SELECT FRC1.CatId AS 'Numerator', FRC1.TemplateId AS 'Template', FRC1.AcctCode AS 'Account Code', FRC1.VisOrder AS 'Display Order', FRC1.CFWId AS 'Cash Flow Line Item ID', FRC1.CalcMethod AS 'Calculation Method', FRC1.SlpCode AS 'Sales Unit Code', FRC1.PrcCode AS 'Cost Center Code', FRC1.CalMethod2 AS 'Calculation Method 2', FRC1.CalMethod3 AS 'Calculation Method 3', FRC1.Linked AS 'Linked', FRC1.Sign AS 'Sign' FROM FRC1 AS FRC1

Related information


G/L Accounts OACT SQL Table

Cash Flow Line Item OCFW SQL Table

Cost Center OPRC SQL Table

Sales Employee OSLP SQL Table

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