biuan SAP® BUSINESS ONE SDK
SQL Finance / Financial Report Templates
API OFRT
OFRT - Financial Report Templates Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
NameNamenVarChar
100
DocType KEY UNIQUETemplate TypeVarChar
B) Balance Sheet
P) Profit and Loss
C) Trial Balance
F) Statement of Cash Flows
S) Sales Unit
T) Form 6111
A) Cost Accounting
E) Asset Devalue Provision
R) Shareholder's Rights and Interests Changing
D) Profit Distribution
V) VAT Payable Detail
L) e-Balance Sheet
O) e-Profit and Loss
H) Asset History Sheet
G) Others
I) Taxable Profit and Loss
J) Appropriation of Net Profit
K) E-Asset History Sheet
1
BSECONDYes
FRTCounterFinancial Report Template CounterInt
6
MoveChk1Move Chk1VarChar
Y) Yes
N) No
1
N
MoveChk2Move Chk2VarChar
Y) Yes
N) No
1
N
MoveTo_1Move To 1Int
6
0
MoveTo_2Move To 2Int
6
0
Title_1Title 1nVarChar
100
Title_2Title 2nVarChar
100
ShowMissDisplay Missing AccountsVarChar
Y) Yes
N) No
1
N
ToTitle_1Move To Title 1Int
6
0
ToTitle_2Move To Title 2Int
6
0
UserSignUser SignatureInt
6OUSR
Users
DimCodeIn Which DimensionInt
11ODIM
Cost Accounting Dimension

Table relationship map

SELECT statement

SELECT OFRT.AbsId AS 'Internal Number', OFRT.Name AS 'Name', OFRT.DocType AS 'Template Type', OFRT.FRTCounter AS 'Financial Report Template Counter', OFRT.MoveChk1 AS 'Move Chk1', OFRT.MoveChk2 AS 'Move Chk2', OFRT.MoveTo_1 AS 'Move To 1', OFRT.MoveTo_2 AS 'Move To 2', OFRT.Title_1 AS 'Title 1', OFRT.Title_2 AS 'Title 2', OFRT.ShowMiss AS 'Display Missing Accounts', OFRT.ToTitle_1 AS 'Move To Title 1', OFRT.ToTitle_2 AS 'Move To Title 2', OFRT.UserSign AS 'User Signature', OFRT.DimCode AS 'In Which Dimension' FROM OFRT AS OFRT

Related information


OFRT SQL Table

Cost Accounting Dimension ODIM 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