Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBFEE


                               PBFEE FILE

REFERENCED BY

BN66.1    PR140     PR189     PR195     PR197     PR80.1
PR85.1    PR89.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PBF-COMPANY            Numeric 4
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

PBF-PROCESS-LEVEL      Alpha 5
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

PBF-FEE-CODE           Alpha 4
Element: Fee Code

PBF-TYPE               Alpha 2
Element: Type          This identifies whether this record is
                       created because of a picking
                       transaction, or because of a return.
                       Valid values are:
                           "IS" = Picking transaction.
                           "RR" = Return.
                        ~$1 VENDOR
                       The vendor's identification code.


PBF-AMOUNT             Currency 15.2
Element: Amount        This is the amounts by period for the
                       specified record.

PBF-FEE-PCT            Signed 7.4                                PR80.1  PR85.1
Element: Fee Pct

PBF-MAXIMUM-AMT        Signed 11.2                               BN66.1  PR140
Element: Maximum Amt                                             PR189   PR195
                                                                 PR197   PR80.1
                                                                 PR85.1  PR89.1

PBF-MINIMUM-AMT        Signed 11.2
Element: Minimum Amt

PBF-ACTIVE-FLAG        Alpha 1
Element: Status        The Active flag of the credit card
                       type.
                       A = Active
                       I = Inactive
                       H = Hold
                       O = One Time

PBF-DEDUCTION-GRP      Alpha 10
Element: Deduction Grp

PBF-GROUP-NAME         Alpha 10
Element: Group Name

PBF-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PBF-CURR-ND            Numeric 1
Account Currency
Code

PBF-FEE-TYPE           Alpha 1
Element: Fee Type      N = Normal
                       M = Manual
                       B = Both

PBF-FEE-GROUP          Alpha 10
Element: Fee Group

PBF-PAY-CLASS          Alpha 3
Element: Payment Class

                         PBFEE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBFSET1   COMPANY
          PROCESS-LEVEL
          FEE-CODE

PBFSET2   FEE-CODE
          COMPANY
          PROCESS-LEVEL

PBFSET3   COMPANY       Subset
          FEE-CODE      Where PROCESS-LEVEL = Spaces
          PROCESS-LEVEL

PBFSET4   COMPANY                                                BN66.1  PR140
          PROCESS-LEVEL                                          PR189   PR195
          FEE-GROUP                                              PR197   PR80.1
          FEE-CODE                                               PR85.1  PR89.1

                         PBFEE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pbbill         PBBILL       Required

                            PBF-COMPANY          -> PBB-COMPANY
                            PBF-PROCESS-LEVEL    -> PBB-PROCESS-LEVEL

                         PBFEE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pbtrans        PBTRANS

                            PBF-COMPANY          -> PTN-COMPANY
                            PBF-PROCESS-LEVEL    -> PTN-PROCESS-LEVEL
                                                    PTN-EMPLOYEE
                                                    PTN-CHECK-ID
                                                    PTN-DATE
                                                    PTN-FEE-CODE
                                                    PTN-SEQ-NUMBER