biuan SAP® BUSINESS ONE SDK
DTW Financial Year Master
API Financial Years Service / Financial Year
OFYM - Financial Year Master Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Code KEY UNIQUECodenVarChar
6
CODEYes
DescrDescriptionnVarChar
30
StartDateStart DateDate
8
EndDateEnd DateDate
8
AssessYear KEY UNIQUEAssessment YearnVarChar
6
ASSESSYEARYes

SELECT statement

SELECT OFYM.AbsId AS 'Internal Number', OFYM.Code AS 'Code', OFYM.Descr AS 'Description', OFYM.StartDate AS 'Start Date', OFYM.EndDate AS 'End Date', OFYM.AssessYear AS 'Assessment Year' FROM OFYM AS OFYM

Related information


Financial Year FinancialYear Object· Table: OFYM
Represents a financial year for TDS (withholding tax) reports. Source table: OFYM
   Parent: Financial Years Service FinancialYearsService Service· Table: OFYM

Financial Years Service FinancialYearsService Service· Table: OFYM
The FinancialYearsService service enables you to add, look up and remove financial roles for TDS (withholding tax) reports. To see the list of employee roles and create a new one, select Administration -- Setup -- Financials -- TDS --...

OFYM 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