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.

Field / column	Type	Description & values	Updated by
`LEI-COMPANY` PK 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-PMT-VENDOR` PK PMT_VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	—
`LEI-LEASE` PK LEASE	Alpha 19	—	—
`LEI-PMT-NBR` PK PMT_NBR	Numeric 6	—	—
`LEI-CANCEL-SEQ` PK CANCEL_SEQ	Numeric 4	An automatically assigned sequence number.	AP30.4
`LEI-DIST-SEQ-NBR` PK DIST_SEQ_NBR	Numeric 6	A unique sequence number.	—
`LEI-INT-SEQ-NBR` PK INT_SEQ_NBR	Numeric 4	An automatically assigned sequence number.	—
`LEI-INT-COMPANY` INT_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-UNIT` INT_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-ACCOUNT` INT_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-ACCT` INT_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-ACTIVITY` INT_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-CAT` INT_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-AMT` INTEREST_AMT	Signed 18.2	—	—
`LEI-BASE-INT-AMT` BASE_INT_AMT	Signed 18.2	—	—
`LEI-TO-BASE-AMT` TO_BASE_AMT	Signed 18.2	—	—
`LEI-TO-BASE-PRINC` TO_BASE_PRINC	Signed 18.2	—	—
`LEI-TO-BASE-INT` TO_BASE_INT	Signed 18.2	—	—
`LEI-TO-BSE-INT-CUR` TO_BSE_INT_CUR	Alpha 5	—	—
`LEI-TO-BSE-INT-ND` TO_BSE_INT_ND	Numeric 2	—	—
`LEI-TO-BSE-INT-RAT` TO_BSE_INT_RAT	Signed 14.7	The currency rate.	—
`LEI-GLT-INT-OBJ-ID` GLT_INT_OBJ_ID	Numeric 12	—	—

Indexes (1)

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
`LEISET1`	`COMPANY`, `PMT-VENDOR`, `LEASE`, `PMT-NBR`, `CANCEL-SEQ`, `DIST-SEQ-NBR`, `INT-SEQ-NBR`	Primary		AP30.4

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Lmdistrib	LMDISTRIB	Not Required		`LEI-COMPANY` → `DIS-COMPANY`, `LEI-PMT-VENDOR` → `DIS-PMT-VENDOR`, `LEI-LEASE` → `DIS-LEASE`, `LEI-PMT-NBR` → `DIS-PMT-NBR`, `LEI-CANCEL-SEQ` → `DIS-CANCEL-SEQ`, `LEI-DIST-SEQ-NBR` → `DIS-DIST-SEQ-NBR`

Programs

Updated by (1)

AP30.4 Invoice Cancel