biuan SAP® BUSINESS ONE SDK
API IMT1
IMT1 - Acct data in selected template Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TemplateId KEY UNIQUETemplate IDInt
6OIMT
Templates for Inventory JE
-1PRIMARYYes
AccountIdAccount IDInt
6
-1
DebitCrediDebit or CreditVarChar
U) Unknown
D) DEBIT
C) CREDIT
B) Both
T) Total
1
U
OrderCalcOrder CalcInt
6
-1

Table relationship map

SELECT statement

SELECT IMT1.TemplateId AS 'Template ID', IMT1.AccountId AS 'Account ID', IMT1.DebitCredi AS 'Debit or Credit', IMT1.OrderCalc AS 'Order Calc' FROM IMT1 AS IMT1

Related information


IMT1 SQL Table

Templates for Inventory JE OIMT 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