Lawson - Lawson Software Technical Library - Data File Text for LMPAYDTL

LMPAYDTL

Payment Schedule Detail

This file stores detail information for lease payments.
UPDATED BY

AP30.4 APCP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY

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

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

LPD-EXEC-CODE
Element: Executory Cost 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
Element: Payment Vwndor Alpha 9 (Right Justified)
The field contains the Accounts Payable vendor associated with the invoice.

LPD-PMT-NBR
Element: Payment Number Numeric 6

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

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

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

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

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

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

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

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

LPD-PAYMENT-AMT
Element: Payment Number 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-NAME
Element: Compute 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-CO
Element: Compute Company Numeric 4
This field contains the company from which the compute parameters pull their data.

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

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

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

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

LPD-TH-ACCOUNT
Element: End 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-ACCT
Element: Beginning Subaccount 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-ACCT
Element: End Subaccount Numeric 4
This field contains the last sub-account in a range of accounts from which the compute parameters pull their data.

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

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

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

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

LPD-RELEASED-FL
Element: Released Flag Alpha 1
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

AP30.4

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

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

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

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

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

LPD-MAXIMUM-PMT
Element: Intl Amt Signed 18.2

LPD-COMPUTE-OPT
Element: Compute Opt Alpha 6

LPD-ACCRUE-FLAG
Element: All Flag Alpha 1

LPD-ACCRUE-RVRS
Element: All Flag Alpha 1

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

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

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

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

LPD-TAX-USAGE-CD
Element: Tax 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-TAXABLE
Element: Percent 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-TAXABLE
Element: Intl Amt Signed 18.2

LPD-TRAN-TAXABLE
Element: Intl Amt Signed 18.2

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

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