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

AC160     AC42.1    AC42.2    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    AP00.3    AP00.5    AP03.3    AP10.1    AP10.5
AP110     AP115     AP125     AP126     AP131     AP16.1
AP16.2    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.1    AP30.2    AP30.4
AP305     AP510     AP52.1    AP52.3    AP520     AP90.1
AP91.1    API1.1    API2.1    API3.1    API4.1    API5.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
MX123     MX500     MA126     MA180     MA205     MA279
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.4    MA43.6    MA43.7    MA530     MA531
MA54.1    MA54.2    MA540     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    MA69.1    MA70.1
MA75.1    MA80.1    MAED.1    MAHA.1    MAI1.1    PD10.1
PD10.2    PD130     PD20.1    PD20.2    PD20.3    PD235
PO10.1    PO100     PO101     PO120     PO122     PO131
PO190     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    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    MAED.1
                       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: Acct 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
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: Sub Acct      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: Segment Block 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-COCO-FL            Numeric 1                                 MA05.1
Element: Coco Fl       This is the flag when added to the
                       handling code denotes that the invoice
                       will be reviewed for match based on
                       header, line, and Cost components (AOC)
                       0 = No
                       1 = Yes

MAH-RULE-GROUP         Alpha 10                                  MA05.1
Element: Rule Group

MAH-MATCH-LEVEL        Alpha 3                                   MA05.1
Element: Match Level

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

                         MAINVHAND FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAHSET1   HANDLING-CODE                                          AC160   AC42.1
                                                                 AC42.2  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  AP00.3
                                                                 AP00.5  AP03.3
                                                                 AP10.1  AP10.5
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP16.1
                                                                 ...

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

MAHSET3   VENDOR-GROUP  KeyChange                                AP110   MA205
          HANDLING-CODE
          COMPANY

                         MAINVHAND FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Systemcodepm   SYSTEMCODE   Required

                            "PM"                 -> SYS-SYSTEM

                         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