Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCOMMENTS


                            APCOMMENTS FILE

                                Comments

The Comments file contains comment records for vendors and invoices.

REFERENCED BY

AP212     AP220     AP912     AP10.1    AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.6    AP20.7    AP20.8
AP210     AP23.1    AP230     AP240     AP245     AP250
AP252     AP30.1    AP30.2    AP30.3    AP32.2    AP35.1
AP40.1    AP40.2    AP90.1    AP90.2    AP90.3    AP90.4
AP91.1    AP92.1    AP95.1    AP96.1    MA41.2    MA43.2
AP150     AP155     AP160     AP161

UPDATED BY

AP115     AP12.1    AP300     AM115     AM15.1    AM15.2
AM15.3    AM15.4    AM20.1    AM20.3    AM21.1    AM21.3
AM500     AM51.1    AM551     AM97.1    API3.1    API4.1
IC840     PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    PR514     UK47.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APC-REC-TYPE           Alpha 1                                   AP115   AP12.1
Element: Record Type   The file record type. Indicates the
                       type of comment. Valid values are:

                       I = Invoice Comment.
                       V = Vendor Comment.

APC-COMPANY            Numeric 4                                 AP115   AP12.1
Element: Company       The company associated with the
                       comment. Must be a valid record in the
                       Accounts Payable Company file.

APC-VENDOR             Alpha 9  (Right Justified)                AP115   AP12.1
Element: Vendor ID     The vendor associated with the comment.
                       Must be a valid record in the Vendor
                       file.

APC-LOCATION-CODE      Alpha 4                                   AP115   AP12.1
Purchase From          The alternate vendor location
Location Code          associated with the comment. Used only
                       for vendor comments. Must be a valid
                       record in the Vendor Location file.

APC-SEQ-NBR            Numeric 4                                 AP12.1
Element: Sequence NumbeA unique sequence number assigned by
                       the system to the comment.

APC-VENDOR-GROUP       Alpha 4                                   AP115   AP12.1
Element: Vendor Group  The vendor group associated with the
                       vendor. Must be a valid record in the
                       Vendor Group file.

APC-PROC-LEVEL         Alpha 5                                   AP115   AP12.1
Element: Process Level The process level associated with the
                       invoice. Used only for invoice comments.
                       Must be a valid record in the Accounts
                       Payable Process Level file.

APC-COMMENT            Alpha 40  (Lower Case)                    AP12.1
Element: Comment       The comment narrative.

APC-PRINT-CODE         Alpha 1                                   AP115   AP12.1
Element: Comment Type  Indicates the type of comment.
                       Indicates where the comment displays
                       and/or prints. Valid values are:

                       A = All. Comment line displays on
                       inquiry screens and prints on payment
                       forms, reports, and listings.

                       C = Check/Cheque. Comment line prints
                       on payment forms only.

                       D = Display and Print. Comment line
                       displays on inquiry screens and prints
                       on reports and listings, but does not
                       print on payment forms.

                       N = Notation. Comment line does not
                       display or print.

APC-BEG-DATE           Numeric 8  (yyyymmdd)                     AP115   AP12.1
Element: Date          The date the comment becomes valid.

APC-END-DATE           Numeric 8  (yyyymmdd)                     AP12.1  AP252
Element: Date          The last date the comment is valid.

APC-DATE-ENTERED       Numeric 8  (yyyymmdd)                     AP115   AP12.1
Element: Date          The system date the comment was created.

APC-PAY-GROUP          Alpha 4                                   AP115   AP12.1
Element: Pay Group     The pay group associated with the
                       comment. Must be a valid record in the
                       Pay Group file.

                         APCOMMENTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APCSET1   REC-TYPE      This index is used to add comment lines  AP12.1  AP212
          COMPANY       or determine whether comments exist for  AP220   AP300
          VENDOR        a particular invoice or vendor.          AP912
          LOCATION-CODE
          SEQ-NBR

APCSET2   REC-TYPE      This index is used to determine whether  AM115   AM15.1
          VENDOR-GROUP  a message display indicating that        AM15.2  AM15.3
          VENDOR        comments exist should display.           AM15.4  AM20.1
          LOCATION-CODE KeyChange, Subset                        AM20.3  AM21.1
          COMPANY       Where PRINT-CODE = "A"                   AM21.3  AM500
          SEQ-NBR       Or    PRINT-CODE = "D"                   AM51.1  AM551
                                                                 AM97.1  AP10.1
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP20.8
                                                                 AP210   AP23.1
                                                                 AP230   AP240
                                                                 AP245   AP250
                                                                 AP252   AP30.1
                                                                 ...

APCSET3   REC-TYPE      This index is used to access comments    AP150   AP155
          COMPANY       lines for printing on a vendor's         AP160   AP161
          VENDOR        remittance.
          LOCATION-CODE KeyChange, Subset
          SEQ-NBR       Where PRINT-CODE = "A"
                        Or    PRINT-CODE = "C"

APCSET4   REC-TYPE      This index is used in AP12 for           AP115   AP12.1
          COMPANY       resequencing purposes.
          VENDOR        KeyChange
          LOCATION-CODE
          SEQ-NBR*

APCSET5   REC-TYPE      This index is used to determine if a     AP150
          VENDOR-GROUP  comment exists for a vendor, regardless
          VENDOR        of the company origin.
          LOCATION-CODE KeyChange, Subset
          SEQ-NBR       Where (PRINT-CODE = "A" )
          COMPANY       Or    (PRINT-CODE = "C" )

                         APCOMMENTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            APC-COMPANY          -> CPY-COMPANY

Apvenloc       APVENLOC     Required
                            When APC-LOCATION-CODE != Spaces

                            APC-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            APC-VENDOR           -> VLO-VENDOR
                            APC-LOCATION-CODE    -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Not Required

                            APC-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            APC-VENDOR           -> VEN-VENDOR