Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             APVENMAST FILE

                                 Vendor

The Vendor file contains accounts payable vendor records, including one-time
vendors defined during invoice entry. If the vendor has default codes defined
at a company level, the vendor record has one or more associated records in
the Vendor Company Codes file.

REFERENCED BY

AM18.1    AP00.1    AP00.3    AP12.1    AP130     AP135
AP141     AP145     AP146     AP150     AP151     AP155
AP156     AP161     AP166     AP175     AP176     AP180
AP181     AP185     AP190     AP191     AP193     AP195
AP197     AP200     AP210     AP212     AP213     AP220
AP230     AP236     AP240     AP245     AP250     AP251
AP252     AP260     AP266     AP270     AP275     AP28.1
AP28.2    AP282     AP284     AP30.1    AP30.2    AP30.3
AP30.4    AP32.1    AP32.2    AP35.1    AP41.1    AP45.1
AP51.2    AP51.3    AP52.7    AP54.1    AP55.1    AP55.2
AP56.1    AP56.2    AP80.1    AP90.1    AP90.2    AP90.5
AP90.6    AP90.7    AP91.1    AP91.5    AP91.6    AP92.1
AP92.2    AP92.3    AP92.4    AP93.1    AP93.2    AP93.3
AP93.4    AP95.1    AP95.2    AP95.3    AP96.1    API1.1
API2.1    AR48.1    CB06.2    EE135     EE175     EE20.1
EE20.2    EE20.3    EE20.4    EE220     EE230     EE235
EE275     EE30.1    EE35.1    EE35.2    EE520     EE90.1
EE90.2    GL284     GL285     IC522     IC526     IC527
IC530     IC531     IC81.1    IC840     MA63.1    MA64.1
MA64.4    MA66.1    MA66.2    MA66.3    MA95.1    MA95.2
PO120     PO132     PO16.1    PO16.2    PO204     PO226
PO227     PO231     POAV.1    PR05.1    PR05.3    PR198
PR226     PR247     PR26.1    PR47.1    PR514     IN120
IN20.1    TX100     AP02.3    AP202     MA05.1    MA05.2

UPDATED BY

AP10.3    AP10.7    AP100     AP102     AP110     AP115
AP160     AP170     AP300     AP40.2    AP510     AP520
API3.1    API4.1    TX140

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

VEN-VENDOR-GROUP     Alpha 4                                     AP10.3  AP100
Vendor Group         The vendor group to which the vendor        AP510   AP520
                     belongs. Must be a valid record in the      API3.1  API4.1
                     Vendor Group file.

VEN-VENDOR           Alpha 9  (Right Justified)                  AP10.3  AP100
Vendor               The identification number assigned to       AP510   AP520
                     the vendor.                                 API3.1  API4.1


VEN-VEN-CLASS        Alpha 3                                     AP10.3  AP100
Vendor Class         The vendor class the vendor is assigned     AP510   AP520
                     to. Represents a group of vendors that      API3.1  API4.1
                     share common characteristics within a
                     vendor group. Must be a valid record in
                     the Vendor Class file.


VEN-VENDOR-VNAME     Alpha 30  (Lower Case)                      AP10.3  AP100
Vendor Name          The vendor name or description.             AP166   AP510
                                                                 AP520   API3.1
                                                                 API4.1

VEN-VENDOR-SNAME     Alpha 30                                    AP10.3  AP100
Search Name          The search name for the vendor.             AP510   AP520
                                                                 API3.1  API4.1

VEN-VENDOR-CONTCT    Alpha 30                                    AP100   AP510
Contact              The name of the main contact for the        API3.1  API4.1
                     vendor.

VEN-REMIT-TO-CODE    Alpha 4                                     AP100   AP510
Normal Remit-To      The normal remittance location for the      API3.1  API4.1
Location             vendor, if defined. Must be a valid
                     record in the Vendor Location file. If
                     present, the address defined for the
                     location overrides the vendor address on
                     vendor payments when invoices are added.

VEN-PURCH-FR-LOC     Alpha 4                                     AP100   AP510
Normal               The normal purchasing location for the      API3.1  API4.1
Purchase-From Locatiovendor, if defined. Must be a valid
                     record in the Vendor Location file. If
                     present, the address defined for the
                     location overrides the vendor address
                     for storing vendor purchase activity
                     balances.

VEN-PAY-VENDOR       Alpha 9  (Right Justified)                  AP100   AP510
Pay Vendor           The pay vendor for the vendor, if           API3.1  API4.1
                     applicable. Used to send invoice
                     payments to another vendor within the
                     same vendor group. If present, the pay
                     vendor relationship overrides the normal
                     remit-to information for the vendor,
                     including remit-to name and address,
                     cash code, and payment code. Must be a
                     valid record in the Vendor file.

                     Although payments are remitted to the
                     pay vendor, the invoiced vendor
                     accumulates the payment balance. If more
                     than one vendor shares the same pay
                     vendor, the system creates a single
                     payment for the pay vendor and lists
                     individual invoiced vendors and invoice
                     numbers that are included in the payment
                     on the remittance.

VEN-VENDOR-STATUS    Alpha 1                                     AP10.3  AP100
Status               The vendor status. Invoices cannot be       AP115   AP510
                     entered for a vendor with an Inactive       AP520   API3.1
                     status. Valid values are:                   API4.1

                     A = Active.
                     I = Inactive.

VEN-VEN-PRIORITY     Numeric 2                                   AP10.3  AP100
Priority             The payment priority assigned to the        AP110   AP510
                     vendor. Valid values are 1 (highest         AP520   API3.1
                     priority) through 99 (lowest priority).     API4.1

VEN-PHONE-PREFIX     Alpha 6                                     AP100   AP510
Telephone Country    The country code for the vendor             API3.1  API4.1
Code                 telephone number.

VEN-PHONE-NUM        Alpha 15                                    AP100   AP510
Telephone Number     The telephone number for the vendor.        API3.1  API4.1

VEN-PHONE-EXT        Alpha 5                                     AP100   AP510
Telephone Extension  The telephone extension number for the      API3.1  API4.1
                     vendor.

VEN-FAX-PREFIX       Alpha 6                                     AP100   AP510
Fax Country Code     The country code for the fax machine        API3.1  API4.1
                     telephone number.

VEN-FAX-NUM          Alpha 15                                    AP100   AP510
Fax Number           The fax machine telephone number.           API3.1  API4.1

VEN-FAX-EXT          Alpha 5                                     AP100   AP510
Fax Extension        The fax machine telephone number            API3.1  API4.1
                     extension.

VEN-TELEX-NUM        Alpha 15                                    AP100   AP510
Telex                The telex number for the vendor.            API3.1  API4.1

VEN-TERM-CODE        Alpha 5                                     AP110   AP510
Payment Terms        The payment terms code assigned to the      API3.1  API4.1
                     vendor. Used to automatically calculate
                     invoice due date and discount
                     information for the vendor's invoices.
                     Must be a valid record in the Terms Code
                     file.

VEN-INV-CURRENCY     Alpha 5                                     AP100   AP110
Invoice Currency     The currency used to add invoices for       AP510   API3.1
                     the vendor. The currency code defaults      API4.1
                     on the vendor's invoices during 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.

VEN-BAL-CURRENCY     Alpha 5                                     AP100   AP510
Vendor Balance       The currency used to store vendor           API3.1  API4.1
                     balance information. Must be a valid
                     record in the Currency Code file. If
                     left blank, the company base currency is
                     used.

VEN-CURR-RECALC      Alpha 1                                     AP100   AP510
Currency             If the Invoice Currency is different        API3.1  API4.1
Recalculation        from the company base currency, this
                     field indicates whether the system will
                     recalculate the invoice currency when
                     the invoice is paid to account for
                     exchange rate fluctuations. If Yes is
                     selected in this field, 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:

                     N = No.
                     Y = Yes.

VEN-SEP-CHK-FLAG     Alpha 1                                     AP10.3  AP100
Separate Payment     Indicates whether to create a separate      AP510   AP520
                     payment for each invoice entered for the    API3.1  API4.1
                     vendor. Valid values are:

                     N = No.
                     Y = Yes.

VEN-TAX-ID           Alpha 20                                    AP10.3  AP100
Tax ID               The tax identification number for the       AP510   AP520
                     vendor. Used for reporting reportable       API3.1  API4.1
                     vendor income.

VEN-TAX-EXEMPT-CD    Alpha 1                                     API3.1  API4.1
Tax Exempt Code

VEN-TAX-CODE         Alpha 10                                    AP100   AP110
Tax Code             The tax code assigned to the vendor.        AP510   API3.1
                     Used to automatically calculate invoice     API4.1  TX140
                     tax information. Must be a valid record
                     in the Tax Code file. If left blank, the
                     tax code assigned to the vendor class
                     defaults.

VEN-HOLD-FLAG        Alpha 1                                     AP100   AP170
Hold Code            This field enables this entire lot to       AP40.2  AP510
                     be put on hold, not allowing any issues     API3.1  API4.1
                     or transfers to be made for this lot.
                     Y = Yes
                     " "

VEN-DIST-CODE        Alpha 9                                     AP100   AP110
Distribution Code    The distribution code assigned to the       AP510   API3.1
                     vendor. Used to automatically create        API4.1
                     distribution lines for the 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.

VEN-ACCR-CODE        Alpha 4                                     AP100   AP110
Invoice Accrual Code The invoice accrual code assigned to        AP510   API3.1
                     the vendor. Used to default a general       API4.1
                     ledger accrual account to the vendor's
                     invoices during entry. Must be a valid
                     record in the Invoice Accrual Code file.
                     If left blank, the invoice accrual code
                     assigned to the vendor class, if
                     assigned, or the company defaults.

VEN-BANK-INST-CODE   Alpha 3                                     AP100   AP110
Payment Code         The payment code assigned to the            AP510   API3.1
                     vendor. Represents a type of cash           API4.1
                     payment, such as a check or payment
                     tape, or a bill of exchange payment.
                     Must be a valid cash or bill of exchange
                     payment transaction code record in the
                     Bank Transaction Code file.

VEN-CASH-CODE        Alpha 4                                     AP100   AP110
Cash Code            The cash code assigned to the vendor.       AP151   AP156
                     Represents a bank account. Must be a        AP180   AP28.1
                     valid record in the Cash Code file. If      AP28.2  AP510
                     left blank, the cash code assigned to       AP56.1  AP56.2
                     the vendor class, if assigned, defaults,    AP80.1  API3.1
                     or the vendor uses the cash code            API4.1
                     assigned to the company or the pay
                     group.

VEN-BANK-ENTITY      Alpha 15                                    AP100   AP510
Bank                 The bank identification used to deposit     API3.1  API4.1
                     electronic payments for the vendor. This
                     field is required for ACH or BACS
                     payment types.

VEN-VBANK-ACCT-NO    Alpha 17                                    AP100   AP510
Vendor Bank Account  The bank account number used to deposit     API3.1  API4.1
Number               electronic payments for the vendor. This
                     field is required for ACH or BACS
                     payment types.

VEN-VBANK-ACCT-TP    Alpha 1                                     AP100   AP510
Vendor Bank Account  Indicates the type of bank account used     API3.1  API4.1
Type                 to deposit electronic payments for the
                     vendor. Valid values are:

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

VEN-INCOME-CODE      Alpha 4                                     AP10.3  AP100
Income Code          The income code assigned to the vendor.     AP110   AP510
                     Used to track reportable income for the     AP520   API3.1
                     vendor. Must be a valid record in the       API4.1
                     Income Code file.

VEN-INCOME-WH-FLG    Alpha 1                                     AP10.3  AP100
Income Withholding   Indicates whether invoices for the          AP510   AP520
                     vendor are subject to reportable income     API3.1  API4.1
                     withholding. Valid values are:

                     N = No.
                     Y = Yes.

VEN-EDI-NBR          Alpha 15                                    AP100   AP510
EDI Number           The vendor's electronic data                API3.1  API4.1
                     interchange (EDI) number. Used for
                     reference.

VEN-ACH-PRENOT       Alpha 1                                     AP100   AP110
ACH Prenotification  Used in conjunction with ACH payments       AP160   AP510
Status               created for the vendor. Indicates the       API3.1  API4.1
                     status of the electronic payment between
                     the vendor and the processing bank.
                     Valid values are:

                     N = Notified.  AP160 (Payment Tape
                     Creation) automatically changes the
                     status from Prenotified to Notified to
                     indicate that the processing bank has
                     been notified but has not yet accepted
                     the electronic payment tape.

                     P = Prenotified. Select this status
                     when first entering ACH information to
                     prenotify the processing bank.

                     A = Accepted. Change the status to
                     Accepted once the processing bank
                     accepts the electronic payment tape.

                     Blank = ACH payment type not selected.

VEN-MAX-INV-AMT      Signed 15.2                                 AP100   AP510
Maximum Invoice      The maximum single invoice amount that      API3.1  API4.1
Amount               can be entered for the vendor.

VEN-CREATE-DATE      Numeric 8  (yyyymmdd)                       AP10.3  AP100
Creation Date        The date the vendor record was created      AP510   AP520
                     in the Lawson Accounts Payable system.      API3.1  API4.1

VEN-ORIGIN-DATE      Numeric 8  (yyyymmdd)                       AP10.3  AP100
Origin Date          The origin date for the vendor. Can be      AP510   AP520
                     used record additional information, such    API3.1  API4.1
                     as the date the vendor relationship
                     began. If left blank, the system date
                     defaults.

VEN-OPERATOR         Alpha 10                                    AP10.3  AP100
Operator Code        The operator associated with                AP510   API3.1
                     maintaining the vendor record.              API4.1

VEN-USER-NAME-01     Alpha 20                                    AP100   AP510
User Defined Field 1 The value of the information being          API3.1  API4.1
                     tracked for the vendor in the first
                     vendor group user field.

VEN-USER-NAME-02     Alpha 20                                    AP100   AP510
User Defined Field 2 The value of the information being          API3.1  API4.1
                     tracked for the vendor in the second
                     vendor group user field.

VEN-USER-NAME-03     Alpha 20                                    AP100   AP510
User Defined Field 3 The value of the information being          API3.1  API4.1
                     tracked for the vendor in the third
                     vendor group user field.

VEN-USER-NAME-04     Alpha 20                                    AP100   AP510
User Defined Field 4 The value of the information being          API3.1  API4.1
                     tracked for the vendor in the fourth
                     vendor group user field.

VEN-USER-NAME-05     Alpha 20                                    AP100   AP510
User Defined Field 5 The value of the information being          API3.1  API4.1
                     tracked for the vendor in the fifth
                     vendor group user field.

VEN-USER-NAME-06     Alpha 15                                    AP100   AP510
User Defined Field 6 The value of the information being          API3.1  API4.1
                     tracked for the vendor in the sixth
                     vendor group user field.

VEN-CUST-GROUP       Alpha 5                                     AP100   API3.1
Customer Group       If the accounts payable vendor is also      API4.1
                     a customer in the Lawson Accounts
                     Receivable system, this field can be
                     used to identify the customer group
                     associated with the corresponding
                     accounts receivable customer. Used to
                     update the accounts receivable customer
                     record.

VEN-CUSTOMER         Alpha 9  (Right Justified)                  AP100   API3.1
Customer             If the accounts payable vendor is also      API4.1
                     a customer in the Lawson Accounts
                     Receivable system, this field can be
                     used to identify the corresponding
                     accounts receivable customer number.
                     Used to update the accounts receivable
                     customer record.

VEN-LEGAL-NAME       Alpha 80  (Lower Case)                      AP10.3  AP100
Legal Name           The legal name for the vendor. Used for     AP510   AP520
                     reporting reportable vendor income. If      API3.1  API4.1
                     left blank, the Vendor Name defaults.

VEN-PRIME-RATE       Signed 7.5                                  AP100   AP510
Anticipation         The percentage used to calculate            API3.1  API4.1
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
                     the 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.

                     Anticipation discount terms codes are
                     defined in the Lawson Terms system.

VEN-INVOICE-GROUP    Alpha 4                                     AP100   AP510
Invoice Group        A user-defined invoice group assigned       API3.1  API4.1
                     to the vendor. This value defaults on
                     invoices entered for the vendor. Can be
                     used to select invoices for payment in
                     AP150 (Cash Requirements).

VEN-DISCOUNT-CODE    Alpha 10                                    AP100   AP110
Discount Code        The discount code assigned to the           AP510   API3.1
                     vendor. Used to default a general ledger    API4.1
                     discount account on the vendor's
                     invoices during entry. Must be a valid
                     record in the Discount Code file.

VEN-ERS-CAPABLE      Alpha 1                                     AP100   AP510
ERS Capable          Indicates whether the vendor location       API3.1  API4.1
                     has the capability to process ERS. Valid
                     values are:

                     N = No.
                     Y = Yes.

VEN-INVC-REF-TYPE    Alpha 2                                     AP100   AP510
ERS Invoice          Indicates the type of number the vendor     API3.1  API4.1
Reference            is providing to reference the invoice.
                     Valid values are:

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

VEN-EDI-AUTO-REL     Alpha 1                                     AP100   AP510
EDI Invoice Auto     Indicates whether the company               API3.1  API4.1
Release              automatically releases EDI invoices.
                     Valid values are:

                     N = No.
                     Y = Yes.

VEN-AUTH-CODE        Alpha 3                                     AP100   AP110
Authority Code       The authority code assigned to the          AP510   API3.1
                     vendor, if assigned. Represents a person    API4.1
                     or department responsible for approving
                     registered invoices for the vendor. This
                     code defaults on the vendor's invoices
                     during entry. Must be a valid authority
                     code in the Authority Code file.

VEN-APPRVL-EXISTS    Alpha 1                                     AP10.7  AP100
Approval             Indicates whether approval criteria is      API3.1  API4.1
Information Exists   defined for the vendor. If Yes, one or
                     more associated approval records exist
                     for the vendor in the Invoice Approval
                     file. Valid values are:

                     N = No.
                     Y = Yes.

VEN-ACTIVITY         Alpha 15                                    AP100   AP110
Activity             The activity assigned to the vendor, if     AP510   API3.1
                     assigned. Activities are the tasks that     API4.1
                     make up an activity group. Activities
                     identify work being done, such as work
                     orders, phases, products, and so on.
                     Must be a valid record in the Activity
                     file.

VEN-ACCT-CATEGORY    Alpha 5                                     AP100   AP110
Account Category     The account category assigned to the        AP510   API3.1
                     vendor. Account categories are the          API4.1
                     Activity Management accounts by which
                     activity transactions are grouped for
                     budgeting and reporting. Must be a valid
                     record in the Activity Account Category
                     file.

VEN-CHARGE-CODE      Alpha 1                                     AP100   AP510
Charge Code          Indicates who pays service charges or       API3.1  API4.1
                     fees associated with a SWIFT payment.
                     Valid values are:

                     I = Issuer.
                     R = Receiver.
                     Blank = Not defined for the vendor.

VEN-PMT-CAT-CODE     Alpha 1                                     AP100   AP510
Payment Category     Indicates the payment category of the       API3.1  API4.1
Code                 SWIFT payment. Valid values are:

                     G = Goods.
                     T = Transit Trade.
                     S = Service and Capital.
                     X = Transfer.
                     O = Other.
                     Blank = Not defined for the vendor.

VEN-NORM-EXP-CODE    Alpha 1                                     AP100   AP510
Normal or Express    Indicates whether the SWIFT payment is      API3.1  API4.1
Code                 a normal or express payment. Valid
                     values are:

                     N = Normal.
                     E = Express.
                     Blank = Not defined for the vendor.

VEN-PMT-FORM         Alpha 1                                     AP100   AP510
Payment Form         Indicates how the SWIFT payment is          API3.1  API4.1
                     made. Valid values are:

                     C = Check.
                     B = Foreign Bank.
                     Blank = Not defined for the vendor.
                     F = Foreign Bank

VEN-SWIFT-ID         Alpha 12                                    AP100   AP510
Swift ID             The SWIFT identification number             API3.1  API4.1
                     assigned to the vendor.

VEN-PROC-GRP         Alpha 4  (Lower Case)                       AP100   AP102
Process Group        A process group is an identifier used       AP510   API3.1
                     for separating vendors into different       API4.1
                     groups to enable concurrent processing
                     within the cash payment cycle.

VEN-MATCH-TABLE      Alpha 10                                    AP100   AP110
Match Table          A code representing a match table. A        AP510   API3.1
                     match table contains the processing         API4.1
                     rules that will be used during matching.

VEN-DISC-CALC-DATE   Alpha 1                                     AP100   AP510
Discount             Indicates which date to use when            API3.1  API4.1
Calculation Date     calculating discounts.

                     You can use the invoice date, receipt
                     date, or the date the invoice was
                     received.
                     " "
                     D = Receipt of Invoice Date
                     I = Invoice Date
                     R = Receipt Date

VEN-CREATE-POD-FL    Alpha 1                                     AP100   AP510
Proof of Delivery    Indicates whether to create a proof of      API3.1  API4.1
Created              delivery.

                     Valid values are:

                     N = No
                     Y = Yes
                     " "

VEN-HANDLING-CODE    Alpha 4                                     AP100   AP110
Invoice Handling     Invoice handling code. Determines the       AP510   API3.1
Code                 processing rules that will be used          API4.1
                     during matching.

VEN-ENCLOSURE        Alpha 1                                     AP100   AP510
Enclosure            Indicates whether the invoice requires      API3.1  API4.1
                     an enclosure with its payment.
                     Y = Yes
                     N = No
                     " "

VEN-REQ-MATCH-REF    Alpha 1                                     AP100   AP510
Match Reference      Indicates whether a match reference         API3.1  API4.1
Required             number is required for invoices for this
                     vendor.
                     Y = Yes
                     N = No

VEN-POOL-OPTION      Numeric 1                                   AP100   AP510
Pool Option          1 = Company Vendor                          API3.1  API4.1
                     2 = Company Vendor PO
                     3 = Company Vendor PO ShipTo
                     0 = MA Company Default

VEN-HOLD-INSP-FLAG   Alpha 1                                     AP100   AP510
Hold Insp Flag       If set to "Y", this flag will keep          API3.1  API4.1
                     receiving lines requiring inspection
                     from being matched until they have been
                     inspected.
                     Y = Yes
                     N = No
                     " " = Use Company

VEN-WRITE-OFF-AMT    Signed 15.2                                 AP100   AP510
Write Off Amt                                                    API3.1  API4.1

VEN-VEN-CLAIM-TYPE   Alpha 2                                     AP100   AP510
Vendor Claim Type    CB = Chargeback                             API3.1  API4.1
                     CM = Credit Memo
                     N = None

VEN-CLAIM-HOLD-CD    Alpha 4                                     AP100   AP510
Claim Hold Cd                                                    API3.1  API4.1

VEN-CB-HOLD-CODE     Alpha 4                                     AP100   AP510
Vendor Claims                                                    API3.1  API4.1
Chargeback Hold

VEN-CB-MINIMUM-AMT   Signed 15.2                                 AP100   AP510
Minimum Claim Amount                                             API3.1  API4.1

VEN-REPLACE-GOODS    Alpha 1                                     AP100   AP510
Replace Goods        Y = Yes                                     API3.1  API4.1
                     N = No

VEN-SHIP-OR-HOLD     Alpha 1                                     AP100   AP510
Ship or Hold Goods   S = Ship                                    API3.1  API4.1
                     H = Hold

VEN-ERS-HANDLING     Alpha 4                                     AP100   AP510
Ers Handling                                                     API3.1  API4.1

VEN-E-MAIL-ADDRESS   Alpha 60  (Lower Case)                      AP100   AP510
E Mail Address                                                   API3.1  API4.1

VEN-URL-ADDR         Alpha 60  (Lower Case)                      AP100   AP510
Url Addr                                                         API3.1  API4.1

VEN-VEND-ACCT        Alpha 30                                    AP100   AP510
Vend Acct            The customer number the vendor has          API3.1  API4.1
                     assigned to you.

VEN-LANGUAGE-CODE    Alpha 10                                    AP100   AP510
Language Code        Language Code (LOCALE).                     API3.1  API4.1

VEN-TAX-USAGE-CD     Alpha 10                                    AP100   AP510
Tax Usage Cd         The tax usage coe for the vendor.  This     API3.1  API4.1
                     filed is required if the AP Company
                     inidcates that VAT reporting required.

VEN-VAT-REG-CTRY     Alpha 2                                     AP10.3  AP100
Vat Reg Ctry         The country component of the VAT            AP510   API3.1
                     Registration Number. This field,            API4.1
                     together with the Registration Number
                     for the company on the tax transaction.


VEN-VAT-REG-NBR      Alpha 12                                    AP10.3  AP100
Vat Reg Nbr          The number component of the VAT             AP510   API3.1
                     Registration Number. This field together    API4.1
                     with the Registration Country field make
                     up the VAT Registration Number.

VEN-LOC-INDICATOR    Derived
Locations Exist      When selecting a vendor from a list of
                     available vendors, an asterisk (*)
                     displays if alternate locations exist
                     for a vendor.

VEN-SHORT-VNAME      Derived
Short Vendor Name    A short name for the vendor. Used for
                     display purposes.

VEN-VCOMMENT-EXIST   Derived
Vendor Comments      When selecting a vendor from a list of
Exist                available vendors, an asterisk (*)
                     displays if comments exist for a vendor.

VEN-VDR-ADDR1        Derived
Vendor Address Line  Vendor address line 1.
1

VEN-VDR-ADDR2        Derived
Vendor Address Line  Vendor address line 2.
2

VEN-VDR-ADDR3        Derived
Vendor Address Line  Vendor address line 3.
3

VEN-VDR-ADDR4        Derived
Vendor Address Line  Vendor address line 4.
4

VEN-VDR-CITY-ADDR5   Derived
Vendor City or       Vendor city or address line 5.
Address Line 5

VEN-VDR-STATE        Derived
Vendor State or      Vendor state or province.
Province

VEN-VDR-POSTAL       Derived
Vendor Postal Code   Vendor postal code.

VEN-VDR-COUNTY       Derived
Vendor County        Vendor county.

VEN-VDR-COUNTRY      Derived
Vendor Country       Vendor country.

VEN-VAT-NBR          Derived
Vat Nbr              The concatenation of the VAT-REG-CTRY
                     and VAT-REG-NBR fields, used as VAT
                     reporting ID.


                         APVENMAST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VENSET1   VENDOR-GROUP  This index is used to access and         AM18.1  AP00.1
          VENDOR        validate vendor records for a specific   AP10.1  AP10.2
                        vendor group.                            AP10.3  AP10.5
                                                                 AP10.6  AP10.7
                                                                 AP10.9  AP100
                                                                 AP102   AP110
                                                                 AP115   AP12.1
                                                                 AP130   AP135
                                                                 AP141   AP145
                                                                 AP146   AP150
                                                                 AP151   AP155
                                                                 AP156   AP160
                                                                 AP161   AP166
                                                                 AP170   AP175
                                                                 AP176   AP180
                                                                 ...

VENSET10  VENDOR-GROUP  KeyChange                                AP130
          CREATE-POD-FL
          VENDOR

VENSET2   VENDOR-GROUP  This index is used to access vendor      AP00.3  AP100
          VEN-CLASS     records within a specific vendor class   AP102   AP110
          VENDOR        for a vendor group.                      AP251   AP252
                        KeyChange                                AP300   PO120
                                                                 POAV.1

VENSET3   VENDOR-GROUP  This index is used to access vendor
          USER-NAME-01  records by using the first vendor group
          VENDOR-SNAME  user-defined field.
          VENDOR        KeyChange

VENSET4   VENDOR-GROUP  This index is used to access vendor
          VEN-CLASS     records within a specific vendor class
          VENDOR-SNAME  in search name sequence.
          VENDOR        KeyChange

VENSET5   VENDOR-GROUP  This index is used to access vendor      AP10.1  AP200
          VENDOR-SNAME  records in search name sequence.         API3.1  API4.1
          VENDOR        KeyChange

VENSET6   PROC-GRP      This index is used to access vendors     AP02.3  AP202
          VENDOR-GROUP  not on hold or vendors assigned a
          VENDOR        specific hold code.
                        KeyChange

VENSET7   VENDOR-GROUP  This index is used to access and         AM18.1  AP520
          EDI-NBR       validate vendor records by EDI number.   API3.1  API4.1
          VENDOR        KeyChange                                IC530   IC840
                                                                 MA63.1  PR05.1
                                                                 PR05.3  PR198
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 PR514

VENSET8   VENDOR-GROUP  This index is used to access vendor      AP160
          VENDOR        records set up for ACH processing that
                        have not been prenotified.
                        Subset
                        Where ACH-PRENOT = "N"
                        Or    ACH-PRENOT = "P"

VENSET9   HANDLING-CODE This index is used to display vendors    MA05.1  MA05.2
          VENDOR-GROUP  assisgned a handling code.
          VENDOR        KeyChange

                         APVENMAST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Address1       APVENADDR    Required

                            VEN-VENDOR-GROUP     -> VDR-VENDOR-GROUP
                            VEN-VENDOR           -> VDR-VENDOR
                            Spaces               -> VDR-LOCATION-CODE
                            "Y"                  -> VDR-CUR-ADDR

Approcgrp      APPROCGRP    Not Required

                            VEN-PROC-GRP         -> APQ-PROC-GRP

Apvengroup     APVENGROUP   Required

                            VEN-VENDOR-GROUP     -> VGP-VENDOR-GROUP

Procuregrp     PROCUREGRP   Required

                            VEN-VENDOR-GROUP     -> PCG-VENDOR-GROUP

                         APVENMAST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapihist      APAPIHIST

                            VEN-VENDOR-GROUP     -> AH1-VENDOR-GROUP
                            VEN-VENDOR           -> AH1-VENDOR
                                                    AH1-INVOICE
                                                    AH1-SUFFIX
                                                    AH1-CANCEL-SEQ
                                                    AH1-COMPANY

Apaudit        APAUDIT

                            VEN-VENDOR-GROUP     -> APA-VENDOR-GROUP
                            Zeroes               -> APA-COMPANY
                            Spaces               -> APA-PROC-LEVEL
                            VEN-VENDOR           -> APA-VENDOR
                            Spaces               -> APA-INVOICE
                            Zeroes               -> APA-SUFFIX
                            Zeroes               -> APA-CANCEL-SEQ
                                                    APA-SEQ-NBR
                                                    APA-TRANS-DATE
                                                    APA-TRANS-TIME

Apcomments     APCOMMENTS   Delete Cascades

                            "V"                  -> APC-REC-TYPE
                            VEN-VENDOR-GROUP     -> APC-VENDOR-GROUP
                            VEN-VENDOR           -> APC-VENDOR
                                                    APC-LOCATION-CODE
                                                    APC-COMPANY
                                                    APC-SEQ-NBR

Apcpyvnd       APCPYVND

                            VEN-VENDOR-GROUP     -> APX-VENDOR-GROUP
                            VEN-VENDOR           -> APX-VENDOR
                            Spaces               -> APX-LOCATION-CODE
                                                    APX-COMPANY

Aphldinv       APHLDINV     Delete Cascades
                            Valid When (VEN-HOLD-FLAG = "Y" )

                            "V"                  -> HLI-REC-TYPE
                            VEN-VENDOR-GROUP     -> HLI-VENDOR-GROUP
                            Zeroes               -> HLI-COMPANY
                            VEN-VENDOR           -> HLI-VENDOR
                                                    HLI-INVOICE
                                                    HLI-SUFFIX
                                                    HLI-CANCEL-SEQ
                                                    HLI-SEQ-NBR
                                                    HLI-VOID-SEQ
                                                    HLI-HLD-CODE

Apinvoice      APINVOICE

                            VEN-VENDOR-GROUP     -> API-VENDOR-GROUP
                            VEN-VENDOR           -> API-VENDOR
                                                    API-INVOICE
                                                    API-SUFFIX
                                                    API-CANCEL-SEQ
                                                    API-COMPANY

Apvcomments    APCOMMENTS

                            "V"                  -> APC-REC-TYPE
                            VEN-VENDOR-GROUP     -> APC-VENDOR-GROUP
                            VEN-VENDOR           -> APC-VENDOR
                            Spaces               -> APC-LOCATION-CODE
                                                    APC-COMPANY
                                                    APC-SEQ-NBR

Apvenaddr      APVENADDR

                            VEN-VENDOR-GROUP     -> VDR-VENDOR-GROUP
                            VEN-VENDOR           -> VDR-VENDOR
                            Spaces               -> VDR-LOCATION-CODE
                                                    VDR-EFFECTIVE-DATE

Apvenbal       APVENBAL     Delete Cascades

                            VEN-VENDOR-GROUP     -> VBA-VENDOR-GROUP
                            VEN-VENDOR           -> VBA-VENDOR
                                                    VBA-COMPANY
                                                    VBA-LOCATION-CODE

Apvenbalmaster APVENBAL     Delete Cascades

                            VEN-VENDOR-GROUP     -> VBA-VENDOR-GROUP
                            VEN-VENDOR           -> VBA-VENDOR
                            Spaces               -> VBA-LOCATION-CODE
                                                    VBA-COMPANY

Apvendorbal    APVENBAL

                            VEN-VENDOR-GROUP     -> VBA-VENDOR-GROUP
                            VEN-VENDOR           -> VBA-VENDOR
                                                    VBA-LOCATION-CODE
                                                    VBA-COMPANY

Apvenloc       APVENLOC     Delete Cascades

                            VEN-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            VEN-VENDOR           -> VLO-VENDOR
                                                    VLO-LOCATION-CODE

Cbcheck        CBCHECK

                            VEN-VENDOR-GROUP     -> CHK-VENDOR-GROUP
                            VEN-VENDOR           -> CHK-PAID-VENDOR
                                                    CHK-COMPANY
                                                    CHK-CHECK-DATE
                                                    CHK-BANK-INST-CODE
                                                    CHK-CASH-CODE
                                                    CHK-TRANS-IDENT

Povagrmthd     POVAGRMTHD

                            PCG-PROCURE-GROUP    -> PVH-PROCURE-GROUP
                            VEN-VENDOR           -> PVH-VENDOR
                                                    PVH-PURCH-FR-LOC
                                                    PVH-VEN-AGRMT-REF