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.
| 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CRMSET1 | COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR, INVOICE, SUFFIX, SEQ-NBR | Primary | AP213, AP284, AP30.4, AP305, AP35.1 | |
CRMSET2 | COMPANY, VENDOR, INVOICE, SUFFIX, SEQ-NBR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR | AP198, AP213, AP284, AP30.4, AP300, AP35.1 | ||
CRMSET3 | COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, INVOICE, SUFFIX, SEQ-NBR, CR-SEQ-NBR | 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