Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBFEE


                               PBFEE FILE

REFERENCED BY

PR197     PR85.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PBF-COMPANY            Numeric 4
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PBF-PROCESS-LEVEL      Alpha 5
Element: Process Lev HrThis 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                                PR85.1
Element: Fee Pct

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

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       Represents the number of decimals
Code                   defined for the currency of the object.

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

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