APHOLDCODE – Hold Code

System
Accounts Payable (AP)
Prefix
HLD
Primary key
VENDOR-GROUP, HLD-CODE
Fields
6
Updated by
29 programs
Referenced by
278 programs

APHOLDCODE is the Hold Code table in Lawson Accounts Payable (prefix HLD). It is indexed by VENDOR-GROUP, HLD-CODE (HLDSET1). It is related 1:1 to APVENGROUP. It is updated by AP00.1, AP00.4, AP05.4, AP10.1, AP100, AP20.1, AP20.2, AP20.3 and 21 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 270 more. The table has 6 fields, 1 index and 1 documented relation.

About APHOLDCODE

The Hold Code file contains all hold code records. A hold code is used to prevent an invoice from being paid. A hold code is defined as an invoice hold code, a vendor hold code, or both. When an invoice has a hold code assigned, the invoice will not be scheduled for payment. When a vendor is placed on hold, all invoices for the vendor will not be scheduled for payment. Both vendor and invoice hold codes are defined as temporary or permanent. Temporary hold codes prevent invoices from being scheduled for payment for one payment cycle, and are removed at the end of the payment cycle by AP170 (Payment Closing). Permanent hold codes remain assigned until the codes are removed from the vendor or invoice record. Five hold codes are automatically created when a vendor group is defined: Manual Payment, Credit Balance, Prepayment, Return on Investment, and Maximum Payment hold codes. For more information, see help text for the Vendor Group file.

Fields (6)

Column = COBOL field name without the HLD- 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
#HLD-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4The vendor group. Must be a valid record in the Vendor Group file.AP00.1, AP05.4, AP100
#HLD-HLD-CODE PK
HLD_CODE		Alpha 4A user-defined code used to temporarily or permanently prevent invoices from being scheduled for payment. Hold codes can be assigned to vendors and invoices.AP00.1, AP05.4, AP100
#HLD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The hold code description.AP00.1, AP00.4, AP05.4, AP100, MA60.7, MA61.1, MA63.2, MA68.7 +1 more
#HLD-HOLD-VEN-FLAG
HOLD_VEN_FLAG		Alpha 1Indicates the type of vendor hold code. Valid values are: effective until the hold code is removed from the vendor record. effective for one cash payment cycle. AP170 (Payment Closing) removes the hold code from the vendor record.
  • P Permanent. The hold remains
  • T Temporary. The hold remains
  • Blank Not a vendor hold code.
AP00.4, AP05.4, AP100, MA60.7, MA61.1, MA63.2, MA68.7, MA69.7
#HLD-HOLD-INV-FLAG
HOLD_INV_FLAG		Alpha 1Indicates the type of invoice hold code. Valid values are: effective until the hold code is removed from the invoice record. effective for one cash payment cycle. AP170 (Payment Closing) removes the hold code from the invoice record.
  • P Permanent. The hold remains
  • T Temporary. The hold remains
  • Blank Not an invoice hold code.
AP00.1, AP00.4, AP05.4, AP100, MA60.7, MA61.1, MA63.2, MA68.7 +1 more
#HLD-ACTIVITY-FLAG
ACTIVITY_FLAG		Alpha 1Indicates whether the hold code has been used.AP00.4, AP05.4, AP10.1, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +19 more

Indexes (1)

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
HLDSET1
  1. VENDOR-GROUP
  2. HLD-CODE
PrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ApvengroupAPVENGROUPRequired
HLD-VENDOR-GROUP→VGP-VENDOR-GROUP

Programs

Updated by (29)

Referenced by (278)