Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PBJOBCDTRN FILE

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PJT-COMPANY          Numeric 4                                   BN66.1  PR140
Company              The company number represents an            PR189   PR195
                     established company and is entered on       PR197   PR80.1
                     all function codes.                         PR85.1  PR89.1


PJT-PROCESS-LEVEL    Alpha 5                                     BN66.1  PR140
Process Level        This field contains the process level,      PR189   PR195
                     which is the reporting hierarchy below      PR197   PR80.1
                     company.                                    PR85.1  PR89.1


PJT-EMPLOYEE         Numeric 9                                   BN66.1  PR140
Employee             Contains the employee number. Each          PR189   PR195
                     person employed by the company is           PR197   PR80.1
                     assigned a unique number. The system        PR85.1  PR89.1
                     uses the employee number to correlate
                     all of the information related to that
                     person.


PJT-JOB-CODE         Alpha 9                                     BN66.1  PR140
Job Code             Contains a user-defined code that           PR189   PR195
                     represents a type of job.                   PR197   PR80.1
                                                                 PR85.1  PR89.1

PJT-CHECK-ID         Numeric 12                                  BN66.1  PR140
Internal Check ID    Contains the payment identification         PR189   PR195
Number               number (unique payment identifier used      PR197   PR80.1
                     in tracking payment information).           PR85.1  PR89.1

PJT-BILLABLE-AMT     Signed 15.2                                 BN66.1  PR140
Billable Amt                                                     PR189   PR195
                                                                 PR197   PR80.1
                                                                 PR85.1  PR89.1

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


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

                         PBJOBCDTRN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PJTSET1   COMPANY
          PROCESS-LEVEL
          EMPLOYEE
          JOB-CODE
          CHECK-ID

PJTSET2   COMPANY                                                BN66.1  PR140
          EMPLOYEE                                               PR189   PR195
          CHECK-ID                                               PR197   PR36.1
          JOB-CODE                                               PR45.1  PR80.1
          PROCESS-LEVEL                                          PR89.1

PJTSET3   COMPANY
          EMPLOYEE
          JOB-CODE
          CHECK-ID
          PROCESS-LEVEL