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
 |