RE_SLSRPT_VW(SQL View) |
Index Back |
---|---|
Sales Report ViewSales Report View |
SELECT SLSRPT_ID , LS_KEY , CALENDAR_ID , FISCAL_YEAR , ACCOUNTING_PERIOD FROM PS_RE_SLSRPT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SLSRPT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Sales Report ID - Number (15) |
2 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
3 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
4 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
5 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |