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.