biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / General / Sales Employees
API Series Lines / Series Line
CSN1 - Certificate Series - Series Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11OCSN
Certificate Series
PRIMARYYes
SeriesSeriesInt
6
BeginStrPrefixnVarChar
20
InitialNumFirst No.Int
11
1
NextNumNext No.Int
11
1
LastNumLast No.Int
11

SELECT statement

SELECT CSN1.AbsId AS 'Internal Number', CSN1.Series AS 'Series', CSN1.BeginStr AS 'Prefix', CSN1.InitialNum AS 'First No.', CSN1.NextNum AS 'Next No.', CSN1.LastNum AS 'Last No.' FROM CSN1 AS CSN1

Related information


Series Line SeriesLine Object· Table: CSN1
Contains the details of a certificate series. Source table: CSN1
   Parent: Series Lines SeriesLines Collection
Certificate Series OCSN 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