biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inventory Valuation Utility Queries
API OSTQ
OSTQ - Inventory Valuation Utility Queries Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
QueryNAmeQuery NamenVarChar
100
QueryStrQuery StringText
16
SeverityInventory Valuation Query SeveVarChar
W) Warning if fails
E) Error if fails
1
E
QueryGroupQuery GroupVarChar
B) Before Recalculation
A) After Recalculation
T) Year Transfer
1
B

SELECT statement

SELECT OSTQ.AbsEntry AS 'Internal Number', OSTQ.QueryNAme AS 'Query Name', OSTQ.QueryStr AS 'Query String', OSTQ.Severity AS 'Inventory Valuation Query Seve', OSTQ.QueryGroup AS 'Query Group' FROM OSTQ AS OSTQ

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