data extraction

[sreekuax]

Have to extract data from below tables :

PL_MSTR
PT_MSTR
GLTR_HIST
CM_MSTR
SI_MSTR
AD_MSTR
CC_MSTR
VD_MSTR
PO_MSTR,
POD_DET
VO_MSTR
VOD_DET

have to use progress- the condition is that have to only extract data in each table of 2009 data only .. as u might know that full data extract will contain data regardless the year !!

Any idea ? pls help

 

[mosfin]

there are different date fields in every table,
you have to analyze each relevant field and export when it relates to 2009
pt_mstr table for example, has these fields:
pt_mod_date (last modified)
pt_added (1st added)

so it depends on your task, but anyway you do it in progress code yourself