biuan SAP® BUSINESS ONE SDK
DTW Administration / Approval Procedures / Approval Templates / Approval Templates
API Approval Templates / Approval Template
OWTM - Approval Templates Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WtmCode KEY UNIQUECodeInt
11OWTM
Approval Templates
PRIMARYYes
Name KEY UNIQUENamenVarChar
20
NAMEYes
RemarksDescriptionnVarChar
100
CondsConditionsVarChar
Y) Yes
N) No
1
N
ActiveActiveVarChar
Y) Yes
N) No
1
Y
UserSignUser SignatureInt
6OUSR
Users
PmptChgPrompt ChangeVarChar
Y) Yes
N) No
1
Y

Table relationship map

SELECT statement

SELECT OWTM.WtmCode AS 'Code', OWTM.Name AS 'Name', OWTM.Remarks AS 'Description', OWTM.Conds AS 'Conditions', OWTM.Active AS 'Active', OWTM.UserSign AS 'User Signature', OWTM.PmptChg AS 'Prompt Change' FROM OWTM AS OWTM

Related information


Approval Template ApprovalTemplate Object· Table: OWTM
ApprovalTemplate is a data structure related to the ApprovalTemplatesService. Source table: OWTM.
   Parent: Approval Templates ApprovalTemplates Collection· Table: OWTM

Approval Template Params ApprovalTemplateParams Object· Table: OWTM
The ApprovalTemplateParams specifies the identification key combination (Code and Name) for which the ApprovalTemplatesService is related. Source table: OWTM.
   Parent: Approval Templates Params ApprovalTemplatesParams Collection· Table: OWTM

Approval Templates Params ApprovalTemplatesParams Collection· Table: OWTM
ApprovalTemplatesParams is a Data Collection of ApprovalTemplateParams identification keys. Source table: OWTM.
   Parent: Approval Templates Service ApprovalTemplatesService Service· Table: OWTM

Approval Templates ApprovalTemplates Collection· Table: OWTM
ApprovalTemplates is a Data Collection of ApprovalTemplate data structures. Source table: OWTM.


Approval Templates Service ApprovalTemplatesService Service· Table: OWTM
ApprovalTemplatesService is a business object that manages the Approval of deviations from organization limitations. This object enables to: Add a new Approval Stage to approval process. Get Approval Stage from approval process. Get a list...

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