LMINTEREST – No description in the Lawson data dictionary
- System
- LM (LM)
- Prefix
LEI- Primary key
COMPANY,PMT-VENDOR,LEASE,PMT-NBR,CANCEL-SEQ,DIST-SEQ-NBR,INT-SEQ-NBR- Fields
- 22
- Updated by
- 1 program
- Referenced by
- 0 programs
LMINTEREST is a Lawson LM table (prefix LEI); no description in the lawson data dictionary. It is indexed by COMPANY, PMT-VENDOR, LEASE, PMT-NBR, CANCEL-SEQ, DIST-SEQ-NBR, INT-SEQ-NBR (LEISET1). It is related 1:1 to LMDISTRIB. It is updated by AP30.4. The table has 22 fields, 1 index and 1 documented relation.
About LMINTEREST
No description in the Lawson data dictionary.
Fields (22)
Column = COBOL field name without the LEI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#LEI-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | — |
#LEI-PMT-VENDOR PKPMT_VENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | — |
#LEI-LEASE PKLEASE | Alpha 19 | — | — |
#LEI-PMT-NBR PKPMT_NBR | Numeric 6 | — | — |
#LEI-CANCEL-SEQ PKCANCEL_SEQ | Numeric 4 | An automatically assigned sequence number. | AP30.4 |
#LEI-DIST-SEQ-NBR PKDIST_SEQ_NBR | Numeric 6 | A unique sequence number. | — |
#LEI-INT-SEQ-NBR PKINT_SEQ_NBR | Numeric 4 | An automatically assigned sequence number. | — |
#LEI-INT-COMPANYINT_COMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | — |
#LEI-INT-ACCT-UNITINT_ACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | — |
#LEI-INT-ACCOUNTINT_ACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | — |
#LEI-INT-SUB-ACCTINT_SUB_ACCT | Numeric 4 | This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. | — |
#LEI-INT-ACTIVITYINT_ACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | — |
#LEI-INT-ACCT-CATINT_ACCT_CAT | Alpha 5 | Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru | — |
#LEI-INTEREST-AMTINTEREST_AMT | Signed 18.2 | — | — |
#LEI-BASE-INT-AMTBASE_INT_AMT | Signed 18.2 | — | — |
#LEI-TO-BASE-AMTTO_BASE_AMT | Signed 18.2 | — | — |
#LEI-TO-BASE-PRINCTO_BASE_PRINC | Signed 18.2 | — | — |
#LEI-TO-BASE-INTTO_BASE_INT | Signed 18.2 | — | — |
#LEI-TO-BSE-INT-CURTO_BSE_INT_CUR | Alpha 5 | — | — |
#LEI-TO-BSE-INT-NDTO_BSE_INT_ND | Numeric 2 | — | — |
#LEI-TO-BSE-INT-RATTO_BSE_INT_RAT | Signed 14.7 | The currency rate. | — |
#LEI-GLT-INT-OBJ-IDGLT_INT_OBJ_ID | Numeric 12 | — | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
LEISET1 |
| Primary | AP30.4 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Lmdistrib | LMDISTRIB | Not Required |
|
Programs
Updated by (1)
- AP30.4 Invoice Cancel