Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBTRANS


                              PBTRANS FILE

UPDATED BY

PR197     PR85.1    PR36.1    PR45.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PTN-COMPANY            Numeric 4                                 PR197   PR85.1
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.

PTN-PROCESS-LEVEL      Alpha 5                                   PR197   PR85.1
Element: Process Lev HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

PTN-DATE               Numeric 8  (yyyymmdd)                     PR197   PR85.1
Element: Date          This field displays the system date
                       when this was created.

PTN-FEE-CODE           Alpha 4                                   PR197   PR85.1
Element: Fee Code

PTN-SEQ-NUMBER         Numeric 6                                 PR197   PR85.1
Record Sequence        A unique number assigned to each
Number                 transaction to be interfaced into the
                       Lawson system.

PTN-PROGRAM            Alpha 5                                   PR197   PR85.1
Element: Program       This field designates the program this
                       record was created by

PTN-DESCRIPTION        Alpha 30  (Lower Case)                    PR197   PR85.1
Element: Description   This field displays the description.

PTN-UNITS              Signed 15.2
Element: Unit          The element that explains the activity.
                       For example, a unit would be the number
                       of computers purchased.


PTN-BILLABLE-AMT       Signed 15.2                               PR197   PR85.1
Element: Billable Amt

PTN-STATUS             Numeric 1                                 PR197   PR85.1
Element: Status        This field displays the status of the
                       transaction.

PTN-DATE-STAMP         Numeric 8  (yyyymmdd)                     PR197
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

PTN-TIME-STAMP         Numeric 6  (hhmmss)                       PR197
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

PTN-EMPLOYEE           Numeric 9                                 PR197   PR85.1
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

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

PTN-CURR-ND            Numeric 1
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

PTN-CHECK-ID           Numeric 12                                PR197   PR85.1
Internal Check ID      Contains the payment identification
Number                 number (unique payment identifier used
                       in tracking payment information).

                         PBTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTNSET1   COMPANY                                                PR197   PR36.1
          PROCESS-LEVEL                                          PR45.1  PR85.1
          EMPLOYEE
          CHECK-ID
          DATE
          FEE-CODE
          SEQ-NUMBER

PTNSET2   COMPANY       Subset
          PROCESS-LEVEL Where (PROGRAM = "PB140" )
          EMPLOYEE      And   (STATUS  = 1 )
          CHECK-ID
          DATE
          FEE-CODE
          SEQ-NUMBER

PTNSET3   COMPANY       Subset
          PROCESS-LEVEL Where (PROGRAM  = "PB40 " )
          EMPLOYEE      And   (EMPLOYEE = Zeroes )
          CHECK-ID      And  ((STATUS   = Zeroes )
          DATE          Or    (STATUS   = 1 ))
          FEE-CODE
          SEQ-NUMBER

PTNSET4   COMPANY       Subset
          DATE-STAMP    Where STATUS = 9
          TIME-STAMP
          PROCESS-LEVEL
          EMPLOYEE
          CHECK-ID
          DATE
          FEE-CODE
          SEQ-NUMBER

PTNSET5   COMPANY       Subset                                   PR197   PR85.1
          PROCESS-LEVEL Where STATUS = 1
          EMPLOYEE
          CHECK-ID
          DATE
          FEE-CODE
          SEQ-NUMBER

                         PBTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            PTN-COMPANY     -> EMP-COMPANY
                            PTN-EMPLOYEE    -> EMP-EMPLOYEE