Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCRMEMO


                             APCRMEMO FILE

                        Credit Memo Application

The Credit Memo file contains credit memo application records.

REFERENCED BY

AP213     AP284

UPDATED BY

AP180     AP181     AP190     AP28.1    AP28.2    AP30.4
AP300     AP305     AP35.1    AP45.1    AP198

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CRM-COMPANY            Numeric 4                                 AP180   AP181
Element: Company       The company number. Must be a valid       AP190   AP28.1
                       record in the Accounts Payable Company    AP28.2  AP35.1
                       file.                                     AP45.1

CRM-VENDOR             Alpha 9  (Right Justified)                AP180   AP181
Element: Vendor        The vendor number. Must be a valid        AP190   AP28.1
                       record in the Vendor file.                AP28.2  AP35.1
                                                                 AP45.1

CRM-CR-MEMO-NBR        Alpha 22                                  AP180   AP181
Element: Credit Memo NuThe credit memo number.                   AP190   AP28.1
                                                                 AP28.2  AP35.1
                                                                 AP45.1

CRM-CR-MEMO-SUFFIX     Numeric 3                                 AP180   AP181
Element: Credit Memo SuThe credit memo suffix number. Assigned   AP190   AP28.1
                       by the system to a system generated       AP28.2  AP35.1
                       credit memo.                              AP45.1

CRM-CR-SEQ-NBR         Numeric 4                                 AP180   AP181
Element: Cr Seq Nbr    The unique sequence number assigned to    AP190   AP28.1
                       the credit memo application.              AP28.2  AP35.1
                                                                 AP45.1

CRM-INVOICE            Alpha 22                                  AP180   AP181
Element: Invoice       The invoice to which the credit memo is   AP190   AP28.1
                       applied. Must be a valid record in the    AP28.2  AP35.1
                       Accounts Payable Invoice file.            AP45.1

CRM-SUFFIX             Numeric 3                                 AP180   AP181
Element: Suffix        The occurrence value of the invoice to    AP190   AP28.1
                       which the credit memo is applied. This    AP28.2  AP35.1
                       value is created by the system for        AP45.1
                       recurring invoices and system-generated
                       credit memos.

CRM-SEQ-NBR            Numeric 4                                 AP180   AP181
Element: Seq Nbr       A unique sequence number assigned to      AP190   AP28.1
                       the invoice.                              AP28.2  AP35.1
                                                                 AP45.1

CRM-AMT-APPLIED        Signed 18.2                               AP180   AP181
Element: Intl Amt      The amount of the invoice that is         AP190   AP28.1
                       applied to the credit memo.               AP28.2  AP35.1
                                                                 AP45.1

                         APCRMEMO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CRMSET1   COMPANY                                                AP213   AP284
          VENDOR                                                 AP30.4  AP305
          CR-MEMO-NBR                                            AP35.1
          CR-MEMO-SUFFIX
          CR-SEQ-NBR
          INVOICE
          SUFFIX
          SEQ-NBR

CRMSET2   COMPANY                                                AP198   AP213
          VENDOR                                                 AP284   AP30.4
          INVOICE                                                AP300   AP35.1
          SUFFIX
          SEQ-NBR
          CR-MEMO-NBR
          CR-MEMO-SUFFIX
          CR-SEQ-NBR

CRMSET3   COMPANY                                                AP35.1
          VENDOR
          CR-MEMO-NBR
          CR-MEMO-SUFFIX
          INVOICE
          SUFFIX
          SEQ-NBR
          CR-SEQ-NBR