OFCT - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

MRP /

Sales Forecast

API OFCT / / Sales Forecast

OFCT - Sales Forecast Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsID ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
Code ^KEY ^UNIQUE	Forecast Code	nVarChar		16			FCT_CODE	Yes
Name	Forecast Name	nVarChar		100
UserSign	User Signature	Int		6	OUSR Users
StartDate	Forecast Start Date	Date		8
EndDate	Forecast End Date	Date		8
FormView	Forecast Form View	VarChar	D) Daily W) Weekly M) Monthly	1		D

Table relationship map

SELECT statement

SELECT
   OFCT.AbsID AS 'Internal Number', 
   OFCT.Code AS 'Forecast Code', 
   OFCT.Name AS 'Forecast Name', 
   OFCT.UserSign AS 'User Signature', 
   OFCT.StartDate AS 'Forecast Start Date', 
   OFCT.EndDate AS 'Forecast End Date', 
   OFCT.FormView AS 'Forecast Form View'
FROM OFCT AS OFCT

Related information

SalesForecast Object· Table: OFCT

SalesForecast is a business object that represents the sales forecast for a specified period. The sales forecast is required for planning the purchase and production of items in the MRP module. This object enables you to: Add a sales forecast....

OFCT SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
SalesForecast

Enumeration

ForecastViewTypeEnum

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Object

SalesForecast_Lines FCT1

Property

Browser

Lines

UserFields

View

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