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
TimeKey	Incremental temporal value	Integer
OrderId	Unique order identifier	Integer
OrderItemId	Order item number	Integer
OrderCreatedDate	Order creation date	Datetime
OrderSentDate	Order dispatch 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 comes from an order, an RFQ, or a request	String
CurrentProcess	Current process phase, e.g., invoice, order, pre-order, RFQ, or request	String
OrderOwnerId	ID of the person responsible for the order	Integer
RequestOwnerId	ID of the person responsible for the request	Integer
PreOrderOwnerId	ID of the person responsible for the pre-order	Integer
RfqOwnerId	ID of the person responsible for the RFQ	Integer
InvoiceOwnerId	ID of the person responsible for the invoice	Integer
ProductId	Unique product identifier	Integer
OrderQuantity	Quantity of the order item	Double
RequestQuantity	Quantity of the request item	Double
PreOrderQuantity	Quantity of the pre-order item	Double
RfqQuantity	Quantity of the RFQ item	Double
InvoiceQuantity	Quantity of the invoice item	Double
RequestItemStateType	State of the request item (e.g., InOrder, InRfq, Canceled, InPreOrder, InRequest, InPurchasePendency)	String
ContractId	Primary key for the Contracts schema	Integer
ContractItemId	Contract item number	Integer
ContractCreatedDate	Contract creation date	Datetime
ContractOwnerId	ID of the person responsible for the contract	Integer
TrackingId	Tracking identifier	String

TrackingTransactions Schema Joins

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

• OrderId
• OrderItemId
• OrderCreatedDate
• OrderSentDate
• RequestId
• RequestItemId
• RequestCreatedDate
• PreOrderId
• PreOrderItemId
• PreOrderCreatedDate
• RfqId
• RfqItemId
• RfqCreatedDate
• InvoiceId
• InvoiceItemId
• InvoiceCreatedDate
• OriginProcess
• CurrentProcess