📚 SAP Business One SDK Help

Table Name: OSPP

Table Description: Special Prices

Field Description Type Size Related Default Value Constraints
ItemCode Item No. nVarChar 50 OITM      
CardCode BP Code nVarChar 15 OCRD      
Price Special Price Num 19.6 -      
Currency Price Currency nVarChar 3 -      
Discount Discount in % Num 19.6 -      
ListNum Price List No. Int 6 OPLN 0    
AutoUpdt Auto Update VarChar 1 - Y Y Yes
            N No
EXPAND Item Details VarChar 1 - N Y Yes
            N No
UserSign User Signature Int 6 OUSR      
SrcPrice Source Price Int 6 - 0 0 Price - Pri. Curr.
            1 Price - Add. Curr. 1
            2 Price - Add. Curr. 2
LogInstanc Log Instance Int 11 - 0    
UserSign2 Updating User Int 6 OUSR      
CreateDate Creation Date Date 8 -      
UpdateDate Update Date Date 8 -      
Valid Active VarChar 1 - Y Y Yes
            N No
ValidFrom Active From Date 8 -      
ValidTo Active To Date 8 -      
Key Unique Field
PRIMARY Yes CardCode
    ItemCode
CARD No CardCode
ITEM No ItemCode
CURRENCY No Currency