Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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

AM18.1    AP115     AP170     AP30.2    AP30.3    AP520
API1.1    API2.1    EE20.1    EE20.2    EE20.4    EE520
IC530     IC840     MA63.1    MA65.1    PR05.1    PR05.3
PR198     PR226     PR247     PR26.1    PR47.1    PR514

UPDATED BY

AP10.5    AP10.6    AP300     AP305     API3.1    API4.1

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  (Right Justified)                  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-EXEMPT-CD    Alpha 1
Tax Exempt Code

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-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
Po Edi Number

APX-REV-EDI-NUMBER   Alpha 15                                    AP10.5  AP10.6
Rev 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
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     AM18.1  AP10.5
          VENDOR        are released to determine if they are    AP10.6  AP115
          LOCATION-CODE approved and available to be paid, or if AP170   AP30.2
          COMPANY       they need approval before payment.       AP30.3  AP300
                                                                 AP305   AP520
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 EE20.1  EE20.2
                                                                 EE20.4  EE520
                                                                 IC530   IC840
                                                                 MA63.1  MA65.1
                                                                 PR05.1  PR05.3
                                                                 PR198   PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  PR514

APXSET2   HANDLING-CODE
          VENDOR-GROUP
          VENDOR
          LOCATION-CODE
          COMPANY