biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Items / Service Code Table
DTW Inventory / Item Master Data / Service Code Table
API Items / Incoming Service Code
OSCD - Service Code Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEIDInt
11
PRIMARYYes
County KEY UNIQUECounty CodeInt
11OCNT
Counties		CODEYes
ServiceCDService CodenVarChar
15
DescripDescriptionnVarChar
70
IncomimgIs Incomimg(Y/N)VarChar
Y) Incoming
N) Outgoing
1
Y

Table relationship map

SELECT statement

SELECT OSCD.AbsEntry AS 'ID', OSCD.County AS 'County Code', OSCD.ServiceCD AS 'Service Code', OSCD.Descrip AS 'Description', OSCD.Incomimg AS 'Is Incomimg(Y/N)' FROM OSCD AS OSCD

Related information


Incoming Service Code IncomingServiceCode Property· Table: OSCD
Sets or returns the Item's incoming service code. Field name: ISvcCode. This is a foreign key to the Service Code table (OSCD), not exposed through the DI API.
· Table: OITM    Parent: Items Items Object· Table: OITM
OSCD SQL Table

Counties OCNT 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