TD_ACTUAL_CONS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: TD_PROMO_CUST.SETID Prompt Table: SP_SETTD_NONVW
2	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code Default Value: TD_PROMO_CUST.PPRC_PROMO_CD Prompt Table: PPRC_PROMO_TBL
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Default Value: TD_PROMO_CUST.CUST_ID Prompt Table: %EDITTABLE
4	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type Default Value: TD_PROMO_MERCH.MERCH_TYPE Prompt Table: TD_MERCH_TYP_VW Set Control Field: SETID
5	UNITS_REDEEMED	Number(16,4)	DECIMAL(15,4) NOT NULL	Actual Units Redeemed
6	INC_UNITS_RED	Number(16,4)	DECIMAL(15,4) NOT NULL	Incurred Units Redeemed
7	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
8	ENTERED_DT	Date(10)	DATE	Entered on
9	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
10	LAST_UPDATE_DT	Date(10)	DATE	Last Updated