LMTRANS – Lease Management Transaction

System
LM (LM)
Prefix
LMT
Primary key
COMPANY, LEASE, SEQ-NBR
Fields
28
Updated by
1 program
Referenced by
0 programs

LMTRANS is the Lease Management Transaction table in Lawson LM (prefix LMT). It is indexed by COMPANY, LEASE, SEQ-NBR (LMTSET1); alternate indexes: LMTSET2, LMTSET3, LMTSET4 and LMTSET5. It is related 1:1 to GLTRANS, LMINVOICE and LMLEASE. It is updated by AP30.4. The table has 28 fields, 5 indexes and 3 documented relations.

About LMTRANS

No description in the Lawson data dictionary.

Fields (28)

Column = COBOL field name without the LMT- 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 / columnTypeDescription & valuesUpdated by
#LMT-COMPANY PK
COMPANY		Numeric 4Identifies 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.—
#LMT-LEASE PK
LEASE		Alpha 19——
#LMT-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.—
#LMT-PT-COMPANY
PT_COMPANY		Numeric 4Identifies 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.—
#LMT-ACCT-UNIT
ACCT_UNIT		Alpha 15The 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.—
#LMT-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.—
#LMT-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.—
#LMT-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.—
#LMT-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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—
#LMT-TRAN-AMT
TRAN_AMT		Signed 18.2——
#LMT-BASE-AMT
BASE_AMT		Signed 18.2——
#LMT-TO-BASE-CURR
TO_BASE_CURR		Alpha 5——
#LMT-TO-BASE-ND
TO_BASE_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—
#LMT-TO-BASE-RATE
TO_BASE_RATE		Signed 14.7The currency rate.—
#LMT-GLT-OBJ-ID
GLT_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.—
#LMT-TRAN-DATE
TRAN_DATE		Numeric 8 (yyyymmdd)——
#LMT-STATUS SET2 SET4
STATUS		Numeric 1This field displays the status of the transaction.
  • 0 Unposted
  • 9 Posted
—
#LMT-REFERENCE
REFERENCE		Alpha 10 (Lower Case)The reference number associated with the transaction.—
#LMT-ALLOC-CD
ALLOC_CD		Alpha 12——
#LMT-TYPE SET2
TYPE		Alpha 3—
  • DFR Deferred Rent
  • ACR Accrued Rent
—
#LMT-PROCESS SET2
PROCESS		Alpha 3——
#LMT-REVERSE
REVERSE		Alpha 1——
#LMT-PMT-VENDOR SET5
PMT_VENDOR		Alpha 9 (Right Justified)The vendor's identification code.—
#LMT-PMT-NBR SET4 SET5
PMT_NBR		Numeric 6——
#LMT-CANCEL-SEQ SET5
CANCEL_SEQ		Numeric 4An automatically assigned sequence number.AP30.4
#LMT-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.—
#LMT-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The creation time.—
#LMT-CREATOR-ID
CREATOR_ID		Alpha 10This field is used to store the login id of the person who entered the record.—

Indexes (5)

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.

IndexKeysFlagsConditionUsed in
LMTSET1
  1. COMPANY
  2. LEASE
  3. SEQ-NBR
Primary—
LMTSET2
  1. COMPANY
  2. LEASE
  3. TYPE
  4. PROCESS
  5. STATUS
  6. SEQ-NBR
—
LMTSET3
  1. COMPANY
  2. LEASE
  3. SEQ-NBR ↓
—
LMTSET4
  1. COMPANY
  2. STATUS
  3. LEASE
  4. PMT-NBR
  5. SEQ-NBR
AP30.4
LMTSET5
  1. COMPANY
  2. LEASE
  3. PMT-NBR
  4. PMT-VENDOR
  5. CANCEL-SEQ
  6. SEQ-NBR
KeyChange, SubsetWhere TYPE = "ACR"—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLTRANSLMINVOICELMLEASELMTRANS

One to one (3) — lookups and parents

RelationTableRulesConditionField map
GltransGLTRANSRequired
LMT-GLT-OBJ-ID→GLT-OBJ-ID (GLTSET7)
LminvoiceLMINVOICERequired
LMT-COMPANY→INV-COMPANY
LMT-LEASE→INV-LEASE
LMT-PMT-NBR→INV-PMT-NBR
LMT-PMT-VENDOR→INV-PMT-VENDOR
LMT-CANCEL-SEQ→INV-CANCEL-SEQ
LmleaseLMLEASERequired
LMT-COMPANY→LSE-COMPANY
LMT-LEASE→LSE-LEASE

Programs

Updated by (1)