SETIDEXS_PROD_KIT_USEI=Item
N=Not Applicable
P=Product
EXS_ITM_PROD_IDPrompt Table: %RECNAME_EDIT
EXS_TAX_DTIP_VW(SQL View) |
Index Back |
|---|---|
Tax Determ Product and Item |
| SELECT A.SETID ,A.EXS_PROD_KIT_USE ,A.EXS_ITM_PROD_ID FROM PS_EXS_TAX_DETERM A WHERE A.EXS_PROD_KIT_USE IN ('I','P') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EXS_PROD_KIT_USE |
Character(1) | VARCHAR2(1) NOT NULL |
Product Kit Usage
I=Item N=Not Applicable P=Product |
| 3 | EXS_ITM_PROD_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item Product ID
Prompt Table: %RECNAME_EDIT |