ERX1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / Excise Registering Number-Rows

DTW Financials / Fixed Assets

API ERX1

ERX1 - Excise Registering Number-Rows Table

SBO SQL database table details

Field	Description	Type	Size	Related	Primary_Key	Unique
ErnId ^KEY ^UNIQUE	Excise Register Numbering ID	Int	11	OERX Excise Register Numbering Ext	PRIMARY	Yes
NumTypeId	Numbering Type ID	Int	11
NumTypeNam	Numbering Type Name	nVarChar	30
FirstNum	First Number	Int	11
NextNum	Next Number	Int	11
LastNum	Last Number	Int	11
ResetDate	Date of last reset	Date	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

OERX SQL Table

biuan SAP® BUSINESS ONE

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