biuan SAP® BUSINESS ONE SDK
SQL Others / Resources - Prices - Log
API ARSC2
ARSC2 - Resources - Prices - Log 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 ARSC2.ResCode AS 'Internal Resource ID', ARSC2.PriceList AS 'Price List No.', ARSC2.Price AS 'List Price', ARSC2.Currency AS 'Currency for List Price', ARSC2.Ovrwritten AS 'Manual Price Entry', ARSC2.Factor AS 'Factor', ARSC2.LogInstanc AS 'Log Instance', ARSC2.ObjType AS 'Object', ARSC2.AddPrice1 AS 'Additional Price (1)', ARSC2.Currency1 AS 'Currency for Add. Price 1', ARSC2.AddPrice2 AS 'Additional Price (2)', ARSC2.Currency2 AS 'Currency for Add. Price 2', ARSC2.Ovrwrite1 AS 'Manual Price Entry (1)', ARSC2.Ovrwrite2 AS 'Manual Price Entry (2)' FROM ARSC2 AS ARSC2

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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates