LMINVOICE – Lease Invoice
- System
- LM (LM)
- Prefix
INV- Primary key
COMPANY,LEASE,PMT-NBR,PMT-VENDOR,CANCEL-SEQ- Fields
- 35
- Updated by
- 1 program
- Referenced by
- 1 program
LMINVOICE is the Lease Invoice table in Lawson LM (prefix INV). It is indexed by COMPANY, LEASE, PMT-NBR, PMT-VENDOR, CANCEL-SEQ (INVSET1); alternate indexes: INVSET10, INVSET11, INVSET2, INVSET3, INVSET4, INVSET6, INVSET7, INVSET8 and 1 more. It is related 1:1 to APAPIHIST, APCOMPANY, APINVOICE, APVENMAST and LMLEASE and 1:M to LMDISTRIB, LMINVAU, LMPAYDTL and LMTRANS. It is updated by AP30.4 and referenced by APCP.1. The table has 35 fields, 10 indexes and 9 documented relations.
About LMINVOICE
This file stores the invoices generated from a lease payment schedule. These invoices can be edited and sent on to the Accounts Payable system.
Fields (35)
Column = COBOL field name without the INV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
INV-COMPANY PKCOMPANY | Numeric 4 | This field contains the Accounts Payable company associated with the invoice. | — |
INV-LEASE PKLEASE | Alpha 19 | This is the lease ID as defined using LM21.1 or LM21.2. | — |
INV-PMT-VENDOR PKPMT_VENDOR | Alpha 9 (Right Justified) | This is the payment vendor or lessor associated with the lease payment. | — |
INV-PMT-NBR PKPMT_NBR | Numeric 6 | This is the payment number for the lease invoice, derived from the lease payment schedule. | — |
INV-INVOICEINVOICE | 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-SUFFIXSUFFIX | Numeric 3 | This field contains the invoice suffix used to make a recurring invoice instance unique. | — |
INV-CANCEL-SEQ PKCANCEL_SEQ | Numeric 4 | An automatically assigned sequence number. | AP30.4 |
INV-STATUSSTATUS | Numeric 1 | This field contains the invoice status. Valid values are: NOTE: If the status of the invoice is Unreleased, the distribution posting status must be Unposted.
| — |
INV-AUTH-CODEAUTH_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-LEVELPROC_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-CODEHANDLING_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-NBRVOUCHER_NBR | Alpha 10 | This field containd the user-defined voucher number for the invoice. | — |
INV-ACCR-CODEACCR_CODE | Alpha 4 | — | — |
INV-INVOICE-TYPEINVOICE_TYPE | Alpha 1 | This field contains the invoice type. Valid values are: invoice. Increases the amount owed to the vendor.
| — |
INV-TRAN-INV-AMTTRAN_INV_AMT | Signed 18.2 | This field contains the amount of the invoice in the invoice currency (which is also the lease currency). | — |
INV-TRAN-CURRTRAN_CURR | Alpha 5 | This field contains the transaction currency. | — |
INV-TRAN-NDTRAN_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | — |
INV-BASE-INV-AMTBASE_INV_AMT | Signed 18.2 | This field contains the invoice amount in compaby base currency. | — |
INV-BASE-CURRBASE_CURR | Alpha 5 | This field contains the company base currency. | — |
INV-BASE-NDBASE_ND | Numeric 1 | The number of decimal positions defined for the company base currency. | — |
INV-ORIG-CNV-RATEORIG_CNV_RATE | Signed 14.7 | — | — |
INV-INVOICE-DATEINVOICE_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-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the description of the invoice. | — |
INV-DUE-DATEDUE_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-DATEDISTRIB_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | — |
INV-FISCAL-YEARFISCAL_YEAR | Numeric 4 | Contains the fiscal year for the data stored on this record. | — |
INV-PERIODPERIOD | Numeric 2 | This is the current accounting period. This field is updated by Period Closing (GL199). | — |
INV-APPROVED-FLAGAPPROVED_FLAG | Alpha 1 | If the invoice requires approval, this field indicates the approval status of the invoice. Valid values are:
| — |
INV-CANCELLED-FLCANCELLED_FL | Alpha 1 | This field contains the canceled flag. Vaid values are:
| AP30.4 |
INV-CANCELLED-APCANCELLED_AP | Derived | This flag is set in the Accounts Payable system if Cancelled Flag is set to Yes. | — |
INV-CANCELLED-LMCANCELLED_LM | Derived | This flag is set in the Lease management system if Canceled Flag is set to Yes. | — |
INV-REMIT-TO-CODEREMIT_TO_CODE | Alpha 4 | A user-defined code that represents a vendor's remittance address. | — |
INV-TRAN-TAX-AMTTRAN_TAX_AMT | Signed 18.2 | — | — |
INV-BASE-TAX-AMTBASE_TAX_AMT | Signed 18.2 | — | — |
INV-TRAN-TAXABLETRAN_TAXABLE | Signed 18.2 | — | — |
Indexes (10)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
INVSET1 | COMPANY, LEASE, PMT-NBR, PMT-VENDOR, CANCEL-SEQ | Primary | 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 | — |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (4) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 | ||
| Lminvau | LMINVAU | INV-COMPANY → LIA-COMPANY, INV-LEASE → LIA-LEASE, INV-PMT-NBR → LIA-PMT-NBR, INV-PMT-VENDOR → LIA-PMT-VENDOR, INV-CANCEL-SEQ → LIA-CANCEL-SEQ, LIA-ACTION, LIA-DATE, LIA-TIME, LIA-UNIQUE-I-D | ||
| 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 |
Programs
Updated by (1)
- AP30.4 Invoice Cancel
Referenced by (1)
- APCP.1 APC Comments