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

SQL

Administration /

Import Template

DTW Inventory / Inventory Transactions / Inventory Opening Balance

API OTPL

OTPL - Import Template Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Primary_Key	Unique
TplNum ^KEY ^UNIQUE	Template Number	Int		11	PRIMARY	Yes
TplName	Template Name	nVarChar		100
TplType	Template Type	VarChar	T) Target BPs B) BP I) Items F) Fixed Asset	1
TplCode ^KEY ^UNIQUE	Template Code	nVarChar		20	CODE	Yes

SELECT statement

SELECT
   OTPL.TplNum AS 'Template Number', 
   OTPL.TplName AS 'Template Name', 
   OTPL.TplType AS 'Template Type', 
   OTPL.TplCode AS 'Template Code'
FROM OTPL AS OTPL

Related information

OTPL SQL Table

biuan SAP® BUSINESS ONE

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