CONTRACT_FLAGPO_SPND_CNT_VW(SQL View) |
Index Back |
|---|---|
PO Spend contract view |
| SELECT A.CONTRACT_FLAG , B.XLATSHORTNAME ,SUM(A.MERCHANDISE_AMT) FROM PS_PO_SPND_PODTDTL A , PSXLATITEM B WHERE B.FIELDNAME = 'CONTRACT_FLAG' AND B.FIELDVALUE = A.CONTRACT_FLAG GROUP BY A.CONTRACT_FLAG, B.XLATSHORTNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_FLAG |
Character(1) | VARCHAR2(1) NOT NULL | Contract Flag |
| 2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 3 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |