% Books of CAPSEA
===========================
SELECT     itung, ID, ORD_ID, TRANSC_NO, REC_DT, PART, ORD_TYPe, RECID_ORD, RECID_REC
FROM         BOOKS_RECEIVED_DTL
WHERE     (REC_DT BETWEEN dbo.Trunc('10/01/2012') AND dbo.Trunc('09/30/2013'))