biuan SAP® BUSINESS ONE SDK
API OTRT
OTRT - Posting Templates Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TrtCode KEY UNIQUETemplate CodenVarChar
8
PRIMARYYes
DscriptionTemplate DescriptionnVarChar
60
FrgnModeFC TemplateVarChar
Y) Yes
N) No
1
Y
MemoDetailsnVarChar
50
TransCodeTransaction CodenVarChar
4
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
StampTaxStamp TaxVarChar
Y) Yes
N) No
1
N
AutoVatAutomatic VATVarChar
Y) Yes
N) No
1
N
ManageWTaxManage WTaxVarChar
Y) Yes
N) No
1
N
DeferedTaxDeferred TaxVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OTRT.TrtCode AS 'Template Code', OTRT.Dscription AS 'Template Description', OTRT.FrgnMode AS 'FC Template', OTRT.Memo AS 'Details', OTRT.TransCode AS 'Transaction Code', OTRT.DataSource AS 'Data Source', OTRT.UserSign AS 'User Signature', OTRT.StampTax AS 'Stamp Tax', OTRT.AutoVat AS 'Automatic VAT', OTRT.ManageWTax AS 'Manage WTax', OTRT.DeferedTax AS 'Deferred Tax' FROM OTRT AS OTRT

Related information


OTRT 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