biuan SAP® BUSINESS ONE SDK
DTW Financials / Fixed Assets
API ERX1
ERX1 - Excise Registering Number-Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ErnId KEY UNIQUEExcise Register Numbering IDInt
11OERX
Excise Register Numbering Ext
PRIMARYYes
NumTypeIdNumbering Type IDInt
11
NumTypeNamNumbering Type NamenVarChar
30
FirstNumFirst NumberInt
11
NextNumNext NumberInt
11
LastNumLast NumberInt
11
ResetDateDate of last resetDate
8

SELECT statement

SELECT ERX1.ErnId AS 'Excise Register Numbering ID', ERX1.NumTypeId AS 'Numbering Type ID', ERX1.NumTypeNam AS 'Numbering Type Name', ERX1.FirstNum AS 'First Number', ERX1.NextNum AS 'Next Number', ERX1.LastNum AS 'Last Number', ERX1.ResetDate AS 'Date of last reset' FROM ERX1 AS ERX1

Related information


Excise Register Numbering Ext OERX 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