APHLDPARAM – Hold Group Parameter

System
Accounts Payable (AP)
Prefix
AHL
Primary key
HOLD-JOB-NAME, PARAM-GROUP
Fields
16
Updated by
1 program
Referenced by
1 program

APHLDPARAM is the Hold Group Parameter table in Lawson Accounts Payable (prefix AHL). It is indexed by HOLD-JOB-NAME, PARAM-GROUP (AHLSET1). It is updated by AP41.1 and referenced by AP141. The table has 16 fields, 1 index and 0 documented relations.

About APHLDPARAM

The Hold Group Parameter file contains the defining parameters for an Accounts Payable Hold Group.

Fields (16)

Column = COBOL field name without the AHL- 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
#AHL-HOLD-JOB-NAME PK
HOLD_JOB_NAME		Alpha 10—AP41.1
#AHL-PARAM-GROUP PK
PARAM_GROUP		Alpha 15The hold group code.AP41.1
#AHL-HOLD-CODE
HOLD_CODE		Alpha 4The hold code.AP41.1
#AHL-HOLD-ACTION
HOLD_ACTION		Alpha 1Indicates whether to add a hold, or remove a hold. Valid values are:
  • A Add hold
  • R Remove hold
AP41.1
#AHL-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.AP41.1
#AHL-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP41.1
#AHL-VENDOR-GROUP
VENDOR_GROUP		Alpha 4A vendor group represents a group of vendors that can be shared by one or more companies.AP41.1
#AHL-PAY-GROUP
PAY_GROUP		Alpha 4A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group.AP41.1
#AHL-COMPANY
COMPANY		Numeric 4Identifies 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.AP41.1
#AHL-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP41.1
#AHL-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP41.1
#AHL-PO-CODE
PO_CODE		Alpha 4Purchase order number code. Used to keep purchase orders unique. Can also be used for reporting purposes.AP41.1
#AHL-AMOUNT
AMOUNT		Signed 18.2—AP41.1
#AHL-INVOICE-STATUS
INVOICE_STATUS		Alpha 1Indicates that invoices of a specific status will be placed on hold.
  • B Both
  • R Released
  • U Unreleased
AP41.1
#AHL-INVOICE-TYPE
INVOICE_TYPE		Alpha 1Identifies the type of invoice. " " = All
  • E Employee Expense
  • A Employee Advance
  • C Credit Memo
  • D Debit Memo
AP41.1
#AHL-SORT-DATE
SORT_DATE		Alpha 1Indicates which date to use in sorting invoices you place on hold. You can select invoice date, due date, or discount date.
  • D Due Date
  • I Invoice Date
  • S Discount Date
AP41.1

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
AHLSET1
  1. HOLD-JOB-NAME
  2. PARAM-GROUP
PrimaryAP141, AP41.1

Programs

Updated by (1)

Referenced by (1)