biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Customer/Vendor Cat. No.
DTW Inventory / Item Management / Batches / Business Partner Catalog Numbers
API OSCN / Alternate Cat Num
OSCN - Customer/Vendor Cat. No. Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEYItem No.nVarChar
20OITM
Items		ITEMNo
CardCodeBP CodenVarChar
15OCRD
Business Partner
Substitute KEYBP Catalog NumbernVarChar
20
SUBSTITUTENo
TransferedPostponed to Next YearVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
ShowSCNDisplay BP Catalog NumberVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OSCN.ItemCode AS 'Item No.', OSCN.CardCode AS 'BP Code', OSCN.Substitute AS 'BP Catalog Number', OSCN.Transfered AS 'Postponed to Next Year', OSCN.DataSource AS 'Data Source', OSCN.UserSign AS 'User Signature', OSCN.UserSign2 AS 'Updating User', OSCN.ShowSCN AS 'Display BP Catalog Number' FROM OSCN AS OSCN

Related information


Alternate Cat Num AlternateCatNum Object· Table: OSCN
AlternateCatNum is a business object that represents the alternative catalog numbers in the Business Partners module. This object enables you to: Add an alternative catalog number. Retrieve an alternative catalog number by its key. Update...

OSCN SQL Table

Business Partner OCRD SQL Table

Items OITM 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