DP_DDHCAL_VW

(SQL View)
 Index Back

demand planning - data history

demand data history table- currently contains 147 fields

SELECT 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.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_BUS_UNIT ,DDH.SOURCE_CODE ,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_DMDHISTORY 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_DDH_ID Character(30) VARCHAR2(30) NOT NULL Demand data history table - row ID (key)
2 DP_DDH_ID_LINK Character(30) VARCHAR2(30) NOT NULL Demand data history table - row ID (key)
3 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
4 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
5 DP_TRANSOURCE Number(1,0) SMALLINT NOT NULL DP_TRANSOURCE
6 DP_DEMANDTYPE Number(1,0) SMALLINT NOT NULL DP_DEMANDTYPE
7 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
8 DP_SOURCESTATUS Signed Number(3,0) DECIMAL(2) NOT NULL DP_SOURCESTATUS
9 DP_UPDATESTATUS Signed Number(2,0) DECIMAL(1) NOT NULL 0 = Not processed 1 = Processed 2 = Partially Processed -1 = Errored
10 DP_DATESTAMP DateTime(26) TIMESTAMP DP_DATESTAMP
11 DP_DEMANDDATE Date(10) DATE DP_DEMANDDATE
12 DP_DEMANDQTY Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_DEMANDQTY
13 DP_UPD_DATESTAMP Date(10) DATE DP_UPD_DATESTAMP
14 DP_PERIOD Number(3,0) SMALLINT NOT NULL DP_PERIOD
15 DP_YEAR Number(4,0) SMALLINT NOT NULL DP_YEAR
16 DP_UPDATE_NO Number(3,0) SMALLINT NOT NULL DP_UPDATE_NO
17 DP_DDHUPD_GROUP Character(36) VARCHAR2(36) NOT NULL DP_DDHUPD_GROUP
18 SETID Character(5) VARCHAR2(5) NOT NULL SetID
19 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

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

Default Value: 1

25 DP_DEMANDVALUE Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_DEMANDVALUE
26 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
27 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
28 INVOICE_DT Date(10) DATE Invoice Date
29 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
30 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
31 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
32 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
33 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
34 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
35 SHIP_DATE Date(10) DATE Item Shipping Date
36 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time
37 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
38 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
39 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
40 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
41 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
42 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
43 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
44 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
45 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
46 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer
47 CUST_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Customer Char 10 A
48 CUST_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Customer Char 10 B
49 CUST_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Customer Char 10 C
50 CUST_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Customer Char 10 D
51 CUST_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Field
52 CUST_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Customer Char1 B
53 CUST_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Customer Char1 C
54 CUST_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Customer Char1 D
55 CUST_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Customer Char 2
56 CUST_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Customer Char 30 A
57 CUST_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Customer Char 30 B
58 CUST_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Customer Char 30 C
59 CUST_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Customer Char 30 D
60 CUST_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Customer Char 4
61 CUST_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Customer Char 6
62 CUST_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Customer Char 8
63 CUST_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 A
64 CUST_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 B
65 CUST_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 C
66 CUST_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 D
67 CUST_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 A
68 CUST_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 B
69 CUST_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 C
70 CUST_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 D
71 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.
72 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.
73 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
74 CUST_CHANNEL Character(15) VARCHAR2(15) NOT NULL Customer Channel
75 CLASSIFICATION Character(10) VARCHAR2(10) NOT NULL Classification
76 PM_DIVISION Character(15) VARCHAR2(15) NOT NULL Division
77 PM_REGION Character(10) VARCHAR2(10) NOT NULL Region
78 PM_TERRITORY Character(15) VARCHAR2(15) NOT NULL Territory
79 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
80 MITBL_DESCR Character(30) VARCHAR2(30) NOT NULL Description
81 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
82 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
83 INV_ITEM_TYPE Character(5) VARCHAR2(5) NOT NULL Item Type
84 INV_ITEM_COLOR Character(10) VARCHAR2(10) NOT NULL Item Color
85 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
86 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
87 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
88 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
89 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
90 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
91 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
92 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
93 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
94 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
95 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
96 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
97 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
98 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
99 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
100 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
101 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
102 ITEM_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
103 ITEM_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
104 ITEM_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
105 ITEM_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
106 ITEM_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
107 ITEM_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
108 ITEM_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
109 ITEM_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
110 FORECAST_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Demand Planning Item
111 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type

Prompt Table: DP_UTILIZ_CD_VW

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

Prompt Table: DP_UTILIZ_GP_VW

113 PROD_BRAND Character(15) VARCHAR2(15) NOT NULL Product Brand
114 PROD_CATEGORY Character(15) VARCHAR2(15) NOT NULL Product Category
115 PRDITM_DESCR Character(30) VARCHAR2(30) NOT NULL Description
116 PROD_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Product Char1 A
117 PROD_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Product Char1 B
118 PROD_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Product Char1 C
119 PROD_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Product Char1 D
120 PROD_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Product Char 10 A
121 PROD_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Product Char 10 B
122 PROD_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Product Char 10 C
123 PROD_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Product Char 10 D
124 PROD_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Product Char 2
125 PROD_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Product Char 30 A
126 PROD_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Product Char 30 B
127 PROD_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Product Char 30 C
128 PROD_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Product Char 30 D
129 PROD_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Product Char 8
130 PROD_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Product Char 6
131 PROD_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Product Char 8
132 PROD_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 A
133 PROD_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 B
134 PROD_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 C
135 PROD_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 D
136 PROD_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 A
137 PROD_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 B
138 PROD_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 C
139 PROD_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 D
140 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
141 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit
142 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.
143 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.
144 FORECASTER Character(20) VARCHAR2(20) NOT NULL Forecaster
145 DP_CALENDARID Character(20) VARCHAR2(20) NOT NULL DP_CALENDARID
146 DP_TIMEPERIODCODE Character(10) VARCHAR2(10) NOT NULL DP_TIMEPERIODCODE
147 DP_STARTDATE Date(10) DATE DP_STARTDATE
148 DP_ENDDATE Date(10) DATE DP_ENDDATE