ITM_SHIPTO_VW

(SQL View)
Index Back

Valid Ship To for Item


select A.SETID, A.INV_ITEM_ID, A.SHIPTO_SETID, A.SHIPTO_ID, B.EFFDT, B.EFF_STATUS, B.DESCR from PS_ITM_SHIPTO A, PS_SHIPTO_TBL B where A.SHIPTO_SETID = B.SETID and A.SHIPTO_ID = B.SHIPTO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
4 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: LOCATION_TBL

5 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

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