📚 SAP Business One SDK Help

Table Name: OSCN

Table Description: Customer/Vendor Cat. No.

Field Description Type Size Related Default Value Constraints
ItemCode Item No. nVarChar 50 OITM      
CardCode BP Code nVarChar 15 OCRD      
Substitute BP Catalog Number nVarChar 50 -      
Transfered Postponed to Next Year VarChar 1 - N Y Yes
            N No
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
UserSign2 Updating User Int 6 OUSR      
ShowSCN Display BP Catalog Number VarChar 1 - N Y Yes
            N No
IsDefault Is Default BP Catalog VarChar 1 - N Y Yes
            N No
Descriptio BP Catalog Description nVarChar 200 -      
DataVers Data Version Int 11 - 1    
Key Unique Field
PRIMARY Yes ItemCode
    CardCode
    Substitute
CARD_SCN No CardCode
    Substitute
CARD No CardCode
    ItemCode
ITEM No ItemCode
    CardCode
SUBSTITUTE No Substitute
DEFAULT No CardCode
    ItemCode
    IsDefault