LMLSEMXAU

Lease Attributes Audit
UPDATED BY
MX500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LXA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
LXA-OBJ-ID
Element: Obj Id		Numeric 12
MX500
LXA-MATRIX-CAT
Element: Matrix Cat		Alpha 12
MX500
LXA-COMPANY
Element: Company		Numeric 4
MX500
LXA-LEASE
Element: Lease		Alpha 19
MX500
LXA-ACTION
Element: Action		Alpha 1
MX500
LXA-OPERATOR
Element: Operator		Alpha 10
MX500
LXA-DATE
Element: Date		Numeric 8 (yyyymmdd)
MX500
LXA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
MX500
LXA-PROGRAM
Element: Program Code		Alpha 5
MX500
LXA-FIELD-NAME
Element: Field Name		Alpha 20 (Lower Case)
MX500
LXA-FIELD-ID
Element: Field Id		Numeric 3
MX500
LXA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
MX500
LXA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
MX500


LMLSEMXAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LXASET1 OBJ-ID
MATRIX-CAT
COMPANY
LEASE
ACTION
DATE
TIME
UNIQUE-I-D
LXASET2 MATRIX-CAT
COMPANY
LEASE
OBJ-ID
ACTION
DATE
TIME
UNIQUE-I-D
LXASET3 COMPANY
LEASE
MATRIX-CAT
OBJ-ID
ACTION
DATE
TIME
UNIQUE-I-D
LXASET4 OPERATOR
ACTION
DATE
OBJ-ID
MATRIX-CAT
COMPANY
LEASE
UNIQUE-I-D
LXASET5 ACTION
DATE
OBJ-ID
MATRIX-CAT
COMPANY
LEASE
UNIQUE-I-D
LXASET6 DATE
COMPANY
LEASE
MATRIX-CAT
OBJ-ID
ACTION
UNIQUE-I-D
LXAUID UNIQUE-I-D


LMLSEMXAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Lmlsemxval LMLSEMXVAL Required
LXA-OBJ-ID->LXV-OBJ-ID (LXVSET1)
LXA-MATRIX-CAT->LXV-MATRIX-CAT

File created: Thu Jun 09 02:21:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.