LMINVAU – Lease Mngmt Invoice Audit

System
LM (LM)
Prefix
LIA
Primary key
COMPANY, LEASE, PMT-NBR, PMT-VENDOR, CANCEL-SEQ, ACTION, DATE, TIME, UNIQUE-I-D
Fields
15
Updated by
1 program
Referenced by
0 programs

LMINVAU is the Lease Mngmt Invoice Audit table in Lawson LM (prefix LIA). It is indexed by COMPANY, LEASE, PMT-NBR, PMT-VENDOR, CANCEL-SEQ, ACTION, DATE, TIME, UNIQUE-I-D (LIASET1); alternate indexes: LIASET2, LIASET3, LIASET4 and LIAUID. It is related 1:1 to LMINVOICE. It is updated by AP30.4. The table has 15 fields, 5 indexes and 1 documented relation.

About LMINVAU

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the LIA- 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
#LIA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#LIA-COMPANY PK
COMPANY		Numeric 4—AP30.4
#LIA-LEASE PK
LEASE		Alpha 19—AP30.4
#LIA-PMT-NBR PK
PMT_NBR		Numeric 6—AP30.4
#LIA-PMT-VENDOR PK
PMT_VENDOR		Alpha 9 (Right Justified)—AP30.4
#LIA-CANCEL-SEQ PK
CANCEL_SEQ		Numeric 4—AP30.4
#LIA-ACTION PK
ACTION		Alpha 1—AP30.4
#LIA-OPERATOR SET2
OPERATOR		Alpha 10—AP30.4
#LIA-DATE PK
DATE		Numeric 8 (yyyymmdd)—AP30.4
#LIA-TIME PK
TIME		Numeric 6 (hhmmss)—AP30.4
#LIA-PROGRAM
PROGRAM		Alpha 5—AP30.4
#LIA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—AP30.4
#LIA-FIELD-ID
FIELD_ID		Numeric 3—AP30.4
#LIA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—AP30.4
#LIA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—AP30.4

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
LIASET1
  1. COMPANY
  2. LEASE
  3. PMT-NBR
  4. PMT-VENDOR
  5. CANCEL-SEQ
  6. ACTION
  7. DATE
  8. TIME
  9. UNIQUE-I-D
Primary—
LIASET2
  1. OPERATOR
  2. ACTION
  3. DATE
  4. COMPANY
  5. LEASE
  6. PMT-NBR
  7. PMT-VENDOR
  8. CANCEL-SEQ
  9. UNIQUE-I-D
—
LIASET3
  1. ACTION
  2. DATE
  3. COMPANY
  4. LEASE
  5. PMT-NBR
  6. PMT-VENDOR
  7. CANCEL-SEQ
  8. UNIQUE-I-D
—
LIASET4
  1. DATE
  2. COMPANY
  3. LEASE
  4. PMT-NBR
  5. PMT-VENDOR
  6. CANCEL-SEQ
  7. ACTION
  8. UNIQUE-I-D
—
LIAUID
  1. UNIQUE-I-D
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
LminvoiceLMINVOICERequired
LIA-COMPANY→INV-COMPANY (INVSET1)
LIA-LEASE→INV-LEASE
LIA-PMT-NBR→INV-PMT-NBR
LIA-PMT-VENDOR→INV-PMT-VENDOR
LIA-CANCEL-SEQ→INV-CANCEL-SEQ

Programs

Updated by (1)