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

SQL Marketing Documents and Receipts / Docs. for Confirmation / Docs. for Confirmation

DTW Docs. for Confirmation

API Approval Requests Service / Approval Request

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
WddCode ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
WtmCode	Authorization Template	Int		11	OWTM Approval Templates
OwnerID	Production Code	Int		11	OUSR Users
DocEntry	Document Counter	Int		11
ObjType	Object Type	nVarChar	23) Sales Quotation 17) Sales Order 15) Delivery 16) Return 203) A/R Down Payment 13) A/R Invoice 165) A/R Correction Invoice 166) A/R Correction Invoice Reversal 14) A/R Credit Memo 132) Correction Invoice (-0) (- 1470000113) Purchase Request 540000006) Purchase Quotation 22) Purchase Order 20) Goods Receipt PO 21) Goods Returns 204) A/P Down Payment 18) A/P Invoice 163) A/P Correction Invoice 164) A/P Correction Invoice Reversal 19) A/P Credit Memo (-1) (- 59) Goods Receipt 60) Goods Issue 1250000001) Inventory Transfer Request 67) Inventory Transfer 310000001) Inventory Opening Balance (-2) (- 46) Outgoing Payment (-3) (- 1470000065) Inventory Counting 10000071) Inventory Posting 112) Documents - Drafts 140) Payment Drafts 1470000109) Inventory Counting - Drafts 1470000136) Inventory Posting - Drafts 1470000131) Inventory Opening Balance - Drafts	20
DocDate	Posting Date	Date		8
CurrStep	Stage Code	Int		11	OWST Confirmation Level
Status	Status	VarChar	W) Pending Y) Approved N) Rejected P) Generated A) Generated by Authorizer C) Canceled	1		W
Remarks	Remarks	nVarChar		100
UserSign	User Signature	Int		6	OUSR Users
CreateDate	Production Date	Date		8
CreateTime	Production Time	Int		6
IsDraft	Draft	VarChar	Y) Yes N) No	1		Y
MaxReqr	No. of Authorizers	Int		6
MaxRejReqr	No. of Rejects	Int		6

Table relationship map

SELECT statement

SELECT
   OWDD.WddCode AS 'Internal Number', 
   OWDD.WtmCode AS 'Authorization Template', 
   OWDD.OwnerID AS 'Production Code', 
   OWDD.DocEntry AS 'Document Counter', 
   OWDD.ObjType AS 'Object Type', 
   OWDD.DocDate AS 'Posting Date', 
   OWDD.CurrStep AS 'Stage Code', 
   OWDD.Status AS 'Status', 
   OWDD.Remarks AS 'Remarks', 
   OWDD.UserSign AS 'User Signature', 
   OWDD.CreateDate AS 'Production Date', 
   OWDD.CreateTime AS 'Production Time', 
   OWDD.IsDraft AS 'Draft', 
   OWDD.MaxReqr AS 'No. of Authorizers', 
   OWDD.MaxRejReqr AS 'No. of Rejects'
FROM OWDD AS OWDD

Related information

ApprovalRequest Object· Table: OWDD

Represents an approval request. Source table: OWDD.

Parent: Approval Requests Service ApprovalRequestsService Service· Table: OWDD

ApprovalRequestParams Object· Table: OWDD

Holds the key, remarks, and status of an approval request. This object is used to pass keys to and retrieve keys from ApprovalRequestsService methods. Source table: OWDD.

Parent: Approval Requests Params ApprovalRequestsParams Collection

ApprovalRequestsService Service· Table: OWDD

ApprovalRequestsService is a business object that manages the approval requests process in the SAP Business One environment. This object enables users to do the following: Get an approval request from the approval process. Get a list of...

OWST SQL Table

OUSR SQL Table

OWTM SQL Table

biuan SAP® BUSINESS ONE

Service
ApprovalRequestsService

Object
ApprovalRequest

Collection

ApprovalRequestDecisions

ApprovalRequestLines

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

ApprovalRequestDecisions

Code

IsDraft

Remarks

Status

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