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

AP520     EE20.1    EE20.2    EE520

UPDATED BY

AP00.6    AP00.4    AP10.7    AP300     AP305     AC160
AM115     AM117     AM15.1    AM15.2    AM15.3    AM15.4
AM19.1    AM19.2    AM20.1    AM20.3    AM21.1    AM21.3
AM500     AM51.1    AM551     AM97.1    AP03.3    AP110
AP115     AP125     AP126     AP131     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP21.1    AP210
AP220     AP23.1    AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    AP510     AP90.1    AP91.1    API1.1
API2.1    API3.1    API4.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    MX123     MX500     MA180
MA279     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.4    MA43.6    MA43.7    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA63.1
MA65.1    MA66.2    MA66.3    MA67.2    MA67.3    MA68.2
MA68.3    MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1
PD10.1    PD10.2    PD130     PD20.1    PD20.2    PD20.3
PD235     PO10.1    PO100     PO101     PO120     PO122
PO131     PO20.1    PO21.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    PO220     PO223     PO23.1    PO233
PO24.1    PO25.1    PO25.5    PO25.6    PO25.7    PO253
PO254     PO27.2    PO278     PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO32.4
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     PO54.1    PO54.2    PO54.3    PO54.4    POI3.1
POID.1    POII.1    POIJ.1    PR05.1    PR05.3    PR226
PR247     PR26.1    PR47.1    PR514     UK47.1    RQ10.1
RQ10.2    WH20.2    WH20.7

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        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 table.


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 18.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 18.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 18.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 18.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 18.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 18.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 18.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 18.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                                          AC160   AM115
          VENDOR-GROUP                                           AM117   AM15.1
          VENDOR                                                 AM15.2  AM15.3
          COMPANY                                                AM15.4  AM19.1
          PROC-LEVEL                                             AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP03.3
                                                                 AP10.7  AP110
                                                                 AP115   AP125
                                                                 AP126   AP131
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 ...

APOSET3   APPROVAL-TYPE KeyChange, Subset                        AP00.4  AP00.6
          COMPANY       Where APPROVAL-TYPE = "C"                AP125   AP126
          PROC-LEVEL                                             AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP305
                                                                 AP520   API1.1
                                                                 API2.1  EE20.1
                                                                 EE20.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 ...