Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
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
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
Old 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
Location Code        Required if defining an alternate           AP51.4  AP51.5
                     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
Search Name          The search name for the vendor. If left
                     blank, the Vendor Name defaults.

CVV-VENDOR-CONTCT    Alpha 30                                    AP51.1  AP51.2
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-COUNTY           Alpha 25  (Lower Case)                      AP51.1  AP51.2
County               The county for the company address.

CVV-COUNTRY          Alpha 30  (Lower Case)                      AP51.1  AP51.2
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
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
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
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  (Right Justified)                  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  AP51.2
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  AP51.2
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-RIBKEY           Numeric 2
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
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 20                                    AP51.1  AP51.2
Vendor User Field 1  The 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
Vendor User Field 2  The 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
Vendor User Field 3  The 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
Vendor User Field 4  The 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
Vendor User Field 5  The value of the information being
                     tracked for the vendor in the fifth
                     vendor group user field.

CVV-USER-NAME-06     Alpha 15                                    AP51.1  AP51.2
Vendor User Field 6  The 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
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  AP51.2
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
ERS Capable          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
EDI Auto Release     Indicates whether the company
                     automatically releases EDI invoices.

                     Valid values are

                     Y = Yes
                     N = No

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-PROC-GRP         Alpha 4  (Lower Case)                       AP51.1
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
Match Table

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

CVV-DISC-CALC-DATE   Alpha 1                                     AP51.1
Disc Calc Date       " "
                     R = Receipt Date
                     D = Receipt of Invoice Date
                     I = Invoice Date

CVV-ENCLOSURE        Alpha 1                                     AP51.1
Enclosure            N = No
                     Y = Yes
                     " "

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

CVV-REQ-MATCH-REF    Alpha 1                                     AP51.1
Match Ref Processing Y = Yes
                     N = No

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

CVV-HOLD-INSP-FLAG   Alpha 1                                     AP51.1
Hold Insp Flag       If 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
Write Off Amt

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

CVV-CLAIM-HOLD-CD    Alpha 4                                     AP51.1  AP51.2
Claim Hold Cd

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

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

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

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

CVV-ERS-HANDLING     Alpha 4                                     AP51.1  AP51.2
Ers Handling

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

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

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

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

CVV-TAX-USAGE-CD     Alpha 10                                    AP51.1  AP51.2
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
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
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-POV-BUYER-CODE   Alpha 3                                     AP51.4  AP51.5
Pov Buyer Code       The user defined buyer identifier for
                     the PO side of vendor.

CVV-POV-OPEN-PO-LM   Signed 15.2                                 AP51.4  AP51.5
Pov Open Po Lm       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
Pov Open Po Am       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
Pov Leadtime         This field contains the average
                     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
Pov Edi Number       EDI number for the PO side of the
                     Vendor.

CVV-POV-FAX-PREFIX   Alpha 15                                    AP51.4  AP51.5
Pov Fax Prefix       The fax number prefix for the PO side
                     of the Vendor.

CVV-POV-FAX-EXT      Alpha 5                                     AP51.4  AP51.5
Pov Fax Ext          This field contains the fax number
                     extension for the PO side of the Vendor.

CVV-POV-FAX-NUMBER   Alpha 15                                    AP51.4  AP51.5
Pov Fax Number       This field contains the fax number for
                     the PO side of the Vendor.

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

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

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

CVV-POV-FOB-CODE     Alpha 2                                     AP51.4  AP51.5
Pov Fob Code         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
Pov Norm Del         The 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
Pov Oship Tpct       Quantity overshipment tolerance
                     percentage for the PO side of the
                     Vendor.

CVV-POV-USHIP-TPCT   Percent 6.3  (Percent)                      AP51.4  AP51.5
Pov Uship Tpct       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.

CVV-POV-HIN-NBR      Alpha 9
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
Pov Zohship Fl       The Vendor default overshipment
                     quantity tolerance flag.  For the PO
                     side of the Vendor.

CVV-POV-ZUHSHIP-FL   Alpha 1                                     AP51.4  AP51.5
Pov Zuhship Fl       Set 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
Pov Can All Bo       Y = Cancel all backorders
                     N = Do not cancel all backorders

CVV-POV-RMA-REQ      Alpha 1                                     AP51.4  AP51.5
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
Pov Rma Doc Rq       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
Pov Ov Shp Via       This 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.

CVV-POV-REQ-LOCLVL   Alpha 1                                     AP51.4  AP51.5
Pov Req Loclvl       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
Pov Req Conlvl       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
Pov Issue Mthd       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
Pov Rev Iss Mt       Specifies 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
Pov Rev Edi Nb       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
Pov Rev Edi Tr       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
Pov Rev Incl         Specifies 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
Pov Ven Cont         The PO side Vendor contact name.

CVV-POV-PHONE-PREF   Alpha 6                                     AP51.4  AP51.5
Pov Phone Pref       The telephone number country code.  For
                     the PO side of Vendor.

CVV-POV-PHONE-NUM    Alpha 15                                    AP51.4  AP51.5
Pov Phone Num        This is the main telephone number for
                     the PO side of Vendor.

CVV-POV-PHONE-EXT    Alpha 5                                     AP51.4  AP51.5
Pov Phone Ext        This field contains the telphone
                     extension number for the PO side of the
                     Vendor.

CVV-POV-VEND-ACCT    Alpha 30
Pov 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
Pov 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
Pov Upd Po Cst       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