PO_STG_SUMTX_VW

(SQL View)

SELECT PROCESS_INSTANCE , BUSINESS_UNIT , PO_ID , PO_STG_TYPE , PO_STG_ID , LINE_NBR , SCHED_NBR , SUT_APPLICABILITY , SUT_EXCPTN_TYPE , SUT_EXCPTN_CERTIF , TAX_CD_SUT , TAX_VAT_FLG , TAX_FRGHT_FLG , TAX_MISC_FLG , SUM(VAT_AMT) , SUM(FREIGHT_AMT) , SUM(MISC_AMT) FROM PS_PO_ITM_STG_TAX GROUP BY PROCESS_INSTANCE , BUSINESS_UNIT , PO_ID , PO_STG_TYPE , PO_STG_ID , LINE_NBR , SCHED_NBR , SUT_APPLICABILITY , SUT_EXCPTN_TYPE , SUT_EXCPTN_CERTIF , TAX_CD_SUT , TAX_VAT_FLG , TAX_FRGHT_FLG , TAX_MISC_FLG

# 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 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition

5 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table

6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

8 SUT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated

9 SUT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None

10 SUT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Sales/Use Tax Exception Certif

11 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax

12 TAX_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Include VAT
N=No
Y=Yes

13 TAX_FRGHT_FLG Character(1) VARCHAR2(1) NOT NULL Include Freight

14 TAX_MISC_FLG Character(1) VARCHAR2(1) NOT NULL Include Misc Charges

15 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.

16 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount

17 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount

#	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	PO_STG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used in conjunction with PO_STG_ID to make a unique key on the stage tables. O=Other R=Requisition
5	PO_STG_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniqye key to the PO Staging table
6	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
7	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
8	SUT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Applicability D=Direct Pay E=Item is Exempt S=Sales Tax Applicable U=Use Tax Applicable X=Purchaser Is Exonerated
9	SUT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Exception Type D=Direct Pay E=Exempt/Exonerated N=None
10	SUT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Sales/Use Tax Exception Certif
11	TAX_CD_SUT	Character(8)	VARCHAR2(8) NOT NULL	Tax Code - Sales and Use Tax
12	TAX_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include VAT N=No Y=Yes
13	TAX_FRGHT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Freight
14	TAX_MISC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Misc Charges
15	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.
16	FREIGHT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Freight Amount
17	MISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Misc. Amount