Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBACCTASGN


                            PBACCTASGN FILE

REFERENCED BY

PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

PBA-CODE-TYPE          Alpha 1
Element: Code Type

PBA-DEDUCT-FEE-CD      Alpha 4
Element: Deduct Fee Cd

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

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

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

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

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

                         PBACCTASGN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBASET1   COMPANY                                                PR197
          PROCESS-LEVEL
          CODE-TYPE
          DEDUCT-FEE-CD

PBASET2   DEDUCT-FEE-CD
          COMPANY
          PROCESS-LEVEL
          CODE-TYPE

PBASET3   COMPANY       Subset
          PROCESS-LEVEL Where PROCESS-LEVEL = Spaces
          CODE-TYPE
          DEDUCT-FEE-CD

                         PBACCTASGN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acctcat        ACACCTCAT    Required

                            PBA-COST-ACCT-CAT    -> AAX-ACCT-CATEGORY  (AAXSET1)

Acglcode       ACGLCODE     Required

                            PBA-REV-GL-CD        -> AGC-AC-GL-CODE

Pbfeehdr       PBFEEHDR     Required

                            PBA-DEDUCT-FEE-CD    -> PBP-FEE-CODE

Revacctcat     ACACCTCAT    Required

                            PBA-REV-ACCT-CAT     -> AAX-ACCT-CATEGORY

                         PBACCTASGN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Dedcode        DEDCODE

                            PBA-COMPANY          -> DDC-COMPANY
                                                    DDC-DED-CODE

Prsystem       PRSYSTEM

                            PBA-COMPANY          -> PRS-COMPANY
                                                    PRS-PROCESS-LEVEL