SUT_BASE_VW

(SQL View)
 Index Back

SUT Base ID Ship Locn View

Used for SUT_BASE_ID field prompt table.

select a.setid, a.shipto_id, a.descr from PS_SHIPTO_TBL a where a.effdt = (select max(b.effdt) from PS_SHIPTO_TBL b where b.setid = a.setid and b.shipto_id = a.shipto_id and b.effdt <= %currentdatein) and a.eff_status = 'A'

# 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 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination

Prompt Table: LOCATION_TBL

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description