U04 End of Period
U0445 Missing Auxiliary File Elements
| EOP Only | Yes |
| Frequency | Daily |
| Sequential Updates | Yes |
| Skip Notes | Recommend not skipping. Should be run at least periodically to help ensure database integrity |
For more information about End of Period,
refer to U04 End of Period Overview.
Sequential Updates: This EOP module runs as part of U0411 Sequential Updates.
This module checks for inconsistencies in the database with respect to the main data files. For example, if broker code 10 is deleted but there are leases on file with that broker code, this module reports that broker code 10 is used but is undefined on the auxiliary files.
The following items are checked:
- req Asset record missing
- rdm Demographic record missing
- Lease form code
- Broker
- Investor
- Guarantor
- Credit approval officer
- Funding approval officer
- Document approval officer
- Customer and group combination
- Base rate code
- Manufacturer and model combination
- City and state combination
- City
- City name
State codes req.st_s "State" (rst.st_s equivalent) and req.eq_st_s "Equipment state" should match. Contact your NETSOL representative if these do not match
Reference Guide |
Table of Contents
© 2025 NETSOL Technologies. All rights reserved.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.