biuan SAP® BUSINESS ONE SDK
SQL Administration / Excise Register Numbering Type
DTW Financials / Cost Accounting / Profit Centers
API OERT
OERT - Excise Register Numbering Type Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
NumTypeId KEY UNIQUENumbering Type IDInt
11
PRIMARYYes
NumTypeNam KEY UNIQUENumbering Type NamenVarChar
30
TYPE_NAMEYes
FirstNumFirst NumberInt
11
NextNumNext NumberInt
11
LastNumLast NumberInt
11

SELECT statement

SELECT OERT.NumTypeId AS 'Numbering Type ID', OERT.NumTypeNam AS 'Numbering Type Name', OERT.FirstNum AS 'First Number', OERT.NextNum AS 'Next Number', OERT.LastNum AS 'Last Number' FROM OERT AS OERT

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