APAPPROVAL – Invoice Approval

System
Accounts Payable (AP)
Prefix
APO
Primary key
APPROVAL-TYPE, VENDOR-GROUP, VENDOR, COMPANY, PROC-LEVEL
Fields
21
Updated by
292 programs
Referenced by
4 programs

APAPPROVAL is the Invoice Approval table in Lawson Accounts Payable (prefix APO). It is indexed by APPROVAL-TYPE, VENDOR-GROUP, VENDOR, COMPANY, PROC-LEVEL (APOSET1); alternate indexes: APOSET3. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 284 more and referenced by AP520, EE20.1, EE20.2 and EE520. The table has 21 fields, 2 indexes and 0 documented relations.

About APAPPROVAL

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.

Fields (21)

Column = COBOL field name without the APO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
APO-APPROVAL-TYPE PK
APPROVAL_TYPE		Alpha 1The 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.
AP00.6, AP10.7
APO-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4The vendor group associated with the approval record. Must be a valid record in the Vendor Group file.AP00.6, AP10.7
APO-VENDOR PK
VENDOR		Alpha 9 (Right Justified)If the approval record is defined for a vendor, this field contains the vendor number. Must be a valid record in the Vendor file.AP10.7
APO-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.AP00.6, AP10.7
APO-PROC-LEVEL PK
PROC_LEVEL		Alpha 5If 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.AP00.6, AP10.7
APO-INV-APPRVL
INV_APPRVL		Alpha 1Indicates 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.
AP00.6, AP10.7
APO-PREPAY-APPRVL
PREPAY_APPRVL		Alpha 1Indicates 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.
AP00.6, AP10.7
APO-ADVANCE-APPRVL
ADVANCE_APPRVL		Alpha 1Indicates 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.
AP00.6, AP10.7
APO-EXPENSE-APPRVL
EXPENSE_APPRVL		Alpha 1Indicates 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.
AP00.6, AP10.7
APO-SERVICE-APPRVL
SERVICE_APPRVL		Alpha 1Indicates 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
DROPSHP_APPRVL		Alpha 1Indicates 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
DB_MEMO_APPRVL		Alpha 1Indicates 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.
AP00.6, AP10.7
APO-CR-MEMO-APPRVL
CR_MEMO_APPRVL		Alpha 1Indicates 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.
AP00.6, AP10.7
APO-INVOICE-AMT
INVOICE_AMT		Signed 18.2The 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.AP00.6, AP10.7
APO-PREPAY-AMT
PREPAY_AMT		Signed 18.2The 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.AP00.6, AP10.7
APO-ADVANCE-AMT
ADVANCE_AMT		Signed 18.2The 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.
AP00.6, AP10.7
APO-EXPENSE-AMT
EXPENSE_AMT		Signed 18.2The 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.
AP00.6, AP10.7
APO-SERVICE-AMT
SERVICE_AMT		Signed 18.2The 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
DROPSHIP_AMT		Signed 18.2The 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 USED.
  • field Yes. THIS FIELD IS NOT CURRENTLY
—
APO-DB-MEMO-AMT
DB_MEMO_AMT		Signed 18.2The 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.AP00.6, AP10.7
APO-CR-MEMO-AMT
CR_MEMO_AMT		Signed 18.2The 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.
AP00.6, AP10.7

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APOSET1APPROVAL-TYPE, VENDOR-GROUP, VENDOR, COMPANY, PROC-LEVELPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
APOSET3APPROVAL-TYPE, COMPANY, PROC-LEVELKeyChange, SubsetWhere APPROVAL-TYPE = "C"AP00.4, AP00.6, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)

Programs

Updated by (292)

Referenced by (4)