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


LMPAYDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LPDSET1 COMPANY
LEASE
PMT-VENDOR
PMT-NBR
EXEC-CODE
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


LMPAYDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:49:58 2016

Home
Contact Us



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