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 table(s). 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 table(s) selected above.
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.
Results
Each row represents a modification in the selected table(s).
| 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. |
|
|||||||||
| 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. |
|
|||||||||
| Transaction Order Number | Identifier that creates a link between all the components that make up an order (such as shipment ID, payment ID, etc.) |
|
|||||||||
| Old Value | Value present prior to the modification. |
|
|||||||||
| New Value | Value present after the modification. |
|
|||||||||
| Batch ID | Batch in which the changes were made. A single batch can contain multiple modifications. |
|
Permissions
Report Administrator