RE_FROMPD_PMPT

(SQL View)
Index Back

Sales From Period Prompt

Sales From Period Prompt - SQL View: Used as Prompt for From Period field in Sales Report search page.

SELECT DISTINCT SETID , CALENDAR_ID , FISCAL_YEAR , ACCOUNTING_PERIOD , BEGIN_dT , END_DT FROM PS_CAL_DETP_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
3 FROM_YEAR Number(4,0) SMALLINT NOT NULL From Year
4 FROM_PERIOD Number(3,0) SMALLINT NOT NULL From Period
5 BEGIN_DT Date(10) DATE Begin Date
6 END_DT Date(10) DATE End Date