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.

Field / column	Type	Description & values	Updated 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` 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`LIASET1`	`COMPANY`, `LEASE`, `PMT-NBR`, `PMT-VENDOR`, `CANCEL-SEQ`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`	Primary	—
`LIASET2`	`OPERATOR`, `ACTION`, `DATE`, `COMPANY`, `LEASE`, `PMT-NBR`, `PMT-VENDOR`, `CANCEL-SEQ`, `UNIQUE-I-D`		—
`LIASET3`	`ACTION`, `DATE`, `COMPANY`, `LEASE`, `PMT-NBR`, `PMT-VENDOR`, `CANCEL-SEQ`, `UNIQUE-I-D`		—
`LIASET4`	`DATE`, `COMPANY`, `LEASE`, `PMT-NBR`, `PMT-VENDOR`, `CANCEL-SEQ`, `ACTION`, `UNIQUE-I-D`		—
`LIAUID`	`UNIQUE-I-D`		—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Lminvoice	LMINVOICE	Required		`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)

AP30.4 Invoice Cancel