biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / General / Commission Groups / Certificate Series
API Certificate Series Service / Certificate Series
OCSN - Certificate Series Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Code KEY UNIQUECodenVarChar
4
CODEYes
Section KEYSectionInt
11OSEC
Sections
SECTIONNo
Location KEYLocationInt
11OLCT
Location
LOCATIONNo
DfltSeriesDefault SeriesInt
6
0

Table relationship map

SELECT statement

SELECT OCSN.AbsId AS 'Internal Number', OCSN.Code AS 'Code', OCSN.Section AS 'Section', OCSN.Location AS 'Location', OCSN.DfltSeries AS 'Default Series' FROM OCSN AS OCSN

Related information


Certificate Series CertificateSeries Object· Table: OCSN
Represents a series for TDS (withholding tax) reports. Source table: OCSN
   Parent: Certificate Series Service CertificateSeriesService Service· Table: OCSN

Certificate Series Service CertificateSeriesService Service· Table: OCSN
The CertificateSeriesService service enables you to add, look up and remove certificate series. Certificate series are used for TDS (withholding tax) reports. To see the list of certificate series and create a new one, select Administration...

OCSN SQL Table

Location OLCT SQL Table

Sections OSEC 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