Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            APHOLDCODE FILE

                               Hold Code

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.

REFERENCED BY

AP150     AP170     AP205     AP230     AP240     AP25.4
AP250     AP26.1    AP290     AP36.1    AP40.1    AP40.2
AP510     AP520     EE20.1    EE20.2    EE20.4    EE35.1
EE35.2    EE520     MA00.4    MA200

UPDATED BY

AP00.1    AP05.4    AP10.1    AP100     AP20.1    AP20.2
AP20.5    AP20.6    AP20.7    AP23.1    MA40.1    MA40.2
MA41.1    MA41.2    MA41.4    MA41.5    MA41.6    MA43.1
MA43.2    MA43.3    MA43.4    MA52.1    MA530     MA540
PO31.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HLD-VENDOR-GROUP     Alpha 4                                     AP00.1  AP05.4
Vendor Group         The vendor group. Must be a valid           AP100
                     record in the Vendor Group file.

HLD-HLD-CODE         Alpha 4                                     AP00.1  AP05.4
Hold Code            A user-defined code used to temporarily     AP100
                     or permanently prevent invoices from
                     being scheduled for payment. Hold codes
                     can be assigned to vendors and invoices.


HLD-DESCRIPTION      Alpha 30  (Lower Case)                      AP00.1  AP05.4
Description          The hold code description.                  AP100

HLD-HOLD-VEN-FLAG    Alpha 1                                     AP05.4  AP100
Vendor Hold          Indicates the type of vendor hold code.
Indicator            Valid values are:

                     P = Permanent. The hold remains
                     effective until the hold code is removed
                     from the vendor record.

                     T = Temporary. The hold remains
                     effective for one cash payment cycle.
                     AP170 (Payment Closing) removes the hold
                     code from the vendor record.

                     Blank = Not a vendor hold code.

HLD-HOLD-INV-FLAG    Alpha 1                                     AP00.1  AP05.4
Invoice Hold         Indicates the type of invoice hold          AP100
Indicator            code. Valid values are:

                     P = Permanent. The hold remains
                     effective until the hold code is removed
                     from the invoice record.

                     T = Temporary. The hold remains
                     effective for one cash payment cycle.
                     AP170 (Payment Closing) removes the hold
                     code from the invoice record.

                     Blank = Not an invoice hold code.

HLD-ACTIVITY-FLAG    Alpha 1                                     AP05.4  AP10.1
Used                 Indicates whether the hold code has         AP20.1  AP20.2
                     been used.                                  AP20.5  AP20.6
                                                                 AP20.7  AP23.1
                                                                 MA40.1  MA40.2
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.5
                                                                 MA41.6  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA52.1
                                                                 MA530   MA540
                                                                 PO31.1

                         APHOLDCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HLDSET1   VENDOR-GROUP  This index is used to access and         AP00.1  AP00.3
          HLD-CODE      validate hold codes for a vendor group.  AP05.4  AP10.1
                                                                 AP100   AP150
                                                                 AP170   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP205   AP23.1
                                                                 AP230   AP240
                                                                 AP25.4  AP250
                                                                 AP26.1  AP290
                                                                 AP36.1  AP40.1
                                                                 AP40.2  AP510
                                                                 AP520   EE20.1
                                                                 EE20.2  EE20.4
                                                                 EE35.1  EE35.2
                                                                 ...

                         APHOLDCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvengroup     APVENGROUP   Required

                            HLD-VENDOR-GROUP    -> VGP-VENDOR-GROUP