PR_EST_PROMOTION_INFO

Description: |
This table extracts promotion-related information that is present in the estimate.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ESTIMATE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ESTIMATE_ID | NUMERIC | No |
The unique identifier for the patient estimate record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | PROMOTION_ID | NUMERIC | No |
The promotion records applied to the estimate.
4 | PROMOTION_ID_PROMOTION_NAME | VARCHAR | No |
The promotion record name.
5 | DISCOUNT_AMOUNT | NUMERIC | No |
The flat discount amount associated with the promotion record at the time the promotion was added to the estimate.
6 | DISCOUNT_PERCENT | NUMERIC | No |
The promotion discount percent at the time the promotion was applied to the estimate.
7 | OVERRIDE_DISCOUNT_AMOUNT | NUMERIC | No |
The promotion discount amount if overridden by the user.
8 | OVERRIDE_DISCOUNT_PERCENT | NUMERIC | No |
The discount percent amount if it was overridden by the user.