BU_TBL_RO_CARVW (SQL View)	Index Back
Carrier description by BU List of valid carriers and ship methods by Order Capture BU

BU_TBL_RO_CARVW

(SQL View)

Carrier description by BU

List of valid carriers and ship methods by Order Capture BU

SELECT A.BUSINESS_UNIT , A.CARRIER , A.DEFAULT_FLAG , B.DESCR80 , B.DESCR100 , B.URL_ID , B.MESSAGE_SET_NBR , B.MESSAGE_NBR01 , B.MESSAGE_NBR02 , B.CARRIER_KEY1 , B.CARRIER_KEY2 FROM %Table(BU_TBL_RO_CAR) A , %Table(CARRIER_TBL) B , %Table(SET_CNTRL_REC) C WHERE C.SETCNTRLVALUE=A.BUSINESS_UNIT AND C.RECNAME='CARRIER_TBL' AND B.SETID=C.SETID AND A.CARRIER = B.CARRIER AND B.ACTIVE_FLAG='A'

Related Language Record: BU_TBL_ROCARLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL This field is a flag field to indicate default or not.
N=No
Y=Yes

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

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

6 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

7 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN

8 MESSAGE_NBR01 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN

9 MESSAGE_NBR02 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN

10 CARRIER_KEY1 Character(10) VARCHAR2(10) NOT NULL When sending carrier information to third party fulfillment systems, this maps our carriers to their carriers.

11 CARRIER_KEY2 Character(10) VARCHAR2(10) NOT NULL When sending carrier information to third party fulfillment systems, this maps our carriers to their carriers.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CARRIER	Character(10)	VARCHAR2(10) NOT NULL	Carrier or preferred carrier. Also used for Shipping Method.
3	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is a flag field to indicate default or not. N=No Y=Yes
4	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
5	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
6	URL_ID	Character(30)	VARCHAR2(30) NOT NULL	URL Identifier (see PSURLDEFN).
7	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: PSMSGCATDEFN
8	MESSAGE_NBR01	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: PSMSGCATDEFN
9	MESSAGE_NBR02	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: PSMSGCATDEFN
10	CARRIER_KEY1	Character(10)	VARCHAR2(10) NOT NULL	When sending carrier information to third party fulfillment systems, this maps our carriers to their carriers.
11	CARRIER_KEY2	Character(10)	VARCHAR2(10) NOT NULL	When sending carrier information to third party fulfillment systems, this maps our carriers to their carriers.