What are the different due date fields in the Voyager Prepackaged Access Reports CIRC_TRANSACTIONS table?
- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Question
What are the different due date fields in the Voyager CIRC_TRANSACTIONS table?
Answer
- The current_due_date is the due date that you normally want to use for queries. It is set when the item is initially charged and changed when the item is renewed or recalled.
- The charge_due_date field is the due date at the time the item was initially charged; it never changes.
- If the item was recalled, the new due date will be in recall_due_date.
- If the item was renewed, the dates of each renewal will be in the RENEW* tables.
- Article last edited: 28-May-2020