APCOMMENTS – Comments

System
Accounts Payable (AP)
Prefix
APC
Primary key
REC-TYPE, COMPANY, VENDOR, LOCATION-CODE, SEQ-NBR
Fields
13
Updated by
290 programs
Referenced by
20 programs

APCOMMENTS is the Comments table in Lawson Accounts Payable (prefix APC). It is indexed by REC-TYPE, COMPANY, VENDOR, LOCATION-CODE, SEQ-NBR (APCSET1); alternate indexes: APCSET2, APCSET3, APCSET4 and APCSET5. It is related 1:1 to APCOMPANY, APVENLOC and APVENMAST. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 282 more and referenced by AP10.1, AP155, AP160, AP161, AP212, AP230, AP240, AP245 and 12 more. The table has 13 fields, 5 indexes and 3 documented relations.

About APCOMMENTS

The Comments file contains comment records for vendors and invoices.

Fields (13)

Column = COBOL field name without the APC- 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 / columnTypeDescription & valuesUpdated by
#APC-REC-TYPE PK
REC_TYPE		Alpha 1The file record type. Indicates the type of comment. Valid values are:
  • I Invoice Comment.
  • V Vendor Comment.
AP115, AP12.1, AP150
#APC-COMPANY PK
COMPANY		Numeric 4The company associated with the comment. Must be a valid record in the Accounts Payable Company file.AP115, AP12.1, AP150
#APC-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor associated with the comment. Must be a valid record in the Vendor file.AP115, AP12.1, AP150
#APC-LOCATION-CODE PK
LOCATION_CODE		Alpha 4The alternate vendor location associated with the comment. Used only for vendor comments. Must be a valid record in the Vendor Location file.AP115, AP12.1, AP150
#APC-SEQ-NBR PK
SEQ_NBR		Numeric 4A unique sequence number assigned by the system to the comment.AP12.1
#APC-VENDOR-GROUP SET2 SET5
VENDOR_GROUP		Alpha 4The vendor group associated with the vendor. Must be a valid record in the Vendor Group file.AP115, AP12.1, AP150
#APC-PROC-LEVEL
PROC_LEVEL		Alpha 5The process level associated with the invoice. Used only for invoice comments. Must be a valid record in the Accounts Payable Process Level file.AP115, AP12.1
#APC-COMMENT
COMMENT		Alpha 40 (Lower Case)The comment narrative.AP12.1, AP150
#APC-PRINT-CODE
PRINT_CODE		Alpha 1Indicates the type of comment. Indicates where the comment displays and/or prints. Valid values are: inquiry screens and prints on payment forms, reports, and listings. on payment forms only. displays on inquiry screens and prints on reports and listings, but does not print on payment forms. display or print.
  • A All. Comment line displays on
  • C Check/Cheque. Comment line prints
  • D Display and Print. Comment line
  • N Notation. Comment line does not
AP115, AP12.1, AP150
#APC-BEG-DATE
BEG_DATE		Numeric 8 (yyyymmdd)The date the comment becomes valid.AP115, AP12.1, AP150
#APC-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The last date the comment is valid.AP12.1, AP150, AP252
#APC-DATE-ENTERED
DATE_ENTERED		Numeric 8 (yyyymmdd)The system date the comment was created.AP115, AP12.1, AP150
#APC-PAY-GROUP
PAY_GROUP		Alpha 4The pay group associated with the comment. Must be a valid record in the Pay Group file.AP115, AP12.1, AP150

Indexes (5)

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.

IndexKeysFlagsConditionUsed in
APCSET1
  1. REC-TYPE
  2. COMPANY
  3. VENDOR
  4. LOCATION-CODE
  5. SEQ-NBR
PrimaryAP12.1, AP212, AP220, AP300, AP912
APCSET2
  1. REC-TYPE
  2. VENDOR-GROUP
  3. VENDOR
  4. LOCATION-CODE
  5. COMPANY
  6. SEQ-NBR
KeyChange, SubsetWhere PRINT-CODE = "A" Or PRINT-CODE = "D"AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
APCSET3
  1. REC-TYPE
  2. COMPANY
  3. VENDOR
  4. LOCATION-CODE
  5. SEQ-NBR
KeyChange, SubsetWhere PRINT-CODE = "A" Or PRINT-CODE = "C"AP150, AP155, AP160, AP161, ZA161
APCSET4
  1. REC-TYPE
  2. COMPANY
  3. VENDOR
  4. LOCATION-CODE
  5. SEQ-NBR ↓
KeyChangeAP115, AP12.1, AP150
APCSET5
  1. REC-TYPE
  2. VENDOR-GROUP
  3. VENDOR
  4. LOCATION-CODE
  5. SEQ-NBR
  6. COMPANY
KeyChange, SubsetWhere (PRINT-CODE = "A") Or (PRINT-CODE = "C")AP150

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYAPVENLOCAPVENMASTAPCOMMENTS

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
APC-COMPANY→CPY-COMPANY
ApvenlocAPVENLOCRequiredWhen APC-LOCATION-CODE != Spaces
APC-VENDOR-GROUP→VLO-VENDOR-GROUP
APC-VENDOR→VLO-VENDOR
APC-LOCATION-CODE→VLO-LOCATION-CODE
ApvenmastAPVENMASTNot Required
APC-VENDOR-GROUP→VEN-VENDOR-GROUP
APC-VENDOR→VEN-VENDOR

Programs

Updated by (290)

Referenced by (20)