Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAINVHAND


                             MAINVHAND FILE

                         Invoice Handling Code

The Invoice Handling Code file contains an invoice handling code, its
description, and the invoice processing rules assigned to the handling code.
Invoice handling codes are defined in MA05.1 (Handling Code).

REFERENCED BY

AC42.1    AM115     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.3    AM21.1    AM21.3    AM500     AM51.1
AM551     AM97.1    AP00.3    AP00.5    AP10.1    AP10.2
AP10.5    AP110     AP125     AP126     AP131     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP220
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.1
AP30.4    AP510     AP520     API1.1    API2.1    API3.1
API4.1    IC840     MA205     MA41.1    MA41.2    MA41.7
MA43.1    MA43.2    MA43.3    MA531     MA540     MA61.1
MA65.1    MA66.2    MAHA.1    MAI1.1    PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    PR514     UK47.1
AP295

UPDATED BY

MA05.1    MA05.6    MA01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MAH-COMPANY            Numeric 4                                 MA05.1  MA05.6
Element: Company       The company number that the invoice
                       handling code is assigned to.

MAH-HANDLING-CODE      Alpha 4                                   MA05.1  MA05.6
Element: Handling Code Handling code. Contains processing
                       rules for invoice matching. Handling
                       codes are assigned at the company level.


MAH-VENDOR-GROUP       Alpha 4                                   MA05.1  MA05.6
Element: Vendor Group  Vendor group. Represents a group of
                       vendors that can be shared by one or
                       more companies.

MAH-DESCRIPTION        Alpha 30  (Lower Case)                    MA05.1  MA05.6
Element: Description   A description of the invoice handling
                       code.

MAH-MATCH-FL           Alpha 1                                   MA05.1  MA05.6
Element: Match Flag    Indicates if invoices assigned this
                       handling code are eligible for matching.

                       Valid values are:

                       N = No
                       Y = Yes

MAH-AOC-FL             Alpha 1                                   MA05.1  MA05.6
Element: Add On Cost FlIndicates if the invoice assigned this
                       handling code will be defined as an add
                       on cost only invoice.

                       Valid values are:

                       N = No
                       Y = Yes

MAH-SERVICE-FL         Alpha 1                                   MA05.1  MA05.6
Element: Service Fl    This field indicates a transaction is a
                       Service only transaction.
                       N = No
                       Y = Yes

MAH-USE-PO-AOC         Alpha 1                                   MA05.1  MA05.6
Element: Use PO Add On Indicates if add on cost information
                       from the purchase order will be used.

                       Valid values are:

                       N = No
                       Y = Yes

MAH-VOUCHER-REQ        Alpha 1                                   MA05.1  MA05.6
Element: Voucher RequirIndicates if a voucher number is
                       required. Valid values are:

                       N = No
                       Y = Yes

MAH-BYPASS-MATCH       Alpha 1                                   MA05.1  MA05.6
Element: All Flag      Y = Yes
                       N = No

MAH-ACCT-UNIT          Alpha 15                                  MA05.1  MA05.6
Element: Accounting UniThe accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


MAH-ACCOUNT            Numeric 6                                 MA05.1  MA05.6
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

MAH-SUB-ACCT           Numeric 4                                 MA05.1  MA05.6
Element: Subaccount    This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

MAH-SEGMENT-BLOCK      Alpha 103                                 MA05.1  MA05.6
Element: User Analysis This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

MAH-DROPSHIP-FL        Alpha 1                                   MA05.1  MA05.6
Element: Dropship Flag This flag indicates whether goods being
                       shipped by the vendor directly to a non
                       standard location need to have the
                       receiving process performed.

                         MAINVHAND FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAHSET1   HANDLING-CODE                                          AC42.1  AM115
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP00.5
                                                                 AP10.1  AP10.2
                                                                 AP10.5  AP110
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP220
                                                                 ...

MAHSET2   COMPANY       KeyChange                                AP295   MA01.1
          HANDLING-CODE                                          MA05.6  MA205

MAHSET3   VENDOR-GROUP  KeyChange                                MA205
          HANDLING-CODE
          COMPANY

                         MAINVHAND FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Approclev      APPROCLEV

                            MAH-HANDLING-CODE    -> APR-HANDLING-CODE
                                                    APR-COMPANY
                                                    APR-PROC-LEVEL

Apvenmast      APVENMAST

                            MAH-HANDLING-CODE    -> VEN-HANDLING-CODE
                                                    VEN-VENDOR-GROUP
                                                    VEN-VENDOR

Macompany      MACOMPANY

                            MAH-HANDLING-CODE    -> MAY-HANDLING-CODE
                                                    MAY-COMPANY