PERIOD_APSTATUS_DESCRCFOP_DISC_VW(SQL View) |
Index Back |
|---|---|
Discounts $ - CFO Portal |
| SELECT ' ' , ' ' , ' ' , ' ' , 0 , 0 , ' ' FROM PS_CFOP_DISC_SUMM A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERIOD_AP |
Character(6) | VARCHAR2(6) NOT NULL | Period |
| 2 | STATUS_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Status Description |
| 3 | PERIOD_NAME | Character(30) | VARCHAR2(30) NOT NULL | Period Name |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |