biuan SAP® BUSINESS ONE SDK
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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates