Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                               PBFEE FILE

REFERENCED BY

PR197     PR85.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                                  PR85.1
Fee Pct

PBF-MAXIMUM-AMT      Signed 11.2                                 PR197   PR85.1
Maximum Amt

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                                                PR197   PR85.1
          PROCESS-LEVEL
          FEE-GROUP
          FEE-CODE

                         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