biuan SAP® BUSINESS ONE SDK
SQL Administration / Import Template
DTW Inventory / Inventory Transactions / Inventory Opening Balance
API OTPL
OTPL - Import Template Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TplNum KEY UNIQUETemplate NumberInt
11
PRIMARYYes
TplNameTemplate NamenVarChar
100
TplTypeTemplate TypeVarChar
T) Target BPs
B) BP
I) Items
F) Fixed Asset
1
TplCode KEY UNIQUETemplate CodenVarChar
20
CODEYes

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
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