Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APCPYVND


                             APCPYVND FILE

                          Vendor Company Codes

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.

REFERENCED BY

AC210     AM18.1    AP115     AP13.2    AP30.2    AP30.3
AP520     API1.1    API2.1    EE20.1    EE20.2    EE20.4
EE520     IC530     MA531     MA61.1    MA63.1    MA65.1
MA80.1    MAI1.1    PO150     PO25.6    PO25.7    PO36.2
PO536     PR198

UPDATED BY

AP10.5    AP10.6    AP300     AP305     AM115     AM117
AM15.1    AM15.2    AM15.3    AM15.4    AM20.1    AM20.3
AM21.1    AM21.3    AM500     AM51.1    AM551     AM97.1
API3.1    API4.1    IC840     PR05.1    PR05.3    PR226
PR247     PR26.1    PR47.1    UK47.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APX-VENDOR-GROUP       Alpha 4                                   AP10.5  AP10.6
Element: Vendor Group  The vendor group associated with the
                       vendor. Must be a valid record in the
                       Vendor Group file.

APX-VENDOR             Alpha 9  (Right Justified)                AP10.5  AP10.6
Element: Vendor ID     The vendor identification. Must be a
                       valid record in the Vendor file.

APX-COMPANY            Numeric 4                                 AP10.5  AP10.6
Element: Company       The company number. Must be a valid
                       record in the Accounts Payable Company
                       file.

APX-LOCATION-CODE      Alpha 4                                   AP10.5  AP10.6
Element: Location Code If 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.

APX-TERM-CODE          Alpha 5                                   AP10.5  AP10.6
Element: Payment Terms The 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.

APX-TAX-EXEMPT-CD      Alpha 1
Element: Tax Exempt CodCode indicating the taxing status. E -
                       Exempt, T - Taxable.

APX-TAX-CODE           Alpha 10                                  AP10.5  AP10.6
Element: Tax Code      The 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.

APX-DIST-CODE          Alpha 9                                   AP10.5
Element: Distribution CThe 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.

APX-ACCR-CODE          Alpha 4                                   AP10.5
Element: Invoice AccruaThe 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.

APX-DISC-CODE          Alpha 10                                  AP10.5
Element: Discount Code The 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.

APX-CASH-CODE          Alpha 4                                   AP10.5  AP10.6
Element: Cash Code     The 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.

APX-INCOME-CODE        Alpha 4                                   AP10.5
Element: Income Code   The 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.

APX-AUTH-CODE          Alpha 3                                   AP10.5
Element: Authority CodeThe 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.

APX-BANK-INST-CODE     Alpha 3                                   AP10.5  AP10.6
Element: Payment Code  A transaction code represents a type of
                       cash payment, bill of exchange payment,
                       or bank service transaction.

APX-HANDLING-CODE      Alpha 4                                   AP10.5
Invoice Handling       Handling code. Contains processing
Code                   rules that are used during matching.

APX-PO-EDI-NUMBER      Alpha 15                                  AP10.5  AP10.6
Element: Po Edi Number

APX-REV-EDI-NUMBER     Alpha 15                                  AP10.5  AP10.6
Element: EDI Number    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
                       vendor's EDI Number will be used on
                       purchase order revisions.

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

APX-DIVERSE-CODE       Alpha 5                                   AP10.5  AP10.6
Element: Diverse Code  Diversity Code for Account Payable
                       Vendors

                         APCPYVND FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APXSET1   VENDOR-GROUP  This index is used when transactions     AC210   AM115
          VENDOR        are released to determine if they are    AM117   AM15.1
          LOCATION-CODE approved and available to be paid, or if AM15.2  AM15.3
          COMPANY       they need approval before payment.       AM15.4  AM18.1
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP10.5  AP10.6
                                                                 AP115   AP13.2
                                                                 AP30.2  AP30.3
                                                                 AP300   AP305
                                                                 AP520   API1.1
                                                                 API2.1  API3.1
                                                                 API4.1  EE20.1
                                                                 ...