biuan SAP® BUSINESS ONE SDK
DTW Inventory / Price Lists / Price Lists
API OPLN / / Price Lists
OPLN - Price Lists Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ListNum KEY UNIQUEPrice List No.Int
6
PRIMARYYes
ListName KEY UNIQUEPrice List NamenVarChar
32
LIST_NAMEYes
BASE_NUMBase Price ListInt
6OPLN
Price Lists
FactorFactorNum
20
RoundSysRounding MethodInt
0
1) Round to Full Decimal Amount
2) Round to Full Amount
3) Round to Full Tens Amount
4) Fixed Ending
5) Fixed Interval
6
0
GroupCodeGroup No.Int
1) Group 1
2) Group 2
3) Group 3
4) Group 4
6
1
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
SPPCounterSPP CounterInt
11
UserSignUser SignatureInt
6OUSR
Users
IsGrossPrcGross Price?VarChar
Y) Yes
N) No
1
N
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
ValidForActiveVarChar
Y) Yes
N) No
1
Y
ValidFromActive FromDate
8
ValidToActive ToDate
8
CreateDateCreation DateDate
8
PrimCurrPrimary Default CurrencynVarChar
3
AddCurr1Additional Default Currency 1nVarChar
3
AddCurr2Additional Default Currency 2nVarChar
3
RoundRuleRounding RuleVarChar
R) Round to Closest
C) Round Up
F) Round Down
1
R
ExtAmountFixed Amount (Ending/Interval)Num
20
RndFrmtIntEnding/Interval - Integer PartnVarChar
10
RndFrmtDecEnding/Interval - Decimal PartnVarChar
10

Table relationship map

SELECT statement

SELECT OPLN.ListNum AS 'Price List No.', OPLN.ListName AS 'Price List Name', OPLN.BASE_NUM AS 'Base Price List', OPLN.Factor AS 'Factor', OPLN.RoundSys AS 'Rounding Method', OPLN.GroupCode AS 'Group No.', OPLN.DataSource AS 'Data Source', OPLN.SPPCounter AS 'SPP Counter', OPLN.UserSign AS 'User Signature', OPLN.IsGrossPrc AS 'Gross Price?', OPLN.LogInstanc AS 'Log Instance', OPLN.UserSign2 AS 'Updating User', OPLN.UpdateDate AS 'Update Date', OPLN.ValidFor AS 'Active', OPLN.ValidFrom AS 'Active From', OPLN.ValidTo AS 'Active To', OPLN.CreateDate AS 'Creation Date', OPLN.PrimCurr AS 'Primary Default Currency', OPLN.AddCurr1 AS 'Additional Default Currency 1', OPLN.AddCurr2 AS 'Additional Default Currency 2', OPLN.RoundRule AS 'Rounding Rule', OPLN.ExtAmount AS 'Fixed Amount (Ending/Interval)', OPLN.RndFrmtInt AS 'Ending/Interval - Integer Part', OPLN.RndFrmtDec AS 'Ending/Interval - Decimal Part' FROM OPLN AS OPLN

Related information


Price Lists PriceLists Object· Table: OPLN
PriceLists is a business object that represents the management of price lists in the Inventory module. A price list is used by Items_Prices object to set the item prices. An item can have several prices, with each based on a different price list,...

Price Lists OPLN 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