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     AC297     AM18.1    AP115     AP125     AP126
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.6
AP20.7    AP23.1    AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.3    AP520     API1.1    API2.1    EE20.1
EE20.2    EE20.4    EE520     IC530     MA41.2    MA41.7
MA43.1    MA43.2    MA43.3    MA43.4    MA43.5    MA43.7
MA43.8    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     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    PR514     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
Purchase From          If the company codes are associated
Location Code          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 Code

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
Accounts Receivable    The cash code assigned to the vendor or
Code                   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
Accounts Receivable    The income code assigned to the vendor
Code                   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

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.

                         APCPYVND FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APXSET1   VENDOR-GROUP  This index is used when transactions     AC210   AC297
          VENDOR        are released to determine if they are    AM115   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   AP125
                                                                 AP126   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP23.1  AP25.1
                                                                 ...