APVENMAST – Vendor Master Record
- System
- Accounts Payable (AP)
- Prefix
VEN- Primary key
VENDOR-GROUP,VENDOR- Fields
- 184
- Updated by
- 306 programs
- Referenced by
- 192 programs
APVENMAST is the Vendor Master Record table in Lawson Accounts Payable (prefix VEN). It is indexed by VENDOR-GROUP, VENDOR (VENSET1); alternate indexes: VENSET10, VENSET11, VENSET2, VENSET3, VENSET4, VENSET5, VENSET6, VENSET7 and 2 more. It is related 1:1 to APVENADDR, APPROCGRP, APVENGROUP, APVNBOD, GLNLOC, GLNLOCDTL, MAMTCHRULE and PROCUREGRP and 1:M to APAPIHIST, APAUDIT, APCOMMENTS, APCONTACT, APCPYVND, APHLDINV, APINVOICE, APVENADDR and 9 more. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 298 more and referenced by AC210, AC297, AM18.1, AP00.1, AP00.3, AP02.3, AP102, AP109 and 184 more. The table has 184 fields, 11 indexes and 28 documented relations.
About APVENMAST
The Vendor file contains accounts payable vendor records, including one-time vendors defined during invoice entry. If the vendor has default codes defined at a company level, the vendor record has one or more associated records in the Vendor Company Codes file.
Fields (184)
Column = COBOL field name without the VEN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
VEN-VENDOR-GROUP PKVENDOR_GROUP | Alpha 4 | The vendor group to which the vendor belongs. Must be a valid record in the Vendor Group file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The identification number assigned to the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VEN-CLASSVEN_CLASS | Alpha 3 | The vendor class the vendor is assigned to. Represents a group of vendors that share common characteristics within a vendor group. Must be a valid record in the Vendor Class file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VENDOR-VNAMEVENDOR_VNAME | Alpha 30 (Lower Case) | The vendor name or description. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VENDOR-SNAMEVENDOR_SNAME | Alpha 30 | The search name for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VENDOR-CONTCTVENDOR_CONTCT | Alpha 30 | The name of the main contact for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-REMIT-TO-CODEREMIT_TO_CODE | Alpha 4 | The normal remittance location for the vendor, if defined. Must be a valid record in the Vendor Location file. If present, the address defined for the location overrides the vendor address on vendor payments when invoices are added. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PURCH-FR-LOCPURCH_FR_LOC | Alpha 4 | The normal purchasing location for the vendor, if defined. Must be a valid record in the Vendor Location file. If present, the address defined for the location overrides the vendor address for storing vendor purchase activity balances. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PAY-VENDORPAY_VENDOR | Alpha 9 (Right Justified) | The pay vendor for the vendor, if applicable. Used to send invoice payments to another vendor within the same vendor group. If present, the pay vendor relationship overrides the normal remit-to information for the vendor, including remit-to name and address, cash code, and payment code. Must be a valid record in the Vendor file. Although payments are remitted to the pay vendor, the invoiced vendor accumulates the payment balance. If more than one vendor shares the same pay vendor, the system creates a single payment for the pay vendor and lists individual invoiced vendors and invoice numbers that are included in the payment on the remittance. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VENDOR-STATUSVENDOR_STATUS | Alpha 1 | The vendor status. Invoices cannot be entered for a vendor with an Inactive status. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VEN-PRIORITYVEN_PRIORITY | Numeric 2 | The payment priority assigned to the vendor. Valid values are 1 (highest priority) through 99 (lowest priority). | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PHONE-PREFIXPHONE_PREFIX | Alpha 6 | The country code for the vendor telephone number. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PHONE-NUMPHONE_NUM | Alpha 15 | The telephone number for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PHONE-EXTPHONE_EXT | Alpha 5 | The telephone extension number for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-FAX-PREFIXFAX_PREFIX | Alpha 6 | The country code for the fax machine telephone number. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-FAX-NUMFAX_NUM | Alpha 15 | The fax machine telephone number. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-FAX-EXTFAX_EXT | Alpha 5 | The fax machine telephone number extension. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TELEX-NUMTELEX_NUM | Alpha 15 | The telex number for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TERM-CODETERM_CODE | Alpha 5 | The payment terms code assigned to the vendor. Used to automatically calculate invoice due date and discount information for the vendor's invoices. Must be a valid record in the Terms Code file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INV-CURRENCYINV_CURRENCY | Alpha 5 | The currency used to add invoices for the vendor. The currency code defaults on the vendor's invoices during entry. Must be a valid record in the Currency Code file. If left blank, the vendor uses the invoice currency assigned to the vendor class, if assigned, or the company base currency. If the Balance Currency field contains a non-base currency, the Invoice Currency must be either the same non-base currency or the company base currency. If the Balance Currency field contains the company base currency, the Invoice Currency can be a non-base currency. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BAL-CURRENCYBAL_CURRENCY | Alpha 5 | The currency used to store vendor balance information. Must be a valid record in the Currency Code file. If left blank, the company base currency is used. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CURR-RECALCCURR_RECALC | Alpha 1 | If the Invoice Currency is different from the company base currency, this field indicates whether the system will recalculate the invoice currency when the invoice is paid to account for exchange rate fluctuations. If Yes is selected in this field, the system compares the exchange rate in effect when the invoice was entered to the exchange rate in effect when the invoice is scheduled for payment by AP150 (Cash Requirements). If a difference exists, AP170 (Payment Closing) creates a currency gain or loss transaction. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SEP-CHK-FLAGSEP_CHK_FLAG | Alpha 1 | Indicates whether to create a separate payment for each invoice entered for the vendor. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TAX-IDTAX_ID | Alpha 20 | The tax identification number for the vendor. Used for reporting reportable vendor income. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TAX-EXEMPT-CDTAX_EXEMPT_CD | Alpha 1 | Code indicating the taxing status. E - Exempt, T - Taxable. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TAX-CODETAX_CODE | Alpha 10 | The tax code assigned to the vendor. Used to automatically calculate invoice tax information. Must be a valid record in the Tax Code file. If left blank, the tax code assigned to the vendor class defaults. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-HOLD-FLAGHOLD_FLAG | Alpha 1 | This field enables this entire lot to be put on hold, not allowing any issues or transfers to be made for this lot. " "
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-DIST-CODEDIST_CODE | Alpha 9 | The distribution code assigned to the vendor. Used to automatically create distribution lines for the vendor's invoices. Must be a valid record in the Distribution Code file. If left blank, the distribution code assigned to the vendor class, if assigned, defaults. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ACCR-CODEACCR_CODE | Alpha 4 | The invoice accrual code assigned to the vendor. Used to default a general ledger accrual account to the vendor's invoices during entry. Must be a valid record in the Invoice Accrual Code file. If left blank, the invoice accrual code assigned to the vendor class, if assigned, or the company defaults. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-INST-CODEBANK_INST_CODE | Alpha 3 | The payment code assigned to the vendor. Represents a type of cash payment, such as a check or payment tape, or a bill of exchange payment. Must be a valid cash or bill of exchange payment transaction code record in the Bank Transaction Code file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CASH-CODECASH_CODE | Alpha 4 | The cash code assigned to the vendor. Represents a bank account. Must be a valid record in the Cash Code file. If left blank, the cash code assigned to the vendor class, if assigned, defaults, or the vendor uses the cash code assigned to the company or the pay group. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-ENTITYBANK_ENTITY | Alpha 15 | The bank identification used to deposit electronic payments for the vendor. This field is required for ACH or BACS payment types. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-CURRENCYBANK_CURRENCY | Alpha 5 | This field contains the bank currency code | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VBANK-ACCT-NOVBANK_ACCT_NO | Alpha 35 | The bank account number used to deposit electronic payments for the vendor. This field is required for ACH or BACS payment types. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VBANK-ACCT-TPVBANK_ACCT_TP | Alpha 1 | Indicates the type of bank account used to deposit electronic payments for the vendor. Valid values are: selected.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VBANK-IDENTVBANK_IDENT | Alpha 1 | This field indicates if the account number is an IBAN number that requires an account validation check.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CROSS-IDENTCROSS_IDENT | Alpha 1 | This field is used to distinguish between SWIFT ID numbers and Routing numbers.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INCOME-CODEINCOME_CODE | Alpha 4 | The income code assigned to the vendor. Used to track reportable income for the vendor. Must be a valid record in the Income Code file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INCOME-WH-FLGINCOME_WH_FLG | Alpha 1 | Indicates whether invoices for the vendor are subject to reportable income withholding. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-EDI-NBREDI_NBR | Alpha 15 | The vendor's electronic data interchange (EDI) number. Used for reference. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ACH-PRENOTACH_PRENOT | Alpha 1 | Used in conjunction with ACH payments created for the vendor. Indicates the status of the electronic payment between the vendor and the processing bank. Valid values are: (AP160) automatically changes the status from Prenotified to Notified to indicate that the processing bank has been notified but has not yet accepted the electronic payment tape. when first entering ACH information to prenotify the processing bank. Accepted once the processing bank accepts the electronic payment tape.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-MAX-INV-AMTMAX_INV_AMT | Signed 18.2 | The maximum single invoice amount that can be entered for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | The date the vendor record was created in Accounts Payable. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ORIGIN-DATEORIGIN_DATE | Numeric 8 (yyyymmdd) | The origin date for the vendor. Can be used record additional information, such as the date the vendor relationship began. If left blank, the system date defaults. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-OPERATOROPERATOR | Alpha 10 | The operator associated with maintaining the vendor record. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-USER-NAME-01USER_NAME_01 | Alpha 20 | The value of the information being tracked for the vendor in the first vendor group user field. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-USER-NAME-02USER_NAME_02 | Alpha 20 | The value of the information being tracked for the vendor in the second vendor group user field. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-USER-NAME-03USER_NAME_03 | Alpha 20 | The value of the information being tracked for the vendor in the third vendor group user field. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-USER-NAME-04USER_NAME_04 | Alpha 20 | The value of the information being tracked for the vendor in the fourth vendor group user field. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-USER-NAME-05USER_NAME_05 | Alpha 20 | The value of the information being tracked for the vendor in the fifth vendor group user field. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-USER-NAME-06USER_NAME_06 | Alpha 20 | The value of the information being tracked for the vendor in the sixth vendor group user field. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CUST-GROUPCUST_GROUP | Alpha 5 | If the accounts payable vendor is also a customer in the Lawson Accounts Receivable system, this field can be used to identify the customer group associated with the corresponding accounts receivable customer. Used to update the accounts receivable customer record. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CUSTOMERCUSTOMER | Alpha 9 (Right Justified) | If the accounts payable vendor is also a customer in the Lawson Accounts Receivable system, this field can be used to identify the corresponding accounts receivable customer number. Used to update the accounts receivable customer record. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-LEGAL-NAMELEGAL_NAME | Alpha 80 (Lower Case) | The legal name for the vendor. Used for reporting reportable vendor income. If left blank, the Vendor Name defaults. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PRIME-RATEPRIME_RATE | Signed 7.5 | The percentage used to calculate anticipation discount invoices; most often the prime rate plus one percent. To calculate the discount for an anticipation invoice, the system subtracts the invoice payment date from the invoice due date to calculate the number of days paid early, multiplies the number of days paid early by 365 days, multiplies the result by the anticipation discount rate, and multiplies the result by the payment amount to calculate the discount amount. Anticipation discount terms codes are defined in Terms. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INVOICE-GROUPINVOICE_GROUP | Alpha 4 | A user-defined invoice group assigned to the vendor. This value defaults on invoices entered for the vendor. Can be used to select invoices for payment in AP150 (Cash Requirements). | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-DISCOUNT-CODEDISCOUNT_CODE | Alpha 10 | The discount code assigned to the vendor. Used to default a general ledger discount account on the vendor's invoices during entry. Must be a valid record in the Discount Code file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ERS-CAPABLEERS_CAPABLE | Alpha 1 | Indicates whether the vendor location has the capability to process ERS. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INVC-REF-TYPEINVC_REF_TYPE | Alpha 2 | Indicates the type of number the vendor is providing to reference the invoice. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-EDI-AUTO-RELEDI_AUTO_REL | Alpha 1 | Indicates whether the company automatically releases EDI invoices. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-AUTH-CODEAUTH_CODE | Alpha 3 | The authority code assigned to the vendor, if assigned. Represents a person or department responsible for approving registered invoices for the vendor. This code defaults on the vendor's invoices during entry. Must be a valid authority code in the Authority Code file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-APPRVL-EXISTSAPPRVL_EXISTS | Alpha 1 | Indicates whether approval criteria is defined for the vendor. If Yes, one or more associated approval records exist for the vendor in the Invoice Approval file. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ACTIVITYACTIVITY | Alpha 15 | The activity assigned to the vendor, if assigned. Activities are the tasks that make up an activity group. Activities identify work being done, such as work orders, phases, products, and so on. Must be a valid record in the Activity file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | The account category assigned to the vendor. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting. Must be a valid record in the Activity Account Category file. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CHARGE-CODECHARGE_CODE | Alpha 1 | Indicates who pays service charges or fees associated with a SWIFT payment. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PMT-CAT-CODEPMT_CAT_CODE | Alpha 6 | Indicates the payment category of the SWIFT payment. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-NORM-EXP-CODENORM_EXP_CODE | Alpha 1 | Indicates whether the SWIFT payment is a normal or express payment. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PMT-FORMPMT_FORM | Alpha 2 | Indicates how the SWIFT payment is made. Valid values are:
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SWIFT-IDSWIFT_ID | Alpha 12 | The SWIFT identification number assigned to the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PROC-GRPPROC_GRP | Alpha 4 (Lower Case) | A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-MATCH-TABLEMATCH_TABLE | Alpha 10 | A code representing a match table. A match table contains the processing rules that will be used during matching. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-DISC-CALC-DATEDISC_CALC_DATE | Alpha 1 | Select which date to use when calculating discounts. You can use the invoice date, receipt date, or the date the invoice was received. " "
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CREATE-POD-FLCREATE_POD_FL | Alpha 1 | Indicates whether to create a proof of delivery. Valid values are: " "
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-HANDLING-CODEHANDLING_CODE | Alpha 4 | Invoice handling code. Determines the processing rules that will be used during matching. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ENCLOSUREENCLOSURE | Alpha 1 | Indicates whether the invoice requires an enclosure with its payment. " "
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-REQ-MATCH-REFREQ_MATCH_REF | Alpha 1 | Indicates whether a match reference number is required for invoices for this vendor.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-POOL-OPTIONPOOL_OPTION | Numeric 1 | —
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-HOLD-INSP-FLAGHOLD_INSP_FLAG | Alpha 1 | If set to "Y", this flag will keep receiving lines requiring inspection from being matched until they have been inspected. " " = Use Company
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-WRITE-OFF-AMTWRITE_OFF_AMT | Signed 18.2 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VEN-CLAIM-TYPEVEN_CLAIM_TYPE | Alpha 2 | —
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CLAIM-HOLD-CDCLAIM_HOLD_CD | Alpha 4 | The hold code. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CB-HOLD-CODECB_HOLD_CODE | Alpha 4 | The hold code. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CB-MINIMUM-AMTCB_MINIMUM_AMT | Signed 18.2 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-REPLACE-GOODSREPLACE_GOODS | Alpha 1 | —
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SHIP-OR-HOLDSHIP_OR_HOLD | Alpha 1 | —
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ERS-HANDLINGERS_HANDLING | Alpha 4 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-E-MAIL-ADDRESSE_MAIL_ADDRESS | Alpha 60 (Lower Case) | e-mail address. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-URL-ADDRURL_ADDR | Alpha 60 (Lower Case) | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VEND-ACCTVEND_ACCT | Alpha 30 | The customer number the vendor has assigned to you. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-LANGUAGE-CODELANGUAGE_CODE | Alpha 10 | Language Code (LOCALE). | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TAX-USAGE-CDTAX_USAGE_CD | Alpha 10 | The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VAT-REG-CTRYVAT_REG_CTRY | Alpha 2 | The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VAT-REG-NBRVAT_REG_NBR | Alpha 12 | The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VALIDATE-POVALIDATE_PO | Alpha 1 | " " = MA Company Default
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-REQUIRE-POREQUIRE_PO | Alpha 1 | " " = MA Company Default
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-LOC-INDICATORLOC_INDICATOR | Derived | When selecting a vendor from a list of available vendors, an asterisk (*) displays if alternate locations exist for a vendor. | — |
VEN-SHORT-VNAMESHORT_VNAME | Derived | A short name for the vendor. Used for display purposes. | — |
VEN-VCOMMENT-EXISTVCOMMENT_EXIST | Derived | When selecting a vendor from a list of available vendors, an asterisk (*) displays if comments exist for a vendor. | — |
VEN-VDR-ADDR1VDR_ADDR1 | Derived | Vendor address line 1. | — |
VEN-VDR-ADDR2VDR_ADDR2 | Derived | Vendor address line 2. | — |
VEN-VDR-ADDR3VDR_ADDR3 | Derived | Vendor address line 3. | — |
VEN-VDR-ADDR4VDR_ADDR4 | Derived | Vendor address line 4. | — |
VEN-VDR-CITY-ADDR5VDR_CITY_ADDR5 | Derived | Vendor city or address line 5. | — |
VEN-VDR-STATEVDR_STATE | Derived | Vendor state or province. | — |
VEN-VDR-POSTALVDR_POSTAL | Derived | Vendor postal code. | — |
VEN-VDR-COUNTYVDR_COUNTY | Derived | Vendor county. | — |
VEN-VDR-COUNTRYVDR_COUNTRY | Derived | Vendor country. | — |
VEN-VAT-NBRVAT_NBR | Derived | The concatenation of the VAT-REG-CTRY and VAT-REG-NBR fields, used as VAT reporting ID. | — |
VEN-WORKFLOW-GROUPWORKFLOW_GROUP | Alpha 20 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-MBL-INT-PREFIXMBL_INT_PREFIX | Alpha 6 | This field contains the country code of the mobile phone number. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-MOBILE-NUMMOBILE_NUM | Alpha 15 | This field contains the mobile phone number. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-MOBILE-EXTMOBILE_EXT | Alpha 5 | This field contains the mobile phone extension number. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PAY-IMM-FLAGPAY_IMM_FLAG | Alpha 1 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-DIVERSE-CODEDIVERSE_CODE | Alpha 5 | Diversity Code for Account Payable Vendors | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-BANK-ENTINTM_BANK_ENT | Alpha 15 | Type the intermediary bank identification used to deposit electronic payments for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-BANK-ACCTINTM_BANK_ACCT | Alpha 35 | Type the intermediary bank account number used to deposit electronic payments for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-BANK-IDNTINTM_BANK_IDNT | Alpha 1 | This field indicates if the account number is and IBAN number that requires an account validation check.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-BANK-CURRINTM_BANK_CURR | Alpha 5 | This field contains the intermediary bank currency code. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-PRENOTINTM_PRENOT | Alpha 1 | If you create intermediary ACH payments for the vendor, select the prenotification status. Indicates the status of the electronic payment between the vendor and the processing bank.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-SWIFT-IDINTM_SWIFT_ID | Alpha 12 | Use SWIFT Payment Options (AP10.8) to define SWIFT payment options if you create Intermediary SWIFT payments for the vendor. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-PMT-CATINTM_PMT_CAT | Alpha 6 | Select the Intermediary SWIFT payment category.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-NORM-EXPINTM_NORM_EXP | Alpha 1 | Indicates whether the SWIFT payment is a normal or express payment. " " = Not defined for the vendor
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-PMT-FORMINTM_PMT_FORM | Alpha 2 | Indicates how the Intermediary SWIFT payment is made. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-CHRG-CDINTM_CHRG_CD | Alpha 1 | Indicates who pays service charges or fees associated with a Intermediary SWIFT payment. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-CRS-IDENTINTM_CRS_IDENT | Alpha 1 | This field is used to distiguish between SWIFT ID numbers and Routing numbers
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-RULE-GROUPRULE_GROUP | Alpha 10 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-FLOAT-DAYSFLOAT_DAYS | Numeric 3 | This is the number of days to add to the best terms calculation if the vendor will allow a specific number of days for the payment to reach them and still receive the discount. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-MTCH-PREPAY-FLMTCH_PREPAY_FL | Alpha 1 | Flag that notes if the invoice will be prepaid. This is for match invoices. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-MTCH-PREPAY-MTMTCH_PREPAY_MT | Numeric 1 | Flag denotes the method of match prepayment.
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BUILD-SOC-REFBUILD_SOC_REF | Alpha 18 | This field holds an individual account number reference for the Building Society | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BUILD-ACCT-NMBUILD_ACCT_NM | Alpha 18 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-XREF-FLAGXREF_FLAG | Alpha 1 | Use a cross reference table for this vendor
| AP15.1 |
VEN-GIRO-NUMBERGIRO_NUMBER | Alpha 15 | This field is the Bankgiro or Postgiro account number | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CR-CARD-NUMBERCR_CARD_NUMBER | Alpha 16 | This field contains the credit card number. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-INSTRUCT1BANK_INSTRUCT1 | Alpha 35 | This field contains bank instructions. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-INSTRUCT2BANK_INSTRUCT2 | Alpha 35 | This field contains bank instructions. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-INSTRUCT3BANK_INSTRUCT3 | Alpha 35 | This field contains bank instructions. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-INSTRUCT4BANK_INSTRUCT4 | Alpha 35 | This field contains bank instructions. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-AP-OBJ-IDAP_OBJ_ID | Numeric 12 | This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-P-CARD-FLAGP_CARD_FLAG | Numeric 1 | —
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-PCARD-NBRPCARD_NBR | Alpha 16 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VAL-DIV-DATEVAL_DIV_DATE | Alpha 1 | Determines on invoice entry if the invoice date is within the certification dates for the diversity code setup for the vendor on AP14.4 " " = No
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-RET-ACCR-CODERET_ACCR_CODE | Alpha 4 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-GLN-NBRGLN_NBR | Alpha 13 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TIN-TYPETIN_TYPE | Numeric 1 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TIN-NOTTIN_NOT | Numeric 1 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-TIN-VERIFIEDTIN_VERIFIED | Numeric 1 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SEC-WTH-EXEMPTSEC_WTH_EXEMPT | Alpha 1 | —
| AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SEC-WTH-CODE1SEC_WTH_CODE1 | Alpha 10 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SEC-WTH-CODE2SEC_WTH_CODE2 | Alpha 10 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SEC-WTH-CODE3SEC_WTH_CODE3 | Alpha 10 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CREATED-BYCREATED_BY | Alpha 10 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-LAST-UPDT-DATELAST_UPDT_DATE | Numeric 8 (yyyymmdd) | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-LAST-UPDT-TIMELAST_UPDT_TIME | Numeric 8 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-LAST-UPDATE-BYLAST_UPDATE_BY | Alpha 10 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-VALID-CERT-DTVALID_CERT_DT | Alpha 1 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-FOR-ECON-CODEFOR_ECON_CODE | Alpha 10 | — | AP10.1, AP510 |
VEN-SOCIAL-ID1SOCIAL_ID1 | Alpha 80 (Lower Case) | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SOCIAL-ID2SOCIAL_ID2 | Alpha 80 (Lower Case) | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SOCIAL-ID3SOCIAL_ID3 | Alpha 80 (Lower Case) | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SOCIAL-ID4SOCIAL_ID4 | Alpha 80 (Lower Case) | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SOCIAL-ID5SOCIAL_ID5 | Alpha 80 (Lower Case) | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CARRIER-FLAGCARRIER_FLAG | Alpha 1 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-CODEBANK_CODE | Alpha 2 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-BANK-IDBANK_ID | Alpha 9 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-ASSIGNMENT-NBRASSIGNMENT_NBR | Alpha 14 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-DEBITING-SIGNDEBITING_SIGN | Alpha 1 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-BANK-CODEINTM_BANK_CODE | Alpha 2 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-BANK-IDINTM_BANK_ID | Alpha 9 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-ASSIGN-NOINTM_ASSIGN_NO | Alpha 14 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-INTM-DEBITINGINTM_DEBITING | Alpha 1 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-CHK-DIG-TYPECHK_DIG_TYPE | Alpha 10 | — | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source) |
VEN-SEPA-FLAGSEPA_FLAG | Alpha 1 | — | — |
VEN-W8-VERIFIEDW8_VERIFIED | Alpha 1 | — | AP14.5 |
VEN-FATCA-IDFATCA_ID | Alpha 6 | — | AP14.5 |
VEN-FIN-INST-TYPEFIN_INST_TYPE | Alpha 5 | — | AP14.5 |
VEN-GIIN-CAT-CODEGIIN_CAT_CODE | Alpha 2 | — | AP14.5 |
VEN-ISO-CTRY-NBRISO_CTRY_NBR | Numeric 3 | — | AP14.5 |
VEN-FATCA-WITHOLDFATCA_WITHOLD | Signed 7.4 | — | AP14.5 |
VEN-FATCA-INC-CODEFATCA_INC_CODE | Alpha 4 | — | AP14.5 |
VEN-FATCA-AUFATCA_AU | Alpha 15 | — | AP14.5 |
VEN-FATCA-ACCOUNTFATCA_ACCOUNT | Numeric 6 | — | AP14.5 |
VEN-FATCA-SUB-ACCTFATCA_SUB_ACCT | Numeric 4 | — | AP14.5 |
VEN-OPEN-ZERO-COSTOPEN_ZERO_COST | Alpha 1 | Use this field to indicate whether or not the AP vendor will allow a zero-cost invoice line to be left open up through the matching process.
| — |
Indexes (11)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
VENSET1 | VENDOR-GROUP, VENDOR | Primary | AC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source) | |
VENSET10 | VENDOR-GROUP, CREATE-POD-FL, VENDOR | KeyChange | AP130 | |
VENSET11 | AP-OBJ-ID | Subset | Where AP-OBJ-ID != Zeroes | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source) |
VENSET2 | VENDOR-GROUP, VEN-CLASS, VENDOR | KeyChange | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source) | |
VENSET3 | VENDOR-GROUP, USER-NAME-01, VENDOR-SNAME, VENDOR | KeyChange | — | |
VENSET4 | VENDOR-GROUP, VEN-CLASS, VENDOR-SNAME, VENDOR | KeyChange | — | |
VENSET5 | VENDOR-GROUP, VENDOR-SNAME, VENDOR | KeyChange | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source) | |
VENSET6 | PROC-GRP, VENDOR-GROUP, VENDOR | KeyChange | AP02.3, AP202 | |
VENSET7 | VENDOR-GROUP, EDI-NBR, VENDOR | KeyChange | AC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source) | |
VENSET8 | VENDOR-GROUP, VENDOR | Subset | Where ACH-PRENOT = "N" Or ACH-PRENOT = "P" | AP160 |
VENSET9 | HANDLING-CODE, VENDOR-GROUP, VENDOR | KeyChange | MA05.1, MA05.2 |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Address1 | APVENADDR | Required | VEN-VENDOR-GROUP → VDR-VENDOR-GROUP, VEN-VENDOR → VDR-VENDOR, Spaces → VDR-LOCATION-CODE, Spaces → VDR-RESP-CODE, Zeroes → VDR-CONTACT-LVL, "Y" → VDR-CUR-ADDR | |
| Approcgrp | APPROCGRP | Not Required | VEN-PROC-GRP → APQ-PROC-GRP | |
| Apvengroup | APVENGROUP | Required | VEN-VENDOR-GROUP → VGP-VENDOR-GROUP | |
| Apvnbod | APVNBOD | Not Required, Delete Cascades | VEN-VENDOR-GROUP → YBC-VENDOR-GROUP, VEN-VENDOR → YBC-VENDOR | |
| Glnloc | GLNLOC | Not Required | Valid When VEN-GLN-NBR != Spaces | PCG-ITEM-GROUP → GLO-ITEM-GROUP, VEN-GLN-NBR → GLO-GLN-NBR |
| Glnlocdtl | GLNLOCDTL | Not Required | Valid When VEN-GLN-NBR != Spaces | PCG-ITEM-GROUP → GLX-ITEM-GROUP, 7 → GLX-GLN-TYPE, VEN-VENDOR → GLX-VENDOR, Spaces → GLX-LOCATION-CODE, VEN-GLN-NBR → GLX-GLN-NBR |
| Mamtchrule | MAMTCHRULE | Required | VEN-RULE-GROUP → MAU-MATCH-RULE | |
| Procuregrp | PROCUREGRP | Required | VEN-VENDOR-GROUP → PCG-VENDOR-GROUP |
One to many (20) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apapihist | APAPIHIST | VEN-VENDOR-GROUP → AH1-VENDOR-GROUP, VEN-VENDOR → AH1-VENDOR, → AH1-INVOICE, → AH1-SUFFIX, → AH1-CANCEL-SEQ, → AH1-COMPANY | ||
| Apaudit | APAUDIT | VEN-VENDOR-GROUP → APA-VENDOR-GROUP, Zeroes → APA-COMPANY, Spaces → APA-PROC-LEVEL, VEN-VENDOR → APA-VENDOR, Spaces → APA-INVOICE, Zeroes → APA-SUFFIX, Zeroes → APA-CANCEL-SEQ, → APA-SEQ-NBR, → APA-TRANS-DATE, → APA-TRANS-TIME, → APA-LOCATION-CODE | ||
| Apcomments | APCOMMENTS | Delete Cascades | "V" → APC-REC-TYPE, VEN-VENDOR-GROUP → APC-VENDOR-GROUP, VEN-VENDOR → APC-VENDOR, → APC-LOCATION-CODE, → APC-COMPANY, → APC-SEQ-NBR | |
| Apcontacts | APCONTACT | Delete Cascades | VEN-VENDOR-GROUP → VCT-VENDOR-GROUP, VEN-VENDOR → VCT-VENDOR, → VCT-RESP-CODE, → VCT-CONTACT-LVL, → VCT-LOCATION-CODE | |
| Apcpyvnd | APCPYVND | VEN-VENDOR-GROUP → APX-VENDOR-GROUP, VEN-VENDOR → APX-VENDOR, Spaces → APX-LOCATION-CODE, → APX-COMPANY | ||
| Aphldinv | APHLDINV | Delete Cascades | Valid When (VEN-HOLD-FLAG = "Y") | "V" → HLI-REC-TYPE, VEN-VENDOR-GROUP → HLI-VENDOR-GROUP, Zeroes → HLI-COMPANY, VEN-VENDOR → HLI-VENDOR, → HLI-INVOICE, → HLI-SUFFIX, → HLI-CANCEL-SEQ, → HLI-SEQ-NBR, → HLI-VOID-SEQ, → HLI-HLD-CODE |
| Apinvoice | APINVOICE | VEN-VENDOR-GROUP → API-VENDOR-GROUP, VEN-VENDOR → API-VENDOR, → API-INVOICE, → API-SUFFIX, → API-CANCEL-SEQ, → API-COMPANY | ||
| Apvcomments | APCOMMENTS | "V" → APC-REC-TYPE, VEN-VENDOR-GROUP → APC-VENDOR-GROUP, VEN-VENDOR → APC-VENDOR, Spaces → APC-LOCATION-CODE, → APC-COMPANY, → APC-SEQ-NBR | ||
| Apvenaddr | APVENADDR | VEN-VENDOR-GROUP → VDR-VENDOR-GROUP, VEN-VENDOR → VDR-VENDOR, Spaces → VDR-LOCATION-CODE, Spaces → VDR-RESP-CODE, Zeroes → VDR-CONTACT-LVL, → VDR-EFFECTIVE-DATE | ||
| Apvenbal | APVENBAL | Delete Cascades | VEN-VENDOR-GROUP → VBA-VENDOR-GROUP, VEN-VENDOR → VBA-VENDOR, → VBA-COMPANY, → VBA-LOCATION-CODE | |
| Apvenbalmaster | APVENBAL | Delete Cascades | VEN-VENDOR-GROUP → VBA-VENDOR-GROUP, VEN-VENDOR → VBA-VENDOR, Spaces → VBA-LOCATION-CODE, → VBA-COMPANY | |
| Apvencert | APVENCERT | VEN-VENDOR-GROUP → AVT-VENDOR-GROUP, VEN-VENDOR → AVT-VENDOR, → AVT-LOCATION-CODE, → AVT-CERTIF-CODE, → AVT-CERTIF-EFF-DT | ||
| Apvendiv | APVENDIV | VEN-VENDOR-GROUP → VDC-VENDOR-GROUP, VEN-VENDOR → VDC-VENDOR, → VDC-LOCATION-CODE, → VDC-DIVERSE-CODE, → VDC-DCERT-DATE | ||
| Apvendorbal | APVENBAL | VEN-VENDOR-GROUP → VBA-VENDOR-GROUP, VEN-VENDOR → VBA-VENDOR, → VBA-LOCATION-CODE, → VBA-COMPANY | ||
| Apvenloc | APVENLOC | Delete Cascades | VEN-VENDOR-GROUP → VLO-VENDOR-GROUP, VEN-VENDOR → VLO-VENDOR, → VLO-LOCATION-CODE | |
| Apvenpay | APVENPAY | VEN-VENDOR-GROUP → VPY-VENDOR-GROUP, VEN-VENDOR → VPY-VENDOR, → VPY-PAY-VENDOR | ||
| Apvnmxval | APVNMXVAL | Delete Cascades | VEN-AP-OBJ-ID → VMX-AP-OBJ-ID, → VMX-MATRIX-CAT | |
| Cbcheck | CBCHECK | VEN-VENDOR-GROUP → CHK-VENDOR-GROUP, VEN-VENDOR → CHK-PAID-VENDOR, → CHK-COMPANY, → CHK-CHECK-DATE, → CHK-BANK-INST-CODE, → CHK-CASH-CODE, → CHK-TRANS-IDENT | ||
| Povagrmthd | POVAGRMTHD | PCG-PROCURE-GROUP → PVH-PROCURE-GROUP, VEN-VENDOR → PVH-VENDOR, → PVH-PURCH-FR-LOC, → PVH-VEN-AGRMT-REF | ||
| Vnmxconv | VNMXCONV | VEN-VENDOR-GROUP → VNC-VENDOR-GROUP, VEN-VENDOR → VNC-VENDOR, → VNC-MATRIX-CAT |
Programs
Updated by (306)
- AC160 Asset Management Interface
- AM115 Mass Additions
- AM117 Mass Distribution Split
- AM15.1 Single Invoice Interface
- AM15.2 Combine Invoice Interface
- AM15.3 Single Activity Interface
- AM15.4 Combine Activity Interface
- AM19.1 PO Line Asset Detail
- AM19.2 Create Detail
- AM20.1 Quick Addition
- AM20.3 Items
- AM21.1 Leased Asset Quick Addition
- AM21.3 Items
- AM22.1 Items
- AM500 Asset Management Interface
- AM51.1 Item Update Adjust Interface Maint
- AM551 Item Update Adjustment Interface
- AM97.1 Item Interface Adjustment
- AP03.3 Query List Members
- AP10.1 Vendor
- AP10.2 Vendor Location
- AP10.3 One Time Vendor
- AP10.7 Vendor Approval
- AP100 Vendor Group Copy
- AP11.1 Pay Vendor Maintenance
- AP110 Mass Vendor Update
- AP115 Vendor Merge
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP13.2 Diversity Code
- AP131 Chargeback
- AP14.5 1099 Tax Identification Information
- AP144 Tax Identification Notification
- AP15.1 Cross Reference Vendor Setup
- AP150 Cash Requirements
- AP160 Payment Tape Creation
- AP170 Payment Closing
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP210 Vendor Listing
- AP220 Invoice Edit Report
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP271 Vendor Spend Report
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP40.2 Vendor Hold Selection
- AP510 Vendor Conversion
- AP520 Invoice Interface
- AP702 Update Active Status Default
- AP90.1 Invoice Search by Vendor, Invoice
- AP91.1 Vendor Activity
- API1.1 Add Invoice
- API2.1 Add Invoice
- API3.1 Vendor Location Invoke
- API4.1 Vendor Master Invoke
- AR09.1 Customer Group Address
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- IC840 Cart Par Location Conversion
- MA126 Auto Matching
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA279 Invoice AOC Detail Report
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.1 Memo Line Detail - Purchase Order
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.3 Invoice Line Detail - Receipt
- MA43.4 Invoice Line Detail - Service
- MA43.6 Service Agreement Detail
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA540 Invoice Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA63.1 Invoice Line Match
- MA65.1 Invoice Line Adjustment
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA69.1 AOC Level Detail Match
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- MX123 List Member Build
- MX500 Attribute Value Population
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD235 P-Card Merchant Report
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO192 PO Vendor Item Audit Report
- PO195 PO Vendor Agreement Audit Report
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.2 Mass Cancel or Delete Purchase Orders
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO22.5 Purchase Order Line Inquiry
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO223 Buyer Expediting Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO233 PO Received Quantity Exceptions
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO253 Item Receipt Volume Report
- PO254 PO Inquiry Report
- PO26.3 Vendor Agreement Commitments Spread
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO278 RNI Aging Report
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO529 PO Receiving File Create
- PO536 Vendor Price Agreement Load
- PO54.1 Purchase Order Inquiry
- PO54.2 Purchase Order Inquiry
- PO54.3 Purchase Order Inquiry
- PO54.4 Purchase Order Inquiry
- PO54.5 PO Line Detail List
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- PR05.1 Deduction
- PR05.3 Additional Vendors
- PR226 United States Employee Garnishment Listing
- PR247 Canada Employee Garnishment Listing
- PR26.1 United States Employee Garnishment
- PR47.1 Canada Employee Garnishment
- PR514 Employee Deduction Master Load
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ260 Requisitioned Items Report
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- TX140 Vertex Geocode Update
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program
Referenced by (192)
- AC210 Activity Listing and Audit
- AC297 Commitment Analysis Summary
- AM18.1 Repair Invoice Interface
- AP00.1 Vendor Group
- AP00.3 Vendor Class
- AP02.3 Process Groups
- AP102 Process Group Update
- AP109 Vendor Current Address Update
- AP111 Vendor Deletion
- AP12.1 Vendor Comments
- AP130 Proof of Delivery Statements
- AP133 Mass Retainage Payment Adjust
- AP135 Vendor, Invoice Audit Report
- AP136 Invoice Accrual Reconciliation
- AP141 Mass Invoice Hold
- AP145 1099 Forms Creation
- AP146 1099 Tape Creation
- AP151 Bill of Exchange Generation
- AP155 Payment Forms Creation
- AP156 Bill of Exchange Creation
- AP16.1 Vendor Bank
- AP16.2 Vendor Location Bank
- AP161 Electronic Payment File Creation
- AP162 Vendor Attribute Interface
- AP166 Bill of Exchange Bank Statement
- AP175 Invoice Distribution Closing
- AP176 Match Discount Accrual
- AP178 Paid Invoice Activity Update
- AP180 Bill of Exchange Cashing Update
- AP181 Bill of Exchange Statement Update
- AP185 Bill of Exchange Distribution Posting
- AP190 Invoice Reinstatement
- AP191 Unrealized Gain or Loss
- AP193 Recurring Invoice Update
- AP195 Period Closing
- AP197 Vendor Balance Rebuild
- AP200 Vendor Group, Company Listing
- AP202 Process Group Listing
- AP211 Vendor Invoicing
- AP212 Comments Listing
- AP213 Vendor Account Balance
- AP221 Potential Duplicate Payments
- AP225 Vendor Statements
- AP230 Open Payables Report
- AP232 Invoice Accrual Reconciliation Report
- AP233 Retainage Invoice Listing
- AP235 Incoming Invoice Register
- AP236 Invoice Payment Approval Edit
- AP237 Distribution Approval Listing
- AP240 Hold Payments Report
- AP245 Reportable Income Report
- AP246 Secondary Withholding Report
- AP250 Cash Forecasting
- AP251 Match Analysis Report
- AP252 Unmatched Invoice Listing
- AP256 Foreign Payment Statistics Report
- AP266 Bill of Exchange Report
- AP270 Vendor Payment History
- AP272 Accounts Payable Tax Exempt Transaction Report
- AP275 Invoice Distribution History
- AP28.1 Bill of Exchange Acceptance by Vendor
- AP28.2 Bill of Exchange Acceptance by Date
- AP282 French DAS2 Preparation Report
- AP284 Vendor Grand Livre
- AP290 Vendor Labels
- AP295 Invoice Processing Statistics
- AP32.1 Workflow Approval Maintenance
- AP33.1 Retainage Payment Adjustment
- AP35.1 Credit Memo Application
- AP36.2 Distribution Approvals
- AP41.1 Hold Parameter Definition
- AP45.1 Reportable Income Adjustment
- AP45.3 Non-AP Reportable Income Adjustment
- AP45.4 Selection Criteria
- AP51.2 Vendor Location Conversion
- AP51.3 Address Change Interface
- AP52.7 Invoice Filter
- AP54.1 Vendor Table
- AP55.1 Cash Payment Entry
- AP55.2 Cash Payment Invoice Application
- AP56.1 Bill of Exchange Entry
- AP56.2 Bill of Exchange Invoice Application
- AP590 AP Vendor CSV
- AP62.1 Vendor Attribute Interface Maintenance
- AP80.1 Bill of Exchange Cashing Selection
- AP810 Retail Vendor Export
- AP92.1 Vendor Invoices
- AP92.2 Pay Group Invoices
- AP92.3 Selection Criteria
- AP92.4 Selection Criteria
- AP93.1 Archived Vendor Invoices
- AP93.2 Archived Pay Group Invoices
- AP93.3 Selection Criteria
- AP93.4 Selection Criteria
- AP95.1 Invoice Distributions
- AP95.2 GL Account Distributions
- AP95.3 Activity Distributions
- AP96.1 Archived Invoice Search by Vendor, Invoice
- AP98.1 AP Vendor Audit View
- AP98.2 AP Vendor Location Audit View
- APBD.2 AP BOD Inquiry
- CB00.1 Bank
- CB06.2 Bank Statement Detail Entry
- CB10.1 Cash Receipt Deposit
- CB150 Mass Release
- CB50.1 Bank Transaction Interface Maintenance
- CB500 Bank Transaction Interface
- CB54.1 Payment Load Maintenance
- CB55.1 Payment Entry
- CB554 Payment Load
- CB700 CB08 Load
- EE11.1 Expense Line Detail
- EE135 Mass Employee Release
- EE175 Company Expense Posting
- EE20.1 Employee Advance
- EE20.2 Employee Expense
- EE20.3 Expense Detail
- EE20.4 Employee Payback
- EE220 Expense, Advance, or Payback Edit
- EE230 Expense or Advance Report
- EE235 Expense Release Edit
- EE275 Expense Analysis Report
- EE30.1 Expense and Advance Matching
- EE35.1 Advance Release
- EE35.2 Expense Release
- EE520 Expense Interface
- EE90.1 Advance Inquiry
- EE90.2 Expense Inquiry
- EX12.1 XM Interface System Configuration
- EX12.3 XM Credit Card Vendor
- EX14.1 XM Interface User Maintain
- EX14.2 XM Interface User Add and Maintain
- EX175 Company Expense Posting
- EXLD.1 Load XM Users
- EXXM.1 Create Expense Interface
- GL284 AP Grand Livre Report - Period
- GL285 AP Grand Livre Report - Date
- IAVO.1 Olap Dimension Retrieval Format
- IC258 Global Location Number Listing
- IC266 Replenishment PO Worksheet Rpt
- IC282 Requesting Location Usage
- IC522 HL7 Item Master - Atwork
- IC524 CSV Item Master
- IC526 HL7 Item Master - McKesson
- IC527 HL7 Item Master - DeRoyal
- IC58.1 Global Location Numbers
- IC58.2 Global Location Numbers Inquiry
- IC58.3 Global Location Numbers Inquiry Details
- IC81.1 Cart, Par Location
- IN120 Intrastat Data Report
- IN20.1 Intrastat Data Maintenance
- MA00.1 Match Table
- MA05.1 Handling Code
- MA05.2 Vendor Handling Code
- MA167 Smart Recon queue Build
- MA168 Prepaid Invoice Not Received
- MA236 Invoiced, Not Received Report
- MA237 Match Update Report
- MA26.1 PO Invoice Match
- MA64.1 Message Queue - Vendor
- MA64.4 Invoice Messaging Queue
- MA64.6 Message Detail by Invoice
- MA64.9 PO Cost Message Accept Upload
- MA90.1 Match Analysis
- MA90.2 All Transactions for Invoice
- MA90.3 Match Analysis Details
- MA90.5 Misc AOC for an Invoice
- MA90.6 Summarization
- MA91.1 Match Pool Display
- MA95.1 Vendor History
- MA95.2 Vendor History Analysis
- MAED.1 Vendor
- MM280 Departmental Procurement Expense Report
- MM80.2 Departmental Procurement Expense Inquiry Detail
- MX202 Attribute Value Listing
- MX223 List Member Listing
- PD21.1 P-Card Charge Detail
- PD263 PCard Merchant Audit Report
- PO135 Received, Not Invoiced Report
- PO196 PO Vendor Audit Report
- PO197 PO Vendor Purchase From Location Audit Report
- PO226 Vendor Agreement Renewal Report
- PO227 Contract Agreement Compliance Report
- PO231 Return Status Report
- PO53.4 Miscellaneous AOC
- PO58.2 Receipt Inquiry
- PR198 General Ledger Posting
- RQIC.1 Get Item List Invoke Object
- RQID.1 RQRQHUPD Invoke Object
- RQIG.1 Get Shopping List Invoke Object
- WH38.1 Web Tracking ID
- ZA161 Electronic Payment File Creation