EXS_TAX_DET_OPT1=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
EXS_DET_OPT_VW2(SQL View) |
Index Back |
|---|---|
Custom Duty Determ Opt |
| SELECT %Substring(FIELDVALUE, 1,1) ,XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME = 'EXS_TAX_DET_OPT' AND EFF_STATUS = 'A' AND EFFDT < %CurrentDateIn AND %Substring(FIELDVALUE, 1,1) IN ('1', '2','3','6','7','9') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |