Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             APCRMEMO FILE

                        Credit Memo Application

The Credit Memo file contains credit memo application records.

REFERENCED BY

AP213     AP284

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CRM-COMPANY          Numeric 4                                   AP180   AP181
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
Vendor ID            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
Credit Memo Number   The credit memo number.                     AP190   AP28.1
                                                                 AP28.2  AP35.1
                                                                 AP45.1

CRM-CR-MEMO-SUFFIX   Numeric 3                                   AP180   AP181
Credit Memo Suffix   The 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
Credit Memo          The unique sequence number assigned to      AP190   AP28.1
Sequence Number      the credit memo application.                AP28.2  AP35.1
                                                                 AP45.1

CRM-INVOICE          Alpha 22                                    AP180   AP181
Invoice Number       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
Invoice 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
Sequence Number      A unique sequence number assigned to        AP190   AP28.1
                     the invoice.                                AP28.2  AP35.1
                                                                 AP45.1

CRM-AMT-APPLIED      Signed 15.2                                 AP180   AP181
Applied Amount       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       This index is used to access and         AP213   AP284
          VENDOR        validate credit memo application records AP30.4  AP305
          CR-MEMO-NBR   created in AP35 (Credit Memo             AP35.1
          CR-MEMO-SUFFIXApplication).
          CR-SEQ-NBR
          INVOICE
          SUFFIX
          SEQ-NBR

CRMSET2   COMPANY       This index is used to access credit      AP198   AP213
          VENDOR        memo application(s) for a specific       AP284   AP30.4
          INVOICE       invoice.                                 AP300   AP35.1
          SUFFIX
          SEQ-NBR
          CR-MEMO-NBR
          CR-MEMO-SUFFIX
          CR-SEQ-NBR

CRMSET3   COMPANY       This index is used to access credit      AP35.1
          VENDOR        memo application records.
          CR-MEMO-NBR
          CR-MEMO-SUFFIX
          INVOICE
          SUFFIX
          SEQ-NBR
          CR-SEQ-NBR