TD_CNSMPTN_DATA(SQL Table) |
Index Back |
|---|---|
Consumption DataThis table holds data entered from an external source (I.R.I or ACNielsen), POS data entered by the user or could potentially hold data from demand planning, giving users information on the impact of a promotion. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_FS_VW.SETID Prompt Table: SP_SETTD_NONVW |
| 2 | 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.
Prompt Table: TD_CUST_OPRVW |
| 3 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: TD_PROD_OPRVW |
| 4 | TD_DATA_SRC |
Character(2) | VARCHAR2(2) NOT NULL |
Consumption Data Source
AC=A.C. Nielsen DP=Demand Planning IR=IRI OT=Other US=User Input |
| 5 | FROM_DATE |
Date(10) | DATE | From Date |
| 6 | TO_DATE |
Date(10) | DATE | To Date |
| 7 | UPC_ID | Character(18) | VARCHAR2(18) NOT NULL | Uniform Product Code ID |
| 8 | EXT_CUST_ID | Character(10) | VARCHAR2(10) NOT NULL | External Customer ID |
| 9 | BASE_UNIT_WK | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Units Per Week |
| 10 | BASE_LIFT | Number(10,0) | DECIMAL(10) NOT NULL | Base Lift Per Week |
| 11 | CONVERT_UNIT_WK | Number(10,0) | DECIMAL(10) NOT NULL | Converted Units Per Week |
| 12 | CONVERT_LIFT | Number(10,0) | DECIMAL(10) NOT NULL | Converted Lift Per Week |
| 13 | PRICE_BASE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price (base) |
| 14 | PROMO_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Promotional Price |
| 15 | INCR_LIFT_PCT | Number(5,1) | DECIMAL(4,1) NOT NULL | Increased Lift Percentage |
| 16 | FEATURE_PART_PCT | Number(5,1) | DECIMAL(4,1) NOT NULL | Feature Participation Percent |
| 17 | DISPLAY_PART_PCT | Number(5,1) | DECIMAL(4,1) NOT NULL | Display Participation Percent |
| 18 | FEAT_DISP_PART_PCT | Number(5,1) | DECIMAL(4,1) NOT NULL | Feature & Display % |
| 19 | TPR_PART_PCT | Number(5,1) | DECIMAL(4,1) NOT NULL | Temporary Price Reduction % |
| 20 | FREQSHOP_PART_PCT | Number(5,1) | DECIMAL(4,1) NOT NULL | Frequent Shopper Participation |
| 21 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table: TD_ALL_PROS_VW |
| 22 | DATETIME_ADDED | DateTime(26) | TIMESTAMP NOT NULL |
DateTime Added
Default Value: %DateTime |