Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              APAUDIT FILE

                          Vendor-Invoice Audit

The Vendor-Invoice Audit file contains audit records for additions, changes,
deletions, and cancellations for vendor and invoice records. Changes to
vendors are recorded for vendor groups that audit vendor changes. Changes to
released invoices are recorded for companies that audit invoice changes.

UPDATED BY

AP10.1    AP10.3    AP10.5    AP10.6    AP10.9    AP115
AP135     AP30.1    AP30.2    AP30.3    AP30.4    AP32.2
AP40.1    AP40.2    AP43.1    AP45.1    API3.1    API4.1
IC840     MA70.1    PO10.1    PO10.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

APA-VENDOR-GROUP     Alpha 4                                     AP10.1  AP10.3
Vendor Group         If the audit record is for a vendor,        AP10.5  AP10.6
                     this field contains the vendor group        AP10.9  AP115
                     assigned to the vendor. Must be a valid     AP30.1  AP30.2
                     record in the Vendor Group file.            AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-COMPANY          Numeric 4                                   AP10.1  AP10.3
Company              If the audit record is for an invoice,      AP10.5  AP10.6
                     this field contains the company number      AP10.9  AP115
                     assigned to the invoice. Must be a valid    AP30.1  AP30.2
                     record in the Accounts Payable Company      AP30.3  AP30.4
                     file.                                       AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-PROC-LEVEL       Alpha 5                                     AP30.1  AP30.2
Process Level        The process level associated with the       AP30.3  AP30.4
                     invoice audit record. Must be a valid       AP32.2  AP40.1
                     record in the Accounts Payable Process      AP40.2  AP43.1
                     Level file.                                 AP45.1  MA70.1

APA-VENDOR           Alpha 9  (Right Justified)                  AP10.1  AP10.3
Vendor ID            The vendor number associated with the       AP10.5  AP10.6
                     audit record. Must be a valid record in     AP10.9  AP115
                     the Vendor file.                            AP30.1  AP30.2
                                                                 AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-INVOICE          Alpha 22                                    AP30.1  AP30.2
Invoice Number       The invoice number associated with the      AP30.3  AP30.4
                     invoice audit record.                       AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  MA70.1

APA-SUFFIX           Numeric 3                                   AP30.1  AP30.2
Invoice Suffix       The invoice suffix number associated        AP30.3  AP30.4
                     with the invoice audit record. A suffix     AP32.2  AP40.1
                     number is assigned by the system to         AP40.2  AP43.1
                     recurring invoices or system-generated      AP45.1  MA70.1
                     credit memos.

APA-CANCEL-SEQ       Numeric 4                                   AP30.1  AP30.2
Cancel Sequence      The sequence number assigned upon a         AP30.3  AP30.4
                     cancellation of a distributed invoice.      AP32.2  AP40.1
                     The first sequence assigned is 9999.        AP40.2  AP43.1
                                                                 AP45.1  MA70.1

APA-SEQ-NBR          Numeric 4                                   AP10.1  AP10.3
Sequence Number      The invoice payment sequence number.        AP10.5  AP10.6
                                                                 AP10.9  AP115
                                                                 AP30.1  AP30.2
                                                                 AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-TRANS-DATE       Numeric 8  (yyyymmdd)                       AP10.1  AP10.3
Transaction Date     The date the audit record was created.      AP10.5  AP10.6
                                                                 AP10.9  AP115
                                                                 AP30.1  AP30.2
                                                                 AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-TRANS-TIME       Numeric 6  (hhmmss)                         AP10.1  AP10.3
Transaction Time     The system time the audit record was        AP10.5  AP10.6
                     created.                                    AP10.9  AP115
                                                                 AP30.1  AP30.2
                                                                 AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-REC-TYPE         Alpha 1                                     AP10.1  AP10.3
Record Type          Indicates the type of audit record.         AP10.5  AP10.6
                     Valid values are:                           AP10.9  AP115
                                                                 AP30.1  AP30.2
                     I = Invoice Audit Record.                   AP30.3  AP30.4
                     V = Vendor Audit Record.                    AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-VENDOR-SNAME     Alpha 30                                    AP10.1  AP10.3
Vendor Search Name   The search name defined for the vendor      AP10.5  AP10.6
                     in the Vendor file at the time the audit    AP10.9  AP115
                     record was created.                         AP30.1  AP30.2
                                                                 AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-VEN-CLASS        Alpha 3                                     AP10.1  AP10.3
Vendor Class         The vendor class the vendor was             AP10.5  AP10.6
                     assigned to at the time the audit record    AP10.9  AP115
                     was created. Must be a valid record in      AP30.1  AP30.2
                     the Vendor Class file.                      AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-LOCATION-CODE    Alpha 4                                     AP10.1  AP10.5
Location Code        The alternate vendor location code          AP10.6  AP10.9
                     associated with the audit record. Must      AP115   AP30.1
                     be a valid record in the Vendor Location    AP30.2  AP30.3
                     file.                                       AP30.4  AP32.2
                                                                 AP40.1  AP40.2
                                                                 AP43.1  AP45.1
                                                                 API3.1  API4.1
                                                                 IC840   MA70.1
                                                                 PO10.1  PO10.2

APA-OPERATOR         Alpha 10                                    AP10.1  AP10.3
Operator Code        The operator associated with the            AP10.5  AP10.6
                     invoice audit record.                       AP10.9  AP115
                                                                 AP30.1  AP30.2
                                                                 AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP43.1  AP45.1
                                                                 API3.1  API4.1
                                                                 IC840   MA70.1
                                                                 PO10.1  PO10.2

APA-FIELD-ID         Numeric 3                                   AP10.1  AP10.3
Field ID             The value for this field comes from a       AP10.5  AP10.6
                     table in working storage. Indicates the     AP10.9  AP115
                     vendor or invoice field that was            AP30.1  AP30.2
                     changed.                                    AP30.3  AP30.4
                     001 = Vendor Class                          AP32.2  AP40.1
                     002 = Vendor Name                           AP40.2  AP43.1
                     003 = Vendor Search Name                    AP45.1  API3.1
                     004 = Vendor Contact                        API4.1  IC840
                     005 = Address 1                             MA70.1  PO10.1
                     006 = Address 2                             PO10.2
                     007 = Address 3
                     008 = Address 4
                     009 = City/Address 5
                     010 = State/Province
                     011 = Postal Code
                     012 = Country
                     013 = Normal Remit-To Flag
                     014 = Normal Purchase-From Flag
                     015 = Pay Vendor
                     016 = Vendor Status
                     017 = Vendor Priority
                     018 = Phone Prefix
                     019 = Phone Number
                     020 = Phone Extension
                     021 = FAX Prefix
                     022 = FAX Number
                     023 = FAX Extension
                     024 = Telex Number
                     025 = Terms Code
                     026 = Invoice Currency
                     027 = Balance Currency
                     028 = Tax Code
                     029 = Hold Code
                     030 = Distribution Code
                     031 = Accrual Code
                     032 = Payment Type
                     033 = Bank Code
                     034 = Bank Identification Number
                     035 = Bank Account Number
                     036 = Bank Account Type
                     037 = Income Code
                     038 = Tax Identification Number
                     039 = Income Withholding Flag
                     040 = EDI Prefix
                     041 = EDI Number
                     042 = Vendor Legal Name
                     044 = ACH Prenotification Flag
                     045 = Maximum Invoice Amount
                     046 = Origin Date
                     047 = Operator
                     048 = User Field 1
                     049 = User Field 2
                     050 = User Field 3
                     051 = User Field 4
                     052 = User Field 5
                     053 = User Field 6
                     054 = Currency Recalculation Flag
                     055 = Region
                     056 = Country Code
                     090 = Vendor Added
                     091 = Vendor Location Added
                     098 = One-Time Vendor Added
                     099 = Vendor Location Deleted
                     100 = Location Type
                     101 = Normal Remit-To Flag
                     102 = Normal Purchase-From Flag
                     103 = Remit-To Code
                     501 = Invoice Canceled
                     502 = Process Level
                     503 = Accrual Code
                     504 = Voucher Number
                     505 = Pay To Vendor
                     506 = Purchase Order
                     507 = Remit To Code
                     510 = Invoice Description
                     511 = Invoice Amount
                     512 = Base Invoice Amount
                     513 = Discount Amount
                     514 = Base Discount Amount
                     515 = Tax Amount
                     519 = Bank Code
                     520 = Hold Code
                     521 = Income Code
                     522 = Payment Group
                     523 = Pay Immediately Flag
                     524 = Separate Payment Flag
                     525 = Enclosure Flag
                     526 = Number of Recurring Payments
                     527 = Recurring Frequency

APA-BEFORE-IMAGE     Alpha 32                                    AP10.1  AP10.5
Before Change Image  The image of the field before the           AP10.6  AP10.9
                     change.                                     AP115   AP30.1
                                                                 AP30.2  AP30.3
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-AFTER-IMAGE      Alpha 32                                    AP10.1  AP10.3
After Change Image   The image of the field after the change.    AP10.5  AP10.6
                                                                 AP10.9  AP115
                                                                 AP30.1  AP30.2
                                                                 AP30.3  AP30.4
                                                                 AP32.2  AP40.1
                                                                 AP40.2  AP43.1
                                                                 AP45.1  API3.1
                                                                 API4.1  IC840
                                                                 MA70.1  PO10.1
                                                                 PO10.2

APA-PRT-STATUS       Numeric 1
Print Status         This field is not currently used.

                         APAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APASET1   VENDOR-GROUP  This is a unique index used to access    AP135   AP40.2
          COMPANY       audit file records.
          PROC-LEVEL    KeyChange
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          TRANS-DATE
          TRANS-TIME

APASET2   VENDOR-GROUP  This index is used to access vendor      AP10.1  AP10.3
          VENDOR        audit records.                           AP10.5  AP10.6
          LOCATION-CODE KeyChange, Subset                        AP10.9  AP115
          TRANS-DATE    Where REC-TYPE = "V"                     AP135   API3.1
          TRANS-TIME                                             API4.1  IC840
          SEQ-NBR                                                PO10.1  PO10.2

APASET3   COMPANY       This index is used to access invoice     AP135   AP30.1
          PROC-LEVEL    audit records.                           AP30.2  AP30.3
          VENDOR        KeyChange, Subset                        AP30.4  AP32.2
          INVOICE       Where REC-TYPE = "I"                     AP40.1  AP43.1
          SUFFIX                                                 AP45.1  MA70.1
          CANCEL-SEQ
          TRANS-DATE
          TRANS-TIME
          SEQ-NBR

                         APAUDIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required
                            When APA-REC-TYPE = "I"

                            APA-COMPANY          -> CPY-COMPANY

Approclev      APPROCLEV    Required
                            When APA-REC-TYPE = "I"

                            APA-COMPANY          -> APR-COMPANY
                            APA-PROC-LEVEL       -> APR-PROC-LEVEL

Apvenclass     APVENCLASS   Not Required

                            APA-VENDOR-GROUP     -> VCL-VENDOR-GROUP
                            APA-VEN-CLASS        -> VCL-VEN-CLASS

Apvengroup     APVENGROUP   Required
                            When APA-REC-TYPE = "V"

                            APA-VENDOR-GROUP     -> VGP-VENDOR-GROUP

Apvenloc       APVENLOC     Required
                            When APA-REC-TYPE = "V"

                            APA-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            APA-VENDOR           -> VLO-VENDOR
                            APA-LOCATION-CODE    -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Required

                            APA-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            APA-VENDOR           -> VEN-VENDOR