biuan SAP® BUSINESS ONE SDK
SQL Administration / Excise Register Numbering Ext
DTW Financials / Cost Accounting
API OERX
OERX - Excise Register Numbering Ext Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ErnId KEY UNIQUEExcise Register Numbering IDInt
11
PRIMARYYes
Location KEY UNIQUELoc.Int
11OLCT
Location		LOC_KEYYes
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OERX.ErnId AS 'Excise Register Numbering ID', OERX.Location AS 'Loc.', OERX.UserSign AS 'User Signature' FROM OERX AS OERX

Related information


OERX SQL Table

Location OLCT SQL Table

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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates