Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PBACCTASGN FILE

REFERENCED BY

PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PBA-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.

PBA-PROCESS-LEVEL    Alpha 5
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

PBA-CODE-TYPE        Alpha 1
Code Type

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

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

PBA-REV-ACCT-CAT     Alpha 5
Rev Acct Cat

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

PBA-REV-SUB-ACCT     Numeric 4
Rev Sub Acct         The general ledger revenue (sales)
                     subaccount for the category.

PBA-REV-GL-CD        Alpha 4
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