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

BU_TBL_ROCARLVW

(SQL View)

Carrier description by BU

List of valid carriers & ship methods by Order Capture BU

SELECT A.BUSINESS_UNIT , A.CARRIER , B.LANGUAGE_CD , B.DESCR100 FROM %Table(BU_TBL_RO_CAR) A , %Table(CARRIER_TBL_LNG) 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

Related Language Record for BU_TBL_RO_CARVW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description