LMDSTRIBAU

Lease Mngmnt Distrib Audit
UPDATED BY
AP30.4

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


LMDSTRIBAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LDUSET1 COMPANY
PMT-VENDOR
LEASE
PMT-NBR
CANCEL-SEQ
DIST-SEQ-NBR
ACTION
DATE
TIME
UNIQUE-I-D
LDUSET2 OPERATOR
ACTION
DATE
COMPANY
PMT-VENDOR
LEASE
PMT-NBR
CANCEL-SEQ
DIST-SEQ-NBR
UNIQUE-I-D
LDUSET3 ACTION
DATE
COMPANY
PMT-VENDOR
LEASE
PMT-NBR
CANCEL-SEQ
DIST-SEQ-NBR
UNIQUE-I-D
LDUSET4 DATE
COMPANY
PMT-VENDOR
LEASE
PMT-NBR
CANCEL-SEQ
DIST-SEQ-NBR
ACTION
UNIQUE-I-D
LDUUID UNIQUE-I-D


LMDSTRIBAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Lmdistrib LMDISTRIB Required
LDU-COMPANY->DIS-COMPANY (DISSET1)
LDU-PMT-VENDOR->DIS-PMT-VENDOR
LDU-LEASE->DIS-LEASE
LDU-PMT-NBR->DIS-PMT-NBR
LDU-CANCEL-SEQ->DIS-CANCEL-SEQ
LDU-DIST-SEQ-NBR->DIS-DIST-SEQ-NBR

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

Home
Contact Us



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