LMINVAU

Lease Mngmt Invoice Audit
UPDATED BY
AP30.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LIA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
LIA-COMPANY
Element: Company		Numeric 4
AP30.4
LIA-LEASE
Element: Lease		Alpha 19
AP30.4
LIA-PMT-NBR
Element: Pmt Nbr		Numeric 6
AP30.4
LIA-PMT-VENDOR
Element: Pmt Vendor		Alpha 9 (Right Justified)
AP30.4
LIA-CANCEL-SEQ
Element: Cancel Seq		Numeric 4
AP30.4
LIA-ACTION
Element: Action		Alpha 1
AP30.4
LIA-OPERATOR
Element: Operator		Alpha 10
AP30.4
LIA-DATE
Element: Date		Numeric 8 (yyyymmdd)
AP30.4
LIA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
AP30.4
LIA-PROGRAM
Element: Program Code		Alpha 5
AP30.4
LIA-FIELD-NAME
Element: Field Name		Alpha 20 (Lower Case)
AP30.4
LIA-FIELD-ID
Element: Field Id		Numeric 3
AP30.4
LIA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
AP30.4
LIA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
AP30.4


LMINVAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LIASET1 COMPANY
LEASE
PMT-NBR
PMT-VENDOR
CANCEL-SEQ
ACTION
DATE
TIME
UNIQUE-I-D
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


LMINVAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

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

Home
Contact Us



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