DP_DDHCALERR_VW

(SQL View)
 Index Back

demand planning - data history

demand data history table- currently contains 147 fields

SELECT DDH.DP_CONFIGVIEW ,DDH.DP_DDH_ID ,DDH.DP_DDH_ID_LINK ,DDH.DEMAND_SOURCE ,DDH.DP_UPDATE_DMDTYPE ,DDH.DP_TRANSOURCE ,DDH.DP_DEMANDTYPE ,DDH.AUDIT_ACTN ,DDH.DP_SOURCESTATUS ,DDH.DP_UPDATESTATUS ,DDH.DP_DATESTAMP ,DDH.DP_DEMANDDATE ,DDH.DP_DEMANDQTY ,DDH.DP_UPD_DATESTAMP ,PER.DP_CORP_PERIOD ,PER.DP_CORP_YEAR ,DDH.DP_UPDATE_NO ,DDH.DP_DDHUPD_GROUP ,DDH.SETID ,DDH.BUSINESS_UNIT ,DDH.DP_SEQNUMBER ,DDH.BILL_TO_CUST_ID ,DDH.CM_UNIT_COST ,DDH.CURRENCY_CD ,DDH.DEMAND_LINE_NO ,DDH.DP_DEMANDVALUE ,DDH.INV_ITEM_ID ,DDH.INVOICE ,DDH.INVOICE_DT ,DDH.LINE_SEQ_NUM ,DDH.LIST_PRICE ,DDH.ORDER_INT_LINE_NO ,DDH.ORDER_NO ,DDH.PRODUCT_ID ,DDH.COMPONENT_ID ,DDH.SCHED_LINE_NBR ,DDH.SHIP_DATE ,DDH.SHIP_DTTM ,DDH.SHIP_TO_CUST_ID ,DDH.SOLD_TO_CUST_ID ,DDH.SOURCE_CODE ,DDH.SOURCE_BUS_UNIT ,DDH.UNIT_OF_MEASURE ,DDH.CONVERSION_RATE ,DDH.BUSINESS_UNIT_BI ,DDH.BUSINESS_UNIT_IN ,DDH.BUSINESS_UNIT_OM ,DDH.CORPORATE_CUST_ID ,DDH.CUST_FIELD_C10_A ,DDH.CUST_FIELD_C10_B ,DDH.CUST_FIELD_C10_C ,DDH.CUST_FIELD_C10_D ,DDH.CUST_FIELD_C1_A ,DDH.CUST_FIELD_C1_B ,DDH.CUST_FIELD_C1_C ,DDH.CUST_FIELD_C1_D ,DDH.CUST_FIELD_C2 ,DDH.CUST_FIELD_C30_A ,DDH.CUST_FIELD_C30_B ,DDH.CUST_FIELD_C30_C ,DDH.CUST_FIELD_C30_D ,DDH.CUST_FIELD_C4 ,DDH.CUST_FIELD_C6 ,DDH.CUST_FIELD_C8 ,DDH.CUST_FIELD_N12_A ,DDH.CUST_FIELD_N12_B ,DDH.CUST_FIELD_N12_C ,DDH.CUST_FIELD_N12_D ,DDH.CUST_FIELD_N15_A ,DDH.CUST_FIELD_N15_B ,DDH.CUST_FIELD_N15_C ,DDH.CUST_FIELD_N15_D ,DDH.SUBCUST_QUAL1 ,DDH.SUBCUST_QUAL2 ,DDH.CUSTOMER_GROUP ,DDH.CUST_CHANNEL ,DDH.CLASSIFICATION ,DDH.PM_DIVISION ,DDH.PM_REGION ,DDH.PM_TERRITORY ,DDH.INV_ITEM_GROUP ,DDH.MITBL_DESCR ,DDH.CATEGORY_ID ,DDH.INV_PROD_FAM_CD ,DDH.INV_ITEM_TYPE ,DDH.INV_ITEM_COLOR ,DDH.UPC_ID ,DDH.ITEM_FIELD_C10_A ,DDH.ITEM_FIELD_C10_B ,DDH.ITEM_FIELD_C10_C ,DDH.ITEM_FIELD_C10_D ,DDH.ITEM_FIELD_C1_A ,DDH.ITEM_FIELD_C1_B ,DDH.ITEM_FIELD_C1_C ,DDH.ITEM_FIELD_C1_D ,DDH.ITEM_FIELD_C2 ,DDH.ITEM_FIELD_C30_A ,DDH.ITEM_FIELD_C30_B ,DDH.ITEM_FIELD_C30_C ,DDH.ITEM_FIELD_C30_D ,DDH.ITEM_FIELD_C4 ,DDH.ITEM_FIELD_C6 ,DDH.ITEM_FIELD_C8 ,DDH.ITEM_FIELD_N12_A ,DDH.ITEM_FIELD_N12_B ,DDH.ITEM_FIELD_N12_C ,DDH.ITEM_FIELD_N12_D ,DDH.ITEM_FIELD_N15_A ,DDH.ITEM_FIELD_N15_B ,DDH.ITEM_FIELD_N15_C ,DDH.ITEM_FIELD_N15_D ,DDH.FORECAST_ITEM_FLAG ,DDH.UTILIZ_CD ,DDH.UTILIZ_GROUP ,DDH.PROD_BRAND ,DDH.PROD_CATEGORY ,DDH.PRDITM_DESCR ,DDH.PROD_FIELD_C1_A ,DDH.PROD_FIELD_C1_B ,DDH.PROD_FIELD_C1_C ,DDH.PROD_FIELD_C1_D ,DDH.PROD_FIELD_C10_A ,DDH.PROD_FIELD_C10_B ,DDH.PROD_FIELD_C10_C ,DDH.PROD_FIELD_C10_D ,DDH.PROD_FIELD_C2 ,DDH.PROD_FIELD_C30_A ,DDH.PROD_FIELD_C30_B ,DDH.PROD_FIELD_C30_C ,DDH.PROD_FIELD_C30_D ,DDH.PROD_FIELD_C4 ,DDH.PROD_FIELD_C6 ,DDH.PROD_FIELD_C8 ,DDH.PROD_FIELD_N12_A ,DDH.PROD_FIELD_N12_B ,DDH.PROD_FIELD_N12_C ,DDH.PROD_FIELD_N12_D ,DDH.PROD_FIELD_N15_A ,DDH.PROD_FIELD_N15_B ,DDH.PROD_FIELD_N15_C ,DDH.PROD_FIELD_N15_D ,DDH.PRODUCT_GROUP ,DDH.PRODUCT_KIT_FLAG ,DDH.SALES_PERSON ,DDH.REGION_CD ,DDH.FORECASTER ,PER.DP_CALENDARID ,PER.DP_TIMEPERIODCODE ,PER.DP_STARTDATE ,PER.DP_ENDDATE FROM PS_DP_DMD_ERRORS DDH , PS_DP_CALPERIODS PER WHERE PER.DP_STARTDATE <= DDH.DP_DEMANDDATE AND PER.DP_ENDDATE >= DDH.DP_DEMANDDATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
2 DP_DDH_ID Character(30) VARCHAR2(30) NOT NULL Demand data history table - row ID (key)
3 DP_DDH_ID_LINK Character(30) VARCHAR2(30) NOT NULL Demand data history table - row ID (key)
4 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
5 DP_UPDATE_DMDTYPE Character(2) VARCHAR2(2) NOT NULL DP_UPDATE_DMDTYPE
BI=Billing
IN=Material Stock Requests
OM=Order Management
PL=Planning Requests
PR=Purchasing Requests
RT=Material Returns
SO=Shipped Orders
6 DP_TRANSOURCE Number(1,0) SMALLINT NOT NULL DP_TRANSOURCE
7 DP_DEMANDTYPE Number(1,0) SMALLINT NOT NULL DP_DEMANDTYPE
8 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
9 DP_SOURCESTATUS Signed Number(3,0) DECIMAL(2) NOT NULL DP_SOURCESTATUS
10 DP_UPDATESTATUS Signed Number(2,0) DECIMAL(1) NOT NULL 0 = Not processed 1 = Processed 2 = Partially Processed -1 = Errored
11 DP_DATESTAMP DateTime(26) TIMESTAMP DP_DATESTAMP
12 DP_DEMANDDATE Date(10) DATE DP_DEMANDDATE
13 DP_DEMANDQTY Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_DEMANDQTY
14 DP_UPD_DATESTAMP Date(10) DATE DP_UPD_DATESTAMP
15 DP_PERIOD Number(3,0) SMALLINT NOT NULL DP_PERIOD
16 DP_YEAR Number(4,0) SMALLINT NOT NULL DP_YEAR
17 DP_UPDATE_NO Number(3,0) SMALLINT NOT NULL DP_UPDATE_NO
18 DP_DDHUPD_GROUP Character(36) VARCHAR2(36) NOT NULL DP_DDHUPD_GROUP
19 SETID Character(5) VARCHAR2(5) NOT NULL SetID
20 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

21 DP_SEQNUMBER Number(10,0) DECIMAL(10) NOT NULL MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.
22 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
23 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
25 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

Default Value: 1

26 DP_DEMANDVALUE Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_DEMANDVALUE
27 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
28 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
29 INVOICE_DT Date(10) DATE Invoice Date
30 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
31 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
32 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
33 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
34 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
35 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
36 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
37 SHIP_DATE Date(10) DATE Item Shipping Date
38 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time
39 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
40 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
41 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
42 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
43 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
44 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
45 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
46 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
47 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
48 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer
49 CUST_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Customer Char 10 A
50 CUST_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Customer Char 10 B
51 CUST_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Customer Char 10 C
52 CUST_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Customer Char 10 D
53 CUST_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Field
54 CUST_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Customer Char1 B
55 CUST_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Customer Char1 C
56 CUST_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Customer Char1 D
57 CUST_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Customer Char 2
58 CUST_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Customer Char 30 A
59 CUST_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Customer Char 30 B
60 CUST_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Customer Char 30 C
61 CUST_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Customer Char 30 D
62 CUST_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Customer Char 4
63 CUST_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Customer Char 6
64 CUST_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Customer Char 8
65 CUST_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 A
66 CUST_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 B
67 CUST_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 C
68 CUST_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 D
69 CUST_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 A
70 CUST_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 B
71 CUST_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 C
72 CUST_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 D
73 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
74 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
75 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
76 CUST_CHANNEL Character(15) VARCHAR2(15) NOT NULL Customer Channel
77 CLASSIFICATION Character(10) VARCHAR2(10) NOT NULL Classification
78 PM_DIVISION Character(15) VARCHAR2(15) NOT NULL Division
79 PM_REGION Character(10) VARCHAR2(10) NOT NULL Region
80 PM_TERRITORY Character(15) VARCHAR2(15) NOT NULL Territory
81 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
82 MITBL_DESCR Character(30) VARCHAR2(30) NOT NULL Description
83 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
84 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
85 INV_ITEM_TYPE Character(5) VARCHAR2(5) NOT NULL Item Type
86 INV_ITEM_COLOR Character(10) VARCHAR2(10) NOT NULL Item Color
87 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
88 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
89 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
90 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
91 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
92 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
93 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
94 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
95 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
96 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
97 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
98 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
99 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
100 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
101 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
102 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
103 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
104 ITEM_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
105 ITEM_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
106 ITEM_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
107 ITEM_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
108 ITEM_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
109 ITEM_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
110 ITEM_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
111 ITEM_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
112 FORECAST_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Demand Planning Item
113 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type

Prompt Table: DP_UTILIZ_CD_VW

114 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count

Prompt Table: DP_UTILIZ_GP_VW

115 PROD_BRAND Character(15) VARCHAR2(15) NOT NULL Product Brand
116 PROD_CATEGORY Character(15) VARCHAR2(15) NOT NULL Product Category
117 PRDITM_DESCR Character(30) VARCHAR2(30) NOT NULL Description
118 PROD_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Product Char1 A
119 PROD_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Product Char1 B
120 PROD_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Product Char1 C
121 PROD_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Product Char1 D
122 PROD_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Product Char 10 A
123 PROD_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Product Char 10 B
124 PROD_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Product Char 10 C
125 PROD_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Product Char 10 D
126 PROD_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Product Char 2
127 PROD_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Product Char 30 A
128 PROD_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Product Char 30 B
129 PROD_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Product Char 30 C
130 PROD_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Product Char 30 D
131 PROD_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Product Char 8
132 PROD_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Product Char 6
133 PROD_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Product Char 8
134 PROD_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 A
135 PROD_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 B
136 PROD_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 C
137 PROD_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 D
138 PROD_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 A
139 PROD_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 B
140 PROD_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 C
141 PROD_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 D
142 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
143 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit
144 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
145 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
146 FORECASTER Character(20) VARCHAR2(20) NOT NULL Forecaster
147 DP_CALENDARID Character(20) VARCHAR2(20) NOT NULL DP_CALENDARID
148 DP_TIMEPERIODCODE Character(10) VARCHAR2(10) NOT NULL DP_TIMEPERIODCODE
149 DP_STARTDATE Date(10) DATE DP_STARTDATE
150 DP_ENDDATE Date(10) DATE DP_ENDDATE