|
|
DTW Administration / Setup / General / Commission Groups / Certificate Series
API Certificate Series Service / Certificate Series
OCSN - Certificate Series Table
Certificate Series CertificateSeries Object· Table: OCSN
Parent: Certificate Series Service CertificateSeriesService Service· Table: OCSN
Certificate Series Service CertificateSeriesService Service· Table: OCSN
OCSN SQL Table
Location OLCT SQL Table
Sections OSEC SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsId KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Code KEY UNIQUE | Code | nVarChar | 4 | CODE | Yes | |||
| Section KEY | Section | Int | 11 | OSEC Sections | SECTION | No | ||
| Location KEY | Location | Int | 11 | OLCT Location | LOCATION | No | ||
| DfltSeries | Default Series | Int | 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
CertificateSeriesService
Object
CertificateSeries
Collection
Method
Property
AbsEntry
DB
Code
DB
Location
DB
Section
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
