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.

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

IndexKeysFlagsConditionUsed in
HLISET1VENDOR-GROUP, HLD-CODE, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQPrimaryAP05.4, AP305
HLISET3VENDOR-GROUP, HLD-CODE, VENDORKeyChange, SubsetWhere (REC-TYPE = "V")AP170, AP240, AP250, AP290, AP40.2
HLISET4VENDOR-GROUP, HLD-CODE, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQSubsetWhere (REC-TYPE = "P")AP00.1, AP141, AP170, AP240, AP252, AP40.1, EE135, EE35.1 +12 more
HLISET5REC-TYPE, VENDOR-GROUP, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, HLD-CODEAC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Relations

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)