Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LMPAYDTL


                             LMPAYDTL FILE

                        Payment Schedule Detail

This file stores detail information for lease payments.

REFERENCED BY

APCP.1

UPDATED BY

AP30.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

LPD-COMPANY            Numeric 4
Element: Company       This field contains the name of the
                       lessor company; it must be a valid
                       company in the Accounts Payable system.

LPD-LEASE              Alpha 19
Element: Lease         This field contains the lease ID
                       defined on Lease (LM21.1).

LPD-EXEC-CODE          Alpha 6
Element: Executory CostThis field contains an executory cost
                       code. Executory costs represent
                       supplemental costs such as taxes.
                       maintenance fees, or insurance. You can
                       assign up to 5 executory cost codes to a
                       lease.

LPD-PMT-VENDOR         Alpha 9  (Right Justified)
Element: Payment VwndorThe field contains the Accounts Payable
                       vendor associated with the invoice.

LPD-PMT-NBR            Numeric 6
Element: Payment Number

LPD-SUFFIX             Numeric 3
Element: Suffix        This is the suffix for the invoice.

LPD-DIST-SEQ-NBR       Numeric 6
Distribution           A unique sequence number.
Sequence Number

LPD-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field displays the description.

LPD-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the code
                       representing the currency used for the
                       lease transactions.

LPD-CURR-ND            Numeric 1
Currency Number of     This field contains the number of
Decimals               decimals defined for the currency used
                       in the lease transaction.

LPD-RECUR-NBR          Numeric 6
Element: Recurring NumbThis field contains a unique number
                       identifying a recurring invoice both in
                       this file and in the LMPAYRECUR file.

LPD-AUTH-CODE          Alpha 3
Element: Authority CodeThis field contains the authority code
                       of the person responsible for releasing
                       the invoice for payment.

LPD-DUE-DATE           Numeric 8  (yyyymmdd)
Element: Due Date      This field contains the due date for
                       the payment.

LPD-PAYMENT-AMT        Signed 18.2
Element: Payment NumberThis lease contains the payment amount
                       in the lease transaction currency.  If
                       you do not enter a payment amount, you
                       must enter a compute name in the
                       COMPUTE-NAME field to let the system
                       calculate the payment amount.

LPD-COMPUTE-NAME       Alpha 12
Element: Compute Name  This field contains a compute name used
                       to calculate the payment amount. A
                       compute name represents an arithmetic
                       equation (also called compute statement)
                       consisting of data dictionary items and
                       operation symbols. The compute name must
                       be defined using Compute Statement
                       (RW50.1).

                       A compute name is required if the
                       PAYMENT-AMT field is blank.

LPD-COMPUTE-CO         Numeric 4
Element: Compute CompanThis field contains the company from
                       which the compute parameters pull their
                       data.

LPD-COMPANY-GROUP      Alpha 12
Element: Company Group This field contains the company group
                       from which the compute parameters pull
                       their data.

LPD-AU-MATRIX-LIST     Alpha 12
Element: Company MatrixThis field contains the matrix list
                       from which the compute parameters pull
                       their data.

LPD-ACCT-UNIT          Alpha 15
Element: Accounting UniThis field contains the accounting unit
                       from which the compute parameters pull
                       their data.

LPD-FR-ACCOUNT         Numeric 6
Element: Beginning AccoThis field contains the first account
                       in a range of accounts from which the
                       compute parameters pull their data.

LPD-TH-ACCOUNT         Numeric 6
Element: End Account   This field contains the last account in
                       a range of accounts from which the
                       compute parameters pull their data.

LPD-FR-SUB-ACCT        Numeric 4
Element: Beginning SubaThis field contains the first
                       sub-account in a range of accounts from
                       which the compute parameters pull their
                       data.

LPD-TH-SUB-ACCT        Numeric 4
Element: End SubaccountThis field contains the last
                       sub-account in a range of accounts from
                       which the compute parameters pull their
                       data.

LPD-ACCOUNT-GROUP      Alpha 12
Element: Account Group This field contains the account group
                       from which the compute parameters pull
                       their data.

LPD-SUB-ACCT-GRP       Alpha 12
Element: End SubaccountThis field contains the sub-account
                       group from which the compute parameters
                       pull their data.

LPD-GL-BUDGET-NBR      Numeric 3
Element: Budget Number This field contains the budget number
                       associated with the compute parameters.

LPD-VENDOR-INV-NBR     Alpha 22
Vendor Invoice         This field contains the vendor-defined
Number                 invoice number.

LPD-RELEASED-FL        Alpha 1                                   AP30.4
Element: Released Flag This flag indicates whether this payment
                       schedule record has been released to the
                       Accounts Payable system. Valid values
                       are:
                       Y = Yes
                       N = No
                       T = Terminated

LPD-BASE-CURRENCY      Alpha 5
Element: Base Currency The company base currency.

LPD-BASE-PMT-AMT       Signed 18.2
Element: Base Payment Amount

LPD-BASE-CURR-RATE     Signed 14.7
Element: Base Exchange This field contain the currency exchange
                       rate for the lease company base
                       currency.

LPD-BASE-ND            Numeric 1
Base Currency Nbr      The number of decimal positions defined
of Decimals            for the company base currency.

LPD-CMP-PMT-AMT        Signed 18.2
Element: Intl Amt

LPD-MAXIMUM-PMT        Signed 18.2
Element: Intl Amt

LPD-COMPUTE-OPT        Alpha 6
Element: Compute Opt

LPD-ACCRUE-FLAG        Alpha 1
Element: All Flag

LPD-ACCRUE-RVRS        Alpha 1
Element: All Flag

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

LPD-YEAR               Numeric 4
Element: Year          Contains the fiscal year for the data
                       stored on this record.


LPD-TAXABLE-FLAG       Alpha 1
Element: Taxable Flag  Defines if Taxable.

LPD-TAX-CODE           Alpha 10
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


LPD-TAX-USAGE-CD       Alpha 10
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

LPD-PCNT-TAXABLE       Signed 7.3
Element: Percent       The percentage determines how much
                       retention is held. It can either be a
                       percentage of each invoice, or it can be
                       a percentage of a total.

LPD-BASE-TAXABLE       Signed 18.2
Element: Intl Amt

LPD-TRAN-TAXABLE       Signed 18.2
Element: Intl Amt

LPD-BASE-LAND-TAX      Signed 18.2
Element: Intl Amt

LPD-TRAN-LAND-TAX      Signed 18.2
Element: Intl Amt

                         LMPAYDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LPDSET1   COMPANY                                                AP30.4  APCP.1
          LEASE
          PMT-VENDOR
          PMT-NBR
          EXEC-CODE

LPDSET2   COMPANY       KeyChange
          LEASE
          PMT-VENDOR
          PMT-NBR*
          EXEC-CODE

LPDSET3   COMPANY       KeyChange
          LEASE
          DUE-DATE
          PMT-VENDOR
          PMT-NBR
          EXEC-CODE

LPDSET5   COMPANY       KeyChange
          LEASE
          EXEC-CODE
          PMT-VENDOR
          PMT-NBR

LPDSET6   COMPANY
          LEASE
          PMT-VENDOR
          RECUR-NBR
          PMT-NBR
          EXEC-CODE

                         LMPAYDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Rwheader  RWHEADER     Not Required

                            "G"                   -> RWH-HEAD-TYPE  (RWHSET1)
                            LPD-ACCOUNT-GROUP     -> RWH-HEAD-NAME
                            "A"                   -> RWH-RECORD-TYPE

Cmp Glsystem   GLSYSTEM     Not Required

                            LPD-COMPUTE-CO        -> GLS-COMPANY

Cmpute         CMPUTE       Not Required

                            LPD-COMPUTE-NAME      -> CMP-COMPUTE-NAME

Glcpygrp       GLCPYGRP     Not Required

                            LPD-COMPANY-GROUP     -> GCG-COMPANY-GROUP

Glnames        GLNAMES      Not Required

                            LPD-COMPUTE-CO        -> GLN-COMPANY
                            LPD-ACCT-UNIT         -> GLN-ACCT-UNIT

Lmlease        LMLEASE      Required

                            LPD-COMPANY           -> LSE-COMPANY
                            LPD-LEASE             -> LSE-LEASE

Mxlisthdr      MXLISTHDR    Not Required

                            "ACCTU"               -> MLH-OBJ-TYPE
                            LPD-AU-MATRIX-LIST    -> MLH-MATRIX-LIST

Sub Rwheader   RWHEADER     Not Required

                            "G"                   -> RWH-HEAD-TYPE
                            LPD-SUB-ACCT-GRP      -> RWH-HEAD-NAME
                            "S"                   -> RWH-RECORD-TYPE

                         LMPAYDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apinvoice      APINVOICE

                            LPD-COMPANY           -> API-COMPANY
                            LPD-PMT-VENDOR        -> API-VENDOR
                            LPD-LEASE             -> API-INVOICE
                            LPD-SUFFIX            -> API-SUFFIX
                                                     API-CANCEL-SEQ

Lminvoice      LMINVOICE

                            LPD-COMPANY           -> INV-COMPANY
                            LPD-LEASE             -> INV-LEASE
                            LPD-PMT-NBR           -> INV-PMT-NBR
                            LPD-PMT-VENDOR        -> INV-PMT-VENDOR
                                                     INV-CANCEL-SEQ