which field to use as the timestamp from sales object
I am using the following query to generate a custom sales report.
I load saleLines as a relation. The sale object has timestamp, createTime, completeTime, and updateTime. The saleLines object also has fields timestamp, createTime, completeTime, and updateTime. I am looking for only completed sales. Which field should I used to determine when the sales was created (sale .createTime , sale.timestamp, saleLines .createTime , or saleLines.timestamp)?