RE_BILL_SCHED(SQL View) |
Index Back |
|---|---|
Percent Rent Schedules ViewPercent Rent Schedules View |
| SELECT A.LS_KEY , B.BUSINESS_UNIT , A.BI_SCHED_ID , A.BI_CALENDAR_ID , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.SCHED_DATE , A.LS_PCT_SCHD_STATUS FROM PS_RE_PCT_BI_SCHED A , PS_RE_LS B WHERE A.LS_KEY = B.LS_KEY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BI_SCHED_ID | Number(30,0) | DECIMAL(30) NOT NULL | Bill Schedule ID |
| 4 | BI_CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Billing Calendar ID |
| 5 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 6 | 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. |
| 7 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 8 | LS_PCT_SCHD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Percent Rent Schedule Status
0=Processing 1=Pending 2=Generated |