APCPYVND – Vendor Company Codes

System
Accounts Payable (AP)
Prefix
APX
Primary key
VENDOR-GROUP, VENDOR, LOCATION-CODE, COMPANY
Fields
24
Updated by
293 programs
Referenced by
9 programs

APCPYVND is the Vendor Company Codes table in Lawson Accounts Payable (prefix APX). It is indexed by VENDOR-GROUP, VENDOR, LOCATION-CODE, COMPANY (APXSET1); alternate indexes: APXSET2. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 285 more and referenced by AC210, AC297, AM18.1, AP520, EE20.1, EE20.2, EE20.4, EE520 and 1 more. The table has 24 fields, 2 indexes and 0 documented relations.

About APCPYVND

The Vendor Company Codes file contains default codes assigned a vendor or alternate vendor location at the company level. If assigned, these codes override the codes assigned to the vendor or location in the Vendor or Vendor Location file for the accounts payable company indicated. These codes default on invoices during entry unless you override them at the invoice level.

Fields (24)

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

Field / columnTypeDescription & valuesUpdated by
APX-VENDOR-GROUP PK
VENDOR_GROUP		Alpha 4The vendor group associated with the vendor. Must be a valid record in the Vendor Group file.AP10.5, AP10.6
APX-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor identification. Must be a valid record in the Vendor file.AP10.5, AP10.6
APX-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.AP10.5, AP10.6
APX-LOCATION-CODE PK
LOCATION_CODE		Alpha 4If the company codes are associated with an alternate location for the vendor, this field contains the location code. Must be a valid record for the vendor in the Vendor Location file.AP10.5, AP10.6
APX-TERM-CODE
TERM_CODE		Alpha 5The payment terms code assigned to the vendor or purchase from location for the company. Used to automatically calculate invoice due date and discount information. Must be a valid record in the Lawson Terms system.AP10.5, AP10.6
APX-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1Code indicating the taxing status. E - Exempt, T - Taxable.—
APX-TAX-CODE
TAX_CODE		Alpha 10The tax code assigned to the vendor or purchase from location for the company. Used to automatically calculate invoice tax information. Must be a valid record in the Lawson Tax system.AP10.5, AP10.6
APX-DIST-CODE
DIST_CODE		Alpha 9The distribution code assigned to the vendor for the company. Used to automatically create distributions for an invoice. Must be a valid record in the Distribution Code file.AP10.5
APX-ACCR-CODE
ACCR_CODE		Alpha 4The invoice accrual code assigned to the vendor for the company. Represents a general ledger accrual account. Must be a valid record in the Invoice Accrual Code file.AP10.5
APX-DISC-CODE
DISC_CODE		Alpha 10The discount code assigned to the vendor for the company. Represents a general ledger discount account. Must be a valid record in the Discount Code file.AP10.5
APX-CASH-CODE
CASH_CODE		Alpha 4The cash code assigned to the vendor or remit to location for the company. Represents a bank account. Must be a valid record in the Cash Code file.AP10.5, AP10.6
APX-INCOME-CODE
INCOME_CODE		Alpha 4The income code assigned to the vendor for the company. Represents a type of income withholding. Used to track reportable income for reporting or withholding. Must be a valid record in the Income Code file.AP10.5
APX-AUTH-CODE
AUTH_CODE		Alpha 3The authority code assigned to the vendor for the company. Represents a person or department responsible for approving an invoice. Valid only for a company that has Yes selected in the Invoice Approval option field. Must be a valid record in the Authority Code file.AP10.5
APX-BANK-INST-CODE
BANK_INST_CODE		Alpha 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.AP10.5, AP10.6
APX-HANDLING-CODE
HANDLING_CODE		Alpha 4Handling code. Contains processing rules that are used during matching.AP10.5
APX-PO-EDI-NUMBER
PO_EDI_NUMBER		Alpha 15—AP10.5, AP10.6
APX-REV-EDI-NUMBER
REV_EDI_NUMBER		Alpha 15—AP10.5, AP10.6
APX-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.AP10.5, AP10.6
APX-DIVERSE-CODE
DIVERSE_CODE		Alpha 5Diversity Code for Account Payable VendorsAP10.5, AP10.6
APX-RET-ACCR-CODE
RET_ACCR_CODE		Alpha 4—AP10.5
APX-SEC-WTH-CODE1
SEC_WTH_CODE1		Alpha 10—AP10.5
APX-SEC-WTH-CODE2
SEC_WTH_CODE2		Alpha 10—AP10.5
APX-SEC-WTH-CODE3
SEC_WTH_CODE3		Alpha 10—AP10.5
APX-AFFILIATE-FL
AFFILIATE_FL		Alpha 1—AP10.5, AP702

Indexes (2)

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

IndexKeysFlagsConditionUsed in
APXSET1VENDOR-GROUP, VENDOR, LOCATION-CODE, COMPANYPrimaryAC160, AC210, AC297, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
APXSET2COMPANY, VENDOR, LOCATION-CODE, VENDOR-GROUPAP702

Programs

Updated by (293)

Referenced by (9)