SUT_PRODUCT_VW(SQL View) |
Index Back |
|---|
| SELECT W.BUSINESS_UNIT , W.TAX_CALC_TXN_ID , W.TAX_CALC_LINE_NBR , W.TAX_CALC_SCHED_NBR , W.SETID , W.INV_ITEM_ID , W.CATEGORY_ID , W.ULTIMATE_USE_CD , W.SHIP_TYPE_ID , W.FREIGHT_TERMS , D.SUT_PRODUCT_CD , D.SUT_APPL_FLG , W.SUT_FREIGHT_CD , W.SUT_FRGHT_APPL_FLG FROM PS_SUT_PRODUCT_WRK W , PS_SUT_PROD_XRFD D , PS_INSTALLATION I WHERE ( (D.TAX_VENDOR = I.TAX_VENDOR OR D.TAX_VENDOR = ' ') AND ( D.SETID = W.SETID OR D.SETID = ' ') AND ( D.INV_ITEM_ID = W.INV_ITEM_ID OR D.INV_ITEM_ID = ' ') AND ( D.CATEGORY_ID = W.CATEGORY_ID OR D.CATEGORY_ID = ' ') AND ( D.ULTIMATE_USE_CD = W.ULTIMATE_USE_CD OR D.ULTIMATE_USE_CD = ' ')) AND ( D.SORT_SEQ_NUM = ( SELECT MIN(SORT_SEQ_NUM) FROM PS_SUT_PROD_XRFD WHERE (PS_SUT_PROD_XRFD.TAX_VENDOR = 'A' ) AND ( PS_SUT_PROD_XRFD.SETID = W.SETID OR D.SETID = ' ') AND ( PS_SUT_PROD_XRFD.INV_ITEM_ID = W.INV_ITEM_ID OR PS_SUT_PROD_XRFD.INV_ITEM_ID = ' ') AND ( PS_SUT_PROD_XRFD.CATEGORY_ID = W.CATEGORY_ID OR PS_SUT_PROD_XRFD.CATEGORY_ID = ' ') AND ( PS_SUT_PROD_XRFD.ULTIMATE_USE_CD = W.ULTIMATE_USE_CD OR PS_SUT_PROD_XRFD.ULTIMATE_USE_CD = ' '))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TAX_CALC_TXN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Tax Calculation Taxation Id |
| 3 | TAX_CALC_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Tax calculation Line Number |
| 4 | TAX_CALC_SCHED_NBR |
Number(5,0) | INTEGER NOT NULL | Tax Calculation Schedule Nbr |
| 5 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 6 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: PURCH_ITEM_ATTR |
| 7 | CATEGORY_ID |
Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_VW |
| 8 | ULTIMATE_USE_CD |
Character(8) | VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table: SUT_USE_CD |
| 9 | SHIP_TYPE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 10 | FREIGHT_TERMS |
Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table: FREIGHT_TERMS |
| 11 | SUT_PRODUCT_CD | Character(18) | VARCHAR2(18) NOT NULL | Product Alias |
| 12 | SUT_PROD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sales/Use Tax Applicablility |
| 13 | SUT_FREIGHT_CD | Character(18) | VARCHAR2(18) NOT NULL | Product Alias |
| 14 | SUT_FRGHT_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sales/Use Tax Applicablility |