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    AP13.2    AP520     EE20.1    EE20.2
EE20.4    EE520     MA540     PO150     PR198

UPDATED BY

AP10.5    AP10.6    AP300     AP305     AC160     AM115
AM117     AM15.1    AM15.2    AM15.3    AM15.4    AM19.1
AM19.2    AM20.1    AM20.3    AM21.1    AM21.3    AM500
AM51.1    AM551     AM97.1    AP03.3    AP110     AP115
AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP210     AP220
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.4    AP510     AP90.1    AP91.1    API1.1    API2.1
API3.1    API4.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    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
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    MAI1.1    PD10.1
PD10.2    PD130     PD20.1    PD20.2    PD20.3    PD235
PO10.1    PO100     PO101     PO120     PO122     PO131
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    POI3.1    POID.1
POII.1    POIJ.1    PR05.1    PR05.3    PR226     PR247
PR26.1    PR47.1    PR514     UK47.1    RQ10.1    RQ10.2
WH20.2    WH20.7

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        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 Cd Code 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: Dist Code     The 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: Auth Code     The 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 Nbr

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                                           AC160   AC210
          VENDOR                                                 AM115   AM117
          LOCATION-CODE                                          AM15.1  AM15.2
          COMPANY                                                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
                                                                 AP10.5  AP10.6
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP13.2  AP131
                                                                 AP20.1  AP20.2
                                                                 ...