VCHR_PO_LN_SVW

(SQL View)
 Index Back

Voucher - PO Line Summary View


SELECT A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM , SUM(A.QTY_VCHR) , SUM(A.MERCHANDISE_AMT) , SUM(A.MERCH_AMT_BSE) , SUM(A.FREIGHT_AMT) , SUM(A.FREIGHT_AMT_BSE) , SUM(A.FREIGHT_AMT_NP) , SUM(A.FREIGHT_AMT_NP_BSE) , SUM(A.SALETX_AMT) , SUM(A.SALETX_AMT_BSE) , SUM(A.SALETX_AMT_NP) , SUM(A.SALETX_AMT_NP_BSE) , SUM(A.USETAX_AMT) , SUM(A.USETAX_AMT_BSE) , SUM(A.USETAX_AMT_NP) , SUM(A.USETAX_AMT_NP_BSE) , SUM(A.VAT_INV_AMT) , SUM(A.VAT_INV_AMT_BSE) , SUM(A.VAT_BASIS_AMT) , SUM(A.VAT_BASIS_AMT_BSE) , SUM(A.VAT_RCVRY_AMT) , SUM(A.VAT_RCVRY_AMT_BSE) , SUM(A.VAT_REBATE_AMT) , SUM(A.VAT_REBATE_AMT_BSE) , SUM(A.MISC_AMT) , SUM(A.MISC_AMT_BSE) , SUM(A.MISC_AMT_NP) , SUM(A.MISC_AMT_NP_BSE) FROM PS_PO_ROLL_DIST_SH A GROUP BY A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
6 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
7 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
8 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
9 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
10 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
11 FREIGHT_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
12 FREIGHT_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
13 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
14 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
15 SALETX_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
16 SALETX_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
17 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
18 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
19 USETAX_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
20 USETAX_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
21 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
22 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr
23 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
24 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
25 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
26 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
27 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt
28 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr
29 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
30 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
31 MISC_AMT_NP Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
32 MISC_AMT_NP_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount