APCRMEMO – Credit Memo Application
- System
- Accounts Payable (AP)
- Prefix
CRM- Primary key
COMPANY,VENDOR,CR-MEMO-NBR,CR-MEMO-SUFFIX,CR-SEQ-NBR,INVOICE,SUFFIX,SEQ-NBR- Fields
- 9
- Updated by
- 11 programs
- Referenced by
- 2 programs
APCRMEMO is the Credit Memo Application table in Lawson Accounts Payable (prefix CRM). It is indexed by COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR, INVOICE, SUFFIX, SEQ-NBR (CRMSET1); alternate indexes: CRMSET2 and CRMSET3. It is updated by AP180, AP181, AP190, AP198, AP28.1, AP28.2, AP30.4, AP300 and 3 more and referenced by AP213 and AP284. The table has 9 fields, 3 indexes and 0 documented relations.
About APCRMEMO
The Credit Memo file contains credit memo application records.
Fields (9)
Column = COBOL field name without the CRM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#CRM-COMPANY PKCOMPANY | Numeric 4 | The company number. Must be a valid record in the Accounts Payable Company file. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
#CRM-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor number. Must be a valid record in the Vendor file. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
#CRM-CR-MEMO-NBR PKCR_MEMO_NBR | Alpha 22 | The credit memo number. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
#CRM-CR-MEMO-SUFFIX PKCR_MEMO_SUFFIX | Numeric 3 | The credit memo suffix number. Assigned by the system to a system generated credit memo. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
#CRM-CR-SEQ-NBR PKCR_SEQ_NBR | Numeric 4 | The unique sequence number assigned to the credit memo application. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
#CRM-INVOICE PKINVOICE | Alpha 22 | The invoice to which the credit memo is applied. Must be a valid record in the Accounts Payable Invoice file. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
#CRM-SUFFIX PKSUFFIX | Numeric 3 | The occurrence value of the invoice to which the credit memo is applied. This value is created by the system for recurring invoices and system-generated credit memos. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
#CRM-SEQ-NBR PKSEQ_NBR | Numeric 4 | A unique sequence number assigned to the invoice. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
#CRM-AMT-APPLIEDAMT_APPLIED | Signed 18.2 | The amount of the invoice that is applied to the credit memo. | AP180, AP181, AP190, AP28.1, AP28.2, AP35.1, AP45.1 |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CRMSET1 |
| Primary | AP213, AP284, AP30.4, AP305, AP35.1 | |
CRMSET2 |
| AP198, AP213, AP284, AP30.4, AP300, AP35.1 | ||
CRMSET3 |
| AP35.1 |
Programs
Updated by (11)
- AP180 Bill of Exchange Cashing Update
- AP181 Bill of Exchange Statement Update
- AP190 Invoice Reinstatement
- AP198 Invoice Data Archival
- AP28.1 Bill of Exchange Acceptance by Vendor
- AP28.2 Bill of Exchange Acceptance by Date
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP35.1 Credit Memo Application
- AP45.1 Reportable Income Adjustment