EXS_TAX_DTRM_VW

(SQL View)
Index Back

Tax Determination View


SELECT A.setid , A.exs_tax_type , A.exs_tax_det_opt FROM PS_EXS_TAX_DETERM A WHERE 'A'='B'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 EXS_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Type
C=Custom Duty
E=Excise Duty
G=Goods and Services Tax
S=Sales Tax / VAT

Default Value: E

3 EXS_TAX_DET_OPT Character(1) VARCHAR2(1) NOT NULL Tax Determination Option
1=Benefit+Partner Category+Item
2=Benefit + Item
3=Partner Category + Item
4=Partner Category + Product
5=Partner Category+Item Category
6=Partner Category
7=Item
8=Product Kit
9=Item Category