ADVANCE_IDDefault Value: 0
EX_ADV_CHK_VW(SQL View) |
Index Back |
|---|
| SELECT ADVANCE_ID ,SUM(AMOUNT) FROM PS_EX_ADV_CHK GROUP BY ADVANCE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 2 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Amount
Default Value: 0 |