ITM_VNDR_MC_VW2

(SQL View)
Index Back

Item Supplier Loc - Misc Charg


SELECT DISTINCT SETID , SORT_SEQ_NUM , CATEGORY_TYPE , CATEGORY_ID , INV_ITEM_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , BUSINESS_UNIT , SHIPTO_SETID , SHIPTO_ID , EFFDT , EFF_STATUS FROM PS_ITM_CAT_VNDR_MC

# 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 SORT_SEQ_NUM Character(1) VARCHAR2(1) NOT NULL Sort Sequence Number
3 CATEGORY_TYPE Character(3) VARCHAR2(3) NOT NULL Category Type
PSF=User Def
UNS=UN/SPSC

Default Value: INSTALLATION_PO.CATEGORY_TYPE

4 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: ITM_CAT_VW

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: PURCH_ITEM_ATTR

6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_VNDSET_VW

8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VENDOR_LOC_VW

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

10 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
11 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIP_SHIPSET_VW

12 EFFDT Date(10) DATE Effective Date

Default Value: %date

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

Default Value: A