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 / columnTypeDescription & valuesUpdated by
VEN-VENDOR-GROUP PK
VENDOR_GROUP
Alpha 4The 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 PK
VENDOR
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-CLASS
VEN_CLASS
Alpha 3The 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-VNAME
VENDOR_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-SNAME
VENDOR_SNAME
Alpha 30The 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-CONTCT
VENDOR_CONTCT
Alpha 30The 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-CODE
REMIT_TO_CODE
Alpha 4The 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-LOC
PURCH_FR_LOC
Alpha 4The 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-VENDOR
PAY_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-STATUS
VENDOR_STATUS
Alpha 1The vendor status. Invoices cannot be entered for a vendor with an Inactive status. Valid values are:
  • A Active.
  • I Inactive.
  • D Inactive for PO additions
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-VEN-PRIORITY
VEN_PRIORITY
Numeric 2The 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-PREFIX
PHONE_PREFIX
Alpha 6The 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-NUM
PHONE_NUM
Alpha 15The 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-EXT
PHONE_EXT
Alpha 5The 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-PREFIX
FAX_PREFIX
Alpha 6The 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-NUM
FAX_NUM
Alpha 15The 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-EXT
FAX_EXT
Alpha 5The 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-NUM
TELEX_NUM
Alpha 15The 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-CODE
TERM_CODE
Alpha 5The 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-CURRENCY
INV_CURRENCY
Alpha 5The 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-CURRENCY
BAL_CURRENCY
Alpha 5The 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-RECALC
CURR_RECALC
Alpha 1If 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:
  • N No.
  • Y Yes.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-SEP-CHK-FLAG
SEP_CHK_FLAG
Alpha 1Indicates whether to create a separate payment for each invoice entered for the vendor. Valid values are:
  • N No.
  • Y Yes.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-TAX-ID
TAX_ID
Alpha 20The 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-CD
TAX_EXEMPT_CD
Alpha 1Code 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-CODE
TAX_CODE
Alpha 10The 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-FLAG
HOLD_FLAG
Alpha 1This field enables this entire lot to be put on hold, not allowing any issues or transfers to be made for this lot. " "
  • Y Yes
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-DIST-CODE
DIST_CODE
Alpha 9The 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-CODE
ACCR_CODE
Alpha 4The 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-CODE
BANK_INST_CODE
Alpha 3The 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-CODE
CASH_CODE
Alpha 4The 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-ENTITY
BANK_ENTITY
Alpha 15The 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-CURRENCY
BANK_CURRENCY
Alpha 5This field contains the bank currency codeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-VBANK-ACCT-NO
VBANK_ACCT_NO
Alpha 35The 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-TP
VBANK_ACCT_TP
Alpha 1Indicates the type of bank account used to deposit electronic payments for the vendor. Valid values are: selected.
  • C Current/Checking Account.
  • S Savings Account.
  • Blank Electronic payment type not
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-VBANK-IDENT
VBANK_IDENT
Alpha 1This field indicates if the account number is an IBAN number that requires an account validation check.
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-CROSS-IDENT
CROSS_IDENT
Alpha 1This field is used to distinguish between SWIFT ID numbers and Routing numbers.
  • S SWIFT
  • R Routing Number
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INCOME-CODE
INCOME_CODE
Alpha 4The 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-FLG
INCOME_WH_FLG
Alpha 1Indicates whether invoices for the vendor are subject to reportable income withholding. Valid values are:
  • N No.
  • Y Yes.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-EDI-NBR
EDI_NBR
Alpha 15The 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-PRENOT
ACH_PRENOT
Alpha 1Used 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.
  • N Notified. Payment Tape Creation
  • P Prenotified. Select this status
  • A Accepted. Change the status to
  • Blank ACH payment type not selected.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-MAX-INV-AMT
MAX_INV_AMT
Signed 18.2The 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-DATE
CREATE_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-DATE
ORIGIN_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-OPERATOR
OPERATOR
Alpha 10The 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-01
USER_NAME_01
Alpha 20The 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-02
USER_NAME_02
Alpha 20The 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-03
USER_NAME_03
Alpha 20The 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-04
USER_NAME_04
Alpha 20The 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-05
USER_NAME_05
Alpha 20The 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-06
USER_NAME_06
Alpha 20The 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-GROUP
CUST_GROUP
Alpha 5If 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-CUSTOMER
CUSTOMER
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-NAME
LEGAL_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-RATE
PRIME_RATE
Signed 7.5The 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-GROUP
INVOICE_GROUP
Alpha 4A 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-CODE
DISCOUNT_CODE
Alpha 10The 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-CAPABLE
ERS_CAPABLE
Alpha 1Indicates whether the vendor location has the capability to process ERS. Valid values are:
  • N No.
  • Y Yes.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INVC-REF-TYPE
INVC_REF_TYPE
Alpha 2Indicates the type of number the vendor is providing to reference the invoice. Valid values are:
  • BM Bill of Lading Number.
  • IN Invoice Number.
  • OW Service Order Number.
  • PL Packing List Number.
  • PO PO Number.
  • VN Vendor Order Number.
  • WO Production Order Number.
  • WP Warehouse Pick Ticket Number.
  • ZZ Mutually Defined Number.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-EDI-AUTO-REL
EDI_AUTO_REL
Alpha 1Indicates whether the company automatically releases EDI invoices. Valid values are:
  • N No.
  • Y Yes.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-AUTH-CODE
AUTH_CODE
Alpha 3The 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-EXISTS
APPRVL_EXISTS
Alpha 1Indicates 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:
  • N No.
  • Y Yes.
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-ACTIVITY
ACTIVITY
Alpha 15The 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-CATEGORY
ACCT_CATEGORY
Alpha 5The 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-CODE
CHARGE_CODE
Alpha 1Indicates who pays service charges or fees associated with a SWIFT payment. Valid values are:
  • I Issuer.
  • R Receiver.
  • Blank 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-PMT-CAT-CODE
PMT_CAT_CODE
Alpha 6Indicates the payment category of the SWIFT payment. Valid values are:
  • G Goods.
  • T Transit Trade.
  • S Service and Capital.
  • X Transfer.
  • O Other.
  • Blank 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-NORM-EXP-CODE
NORM_EXP_CODE
Alpha 1Indicates whether the SWIFT payment is a normal or express payment. Valid values are:
  • N Normal.
  • E Express.
  • Blank 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-PMT-FORM
PMT_FORM
Alpha 2Indicates how the SWIFT payment is made. Valid values are:
  • C Check.
  • B Foreign Bank.
  • Blank 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-SWIFT-ID
SWIFT_ID
Alpha 12The 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-GRP
PROC_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-TABLE
MATCH_TABLE
Alpha 10A 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-DATE
DISC_CALC_DATE
Alpha 1Select which date to use when calculating discounts. You can use the invoice date, receipt date, or the date the invoice was received. " "
  • D Receipt of Invoice Date
  • I Invoice Date
  • R Latest Receipt Date
  • E Earliest Receipt Date
  • S Ship To Arrive Date
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-CREATE-POD-FL
CREATE_POD_FL
Alpha 1Indicates whether to create a proof of delivery. Valid values are: " "
  • N No
  • Y Yes
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-HANDLING-CODE
HANDLING_CODE
Alpha 4Invoice 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-ENCLOSURE
ENCLOSURE
Alpha 1Indicates whether the invoice requires an enclosure with its payment. " "
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-REQ-MATCH-REF
REQ_MATCH_REF
Alpha 1Indicates whether a match reference number is required for invoices for this vendor.
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-POOL-OPTION
POOL_OPTION
Numeric 1
  • 1 Company Vendor
  • 2 Company Vendor PO
  • 3 Company Vendor PO ShipTo
  • 0 MA Company Default
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-HOLD-INSP-FLAG
HOLD_INSP_FLAG
Alpha 1If set to "Y", this flag will keep receiving lines requiring inspection from being matched until they have been inspected. " " = Use Company
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-WRITE-OFF-AMT
WRITE_OFF_AMT
Signed 18.2AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-VEN-CLAIM-TYPE
VEN_CLAIM_TYPE
Alpha 2
  • CB Chargeback
  • CM Credit Memo
  • N None
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-CLAIM-HOLD-CD
CLAIM_HOLD_CD
Alpha 4The hold code.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-CB-HOLD-CODE
CB_HOLD_CODE
Alpha 4The hold code.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-CB-MINIMUM-AMT
CB_MINIMUM_AMT
Signed 18.2AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-REPLACE-GOODS
REPLACE_GOODS
Alpha 1
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-SHIP-OR-HOLD
SHIP_OR_HOLD
Alpha 1
  • S Ship
  • H Hold
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-ERS-HANDLING
ERS_HANDLING
Alpha 4AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-E-MAIL-ADDRESS
E_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-ADDR
URL_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-ACCT
VEND_ACCT
Alpha 30The 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-CODE
LANGUAGE_CODE
Alpha 10Language Code (LOCALE).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-TAX-USAGE-CD
TAX_USAGE_CD
Alpha 10The 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-CTRY
VAT_REG_CTRY
Alpha 2The 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-NBR
VAT_REG_NBR
Alpha 12The 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-PO
VALIDATE_PO
Alpha 1" " = MA Company Default
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-REQUIRE-PO
REQUIRE_PO
Alpha 1" " = MA Company Default
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-LOC-INDICATOR
LOC_INDICATOR
DerivedWhen selecting a vendor from a list of available vendors, an asterisk (*) displays if alternate locations exist for a vendor.
VEN-SHORT-VNAME
SHORT_VNAME
DerivedA short name for the vendor. Used for display purposes.
VEN-VCOMMENT-EXIST
VCOMMENT_EXIST
DerivedWhen selecting a vendor from a list of available vendors, an asterisk (*) displays if comments exist for a vendor.
VEN-VDR-ADDR1
VDR_ADDR1
DerivedVendor address line 1.
VEN-VDR-ADDR2
VDR_ADDR2
DerivedVendor address line 2.
VEN-VDR-ADDR3
VDR_ADDR3
DerivedVendor address line 3.
VEN-VDR-ADDR4
VDR_ADDR4
DerivedVendor address line 4.
VEN-VDR-CITY-ADDR5
VDR_CITY_ADDR5
DerivedVendor city or address line 5.
VEN-VDR-STATE
VDR_STATE
DerivedVendor state or province.
VEN-VDR-POSTAL
VDR_POSTAL
DerivedVendor postal code.
VEN-VDR-COUNTY
VDR_COUNTY
DerivedVendor county.
VEN-VDR-COUNTRY
VDR_COUNTRY
DerivedVendor country.
VEN-VAT-NBR
VAT_NBR
DerivedThe concatenation of the VAT-REG-CTRY and VAT-REG-NBR fields, used as VAT reporting ID.
VEN-WORKFLOW-GROUP
WORKFLOW_GROUP
Alpha 20AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-MBL-INT-PREFIX
MBL_INT_PREFIX
Alpha 6This 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-NUM
MOBILE_NUM
Alpha 15This 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-EXT
MOBILE_EXT
Alpha 5This 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-FLAG
PAY_IMM_FLAG
Alpha 1AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-DIVERSE-CODE
DIVERSE_CODE
Alpha 5Diversity Code for Account Payable VendorsAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-BANK-ENT
INTM_BANK_ENT
Alpha 15Type 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-ACCT
INTM_BANK_ACCT
Alpha 35Type 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-IDNT
INTM_BANK_IDNT
Alpha 1This field indicates if the account number is and IBAN number that requires an account validation check.
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-BANK-CURR
INTM_BANK_CURR
Alpha 5This 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-PRENOT
INTM_PRENOT
Alpha 1If 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.
  • A Accepted
  • N Not prenotified
  • P Prenotified
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-SWIFT-ID
INTM_SWIFT_ID
Alpha 12Use 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-CAT
INTM_PMT_CAT
Alpha 6Select the Intermediary SWIFT payment category.
  • G Goods
  • T Transit Trade
  • S Service and Capital
  • X Transfer
  • O Other
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-NORM-EXP
INTM_NORM_EXP
Alpha 1Indicates whether the SWIFT payment is a normal or express payment. " " = Not defined for the vendor
  • N Normal
  • E Express
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-PMT-FORM
INTM_PMT_FORM
Alpha 2Indicates 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-CD
INTM_CHRG_CD
Alpha 1Indicates 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-IDENT
INTM_CRS_IDENT
Alpha 1This field is used to distiguish between SWIFT ID numbers and Routing numbers
  • S Swift
  • R Routing Number
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-RULE-GROUP
RULE_GROUP
Alpha 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-FLOAT-DAYS
FLOAT_DAYS
Numeric 3This 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-FL
MTCH_PREPAY_FL
Alpha 1Flag 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-MT
MTCH_PREPAY_MT
Numeric 1Flag denotes the method of match prepayment.
  • 0 No
  • 1 Prepay from Invoice
  • 2 Eligible for Prepayment
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-BUILD-SOC-REF
BUILD_SOC_REF
Alpha 18This field holds an individual account number reference for the Building SocietyAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-BUILD-ACCT-NM
BUILD_ACCT_NM
Alpha 18AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-XREF-FLAG
XREF_FLAG
Alpha 1Use a cross reference table for this vendor
  • 0 Xref Vendor does not exist
  • 1 Xref record exist
AP15.1
VEN-GIRO-NUMBER
GIRO_NUMBER
Alpha 15This field is the Bankgiro or Postgiro account numberAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-CR-CARD-NUMBER
CR_CARD_NUMBER
Alpha 16This 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-INSTRUCT1
BANK_INSTRUCT1
Alpha 35This 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-INSTRUCT2
BANK_INSTRUCT2
Alpha 35This 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-INSTRUCT3
BANK_INSTRUCT3
Alpha 35This 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-INSTRUCT4
BANK_INSTRUCT4
Alpha 35This 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-ID
AP_OBJ_ID
Numeric 12This 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-FLAG
P_CARD_FLAG
Numeric 1
  • 0 No
  • 1 Yes
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-PCARD-NBR
PCARD_NBR
Alpha 16AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-VAL-DIV-DATE
VAL_DIV_DATE
Alpha 1Determines on invoice entry if the invoice date is within the certification dates for the diversity code setup for the vendor on AP14.4 " " = No
  • Y Yes
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-RET-ACCR-CODE
RET_ACCR_CODE
Alpha 4AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-GLN-NBR
GLN_NBR
Alpha 13AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-TIN-TYPE
TIN_TYPE
Numeric 1AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-TIN-NOT
TIN_NOT
Numeric 1AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-TIN-VERIFIED
TIN_VERIFIED
Numeric 1AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-SEC-WTH-EXEMPT
SEC_WTH_EXEMPT
Alpha 1
  • Y Yes
  • N No
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-SEC-WTH-CODE1
SEC_WTH_CODE1
Alpha 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-SEC-WTH-CODE2
SEC_WTH_CODE2
Alpha 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-SEC-WTH-CODE3
SEC_WTH_CODE3
Alpha 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-CREATED-BY
CREATED_BY
Alpha 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-LAST-UPDT-DATE
LAST_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-TIME
LAST_UPDT_TIME
Numeric 8AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-LAST-UPDATE-BY
LAST_UPDATE_BY
Alpha 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-VALID-CERT-DT
VALID_CERT_DT
Alpha 1AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-FOR-ECON-CODE
FOR_ECON_CODE
Alpha 10AP10.1, AP510
VEN-SOCIAL-ID1
SOCIAL_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-ID2
SOCIAL_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-ID3
SOCIAL_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-ID4
SOCIAL_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-ID5
SOCIAL_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-FLAG
CARRIER_FLAG
Alpha 1AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-BANK-CODE
BANK_CODE
Alpha 2AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-BANK-ID
BANK_ID
Alpha 9AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-ASSIGNMENT-NBR
ASSIGNMENT_NBR
Alpha 14AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-DEBITING-SIGN
DEBITING_SIGN
Alpha 1AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-BANK-CODE
INTM_BANK_CODE
Alpha 2AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-BANK-ID
INTM_BANK_ID
Alpha 9AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-ASSIGN-NO
INTM_ASSIGN_NO
Alpha 14AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-INTM-DEBITING
INTM_DEBITING
Alpha 1AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-CHK-DIG-TYPE
CHK_DIG_TYPE
Alpha 10AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +52 more (list truncated in source)
VEN-SEPA-FLAG
SEPA_FLAG
Alpha 1
VEN-W8-VERIFIED
W8_VERIFIED
Alpha 1AP14.5
VEN-FATCA-ID
FATCA_ID
Alpha 6AP14.5
VEN-FIN-INST-TYPE
FIN_INST_TYPE
Alpha 5AP14.5
VEN-GIIN-CAT-CODE
GIIN_CAT_CODE
Alpha 2AP14.5
VEN-ISO-CTRY-NBR
ISO_CTRY_NBR
Numeric 3AP14.5
VEN-FATCA-WITHOLD
FATCA_WITHOLD
Signed 7.4AP14.5
VEN-FATCA-INC-CODE
FATCA_INC_CODE
Alpha 4AP14.5
VEN-FATCA-AU
FATCA_AU
Alpha 15AP14.5
VEN-FATCA-ACCOUNT
FATCA_ACCOUNT
Numeric 6AP14.5
VEN-FATCA-SUB-ACCT
FATCA_SUB_ACCT
Numeric 4AP14.5
VEN-OPEN-ZERO-COST
OPEN_ZERO_COST
Alpha 1Use 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.
  • N No
  • Y Yes

Indexes (11)

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

IndexKeysFlagsConditionUsed in
VENSET1VENDOR-GROUP, VENDORPrimaryAC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
VENSET10VENDOR-GROUP, CREATE-POD-FL, VENDORKeyChangeAP130
VENSET11AP-OBJ-IDSubsetWhere AP-OBJ-ID != ZeroesAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
VENSET2VENDOR-GROUP, VEN-CLASS, VENDORKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
VENSET3VENDOR-GROUP, USER-NAME-01, VENDOR-SNAME, VENDORKeyChange
VENSET4VENDOR-GROUP, VEN-CLASS, VENDOR-SNAME, VENDORKeyChange
VENSET5VENDOR-GROUP, VENDOR-SNAME, VENDORKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
VENSET6PROC-GRP, VENDOR-GROUP, VENDORKeyChangeAP02.3, AP202
VENSET7VENDOR-GROUP, EDI-NBR, VENDORKeyChangeAC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
VENSET8VENDOR-GROUP, VENDORSubsetWhere ACH-PRENOT = "N" Or ACH-PRENOT = "P"AP160
VENSET9HANDLING-CODE, VENDOR-GROUP, VENDORKeyChangeMA05.1, MA05.2

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Address1APVENADDRRequiredVEN-VENDOR-GROUPVDR-VENDOR-GROUP, VEN-VENDORVDR-VENDOR, SpacesVDR-LOCATION-CODE, SpacesVDR-RESP-CODE, ZeroesVDR-CONTACT-LVL, "Y"VDR-CUR-ADDR
ApprocgrpAPPROCGRPNot RequiredVEN-PROC-GRPAPQ-PROC-GRP
ApvengroupAPVENGROUPRequiredVEN-VENDOR-GROUPVGP-VENDOR-GROUP
ApvnbodAPVNBODNot Required, Delete CascadesVEN-VENDOR-GROUPYBC-VENDOR-GROUP, VEN-VENDORYBC-VENDOR
GlnlocGLNLOCNot RequiredValid When VEN-GLN-NBR != SpacesPCG-ITEM-GROUPGLO-ITEM-GROUP, VEN-GLN-NBRGLO-GLN-NBR
GlnlocdtlGLNLOCDTLNot RequiredValid When VEN-GLN-NBR != SpacesPCG-ITEM-GROUPGLX-ITEM-GROUP, 7GLX-GLN-TYPE, VEN-VENDORGLX-VENDOR, SpacesGLX-LOCATION-CODE, VEN-GLN-NBRGLX-GLN-NBR
MamtchruleMAMTCHRULERequiredVEN-RULE-GROUPMAU-MATCH-RULE
ProcuregrpPROCUREGRPRequiredVEN-VENDOR-GROUPPCG-VENDOR-GROUP

One to many (20) — child tables

RelationTableRulesConditionField map
ApapihistAPAPIHISTVEN-VENDOR-GROUPAH1-VENDOR-GROUP, VEN-VENDORAH1-VENDOR, AH1-INVOICE, AH1-SUFFIX, AH1-CANCEL-SEQ, AH1-COMPANY
ApauditAPAUDITVEN-VENDOR-GROUPAPA-VENDOR-GROUP, ZeroesAPA-COMPANY, SpacesAPA-PROC-LEVEL, VEN-VENDORAPA-VENDOR, SpacesAPA-INVOICE, ZeroesAPA-SUFFIX, ZeroesAPA-CANCEL-SEQ, APA-SEQ-NBR, APA-TRANS-DATE, APA-TRANS-TIME, APA-LOCATION-CODE
ApcommentsAPCOMMENTSDelete Cascades"V"APC-REC-TYPE, VEN-VENDOR-GROUPAPC-VENDOR-GROUP, VEN-VENDORAPC-VENDOR, APC-LOCATION-CODE, APC-COMPANY, APC-SEQ-NBR
ApcontactsAPCONTACTDelete CascadesVEN-VENDOR-GROUPVCT-VENDOR-GROUP, VEN-VENDORVCT-VENDOR, VCT-RESP-CODE, VCT-CONTACT-LVL, VCT-LOCATION-CODE
ApcpyvndAPCPYVNDVEN-VENDOR-GROUPAPX-VENDOR-GROUP, VEN-VENDORAPX-VENDOR, SpacesAPX-LOCATION-CODE, APX-COMPANY
AphldinvAPHLDINVDelete CascadesValid When (VEN-HOLD-FLAG = "Y")"V"HLI-REC-TYPE, VEN-VENDOR-GROUPHLI-VENDOR-GROUP, ZeroesHLI-COMPANY, VEN-VENDORHLI-VENDOR, HLI-INVOICE, HLI-SUFFIX, HLI-CANCEL-SEQ, HLI-SEQ-NBR, HLI-VOID-SEQ, HLI-HLD-CODE
ApinvoiceAPINVOICEVEN-VENDOR-GROUPAPI-VENDOR-GROUP, VEN-VENDORAPI-VENDOR, API-INVOICE, API-SUFFIX, API-CANCEL-SEQ, API-COMPANY
ApvcommentsAPCOMMENTS"V"APC-REC-TYPE, VEN-VENDOR-GROUPAPC-VENDOR-GROUP, VEN-VENDORAPC-VENDOR, SpacesAPC-LOCATION-CODE, APC-COMPANY, APC-SEQ-NBR
ApvenaddrAPVENADDRVEN-VENDOR-GROUPVDR-VENDOR-GROUP, VEN-VENDORVDR-VENDOR, SpacesVDR-LOCATION-CODE, SpacesVDR-RESP-CODE, ZeroesVDR-CONTACT-LVL, VDR-EFFECTIVE-DATE
ApvenbalAPVENBALDelete CascadesVEN-VENDOR-GROUPVBA-VENDOR-GROUP, VEN-VENDORVBA-VENDOR, VBA-COMPANY, VBA-LOCATION-CODE
ApvenbalmasterAPVENBALDelete CascadesVEN-VENDOR-GROUPVBA-VENDOR-GROUP, VEN-VENDORVBA-VENDOR, SpacesVBA-LOCATION-CODE, VBA-COMPANY
ApvencertAPVENCERTVEN-VENDOR-GROUPAVT-VENDOR-GROUP, VEN-VENDORAVT-VENDOR, AVT-LOCATION-CODE, AVT-CERTIF-CODE, AVT-CERTIF-EFF-DT
ApvendivAPVENDIVVEN-VENDOR-GROUPVDC-VENDOR-GROUP, VEN-VENDORVDC-VENDOR, VDC-LOCATION-CODE, VDC-DIVERSE-CODE, VDC-DCERT-DATE
ApvendorbalAPVENBALVEN-VENDOR-GROUPVBA-VENDOR-GROUP, VEN-VENDORVBA-VENDOR, VBA-LOCATION-CODE, VBA-COMPANY
ApvenlocAPVENLOCDelete CascadesVEN-VENDOR-GROUPVLO-VENDOR-GROUP, VEN-VENDORVLO-VENDOR, VLO-LOCATION-CODE
ApvenpayAPVENPAYVEN-VENDOR-GROUPVPY-VENDOR-GROUP, VEN-VENDORVPY-VENDOR, VPY-PAY-VENDOR
ApvnmxvalAPVNMXVALDelete CascadesVEN-AP-OBJ-IDVMX-AP-OBJ-ID, VMX-MATRIX-CAT
CbcheckCBCHECKVEN-VENDOR-GROUPCHK-VENDOR-GROUP, VEN-VENDORCHK-PAID-VENDOR, CHK-COMPANY, CHK-CHECK-DATE, CHK-BANK-INST-CODE, CHK-CASH-CODE, CHK-TRANS-IDENT
PovagrmthdPOVAGRMTHDPCG-PROCURE-GROUPPVH-PROCURE-GROUP, VEN-VENDORPVH-VENDOR, PVH-PURCH-FR-LOC, PVH-VEN-AGRMT-REF
VnmxconvVNMXCONVVEN-VENDOR-GROUPVNC-VENDOR-GROUP, VEN-VENDORVNC-VENDOR, VNC-MATRIX-CAT

Programs

Updated by (306)

Referenced by (192)