APCATTACH – No description in the Lawson data dictionary
- System
- Accounts Payable (AP)
- Prefix
AAP- Primary key
COMPANY,VENDOR,INVOICE,SUFFIX,COMMENT-NAME,CMT-SEQ-NBR- Fields
- 8
- Updated by
- 3 programs
- Referenced by
- 0 programs
APCATTACH is a Lawson Accounts Payable table (prefix AAP); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, COMMENT-NAME, CMT-SEQ-NBR (AAPSET1). It is updated by AP52.1, AP52.9 and AP520. The table has 8 fields, 1 index and 0 documented relations.
About APCATTACH
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the AAP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AAP-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. | AP52.9 |
AAP-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | AP52.9 |
AAP-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | AP52.9 |
AAP-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | AP52.9 |
AAP-CMT-SEQ-NBR PKCMT_SEQ_NBR | Numeric 1 | Up to ten comment text strings can be included to a comment name. Valid values are 0 through 9. | AP52.9 |
AAP-COMMENT-NAME PKCOMMENT_NAME | Alpha 50 (Lower Case) | This field contains the text you enter for the comment to be associated with an asset. You can have multiple lines of comments for each comment type. | AP52.9 |
AAP-COMMENT-TYPECOMMENT_TYPE | Alpha 2 | — | — |
AAP-APCOMMENT-TEXTAPCOMMENT_TEXT | Alpha 205 (Lower Case) | Textual information references applied to comment. | AP52.9 |
Indexes (1)
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 |
|---|---|---|---|---|
AAPSET1 | COMPANY, VENDOR, INVOICE, SUFFIX, COMMENT-NAME, CMT-SEQ-NBR | Primary | AP52.1, AP52.3, AP52.9, AP520 |