Invoice fields Subscription From Date and To Date on ARC
- Article Type: Q&A
- Product: Aleph
- Product Version: 3
Question
Where in Query Studio does one find the Subscription From Date and To Date elements found on an invoice
Answer
The Invoice line items (Z75) are not reflected in ARC, therefore the Subscription From Date (z75_i_date_from) and To Date (z75_i_date_to) are also not included.
Additional Information
The only dates for subscription are the fields from the Aleph subscription record (z16): z16_copy_from_date and z16_copy_to_date which might be helpful instead.
Category: ARC
Subject: Extract - ARC
- Article last edited: 12/20/2013