biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Defect Cause / Defect Cause
DTW Defect Cause
API Sales Opportunity Reasons Setup Service / Sales Opportunity Reason Setup
OOFR - Defect Cause Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Num KEY UNIQUESequence No.Int
11
PRIMARYYes
DescriptDescriptionnVarChar
30
SortOrderSortInt
6
100
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OOFR.Num AS 'Sequence No.', OOFR.Descript AS 'Description', OOFR.SortOrder AS 'Sort', OOFR.UserSign AS 'User Signature' FROM OOFR AS OOFR

Related information


Sales Opportunity Reason Setup SalesOpportunityReasonSetup Object· Table: OOFR
Represents a reason for a successful or unsuccessful sales opportunity. Source table: OOFR Mandatory properties: Description
   Parent: Sales Opportunity Reasons Setup Service SalesOpportunityReasonsSetupService Service· Table: OOFR

Sales Opportunity Reasons Setup Service SalesOpportunityReasonsSetupService Service· Table: OOFR
The SalesOpportunityReasonsSetupService service enables you to add, look up and remove reasons in the reasons master data table. Reasons can be assigned to sales opportunities; the reason explain why a sales opportunity was won or lost. To see...

OOFR 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates