GST_TAX_DTM_VW1

(SQL View)
 Index Back

TAX DETERMINATION VIEW


SELECT A.SETID ,A.EXS_TAX_TYPE ,A.EXS_TAX_TXN_TYPE ,A.STX_TAX_AUTH_CD ,A.EXS_TPRTNR_TAX_CAT ,A.EXS_ITM_TAX_CATG ,A.EXS_PROD_KIT_USE ,A.EXS_ITM_PROD_ID ,A.CSD_BENEFIT_ID FROM PS_EXS_TAX_DETERM A WHERE A.EXS_TAX_TYPE IN('G','C')

# 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_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import

Default Value: DOM

4 STX_TAX_AUTH_CD Character(8) VARCHAR2(8) NOT NULL Tax Authority Code

Prompt Table: STX_TAX_AUTH

5 EXS_TPRTNR_TAX_CAT Character(10) VARCHAR2(10) NOT NULL Trading Partner

Prompt Table: EXS_TAX_CAT_VW2

6 EXS_ITM_TAX_CATG Character(11) VARCHAR2(11) NOT NULL Item Tax Category

Prompt Table: EXS_TAX_CAT_VW1

7 EXS_PROD_KIT_USE Character(1) VARCHAR2(1) NOT NULL Product Kit Usage
I=Item
N=Not Applicable
P=Product

Default Value: N

8 EXS_ITM_PROD_ID Character(18) VARCHAR2(18) NOT NULL Item Product ID

Prompt Table: EXS_TAX_DTIP_VW

9 CSD_BENEFIT_ID Character(10) VARCHAR2(10) NOT NULL India Customs Duty Benefit Identification

Prompt Table: CSD_BENEFIT_VW