|
|
LMPAYDTL FILE
This file stores detail information for lease payments.
UPDATED BY
AP30.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LPD-COMPANY Numeric 4
Element: Company This field contains the name of the
lessor company; it must be a valid
company in the Accounts Payable system.
LPD-LEASE Alpha 19
Element: Lease This field contains the lease ID
defined on Lease (LM21.1).
LPD-EXEC-CODE Alpha 6
Element: Executory CostThis 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 Alpha 9 (Right Justified)
Element: Payment VwndorThe field contains the Accounts Payable
vendor associated with the invoice.
LPD-PMT-NBR Numeric 3
Element: Payment Number
LPD-SUFFIX Numeric 3
Element: Suffix This is the suffix for the invoice.
LPD-DIST-SEQ-NBR Numeric 4
Distribution
Sequence Number
LPD-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field displays the description.
LPD-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the code
representing the currency used for the
lease transactions.
LPD-CURR-ND Numeric 1
Currency Number of This field contains the number of
Decimals decimals defined for the currency used
in the lease transaction.
LPD-RECUR-NBR Numeric 4
Element: Recurring NumbThis field contains a unique number
identifying a recurring invoice both in
this file and in the LMPAYRECUR file.
LPD-AUTH-CODE Alpha 3
Element: Authority CodeThis field contains the authority code
of the person responsible for releasing
the invoice for payment.
LPD-DUE-DATE Numeric 8 (yyyymmdd)
Element: Due Date This field contains the due date for
the payment.
LPD-PAYMENT-AMT Signed 15.2
Element: Payment NumberThis 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 Alpha 12
Element: Compute Name 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 Numeric 4
Element: Compute CompanThis field contains the company from
which the compute parameters pull their
data.
LPD-COMPANY-GROUP Alpha 12
Element: Company Group This field contains the company group
from which the compute parameters pull
their data.
LPD-AU-MATRIX-LIST Alpha 12
Element: Company MatrixThis field contains the matrix list
from which the compute parameters pull
their data.
LPD-ACCT-UNIT Alpha 15
Element: Accounting UniThis field contains the accounting unit
from which the compute parameters pull
their data.
LPD-FR-ACCOUNT Numeric 6
Element: Beginning AccoThis field contains the first account
in a range of accounts from which the
compute parameters pull their data.
LPD-TH-ACCOUNT Numeric 6
Element: End Account This field contains the last account in
a range of accounts from which the
compute parameters pull their data.
LPD-FR-SUB-ACCT Numeric 4
Element: Beginning SubaThis field contains the first
sub-account in a range of accounts from
which the compute parameters pull their
data.
LPD-TH-SUB-ACCT Numeric 4
Element: End SubaccountThis field contains the last
sub-account in a range of accounts from
which the compute parameters pull their
data.
LPD-ACCOUNT-GROUP Alpha 12
Element: Account Group This field contains the account group
from which the compute parameters pull
their data.
LPD-SUB-ACCT-GRP Alpha 12
Element: End SubaccountThis field contains the sub-account
group from which the compute parameters
pull their data.
LPD-GL-BUDGET-NBR Numeric 3
Element: Budget Number This field contains the budget number
associated with the compute parameters.
LPD-VENDOR-INV-NBR Alpha 22
Vendor Invoice This field contains the vendor-defined
Number invoice number.
LPD-RELEASED-FL Alpha 1 AP30.4
Element: Released Flag This flag indicates whether this payment
schedule record has been released to the
Accounts Payable system. Valid values
are:
Y = Yes
N = No
LPD-BASE-CURRENCY Alpha 5
Element: Base Currency Code
LPD-BASE-PMT-AMT Signed 15.2
Element: Base Payment Amount
LPD-BASE-CURR-RATE Signed 12.6
Element: Base Exchange This field contain the currency exchange
rate for the lease company base
currency.
LPD-BASE-ND Numeric 1
Base Currency Nbr
of Decimals
LMPAYDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LPDSET1 COMPANY This index retrieves the lease payment AP30.4
LEASE detail records.
PMT-VENDOR
PMT-NBR
EXEC-CODE
LPDSET2 COMPANY This index retrieves the lease payment
LEASE detail records.
PMT-VENDOR KeyChange
PMT-NBR*
EXEC-CODE
LPDSET3 COMPANY This index retrieves the lease payment
LEASE detail records.
DUE-DATE KeyChange
PMT-VENDOR
PMT-NBR
EXEC-CODE
LPDSET4 COMPANY KeyChange, Subset
PMT-VENDOR Where (DIST-SEQ-NBR != Zeroes )
LEASE
PMT-NBR
SUFFIX
DIST-SEQ-NBR
LPDSET5 COMPANY KeyChange
LEASE
EXEC-CODE
PMT-VENDOR
PMT-NBR
LPDSET6 COMPANY
LEASE
PMT-VENDOR
RECUR-NBR
PMT-NBR
EXEC-CODE
LMPAYDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apinvoice APINVOICE
LPD-COMPANY -> API-COMPANY
LPD-PMT-VENDOR -> API-VENDOR
LPD-LEASE -> API-INVOICE
LPD-SUFFIX -> API-SUFFIX
API-CANCEL-SEQ
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
|
