📚 SAP Business One SDK Help

Table Name: APLN

Table Description: Price Lists

Field Description Type Size Related Default Value Constraints
ListNum Price List No. Int 6 -      
ListName Price List Name nVarChar 32 -      
BASE_NUM Base Price List Int 6 OPLN      
Factor Factor Num 19.6 -      
RoundSys Rounding Method Int 6 - 0 0 No Rounding
            1 Round to Full Decimal Amount
            2 Round to Full Amount
            3 Round to Full Tens Amount
            4 Fixed Ending
            5 Fixed Interval
GroupCode Group No. Int 6 - 1 1 Price List - Group No. 1
            2 Price List - Group No. 2
            3 Price List - Group No. 3
            4 Price List - Group No. 4
            5 Price List - Group No. 5
            6 Price List - Group No. 6
            7 Price List - Group No. 7
            8 Price List - Group No. 8
            9 Price List - Group No. 9
            10 Price List - Group No. 10
            11 Price List - Group No. 11
            12 Price List - Group No. 12
            13 Price List - Group No. 13
            14 Price List - Group No. 14
            15 Price List - Group No. 15
            16 Price List - Group No. 16
            17 Price List - Group No. 17
            18 Price List - Group No. 18
            19 Price List - Group No. 19
            20 Price List - Group No. 20
            21 Price List - Group No. 21
            22 Price List - Group No. 22
            23 Price List - Group No. 23
            24 Price List - Group No. 24
            25 Price List - Group No. 25
            26 Price List - Group No. 26
            27 Price List - Group No. 27
            28 Price List - Group No. 28
            29 Price List - Group No. 29
            30 Price List - Group No. 30
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
SPPCounter SPP Counter Int 11 -      
UserSign User Signature Int 6 OUSR      
IsGrossPrc Gross Price? VarChar 1 - N Y Gross
            N Net
LogInstanc Log Instance Int 11 - 0    
UserSign2 Updating User Int 6 OUSR      
UpdateDate Update Date Date 8 -      
ValidFor Active VarChar 1 - Y Y Yes
            N No
ValidFrom Active From Date 8 -      
ValidTo Active To Date 8 -      
CreateDate Creation Date Date 8 -      
PrimCurr Primary Default Curreny nVarChar 3 -      
AddCurr1 Additional Default Currency 1 nVarChar 3 -      
AddCurr2 Additional Default Currency 2 nVarChar 3 -      
RoundRule Rounding Rule VarChar 1 - R R Round to Closest
            C Round Up
            F Round Down
ExtAmount Fixed Amount (Ending/Interval) Num 19.6 -      
RndFrmtInt Ending/Interval - Integer Part nVarChar 10 -      
RndFrmtDec Ending/Interval - Decimal Part nVarChar 10 -      
Key Unique Field
PRIMARY Yes ListNum
    LogInstanc
LIST_NAME Yes ListName
    LogInstanc