Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                               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
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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


PBF-FEE-CODE         Alpha 4
Fee Code

PBF-TYPE             Alpha 2
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
Amount               This is the amounts by period for the
                     specified record.

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

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

PBF-MINIMUM-AMT      Signed 11.2
Minimum Amt

PBF-ACTIVE-FLAG      Alpha 1
Status               The Active flag of the credit card
                     type.

                     A = Active
                     I = Inactive
                     H = Hold
                     O = One Time

PBF-DEDUCTION-GRP    Alpha 10
Deduction Grp

PBF-GROUP-NAME       Alpha 10
Group Name

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


PBF-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

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

PBF-FEE-GROUP        Alpha 10
Fee Group

PBF-PAY-CLASS        Alpha 3
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