ORD_TOT_VAT_VW(SQL View) |
Index Back |
|---|---|
Vat AmtsThis view reflects the vat amounts captured at the schedule level and is used to update the header record. |
| SELECT S.BUSINESS_UNIT, S.ORDER_NO, SUM(S.VAT_AMT), SUM(S.VAT_AMT_BASE), SUM(S.VAT_BASIS_AMT), SUM(S.VAT_BASIS_AMT_BSE) FROM PS_ORD_SCHEDULE S WHERE S.ORD_SCH_STATUS <> 'X' AND S.QTY_SCHEDULED <> 0 GROUP BY S.BUSINESS_UNIT, S.ORDER_NO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | EXT_VAT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Extended VAT Amount |
| 4 | EXT_VAT_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Extended VAT Amount (base) |
| 5 | EXT_VAT_BASIS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Extended VAT Basis Amount |
| 6 | EXT_VAT_BASIS_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Extended VAT Basis Amt (Base) |