biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Templates for Inventory JE
API OIMT
OIMT - Templates for Inventory JE Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ValuatTypeDocument Valuation TypeVarChar
A)
F)
S)
N) unDefined
1
N
TransType KEY UNIQUETransaction typeInt
11
-1SECONDARYYes
BaseTypeBase Transaction TypeInt
6
-1
TemplateId KEY UNIQUETemplate IDInt
6
-1PRIMARYYes
LocalizIdLocalization IdentifiernVarChar
XX) All Localizations
2
XX
ActionAction TypeInt
6
0
JEPostingPosting StatusVarChar
N) None
C) Complete
P) Partial
1
N
LineActTypLine Account TypeInt
2) LINE_ACCT_TYPE
6
2
TmpTypeTemplate TypeInt
6
0
TotalTotal TypeVarChar
M) Total from Message
C) Total from Calculator
F) Total from Formula
1
M

SELECT statement

SELECT OIMT.ValuatType AS 'Document Valuation Type', OIMT.TransType AS 'Transaction type', OIMT.BaseType AS 'Base Transaction Type', OIMT.TemplateId AS 'Template ID', OIMT.LocalizId AS 'Localization Identifier', OIMT.Action AS 'Action Type', OIMT.JEPosting AS 'Posting Status', OIMT.LineActTyp AS 'Line Account Type', OIMT.TmpType AS 'Template Type', OIMT.Total AS 'Total Type' FROM OIMT AS OIMT

Related information


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