APCRMHIST – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
AH6- Primary key
COMPANY,VENDOR,CR-MEMO-NBR,CR-MEMO-SUFFIX,CR-SEQ-NBR,INVOICE,SUFFIX,SEQ-NBR- Fields
- 9
- Updated by
- 9 programs
- Referenced by
- 0 programs
APCRMHIST is a Lawson Accounts Payable table (prefix AH6); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR, INVOICE, SUFFIX, SEQ-NBR (AH6SET1); alternate indexes: AH6SET2. It is updated by AP180, AP181, AP190, AP198, AP28.1, AP28.2, AP300, AP305 and 1 more. The table has 9 fields, 2 indexes and 0 documented relations.
About APCRMHIST
No description in the Lawson data dictionary.
Fields (9)
Column = COBOL field name without the AH6- 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 |
|---|---|---|---|
#AH6-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | AP198 |
#AH6-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | AP198 |
#AH6-CR-MEMO-NBR PKCR_MEMO_NBR | Alpha 22 | Used to identify the invoice. | AP198 |
#AH6-CR-MEMO-SUFFIX PKCR_MEMO_SUFFIX | Numeric 3 | This is the suffix for the invoice. | AP198 |
#AH6-CR-SEQ-NBR PKCR_SEQ_NBR | Numeric 4 | — | AP198 |
#AH6-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | AP198 |
#AH6-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | AP198 |
#AH6-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | AP198 |
#AH6-AMT-APPLIEDAMT_APPLIED | Signed 18.2 | — | AP198 |
Indexes (2)
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 |
|---|---|---|---|---|
AH6SET1 |
| Primary | AP300, AP305 | |
AH6SET2 |
| AP180, AP181, AP190, AP28.1, AP28.2, AP300, AP45.1 |
Programs
Updated by (9)
- 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
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP45.1 Reportable Income Adjustment