BUSINESS_UNITPO_IDCS_PO_CHRGES_VW(SQL View) |
Index Back |
|---|---|
Purchase Order Freight/ChargesUsed in SCMT bind mappings for PO |
| SELECT A.BUSINESS_UNIT ,A.PO_ID ,SUM(A.VAT_AMT) ,SUM(A.FREIGHT_AMT) ,SUM(A.MISC_AMT) ,SUM(A.SALETX_AMT) ,SUM(A.USETAX_AMT) ,SUM(A.VAT_AMT + A.FREIGHT_AMT + A.MISC_AMT + A.SALETX_AMT + A.USETAX_AMT) FROM PS_PO_LINE_DISTRIB A GROUP BY BUSINESS_UNIT ,PO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | VAT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice. |
| 4 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 5 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 6 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 7 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 8 | ADJ_AMT_TTL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Adjustment |