biuan SAP® BUSINESS ONE SDK
API APLN
APLN - 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 CurrenynVarChar
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 APLN.ListNum AS 'Price List No.', APLN.ListName AS 'Price List Name', APLN.BASE_NUM AS 'Base Price List', APLN.Factor AS 'Factor', APLN.RoundSys AS 'Rounding Method', APLN.GroupCode AS 'Group No.', APLN.DataSource AS 'Data Source', APLN.SPPCounter AS 'SPP Counter', APLN.UserSign AS 'User Signature', APLN.IsGrossPrc AS 'Gross Price?', APLN.LogInstanc AS 'Log Instance', APLN.UserSign2 AS 'Updating User', APLN.UpdateDate AS 'Update Date', APLN.ValidFor AS 'Active', APLN.ValidFrom AS 'Active From', APLN.ValidTo AS 'Active To', APLN.CreateDate AS 'Creation Date', APLN.PrimCurr AS 'Primary Default Curreny', APLN.AddCurr1 AS 'Additional Default Currency 1', APLN.AddCurr2 AS 'Additional Default Currency 2', APLN.RoundRule AS 'Rounding Rule', APLN.ExtAmount AS 'Fixed Amount (Ending/Interval)', APLN.RndFrmtInt AS 'Ending/Interval - Integer Part', APLN.RndFrmtDec AS 'Ending/Interval - Decimal Part' FROM APLN AS APLN

Related information


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