PO_SUT_DFLT_VW

(SQL View)

SELECT DISTINCT PROCESS_INSTANCE , TAX_SETID , SALETX_CD , USETAX_CD , SUT_APPL_FLG , TAX_DSCNT_FLG , TAX_VAT_FLG , TAX_MISC_FLG , TAX_FRGHT_FLG , SALES_USE_TX_FLG FROM PS_PO_SUT_DFLT_TMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 TAX_SETID Character(5) VARCHAR2(5) NOT NULL Tax SetID

3 SALETX_CD Character(8) VARCHAR2(8) NOT NULL Sales Tax Code

4 USETAX_CD Character(8) VARCHAR2(8) NOT NULL Use Tax Code

5 SUT_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Applicablility
D=Taxable - Direct Pay
E=Exempt
T=Taxable
X=Exoneration Certificate

6 TAX_DSCNT_FLG Character(1) VARCHAR2(1) NOT NULL Include Discount

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

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

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

10 SALES_USE_TX_FLG Character(1) VARCHAR2(1) NOT NULL Sales/Use Tax Code
N=Non Taxable
S=Sales Tax
U=Use Tax

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TAX_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tax SetID
3	SALETX_CD	Character(8)	VARCHAR2(8) NOT NULL	Sales Tax Code
4	USETAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Use Tax Code
5	SUT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Applicablility D=Taxable - Direct Pay E=Exempt T=Taxable X=Exoneration Certificate
6	TAX_DSCNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Discount
7	TAX_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include VAT N=No Y=Yes
8	TAX_MISC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Misc Charges
9	TAX_FRGHT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Freight
10	SALES_USE_TX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales/Use Tax Code N=Non Taxable S=Sales Tax U=Use Tax