LMPAYDTL – Payment Schedule Detail
- System
- LM (LM)
- Prefix
LPD- Primary key
COMPANY,LEASE,PMT-VENDOR,PMT-NBR,EXEC-CODE- Fields
- 47
- Updated by
- 1 program
- Referenced by
- 1 program
LMPAYDTL is the Payment Schedule Detail table in Lawson LM (prefix LPD). It is indexed by COMPANY, LEASE, PMT-VENDOR, PMT-NBR, EXEC-CODE (LPDSET1); alternate indexes: LPDSET2, LPDSET3, LPDSET5 and LPDSET6. It is related 1:1 to RWHEADER, GLSYSTEM, CMPUTE, GLCPYGRP, GLNAMES, LMLEASE and MXLISTHDR and 1:M to LMINVOICE. It is updated by AP30.4 and referenced by APCP.1. The table has 47 fields, 5 indexes and 9 documented relations.
About LMPAYDTL
This file stores detail information for lease payments.
Fields (47)
Column = COBOL field name without the LPD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#LPD-COMPANY PKCOMPANY | Numeric 4 | This field contains the name of the lessor company; it must be a valid company in the Accounts Payable system. | — |
#LPD-LEASE PKLEASE | Alpha 19 | This field contains the lease ID defined on Lease (LM21.1). | — |
#LPD-EXEC-CODE PKEXEC_CODE | Alpha 6 | This 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 PKPMT_VENDOR | Alpha 9 (Right Justified) | The field contains the Accounts Payable vendor associated with the invoice. | — |
#LPD-PMT-NBR PKPMT_NBR | Numeric 6 | — | — |
#LPD-SUFFIXSUFFIX | Numeric 3 | This is the suffix for the invoice. | — |
#LPD-DIST-SEQ-NBRDIST_SEQ_NBR | Numeric 6 | A unique sequence number. | — |
#LPD-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | — |
#LPD-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the code representing the currency used for the lease transactions. | — |
#LPD-CURR-NDCURR_ND | Numeric 1 | This field contains the number of decimals defined for the currency used in the lease transaction. | — |
#LPD-RECUR-NBR SET6RECUR_NBR | Numeric 6 | This field contains a unique number identifying a recurring invoice both in this file and in the LMPAYRECUR file. | — |
#LPD-AUTH-CODEAUTH_CODE | Alpha 3 | This field contains the authority code of the person responsible for releasing the invoice for payment. | — |
#LPD-DUE-DATE SET3DUE_DATE | Numeric 8 (yyyymmdd) | This field contains the due date for the payment. | — |
#LPD-PAYMENT-AMTPAYMENT_AMT | Signed 18.2 | This 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-NAMECOMPUTE_NAME | Alpha 12 | 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-COCOMPUTE_CO | Numeric 4 | This field contains the company from which the compute parameters pull their data. | — |
#LPD-COMPANY-GROUPCOMPANY_GROUP | Alpha 12 | This field contains the company group from which the compute parameters pull their data. | — |
#LPD-AU-MATRIX-LISTAU_MATRIX_LIST | Alpha 12 | This field contains the matrix list from which the compute parameters pull their data. | — |
#LPD-ACCT-UNITACCT_UNIT | Alpha 15 | This field contains the accounting unit from which the compute parameters pull their data. | — |
#LPD-FR-ACCOUNTFR_ACCOUNT | Numeric 6 | This field contains the first account in a range of accounts from which the compute parameters pull their data. | — |
#LPD-TH-ACCOUNTTH_ACCOUNT | Numeric 6 | This field contains the last account in a range of accounts from which the compute parameters pull their data. | — |
#LPD-FR-SUB-ACCTFR_SUB_ACCT | Numeric 4 | This field contains the first sub-account in a range of accounts from which the compute parameters pull their data. | — |
#LPD-TH-SUB-ACCTTH_SUB_ACCT | Numeric 4 | This field contains the last sub-account in a range of accounts from which the compute parameters pull their data. | — |
#LPD-ACCOUNT-GROUPACCOUNT_GROUP | Alpha 12 | This field contains the account group from which the compute parameters pull their data. | — |
#LPD-SUB-ACCT-GRPSUB_ACCT_GRP | Alpha 12 | This field contains the sub-account group from which the compute parameters pull their data. | — |
#LPD-GL-BUDGET-NBRGL_BUDGET_NBR | Numeric 3 | This field contains the budget number associated with the compute parameters. | — |
#LPD-VENDOR-INV-NBRVENDOR_INV_NBR | Alpha 22 | This field contains the vendor-defined invoice number. | — |
#LPD-RELEASED-FLRELEASED_FL | Alpha 1 | This flag indicates whether this payment schedule record has been released to the Accounts Payable system. Valid values are:
| AP30.4 |
#LPD-BASE-CURRENCYBASE_CURRENCY | Alpha 5 | The company base currency. | — |
#LPD-BASE-PMT-AMTBASE_PMT_AMT | Signed 18.2 | — | — |
#LPD-BASE-CURR-RATEBASE_CURR_RATE | Signed 14.7 | This field contain the currency exchange rate for the lease company base currency. | — |
#LPD-BASE-NDBASE_ND | Numeric 1 | The number of decimal positions defined for the company base currency. | — |
#LPD-CMP-PMT-AMTCMP_PMT_AMT | Signed 18.2 | — | — |
#LPD-MAXIMUM-PMTMAXIMUM_PMT | Signed 18.2 | — | — |
#LPD-COMPUTE-OPTCOMPUTE_OPT | Alpha 6 | — | — |
#LPD-ACCRUE-FLAGACCRUE_FLAG | Alpha 1 | — | — |
#LPD-ACCRUE-RVRSACCRUE_RVRS | Alpha 1 | — | — |
#LPD-PERIODPERIOD | Numeric 2 | This is the current accounting period. This field is updated by GL199 (Period Closing). | — |
#LPD-YEARYEAR | Numeric 4 | Contains the fiscal year for the data stored on this record. | — |
#LPD-TAXABLE-FLAGTAXABLE_FLAG | Alpha 1 | Defines if Taxable. | — |
#LPD-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | — |
#LPD-TAX-USAGE-CDTAX_USAGE_CD | Alpha 10 | The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required. | — |
#LPD-PCNT-TAXABLEPCNT_TAXABLE | Signed 7.3 | 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-TAXABLEBASE_TAXABLE | Signed 18.2 | — | — |
#LPD-TRAN-TAXABLETRAN_TAXABLE | Signed 18.2 | — | — |
#LPD-BASE-LAND-TAXBASE_LAND_TAX | Signed 18.2 | — | — |
#LPD-TRAN-LAND-TAXTRAN_LAND_TAX | Signed 18.2 | — | — |
Indexes (5)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
LPDSET1 |
| Primary | AP30.4, APCP.1 | |
LPDSET2 |
| KeyChange | — | |
LPDSET3 |
| KeyChange | — | |
LPDSET5 |
| KeyChange | — | |
LPDSET6 |
| — |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acct Rwheader | RWHEADER | Not Required |
| ||||||||||
| Cmp Glsystem | GLSYSTEM | Not Required |
| ||||||||||
| Cmpute | CMPUTE | Not Required |
| ||||||||||
| Glcpygrp | GLCPYGRP | Not Required |
| ||||||||||
| Glnames | GLNAMES | Not Required |
| ||||||||||
| Lmlease | LMLEASE | Required |
| ||||||||||
| Mxlisthdr | MXLISTHDR | Not Required |
| ||||||||||
| Sub Rwheader | RWHEADER | Not Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Lminvoice | LMINVOICE |
|
Programs
Updated by (1)
- AP30.4 Invoice Cancel
Referenced by (1)
- APCP.1 APC Comments