EXS_TAX_DETERM

(SQL Table)
Index Back

Tax Determination

# 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
4 STX_TAX_AUTH_CD Character(8) VARCHAR2(8) NOT NULL Tax Authority Code

Prompt Table: %RECNAME_EDIT3

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
8 EXS_ITM_PROD_ID Character(18) VARCHAR2(18) NOT NULL Item Product ID

Prompt Table: %RECNAME_EDIT

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

Prompt Table: CSD_BENEFIT_VW

10 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
11 EXS_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Tax Rate Code

Prompt Table: %RECNAME_EDIT2