Sheet_Customer_Order_Tracking_History

Track and analyze historical customer order data using the Sheet_Customer_Order_Tracking_History.

Columns


Name	Type	ReadOnly	References	Description
RowId [KEY]	String	False		A unique identifier for each row in the order tracking history, corresponding to the API field for record identification.
PO	String	False		The purchase order number associated with the customer order, retrieved from the API.
PO Date	Datetime	False		The date when the purchase order was created, as specified in the API data.
Ship Date	Datetime	False		The date the order was shipped, sourced from the API field tracking shipment details.
Shipped Via	String	False		The shipping carrier or method used for the order, as recorded in the API.
Invoice Amount	String	False		The total amount billed on the invoice for the order, provided by the API.
Invoice Number	String	False		The unique identifier for the invoice related to the order, matching the API data.
Inv Date	Datetime	False		The date the invoice was generated for the order, as recorded in the API.
Terms	String	False		The payment terms agreed upon for the invoice, as defined in the API.
Paid	Boolean	False		Indicates whether the invoice has been fully paid (true) or not (false), based on API data.
Date Paid	Datetime	False		The date when the invoice payment was completed, if applicable, from the API.
Payment	String	False		Details about the payment method or transaction used for settling the invoice, as sourced from the API.
Check #	String	False		The check number associated with the payment, if a check was used, as recorded in the API.