Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APAPPROVAL


                            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

AP125     AP126     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.6    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP520     API1.1    API2.1    EE20.1
EE20.2    EE520     MA41.2    MA41.7    MA43.2    MA61.1
MA66.2    MAI1.1

UPDATED BY

AP00.6    AP00.4    AP10.7    AP300     AP305     AM115
AM15.1    AM15.2    AM15.3    AM15.4    AM20.1    AM20.3
AM21.1    AM21.3    AM500     AM51.1    AM551     AM97.1
API3.1    API4.1    IC840     PR05.1    PR05.3    PR226
PR247     PR26.1    PR47.1    PR514     UK47.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APO-APPROVAL-TYPE      Alpha 1                                   AP00.6  AP10.7
Element: 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
Element: 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
Element: 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
Element: Company       The company number. Must be a valid
                       record in the Accounts Payable Company
                       file.

APO-PROC-LEVEL         Alpha 5                                   AP00.6  AP10.7
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Invoice AmountThe 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
Element: Prepayment AmoThe 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
Element: Advance AmountThe 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
Element: Expense AmountThe 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
Element: Service AmountThe 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
Element: Dropshipment AThe 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
Element: Debit Memo AmoThe 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
Element: Credit Memo AmThe 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    AM115   AM15.1
          VENDOR-GROUP  records when the vendor is deleted.  It  AM15.2  AM15.3
          VENDOR        is also used to display on the vendor    AM15.4  AM20.1
          COMPANY       payment screen.                          AM20.3  AM21.1
          PROC-LEVEL                                             AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP10.7
                                                                 AP125   AP126
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP300   AP520
                                                                 ...

APOSET3   APPROVAL-TYPE This index is used to delete approval    AP00.4  AP00.6
          COMPANY       records when the company is deleted.     AP125   AP126
          PROC-LEVEL    KeyChange, Subset                        AP20.1  AP20.2
                        Where APPROVAL-TYPE = "C"                AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP305   AP520
                                                                 API1.1  API2.1
                                                                 EE20.1  EE20.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1