Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCVENMAST


                            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    AP51.4    AP51.5    AP510

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CVV-VENDOR-GROUP       Alpha 4                                   AP51.1  AP51.2
Element: Vendor Group  Required. The vendor group. Must be a     AP51.4  AP51.5
                       valid record in the Vendor Group file.

CVV-VENDOR             Alpha 9  (Right Justified)                AP51.1  AP51.2
Element: Vendor        The vendor number. Required if defining   AP51.4  AP51.5
                       a vendor or alternate vendor location     AP510
                       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  (Right Justified)                AP51.1  AP51.2
Element: Vendor ID     The vendor's number before conversion     AP51.4  AP51.5
                       to the Lawson Accounts Payable system.
                       Required if using automatic vendor
                       numbering.

CVV-LOCATION-CODE      Alpha 4                                   AP51.1  AP51.2
Purchase From          Required if defining an alternate         AP51.4  AP51.5
Location Code          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
Element: Bin Usage TypeIf 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
Element: 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
Element: Name          Required. The vendor name or
                       description. This field accepts both
                       upper and lower case entries.

CVV-VENDOR-SNAME       Alpha 30                                  AP51.1
Element: Search Name   The search name for the vendor. If left
                       blank, the Vendor Name defaults.

CVV-VENDOR-CONTCT      Alpha 30                                  AP51.1  AP51.2
Element: Contact

CVV-ADDR1              Alpha 30  (Lower Case)                    AP51.1  AP51.2
Element: 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
Element: 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
Element: 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
Element: 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
Element: City or AddresThe 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
Element: State or ProviThe state or province for the vendor
                       address.

CVV-POSTAL-CODE        Alpha 10  (Lower Case)                    AP51.1  AP51.2
Element: Postal Code   The postal code for the vendor address.

CVV-COUNTY             Alpha 25  (Lower Case)                    AP51.1  AP51.2
Element: County        The county for the company address.

CVV-COUNTRY            Alpha 30  (Lower Case)                    AP51.1  AP51.2
Element: Country       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-REGION             Alpha 2                                   AP51.1
Element: Region Code   The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)

CVV-COUNTRY-CODE       Alpha 2                                   AP51.1  AP51.2
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

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
Purchase From          The normal remittance location for an
Location 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  (Right Justified)                AP51.1
Element: Vendor ID     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
Element: 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
Element: Vendor PrioritThe 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
Element: Telephone NumbThe telephone number for the vendor.

CVV-PHONE-EXT          Alpha 5                                   AP51.1  AP51.2
Element: Telephone ExteThe telephone extension number for the
                       vendor.

CVV-FAX-PREFIX         Alpha 6                                   AP51.1  AP51.2
Telephone Country      The fax telephone number prefix for the
Code                   vendor.

CVV-FAX-NUM            Alpha 15                                  AP51.1  AP51.2
Element: Telephone NumbThe fax telephone number for the vendor.

CVV-FAX-EXT            Alpha 5                                   AP51.1  AP51.2
Element: Telephone ExteThe fax telephone number extension for
                       the vendor.

CVV-TELEX-NUM          Alpha 15                                  AP51.1  AP51.2
Element: Telephone NumbThe telex number for the vendor.

CVV-TERM-CODE          Alpha 5                                   AP51.1  AP51.2
Element: 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
To Company Base        The currency used to add invoices for
Currency               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
To Company Base        The currency used to store vendor
Currency               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  AP51.2
Element: Separate PaymeIndicates 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
Element: 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
Element: 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
Element: 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
Element: Distribution CThe 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
Element: Invoice AccruaThe 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
Element: 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  AP51.2
Accounts Receivable    The cash code assigned to the vendor.
Code                   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
Element: 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
Element: Bank Account NThe bank account number used to deposit
                       electronic payments for the vendor.
                       Required if a value is present in the
                       Bank field.

CVV-RIBKEY             Numeric 2                                 AP51.1  AP51.2
Element: Ribkey

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
Accounts Receivable    The income code assigned to the vendor.
Code                   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
Element: 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
Element: 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 20                                  AP51.1  AP51.2
Element: Vendor User FiThe value of the information being
                       tracked for the vendor in the first
                       vendor group user field.

CVV-USER-NAME-02       Alpha 20                                  AP51.1  AP51.2
Element: Vendor User FiThe value of the information being
                       tracked for the vendor in the second
                       vendor group user field.

CVV-USER-NAME-03       Alpha 20                                  AP51.1  AP51.2
Element: Vendor User FiThe value of the information being
                       tracked for the vendor in the third
                       vendor group user field.

CVV-USER-NAME-04       Alpha 20                                  AP51.1  AP51.2
Element: Vendor User FiThe value of the information being
                       tracked for the vendor in the fourth
                       vendor group user field.

CVV-USER-NAME-05       Alpha 20                                  AP51.1  AP51.2
Element: Vendor User FiThe value of the information being
                       tracked for the vendor in the fifth
                       vendor group user field.

CVV-USER-NAME-06       Alpha 20                                  AP51.1  AP51.2
Element: Vendor User FiThe value of the information being
                       tracked for the vendor in the sixth
                       vendor group user field.

CVV-LEGAL-NAME         Alpha 80  (Lower Case)                    AP51.1
Element: 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
Element: 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
Element: Account CategoThe 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
Element: 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  AP51.2
Element: 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-ERS-CAPABLE        Alpha 1                                   AP51.1  AP51.2
Element: All Flag      Indicates whether the vendor location
                       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.
                       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

CVV-EDI-AUTO-REL       Alpha 1                                   AP51.1  AP51.2
Element: EDI Auto ReleaIndicates whether the company
                       automatically releases EDI invoices.

                       Valid values are

                       Y = Yes
                       N = No

CVV-AUTH-CODE          Alpha 3                                   AP51.1
Element: Authority CodeA 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
Element: 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
Element: 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
Element: Swift ID      The SWIFT identification number
                       assigned to the vendor.

CVV-PROC-GRP           Alpha 4  (Lower Case)                     AP51.1
Element: Process Group A process group is an identifier used
                       for separating vendors into different
                       groups to enable concurrent processing
                       within the cash payment cycle.

CVV-MATCH-TABLE        Alpha 10                                  AP51.1
Element: Match Table

CVV-HANDLING-CODE      Alpha 4                                   AP51.1
Element: Handling Code

CVV-DISC-CALC-DATE     Alpha 1                                   AP51.1
Element: Disc Calc Date`
                       R = Receipt Date
                       D = Receipt of Invoice Date
                       I = Invoice Date
                       E = Earliest Receipt Date

CVV-ENCLOSURE          Alpha 1                                   AP51.1
Element: All Flag      N = No
                       Y = Yes
                       " "

CVV-CREATE-POD-FL      Alpha 1                                   AP51.1
Element: Create Pod Fl Y = Yes
                       N = No

CVV-REQ-MATCH-REF      Alpha 1                                   AP51.1
Element: Match Ref ProcY = Yes
                       N = No

CVV-POOL-OPTION        Numeric 1                                 AP51.1
Element: Pool Option

CVV-HOLD-INSP-FLAG     Alpha 1                                   AP51.1
Element: Hold Insp FlagIf set to "Y", this flag will keep
                       receiving lines requiring inspection
                       from being matched until they have been
                       inspected.

CVV-WRITE-OFF-AMT      Signed 15.2                               AP51.1  AP51.2
Element: Invoice Amount

CVV-VEN-CLAIM-TYPE     Alpha 2                                   AP51.1  AP51.2
Element: Vendor Claim Type

CVV-CLAIM-HOLD-CD      Alpha 4                                   AP51.1  AP51.2
Element: Hold Code

CVV-CB-HOLD-CODE       Alpha 4                                   AP51.1
Element: Hold Code

CVV-CB-MINIMUM-AMT     Signed 15.2                               AP51.1
Element: Minimum Claim Amount

CVV-REPLACE-GOODS      Alpha 1                                   AP51.1  AP51.2
Element: Replace Goods

CVV-SHIP-OR-HOLD       Alpha 1                                   AP51.1  AP51.2
Element: Ship or Hold Goods

CVV-ERS-HANDLING       Alpha 4                                   AP51.1  AP51.2
Element: Handling Code

CVV-E-MAIL-ADDRESS     Alpha 60  (Lower Case)                    AP51.1  AP51.2
Element: Email Address

CVV-URL-ADDR           Alpha 60  (Lower Case)                    AP51.1  AP51.2
Element: Url Addr

CVV-VEND-ACCT          Alpha 30                                  AP51.1  AP51.2
Element: Vend Acct     The customer number the vendor has
                       assigned to you.

CVV-LANGUAGE-CODE      Alpha 10                                  AP51.1
Element: Language Code Language Code (LOCALE).

CVV-TAX-USAGE-CD       Alpha 10                                  AP51.1  AP51.2
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

CVV-VAT-REG-CTRY       Alpha 2                                   AP51.1  AP51.2
Element: Vat Reg Ctry  The country component of the VAT
                       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
Element: Vat Reg Nbr   The number component of the VAT
                       Registration Number. This field together
                       with the Registration Country field make
                       up the VAT Registration Number.

CVV-VALIDATE-PO        Alpha 1
Element: Validate Po   " " = Use Default
                       Y = Yes
                       N = No

CVV-REQUIRE-PO         Alpha 1
Element: Require Po    " " = Use Default
                       Y = Yes
                       N = No

CVV-POV-BUYER-CODE     Alpha 3                                   AP51.4  AP51.5
Element: Buyer         The user defined buyer identifier for
                       the PO side of vendor.

CVV-POV-OPEN-PO-LM     Signed 15.2                               AP51.4  AP51.5
Element: Max Amount    The 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.

CVV-POV-OPEN-PO-AM     Signed 15.2                               AP51.4  AP51.5
Element: Max Amount    The 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.

CVV-POV-LEADTIME       Numeric 3                                 AP51.4  AP51.5
Leadtime Number of     This field contains the average
Days                   lead-time dats.  The average of the last
                       and the previous lead-time days if
                       system calculated.  This is for the PO
                       side of Vendor.

CVV-POV-EDI-NUMBER     Alpha 15                                  AP51.4  AP51.5
Element: EDI Number    EDI number for the PO side of the
                       Vendor.

CVV-POV-FAX-PREFIX     Alpha 6                                   AP51.4  AP51.5
Telephone Country      The fax number prefix for the PO side
Code                   of the Vendor.

CVV-POV-FAX-EXT        Alpha 5                                   AP51.4  AP51.5
Element: Telephone ExteThis field contains the fax number
                       extension for the PO side of the Vendor.

CVV-POV-FAX-NUMBER     Alpha 15                                  AP51.4  AP51.5
Element: Telephone NumbThis field contains the fax number for
                       the PO side of the Vendor.

CVV-POV-MAX-ORD-AM     Signed 15.2                               AP51.4  AP51.5
Element: Max Amount    The maximum open purchase order amount
                       for the PO side of the Vendor.

CVV-POV-FREIGHT-TR     Alpha 1                                   AP51.4  AP51.5
Element: Pov Freight TrThe Vendor's default freight term for
                       the PO side of the Vendor.

CVV-POV-SHIP-VIA       Alpha 12  (Lower Case)                    AP51.4  AP51.5
Element: Ship Via DescrThe Vendor's default ship via narrative
                       for the PO side of the Vendor.

CVV-POV-FOB-CODE       Alpha 3                                   AP51.4  AP51.5
Element: Shipping Term The 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.

CVV-POV-NORM-DEL       Alpha 3                                   AP51.4  AP51.5
Element: Normal DeliverThe Vendor's normal delivery day for
                       the PO side of the vendor. Informational
                       only.

CVV-POV-OSHIP-TPCT     Percent 5.3  (Percent)                    AP51.4  AP51.5
Element: Pov Oship TpctQuantity overshipment tolerance
                       percentage for the PO side of the
                       Vendor.

CVV-POV-USHIP-TPCT     Percent 6.3  (Percent)                    AP51.4  AP51.5
Cancel Backorder       This is the quantity undership
Percent                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.

CVV-POV-HIN-NBR        Alpha 9
Element: Pov Hin Nbr   The 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     Alpha 1                                   AP51.4  AP51.5
Element: Pov Zohship FlThe Vendor default overshipment
                       quantity tolerance flag.  For the PO
                       side of the Vendor.

CVV-POV-ZUHSHIP-FL     Alpha 1                                   AP51.4  AP51.5
Element: Pov Zohship FlSet 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.

CVV-POV-CAN-ALL-BO     Alpha 1                                   AP51.4
Element: Cancel All Bo Y = Cancel all backorders
                       N = Do not cancel all backorders

CVV-POV-RMA-REQ        Alpha 1                                   AP51.4  AP51.5
Element: Pov Rma Req   Enter 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.

CVV-POV-RMA-DOC-RQ     Alpha 1                                   AP51.4  AP51.5
Element: Pov Rma Req   Set 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.

CVV-POV-OV-SHP-VIA     Alpha 12
Inbound frm Vendor     This is the shipping method to be used
Ship Via               for the shipment of return goods to the
                       vendor.  This may be defaulted from the
                       vendor.  For the PO side of the Vendor.

CVV-POV-REQ-LOCLVL     Alpha 1                                   AP51.4  AP51.5
Element: Req Loc Level This 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.

CVV-POV-REQ-CONLVL     Alpha 1                                   AP51.4  AP51.5
Element: Req Loc Level This 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     Alpha 1                                   AP51.4  AP51.5
Element: Issue Meth    Specifies the method that will be used
                       to issue the purhase order to the
                       vendor.  For the PO side of the Vendor.

CVV-POV-REV-ISS-MT     Alpha 1                                   AP51.4  AP51.5
Element: Rev Issue MethSpecifies the method that will be used
                       to issued purchase order revisions to
                       the vendor.  For the PO side of Vendor.

CVV-POV-REV-EDI-NB     Alpha 15                                  AP51.4  AP51.5
Element: EDI Number    Enter 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.

CVV-POV-REV-EDI-TR     Alpha 1                                   AP51.4  AP51.5
Element: Rev Edi Trans For 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
                       Vendor.

CVV-POV-REV-INCL       Alpha 1                                   AP51.4  AP51.5
Element: Revisions InclSpecifies 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 spcify 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-issed, this
                       field will be blank (Not Applicable).

                       For the PO side of Vendor.

CVV-POV-VEN-CONT       Alpha 30                                  AP51.4  AP51.5
Element: Tax Contact   The PO side Vendor contact name.

CVV-POV-PHONE-PREF     Alpha 6                                   AP51.4  AP51.5
Telephone Country      The telephone number country code.  For
Code                   the PO side of Vendor.

CVV-POV-PHONE-NUM      Alpha 15                                  AP51.4  AP51.5
Element: Telephone NumbThis is the main telephone number for
                       the PO side of Vendor.

CVV-POV-PHONE-EXT      Alpha 5                                   AP51.4  AP51.5
Element: Telephone ExteThis field contains the telphone
                       extension number for the PO side of the
                       Vendor.

CVV-POV-VEND-ACCT      Alpha 30
Element: Vend Acct     The customer number the vendor has
                       assigned to you for the PO side of
                       Vendor.

CVV-POV-PO-CODE        Alpha 4                                   AP51.4  AP51.5
Element: Po Code       This is the purchase order code that
                       will default from the vendor to the
                       purchase order.  For the PO side of the
                       Vendor.

CVV-POV-UPD-PO-CST     Numeric 1                                 AP51.4
Element: Upd Po Cost   1 = Do Not update PO cost from rec
                       2 = Update PO cost from rec

                         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.                      AP51.4  AP51.5
          OLD-VENDOR                                             AP510
          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