Order Audit Extract
Description
This report provides a list of modifications made in tables of the Order database. The report can target a specific table or include all of them. It allows users to pick one or more columns from the selected tables and to specify a time frame to further refine results. The report can also filter results based on the identifiers of up to two modified related entities in the selected tables. The report can further filter on the identifier of a modified entity within the table, and/or a transaction order number.
Parameters
Scope selection is not relevant for audit reports.
From and To: Defines the start and end dates of the data time range.
Table Name: Presents tables which have been modified at least once, i.e., which have at least one entry in the audit table.
Column Name: Choose from columns available in the tables.
Last Modified By: Restricts results to modifications made by a specific individual.
Entity ID: If you know the identifier of the entity you are attempting to audit, enter it here to limit results to this entity only.
Transaction Order Number: Restricts results to a single order using the order number found in the Order Management application.
| 1. | Click Generate to obtain Order Audit Extracts. |
Figure 1 - Order Audit Extract parameters
Results
Each row represents a modification in the selected tables.
Additional fields may appear in the report to reflect the configuration of your client accounts.
Figure 2 - Order Audit Extract
| column header | description | examples | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Audit ID | Each audit entry is assigned a number. Depending on the filters you have selected, the relevant audit entries will be added to your report. |
63, 117 |
|||||||||
| Last Modification Date | Date and time when the modification occurred. |
2020-08-05 15:58:09.61 |
|||||||||
| Last Modified by | Name of the user who performed the modification. |
jeanwalter.smith@orckestra.com |
|||||||||
| Description | Description of the modification. |
field AllowsShipmentChanges was updated |
|||||||||
| Application Name | Name of the Orchestration Console application in which the modification was made. |
|
|||||||||
| Operation | Nature of the modification. |
|
|||||||||
| Table Name | Name of the modified table. |
ShipmentFulfillmentState |
|||||||||
| Column Name | Name of the column in which the modification was done. |
FulfillmentProviderID |
|||||||||
| Entity ID | Identifier of the modified entity. |
0fd7eec9-6c2d-4b04-af86-fe81b82a0cf4 |
|||||||||
| Transaction Order Number | Identifier that creates a link between all the components that make up an order (such as shipment ID, payment ID, etc.) |
1001 |
|||||||||
| Old Value | Value present prior to the modification. |
2112 |
|||||||||
| New Value | Value present after the modification. |
11/3/2021 2:49:43 PM |
|||||||||
| Batch ID | Batch in which the changes were made. A single batch can contain multiple modifications. |
df8c0181-752e-4f7a-b816-61dbf21d822f |
Permissions
Report Administrator
REFERENCES
| • | Managing Reports and Extracts |
| • | Generating Analytics Reports and Extracts |
| • | Exporting, Downloading Analytics Reports |