BUSINESS_UNITINVOICE_IDSPA_INV_TOT_VW(SQL View) |
Index Back |
|---|---|
Total Invoice Amount |
| SELECT A.BUSINESS_UNIT , A.INVOICE_ID , SUM(A.INV_LINE_ADJAMT) + SUM(A.INV_LINE_ADJEXP) + SUM(A.ADJ_VAT_AMT) + SUM(A.ADJ_SALETX_AMT) , SUM(A.INV_LN_ADJAMT_BSE) + SUM(A.INV_LN_ADJEXP_BSE) + SUM(A.ADJ_VAT_AMT_BSE) + SUM(A.ADJ_SALETX_AMT_BSE) , A.CURRENCY_CD , A.CURRENCY_CD_BASE FROM PS_SPF_INVOICE_DTL A GROUP BY A.BUSINESS_UNIT , A.INVOICE_ID , A.CURRENCY_CD , A.CURRENCY_CD_BASE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 3 | TOTAL_INVOICED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Invoiced |
| 4 | INVOICE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |