Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APVENCLASS


                            APVENCLASS FILE

                              Vendor Class

The Vendor Class file contains all vendor class records for a vendor group. A
vendor class is a subgroup of vendors that share common payment or processing
characteristics, such as office supply vendors or employees.

The vendor class "ONE" is automatically created in this file when you define
a vendor group. The system assigns this vendor class to one-time vendors that
are defined during invoice entry.

REFERENCED BY

AC160     AC210     AM115     AM117     AM15.1    AM15.2
AM15.3    AM15.4    AM18.1    AM19.1    AM19.2    AM20.1
AM20.3    AM21.1    AM21.3    AM500     AM51.1    AM551
AM97.1    AP03.3    AP102     AP110     AP115     AP125
AP126     AP130     AP131     AP135     AP150     AP151
AP156     AP180     AP197     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.6    AP20.7    AP20.8    AP200
AP21.1    AP210     AP211     AP220     AP23.1    AP230
AP237     AP245     AP25.1    AP25.2    AP250     AP251
AP252     AP26.1    AP27.1    AP270     AP28.1    AP28.2
AP290     AP30.1    AP30.2    AP30.3    AP30.4    AP305
AP32.1    AP35.1    AP510     AP56.1    AP56.2    AP80.1
AP810     AP90.1    AP91.1    API1.1    API2.1    API3.1
API4.1    AR01.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    EE135     EE20.1    EE20.2    EE20.4
EE35.1    EE35.2    EE520     ET700     MX123     MX500
MA180     MA279     MA41.1    MA41.2    MA41.4    MA41.7
MA43.1    MA43.2    MA43.3    MA43.4    MA43.6    MA43.7
MA530     MA531     MA540     MA60.2    MA60.3    MA60.5
MA61.1    MA63.1    MA65.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MA90.1    MA90.2    MA90.3    MA90.5    MA91.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PD235     PO10.1    PO100     PO101     PO120
PO122     PO131     PO150     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO220     PO223
PO23.1    PO233     PO24.1    PO25.1    PO25.5    PO25.6
PO25.7    PO253     PO254     PO27.2    PO278     PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO32.4    PO33.1    PO34.1    PO35.1    PO36.1
PO36.2    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     PO536     PO54.1    PO54.2    PO54.3
PO54.4    POA2.1    POI3.1    POID.1    POII.1    POIJ.1
PR05.1    PR05.3    PR198     PR226     PR247     PR26.1
PR47.1    PR514     UK47.1    RQ10.1    RQ10.2    WH20.2
WH20.7

UPDATED BY

AP00.1    AP00.3    AP10.3    AP100     AP520

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

VCL-VENDOR-GROUP       Alpha 4                                   AP00.1  AP00.3
Element: Vendor Group  The vendor group. Must be a valid         AP10.3  AP100
                       record in the Vendor Group file.          AP520

VCL-VEN-CLASS          Alpha 3                                   AP00.1  AP00.3
Element: Ven Class     A user-defined code representing a        AP10.3  AP100
                       subset of vendors within a vendor group.  AP520

VCL-VEN-PRIORITY       Numeric 2                                 AP00.1  AP00.3
Element: Payment PrioriThe payment priority to default on        AP10.3  AP100
                       vendors added for the vendor class.       AP520
                       Valid values are 1 (highest priority)
                       through 99 (lowest priority).

VCL-DESCRIPTION        Alpha 30  (Lower Case)                    AP00.1  AP00.3
Element: Description   The name or description of the vendor     AP10.3  AP100
                       class.                                    AP135   AP520

VCL-ZERO-CHECK         Alpha 1                                   AP00.1  AP00.3
Zero Payments          Indicates whether vendors assigned this   AP10.3  AP100
Allowed                vendor class will have zero payments      AP520
                       created if the vendor's invoices net to
                       zero. Valid values are:

                       N = No.
                       Y = Yes.

VCL-POST-OPTION        Alpha 1                                   AP00.1  AP00.3
Element: Post Option   The posting option for the vendor         AP10.3  AP100
                       class. Determines the volume of invoice   AP520
                       expense distribution information that
                       AP175 (Invoice Distribution Closing)
                       transfers to the general ledger. Valid
                       values are:

                       S = Summary. Invoice distributions post
                       to the general ledger in summary.
                       Invoice distributions with the same
                       accounting unit, account number,
                       activity, and post date are grouped into
                       one general ledger journal entry.

                       D = Detail. Invoice distributions post
                       to the general ledger in detail. Each
                       invoice distribution represents one
                       general ledger journal entry.

                       Blank = Posting option not selected for
                       vendor class. Company posting option is
                       used.

VCL-DIST-CODE          Alpha 9                                   AP00.1  AP00.3
Element: Dist Code     The distribution code to default on       AP10.3  AP100
                       vendors added for the vendor class. Used  AP520
                       to automatically create expense
                       distribution lines for an invoice during
                       entry. Must be a valid record in the
                       Distribution Code file.

VCL-MAX-PMT-AMT        Signed 18.2                               AP00.1  AP00.3
Element: Intl Amt      The maximum single payment amount that    AP10.3  AP100
                       can be created for any vendor within      AP520
                       this vendor class. AP150 or AP151
                       assigns the Maximum Payment Hold Code
                       you select for the vendor class to
                       invoices that, if scheduled for payment,
                       would cause a payment total greater than
                       this maximum amount.

VCL-MAX-PMT-HOLD       Alpha 4                                   AP00.1  AP00.3
Element: Hold Code     The hold code to be assigned to vendor    AP10.3  AP100
                       invoices within this vendor class when    AP520
                       the maximum single payment amount is
                       exceeded. Must be a valid invoice hold
                       code in the Hold Code file. Used only if
                       a Maximum Payment Amount is defined for
                       the vendor class.

VCL-INCOME-CODE        Alpha 4                                   AP00.1  AP00.3
Element: Income Code   The income code to default on vendors     AP10.3  AP100
                       added for the vendor class. Used to       AP520
                       track vendor reportable income. Must be
                       a valid record in the Income Code file.

VCL-CURRENCY-CODE      Alpha 5                                   AP00.1  AP00.3
Element: Invoice CurrenThe invoice currency to default on        AP10.3  AP100
                       vendors added for the vendor class. Must  AP520
                       be a valid record in the Currency Code
                       file.

VCL-TAX-EXEMPT-CD      Alpha 1
Element: Tax Exempt Cd Code indicating the taxing status. E -
                       Exempt, T - Taxable.

VCL-TAX-CODE           Alpha 10                                  AP00.1  AP00.3
Element: Tax Code      The tax code to default on vendors        AP10.3  AP100
                       added for the vendor class. Used to       AP520
                       calculate invoice tax information. Must
                       be a valid record in the Tax Code file.

VCL-CASH-CODE          Alpha 4                                   AP00.3
Element: Cash Code     The cash code to default on vendors
                       added for the vendor class. Represents a
                       bank account. Must be a valid record in
                       the Cash Code file.

VCL-BANK-INST-CODE     Alpha 3                                   AP00.3
Element: Payment Code  The payment code to default on vendors
                       added for the vendor class. Represents a
                       type of cash or bill of exchange
                       payment. Must be a valid cash payment or
                       bill of exchange payment transaction
                       code in the Bank Transaction Code file.

VCL-ZERO-PMT-CODE      Alpha 3                                   AP00.3
Element: Zero Payment CThe payment code that represents a zero
                       payment.

VCL-ENCLOSURE          Alpha 1                                   AP00.3
Element: All Flag      Indicates whether the invoice requires
                       an enclosure with its payment.
                       Y = Yes
                       N = No
                       " "

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


VCL-HANDLING-CODE      Alpha 4                                   AP00.3  AP100
Element: Handling Code

VCL-VALIDATE-PO        Alpha 1                                   AP00.3  AP100
Element: Validate Po   " " = MA Company Default
                       Y = Yes
                       N = No

VCL-REQUIRE-PO         Alpha 1                                   AP00.3  AP100
Element: Require Po    " " = MA Company Default
                       Y = Yes
                       N = No

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

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

VCL-MATCH-TABLE        Alpha 10                                  AP00.3
Element: Match Table

VCL-RULE-GROUP         Alpha 10                                  AP00.3
Element: Rule Group

VCL-RETAIL-FLAG        Numeric 1                                 AP00.3
Element: Retail Flag

                         APVENCLASS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VCLSET1   VENDOR-GROUP                                           AC160   AC210
          VEN-CLASS                                              AM115   AM117
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM18.1  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.1
                                                                 AP00.3  AP03.3
                                                                 AP10.1  AP10.2
                                                                 AP10.3  AP100
                                                                 AP102   AP110
                                                                 AP115   AP125
                                                                 ...