Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APHOLDCODE


                            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

AM115     AM15.1    AM15.2    AM15.3    AM15.4    AM20.1
AM20.3    AM21.1    AM21.3    AM500     AM51.1    AM551
AM97.1    AP141     AP150     AP170     AP205     AP230
AP240     AP25.4    AP250     AP252     AP26.1    AP27.1
AP290     AP36.1    AP40.1    AP40.2    AP41.1    AP43.1
AP510     AP520     API3.1    API4.1    EE20.1    EE20.2
EE20.4    EE35.1    EE35.2    EE520     IC840     MA01.1
PR05.1    PR05.3    PR226     PR247     PR26.1    PR47.1
PR514     UK47.1

UPDATED BY

AP00.1    AP05.4    AP10.1    AP100     AP125     AP126
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.6
AP20.7    AP23.1    AP31.3    API1.1    API2.1    MA126
MA41.2    MA43.2    MA531     MA540     MA60.7    MA61.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HLD-VENDOR-GROUP       Alpha 4                                   AP00.1  AP05.4
Element: 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
Accounts Receivable    A user-defined code used to temporarily   AP100
Code                   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
Element: Description   The hold code description.                AP100   AP125
                                                                 AP126   AP31.3
                                                                 MA126   MA531
                                                                 MA540   MA60.7
                                                                 MA61.1

HLD-HOLD-VEN-FLAG      Alpha 1                                   AP05.4  AP100
Vendor Hold            Indicates the type of vendor hold code.   AP125   AP126
Indicator              Valid values are:                         AP31.3  MA126
                                                                 MA531   MA540
                       P = Permanent. The hold remains           MA60.7  MA61.1
                       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   AP125
Indicator              code. Valid values are:                   AP126   AP31.3
                                                                 MA126   MA531
                       P = Permanent. The hold remains           MA540   MA60.7
                       effective until the hold code is removed  MA61.1
                       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
Element: Used          Indicates whether the hold code has       AP125   AP126
                       been used.                                AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP23.1
                                                                 AP31.3  API1.1
                                                                 API2.1  MA126
                                                                 MA41.2  MA43.2
                                                                 MA531   MA540
                                                                 MA60.7  MA61.1

                         APHOLDCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HLDSET1   VENDOR-GROUP  This index is used to access and         AM115   AM15.1
          HLD-CODE      validate hold codes for a vendor group.  AM15.2  AM15.3
                                                                 AM15.4  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.1
                                                                 AP00.3  AP05.4
                                                                 AP10.1  AP10.2
                                                                 AP100   AP125
                                                                 AP126   AP141
                                                                 AP150   AP170
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 ...

                         APHOLDCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvengroup     APVENGROUP   Required

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