lien_workfile

lien_workfile

Lien_workfile is a database table used by Lien Processing in the Inquiry.

Notes:

For information about interpreting EDIFICE Tables, see Understanding EDIFICE Tables.
To view other EDIFICE Tables, see the EDIFICE Database Overview.

lien_workfile
Field
Row_Index	INT	11
Batch_ID	VARCHAR	36
Customer_ID	VARCHAR	12
Location_ID	VARCHAR	12
Transaction_Invoice_ID	VARCHAR	10
Service_Code	INT	11
Company_Number	INT	11
Finance_Period	INT	11
Book_Number	INT	11
Principal_Amount	DECIMAL	14,2
Interest_Amount	DECIMAL	14,2
Principal_Payments	DECIMAL	14,2
Interest_Payments	DECIMAL	14,2
Lien_Workfile_Status	INT	11
Original_Interest_Stop_Date	DATE
Last_Notice_Job	VARCHAR	255
Last_Notice_By	VARCHAR	100
Last_Notice_Date	DATE
Last_Updated_By	VARCHAR	100
Last_Updated_Date	DATETIME