Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    AP00.3    AP00.5    AP10.1    AP10.2    AP10.5
AP110     AP220     AP30.1    AP510     AP520     API1.1
API2.1    API3.1    API4.1    MA205     MA65.1    MAHA.1

UPDATED BY

MA05.1    MA05.6    MA01.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

MAH-HANDLING-CODE    Alpha 4                                     MA05.1  MA05.6
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
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
Description          A description of the invoice handling
                     code.

MAH-MATCH-FL         Alpha 1                                     MA05.1  MA05.6
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
Add On Cost Flag     Indicates 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
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
Use PO Add On Costs  Indicates if add on cost information
                     from the purchase order will be used.

                     Valid values are:

                     N = No
                     Y = Yes

MAH-PO-NBR-REQ       Alpha 1                                     MA05.1  MA05.6
Purchase Order       Indicates if a PO number is required.
Number Required      Valid values are:

                     N = No
                     Y = Yes

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

                     N = No
                     Y = Yes

MAH-BYPASS-MATCH     Alpha 1                                     MA05.1  MA05.6
Bypass Match         Y = Yes
                     N = No

MAH-ACCT-UNIT        Alpha 15                                    MA05.1  MA05.6
Accounting Unit      The 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
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
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
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.

                         MAINVHAND FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAHSET1   HANDLING-CODE                                          AC42.1  AP00.3
                                                                 AP00.5  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP110   AP220
                                                                 AP30.1  AP510
                                                                 AP520   API1.1
                                                                 API2.1  API3.1
                                                                 API4.1  MA01.1
                                                                 MA05.1  MA05.2
                                                                 MA05.3  MA05.4
                                                                 MA05.6  MA205
                                                                 MA65.1  MAHA.1

MAHSET2   COMPANY       KeyChange                                MA01.1  MA05.6
          HANDLING-CODE                                          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