LMINVOICE

Invoices

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
Element: Company
Numeric 4
This field contains the Accounts Payable company associated with the invoice.
INV-LEASE
Element: Lease
Alpha 19
This is the lease ID as defined using LM21.1 or LM21.2.
INV-PMT-VENDOR
Element: Payment Vendor
Alpha 9 (Right Justified)
This is the payment vendor or lessor associated with the lease payment.
INV-PMT-NBR
Element: Payment Number
Numeric 6
This is the payment number for the lease invoice, derived from the lease payment schedule.
INV-INVOICE
Element: Invoice
Alpha 22
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
Element: Suffix
Numeric 3
This field contains the invoice suffix used to make a recurring invoice instance unique.
INV-CANCEL-SEQ
Invoice
Cancellation Number
Numeric 4
An automatically assigned sequence number.
AP30.4
INV-STATUS
Element: Status
Numeric 1
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
Element: Authority Code
Alpha 3
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
Element: Process Level
Alpha 5
This field contains the process level assigned to the invoice. Must be a valid record in the Accounts Payable system.
INV-HANDLING-CODE
Element: Handling Code
Alpha 4
This field contains the handling code specifying invoice rules. The handling code is defined in the Invoice Matching (MA) system.
INV-VOUCHER-NBR
Element: Voucher Number
Alpha 10
This field containd the user-defined voucher number for the invoice.
INV-ACCR-CODE
Element: Accrual Code
Alpha 4
INV-INVOICE-TYPE
Element: Invoice Type
Alpha 1
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
Lease Currency
Invoice Amount
Signed 18.2
This field contains the amount of the invoice in the invoice currency (which is also the lease currency).
INV-TRAN-CURR
Element: Lease Currency Code
Alpha 5
This field contains the transaction currency.
INV-TRAN-ND
Element: Number of Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
INV-BASE-INV-AMT
Base Currency
Invoice Amount
Signed 18.2
This field contains the invoice amount in compaby base currency.
INV-BASE-CURR
Element: Base Currency Code
Alpha 5
This field contains the company base currency.
INV-BASE-ND
Base Currency Nber
of Decimals
Numeric 1
The number of decimal positions defined for the company base currency.
INV-ORIG-CNV-RATE
Original Exchange
Rate
Signed 14.7
INV-INVOICE-DATE
Element: Invoice Date
Numeric 8 (yyyymmdd)
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
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the invoice.
INV-DUE-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
This field contains the invoice due date. It is used by the Accounts Payable system to select the invoice for payment.
INV-DISTRIB-DATE
Element: Posting Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
INV-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Contains the fiscal year for the data stored on this record.
INV-PERIOD
Element: Period
Numeric 2
This is the current accounting period. This field is updated by Period Closing (GL199).
INV-APPROVED-FLAG
Element: Approved Flag
Alpha 1
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
Element: Cancellation Flag
Alpha 1
This field contains the canceled flag. Vaid values are: Y = Yes N = No
AP30.4
INV-CANCELLED-AP
Element: AP Cancellation Flag
Derived
This flag is set in the Accounts Payable system if Cancelled Flag is set to Yes.
INV-CANCELLED-LM
Element: LM Cancellation Flag
Derived
This flag is set in the Lease management system if Canceled Flag is set to Yes.
INV-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
A user-defined code that represents a vendor's remittance address.
INV-TRAN-TAX-AMT
Element: Intl Amt
Signed 18.2
INV-BASE-TAX-AMT
Element: Intl Amt
Signed 18.2
INV-TRAN-TAXABLE
Element: Intl Amt
Signed 18.2


LMINVOICE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
INVSET1 COMPANY
LEASE
PMT-NBR
PMT-VENDOR
CANCEL-SEQ
AP30.4
INVSET10 COMPANY
LEASE
FISCAL-YEAR*
PERIOD*
PMT-NBR*
PMT-VENDOR
CANCEL-SEQ
KeyChange
INVSET11 COMPANY
LEASE
DUE-DATE*
PMT-NBR*
PMT-VENDOR
CANCEL-SEQ
KeyChange
INVSET2 COMPANY
AUTH-CODE
PMT-VENDOR
LEASE
PMT-NBR
DUE-DATE
KeyChange, Subset
Where(CANCEL-SEQ =Zeroes)
And(STATUS =Zeroes)
INVSET3 COMPANY
LEASE
PMT-VENDOR
PMT-NBR
KeyChange, Subset
Where(CANCEL-SEQ =Zeroes)
And(STATUS =Zeroes)
INVSET4 COMPANY
APPROVED-FLAG
AUTH-CODE
LEASE
PMT-NBR
PMT-VENDOR
KeyChange, Subset
Where(CANCEL-SEQ =Zeroes)
And(STATUS =Zeroes)
INVSET6 COMPANY
LEASE
DUE-DATE
PMT-NBR
PMT-VENDOR
CANCEL-SEQ
KeyChange
INVSET7 COMPANY
PMT-VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
KeyChange
AP30.4 APCP.1
INVSET8 COMPANY
PMT-VENDOR
LEASE
PMT-NBR
KeyChange, Subset
Where(CANCEL-SEQ =Zeroes)
And(STATUS =Zeroes)
INVSET9 COMPANY
LEASE
FISCAL-YEAR
PERIOD
PMT-VENDOR
PMT-NBR
CANCEL-SEQ
KeyChange


LMINVOICE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
Lmtrans LMTRANS
INV-COMPANY->LMT-COMPANY
INV-LEASE->LMT-LEASE
INV-PMT-NBR->LMT-PMT-NBR
INV-PMT-VENDOR->LMT-PMT-VENDOR
INV-CANCEL-SEQ->LMT-CANCEL-SEQ
  LMT-SEQ-NBR


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

Home
Contact Us



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