LMINVOICE FILE
This file stores the invoices generated from a lease payment schedule. These
invoices can be edited and sent on to the Accounts Payable system.
REFERENCED BY
APCP.1
UPDATED BY
AP30.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
INV-COMPANY Numeric 4
Company This field contains the Accounts
Payable company associated with the
invoice.
INV-LEASE Alpha 19
Lease This is the lease ID as defined using
LM21.1 or LM21.2.
INV-PMT-VENDOR Alpha 9 (Right Justified)
Payment Vendor This is the payment vendor or lessor
associated with the lease payment.
INV-PMT-NBR Numeric 3
Payment Number This is the payment number for the lease
invoice, derived from the lease payment
schedule.
INV-INVOICE Alpha 22
Invoice The field contains the unique invoice
number associated with the invoice. For
Lease Management, it consists of the
lease ID and payment number.
INV-SUFFIX Numeric 3
Suffix This field contains the invoice suffix
used to make a recurring invoice
instance unique.
INV-CANCEL-SEQ Numeric 4 AP30.4
Invoice The sequence number assigned upon a
Cancellation Number cancellation of a distributed invoice.
The first sequence assigned is 9999.
INV-STATUS Numeric 1
Status This field contains the invoice status.
Valid values are:
0 = Unreleased
1 = Released
9 = Posted
NOTE: If the status of the invoice is
Unreleased, the distribution posting
status must be Unposted.
INV-AUTH-CODE Alpha 3
Authority Code This field contains the authority code
of the person responsible for releasing
the invoice for payment. This code is
defined in theAccounts Payable system.
INV-PROC-LEVEL Alpha 5
Process Level This field contains the process level
assigned to the invoice. Must be a valid
record in the Accounts Payable system.
INV-HANDLING-CODE Alpha 4
Handling Code This field contains the handling code
specifying invoice rules. The handling
code is defined in the Invoice Matching
(MA) system.
INV-VOUCHER-NBR Alpha 10
Voucher Number This field containd the user-defined
voucher number for the invoice.
INV-ACCR-CODE Alpha 4
Accrual Code A user-defined code representing a
general ledger accrual account.
INV-INVOICE-TYPE Alpha 1
Invoice Type This field contains the invoice type.
Valid values are:
Blank = Regular Invoice
C = Credit Memo
H = Historical
D = Debit Memo. Processed just like an
invoice. Increases the amount owed to
the vendor.
INV-TRAN-INV-AMT Signed 15.2
Lease Currency This field contains the amount of the
Invoice Amount invoice in the invoice currency (which
is also the lease currency).
INV-TRAN-CURR Alpha 5
Lease Currency Code This field contains the transaction
currency.
INV-TRAN-ND Numeric 1
Number of Decimals The number of decimal positions defined
for the transaction currency.
INV-BASE-INV-AMT Signed 15.2
Base Currency This field contains the invoice amount
Invoice Amount in compaby base currency.
INV-BASE-CURR Alpha 5
Base Currency Code This field contains the company base
currency.
INV-BASE-ND Numeric 1
Base Currency Nber The number of decimal positions defined
of Decimals for the company base currency.
INV-ORIG-CNV-RATE Signed 12.6
Original Exchange Represents the currency exchange rate
Rate the transaction was created with.
INV-INVOICE-DATE Numeric 8 (yyyymmdd)
Invoice Date This field contains the date of the
invoice. It can be the date on which the
vendor created the invoice or the date
on which it was received. This is the
date used when updating vendor balances.
INV-DESCRIPTION Alpha 30 (Lower Case)
Description This field contains the description of
the invoice.
INV-DUE-DATE Numeric 8 (yyyymmdd)
Due Date This field contains the invoice due
date. It is used by the Accounts Payable
system to select the invoice for
payment.
INV-DISTRIB-DATE Numeric 8 (yyyymmdd)
Posting Date The date used for posting the
transactions to the general ledger.
INV-FISCAL-YEAR Numeric 4
Fiscal Year This is the current fiscal year. This
field is updated by Period Closing
(GL199).
INV-PERIOD Numeric 2
Period This is the current accounting period.
This field is updated by Period Closing
(GL199).
INV-APPROVED-FLAG Alpha 1
Approved Flag If the invoice requires approval, this
field indicates the approval status of
the invoice. Valid values are:
Y = Yes (approved)
N = No (not yet approved)
D = Disapproved (authorization denied)
INV-CANCELLED-FL Alpha 1
Cancellation Flag This field contains the canceled flag.
Vaid values are:
Y = Yes
N = No
INV-CANCELLED-AP Derived
AP Cancellation Flag This flag is set in the Accounts Payable
system if Cancelled Flag is set to Yes.
INV-CANCELLED-LM Derived
LM Cancellation Flag This flag is set in the Lease management
system if Canceled Flag is set to Yes.
LMINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INVSET1 COMPANY This index is used to retrieve and
LEASE create lease invoice records.
PMT-NBR
PMT-VENDOR
CANCEL-SEQ
INVSET10 COMPANY KeyChange
LEASE
FISCAL-YEAR*
PERIOD*
PMT-NBR*
PMT-VENDOR
CANCEL-SEQ
INVSET11 COMPANY Duplicates
LEASE
DUE-DATE*
PMT-NBR*
PMT-VENDOR
CANCEL-SEQ
INVSET2 COMPANY KeyChange, Subset
AUTH-CODE Where (CANCEL-SEQ = Zeroes )
PMT-VENDOR And (STATUS = Zeroes )
LEASE
PMT-NBR
DUE-DATE
INVSET3 COMPANY KeyChange, Subset
LEASE Where (CANCEL-SEQ = Zeroes )
PMT-VENDOR And (STATUS = Zeroes )
PMT-NBR
INVSET4 COMPANY KeyChange, Subset
APPROVED-FLAG Where (CANCEL-SEQ = Zeroes )
AUTH-CODE And (STATUS = Zeroes )
LEASE
PMT-NBR
PMT-VENDOR
INVSET5 COMPANY KeyChange, Subset
LEASE Where((STATUS = 1 )
PMT-VENDOR And (CANCEL-SEQ = Zeroes ))
PMT-NBR Or ((STATUS = 9 )
CANCEL-SEQ And (CANCEL-SEQ != Zeroes )
And (CANCELLED-FL != "Y" ))
INVSET6 COMPANY KeyChange
LEASE
DUE-DATE
PMT-NBR
PMT-VENDOR
CANCEL-SEQ
INVSET7 COMPANY KeyChange AP30.4 APCP.1
PMT-VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
INVSET8 COMPANY KeyChange, Subset
PMT-VENDOR Where (CANCEL-SEQ = Zeroes )
LEASE And (STATUS = Zeroes )
PMT-NBR
INVSET9 COMPANY KeyChange
LEASE
FISCAL-YEAR
PERIOD
PMT-VENDOR
PMT-NBR
CANCEL-SEQ
LMINVOICE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apapihist APAPIHIST Not Required
INV-COMPANY -> AH1-COMPANY (AH1SET1)
INV-PMT-VENDOR -> AH1-VENDOR
INV-INVOICE -> AH1-INVOICE
INV-SUFFIX -> AH1-SUFFIX
INV-CANCEL-SEQ -> AH1-CANCEL-SEQ
Apcompany APCOMPANY Required
INV-COMPANY -> CPY-COMPANY
Apinvoice APINVOICE Not Required
INV-COMPANY -> API-COMPANY
INV-PMT-VENDOR -> API-VENDOR
INV-INVOICE -> API-INVOICE
INV-SUFFIX -> API-SUFFIX
INV-CANCEL-SEQ -> API-CANCEL-SEQ
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
INV-PMT-VENDOR -> VEN-VENDOR
Lmlease LMLEASE Not Required
INV-COMPANY -> LSE-COMPANY
INV-LEASE -> LSE-LEASE
LMINVOICE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Lmdistrib LMDISTRIB
INV-COMPANY -> DIS-COMPANY
INV-PMT-VENDOR -> DIS-PMT-VENDOR
INV-LEASE -> DIS-LEASE
INV-PMT-NBR -> DIS-PMT-NBR
INV-CANCEL-SEQ -> DIS-CANCEL-SEQ
DIS-DIST-SEQ-NBR
Lmpaydtl LMPAYDTL
INV-COMPANY -> LPD-COMPANY
INV-LEASE -> LPD-LEASE
INV-PMT-VENDOR -> LPD-PMT-VENDOR
INV-PMT-NBR -> LPD-PMT-NBR
LPD-EXEC-CODE
|
