biuan SAP® BUSINESS ONE SDK
DTW Financials / Chart of Accounts
API OERN
OERN - Excise Register Numbering Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
NumTypeID KEY UNIQUEID for numbering typeInt
11
PRIMARYYes
NumTypeNamName for numbering typenVarChar
30
FirstNumFirst numberInt
11
1
NextNumNext NumberInt
11
1
LastNumLast NumberInt
11
UserSignUser SignatureInt
6OUSR
Users
ResetDateDate of last resetDate
8

SELECT statement

SELECT OERN.NumTypeID AS 'ID for numbering type', OERN.NumTypeNam AS 'Name for numbering type', OERN.FirstNum AS 'First number', OERN.NextNum AS 'Next Number', OERN.LastNum AS 'Last Number', OERN.UserSign AS 'User Signature', OERN.ResetDate AS 'Date of last reset' FROM OERN AS OERN

Related information


Users OUSR 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