APHLDINV – Hold

System
Accounts Payable (AP)
Prefix
HLI
Primary key
VENDOR-GROUP, HLD-CODE, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ
Fields
11
Updated by
318 programs
Referenced by
12 programs

APHLDINV is the Hold table in Lawson Accounts Payable (prefix HLI). It is indexed by VENDOR-GROUP, HLD-CODE, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ (HLISET1); alternate indexes: HLISET3, HLISET4 and HLISET5. It is related 1:1 to APINVOICE, APPAYMENT and APVENMAST. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 310 more and referenced by AC210, AC297, AM18.1, AP00.1, AP05.4, AP230, AP240, AP250 and 4 more. The table has 11 fields, 4 indexes and 3 documented relations.

About APHLDINV

The Hold file contains records of vendors, invoices, and payments that are on hold. When one of these items is placed on hold, a record is created in this file. When the hold is removed, the record is deleted.

Fields (11)

Column = COBOL field name without the HLI- 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
#HLI-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4The vendor group. Must be a valid record in the Vendor Group file.AP10.1, AP100, AP110, AP125, AP126, AP141, AP150, AP170 +46 more
#HLI-HLD-CODE PK
HLD_CODE		Alpha 4The hold code assigned to the vendor, invoice, or payment. Must be a valid record in the Hold Code file.AP10.1, AP110, AP141, AP150, AP170, AP20.1, AP20.2, AP20.3 +41 more
#HLI-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.AP110, AP125, AP126, AP141, AP150, AP170, AP20.1, AP20.2 +42 more
#HLI-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor number. Must be a valid record in the Vendor file.AP10.1, AP110, AP115, AP125, AP126, AP141, AP150, AP170 +46 more
#HLI-INVOICE PK
INVOICE		Alpha 22The invoice number. Used only if the item on hold is an invoice or payment.AP115, AP125, AP126, AP141, AP150, AP170, AP20.1, AP20.2 +42 more
#HLI-SUFFIX PK
SUFFIX		Numeric 3The invoice suffix number. Represents the occurrence value of the invoice. Used only if the item on hold is an invoice or payment.AP125, AP126, AP141, AP150, AP170, AP20.1, AP20.2, AP20.3 +41 more
#HLI-CANCEL-SEQ PK
CANCEL_SEQ		Numeric 4An automatically assigned sequence number.AP125, AP126, AP141, AP150, AP170, AP20.1, AP20.2, AP20.3 +41 more
#HLI-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AP125, AP126, AP141, AP150, AP170, AP20.1, AP20.2, AP20.3 +41 more
#HLI-VOID-SEQ PK
VOID_SEQ		Numeric 4The void sequence for the invoice payment, if applicable. Used by the system to keep payment records unique each time a payment is voided and the invoice is reinstated for payment.AP125, AP126, AP141, AP150, AP170, AP20.1, AP20.2, AP20.3 +41 more
#HLI-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP125, AP126, AP141, AP150, AP20.1, AP20.2, AP20.3, AP20.4 +41 more
#HLI-REC-TYPE SET5
REC_TYPE		Alpha 1The file record type. Identifies the type of record on hold. Valid values are: records. After invoices on hold are upgraded, a post-upgrade program changes this value to Payment.
  • I Invoice. Used for upgrading invoice
  • P Payment.
  • V Vendor.
AP10.1, AP110, AP125, AP126, AP141, AP150, AP170, AP20.1 +45 more

Indexes (4)

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
HLISET1
  1. VENDOR-GROUP
  2. HLD-CODE
  3. COMPANY
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
  8. SEQ-NBR
  9. VOID-SEQ
PrimaryAP05.4, AP305
HLISET3
  1. VENDOR-GROUP
  2. HLD-CODE
  3. VENDOR
KeyChange, SubsetWhere (REC-TYPE = "V")AP170, AP240, AP250, AP290, AP40.2
HLISET4
  1. VENDOR-GROUP
  2. HLD-CODE
  3. COMPANY
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
  8. SEQ-NBR
  9. VOID-SEQ
SubsetWhere (REC-TYPE = "P")AP00.1, AP141, AP170, AP240, AP252, AP40.1, EE135, EE35.1 +12 more
HLISET5
  1. REC-TYPE
  2. VENDOR-GROUP
  3. COMPANY
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
  8. SEQ-NBR
  9. VOID-SEQ
  10. HLD-CODE
AC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 +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)
APINVOICEAPPAYMENTAPVENMASTAPHLDINV

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApinvoiceAPINVOICERequiredWhen (HLI-REC-TYPE = "I")
HLI-COMPANY→API-COMPANY
HLI-VENDOR→API-VENDOR
HLI-INVOICE→API-INVOICE
HLI-SUFFIX→API-SUFFIX
HLI-CANCEL-SEQ→API-CANCEL-SEQ
AppaymentAPPAYMENTRequiredWhen (HLI-REC-TYPE = "P")
HLI-COMPANY→APP-COMPANY
HLI-VENDOR→APP-VENDOR
HLI-INVOICE→APP-INVOICE
HLI-SUFFIX→APP-SUFFIX
HLI-CANCEL-SEQ→APP-CANCEL-SEQ
HLI-SEQ-NBR→APP-SEQ-NBR
HLI-VOID-SEQ→APP-VOID-SEQ
ApvenmastAPVENMASTRequiredWhen (HLI-REC-TYPE = "V")
HLI-VENDOR-GROUP→VEN-VENDOR-GROUP
HLI-VENDOR→VEN-VENDOR

Programs

Updated by (318)

Referenced by (12)