RBF_CARRIER_VW (SQL View)	Index Back
Carrier Table View This view fecthes all the carriers from carrier table

RBF_CARRIER_VW

(SQL View)

Carrier Table View

This view fecthes all the carriers from carrier table

SELECT SETID , CARRIER , DESCR80 , DESCR100 FROM PS_CARRIER_TBL A WHERE A.ACTIVE_FLAG='A'

Related Language Record: RBF_CARR_VW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID

2 CARRIER Character(10) VARCHAR2(10) NOT NULL Carrier or preferred carrier. Also used for Shipping Method.

3 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.

4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_FS.SETID
2	CARRIER	Character(10)	VARCHAR2(10) NOT NULL	Carrier or preferred carrier. Also used for Shipping Method.
3	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
4	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description