RBF_TCHK_DEN_VW(SQL View) |
Index Back |
|---|---|
denomination viewdenomination view |
| SELECT DENOMINATION ,PACK_OF ,DENOMINATION * PACK_OF ,0 FROM PS_RBF_TCHK_DENOM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DENOMINATION | Number(10,0) | DECIMAL(10) NOT NULL | Denomination |
| 2 | PACK_OF | Number(5,0) | INTEGER NOT NULL | Pack Of |
| 3 | TRV_CHK_AMOUNT | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Cost per pack |
| 4 | QUANTITY_OF_CHECKS | Number(10,0) | DECIMAL(10) NOT NULL | quantity |