Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            APAPPROVAL FILE

                            Invoice Approval

The Invoice Approval file contains approval criteria records for accounts
payable companies and vendors. The approval criteria is used for selecting
released transactions for approval in AP36.1 (Invoice Payment Approval) or in
a workflow system. Transactions are selected for approval if the transaction
amount is greater than or equal to the defined transaction amount for the
transaction type.

REFERENCED BY

AP520     API1.1    API2.1    EE20.1    EE20.2    EE520

UPDATED BY

AP00.6    AP00.4    AP10.7    AP300     AP305     API3.1
API4.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

APO-APPROVAL-TYPE    Alpha 1                                     AP00.6  AP10.7
Approval Type        The type of approval record. Indicates
                     whether the approval criteria is defined
                     for an accounts payable company or
                     vendor. Valid values are:

                     C = Company.
                     V = Vendor.

APO-VENDOR-GROUP     Alpha 4                                     AP00.6  AP10.7
Vendor Group         The vendor group associated with the
                     approval record. Must be a valid record
                     in the Vendor Group file.

APO-VENDOR           Alpha 9  (Right Justified)                  AP10.7
Vendor ID            If the approval record is defined for a
                     vendor, this field contains the vendor
                     number. Must be a valid record in the
                     Vendor file.

APO-COMPANY          Numeric 4                                   AP00.6  AP10.7
Company              The company number. Must be a valid
                     record in the Accounts Payable Company
                     file.

APO-PROC-LEVEL       Alpha 5                                     AP00.6  AP10.7
Process Level        If the approval record is defined for a
                     specific company process level, this
                     field contains the process level. Must
                     be a valid record in the Accounts
                     Payable Process Level file.

APO-INV-APPRVL       Alpha 1                                     AP00.6  AP10.7
Invoices             Indicates whether approval criteria
                     applies to invoices. If Yes, released
                     invoices with an amount greater than or
                     equal to the amount defined in the
                     Invoice Amount field require approval
                     before they can be paid. Valid values
                     are:

                     N = No.
                     Y = Yes.

APO-PREPAY-APPRVL    Alpha 1                                     AP00.6  AP10.7
Prepayments          Indicates whether approval criteria
                     applies to prepayments. If Yes, released
                     prepayments with an amount greater than
                     or equal to the amount defined in the
                     Prepayment Amount field require approval
                     before they can be paid. Valid values
                     are:

                     N = No.
                     Y = Yes.

APO-ADVANCE-APPRVL   Alpha 1                                     AP00.6  AP10.7
Advances             Indicates whether approval criteria
                     applies to employee advances. If Yes,
                     released advances with an amount greater
                     than or equal to the amount defined in
                     the Advance Amount field require
                     approval before they can be paid. Valid
                     values are:

                     N = No.
                     Y = Yes.

APO-EXPENSE-APPRVL   Alpha 1                                     AP00.6  AP10.7
Expenses             Indicates whether approval criteria
                     applies to employee expenses. If Yes,
                     released expenses with an amount greater
                     than or equal to the amount defined in
                     the Expense Amount field require
                     approval before they can be paid. Valid
                     values are:

                     N = No.
                     Y = Yes.

APO-SERVICE-APPRVL   Alpha 1
Services             Indicates whether approval criteria
                     applies to service charges. If Yes,
                     released service charges with an amount
                     greater than or equal to the amount
                     defined in the Services amount field
                     require approval before they can be
                     paid. THIS FIELD IS NOT CURRENTLY USED.

APO-DROPSHP-APPRVL   Alpha 1
Dropshipments        Indicates whether approval criteria
                     applies to dropshipments. If Yes,
                     released dropshipments with an amount
                     greater than or equal to the amount
                     defined in the Dropshipment Amount field
                     require approval before they can be
                     paid. THIS FIELD IS NOT CURRENTLY USED.

APO-DB-MEMO-APPRVL   Alpha 1                                     AP00.6  AP10.7
Debit Memos          Indicates whether approval criteria
                     applies to debit memos. If Yes, released
                     debit memos with an amount greater than
                     or equal to the amount defined in the
                     Debit Memo Amount field require approval
                     before they can be paid. Valid values
                     are:

                     N = No.
                     Y = Yes.

APO-CR-MEMO-APPRVL   Alpha 1                                     AP00.6  AP10.7
Credit Memos         Indicates whether approval criteria
                     applies to credit memos. If Yes,
                     released credit memos with an amount
                     greater than or equal to the amount
                     defined in the Credit Memo Amount field
                     require approval before they can be
                     applied. Valid values are:

                     N = No.
                     Y = Yes.

APO-INVOICE-AMT      Signed 15.2                                 AP00.6  AP10.7
Invoice Amount       The transaction amount used for
                     selecting invoices for approval.
                     Released invoices with an amount greater
                     than or equal to this amount must be
                     approved before they can be paid. Used
                     only if the Invoices field = Yes.

APO-PREPAY-AMT       Signed 15.2                                 AP00.6  AP10.7
Prepayment Amount    The transaction amount used for
                     selecting prepayments for approval.
                     Released prepayments with an amount
                     greater than or equal to this amount
                     must be approved before they can be
                     paid. Used only if the Prepayments field
                     = Yes.

APO-ADVANCE-AMT      Signed 15.2                                 AP00.6  AP10.7
Advance Amount       The transaction amount used for
                     selecting employee advances for
                     approval. Released employee advances
                     with an amount greater than or equal to
                     this amount must be approved before they
                     can be paid. Used only if the Advances
                     field = Yes.

APO-EXPENSE-AMT      Signed 15.2                                 AP00.6  AP10.7
Expense Amount       The transaction amount used for
                     selecting employee expenses for
                     approval. Released employee expenses
                     with an amount greater than or equal to
                     this amount must be approved before they
                     can be paid. Used only if the Expenses
                     field = Yes.

APO-SERVICE-AMT      Signed 15.2
Service Amount       The transaction amount used for
                     selecting service charges for approval.
                     Released service charges with an amount
                     greater than or equal to this amount
                     must be approved before they can be
                     paid. Used only if the Services field =
                     Yes. THIS FIELD IS NOT CURRENTLY USED.

APO-DROPSHIP-AMT     Signed 15.2
Dropshipment Amount  The transaction amount used for
                     selecting dropshipments for approval.
                     Released dropshipments with an amount
                     greater than or equal to this amount
                     must be approved before they can be
                     paid. Used only if the Dropshipments
                     field = Yes. THIS FIELD IS NOT CURRENTLY
                     USED.

APO-DB-MEMO-AMT      Signed 15.2                                 AP00.6  AP10.7
Debit Memo Amount    The transaction amount used for
                     selecting debit memos for approval.
                     Released debit memos with an amount
                     greater than or equal to this amount
                     must be approved before they can be
                     paid. Used only if the Debit Memos field
                     = Yes.

APO-CR-MEMO-AMT      Signed 15.2                                 AP00.6  AP10.7
Credit Memo Amount   The transaction amount used for
                     selecting credit memos for approval.
                     Released credit memos with an amount
                     greater than or equal to this amount
                     must be approved before they can be
                     applied. Used only if the Credit Memos
                     field = Yes.

                         APAPPROVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APOSET1   APPROVAL-TYPE This index is used to delete approval    AP10.7  AP300
          VENDOR-GROUP  records when the vendor is deleted.  It  AP520   API1.1
          VENDOR        is also used to display on the vendor    API2.1  API3.1
          COMPANY       payment screen.                          API4.1  EE20.1
          PROC-LEVEL                                             EE20.2  EE520

APOSET3   APPROVAL-TYPE This index is used to delete approval    AP00.4  AP00.6
          COMPANY       records when the company is deleted.     AP305   AP520
          PROC-LEVEL    KeyChange, Subset                        API1.1  API2.1
                        Where APPROVAL-TYPE = "C"                EE20.1  EE20.2
                                                                 EE520