Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             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

AC03.4    AC115     AC440     AC50.1    AC500     AC52.1
AC520     AM18.1    AP125     AP126     AP170     AP180
AP181     AP190     AP193     AP20.1    AP20.2    AP20.5
AP20.6    AP20.7    AP23.1    AP25.1    AP25.2    AP26.1
AP30.2    AP30.3    AP30.4    AP32.2    AP520     AR08.1
AR10.1    AR115     AR124     AR190     AR20.1    AR21.1
AR21.2    AR21.3    AR24.1    AR29.2    AR30.1    AR30.2
AR30.4    AR42.1    AR42.2    AR42.7    AR43.1    AR501
AR550     AR560     AR570     AR575     AR580     AR82.1
BL02.1    BL122     BL140     BL141     BL202     BL240
BL340     BL41.1    BL802     BL902     BL92.1    CB10.1
CB180     CB191     CB20.1    CB30.1    CB500     DT180
DT181     EE135     EE20.1    EE20.2    EE20.4    EE35.1
EE35.2    EE520     DR100     IC10.1    IC10.2    IC12.1
IC140     IC141     IC142     IC145     IC16.4    IC226
IC263     IC45.1    IC530     IC62.1    IC63.1    IC81.2
IC812     IC82.1    IC83.1    IC840     IN20.1    MA140
MA190     MA278     MA300     MA40.1    MA40.2    MA41.1
MA41.2    MA41.3    MA41.4    MA41.5    MA41.6    MA43.1
MA43.2    MA43.3    MA43.4    MA52.1    MA520     MA530
MA540     MA95.1    MA95.2    OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE112     OE113
OE114     OE129     OE14.4    OE15.1    OE15.2    OE15.3
OE15.4    OE15.5    OE15.7    OE510     OE810     OE920
PBIP.1    PO10.1    PO10.2    PO100     PO115     PO120
PO121     PO122     PO123     PO13.1    PO130     PO131
PO132     PO135     PO14.1    PO15.1    PO150     PO180
PO20.1    PO21.1    PO21.2    PO21.5    PO21.6    PO210
PO213     PO214     PO216     PO22.1    PO22.2    PO22.3
PO220     PO221     PO223     PO224     PO225     PO23.1
PO23.2    PO230     PO231     PO233     PO236     PO24.1
PO25.1    PO25.2    PO25.3    PO25.4    PO26.1    PO272
PO274     PO275     PO276     PO277     PO28.3    PO28.4
PO28.5    PO28.7    PO28.8    PO280     PO29.1    PO295
PO30.1    PO31.1    PO33.1    PO34.1    PO35.1    PO50.1
PO529     PO530     PO560     PO60.1    PO61.1    PO62.1
PO63.1    PO64.1    PO66.1    PO67.1    PO68.1    PO69.1
PO72.2    PO81.1    PO813     PO820     PO821     PO94.1
PR05.1    PR05.3    PR150     PR195     PR199     PR226
PR26.1    PR514     PR82.1    PR85.1    RQ10.1    RQ10.3
RQ11.1    RQ111     RQ20.1    RQ20.2    RQ20.3    RQ20.4
RQ35.1    RQ500     TX04.1    TX40.1    WH130     WH132
WH140     WH190     WH20.2    WH20.7    WH30.1    WH30.2
WH30.3    WH31.1    WH31.2    WH31.3    WH32.1    WH32.2
WH32.3    WH33.5    WH34.1    WH34.2    WH34.3    WH34.4
WH40.1    WH40.2    WH520     WH830     WO235     WO252
WO30.1    WO35.1    WO40.1

UPDATED BY

AP10.5    AP10.6    AP10.1    AP10.2    AP300     AP305

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


APX-VENDOR           Alpha 9                                     AP10.5  AP10.6
Vendor ID            The vendor identification. Must be a
                     valid record in the Vendor file.


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


APX-LOCATION-CODE    Alpha 4                                     AP10.5  AP10.6
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
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-CODE         Alpha 10                                    AP10.5  AP10.6
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
Distribution 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
Invoice Accrual Code The 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
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
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
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
Authority 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
Payment Code         A transaction code represents a type of
                     cash payment, bill of exchange payment,
                     or bank service transaction.


APX-TAX-USAGE-CD     Alpha 10                                    AP10.5  AP10.6
Tax Usage Code       The tax usage code for the vendor.
                     This field is required if the AP Company
                     indicates that VAT reporting required


                         APCPYVND FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APXSET1   VENDOR-GROUP  This index is used when transactions     AC03.4  AC115
          VENDOR        are released to determine if they are    AC440   AC50.1
          LOCATION-CODE approved and available to be paid, or if AC500   AC52.1
          COMPANY       they need approval before payment.       AC520   AM18.1
                                                                 AP10.1  AP10.2
                                                                 AP10.5  AP10.6
                                                                 AP125   AP126
                                                                 AP170   AP180
                                                                 AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP30.3
                                                                 ...