PC_SEL_DATE

(SQL Table)
Index Back

Date Selection Criteria

PC-AM: Selection criteria for Accounting or Transaction Dates

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 CRITERIA_ID Character(10) VARCHAR2(10) NOT NULL Selection Criteria ID
4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
5 INC_DATE_TYPE Character(1) VARCHAR2(1) NOT NULL Include Date Type
A=Accounting Date
E=All
T=Transaction Date

Default Value: E

6 INC_FROM_DATE Date(10) DATE Include From Date
7 INC_TO_DATE Date(10) DATE Include To Date
8 EXC_DATE_TYPE Character(1) VARCHAR2(1) NOT NULL Exclude Date Type
A=Accounting Date
T=Transaction Date
9 EXC_FROM_DATE Date(10) DATE Exclude From Date
10 EXC_TO_DATE Date(10) DATE Exclude To Date