PO_EXS_SCDST_VW(SQL View) |
Index Back |
|---|---|
PO_EXS_SCDST_VW |
| SELECT B.PROCESS_INSTANCE , B.BUSINESS_UNIT , B.PO_ID , B.LINE_NBR , B.SCHED_NBR , SUM(B.EXD_TAX_AMT) , SUM(B.EXD_RCVRY_AMT) , SUM(B.EXD_NRCVRY_AMT) , SUM(B.EXD_TAX_AMT_BSE) , SUM(B.EXD_TAX_AMT_RPT) , SUM(B.EXD_BASIS_AMT) , SUM(B.EXD_BASIS_AMT_BSE) , SUM(B.EXD_BASIS_AMT_RPT) , SUM(B.EXD_RCVRY_AMT_BSE) , SUM(B.EXD_RCVRY_AMT_RPT) , SUM(B.EXD_NRCVRY_AMT_BSE) , SUM(B.EXD_NRCVRY_AMT_RPT) FROM PS_PO_LN_DIST_EXS B GROUP BY B.PROCESS_INSTANCE , B.BUSINESS_UNIT , B.PO_ID , B.LINE_NBR , B.SCHED_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 6 | EXS_TAX_AMT_TTL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Tax Amount |
| 7 | EXD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 8 | EXD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise NonRcvry Amount |
| 9 | EXD_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty in Base Currency |
| 10 | EXD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty Amt In Rpt Curr |
| 11 | EXD_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Basis Amt |
| 12 | EXD_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Basis Amount - Base |
| 13 | EXD_BASIS_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Basis Amount |
| 14 | EXD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 15 | EXD_RCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 16 | EXD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Non Recovery |
| 17 | EXD_NRCVRY_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Non-Recovery |