Tracking Transactions

The following are the schemas and relationships of TrackingTransactions.

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Reference date of the transaction	Datetime
OrderId	Unique order identifier	Integer
OrderItemId	Order item number	Integer
OrderCreatedDate	Order creation date	Datetime
OrderSentDate	Order submission date	Datetime
RequestId	Unique request identifier	Integer
RequestItemId	Request item number	Integer
RequestCreatedDate	Request creation date	Datetime
PreOrderId	Unique pre-order identifier	Integer
PreOrderItemId	Pre-order item number	Integer
PreOrderCreatedDate	Pre-order creation date	Datetime
RfqId	Unique RFQ identifier	Integer
RfqItemId	RFQ item number	Integer
RfqCreatedDate	RFQ creation date	Datetime
InvoiceId	Unique invoice identifier	Integer
InvoiceItemId	Invoice item number	Integer
InvoiceCreatedDate	Invoice creation date	Datetime
OriginProcess	Indicates whether the source process originates from an order, quotation, or request	String
CurrentProcess	Current process stage. For example: invoice, order, pre-order, quotation, or request	String

The TrackingTransactions schema has relationships with all tables with the following columns:

Tracking Transactions ​