biuan SAP® BUSINESS ONE SDK
SQL Finance / Fixed Asset Revaluation
API OFAR
OFAR - Fixed Asset Revaluation Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEY UNIQUEDocument NumberInt
11
INDEXYes
SeriesSeriesInt
6NNM1
Documents Numbering - Series
PostDatePosting DateDate
8
AssetDateAsset Value DateDate
8
RefReferencenVarChar
32
CommentsRemarksnVarChar
127
JrnlMemoJournal RemarksnVarChar
50
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
TransIdTransaction NumberInt
11OJDT
Journal Entry
HandwrttenManual NumberingVarChar
Y) Yes
N) No
1
N
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
DocDateDocument DateDate
8
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
VatRegNumVAT Reg. NumbernVarChar
32
RevalPercRevaluation Percentage %Num
20

Table relationship map

SELECT statement

SELECT OFAR.DocEntry AS 'Internal Number', OFAR.DocNum AS 'Document Number', OFAR.Series AS 'Series', OFAR.PostDate AS 'Posting Date', OFAR.AssetDate AS 'Asset Value Date', OFAR.Ref AS 'Reference', OFAR.Comments AS 'Remarks', OFAR.JrnlMemo AS 'Journal Remarks', OFAR.DprArea AS 'Depreciation Area', OFAR.TransId AS 'Transaction Number', OFAR.Handwrtten AS 'Manual Numbering', OFAR.PIndicator AS 'Period Indicator', OFAR.DocDate AS 'Document Date', OFAR.BPLId AS 'Branch', OFAR.BPLName AS 'Branch Name', OFAR.VatRegNum AS 'VAT Reg. Number', OFAR.RevalPerc AS 'Revaluation Percentage %' FROM OFAR AS OFAR

Related information


OFAR SQL Table

Business Place OBPL SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Period Indicator OPID SQL Table

Documents Numbering - Series NNM1 SQL Table

Journal Entry OJDT 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