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     AP58.1


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.    AP58.1


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   AP58.1
                       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        The vendor's number before conversion     AP51.4  AP51.5
                       to Accounts Payable. Required if using
                       automatic vendor numbering.


CVV-LOCATION-CODE      Alpha 4                                   AP51.1  AP51.2
Element: Location Code Required if defining an alternate         AP51.4  AP51.5
                       vendor location record. A user-defined    AP58.1
                       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: Loc 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
Element: Ven 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       The requester can enter the recommended
                       vendor's name for the requested items.

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  AP51.2
Element: Region        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
Element: Remit To Code The normal remittance location for an
                       alternate vendor location, if defined.
                       If present, the address defined for the
                       location overrides the vendor address on
                       vendor payments when invoices are added.
                       Must be a valid record in the Vendor
                       Location file and the Vendor Conversion
                       file.

CVV-PURCH-FR-LOC       Alpha 4
Element: Purch Fr Loc  THIS FIELD IS NOT CURRENTLY USED.

CVV-PAY-VENDOR         Alpha 9  (Right Justified)                AP51.1
Element: 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
Element: Active Flag   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: Ven 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
Element: Phone Prefix  The telephone number prefix for the
                       vendor.

CVV-PHONE-NUM          Alpha 15                                  AP51.1  AP51.2
Element: Phone         The telephone number for the vendor.

CVV-PHONE-EXT          Alpha 5                                   AP51.1  AP51.2
Element: Phone Ext     The telephone extension number for the
                       vendor.


CVV-FAX-PREFIX         Alpha 6                                   AP51.1  AP51.2
Element: Phone Prefix  The fax telephone number prefix for the
                       vendor.

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


CVV-FAX-EXT            Alpha 5                                   AP51.1  AP51.2
Element: Phone Ext     The fax telephone number extension for
                       the vendor.


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

CVV-TERM-CODE          Alpha 5                                   AP51.1  AP51.2
Element: Term 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
Element: To Base Curr  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
Element: To Base Curr  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-BANK-CURRENCY      Alpha 5                                   AP58.1
Element: Currency Code This field contains the bank currency
                       code.


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 Cash Requirements (AP150). If
                       a difference exists, Payment Closing
                       (AP170) 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: Dist 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
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
Element: 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                                  AP58.1
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 35                                  AP58.1
Element: Bank Acct Nbr The bank account number used to deposit
                       electronic payments for the vendor.
                       Required if a value is present in the
                       Bank field.


CVV-VBANK-IDENT        Alpha 1                                   AP58.1
Element: Vbank Ident   This field indicates if the account
                       number is an IBAN number that requires
                       an account validation check.

                       Y = Yes
                       N = No

CVV-RIBKEY             Numeric 2
Element: Ribkey

CVV-VBANK-ACCT-TP      Alpha 1                                   AP58.1
Element: Vbank Acct Tp Indicates the type of bank account
                       where electronic payments for the vendor
                       will be deposited. Required if a value
                       is present in the Bank field. Valid
                       values are:

                       C = Current/Checking Account.
                       S = Savings Account.
                       Blank = Electronic payment type was not
                       selected.



CVV-INCOME-CODE        Alpha 4                                   AP51.1
Element: 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                                  AP58.1
Element: Edi Nbr       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                                   AP58.1
Element: Ach Prenot    Used in conjunction with ACH payments
                       made for the vendor. Indicates the
                       status of the electronic payment between
                       the vendor and the processing bank.
                       Valid values are:

                       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 18.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-CUST-GROUP         Alpha 5                                   AP51.1
Element: Cust Group    Customer group. Used to identify a
                       group of customer associated with one or
                       more companies.

CVV-CUSTOMER           Alpha 9  (Right Justified)                AP51.1
Element: Customer      This field contains the number that
                       represents a customer.


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: Acct 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  AP51.2
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                                   AP58.1
Element: All Flag      Indicates whether the vendor location
                       can process ERS.

                       Valid values are

                       Y = Yes
                       N = No


CVV-INVC-REF-TYPE      Alpha 2                                   AP58.1
Element: Invc Ref Type Indicates the type of number the vendor
                       is providing to reference the invoice.

                       BM = Bill of Lading
                       IN = Invoice
                       OW = Service Order Number
                       PL = Packing List Number
                       PO = PO Number
                       VN = Vendor Order Number
                       WO = Work Order
                       WP = Warehouse Pick Ticket Number
                       ZZ = Mutually Defined

CVV-EDI-AUTO-REL       Alpha 1                                   AP58.1
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: Auth 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                                   AP58.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 6                                   AP58.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                                   AP58.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 2                                   AP58.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                                  AP58.1
Element: Swift ID      The SWIFT identification number
                       assigned to the vendor.

CVV-PROC-GRP           Alpha 4  (Lower Case)                     AP51.1
Element: Proc Grp      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
                       S = Ship To Arrive 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 18.2                               AP51.1  AP51.2
Element: Intl Amt

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     The hold code.

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

CVV-CB-MINIMUM-AMT     Signed 18.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                                   AP58.1
Element: Handling Code

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

CVV-URL-ADDR           Alpha 60  (Lower Case)                    AP51.1
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                                   AP51.1
Element: Validate Po   " " = Use Default
                       Y = Yes
                       N = No

CVV-REQUIRE-PO         Alpha 1                                   AP51.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 the vendor.


CVV-POV-OPEN-PO-LM     Signed 18.2                               AP51.4  AP51.5
Element: Intl Amt      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 18.2                               AP51.4  AP51.5
Element: Intl Amt      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
Element: Leadtime Days This field contains the average
                       lead-time date.  The average of the last
                       and the previous lead-time days if
                       system calculated.  This is for the PO
                       side of vendor.


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


CVV-POV-FAX-PREFIX     Alpha 6                                   AP51.4  AP51.5
Element: Phone Prefix  The fax number prefix for the PO side
                       of the vendor.


CVV-POV-FAX-EXT        Alpha 5                                   AP51.4  AP51.5
Element: Phone 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
Element: Phone         This field contains the fax number for
                       the PO side of the vendor.


CVV-POV-MAX-ORD-AM     Signed 18.2                               AP51.4  AP51.5
Element: Intl Amt      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      The Vendor's default ship via narrative
                       for the PO side of the vendor.


CVV-POV-FOB-CODE       Alpha 3                                   AP51.4  AP51.5
Element: 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
Element: Norm Del Day  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
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
Element: Uship Tol Pct 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
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 If set to "Y", when the first receiving
                       is processed against a purchase order
                       for this vendor, any items that are
                       backordered will be canceled, including
                       items that were not shipped.

                       Y = Cancel all backorders
                       N = Do not cancel all backorders

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                                  AP51.4
Element: Ivend Ship ViaThis 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
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
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 the
                       vendor.


CVV-POV-REV-EDI-NB     Alpha 15                                  AP51.4  AP51.5
Element: Edi Nbr       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
                       the 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 specify that the entire
                       PO is re-issued.  No revision messages
                       will appear.

                       If the PO has not been printed, or the
                       revised PO is not to be re-issued, this
                       field will be blank (Not Applicable).

                       For the PO side of Vendor.






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
Element: Phone Prefix  The telephone number country code.  For
                       the PO side of vendor.


CVV-POV-PHONE-NUM      Alpha 15                                  AP51.4  AP51.5
Element: Phone         This is the main telephone number for
                       the PO side of vendor.


CVV-POV-PHONE-EXT      Alpha 5                                   AP51.4  AP51.5
Element: Phone Ext     This field contains the telephone
                       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   Used by Pharmacy subsystem to indicate
                       if the line item cost should be updated
                       by programs PO122 and MA531. By setting
                       the value to 3 the user is telling the
                       programs to take the pricing of this
                       item from the EDI 855 and 856
                       transactions an update the PO.

                       1 = Do Not update PO cost from rec
                       2 = Update PO cost from rec

CVV-POV-USR-FLD-01     Alpha 20                                  AP51.4
Element: Pov Usr Fld 01

CVV-POV-USR-FLD-02     Alpha 20                                  AP51.4
Element: Pov Usr Fld 02

CVV-POV-USR-FLD-03     Alpha 20                                  AP51.4
Element: Pov Usr Fld 03

CVV-POV-USR-FLD-04     Alpha 20                                  AP51.4
Element: Pov Usr Fld 04

CVV-POV-USR-FLD-05     Alpha 20                                  AP51.4
Element: Pov Usr Fld 05

CVV-MBL-INT-PREFIX     Alpha 6                                   AP51.1  AP51.2
Element: Mbl Int PrefixThis field contains the country code of
                       the mobile phone number.


CVV-MOBILE-NUM         Alpha 15                                  AP51.1  AP51.2
Element: Mobile Num    This field contains the mobile phone
                       number.


CVV-MOBILE-EXT         Alpha 5                                   AP51.1  AP51.2
Element: Mobile Ext    This field contains the mobile phone
                       extension number.


CVV-PAY-IMM-FLAG       Alpha 1                                   AP51.1  AP51.2
Element: All Flag

CVV-DIVERSE-CODE       Alpha 5                                   AP51.1  AP51.2
Element: Diverse Code  Diversity Code for Account Payable
                       Vendors


CVV-INTM-BANK-ENT      Alpha 15                                  AP58.1
Element: Bank Entity   Type the intermediary bank
                       identification used to deposit
                       electronic payments for the vendor.


CVV-INTM-BANK-ACCT     Alpha 35                                  AP58.1
Element: Bank Acct Nbr Type the intermediary bank account
                       number used to deposit electronic
                       payments for the vendor.


CVV-INTM-BANK-IDNT     Alpha 1                                   AP58.1
Element: Intm Bank IdntThis field indicate if the account
                       number is an IBANK number that requires
                       an account validation check.

                       Y = Yes
                       N = No or Blank

CVV-INTM-BANK-CURR     Alpha 5                                   AP58.1
Element: Currency Code This field contains the intermediary
                       bank currency code.


CVV-INTM-PRENOT        Alpha 1                                   AP58.1
Element: All Flag      If you create Intermediary ACH payments
                       for the vendor, select the
                       prenotification status.  Indicates the
                       status of the electronic payment between
                       the vendor and the processing bank.

                       A = Accepted
                       N = Not Prenotified
                       P = Prenotified

CVV-INTM-SWIFT-ID      Alpha 12                                  AP58.1
Element: Patient Id    Use SWIFT Payment Options (AP10.8) to
                       define SWIFT payment options if you
                       create Intermediary SWIFT payments for
                       the vendor.

CVV-INTM-PMT-CAT       Alpha 6                                   AP58.1
Element: Pmt Cat Code  Select the Intermediary SWIFT payment
                       category.

CVV-INTM-NORM-EXP      Alpha 1                                   AP58.1
Element: Charge Code   Indicates whether the SWIFT payment is a
                       normal or express payment.
                       N = Normal
                       E = Express
                       " " = Not defined for the vendor

CVV-INTM-PMT-FORM      Alpha 2                                   AP58.1
Element: Pmt Form      Indicates how the Intermediary SWIFT
                       payment is made.

CVV-INTM-CHRG-CD       Alpha 1                                   AP58.1
Element: Charge Code   Indicates who pays service charges or
                       fees associated with a Intermediary
                       SWIFT payment.

CVV-INTM-RIBKEY        Numeric 2
Element: Ribkey

CVV-INTM-CRS-IDENT     Alpha 1                                   AP58.1
Element: Intm Crs IdentS = SWIFT
                       R = Routing Number

CVV-FLOAT-DAYS         Numeric 3                                 AP51.1
Element: Float Days    THis is a number of days to add to best
                       terms calculation if the vendor will
                       allow a specific number of days for
                       payment to reach them and still receive
                       the discount.

CVV-VN-BLD-SOC-REF     Alpha 18
Element: Build Soc Ref This field holds an individual account
                       number reference for the Building
                       Society

CVV-VN-BLD-ACCT-NM     Alpha 18
Element: Account Name

CVV-IN-BLD-SOC-REF     Alpha 18
Element: Build Soc Ref This field holds an individual account
                       number reference for the Building
                       Society

CVV-IN-BLD-ACCT-NM     Alpha 18
Element: Account Name

CVV-MTCH-PREPAY-FL     Alpha 1
Element: Mtch Prepay FlFlag notes that the invoice will be
                       prepaid.  This is for match invoices.

CVV-MTCH-PREPAY-MT     Numeric 1
Element: Mtch Prepay MtFlag denotes the method of match
                       prepayment.
                       0 = No
                       1 = Prepay from Invoice
                       2 = Eligible for Prepayment

CVV-BUILD-SOC-REF      Alpha 18                                  AP58.1
Element: Build Soc Ref This field holds an individual account
                       number reference for the Building
                       Society


CVV-BUILD-ACCT-NM      Alpha 18                                  AP58.1
Element: Account Name

CVV-MIN-ORD-WEIGHT     Signed 9.3                                AP51.4
Element: Min Ord Weight

CVV-UNLOADING-PORT     Alpha 5                                   AP51.4
Element: Unloading PortThe prot where the goods are unloaded
                       if required.  Must be defined in IN04.1
                       (Port Maintenance)


CVV-LOADING-PORT       Alpha 5                                   AP51.4
Element: Loading Port  The port where the goods are loaded, if
                       required.  The port code must be defined
                       in IN04.1 (Port Maintenance)


CVV-WORKFLOW-GROUP     Alpha 20                                  AP51.1
Element: Workflow Group

CVV-RULE-GROUP         Alpha 10                                  AP51.1
Element: Rule Group

CVV-CROSS-IDENT        Alpha 1                                   AP58.1
Element: Cross Ident   This field is used to distinguish
                       between SWIFT ID numbers and Routing
                       numbers.
                       S = SWIFT
                       R = Routing Number

CVV-GIRO-NUMBER        Alpha 15                                  AP58.1
Element: Giro Number   This field is the Bankgiro or Postgiro
                       account number


CVV-CR-CARD-NUMBER     Alpha 16                                  AP58.1
Element: Cr Card NumberThis field contains the credit card
                       number.


CVV-BANK-INSTRUCT1     Alpha 35                                  AP58.1
Element: Bank Instruct1This field contains bank instructions.

CVV-BANK-INSTRUCT2     Alpha 35                                  AP58.1
Element: Bank Instruct2This field contains bank instructions.

CVV-BANK-INSTRUCT3     Alpha 35                                  AP58.1
Element: Bank Instruct3This field contains bank instructions.

CVV-BANK-INSTRUCT4     Alpha 35                                  AP58.1
Element: Bank Instruct4This field contains bank instructions.

CVV-LOC-ID-PRT         Numeric 1                                 AP51.4  AP51.5
Element: Loc Id Prt

CVV-PUNCHOUT-CHG-F     Numeric 1                                 AP51.4  AP51.5
Element: Punchout Chg F

CVV-EMAIL-ADDRESS      Alpha 60  (Lower Case)                    AP51.4  AP51.5
Element: Email Address e-mail address.

CVV-REORDER-SUN-FL     Numeric 1                                 AP51.4  AP51.5
Element: Reorder Mon Fl

CVV-REORDER-MON-FL     Numeric 1                                 AP51.4  AP51.5
Element: Reorder Mon Fl

CVV-REORDER-TUE-FL     Numeric 1                                 AP51.4  AP51.5
Element: Reorder Mon Fl

CVV-REORDER-WED-FL     Numeric 1                                 AP51.4  AP51.5
Element: Reorder Mon Fl

CVV-REORDER-THU-FL     Numeric 1                                 AP51.4  AP51.5
Element: Reorder Mon Fl

CVV-REORDER-FRI-FL     Numeric 1                                 AP51.4  AP51.5
Element: Reorder Mon Fl

CVV-REORDER-SAT-FL     Numeric 1                                 AP51.4  AP51.5
Element: Reorder Mon Fl

CVV-DIVERSE-CODE5      Alpha 5
Element: Diverse Code  Diversity Code for Account Payable
                       Vendors

CVV-P-CARD-FLAG        Numeric 1                                 AP51.1
Element: Flag Num      0 = No
                       1 = Yes

CVV-PCARD-NBR          Alpha 16                                  AP51.1
Element: Pcard Nbr

CVV-VAL-DIV-DATE       Alpha 1                                   AP51.1
Element: All Flag      Determines on invoice entry if the
                       invoice date is within the certification
                       dates for the diversity code setup for
                       the vendor on AP14.4

                         APCVENMAST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVVSET1   VENDOR-GROUP                                           AP51.1  AP51.2
          VENDOR                                                 AP51.4  AP51.5
          OLD-VENDOR                                             AP51.8  AP510
          LOCATION-CODE                                          AP58.1

                         APCVENMAST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcontacts     APCCONTACT   Delete Cascades

                            CVV-VENDOR-GROUP     -> CVH-VENDOR-GROUP
                            CVV-VENDOR           -> CVH-VENDOR
                            CVV-LOCATION-CODE    -> CVH-LOCATION-CODE
                                                    CVH-RESP-CODE
                                                    CVH-CONTACT-LVL

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