Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PDPROGCOMP


                            PDPROGCOMP FILE

REFERENCED BY

PD10.2    PD10.3    PD130     PD20.1    PD20.2    PD20.3
PD230     PD570

UPDATED BY

PD01.1    PD01.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PGC-PCARD-PROGRAM      Alpha 10                                  PD01.2
Element: Pcard Program

PGC-COMPANY            Numeric 4                                 PD01.2
Element: Company       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.

PGC-CLG-ACCOUNT        Numeric 6                                 PD01.2
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

PGC-CLG-ACCT-UNIT      Alpha 15                                  PD01.2
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


PGC-CLG-SUB-ACCT       Numeric 4                                 PD01.2
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

PGC-TAX-ACCOUNT        Numeric 6                                 PD01.2
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

PGC-TAX-ACCT-UNIT      Alpha 15                                  PD01.2
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


PGC-TAX-SUB-ACCT       Numeric 4                                 PD01.2
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

PGC-DIST-COMPANY       Numeric 4                                 PD01.2
Element: Company       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.

PGC-AUTH-CODE          Alpha 3                                   PD01.2
Element: Auth Code     A user-defined code representing a
                       person or department responsible for
                       approving a registered invoice.

                         PDPROGCOMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGCSET1   PCARD-PROGRAM                                          PD01.1  PD01.2
          COMPANY                                                PD10.2  PD10.3
                                                                 PD130   PD20.1
                                                                 PD20.2  PD20.3
                                                                 PD230   PD570

                         PDPROGCOMP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pdcardcomp     PDCARDCOMP   Required

                            PGC-PCARD-PROGRAM    -> PCA-PCARD-PROGRAM
                            Zeroes               -> PCA-REQUEST-NBR
                            PGC-COMPANY          -> PCA-COMPANY

                         PDPROGCOMP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pdcard         PDCARD

                            PGC-PCARD-PROGRAM    -> PDC-PCARD-PROGRAM
                                                    PDC-REQUEST-NBR