RE_SLSRPT_ADD(SQL View) |
Index Back |
|---|---|
Sales Report Add ViewSales Report Add View - SQL View |
| SELECT 0 ,A.BUSINESS_UNIT , A.LEASE_OBLG , A.LS_NBR , A.LS_KEY , B.CALENDAR_ID , B.FISCAL_YEAR , B.ACCOUNTING_PERIOD FROM PS_RE_LS A , PS_RE_SLSRPT B WHERE A.LS_KEY = B.LS_KEY |
| # | 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 3 | LEASE_OBLG |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 4 | LS_NBR |
Character(10) | VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
Prompt Table: RE_ACTIVERECVLS |
| 5 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 6 | CALENDAR_ID |
Character(2) | VARCHAR2(2) NOT NULL |
Calendar ID
Default Value: RE_BUS_UNIT.CALENDAR_ID |
| 7 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: RE_YEAR_PMPT |
| 8 | 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.
Prompt Table: RE_PERIOD_PMPT |