Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LMINVOICE


                             LMINVOICE FILE

This file stores the invoices generated from a lease payment schedule. These
invoices can be edited and sent on to the Accounts Payable system.

REFERENCED BY

APCP.1

UPDATED BY

AP30.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

INV-COMPANY            Numeric 4
Element: Company       This field contains the Accounts
                       Payable company associated with the
                       invoice.

INV-LEASE              Alpha 19
Element: Lease         This is the lease ID as defined using
                       LM21.1 or LM21.2.

INV-PMT-VENDOR         Alpha 9  (Right Justified)
Element: Payment VendorThis is the payment vendor or lessor
                       associated with the lease payment.

INV-PMT-NBR            Numeric 3
Element: Payment NumberThis is the payment number for the lease
                       invoice, derived from the lease payment
                       schedule.

INV-INVOICE            Alpha 22
Element: Invoice       The field contains the unique invoice
                       number associated with the invoice. For
                       Lease Management, it consists of the
                       lease ID and payment number.

INV-SUFFIX             Numeric 3
Element: Suffix        This field contains the invoice suffix
                       used to make a recurring invoice
                       instance unique.

INV-CANCEL-SEQ         Numeric 4                                 AP30.4
Invoice
Cancellation Number

INV-STATUS             Numeric 1
Element: Status        This field contains the invoice status.
                       Valid values are:
                       0 = Unreleased
                       1 = Released
                       9 = Posted
                       NOTE: If the status of the invoice is
                       Unreleased, the distribution posting
                       status must be Unposted.

INV-AUTH-CODE          Alpha 3
Element: Authority CodeThis field contains the authority code
                       of the person responsible for releasing
                       the invoice for payment. This code is
                       defined in theAccounts Payable system.

INV-PROC-LEVEL         Alpha 5
Element: Process Level This field contains the process level
                       assigned to the invoice. Must be a valid
                       record in the Accounts Payable system.

INV-HANDLING-CODE      Alpha 4
Element: Handling Code This field contains the handling code
                       specifying invoice rules.  The handling
                       code is defined in the Invoice Matching
                       (MA) system.

INV-VOUCHER-NBR        Alpha 10
Element: Voucher NumberThis field containd the user-defined
                       voucher number for the invoice.

INV-ACCR-CODE          Alpha 4
Element: Accrual Code

INV-INVOICE-TYPE       Alpha 1
Element: Invoice Type  This field contains the invoice type.
                       Valid values are:
                       Blank = Regular Invoice
                       C = Credit Memo
                       H = Historical
                       D = Debit Memo. Processed just like an
                       invoice. Increases the amount owed to
                       the vendor.

INV-TRAN-INV-AMT       Signed 15.2
Lease Currency         This field contains the amount of the
Invoice Amount         invoice in the invoice currency (which
                       is also the lease currency).

INV-TRAN-CURR          Alpha 5
Element: Lease CurrencyThis field contains the transaction
                       currency.

INV-TRAN-ND            Numeric 1
Element: Number of Decimals

INV-BASE-INV-AMT       Signed 15.2
Base Currency          This field contains the invoice amount
Invoice Amount         in compaby base currency.

INV-BASE-CURR          Alpha 5
Element: Base Currency This field contains the company base
                       currency.

INV-BASE-ND            Numeric 1
Base Currency Nber
of Decimals

INV-ORIG-CNV-RATE      Signed 12.6
Original Exchange
Rate

INV-INVOICE-DATE       Numeric 8  (yyyymmdd)
Element: Invoice Date  This field contains the date of the
                       invoice. It can be the date on which the
                       vendor created the invoice or the date
                       on which it was received. This is the
                       date used when updating vendor balances.

INV-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field contains the description of
                       the invoice.

INV-DUE-DATE           Numeric 8  (yyyymmdd)
Element: Due Date      This field contains the invoice due
                       date. It is used by the Accounts Payable
                       system to select the invoice for
                       payment.

INV-DISTRIB-DATE       Numeric 8  (yyyymmdd)
Element: Posting Date

INV-FISCAL-YEAR        Numeric 4
Element: Fiscal Year   This is the current fiscal year.  This
                       field is updated by Period Closing
                       (GL199).

INV-PERIOD             Numeric 2
Element: Period        This is the current accounting period.
                       This field is updated by Period Closing
                       (GL199).

INV-APPROVED-FLAG      Alpha 1
Element: Approved Flag If the invoice requires approval, this
                       field indicates the approval status of
                       the invoice. Valid values are:
                       Y = Yes (approved)
                       N = No (not yet approved)
                       D = Disapproved (authorization denied)

INV-CANCELLED-FL       Alpha 1                                   AP30.4
Element: Cancellation FThis field contains the canceled flag.
                       Vaid values are:
                       Y = Yes
                       N = No

INV-CANCELLED-AP       Derived
Element: AP CancellatioThis flag is set in the Accounts Payable
                       system if Cancelled Flag is set to Yes.

INV-CANCELLED-LM       Derived
Element: LM CancellatioThis flag is set in the Lease management
                       system if Canceled Flag is set to Yes.

                         LMINVOICE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INVSET1   COMPANY       This index is used to retrieve and
          LEASE         create lease invoice records.
          PMT-NBR
          PMT-VENDOR
          CANCEL-SEQ

INVSET10  COMPANY       KeyChange
          LEASE
          FISCAL-YEAR*
          PERIOD*
          PMT-NBR*
          PMT-VENDOR
          CANCEL-SEQ

INVSET11  COMPANY       KeyChangeDuplicates
          LEASE
          DUE-DATE*
          PMT-NBR*
          PMT-VENDOR
          CANCEL-SEQ

INVSET2   COMPANY       KeyChange, Subset
          AUTH-CODE     Where (CANCEL-SEQ = Zeroes )
          PMT-VENDOR    And   (STATUS     = Zeroes )
          LEASE
          PMT-NBR
          DUE-DATE

INVSET3   COMPANY       KeyChange, Subset
          LEASE         Where (CANCEL-SEQ = Zeroes )
          PMT-VENDOR    And   (STATUS     = Zeroes )
          PMT-NBR

INVSET4   COMPANY       KeyChange, Subset
          APPROVED-FLAG Where (CANCEL-SEQ = Zeroes )
          AUTH-CODE     And   (STATUS     = Zeroes )
          LEASE
          PMT-NBR
          PMT-VENDOR

INVSET5   COMPANY       KeyChange, Subset
          LEASE         Where((STATUS       =  1 )
          PMT-VENDOR    And   (CANCEL-SEQ   =  Zeroes ))
          PMT-NBR       Or   ((STATUS       =  9 )
          CANCEL-SEQ    And   (CANCEL-SEQ   != Zeroes )
                        And   (CANCELLED-FL != "Y" ))

INVSET6   COMPANY       KeyChange
          LEASE
          DUE-DATE
          PMT-NBR
          PMT-VENDOR
          CANCEL-SEQ

INVSET7   COMPANY       KeyChange                                AP30.4  APCP.1
          PMT-VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ

INVSET8   COMPANY       KeyChange, Subset
          PMT-VENDOR    Where (CANCEL-SEQ = Zeroes )
          LEASE         And   (STATUS     = Zeroes )
          PMT-NBR

INVSET9   COMPANY       KeyChange
          LEASE
          FISCAL-YEAR
          PERIOD
          PMT-VENDOR
          PMT-NBR
          CANCEL-SEQ

                         LMINVOICE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapihist      APAPIHIST    Not Required

                            INV-COMPANY         -> -COMPANY  (XXXXXXXXXX)
                            INV-PMT-VENDOR      -> -VENDOR
                            INV-INVOICE         -> -INVOICE
                            INV-SUFFIX          -> -SUFFIX
                            INV-CANCEL-SEQ      -> -CANCEL-SEQ

Apcompany      APCOMPANY    Required

                            INV-COMPANY         -> CPY-COMPANY

Apinvoice      APINVOICE    Not Required

                            INV-COMPANY         -> API-COMPANY
                            INV-PMT-VENDOR      -> API-VENDOR
                            INV-INVOICE         -> API-INVOICE
                            INV-SUFFIX          -> API-SUFFIX
                            INV-CANCEL-SEQ      -> API-CANCEL-SEQ

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            INV-PMT-VENDOR      -> VEN-VENDOR

Lmlease        LMLEASE      Not Required

                            INV-COMPANY         -> LSE-COMPANY
                            INV-LEASE           -> LSE-LEASE

                         LMINVOICE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lmdistrib      LMDISTRIB

                            INV-COMPANY         -> DIS-COMPANY
                            INV-PMT-VENDOR      -> DIS-PMT-VENDOR
                            INV-LEASE           -> DIS-LEASE
                            INV-PMT-NBR         -> DIS-PMT-NBR
                            INV-CANCEL-SEQ      -> DIS-CANCEL-SEQ
                                                   DIS-DIST-SEQ-NBR

Lmpaydtl       LMPAYDTL

                            INV-COMPANY         -> LPD-COMPANY
                            INV-LEASE           -> LPD-LEASE
                            INV-PMT-VENDOR      -> LPD-PMT-VENDOR
                            INV-PMT-NBR         -> LPD-PMT-NBR
                                                   LPD-EXEC-CODE