BI_CVW_TransEditSummary – Overview

Purpose

The BI_CVW_TransEditSummary view provides a consolidated summary of transaction edits, including financial changes, status updates, and operator activity.
Use this view to audit transaction modifications, review payment details, and track edits across stores.

Transaction Details

• Transaction Description – Reason or code describing the edit

• Batch Number – Batch associated with the edit

• Store – Location where the transaction occurred

• Contract Number (ContractNo) – Associated contract

• Operator – User who performed the edit

• Transaction Date – Date of the transaction

• Date Out – Date the contract or item was checked out

Status Information

• Primary Status – Main transaction status (from edit or original transaction)

• Secondary Status – Additional status classification

• Derived Status Label – System-generated label indicating:

  • Edit status

  • Original transaction status

  • “Change” (indicates a modification to the original transaction)

Note: Status labels are determined by system logic based on the type of edit and transaction state.

Financial Data

• Rent – Rental charges

• Sale – Sales charges

• DW (Damage Waiver) – Damage waiver amount

• Tax – Applied taxes

• Other Charges – Additional fees

• Paid – Total amount paid

Payment Information

• PayType – Payment method used (e.g., cash, card, etc.)

Common Use Cases

Use this view to:

• Audit transaction edits and identify who made changes

• Track financial adjustments after the original transaction

• Analyze payment methods used during edits

• Monitor status changes and transaction corrections

Related POR Tables

This view is built from the following tables:

• TransactionEdit

• TransEditCode

• OperatorID

• TransactionStatus

• TransactionSecondaryStatus

• Transactions

• PaymentMethod