APVENCLASS – Vendor Class

System
Accounts Payable (AP)
Prefix
VCL
Primary key
VENDOR-GROUP, VEN-CLASS
Fields
29
Updated by
5 programs
Referenced by
373 programs

APVENCLASS is the Vendor Class table in Lawson Accounts Payable (prefix VCL). It is indexed by VENDOR-GROUP, VEN-CLASS (VCLSET1). It is updated by AP00.1, AP00.3, AP10.3, AP100 and AP520 and referenced by AC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 and 365 more. The table has 29 fields, 1 index and 0 documented relations.

About APVENCLASS

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.

Fields (29)

Column = COBOL field name without the VCL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
VCL-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4The vendor group. Must be a valid record in the Vendor Group file.AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-VEN-CLASS PK
VEN_CLASS		Alpha 3A user-defined code representing a subset of vendors within a vendor group.AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-VEN-PRIORITY
VEN_PRIORITY		Numeric 2The payment priority to default on vendors added for the vendor class. Valid values are 1 (highest priority) through 99 (lowest priority).AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The name or description of the vendor class.AP00.1, AP00.3, AP10.3, AP100, AP135, AP520
VCL-ZERO-CHECK
ZERO_CHECK		Alpha 1Indicates whether vendors assigned this vendor class will have zero payments created if the vendor's invoices net to zero. Valid values are:
  • N No.
  • Y Yes.
AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-POST-OPTION
POST_OPTION		Alpha 1The posting option for the vendor class. Determines the volume of invoice expense distribution information that AP175 (Invoice Distribution Closing) transfers to the general ledger. Valid values are: 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. to the general ledger in detail. Each invoice distribution represents one general ledger journal entry. vendor class. Company posting option is used.
  • S Summary. Invoice distributions post
  • D Detail. Invoice distributions post
  • Blank Posting option not selected for
AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-DIST-CODE
DIST_CODE		Alpha 9The distribution code to default on vendors added for the vendor class. Used to automatically create expense distribution lines for an invoice during entry. Must be a valid record in the Distribution Code file.AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-MAX-PMT-AMT
MAX_PMT_AMT		Signed 18.2The maximum single payment amount that can be created for any vendor within 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.AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-MAX-PMT-HOLD
MAX_PMT_HOLD		Alpha 4The hold code to be assigned to vendor invoices within this vendor class when 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.AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-INCOME-CODE
INCOME_CODE		Alpha 4The income code to default on vendors added for the vendor class. Used to track vendor reportable income. Must be a valid record in the Income Code file.AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-CURRENCY-CODE
CURRENCY_CODE		Alpha 5The invoice currency to default on vendors added for the vendor class. Must be a valid record in the Currency Code file.AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1Code indicating the taxing status. E - Exempt, T - Taxable.—
VCL-TAX-CODE
TAX_CODE		Alpha 10The tax code to default on vendors added for the vendor class. Used to calculate invoice tax information. Must be a valid record in the Tax Code file.AP00.1, AP00.3, AP10.3, AP100, AP520
VCL-CASH-CODE
CASH_CODE		Alpha 4The 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.AP00.3
VCL-BANK-INST-CODE
BANK_INST_CODE		Alpha 3The 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.AP00.3
VCL-ZERO-PMT-CODE
ZERO_PMT_CODE		Alpha 3The payment code that represents a zero payment.AP00.3
VCL-ENCLOSURE
ENCLOSURE		Alpha 1Indicates whether the invoice requires an enclosure with its payment. " "
  • Y Yes
  • N No
AP00.3
VCL-TAX-USAGE-CD
TAX_USAGE_CD		Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.AP00.3
VCL-HANDLING-CODE
HANDLING_CODE		Alpha 4—AP00.3, AP100
VCL-VALIDATE-PO
VALIDATE_PO		Alpha 1" " = MA Company Default
  • Y Yes
  • N No
AP00.3, AP100
VCL-REQUIRE-PO
REQUIRE_PO		Alpha 1" " = MA Company Default
  • Y Yes
  • N No
AP00.3, AP100
VCL-MTCH-PREPAY-FL
MTCH_PREPAY_FL		Alpha 1Flag that notes if the invoice will be prepaid. This is for match invoices.AP00.3
VCL-MTCH-PREPAY-MT
MTCH_PREPAY_MT		Numeric 1Flag denotes the method of match prepayment.
  • 0 No
  • 1 Prepay from Invoice
  • 2 Eligible for Prepayment
AP00.3
VCL-MATCH-TABLE
MATCH_TABLE		Alpha 10—AP00.3
VCL-RULE-GROUP
RULE_GROUP		Alpha 10—AP00.3
VCL-RETAIL-FLAG
RETAIL_FLAG		Numeric 1—AP00.3
VCL-EAM-VEN-FL
EAM_VEN_FL		Numeric 1—
  • 0 Not an EAM Vendor
  • 1 EAM Vendor
AP00.3
VCL-MIN-PMT-HOLD
MIN_PMT_HOLD		Alpha 4—AP00.3
VCL-MIN-PMT-AMT
MIN_PMT_AMT		Signed 18.2—AP00.3

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
VCLSET1VENDOR-GROUP, VEN-CLASSPrimaryAC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Programs

Updated by (5)

Referenced by (373)