Skip to content

Tracking Transactions

The following are the schemas and relationships of TrackingTransactions.

ColumnDescriptionType
IdInternal identifierString
TenantIdCustomer identifierString
UpdatedAtDate of the last record updateDatetime
SnapshotAtReference date of the transactionDatetime
OrderIdUnique order identifierInteger
OrderItemIdOrder item numberInteger
OrderCreatedDateOrder creation dateDatetime
OrderSentDateOrder submission dateDatetime
RequestIdUnique request identifierInteger
RequestItemIdRequest item numberInteger
RequestCreatedDateRequest creation dateDatetime
PreOrderIdUnique pre-order identifierInteger
PreOrderItemIdPre-order item numberInteger
PreOrderCreatedDatePre-order creation dateDatetime
RfqIdUnique RFQ identifierInteger
RfqItemIdRFQ item numberInteger
RfqCreatedDateRFQ creation dateDatetime
InvoiceIdUnique invoice identifierInteger
InvoiceItemIdInvoice item numberInteger
InvoiceCreatedDateInvoice creation dateDatetime
OriginProcessIndicates whether the source process originates from an order, quotation, or requestString
CurrentProcessCurrent process stage. For example: invoice, order, pre-order, quotation, or requestString

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