EX_ERTIPSUM_TMP(SQL Table) |
Index Back |
|---|---|
EX TIP Summarized Temp. TableEX Transactions in Progress Summarized Temporary Table to create summarized tables by GL Business Unit, Department, PC Business Unit and Project ID. It is used only in Application Engine EX_TIP_LOAD. Expense Reports Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | TIP_STAGE | Character(7) | VARCHAR2(7) NOT NULL | Transactions In Progress |
| 3 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 4 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 5 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 6 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 7 | DAYS_INACT_RANGE | Character(3) | VARCHAR2(3) NOT NULL |
Days Inactive Range
-30=< 31 30=31 to 60 60=61 to 90 90+=> 90 A=All |