APCVENMAST – Vendor Conversion

System
Accounts Payable (AP)
Prefix
CVV
Primary key
VENDOR-GROUP, VENDOR, OLD-VENDOR, LOCATION-CODE
Fields
222
Updated by
6 programs
Referenced by
0 programs

APCVENMAST is the Vendor Conversion table in Lawson Accounts Payable (prefix CVV). It is indexed by VENDOR-GROUP, VENDOR, OLD-VENDOR, LOCATION-CODE (CVVSET1). It is related 1:M to APCCONTACT and APCVENBAL. It is updated by AP51.1, AP51.2, AP51.4, AP51.5, AP510 and AP58.1. The table has 222 fields, 1 index and 2 documented relations.

About APCVENMAST

No description in the Lawson data dictionary.

Fields (222)

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

Field / columnTypeDescription & valuesUpdated by
CVV-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4Required. The vendor group. Must be a valid record in the Vendor Group file.AP51.1, AP51.2, AP51.4, AP51.5, AP58.1
CVV-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor number. Required if defining a vendor or alternate vendor location record and not using automatic vendor numbering. If defining an alternate vendor location record, must be a valid record in the Vendor Conversion or Vendor file.AP51.1, AP51.2, AP51.4, AP51.5, AP510, AP58.1
CVV-OLD-VENDOR PK
OLD_VENDOR		Alpha 9 (Right Justified)The vendor's number before conversion to Accounts Payable. Required if using automatic vendor numbering.AP51.1, AP51.2, AP51.4, AP51.5
CVV-LOCATION-CODE PK
LOCATION_CODE		Alpha 4Required if defining an alternate vendor location record. A user-defined code representing an alternate remittance or purchasing location for the vendor. If present, the Vendor must be a valid record in the Vendor Conversion or Vendor file.AP51.1, AP51.2, AP51.4, AP51.5, AP58.1
CVV-LOC-TYPE
LOC_TYPE		Alpha 1If defining an alternate vendor location record, this field indicates the type of alternate location for the vendor. Valid values are: alternate purchasing location for the vendor. remittance location for the vendor. alternate purchasing and remittance location for the vendor. record is not being defined.
  • P Purchase-From. Represents an
  • R Remit-To. Represents an alternate
  • B Both. Can be used as both an
  • Blank An alternate vendor location
AP51.2
CVV-VEN-CLASS
VEN_CLASS		Alpha 3Required. The vendor class the vendor is assigned to. Represents a group of vendors within a vendor group that share common characteristics. Must be a valid record in the Vendor Class file.AP51.1
CVV-VENDOR-VNAME
VENDOR_VNAME		Alpha 30 (Lower Case)Required. The vendor name or description. This field accepts both upper and lower case entries.AP51.1, AP51.2
CVV-VENDOR-SNAME
VENDOR_SNAME		Alpha 30The search name for the vendor. If left blank, the Vendor Name defaults.AP51.1
CVV-VENDOR-CONTCT
VENDOR_CONTCT		Alpha 30The requester can enter the recommended vendor's name for the requested items.AP51.1, AP51.2
CVV-ADDR1
ADDR1		Alpha 30 (Lower Case)Required. The first line of address information for the vendor. This field accepts both upper and lower case entries.AP51.1, AP51.2
CVV-ADDR2
ADDR2		Alpha 30 (Lower Case)The second line of address information for the vendor. This field accepts both upper and lower case entries.AP51.1, AP51.2
CVV-ADDR3
ADDR3		Alpha 30 (Lower Case)The third line of address information for the vendor. This field accepts both upper and lower case entries.AP51.1, AP51.2
CVV-ADDR4
ADDR4		Alpha 30 (Lower Case)The fourth line of address information for the vendor. This field accepts both upper and lower case entries.AP51.1, AP51.2
CVV-CITY-ADDR5
CITY_ADDR5		Alpha 18 (Lower Case)The city or fifth line of address information for the vendor. This field accepts both upper and lower case entries.AP51.1, AP51.2
CVV-STATE-PROV
STATE_PROV		Alpha 2The state or province for the vendor address.AP51.1, AP51.2
CVV-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)The postal code for the vendor address.AP51.1, AP51.2
CVV-COUNTY
COUNTY		Alpha 25 (Lower Case)The county for the company address.AP51.1, AP51.2
CVV-COUNTRY
COUNTRY		Alpha 30 (Lower Case)The country for the vendor address. Can also be used for additional information such as attention name. This field accepts both upper and lower case entries.AP51.1, AP51.2
CVV-REGION
REGION		Alpha 2The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)AP51.1, AP51.2
CVV-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AP51.1, AP51.2
CVV-NORM-REMIT
NORM_REMIT		Alpha 1If defining an alternate vendor location and the Location Type field = R or B, this field indicates whether the location represents the normal remittance location for the vendor. A vendor can have only one normal remittance location. Valid values are:
  • N No. Default value.
  • Y Yes.
AP51.2
CVV-NORM-PURCH
NORM_PURCH		Alpha 1If defining an alternate vendor location and the Location Type field = P or B, this field indicates whether the location represents the normal purchasing location for the vendor. A vendor can have only one normal purchasing location. Valid values are:
  • N No. Default value.
  • Y Yes.
AP51.2
CVV-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4The normal remittance location for an alternate vendor location, if defined. If present, the address defined for the location overrides the vendor address on vendor payments when invoices are added. Must be a valid record in the Vendor Location file and the Vendor Conversion file.AP51.2
CVV-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4THIS FIELD IS NOT CURRENTLY USED.—
CVV-PAY-VENDOR
PAY_VENDOR		Alpha 9 (Right Justified)The vendor number of the vendor to be paid for invoices entered for this vendor. If left blank, the Vendor defaults. If entered a number, make sure the value is a valid record in the Vendor Conversion or Vendor file.AP51.1
CVV-VENDOR-STATUS
VENDOR_STATUS		Alpha 1The vendor status. You cannot enter invoices for a vendor with an Inactive status. Valid values are:
  • A Active.
  • I Inactive.
AP51.1, AP51.2
CVV-VEN-PRIORITY
VEN_PRIORITY		Numeric 2The payment priority of the vendor. Valid values are 1 (highest priority) through 99 (lowest priority). If left blank, the payment priority defined for vendor class will be used.AP51.1
CVV-PHONE-PREFIX
PHONE_PREFIX		Alpha 6The telephone number prefix for the vendor.AP51.1, AP51.2
CVV-PHONE-NUM
PHONE_NUM		Alpha 15The telephone number for the vendor.AP51.1, AP51.2
CVV-PHONE-EXT
PHONE_EXT		Alpha 5The telephone extension number for the vendor.AP51.1, AP51.2
CVV-FAX-PREFIX
FAX_PREFIX		Alpha 6The fax telephone number prefix for the vendor.AP51.1, AP51.2
CVV-FAX-NUM
FAX_NUM		Alpha 15The fax telephone number for the vendor.AP51.1, AP51.2
CVV-FAX-EXT
FAX_EXT		Alpha 5The fax telephone number extension for the vendor.AP51.1, AP51.2
CVV-TELEX-NUM
TELEX_NUM		Alpha 15The telex number for the vendor.AP51.1, AP51.2
CVV-TERM-CODE
TERM_CODE		Alpha 5The payment terms code assigned to the vendor. Used to automatically calculate due date and discount information for the vendor's invoices during entry. Must be a valid record in the Terms Code file.AP51.1, AP51.2
CVV-INV-CURRENCY
INV_CURRENCY		Alpha 5The currency used to add invoices for the vendor. The currency code defaults on the vendor's invoices during invoice 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.AP51.1, AP51.2
CVV-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 will be used.AP51.1
CVV-BANK-CURRENCY
BANK_CURRENCY		Alpha 5This field contains the bank currency code.AP58.1
CVV-CURR-RECALC
CURR_RECALC		Alpha 1If the Invoice Currency is different from the company base currency, this field indicates whether the system should recalculate the invoice currency when the invoice is paid to account for exchange rate fluctuations. If this exchange rate in effect when the invoice was entered to the exchange rate in effect when the invoice is scheduled for payment by Cash Requirements (AP150). If a difference exists, Payment Closing (AP170) creates a currency gain or loss transaction. Valid values are:
  • field Yes, the system compares the
  • Y Yes. Default value.
  • N No.
AP51.1, AP51.2
CVV-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.
AP51.1, AP51.2
CVV-TAX-ID
TAX_ID		Alpha 20If tracking reportable income for the vendor, this field contains the vendor's tax identification number.AP51.1
CVV-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.AP51.1, AP51.2
CVV-HLD-CODE
HLD_CODE		Alpha 4The hold code assigned to the vendor. If present, invoices for the vendor will not be scheduled for payment. Must be a valid vendor type hold code record in the Hold Code file.AP51.1
CVV-DIST-CODE
DIST_CODE		Alpha 9The distribution code assigned to the vendor. Used to automatically create expense distribution lines for this 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.AP51.1
CVV-ACCR-CODE
ACCR_CODE		Alpha 4The invoice accrual code assigned to the vendor. Used to default general ledger accrual account to the vendor's invoices during invoice entry. Must be a valid record in the Invoice Accrual Code file.AP51.1
CVV-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 payment or bill of exchange payment type transaction code record in the Bank Transaction Code file.AP51.1, AP51.2
CVV-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.AP51.1, AP51.2
CVV-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.AP58.1
CVV-VBANK-ACCT-NO
VBANK_ACCT_NO		Alpha 35The bank account number used to deposit electronic payments for the vendor. Required if a value is present in the Bank field.AP58.1
CVV-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
AP58.1
CVV-RIBKEY
RIBKEY		Numeric 2——
CVV-VBANK-ACCT-TP
VBANK_ACCT_TP		Alpha 1Indicates the type of bank account where electronic payments for the vendor will be deposited. Required if a value is present in the Bank field. Valid values are: selected.
  • C Current/Checking Account.
  • S Savings Account.
  • Blank Electronic payment type was not
AP58.1
CVV-INCOME-CODE
INCOME_CODE		Alpha 4The income code assigned to the vendor. Represents a type of reportable income for the vendor. Must be a valid record in the Income Code file.AP51.1
CVV-INCOME-WH-FLG
INCOME_WH_FLG		Alpha 1Indicates whether invoices for the vendor are subject to reportable income withholding. Valid values are:
  • N No. Default value.
  • Y Yes.
AP51.1
CVV-EDI-NBR
EDI_NBR		Alpha 15The vendor's electronic data interchange (EDI) number. Used for reference. Can also be used to look up a vendor if the vendor receives electronic invoices.AP58.1
CVV-ACH-PRENOT
ACH_PRENOT		Alpha 1Used in conjunction with ACH payments made for the vendor. Indicates the status of the electronic payment between the vendor and the processing bank. Valid values are: values are present in the Bank and Vendor Bank Account Number fields. AP160 (Payment Tape Creation) automatically changes the status from Not Prenotified to Prenotified to indicate that the processing bank has been notified but has not yet accepted the electronic payment tape. processing bank has been notified but has not yet accepted the electronic payment tape. Accepted once the processing bank accepts the electronic payment tape.
  • N Not Prenotified. Default value if
  • P Prenotified. Indicates that the
  • A Accepted. Change the status to
  • Blank ACH payment type not selected.
AP58.1
CVV-MAX-INV-AMT
MAX_INV_AMT		Signed 18.2The maximum single invoice amount that can be entered for the vendor.AP51.1
CVV-ORIGIN-DATE
ORIGIN_DATE		Numeric 8 (yyyymmdd)The origin date for the vendor. Provides additional information such as the date the vendor relationship began. If left blank, the system date defaults.AP51.1
CVV-USER-NAME-01
USER_NAME_01		Alpha 20The value of the information being tracked for the vendor in the first vendor group user field.AP51.1, AP51.2
CVV-USER-NAME-02
USER_NAME_02		Alpha 20The value of the information being tracked for the vendor in the second vendor group user field.AP51.1, AP51.2
CVV-USER-NAME-03
USER_NAME_03		Alpha 20The value of the information being tracked for the vendor in the third vendor group user field.AP51.1, AP51.2
CVV-USER-NAME-04
USER_NAME_04		Alpha 20The value of the information being tracked for the vendor in the fourth vendor group user field.AP51.1, AP51.2
CVV-USER-NAME-05
USER_NAME_05		Alpha 20The value of the information being tracked for the vendor in the fifth vendor group user field.AP51.1, AP51.2
CVV-USER-NAME-06
USER_NAME_06		Alpha 20The value of the information being tracked for the vendor in the sixth vendor group user field.AP51.1, AP51.2
CVV-CUST-GROUP
CUST_GROUP		Alpha 5Customer group. Used to identify a group of customer associated with one or more companies.AP51.1
CVV-CUSTOMER
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.AP51.1
CVV-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.AP51.1
CVV-ACTIVITY
ACTIVITY		Alpha 15The activity assigned to the vendor. Activities are the processes or procedures that produce work. If assigned, the activity defaults on all invoices for the vendor and associated locations unless you override it during invoice entry. Must be a valid record in the Lawson Activity Management system.AP51.1
CVV-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The account category assigned to the vendor. Used to group activity transactions for budgeting and reporting. If assigned, the account category defaults on all invoices for the vendor and associated locations unless you override it during invoice entry.AP51.1
CVV-DISCOUNT-CODE
DISCOUNT_CODE		Alpha 10The discount code assigned to the vendor. Used to default a general ledger discount account to the vendor's invoices during invoice entry. Must be a valid record in the Discount Code file.AP51.1, AP51.2
CVV-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 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.AP51.1
CVV-INVOICE-GROUP
INVOICE_GROUP		Alpha 4A user-defined character expression. An invoice group can be assigned to one more invoices. AP150 (Cash Requirements) has an option to select all invoices assigned the same invoice group.AP51.1, AP51.2
CVV-ERS-CAPABLE
ERS_CAPABLE		Alpha 1Indicates whether the vendor location can process ERS. Valid values are
  • Y Yes
  • N No
AP58.1
CVV-INVC-REF-TYPE
INVC_REF_TYPE		Alpha 2Indicates the type of number the vendor is providing to reference the invoice.
  • BM Bill of Lading
  • IN Invoice
  • OW Service Order Number
  • PL Packing List Number
  • PO PO Number
  • VN Vendor Order Number
  • WO Work Order
  • WP Warehouse Pick Ticket Number
  • ZZ Mutually Defined
AP58.1
CVV-EDI-AUTO-REL
EDI_AUTO_REL		Alpha 1Indicates whether the company automatically releases EDI invoices. Valid values are
  • Y Yes
  • N No
AP58.1
CVV-AUTH-CODE
AUTH_CODE		Alpha 3A user-defined code representing a person or department responsible for approving a registered invoice. Used only if using the invoice approval entry option. Must be a valid record in the Authority Code file. If assigned, the code defaults on invoices for the vendor unless you override the code for a specific company or override the code during invoice entry.AP51.1
CVV-CHARGE-CODE
CHARGE_CODE		Alpha 1The charge code assigned to the vendor. Indicates who pays service charges or fees associated with a SWIFT payment. Valid values are:
  • I Issuer.
  • R Receiver.
AP58.1
CVV-PMT-CAT-CODE
PMT_CAT_CODE		Alpha 6The SWIFT payment category code assigned to the vendor. Valid values are:
  • G Goods.
  • S Service & Capital.
  • T Transit Trade.
  • X Transfer.
  • O Other.
AP58.1
CVV-NORM-EXP-CODE
NORM_EXP_CODE		Alpha 1The normal or express SWIFT payment option assigned to the vendor. Valid values are:
  • N Normal.
  • E Express.
AP58.1
CVV-PMT-FORM
PMT_FORM		Alpha 2The SWIFT payment form assigned to the vendor. Indicates how the payment is made. Valid values are:
  • C Check.
  • F Foreign Bank.
AP58.1
CVV-SWIFT-ID
SWIFT_ID		Alpha 12The SWIFT identification number assigned to the vendor.AP58.1
CVV-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.AP51.1
CVV-MATCH-TABLE
MATCH_TABLE		Alpha 10—AP51.1
CVV-HANDLING-CODE
HANDLING_CODE		Alpha 4—AP51.1
CVV-DISC-CALC-DATE
DISC_CALC_DATE		Alpha 1" "
  • R Receipt Date
  • D Receipt of Invoice Date
  • I Invoice Date
  • S Ship To Arrive Date
  • E Earliest Receipt Date
AP51.1
CVV-ENCLOSURE
ENCLOSURE		Alpha 1" "
  • N No
  • Y Yes
AP51.1
CVV-CREATE-POD-FL
CREATE_POD_FL		Alpha 1—
  • Y Yes
  • N No
AP51.1
CVV-REQ-MATCH-REF
REQ_MATCH_REF		Alpha 1—
  • Y Yes
  • N No
AP51.1
CVV-POOL-OPTION
POOL_OPTION		Numeric 1—AP51.1
CVV-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.AP51.1
CVV-WRITE-OFF-AMT
WRITE_OFF_AMT		Signed 18.2—AP51.1, AP51.2
CVV-VEN-CLAIM-TYPE
VEN_CLAIM_TYPE		Alpha 2—AP51.1, AP51.2
CVV-CLAIM-HOLD-CD
CLAIM_HOLD_CD		Alpha 4The hold code.AP51.1, AP51.2
CVV-CB-HOLD-CODE
CB_HOLD_CODE		Alpha 4The hold code.AP51.1
CVV-CB-MINIMUM-AMT
CB_MINIMUM_AMT		Signed 18.2—AP51.1
CVV-REPLACE-GOODS
REPLACE_GOODS		Alpha 1—AP51.1, AP51.2
CVV-SHIP-OR-HOLD
SHIP_OR_HOLD		Alpha 1—AP51.1, AP51.2
CVV-ERS-HANDLING
ERS_HANDLING		Alpha 4—AP58.1
CVV-E-MAIL-ADDRESS
E_MAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.AP51.1, AP51.2
CVV-URL-ADDR
URL_ADDR		Alpha 60 (Lower Case)—AP51.1
CVV-VEND-ACCT
VEND_ACCT		Alpha 30The customer number the vendor has assigned to you.AP51.1, AP51.2
CVV-LANGUAGE-CODE
LANGUAGE_CODE		Alpha 10Language Code (LOCALE).AP51.1
CVV-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.AP51.1, AP51.2
CVV-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.AP51.1, AP51.2
CVV-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.AP51.1, AP51.2
CVV-VALIDATE-PO
VALIDATE_PO		Alpha 1" " = Use Default
  • Y Yes
  • N No
AP51.1
CVV-REQUIRE-PO
REQUIRE_PO		Alpha 1" " = Use Default
  • Y Yes
  • N No
AP51.1
CVV-POV-BUYER-CODE
POV_BUYER_CODE		Alpha 3The user defined buyer identifier for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-OPEN-PO-LM
POV_OPEN_PO_LM		Signed 18.2The maximum open purchase order amount that is allowed for the vendor. A purchase order may not be released if it will cause the Open PO Amount to exceed this value. For the PO side of vendor.AP51.4, AP51.5
CVV-POV-OPEN-PO-AM
POV_OPEN_PO_AM		Signed 18.2The total open amount (not cancelled and not paid) for the vendor. This total includes only product costs (add on costs and taxes are not included) and is stated in base currency. This is for the PO side of vendor.AP51.4, AP51.5
CVV-POV-LEADTIME
POV_LEADTIME		Numeric 3This field contains the average lead-time date. The average of the last and the previous lead-time days if system calculated. This is for the PO side of vendor.AP51.4, AP51.5
CVV-POV-EDI-NUMBER
POV_EDI_NUMBER		Alpha 15EDI number for the PO side of the Vendor.AP51.4, AP51.5
CVV-POV-FAX-PREFIX
POV_FAX_PREFIX		Alpha 6The fax number prefix for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-FAX-EXT
POV_FAX_EXT		Alpha 5This field contains the fax number extension for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-FAX-NUMBER
POV_FAX_NUMBER		Alpha 15This field contains the fax number for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-MAX-ORD-AM
POV_MAX_ORD_AM		Signed 18.2The maximum open purchase order amount for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-FREIGHT-TR
POV_FREIGHT_TR		Alpha 1The Vendor's default freight term for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-SHIP-VIA
POV_SHIP_VIA		Alpha 12 (Lower Case)The Vendor's default ship via narrative for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-FOB-CODE
POV_FOB_CODE		Alpha 3The vendor's user-defined ship term code that is used as a default at purchase order entry time for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-NORM-DEL
POV_NORM_DEL		Alpha 3The Vendor's normal delivery day for the PO side of the vendor. Informational only.AP51.4, AP51.5
CVV-POV-OSHIP-TPCT
POV_OSHIP_TPCT		Percent 5.3 (Percent)Quantity overshipment tolerance percentage for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-USHIP-TPCT
POV_USHIP_TPCT		Percent 6.3 (Percent)This is the quantity undership percentage for automatic back order cancellation. If a value of 10% is entered here, for instance, and a quantity of 91 is shipped against an ordered quantity of 100, that would be considered a 9% undershipment. Since this is less than the 10% limit, the backordered amount would be canceled. This is for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-HIN-NBR
POV_HIN_NBR		Alpha 9The Health Industry Number is a unique number assigned to any company or facility doing business in the health industry. This number is assigned by the Health Industry Business Communications Council (HIBCC). This is for the PO side of the Vendor.—
CVV-POV-ZOHSHIP-FL
POV_ZOHSHIP_FL		Alpha 1The Vendor default overshipment quantity tolerance flag. For the PO side of the vendor.AP51.4, AP51.5
CVV-POV-ZUHSHIP-FL
POV_ZUHSHIP_FL		Alpha 1Set this flag to "Y" to indicate that the undershipment tolerance percent should be set to "zero" at this level. This means that no backorders will be canceled. The undershipment tolerance percent must be blank to set this flag to "Y". For the PO side of Vendor.AP51.4, AP51.5
CVV-POV-CAN-ALL-BO
POV_CAN_ALL_BO		Alpha 1If set to "Y", when the first receiving is processed against a purchase order for this vendor, any items that are backordered will be canceled, including items that were not shipped.
  • Y Cancel all backorders
  • N Do not cancel all backorders
AP51.4
CVV-POV-RMA-REQ
POV_RMA_REQ		Alpha 1Type or select a "Y" to indicate that the vendor requires return material authorization numbers when returns are made to them. The RMA number will than be required to be entered on any returns to that vendor, and vendor RMA documents can be printed to send to the vendor with the return goods. For the PO side of vendor.AP51.4, AP51.5
CVV-POV-RMA-DOC-RQ
POV_RMA_DOC_RQ		Alpha 1Set to Yes to indicate that Return Material Authorization documents provided by the vendor must be sent with any goods returned to this vendor. RMA documents can also be printed internally and sent to the vendor, but this flag does not pertain to those documents. For the PO side of vendor.AP51.4, AP51.5
CVV-POV-OV-SHP-VIA
POV_OV_SHP_VIA		Alpha 12This is the shipping method to be used for the shipment of return goods to the vendor. This may be defaulted from the vendor. For the PO side of the vendor.AP51.4
CVV-POV-REQ-LOCLVL
POV_REQ_LOCLVL		Alpha 1This field is used to determine how requisition lines can be combined, based on requesting location, in two different circumstances. The first circumstance is whether multiple requisitions lines can be combined into one purchase order line. If the flag is set to "S", they can be combined, regardless of requesting locations on the lines. If the flag is set to "L" or "H", the requisition lines can only be combined if the requesting locations are the same. The second circumstance is whether requisition lines for different requesting locations can be combined on the same purchase order. If the flag is set to "S" or "L", they can be combined. If the flag is set to "H", they cannot be combined. For the PO side of the vendor.AP51.4, AP51.5
CVV-POV-REQ-CONLVL
POV_REQ_CONLVL		Alpha 1This field is used to determine whether requisition lines with different contract numbers can be combined onto a single purchase order. For the PO side of the Vendor.—
CVV-POV-ISSUE-MTHD
POV_ISSUE_MTHD		Alpha 1Specifies the method that will be used to issue the purhase order to the vendor. For the PO side of the Vendor.AP51.4, AP51.5
CVV-POV-REV-ISS-MT
POV_REV_ISS_MT		Alpha 1Specifies the method that will be used to issued purchase order revisions to the vendor. For the PO side of the vendor.AP51.4, AP51.5
CVV-POV-REV-EDI-NB
POV_REV_EDI_NB		Alpha 15Type the number used to identify the trading partner in the EDI translation software for purchase order revisions. If you do not specify a value, the PO Vendor's EDI Number will be used on purchase order revision. For the PO side of Vendor.AP51.4, AP51.5
CVV-POV-REV-EDI-TR
POV_REV_EDI_TR		Alpha 1For vendors that receive purchase order revisions via EDI, this specifies whether the EDI transaction is a normal EDI purchase order transaction (for example, an ANSI X12 850) or a change purchase order transaction (for example, an ANSI X12 860). For the PO side of the vendor.AP51.4, AP51.5
CVV-POV-REV-INCL
POV_REV_INCL		Alpha 1Specifies what information will be included when a revised purchase order is re-issued. You may specify that only the revised information is included, along with messages that indicate what was revised (option O - Revisions Only). Alternately, you may specify that the entire PO is included, along with messages that indicate the revisions. Finally, you may specify that the entire PO is re-issued. No revision messages will appear. If the PO has not been printed, or the revised PO is not to be re-issued, this field will be blank (Not Applicable). For the PO side of Vendor.AP51.4, AP51.5
CVV-POV-VEN-CONT
POV_VEN_CONT		Alpha 30The PO side Vendor contact name.AP51.4, AP51.5
CVV-POV-PHONE-PREF
POV_PHONE_PREF		Alpha 6The telephone number country code. For the PO side of vendor.AP51.4, AP51.5
CVV-POV-PHONE-NUM
POV_PHONE_NUM		Alpha 15This is the main telephone number for the PO side of vendor.AP51.4, AP51.5
CVV-POV-PHONE-EXT
POV_PHONE_EXT		Alpha 5This field contains the telephone extension number for the PO side of the vendor.AP51.4, AP51.5
CVV-POV-VEND-ACCT
POV_VEND_ACCT		Alpha 30The customer number the vendor has assigned to you for the PO side of Vendor.—
CVV-POV-PO-CODE
POV_PO_CODE		Alpha 4This is the purchase order code that will default from the vendor to the purchase order. For the PO side of the vendor.AP51.4, AP51.5
CVV-POV-UPD-PO-CST
POV_UPD_PO_CST		Numeric 1Used by Pharmacy subsystem to indicate if the line item cost should be updated by programs PO122 and MA531. By setting the value to 3 the user is telling the programs to take the pricing of this item from the EDI 855 and 856 transactions an update the PO.
  • 1 Do Not update PO cost from rec
  • 2 Update PO cost from rec
AP51.4
CVV-POV-USR-FLD-01
POV_USR_FLD_01		Alpha 20—AP51.4
CVV-POV-USR-FLD-02
POV_USR_FLD_02		Alpha 20—AP51.4
CVV-POV-USR-FLD-03
POV_USR_FLD_03		Alpha 20—AP51.4
CVV-POV-USR-FLD-04
POV_USR_FLD_04		Alpha 20—AP51.4
CVV-POV-USR-FLD-05
POV_USR_FLD_05		Alpha 20—AP51.4
CVV-MBL-INT-PREFIX
MBL_INT_PREFIX		Alpha 6This field contains the country code of the mobile phone number.AP51.1, AP51.2
CVV-MOBILE-NUM
MOBILE_NUM		Alpha 15This field contains the mobile phone number.AP51.1, AP51.2
CVV-MOBILE-EXT
MOBILE_EXT		Alpha 5This field contains the mobile phone extension number.AP51.1, AP51.2
CVV-PAY-IMM-FLAG
PAY_IMM_FLAG		Alpha 1—AP51.1, AP51.2
CVV-DIVERSE-CODE
DIVERSE_CODE		Alpha 5Diversity Code for Account Payable VendorsAP51.1, AP51.2
CVV-INTM-BANK-ENT
INTM_BANK_ENT		Alpha 15Type the intermediary bank identification used to deposit electronic payments for the vendor.AP58.1
CVV-INTM-BANK-ACCT
INTM_BANK_ACCT		Alpha 35Type the intermediary bank account number used to deposit electronic payments for the vendor.AP58.1
CVV-INTM-BANK-IDNT
INTM_BANK_IDNT		Alpha 1This field indicate if the account number is an IBANK number that requires an account validation check.
  • Y Yes
  • N No or Blank
AP58.1
CVV-INTM-BANK-CURR
INTM_BANK_CURR		Alpha 5This field contains the intermediary bank currency code.AP58.1
CVV-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
AP58.1
CVV-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.AP58.1
CVV-INTM-PMT-CAT
INTM_PMT_CAT		Alpha 6Select the Intermediary SWIFT payment category.AP58.1
CVV-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
AP58.1
CVV-INTM-PMT-FORM
INTM_PMT_FORM		Alpha 2Indicates how the Intermediary SWIFT payment is made.AP58.1
CVV-INTM-CHRG-CD
INTM_CHRG_CD		Alpha 1Indicates who pays service charges or fees associated with a Intermediary SWIFT payment.AP58.1
CVV-INTM-RIBKEY
INTM_RIBKEY		Numeric 2——
CVV-INTM-CRS-IDENT
INTM_CRS_IDENT		Alpha 1—
  • S SWIFT
  • R Routing Number
AP58.1
CVV-FLOAT-DAYS
FLOAT_DAYS		Numeric 3THis is a number of days to add to best terms calculation if the vendor will allow a specific number of days for payment to reach them and still receive the discount.AP51.1
CVV-VN-BLD-SOC-REF
VN_BLD_SOC_REF		Alpha 18This field holds an individual account number reference for the Building Society—
CVV-VN-BLD-ACCT-NM
VN_BLD_ACCT_NM		Alpha 18——
CVV-IN-BLD-SOC-REF
IN_BLD_SOC_REF		Alpha 18This field holds an individual account number reference for the Building Society—
CVV-IN-BLD-ACCT-NM
IN_BLD_ACCT_NM		Alpha 18——
CVV-MTCH-PREPAY-FL
MTCH_PREPAY_FL		Alpha 1Flag notes that the invoice will be prepaid. This is for match invoices.—
CVV-MTCH-PREPAY-MT
MTCH_PREPAY_MT		Numeric 1Flag denotes the method of match prepayment.
  • 0 No
  • 1 Prepay from Invoice
  • 2 Eligible for Prepayment
—
CVV-BUILD-SOC-REF
BUILD_SOC_REF		Alpha 18This field holds an individual account number reference for the Building SocietyAP58.1
CVV-BUILD-ACCT-NM
BUILD_ACCT_NM		Alpha 18—AP58.1
CVV-MIN-ORD-WEIGHT
MIN_ORD_WEIGHT		Signed 9.3—AP51.4
CVV-UNLOADING-PORT
UNLOADING_PORT		Alpha 5The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)AP51.4
CVV-LOADING-PORT
LOADING_PORT		Alpha 5The port where the goods are loaded, if required. The port code must be defined in IN04.1 (Port Maintenance)AP51.4
CVV-WORKFLOW-GROUP
WORKFLOW_GROUP		Alpha 20—AP51.1
CVV-RULE-GROUP
RULE_GROUP		Alpha 10—AP51.1
CVV-CROSS-IDENT
CROSS_IDENT		Alpha 1This field is used to distinguish between SWIFT ID numbers and Routing numbers.
  • S SWIFT
  • R Routing Number
AP58.1
CVV-GIRO-NUMBER
GIRO_NUMBER		Alpha 15This field is the Bankgiro or Postgiro account numberAP58.1
CVV-CR-CARD-NUMBER
CR_CARD_NUMBER		Alpha 16This field contains the credit card number.AP58.1
CVV-BANK-INSTRUCT1
BANK_INSTRUCT1		Alpha 35This field contains bank instructions.AP58.1
CVV-BANK-INSTRUCT2
BANK_INSTRUCT2		Alpha 35This field contains bank instructions.AP58.1
CVV-BANK-INSTRUCT3
BANK_INSTRUCT3		Alpha 35This field contains bank instructions.AP58.1
CVV-BANK-INSTRUCT4
BANK_INSTRUCT4		Alpha 35This field contains bank instructions.AP58.1
CVV-LOC-ID-PRT
LOC_ID_PRT		Numeric 1—AP51.4, AP51.5
CVV-PUNCHOUT-CHG-F
PUNCHOUT_CHG_F		Numeric 1—AP51.4, AP51.5
CVV-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.AP51.4, AP51.5
CVV-REORDER-SUN-FL
REORDER_SUN_FL		Numeric 1—AP51.4, AP51.5
CVV-REORDER-MON-FL
REORDER_MON_FL		Numeric 1—AP51.4, AP51.5
CVV-REORDER-TUE-FL
REORDER_TUE_FL		Numeric 1—AP51.4, AP51.5
CVV-REORDER-WED-FL
REORDER_WED_FL		Numeric 1—AP51.4, AP51.5
CVV-REORDER-THU-FL
REORDER_THU_FL		Numeric 1—AP51.4, AP51.5
CVV-REORDER-FRI-FL
REORDER_FRI_FL		Numeric 1—AP51.4, AP51.5
CVV-REORDER-SAT-FL
REORDER_SAT_FL		Numeric 1—AP51.4, AP51.5
CVV-DIVERSE-CODE5
DIVERSE_CODE5		Alpha 5Diversity Code for Account Payable Vendors—
CVV-P-CARD-FLAG
P_CARD_FLAG		Numeric 1—
  • 0 No
  • 1 Yes
AP51.1
CVV-PCARD-NBR
PCARD_NBR		Alpha 16—AP51.1
CVV-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.4AP51.1
CVV-POV-GTIN-USED
POV_GTIN_USED		Numeric 1—
  • 0 No
  • 1 Yes
AP51.4
CVV-GTIN-ITEM-SYNC
GTIN_ITEM_SYNC		Numeric 1—
  • 0 No
  • 1 Yes
AP51.4
CVV-AP-GLN-NBR
AP_GLN_NBR		Alpha 13—AP51.1, AP51.2
CVV-PO-GLN-NBR
PO_GLN_NBR		Alpha 13—AP51.4, AP51.5
CVV-SEC-WTH-EXEMPT
SEC_WTH_EXEMPT		Alpha 1—AP51.1
CVV-SEC-WTH-CODE1
SEC_WTH_CODE1		Alpha 10—AP51.1
CVV-SEC-WTH-CODE2
SEC_WTH_CODE2		Alpha 10—AP51.1
CVV-SEC-WTH-CODE3
SEC_WTH_CODE3		Alpha 10—AP51.1
CVV-VALID-CERT-DT
VALID_CERT_DT		Alpha 1—AP51.1, AP51.2
CVV-FOR-ECON-CODE
FOR_ECON_CODE		Alpha 10—AP51.1
CVV-CARRIER-FLAG
CARRIER_FLAG		Alpha 1—AP51.1
CVV-BANK-CODE
BANK_CODE		Alpha 2—AP58.1
CVV-BANK-ID
BANK_ID		Alpha 9—AP58.1
CVV-ASSIGNMENT-NBR
ASSIGNMENT_NBR		Alpha 14—AP58.1
CVV-DEBITING-SIGN
DEBITING_SIGN		Alpha 1—AP58.1
CVV-INTM-BANK-CODE
INTM_BANK_CODE		Alpha 2—AP58.1
CVV-INTM-BANK-ID
INTM_BANK_ID		Alpha 9—AP58.1
CVV-INTM-ASSIGN-NO
INTM_ASSIGN_NO		Alpha 14—AP58.1
CVV-INTM-DEBITING
INTM_DEBITING		Alpha 1—AP58.1
CVV-CHK-DIG-TYPE
CHK_DIG_TYPE		Alpha 10—AP51.1
CVV-SEPA-FLAG
SEPA_FLAG		Alpha 1——
CVV-INTM-SEPA-FLAG
INTM_SEPA_FLAG		Alpha 1——

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CVVSET1VENDOR-GROUP, VENDOR, OLD-VENDOR, LOCATION-CODEPrimaryAP51.1, AP51.2, AP51.4, AP51.5, AP51.8, AP510, AP58.1

Relations

One to many (2) — child tables

RelationTableRulesConditionField map
ApcontactsAPCCONTACTDelete CascadesCVV-VENDOR-GROUP → CVH-VENDOR-GROUP, CVV-VENDOR → CVH-VENDOR, CVV-LOCATION-CODE → CVH-LOCATION-CODE, → CVH-RESP-CODE, → CVH-CONTACT-LVL
ApcvenbalAPCVENBALCVV-VENDOR-GROUP → CVB-VENDOR-GROUP, CVV-VENDOR → CVB-VENDOR, CVV-OLD-VENDOR → CVB-OLD-VENDOR, CVV-LOCATION-CODE → CVB-LOCATION-CODE, → CVB-COMPANY

Programs

Updated by (6)