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 |
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