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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APCSET1REC-TYPE, COMPANY, VENDOR, LOCATION-CODE, SEQ-NBRPrimaryAP12.1, AP212, AP220, AP300, AP912
APCSET2REC-TYPE, VENDOR-GROUP, VENDOR, LOCATION-CODE, COMPANY, SEQ-NBRKeyChange, 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)
APCSET3REC-TYPE, COMPANY, VENDOR, LOCATION-CODE, SEQ-NBRKeyChange, SubsetWhere PRINT-CODE = "A" Or PRINT-CODE = "C"AP150, AP155, AP160, AP161, ZA161
APCSET4REC-TYPE, COMPANY, VENDOR, LOCATION-CODE, SEQ-NBR*KeyChangeAP115, AP12.1, AP150
APCSET5REC-TYPE, VENDOR-GROUP, VENDOR, LOCATION-CODE, SEQ-NBR, COMPANYKeyChange, SubsetWhere (PRINT-CODE = "A") Or (PRINT-CODE = "C")AP150

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredAPC-COMPANY → CPY-COMPANY
ApvenlocAPVENLOCRequiredWhen APC-LOCATION-CODE != SpacesAPC-VENDOR-GROUP → VLO-VENDOR-GROUP, APC-VENDOR → VLO-VENDOR, APC-LOCATION-CODE → VLO-LOCATION-CODE
ApvenmastAPVENMASTNot RequiredAPC-VENDOR-GROUP → VEN-VENDOR-GROUP, APC-VENDOR → VEN-VENDOR

Programs

Updated by (290)

Referenced by (20)