AP_CHART_TEMP(SQL Table) |
Index Back |
|---|---|
Payables Chart Temp Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COLUMN1 | Character(20) | VARCHAR2(20) NOT NULL | Column1 |
| 2 | COLUMN2 | Character(20) | VARCHAR2(20) NOT NULL | Column2 |
| 3 | COLUMN3 | Character(20) | VARCHAR2(20) NOT NULL | Column3 |
| 4 | COLUMN4 | Character(50) | VARCHAR2(50) NOT NULL | Column4 |
| 5 | ROW_NUM | Number(3,0) | SMALLINT NOT NULL | Row Number |
| 6 | COLOR | Number(10,0) | DECIMAL(10) NOT NULL | Color |
| 7 | MONTH_VALUE | Number(2,0) | SMALLINT NOT NULL | Month |
| 8 | YEAR_VALUE | Number(4,0) | SMALLINT NOT NULL | Year |