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 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

LMPAYDTL FILE INDEX

LMPAYDTL FILE RELATIONS

ONE TO ONE RELATIONS

LMPAYDTL FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.