Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             APAUTHOR FILE

                             Authority Code

The Authority Code file contains authority codes. Authority codes are
required for companies that have Yes selected in the Invoice Approval Option
field and No selected in the Batch Release Option field. An authority code
must be assigned to a registered invoice before the invoice can be released.

Authority codes can also be used for a company that has Yes selected in both
invoice entry option fields, but an authority code is not required for release
in this case.

REFERENCED BY

AP10.5    AP10.1    AP126     AP205     AP226     AP236
AP239     AP26.1    AP36.1    AP520     AP110     AP510

UPDATED BY

AP05.6    AP20.1    AP20.2    AP20.5    AP20.6    AP20.7
AP23.1    AP305     AP950     MA40.1    MA40.2    MA41.1
MA41.2    MA41.4    MA41.5    MA41.6    MA43.1    MA43.2
MA43.3    MA43.4    MA52.1    MA530     MA540     PO31.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ATR-COMPANY          Numeric 4                                   AP05.6  AP950
Company              The company number. Must be a valid
                     record in the Accounts Payable Company
                     file.

ATR-AUTH-CODE        Alpha 3                                     AP05.6  AP950
Authority Code       The user-defined authority code.
                     Identifies the person or department
                     responsible for approving a registered
                     invoice.

ATR-DESCRIPTION      Alpha 30  (Lower Case)                      AP05.6  AP236
Description          The description of the authority code.      AP239   AP520
                                                                 AP950

ATR-ACTIVITY-FLAG    Alpha 1                                     AP05.6  AP20.1
Used                 Indicates whether the authority code        AP20.2  AP20.5
                     has been used.                              AP20.6  AP20.7
                                                                 AP23.1  AP950
                                                                 MA40.1  MA40.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.5
                                                                 MA41.6  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA52.1
                                                                 MA530   MA540
                                                                 PO31.1

ATR-VENDOR-GROUP     Alpha 4                                     AP05.6  AP950
Vendor Group         The vendor group associated with the
                     authority code company.

                         APAUTHOR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATRSET1   COMPANY       This index is used to validate an        AP05.6  AP10.5
          AUTH-CODE     authority code within an accounts        AP126   AP20.1
                        payable company.                         AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP205   AP226
                                                                 AP23.1  AP236
                                                                 AP239   AP26.1
                                                                 AP305   AP36.1
                                                                 AP520   MA40.1
                                                                 MA40.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA530
                                                                 ...

ATRSET2   VENDOR-GROUP  This index is used to validate an        AP10.1  AP110
          AUTH-CODE     authority code within an Accounts        AP510
                        Payable vendor group.
                        KeyChange, Duplicates

ATRSET3   AUTH-CODE     This index is used by the Accounts       AP205
                        Payable Codes Listing program.
                        KeyChange, Duplicates

                         APAUTHOR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            ATR-COMPANY      -> CPY-COMPANY

                         APAUTHOR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apinvoice      APINVOICE    Delete Restricted

                            ATR-COMPANY      -> API-COMPANY
                            Zeroes           -> API-BATCH-NUM
                            ATR-AUTH-CODE    -> API-AUTH-CODE
                                                API-VOUCHER-NBR
                                                API-VENDOR
                                                API-INVOICE
                                                API-SUFFIX
                                                API-CANCEL-SEQ