Accounts Payable – Lawson AP tables and programs
Accounts Payable (AP) in Lawson S3 v10 MSP6 has 123 tables, 171 online screens and 92 batch programs.
Tables (123)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| APACCRCODE | ACR | Invoice Accrual Code | COMPANY, ACCR-CODE | 7 |
| APAPDHIST | AH2 | No description in the Lawson data dictionary | API-OBJ-ID, DIST-SEQ-NBR | 65 |
| APAPIHIST | AH1 | Vendor Invoice History | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ | 155 |
| APAPPHIST | AH3 | AP Payment History | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ | 89 |
| APAPPROVAL | APO | Invoice Approval | APPROVAL-TYPE, VENDOR-GROUP, VENDOR, COMPANY, PROC-LEVEL | 21 |
| APAPSHIST | AH4 | No description in the Lawson data dictionary | API-OBJ-ID, DIST-SEQ-NBR | 26 |
| APASTDTL | APS | Asset Detail | API-OBJ-ID, DIST-SEQ-NBR | 26 |
| APAUDIT | APA | Vendor Invoice Audit | VENDOR-GROUP, COMPANY, PROC-LEVEL, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, TRANS-DATE, TRANS-TIME, LOCATION-CODE | 20 |
| APAUTHBUY | APG | No description in the Lawson data dictionary | COMPANY, AUTH-CODE, BUYER-CODE | 3 |
| APAUTHOR | ATR | Authority Code | COMPANY, AUTH-CODE | 7 |
| APBATCH | APB | Batch | COMPANY, BATCH-NUM | 15 |
| APCATTACH | AAP | No description in the Lawson data dictionary | COMPANY, VENDOR, INVOICE, SUFFIX, COMMENT-NAME, CMT-SEQ-NBR | 8 |
| APCCONTACT | CVH | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL | 16 |
| APCDISTRIB | CVD | Distribution Interface | COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ-NBR | 56 |
| APCERTCODE | CER | Accounts Payable Cert Code | CERTIF-CODE | 3 |
| APCINVERR | AER | AP Invoice Conversion Error | COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ, RECORD-TYPE, SEQ-NBR | 9 |
| APCINVOICE | CVI | Invoice Interface | COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX | 127 |
| APCNTNBOD | YAX | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL | 11 |
| APCOMMENTS | APC | Comments | REC-TYPE, COMPANY, VENDOR, LOCATION-CODE, SEQ-NBR | 13 |
| APCOMPANY | CPY | Accounts Payable Company | COMPANY | 53 |
| APCOMPAUD | CAP | AP Company Audit | COMPANY, ACTION, DATE, TIME, UNIQUE-I-D | 19 |
| APCONTACT | VCT | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL | 21 |
| APCPAYMENT | CVP | Invoice Payment Interface | COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, SEQ-NBR | 29 |
| APCPYVND | APX | Vendor Company Codes | VENDOR-GROUP, VENDOR, LOCATION-CODE, COMPANY | 24 |
| APCRMEMO | CRM | Credit Memo Application | COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR, INVOICE, SUFFIX, SEQ-NBR | 9 |
| APCRMHIST | AH6 | No description in the Lawson data dictionary | COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR, INVOICE, SUFFIX, SEQ-NBR | 9 |
| APCVENADDR | AAD | Vender Address Conversion | VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL, EFFECTIVE-DATE | 17 |
| APCVENBAL | CVB | Vendor Balance Conversion | VENDOR-GROUP, VENDOR, OLD-VENDOR, LOCATION-CODE, COMPANY | 23 |
| APCVENCERT | CVN | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR, LOCATION-CODE, CERTIF-CODE, CERTIF-EFF-DT | 8 |
| APCVENMAST | CVV | Vendor Conversion | VENDOR-GROUP, VENDOR, OLD-VENDOR, LOCATION-CODE | 222 |
| APDFLHIST | AH7 | No description in the Lawson data dictionary | API-OBJ-ID, DIST-SEQ-NBR | 7 |
| APDFTSTMT | ADF | No description in the Lawson data dictionary | CASH-CODE, PAY-GROUP, STATEMENT-NBR, COMPANY | 9 |
| APDICT | DCT | No description in the Lawson data dictionary | FLD-NBR | 8 |
| APDICT2 | AP2 | No description in the Lawson data dictionary | DB-FILE-PFX, FLD-NBR | 5 |
| APDISACSTA | ADA | No description in the Lawson data dictionary | ACCT-STRCT, DIST-COMPANY, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT, UNIQUE-I-D | 6 |
| APDISACSTH | ADH | No description in the Lawson data dictionary | COMPANY, ACCT-STRCT | 2 |
| APDISCACC | DSK | Discount | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, DISC-TYPE | 19 |
| APDISCCODE | DSC | Discount Code | DISCOUNT-CODE | 8 |
| APDISTCODE | DTC | Distribution Code Detail | COMPANY, DIST-CODE, SEQ-NBR | 33 |
| APDISTHDR | HDR | Distribution Code Header | COMPANY, DIST-CODE | 10 |
| APDISTPAY | DTY | For invoices with retainage, it is required to track what has been paid against a vendor agreement or purchase order… | COMPANY, VENDOR, INVOICE, SUFFIX, PMT-SEQ-NBR, LINE-NBR, MAD-SEQ-NBR, DIST-SEQ-NBR | 17 |
| APDISTRIB | APD | Invoice Distribution | API-OBJ-ID, DIST-SEQ-NBR | 74 |
| APDIVCODE | AVC | Accounts Payable Diversity Cd | DIVERSE-CODE | 3 |
| APDRAFTS | APT | AP Bill of Exchange | BANK-INST-CODE, TRANS-IDENT | 43 |
| APDRFTCDES | APF | Bill of Exchange Accrual Code | DRAFT-CODE | 7 |
| APDRFTDIST | DDT | Bill of Exchange Distribution | BANK-INST-CODE, TRANS-IDENT, SEQ-NBR | 32 |
| APDSKHIST | AH8 | No description in the Lawson data dictionary | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, DISC-TYPE | 19 |
| APDSTBOD | YAY | No description in the Lawson data dictionary | API-OBJ-ID, DIST-SEQ-NBR | 8 |
| APDSUSRFLD | DFL | Accounts Payable User Fields | API-OBJ-ID, DIST-SEQ-NBR | 7 |
| APELECTID | APE | Electronic Transfer ID | PAY-GROUP, BANK-INST-CODE | 8 |
| APEXPINV | IEX | No description in the Lawson data dictionary | COMPANY, OBJ-ID | 29 |
| APFRIEXP | AFX | No description in the Lawson data dictionary | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, APP-SEQ-NBR, VOID-SEQ, DISC-TYPE, DIST-SEQ-NBR, SEQ-NBR | 32 |
| APHLDINV | HLI | Hold | VENDOR-GROUP, HLD-CODE, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ | 11 |
| APHLDPARAM | AHL | Hold Group Parameter | HOLD-JOB-NAME, PARAM-GROUP | 16 |
| APHOLDCODE | HLD | Hold Code | VENDOR-GROUP, HLD-CODE | 6 |
| APINCCODE | TYP | Income Code | INCOME-CODE | 6 |
| APINUSRFLD | ISR | AP Invoice User Fields | OBJ-ID | 6 |
| APINVBOD | YAZ | No description in the Lawson data dictionary | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ | 11 |
| APINVOICE | API | Accounts Payable Invoice | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ | 187 |
| APISRHIST | AH9 | No description in the Lawson data dictionary | OBJ-ID | 6 |
| APMONITOR | MON | Accounts Payable Monitor | PAY-GROUP, RUN-PROG, PROC-GRP, PROC-LEVEL, ADA-ACCT-STRCT, BATCH-NUM, AUTH-CODE, COMPANY | 11 |
| APPAYCOREL | PYR | Pay Group-Company Relationship | PAY-GROUP, COMPANY, PROC-LEVEL | 3 |
| APPAYGROUP | PAY | Pay Group | PAY-GROUP | 18 |
| APPAYMENT | APP | Invoice Payment | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ | 98 |
| APPMTBOD | YBA | No description in the Lawson data dictionary | COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ | 13 |
| APPOVNXREF | AXV | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR, XREF-VENDOR | 5 |
| APPRCLVAUD | LVA | AP Process Level Audit | COMPANY, PROCESS-LEVEL, ACTION, DATE, TIME, UNIQUE-I-D | 15 |
| APPROCGRP | APQ | Process Group | PROC-GRP | 2 |
| APPROCLEV | APR | Accounts Payable Process Level | COMPANY, PROC-LEVEL | 28 |
| APRECON | APN | Invoice Accrual Reconciliation | COMPANY, RECON-DATE, ACCR-CODE, INV-CURRENCY | 5 |
| APRESPCODE | VRC | Accounts Payable Response Code | RESP-CODE | 2 |
| APRPTBLINC | RIC | No description in the Lawson data dictionary | SOURCE, YEAR-PAID, RIC-OBJ-ID | 26 |
| APSECWTH | SWH | No description in the Lawson data dictionary | SEC-WTH-CODE | 9 |
| APSECWTHRT | SWR | No description in the Lawson data dictionary | SEC-WTH-CODE, EFF-DATE | 3 |
| APTAXENT | TNT | Reportable Income Group Entity | TAX-GROUP, COMPANY, PROC-LEVEL | 3 |
| APTAXGROUP | TXP | Reportable Income Group | TAX-GROUP | 23 |
| APUAVAL | UAV | No description in the Lawson data dictionary | SEG-TYPE, API-OBJ-ID, DIST-SEQ-NBR | 4 |
| APUAVHIST | AH5 | No description in the Lawson data dictionary | SEG-TYPE, API-OBJ-ID, DIST-SEQ-NBR | 4 |
| APUDISTCD | UDS | No description in the Lawson data dictionary | COMPANY, DIST-CODE, SEQ-NBR | 4 |
| APUSER | APJ | Pay Group User | USER-CLASS, USER-ID | 4 |
| APUSRCLASS | APK | Pay Group User Class | USER-CLASS | 2 |
| APUSRFLDEF | AFL | AP User Field Definition | | 9 |
| APVENADDR | VDR | AP Vendor Address | VENDOR-GROUP, VENDOR, LOCATION-CODE, RESP-CODE, CONTACT-LVL, EFFECTIVE-DATE | 22 |
| APVENBAL | VBA | Vendor Balance | VENDOR-GROUP, COMPANY, VENDOR, LOCATION-CODE | 77 |
| APVENCERT | AVT | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR, LOCATION-CODE, CERTIF-CODE, CERTIF-EFF-DT | 8 |
| APVENCLASS | VCL | Vendor Class | VENDOR-GROUP, VEN-CLASS | 29 |
| APVENDIV | VDC | The APVENDIV file stores the diversity codes and their certification dates for the related vendor in APVENMAST | VENDOR-GROUP, VENDOR, LOCATION-CODE, DIVERSE-CODE, DCERT-DATE | 7 |
| APVENGROUP | VGP | Vendor Group | VENDOR-GROUP | 28 |
| APVENLCBOD | YBB | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR, LOCATION-CODE | 9 |
| APVENLOC | VLO | Vendor Location | VENDOR-GROUP, VENDOR, LOCATION-CODE | 118 |
| APVENMAST | VEN | Vendor Master Record | VENDOR-GROUP, VENDOR | 184 |
| APVENPAY | VPY | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR, PAY-VENDOR | 5 |
| APVENTABLE | VTB | Vendor Table | VENDOR-GROUP, OLD-VENDOR, LOCATION-CODE | 7 |
| APVNBOD | YBC | No description in the Lawson data dictionary | VENDOR-GROUP, VENDOR | 8 |
| APVNMXVAL | VMX | No description in the Lawson data dictionary | AP-OBJ-ID, MATRIX-CAT | 3 |
| APWTHCODE | WTH | Income Withholding Code | INC-ACCR-CODE | 7 |
| CTXMCONFIG | XMC | No description in the Lawson data dictionary | OBJID | 22 |
| CTXMEXPDTL | XME | No description in the Lawson data dictionary | XMHOBJID, OBJID | 27 |
| CTXMEXPHDR | XMH | No description in the Lawson data dictionary | OBJID | 25 |
| CTXMEXPTYP | XMT | No description in the Lawson data dictionary | EXPTYPE, COMPANY | 10 |
| CTXMMCR | CTX | No description in the Lawson data dictionary | OBJID, SEQUENCE | 4 |
| CTXMPRTYPE | XMP | No description in the Lawson data dictionary | PRTYPE | 4 |
| CTXMUSER | XMU | No description in the Lawson data dictionary | OBJID | 33 |
| EEADVANCE | EEA | Employee Advance | COMPANY, VENDOR, ADVANCE-NBR | 34 |
| EEADVAPP | ETQ | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, DOCUMENT, ADVANCE-NBR | 7 |
| EEAPPROVAL | EAP | Expense Advance Approval Code | COMPANY, APPROVAL-CODE | 6 |
| EECATEGORY | CTG | Expense Advance Category Code | COMPANY, CATEGORY | 13 |
| EECDISTRIB | CVT | Expense Distribution Interface | COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR | 26 |
| EECEXPENSE | CVE | Expense Interface | COMPANY, VENDOR, EXPENSE-NBR | 43 |
| EEDISTRIB | EED | Expense Distribution | COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR | 38 |
| EEEXPDTL | XPD | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, DOCUMENT, SEQ | 42 |
| EEEXPENSE | EXP | Employee Expense | COMPANY, VENDOR, EXPENSE-NBR | 53 |
| EEEXPHDR | XPH | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, DOCUMENT | 43 |
| EEMATCHING | EEM | Advance Expense Matching | COMPANY, VENDOR, EXPENSE-NBR, ADVANCE-NBR | 6 |
| EENONDETL | END | No description in the Lawson data dictionary | COMPANY, EXPENSE-NBR, VENDOR, BEFORE-AFTER, SEQ | 10 |
| EENONHEAD | ENH | No description in the Lawson data dictionary | COMPANY, EXPENSE-NBR, VENDOR, BEFORE-AFTER | 16 |
| EETRAVELDT | ETD | No description in the Lawson data dictionary | COMPANY, EXPENSE-NBR, VENDOR, BEFORE-AFTER, SEQ | 8 |
| EETRAVELHD | ETH | No description in the Lawson data dictionary | COMPANY, EXPENSE-NBR, VENDOR, BEFORE-AFTER | 19 |
| EEUACATEG | ECV | No description in the Lawson data dictionary | COMPANY, CATEGORY | 3 |
| EEUAVAL | EUA | No description in the Lawson data dictionary | COMPANY, VENDOR, EXPENSE-NBR, SEQ-NBR, TYPE | 6 |
| EMPEXPENSE | ETC | No description in the Lawson data dictionary | COMPANY, EE-CATEGORY, SEA-CATEGORY, CATEGORY-TYPE, CAT-STATUS | 6 |
| VBABOD | YVB | No description in the Lawson data dictionary | VENDOR-GROUP, COMPANY, VENDOR, LOCATION-CODE | 10 |
| VNMXCONV | VNC | No description in the Lawson data dictionary | RUN-GROUP, VENDOR-GROUP, VENDOR, MATRIX-CAT | 5 |
Online screens (171)
| Screen | Description | Updates | References |
|---|---|---|---|
| AP00.1 | Vendor Group | 4 | 4 |
| AP00.2 | Vendor Group User Fields | 0 | 1 |
| AP00.3 | Vendor Class | 7 | 18 |
| AP00.4 | Company | 18 | 29 |
| AP00.5 | Process Level | 5 | 18 |
| AP00.6 | Company Approval | 3 | 2 |
| AP00.7 | Distribution Reporting Set Up | 4 | 8 |
| AP01.1 | Pay Group | 5 | 14 |
| AP01.3 | Electronic Transfer Identification | 2 | 1 |
| AP01.4 | Pay Group Company Relationship | 0 | 4 |
| AP01.5 | Pay Group Security | 0 | 2 |
| AP02.1 | Reportable Income Group | 2 | 4 |
| AP02.2 | Reportable Income Group Entities | 1 | 3 |
| AP02.3 | Process Groups | 1 | 2 |
| AP02.4 | Income Code | 1 | 0 |
| AP03.1 | Attributes | 3 | 7 |
| AP03.2 | Values by Attribute | 3 | 5 |
| AP03.3 | Query List Members | 27 | 51 |
| AP03.4 | Manual Vendor List | 3 | 1 |
| AP04.1 | Pay Group Security | 2 | 0 |
| AP04.2 | Pay Group Users | 1 | 1 |
| AP05.1 | Bill of Exchange Accrual Code | 2 | 4 |
| AP05.2 | Invoice Accrual Code | 2 | 5 |
| AP05.3 | Distribution Code | 4 | 8 |
| AP05.4 | Hold Code | 1 | 2 |
| AP05.6 | Authority Code | 1 | 3 |
| AP05.7 | Discount Code | 2 | 5 |
| AP05.8 | Withholding Code | 2 | 4 |
| AP06.1 | Authorized Buyer | 1 | 4 |
| AP08.1 | Secondary Withholding Code | 3 | 4 |
| AP09.2 | Asset Management | 0 | 1 |
| AP10.1 | Vendor | 13 | 57 |
| AP10.2 | Vendor Location | 10 | 43 |
| AP10.3 | One Time Vendor | 4 | 3 |
| AP10.4 | Customer | 0 | 2 |
| AP10.5 | Vendor, Company Codes | 9 | 21 |
| AP10.6 | Location, Company Codes | 9 | 13 |
| AP10.7 | Vendor Approval | 3 | 3 |
| AP10.8 | Cross Border Payment Options | 0 | 3 |
| AP10.9 | Vendor Address | 2 | 5 |
| AP11.1 | Pay Vendor Maintenance | 3 | 2 |
| AP12.1 | Vendor Comments | 1 | 6 |
| AP13.1 | Contact Code | 2 | 1 |
| AP13.2 | Diversity Code | 4 | 3 |
| AP13.3 | Certification Code | 2 | 1 |
| AP14.1 | Vendor Contact | 4 | 25 |
| AP14.2 | Vendor Contact Address | 2 | 26 |
| AP14.3 | Certification Code Assignment | 2 | 4 |
| AP14.4 | Vendor Diversity Code Certification | 2 | 4 |
| AP14.5 | 1099 Tax Identification Information | 2 | 27 |
| AP15.1 | Cross Reference Vendor Setup | 3 | 1 |
| AP16.1 | Vendor Bank | 2 | 30 |
| AP16.2 | Vendor Location Bank | 2 | 30 |
| AP20.1 | Basic Invoice | 227 | 243 |
| AP20.2 | Taxed Invoice | 227 | 243 |
| AP20.3 | Detail Invoice | 227 | 243 |
| AP20.4 | Invoice Line Detail | 227 | 243 |
| AP20.5 | Multiple Invoice | 227 | 243 |
| AP20.6 | Prepayment | 19 | 40 |
| AP20.7 | Distributions | 227 | 243 |
| AP20.8 | Payment Schedule | 10 | 24 |
| AP21.1 | View Distributions | 227 | 243 |
| AP22.2 | Asset Management | 7 | 7 |
| AP23.1 | Transit Invoice Entry | 227 | 243 |
| AP25.1 | Batch Control | 215 | 233 |
| AP25.2 | Batch Review | 219 | 233 |
| AP25.3 | Invoice Batch Transfer | 2 | 3 |
| AP25.4 | Selection Criteria | 0 | 4 |
| AP26.1 | Invoice Release | 217 | 232 |
| AP27.1 | Single Invoice Release | 218 | 232 |
| AP28.1 | Bill of Exchange Acceptance by Vendor | 34 | 35 |
| AP28.2 | Bill of Exchange Acceptance by Date | 34 | 34 |
| AP28.3 | Selection Criteria | 1 | 0 |
| AP30.1 | Invoice Maintenance | 14 | 45 |
| AP30.2 | Distribution Adjustments | 124 | 143 |
| AP30.3 | Payment Schedule Adjustment | 10 | 20 |
| AP30.4 | Invoice Cancel | 213 | 198 |
| AP30.5 | Invoice Options | 0 | 2 |
| AP32.1 | Workflow Approval Maintenance | 5 | 10 |
| AP33.1 | Retainage Payment Adjustment | 3 | 8 |
| AP35.1 | Credit Memo Application | 5 | 8 |
| AP36.1 | Invoice Payment Approval | 3 | 3 |
| AP36.2 | Distribution Approvals | 1 | 11 |
| AP40.1 | Invoice Hold Selection | 4 | 8 |
| AP40.2 | Vendor Hold Selection | 3 | 3 |
| AP41.1 | Hold Parameter Definition | 1 | 5 |
| AP45.1 | Reportable Income Adjustment | 27 | 4 |
| AP45.2 | Selection Criteria | 0 | 2 |
| AP45.3 | Non-AP Reportable Income Adjustment | 2 | 5 |
| AP45.4 | Selection Criteria | 0 | 5 |
| AP51.1 | Vendor Conversion | 3 | 6 |
| AP51.2 | Vendor Location Conversion | 2 | 4 |
| AP51.3 | Address Change Interface | 1 | 3 |
| AP51.4 | Purchase Order Vendor Conversion | 1 | 2 |
| AP51.5 | Purchase Order Vendor Location Conversion | 1 | 2 |
| AP51.6 | Vendor Maintenance | 1 | 2 |
| AP51.7 | Vendor Conversion Contact Address | 1 | 1 |
| AP51.8 | Certification Code Assignment | 1 | 3 |
| AP51.9 | Customer | 0 | 2 |
| AP52.1 | Invoice Interface | 5 | 16 |
| AP52.2 | Multiple Payment Interface | 1 | 3 |
| AP52.3 | Distribution Interface | 2 | 12 |
| AP52.6 | Invoice Errors | 0 | 3 |
| AP52.7 | Invoice Filter | 0 | 5 |
| AP52.9 | Invoice Conversion Comments | 1 | 0 |
| AP54.1 | Vendor Table | 1 | 2 |
| AP55.1 | Cash Payment Entry | 9 | 17 |
| AP55.2 | Cash Payment Invoice Application | 10 | 16 |
| AP56.1 | Bill of Exchange Entry | 8 | 18 |
| AP56.2 | Bill of Exchange Invoice Application | 8 | 20 |
| AP57.2 | Invoice Inquiry | 0 | 4 |
| AP58.1 | Vendor Bank | 2 | 8 |
| AP62.1 | Vendor Attribute Interface Maintenance | 1 | 7 |
| AP80.1 | Bill of Exchange Cashing Selection | 5 | 18 |
| AP80.2 | Selection Criteria | 2 | 3 |
| AP81.1 | Manual Forms Reservation | 10 | 17 |
| AP88.1 | Company, Process Level Dictionary Inquiry | 1 | 0 |
| AP88.2 | Vendor, Invoice Dictionary Inquiry | 0 | 1 |
| AP88.3 | Vendor and Invoice Dictionary Maint | 1 | 0 |
| AP89.1 | Company Audit Inquiry | 0 | 2 |
| AP89.3 | Process Level Audit Inquiry | 0 | 2 |
| AP90.1 | Invoice Search by Vendor, Invoice | 27 | 52 |
| AP90.2 | Invoice Search by Invoice Date | 0 | 6 |
| AP90.3 | Invoice Search by Voucher | 0 | 3 |
| AP90.4 | Invoice Search by Purchase Order | 0 | 7 |
| AP90.5 | Cash Payment Inquiry | 9 | 20 |
| AP90.6 | Company Vendor Balances | 0 | 6 |
| AP90.7 | Vendor Group Vendor Balances | 0 | 5 |
| AP90.8 | Selection Criteria | 0 | 2 |
| AP90.9 | Vendor Customer Net Balances | 0 | 2 |
| AP91.1 | Vendor Activity | 27 | 52 |
| AP91.2 | Bill of Exchange Inquiry | 1 | 2 |
| AP91.4 | Selection Criteria | 1 | 6 |
| AP91.5 | Vendor History | 0 | 4 |
| AP91.6 | Vendor History Analysis | 0 | 4 |
| AP92.1 | Vendor Invoices | 0 | 4 |
| AP92.2 | Pay Group Invoices | 0 | 4 |
| AP92.3 | Selection Criteria | 0 | 6 |
| AP92.4 | Selection Criteria | 0 | 6 |
| AP93.1 | Archived Vendor Invoices | 0 | 3 |
| AP93.2 | Archived Pay Group Invoices | 0 | 4 |
| AP93.3 | Selection Criteria | 0 | 6 |
| AP93.4 | Selection Criteria | 0 | 6 |
| AP95.1 | Invoice Distributions | 4 | 12 |
| AP95.2 | GL Account Distributions | 1 | 9 |
| AP95.3 | Activity Distributions | 1 | 11 |
| AP96.1 | Archived Invoice Search by Vendor, Invoice | 0 | 6 |
| AP96.2 | Archived Invoice Search by Voucher | 0 | 2 |
| AP96.3 | Archived Invoice Search by Purchase Order | 0 | 3 |
| AP96.4 | Archived Accounts Payable Selection Criteria | 0 | 2 |
| AP97.1 | Retainage Invoice Inquiry By Vendor Agreement | 0 | 9 |
| AP97.2 | Retainage Invoice Inquiry By Purchase Order | 0 | 9 |
| AP97.3 | Retainage Totals | 0 | 5 |
| AP97.5 | Retainage Totals | 0 | 4 |
| AP98.1 | AP Vendor Audit View | 0 | 5 |
| AP98.2 | AP Vendor Location Audit View | 0 | 5 |
| AP98.3 | AP Invoice Audit View | 0 | 4 |
| APBD.1 | AP BOD Maintenance | 7 | 1 |
| APBD.2 | AP BOD Inquiry | 0 | 13 |
| APCP.1 | APC Comments | 0 | 5 |
| APDS.1 | Call program for APDISCTKN | 1 | 0 |
| APH1.1 | APC Comments | 0 | 2 |
| API1.1 | Add Invoice | 214 | 236 |
| API2.1 | Add Invoice | 204 | 227 |
| API3.1 | Vendor Location Invoke | 29 | 49 |
| API4.1 | Vendor Master Invoke | 27 | 51 |
| API5.1 | Invoice Balancing | 4 | 11 |
| API6.1 | Next Voucher Invoke | 1 | 3 |
| API6.2 | Invoke for POAPIPD | 4 | 8 |
| API6.3 | Invoice Comments Create | 0 | 1 |
| API6.4 | Invoke for POSAC70PD | 2 | 2 |
Batch programs (92)
| Program | Description | Updates | References |
|---|---|---|---|
| AP100 | Vendor Group Copy | 9 | 21 |
| AP101 | Pay Group Update | 10 | 4 |
| AP102 | Process Group Update | 3 | 7 |
| AP109 | Vendor Current Address Update | 3 | 26 |
| AP110 | Mass Vendor Update | 27 | 61 |
| AP111 | Vendor Deletion | 1 | 26 |
| AP115 | Vendor Merge | 101 | 101 |
| AP125 | Batch Release | 215 | 235 |
| AP126 | Mass Invoice Release | 215 | 235 |
| AP130 | Proof of Delivery Statements | 3 | 9 |
| AP131 | Chargeback | 178 | 184 |
| AP133 | Mass Retainage Payment Adjust | 5 | 11 |
| AP135 | Vendor, Invoice Audit Report | 2 | 7 |
| AP136 | Invoice Accrual Reconciliation | 6 | 19 |
| AP141 | Mass Invoice Hold | 4 | 7 |
| AP144 | Tax Identification Notification | 2 | 3 |
| AP145 | 1099 Forms Creation | 1 | 13 |
| AP146 | 1099 Tape Creation | 1 | 13 |
| AP150 | Cash Requirements | 34 | 70 |
| AP151 | Bill of Exchange Generation | 10 | 37 |
| AP155 | Payment Forms Creation | 12 | 29 |
| AP156 | Bill of Exchange Creation | 7 | 21 |
| AP160 | Payment Tape Creation | 16 | 39 |
| AP161 | Electronic Payment File Creation | 15 | 45 |
| AP162 | Vendor Attribute Interface | 4 | 5 |
| AP166 | Bill of Exchange Bank Statement | 6 | 10 |
| AP167 | Bill of Exchange Cashing Statement | 6 | 3 |
| AP170 | Payment Closing | 52 | 76 |
| AP175 | Invoice Distribution Closing | 6 | 25 |
| AP176 | Match Discount Accrual | 5 | 15 |
| AP177 | Financial Reporting Update | 4 | 1 |
| AP178 | Paid Invoice Activity Update | 5 | 16 |
| AP180 | Bill of Exchange Cashing Update | 45 | 42 |
| AP181 | Bill of Exchange Statement Update | 47 | 42 |
| AP185 | Bill of Exchange Distribution Posting | 4 | 9 |
| AP189 | Company, Process Level Audit Report | 4 | 5 |
| AP190 | Invoice Reinstatement | 60 | 52 |
| AP191 | Unrealized Gain or Loss | 10 | 22 |
| AP193 | Recurring Invoice Update | 29 | 62 |
| AP195 | Period Closing | 15 | 17 |
| AP197 | Vendor Balance Rebuild | 2 | 8 |
| AP198 | Invoice Data Archival | 31 | 13 |
| AP199 | Vendor Balance Year End | 4 | 1 |
| AP200 | Vendor Group, Company Listing | 5 | 16 |
| AP201 | Pay Group Listing | 2 | 8 |
| AP202 | Process Group Listing | 1 | 4 |
| AP205 | Accounts Payable Codes Listing | 2 | 21 |
| AP210 | Vendor Listing | 29 | 54 |
| AP211 | Vendor Invoicing | 5 | 36 |
| AP212 | Comments Listing | 1 | 8 |
| AP213 | Vendor Account Balance | 1 | 12 |
| AP214 | Bill of Exchange Maturity List | 1 | 2 |
| AP220 | Invoice Edit Report | 91 | 100 |
| AP221 | Potential Duplicate Payments | 2 | 4 |
| AP225 | Vendor Statements | 3 | 11 |
| AP230 | Open Payables Report | 4 | 17 |
| AP232 | Invoice Accrual Reconciliation Report | 6 | 20 |
| AP233 | Retainage Invoice Listing | 2 | 14 |
| AP235 | Incoming Invoice Register | 1 | 4 |
| AP236 | Invoice Payment Approval Edit | 2 | 6 |
| AP237 | Distribution Approval Listing | 2 | 11 |
| AP240 | Hold Payments Report | 1 | 14 |
| AP245 | Reportable Income Report | 1 | 21 |
| AP246 | Secondary Withholding Report | 1 | 20 |
| AP250 | Cash Forecasting | 3 | 17 |
| AP251 | Match Analysis Report | 2 | 9 |
| AP252 | Unmatched Invoice Listing | 1 | 9 |
| AP255 | Bank Account Payment History | 10 | 20 |
| AP256 | Foreign Payment Statistics Report | 1 | 8 |
| AP262 | Vendor Attribute Interface Listing | 1 | 4 |
| AP265 | Cash Payment Register | 16 | 29 |
| AP266 | Bill of Exchange Report | 3 | 5 |
| AP270 | Vendor Payment History | 4 | 13 |
| AP271 | Vendor Spend Report | 28 | 56 |
| AP272 | Accounts Payable Tax Exempt Transaction Report | 1 | 8 |
| AP275 | Invoice Distribution History | 2 | 14 |
| AP282 | French DAS2 Preparation Report | 1 | 6 |
| AP284 | Vendor Grand Livre | 1 | 13 |
| AP290 | Vendor Labels | 1 | 9 |
| AP295 | Invoice Processing Statistics | 1 | 8 |
| AP300 | Invoice and Vendor History Purge | 67 | 73 |
| AP305 | Accounts Payable Company Purge | 133 | 97 |
| AP510 | Vendor Conversion | 191 | 196 |
| AP520 | Invoice Interface | 54 | 97 |
| AP590 | AP Vendor CSV | 1 | 29 |
| AP700 | Accounts Payable Taxable Upgrade or Conversion | 2 | 2 |
| AP702 | Update Active Status Default | 5 | 0 |
| AP750 | AP shell program for FIN BOD | 1 | 6 |
| AP788 | AP Dictionary Load | 3 | 0 |
| AP810 | Retail Vendor Export | 2 | 5 |
| AP912 | Vendor and Invoice Comment Conversion | 1 | 2 |
| ZA161 | Electronic Payment File Creation | 14 | 32 |
Other tables used by Accounts Payable programs (457)
ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE, ACASSIGN, ACBILL, ACBILLX, ACBRDNTRAN, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATMXVAL, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACCTRCATGX, ACDETAIL, ACDETAILAU, ACGRPMXVAL, ACHEADER, ACHEADERAU, ACIFACTV, ACPRDPERF, ACROLE, ACSTATUS, ACTRANS, ADDRDATA, AMACCOUNT, AMACCTAU, AMACCTGPAU, AMACCTGRP, AMASSET, AMASSETADJ, AMASSETBOD, AMASSETDSP, AMASSETGRP, AMASSETTRF, AMASTBKADJ, AMASTBKDSP, AMASTBKTRF, AMASTBOOK, AMASTITADJ, AMASTITDSP, AMASTITEM, AMASTITTRF, AMASTMXVAL, AMASTRECAP, AMASTRPAIR, AMASTTYPAU, AMASTTYPE, AMAUGROUP, AMAUGRPAU, AMBKHIST, AMBKHISTX, AMBKTEMPLT, AMBKTRANS, AMBOOK, AMCALENDAR, AMCLASSDEP, AMCNTRLAU, AMCOMPUTE, AMCONTROL, AMCTLTRANS, AMDICT2, AMDIVISION, AMDIVISNAU, AMINTER, AMINTERAU, AMLOCATION, AMLOCAUDIT, AMLOCDTL, AMMETHOD, AMMONITOR, AMPOASTDTL, AMPOASTHDR, AMPODFLTS, AMPUCODE, AMPUHIS, AMRPRINTER, AMSEGBLOCK, AMSYSOPTAU, AMTABLEPCT, AMTABLETAX, AMTAXAUTH, AMTEMPLATE, AMTRANS, AMTRANSBOD, AMTRANSUMM, AMTYPALLOC, AMTYPALLOX, AMUOPPDS, ARCOMP, ARCUSTGRP, ARCUSTOMER, AUMXVALUAU, AUMXVLDTAU, BILLTO, BUYBOD, BUYCLASS, BUYCMPLOC, BUYER, BUYVENPF, C3BODRET, C3DTLRET, CAALLOCGRP, CAALOCGPAU, CADETAIL, CADETAILAU, CAHEADER, CAHEADERAU, CBADJUST, CBAUTONBR, CBBALANCE, CBBANKENT, CBBANKINST, CBCASHCODE, CBCASHFORM, CBCCGRP, CBCCTRNJB, CBCHECK, CBCHRGCODE, CBCONSOL, CBCPYCASH, CBDISTRIB, CBDRFTFORM, CBESCHEAT, CBGRPCC, CBMXVALUE, CBPAYMENT, CBPMTCAT, CBPMTFORM, CBRECPTHDR, CBSEGBLOCK, CBSTATEMNT, CBSTMTDTL, CBTRANS, CBTRANSAUD, CBTRANSBOD, CBUSER, CBUSRCLASS, COCOMP, COLINE, COMPONENT, COSGBLK, CUACCT, CUACCTAU, CUCODES, CUCODESAU, CUCONV, CUCONVAU, CURELAT, CURELATAU, CUSTDESC, CUSTORDER, CUTABLE, CUTABLEAU, CUTRANSL, CUTRNSLAU, CXBURDEN, CXCASEPREF, CXCOMPANY, CXCPIUAVAL, CXITEMHIST, CXPREFITEM, CXPTMPITEM, ETEMPVEN, FBADJCODAU, FBCNTRLAU, FBDETAIL, FBDETAILAU, FBFNDHDRAU, FBFUNDAMT, FBFUNDDTL, FBHEADER, FBHEADERAU, FBHSTHDRAU, FBINTBUAU, FBSPREADAU, FBTRANS, FBTRANSAU, FBYETR, FOBCODE, GLACCTVLD, GLACMXVLAU, GLADDRESS, GLAMOUNTS, GLAUTMXVAU, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCHTDTLAU, GLCNTRLAU, GLCODES, GLCOMMIT, GLCOMMITX, GLCONTROL, GLCPYGRP, GLHISCOMBL, GLHISCOMX, GLINTCO, GLMASTER, GLMASTERAU, GLNAMES, GLNAMESAU, GLNLOC, GLNLOCDTL, GLSRCCODE, GLSYSTEM, GLSYSTEMAU, GLTRANS, GLZONE, GMAWARD, GMFNDACT, GTMXVALUAU, HCCHRGITEM, HCHPPAUDIT, HCPATCHRG, HCPATPROC, HCPATVISIT, ICBIN, ICCATEGORY, ICCOMPANY, ICCOUT, ICFACILITY, ICHISTORY, ICICLAUDIT, ICICRAUDIT, ICITEMCODE, ICITEMGTIN, ICLOCATION, ICLOCGRP, ICLOT, ICMANFCODE, ICMFGCODE, ICMFGDIST, ICRECEIPTS, ICTRANS, ICTRANSDTL, ICVALUOM, IFBCIQUEUE, INDOCTPCD, INFERCONCD, INLINETYPE, INRPTTBL, INSTATPROC, INSTCMDTY, INSTCTRYCD, INSTDETAIL, INSTHEADER, INSTNBR, INSTNOTC, INSTPORTS, INSTREGN, ITEMGROUP, ITEMLOC, ITEMMAST, ITEMSPECL, ITEMSRC, ITEMSUB, ITSERIAL, JBKACCT, JBKOPCODE, JBKSEQNBR, JBKSYSCODE, JBOOKHDR, KITITEM, KWDDETAIL, KWDMASTER, KWDSETUP, KWDSYNONYM, LANGPREF, LMDISTRIB, LMDSTRIBAU, LMINTEREST, LMINVAU, LMINVOICE, LMLEASE, LMLEASESEG, LMPAYDTL, LMTRANS, MAAOCDTL, MAAOIHIST, MACAPDTL, MACOMPANY, MAELMGPREL, MAELMVALUE, MAFRXREF, MAINVDTL, MAINVHAND, MAINVMSG, MAINVREF, MAMAAHIST, MAMADHIST, MAMATCHTBL, MAMSGTOL, MAMTCHELEM, MAMTCHRULE, MAPOINV, MAREASONCD, MATCHCLASS, MFGSHPFAC, MLCOLEDGER, MMDIST, MMUAVAL, MXCATDEF, MXCATDEFAU, MXELEMENT, MXELEMNTAU, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXLSTDTLAU, MXLSTHDRAU, MXOBJCAT, MXOBJCATAU, MXTMPDTLAU, MXTMPHDRAU, MXTMPLDTL, MXTMPLHDR, MXTPEFDTAU, MXTPHEDTAU, MXVALIDATE, MXVALIDAU, MXVEWDTLAU, MXVEWHDRAU, NATACCT, NATBALANCE, OECOMPANY, OECUST, OEFRTCODE, OEROUTE, ORDERTYPE, PDCARD, PDCCHRGERR, PDCHRGDTL, PDMERCHANT, PDMERCHGDT, PDMERCHGRP, PDPROGRAM, PJLBOD, POAGMAUDIT, POAGMTPART, POAGMTPRIC, POAOCDTL, POAOCMAST, POAOCSPRD, POAPPCODE, POAPPROVE, POAUDIT, POAUDRULES, POAUDTYPE, POCODE, POCOMPANY, POCONTGRP, POCONTRACT, POCONTREB, PODOCREF, POFRTTERM, POHDROUT, POHDRPVT, POINTAOC, POINTAUDIT, POINTERFAC, POITEMVEN, POIVACMNT, POLINE, POLINEOUT, POLINEPVT, POLINESRC, POMATCHOBJ, POMESSAGE, POMXVAL, POPCRUF, POPLIUF, POPOVUF, POPSPHIST, POREBDIST, POREBDUE, POREBRECD, PORECADJHD, PORECADJLN, PORECEIVE, PORECLINE, PORETURNHD, PORETURNLN, POREVISION, PORLNUF, PORQHUF, POTRACK, POTRANSDTL, POVACOMMIT, POVACOMMIX, POVADIST, POVAGLNERR, POVAGRMTHD, POVAGRMTLN, POVAPARTLN, POVENDLOC, POVENDOR, PROCLEV, PROCTEMPLN, PROCUREGRP, PTHBOD, PURCHORDER, PVHBOD, PWEXPENSE, REASON, RECAOCDTL, REQHEADER, REQLINE, REQUESTER, RJBRIDGE, RJCNTRLAU, RJCONTROL, RJMXVALUAU, RJSCHEDULE, ROUTEDOC, ROUTEHDR, ROUTESTOP, RQAUDIT, RQLMXVAL, RQLOC, RQRQLAUDIT, RQTRANS, SOHDETAIL, STATICCUST, STCOMMCODE, STRUCTURE, SUBCKPOINT, SYSTEMCODE, TERMS, TXCALDTL, TXCALENDAR, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, TXTAXTRAN, TXUSAGECD, WFSETUP, WHDEMAND, WHDEMNDHDR, WHPROCTYPE, WHSHIPLINE, WHSHIPMENT, WHSHLAUD