biuan SAP® BUSINESS ONE SDK
API RSC2
RSC2 - Resources - Prices Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ResCode KEY UNIQUEInternal Resource IDnVarChar
20ORSC
Resources
PRIMARYYes
PriceList KEYPrice List No.Int
11OPLN
Price Lists
PRICE_LISTNo
PriceList PriceNum
20
Currency KEYCurrency for List PricenVarChar
3OCRN
Currency Codes
CURRENCYNo
Ovrwritten KEYManual Price EntryVarChar
Y) Yes
N) No
1
NMANUALNo
FactorFactorNum
20
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
290
AddPrice1Additional Price (1)Num
20
Currency1Currency for Add. Price 1nVarChar
3OCRN
Currency Codes
AddPrice2Additional Price (2)Num
20
Currency2Currency for Add. Price 2nVarChar
3OCRN
Currency Codes
Ovrwrite1Manual Price Entry (1)VarChar
Y) Yes
N) No
1
N
Ovrwrite2Manual Price Entry (2)VarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT RSC2.ResCode AS 'Internal Resource ID', RSC2.PriceList AS 'Price List No.', RSC2.Price AS 'List Price', RSC2.Currency AS 'Currency for List Price', RSC2.Ovrwritten AS 'Manual Price Entry', RSC2.Factor AS 'Factor', RSC2.LogInstanc AS 'Log Instance', RSC2.ObjType AS 'Object', RSC2.AddPrice1 AS 'Additional Price (1)', RSC2.Currency1 AS 'Currency for Add. Price 1', RSC2.AddPrice2 AS 'Additional Price (2)', RSC2.Currency2 AS 'Currency for Add. Price 2', RSC2.Ovrwrite1 AS 'Manual Price Entry (1)', RSC2.Ovrwrite2 AS 'Manual Price Entry (2)' FROM RSC2 AS RSC2

Related information


Currency Codes OCRN SQL Table

Object Settings - History ADP1 SQL Table

Price Lists OPLN SQL Table

Resources ORSC 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