|
|
APCVENMAST FILE
Vendor Conversion
The Vendor Conversion file is used by the Vendor Conversion program to
convert vendor and alternate vendor location records to the Lawson Accounts
Payable system. When you run AP510 (Vendor Conversion), the system reads
records in this file for conversion into the Accounts Payable Vendor and
Vendor Location files. When Vendor Conversion file records are successfully
converted, they are purged from this file. You can use AP51.1 (Vendor
Conversion) and AP51.2 (Vendor Location Conversion) to add records to this
file or maintain records previously loaded into this file for conversion to
the Lawson Accounts Payable system.
UPDATED BY
AP51.1 AP51.2 AP510
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVV-VENDOR-GROUP Alpha 4 AP51.1 AP51.2
Vendor Group Required. The vendor group. Must be a
valid record in the Vendor Group file.
CVV-VENDOR Alpha 9 AP51.1 AP51.2
Vendor ID The vendor number. Required if defining AP510
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.
CVV-OLD-VENDOR Alpha 9 AP51.1 AP51.2
Old Vendor ID The vendor's number before conversion
to the Lawson Accounts Payable system.
Required if using automatic vendor
numbering.
CVV-LOCATION-CODE Alpha 4 AP51.1 AP51.2
Location Code Required 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.
CVV-LOC-TYPE Alpha 1 AP51.2
Location Type If defining an alternate vendor
location record, this field indicates
the type of alternate location for the
vendor. Valid values are:
P = Purchase-From. Represents an
alternate purchasing location for the
vendor.
R = Remit-To. Represents an alternate
remittance location for the vendor.
B = Both. Can be used as both an
alternate purchasing and remittance
location for the vendor.
Blank = An alternate vendor location
record is not being defined.
CVV-VEN-CLASS Alpha 3 AP51.1
Vendor Class Required. 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.
CVV-VENDOR-VNAME Alpha 30 (Lower Case) AP51.1 AP51.2
Vendor Name Required. The vendor name or
description. This field accepts both
upper and lower case entries.
CVV-VENDOR-SNAME Alpha 30 AP51.1
Vendor Search Name The search name for the vendor. If left
blank, the Vendor Name defaults.
CVV-VENDOR-CONTCT Alpha 30 AP51.1 AP51.2
Vendor Contact The vendor contact name.
CVV-ADDR1 Alpha 30 (Lower Case) AP51.1 AP51.2
Address 1 Required. The first line of address
information for the vendor. This field
accepts both upper and lower case
entries.
CVV-ADDR2 Alpha 30 (Lower Case) AP51.1 AP51.2
Address 2 The second line of address information
for the vendor. This field accepts both
upper and lower case entries.
CVV-ADDR3 Alpha 30 (Lower Case) AP51.1 AP51.2
Address 3 The third line of address information
for the vendor. This field accepts both
upper and lower case entries.
CVV-ADDR4 Alpha 30 (Lower Case) AP51.1 AP51.2
Address 4 The fourth line of address information
for the vendor. This field accepts both
upper and lower case entries.
CVV-CITY-ADDR5 Alpha 18 (Lower Case) AP51.1 AP51.2
City or Address 5 The city or fifth line of address
information for the vendor. This field
accepts both upper and lower case
entries.
CVV-STATE-PROV Alpha 2 AP51.1 AP51.2
State or Province The state or province for the vendor
address.
CVV-POSTAL-CODE Alpha 10 (Lower Case) AP51.1 AP51.2
Postal Code The postal code for the vendor address.
CVV-COUNTRY Alpha 30 (Lower Case) AP51.1 AP51.2
Country Description 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.
CVV-NORM-REMIT Alpha 1 AP51.2
Normal Remittance If defining an alternate vendor
Location 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.
CVV-NORM-PURCH Alpha 1 AP51.2
Normal Purchasing If defining an alternate vendor
Location 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.
CVV-REMIT-TO-CODE Alpha 4 AP51.2
Remit To Location The normal remittance location for an
Code 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.
CVV-PURCH-FR-LOC Alpha 4
Purchase From THIS FIELD IS NOT CURRENTLY USED.
Location Code
CVV-PAY-VENDOR Alpha 9 AP51.1
Paid Vendor The vendor number of the vendor to be
paid for invoices entered for this
vendor. If left blank, the Vendor
defaults.
If entered, make sure the value is a
valid record in the Vendor Conversion or
Vendor file.
CVV-VENDOR-STATUS Alpha 1 AP51.1 AP51.2
Vendor Status The vendor status. You cannot enter
invoices for a vendor with an Inactive
status. Valid values are:
A = Active.
I = Inactive.
CVV-VEN-PRIORITY Numeric 2 AP51.1
Vendor Priority The 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.
CVV-PHONE-PREFIX Alpha 6 AP51.1 AP51.2
Telephone Country The telephone number prefix for the
Code vendor.
CVV-PHONE-NUM Alpha 15 AP51.1 AP51.2
Telephone Number The telephone number for the vendor.
CVV-PHONE-EXT Alpha 5 AP51.1 AP51.2
Telephone Extension The telephone extension number for the
vendor.
CVV-FAX-PREFIX Alpha 6 AP51.1 AP51.2
Fax Country Code The fax telephone number prefix for the
vendor.
CVV-FAX-NUM Alpha 15 AP51.1 AP51.2
Fax Number The fax telephone number for the
vendor.
CVV-FAX-EXT Alpha 5 AP51.1 AP51.2
Fax Extension The fax telephone number extension for
the vendor.
CVV-TELEX-NUM Alpha 15 AP51.1 AP51.2
Telex Number The telex number for the vendor.
CVV-TERM-CODE Alpha 5 AP51.1 AP51.2
Terms Code The 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.
CVV-INV-CURRENCY Alpha 5 AP51.1 AP51.2
Invoice Currency The 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.
CVV-BAL-CURRENCY Alpha 5 AP51.1
Balance Currency 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
will be used.
CVV-CURR-RECALC Alpha 1 AP51.1 AP51.2
Currency If the Invoice Currency is different
Recalculation 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
field = Yes, 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:
Y = Yes. Default value.
N = No.
CVV-SEP-CHK-FLAG Alpha 1 AP51.1
Separate Payment Indicates whether to create a separate
payment for each invoice entered for the
vendor. Valid values are:
N = No.
Y = Yes.
CVV-TAX-ID Alpha 20 AP51.1
Tax ID If tracking reportable income for the
vendor, this field contains the vendor's
tax identification number.
CVV-TAX-CODE Alpha 10 AP51.1 AP51.2
Tax Code 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.
CVV-HLD-CODE Alpha 4 AP51.1
Hold Code The 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.
CVV-DIST-CODE Alpha 9 AP51.1
Distribution Code The 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.
CVV-ACCR-CODE Alpha 4 AP51.1
Invoice Accrual Code The 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.
CVV-BANK-INST-CODE Alpha 3 AP51.1 AP51.2
Payment Code 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 payment or bill of
exchange payment type transaction code
record in the Bank Transaction Code
file.
CVV-CASH-CODE Alpha 4 AP51.1
Cash Code 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.
CVV-BANK-ENTITY Alpha 15 AP51.1 AP51.2
Bank The bank identification used to deposit
electronic payments for the vendor. This
field is required for ACH or BACS
payment types.
CVV-VBANK-ACCT-NO Alpha 17 AP51.1 AP51.2
Vendor Bank Account The bank account number used to deposit
Number electronic payments for the vendor.
Required if a value is present in the
Bank field.
CVV-VBANK-ACCT-TP Alpha 1 AP51.1 AP51.2
Vendor Bank Account Indicates the type of bank account
Type where electronic payments for the vendor
will be deposited. Required if a value
is present in the Bank field. Valid
values are:
C = Current/Checking Account.
S = Savings Account.
Blank = Electronic payment type was not
selected.
CVV-INCOME-CODE Alpha 4 AP51.1
Income Code The 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.
CVV-INCOME-WH-FLG Alpha 1 AP51.1
Income Withholding Indicates whether invoices for the
Flag vendor are subject to reportable income
withholding. Valid values are:
N = No. Default value.
Y = Yes.
CVV-EDI-NBR Alpha 15 AP51.1 AP51.2
EDI Number The 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.
CVV-ACH-PRENOT Alpha 1 AP51.1 AP51.2
ACH Prenotification Used in conjunction with ACH payments
Status made for the vendor. Indicates the
status of the electronic payment between
the vendor and the processing bank.
Valid values are:
N = Not Prenotified. Default value if
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.
P = Prenotified. Indicates that the
processing bank has been notified but
has not yet accepted the electronic
payment tape.
A = Accepted. Change the status to
Accepted once the processing bank
accepts the electronic payment tape.
Blank = ACH payment type not selected.
CVV-MAX-INV-AMT Signed 15.2 AP51.1
Maximum Invoice The maximum single invoice amount that
Amount can be entered for the vendor.
CVV-ORIGIN-DATE Numeric 8 (yyyymmdd) AP51.1
Origin Date The origin date for the vendor.
Provides additional information such as
the date the vendor relationship began.
If left blank, the system date defaults.
CVV-USER-NAME-01 Alpha 15 AP51.1 AP51.2
Vendor Group - User The value of the information being
Name 1 tracked for the vendor in the first
vendor group user field.
CVV-USER-NAME-02 Alpha 15 AP51.1 AP51.2
Vendor Group - User The value of the information being
Name 2 tracked for the vendor in the second
vendor group user field.
CVV-USER-NAME-03 Alpha 15 AP51.1 AP51.2
Vendor Group - User The value of the information being
Name 3 tracked for the vendor in the third
vendor group user field.
CVV-USER-NAME-04 Alpha 15 AP51.1 AP51.2
Vendor Group - User The value of the information being
Name 4 tracked for the vendor in the fourth
vendor group user field.
CVV-USER-NAME-05 Alpha 15 AP51.1 AP51.2
Vendor Group - User The value of the information being
Name 5 tracked for the vendor in the fifth
vendor group user field.
CVV-USER-NAME-06 Alpha 15 AP51.1 AP51.2
Vendor Group - User The value of the information being
Name 6 tracked for the vendor in the sixth
vendor group user field.
CVV-LEGAL-NAME Alpha 30 (Lower Case) AP51.1
Legal Name The legal name for the vendor. Used for
reporting reportable vendor income. If
left blank, the vendor name defaults.
CVV-ACTIVITY Alpha 15 AP51.1
Activity The 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.
CVV-ACCT-CATEGORY Alpha 5 AP51.1
Account Category The 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.
CVV-DISCOUNT-CODE Alpha 10 AP51.1
Discount Code The 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.
CVV-PRIME-RATE Signed 7.5 AP51.1
Anticipation The percentage used to calculate
Discount Rate 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.
CVV-INVOICE-GROUP Alpha 4 AP51.1
Invoice Group A 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.
CVV-RET-INV-METH Alpha 1 AP51.1
Return Invoicing Indicates whether a replacement type
Method return will be shipped no charge, or
whether the vendor will credit the
return and invoice the replacement
shipment. Valid values are:
C = Credit/Rebill.
N = No Charge.
CVV-RET-MEMO-FL Alpha 1 AP51.1
Create Debit Memo Indicates whether to create debit memos
for items returned to a vendor. Valid
values are:
Y = Yes.
N = No.
CVV-ERS-CAPABLE Alpha 1 AP51.1 AP51.2
ERS Capable Indicates whether the vendor can
process ERS. Valid values are:
Y = Yes.
N = No.
CVV-INVC-REF-TYPE Alpha 2 AP51.1 AP51.2
Invoice Reference Indicates the type of number the vendor
Type is providing to reference the invoice.
Valid values are:
BM = Bill of Lading
IN = Invoice.
OW = Service Order Number.
PL = Packing List Number.
PO = Purchase Order Number.
VN = Vendor Order Number.
WO = Work Order.
WP = Warehouse Pick Ticket
ZZ = Mutually Defined.
CVV-ERS-AUTO-REL Alpha 1 AP51.1 AP51.2
ERS Invoice Auto Indicates whether the company
Release automatically releases invoices created
from receipts in the evaluated receipts
settlements process (payment on
receipt). Valid values are:
Y = Yes.
N = No.
CVV-EDI-AUTO-REL Alpha 1 AP51.1 AP51.2
Edi Auto Rel If you interface EDI invoices for the
vendor using MA540 (EDI Line Level
Match), this field indicates whether to
interfaces invoices in a released
status. If this field is Yes, then
invoices that are matched or interfaced
cleanly are interfaced to Accounts
Payable in a released status. Valid
values are:
N = No.
Y = Yes.
CVV-AUTH-CODE Alpha 3 AP51.1
Authority Code A 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.
CVV-CHARGE-CODE Alpha 1 AP51.1
Charge Code The 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.
CVV-PMT-CAT-CODE Alpha 1 AP51.1
Payment Category The SWIFT payment category code
Code assigned to the vendor. Valid values
are:
G = Goods.
S = Service & Capital.
T = Transit Trade.
X = Transfer.
O = Other.
CVV-NORM-EXP-CODE Alpha 1 AP51.1
Normal or Express The normal or express SWIFT payment
Code option assigned to the vendor. Valid
values are:
N = Normal.
E = Express.
CVV-PMT-FORM Alpha 1 AP51.1
Payment Form The SWIFT payment form assigned to the
vendor. Indicates how the payment is
made. Valid values are:
C = Check.
F = Foreign Bank.
CVV-SWIFT-ID Alpha 12 AP51.1
SWIFT ID The SWIFT identification number
assigned to the vendor.
CVV-COUNTRY-CODE Alpha 2 AP51.1 AP51.2
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CVV-REGION Alpha 2 AP51.1 AP51.2
Region Code The region code, if applicable for the
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
CVV-VAT-REG-CTRY Alpha 2 AP51.1 AP51.2
VAT Registration The country component of the VAT
Country Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
CVV-VAT-REG-NBR Alpha 12 AP51.1 AP51.2
VAT Registration The number component of the VAT
Number Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
CVV-VAT-NBR Derived
VAT Number The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
CVV-LANGUAGE-CODE Alpha 10 AP51.1
Language Code The language code representing the
conversion vendor's preferred language.
If no language code is specified, the
environment base language is assumed.
Must be defined in GL19.1 (Language
Code Maintenance) as well as in the
langdef environment.
APCVENMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVVSET1 VENDOR-GROUP This index is used to access vendor AP51.1 AP51.2
VENDOR conversion records. AP510
OLD-VENDOR
LOCATION-CODE
APCVENMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcvenbal APCVENBAL
CVV-VENDOR-GROUP -> CVB-VENDOR-GROUP
CVV-VENDOR -> CVB-VENDOR
CVV-OLD-VENDOR -> CVB-OLD-VENDOR
CVV-LOCATION-CODE -> CVB-LOCATION-CODE
CVB-COMPANY
|