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.
| 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-NBRRECUR_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-DATEDUE_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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
LPDSET1 | COMPANY, LEASE, PMT-VENDOR, PMT-NBR, EXEC-CODE | Primary | AP30.4, APCP.1 | |
LPDSET2 | COMPANY, LEASE, PMT-VENDOR, PMT-NBR*, EXEC-CODE | KeyChange | — | |
LPDSET3 | COMPANY, LEASE, DUE-DATE, PMT-VENDOR, PMT-NBR, EXEC-CODE | KeyChange | — | |
LPDSET5 | COMPANY, LEASE, EXEC-CODE, PMT-VENDOR, PMT-NBR | KeyChange | — | |
LPDSET6 | COMPANY, LEASE, PMT-VENDOR, RECUR-NBR, PMT-NBR, EXEC-CODE | — |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
Updated by (1)
- AP30.4 Invoice Cancel
Referenced by (1)
- APCP.1 APC Comments