Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBBLJOBCD


                             PBBLJOBCD FILE

REFERENCED BY

PR197     PR85.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PBJ-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.

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

PBJ-JOB-CODE           Alpha 9
Element: Job Code      Contains a user-defined code that
                       represents a type of job.

PBJ-DEDUCTION-GRP      Alpha 10
Element: Deduction Grp

PBJ-COST-ACCT-CAT      Alpha 5
Element: Cost Acct Cat

PBJ-REV-ACCT-CAT       Alpha 5
Element: Account Category

PBJ-REV-ACCOUNT        Numeric 6
Element: Account       This field represents the general
                       ledger revenue (sales) account for the
                       category.

PBJ-REV-SUB-ACCT       Numeric 4
Element: Subaccount    The general ledger revenue (sales)
                       subaccount for the category.

PBJ-REV-GL-CD          Alpha 4
Element: Rev Gl Cd

PBJ-CALC-OPTION        Alpha 1
Element: Calc Option   The Calc Option field determines
                       whether the data mart should be
                       completely calculated (Essbase Calc All)
                       after the outline is built and the data
                       values have been loaded.

                       Valid values are:
                       Y = Yes; Default value.
                       N = No
                       L = Lowest
                       H = Highest
                       P = Prorate

                         PBBLJOBCD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBJSET1   COMPANY                                                PR197   PR85.1
          PROCESS-LEVEL
          JOB-CODE

                         PBBLJOBCD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pbbljobcdx     PBBLJOBCDX

                            PBJ-COMPANY          -> PBN-COMPANY
                            PBJ-PROCESS-LEVEL    -> PBN-PROCESS-LEVEL
                            PBJ-JOB-CODE         -> PBN-JOB-CODE
                                                    PBN-SEQUENCE-NBR