biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Sales Opportunities / Sales Stages
API OOST / / Sales Stages
OOST - Opportunity Stage Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Num KEY UNIQUESequence No.Int
11
PRIMARYYes
DescriptNamenVarChar
30
StepId KEY UNIQUEStage No.Int
6
STEPYes
CloPrcntClosing PercentageNum
20
CanceledCanceledVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
SalesStageSalesVarChar
Y) Yes
N) No
1
Y
PurStagePurchasingVarChar
Y) Yes
N) No
1
Y

Table relationship map

SELECT statement

SELECT OOST.Num AS 'Sequence No.', OOST.Descript AS 'Name', OOST.StepId AS 'Stage No.', OOST.CloPrcnt AS 'Closing Percentage', OOST.Canceled AS 'Canceled', OOST.UserSign AS 'User Signature', OOST.SalesStage AS 'Sales', OOST.PurStage AS 'Purchasing' FROM OOST AS OOST

Related information


Sales Stages SalesStages Object· Table: OOST
The SalesStages object enables defining sales stages and their probability percentage. For example: Lead, Meeting, Quotation, Negotiation, and Order. These definitions are used as default values for the SalesOpportunities object. Source table:...

OOST 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