RO_LINE_CUST_VW (SQL View)	Index Back
Line Detail This record is a view which contains the customers line details

RO_LINE_CUST_VW

(SQL View)

Line Detail

This record is a view which contains the customers line details

SELECT LIN.CAPTURE_ID , LIN.UID20 , LIN.LINE_NBR , LIN.AGREE_LINE_NBR , LIN.PRODUCT_ID , LIN.AGREEMENT_CODE , LIN.LINE_ACTION , LIN.LIST_PRICE , LIN.PRICE , LIN.RECUR_PRICE , LIN.RECUR_LIST_PRICE , LIN.PPRC_RECUR_FREQ , LIN.FREE_PERIODS , LIN.QTY_ORDERED , LIN.STATUS_CODE , LIN.UNIT_OF_MEASURE , LIN.CURRENCY_CD , LIN.PORT_IN_FLAG , LIN.HOLD_DENIAL_CD ,LIN.INST_PROD_ID , SHP.BO_ID , SHP.UID20 , SHP.PROFILE_CM_SEQ , SHP.UID20F_ADDR , DSS.CARRIER , DSS.REQ_ARRIVAL_DATE , DSS.UID20 , SHP.BO_ID_EIP , SHP.PROFILE_CM_SEQ_EIP FROM PS_RO_LINE LIN , PS_RO_DEST DSS , PS_RO_BOID SHP WHERE LIN.CAPTURE_ID=DSS.CAPTURE_ID AND LIN.UID20F=DSS.UID20 AND DSS.CAPTURE_ID=SHP.CAPTURE_ID AND DSS.UID20F_SHIP=SHP.UID20

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

2 UID20F Character(20) VARCHAR2(20) NOT NULL Foreign UID...................................................................

3 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.

4 AGREE_LINE_NBR Number(5,0) INTEGER NOT NULL Agreement Line

5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

6 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

7 LINE_ACTION Character(4) VARCHAR2(4) NOT NULL Actions available on an Order - ie Change Features, Renew, Cancel.

8 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

9 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.

10 RECUR_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price

11 RECUR_LIST_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price

12 PPRC_RECUR_FREQ Character(2) VARCHAR2(2) NOT NULL Field used to store the recurring frequency.
00=Daily
05=Weekly
10=Monthly
15=Quarterly
20=Annually

13 FREE_PERIODS Number(3,0) SMALLINT NOT NULL Free Periods - used by Pricing to indicate number of free periods for a product with recurring pricing

14 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty

15 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code

16 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

18 PORT_IN_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to indicate if this business unit will allow porting in of other carrier's phone numbers

19 HOLD_DENIAL_CD Character(6) VARCHAR2(6) NOT NULL Define the hold denial codes that can be used by order capture an enterprise user want to deny an order that was placed by a partner user and went on hold.

20 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

21 BO_ID_SHIP Number(31,0) DECIMAL(31) NOT NULL Business Object ID

22 UID20F_SOLD Character(20) VARCHAR2(20) NOT NULL Foreign UID

23 PROFILE_CM_SEQ_SHP Number(31,0) DECIMAL(31) NOT NULL Profile Sequence

24 UID20F_ADDR Character(20) VARCHAR2(20) NOT NULL Foreign UID

25 CARRIER Character(10) VARCHAR2(10) NOT NULL Carrier or preferred carrier. Also used for Shipping Method.
Prompt Table: CARRIER_VW

26 REQ_ARRIVAL_DATE Date(10) DATE Requested Arrival Date

27 UID20F_SHIP Character(20) VARCHAR2(20) NOT NULL Foreign UID...................................................................

28 BO_ID_EIP_SHP Signed Number(32,0) DECIMAL(31) NOT NULL This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems

29 PRO_CM_SEQ_EIP_SHP Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	UID20F	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID...................................................................
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	This field represents the integer Order Line Number.
4	AGREE_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Agreement Line
5	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
6	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
7	LINE_ACTION	Character(4)	VARCHAR2(4) NOT NULL	Actions available on an Order - ie Change Features, Renew, Cancel.
8	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
9	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
10	RECUR_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Recurring Price
11	RECUR_LIST_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Recurring Price
12	PPRC_RECUR_FREQ	Character(2)	VARCHAR2(2) NOT NULL	Field used to store the recurring frequency. 00=Daily 05=Weekly 10=Monthly 15=Quarterly 20=Annually
13	FREE_PERIODS	Number(3,0)	SMALLINT NOT NULL	Free Periods - used by Pricing to indicate number of free periods for a product with recurring pricing
14	QTY_ORDERED	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Order Qty
15	STATUS_CODE	Number(5,0)	INTEGER NOT NULL	Status Code
16	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
18	PORT_IN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate if this business unit will allow porting in of other carrier's phone numbers
19	HOLD_DENIAL_CD	Character(6)	VARCHAR2(6) NOT NULL	Define the hold denial codes that can be used by order capture an enterprise user want to deny an order that was placed by a partner user and went on hold.
20	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
21	BO_ID_SHIP	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
22	UID20F_SOLD	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
23	PROFILE_CM_SEQ_SHP	Number(31,0)	DECIMAL(31) NOT NULL	Profile Sequence
24	UID20F_ADDR	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
25	CARRIER	Character(10)	VARCHAR2(10) NOT NULL	Carrier or preferred carrier. Also used for Shipping Method. Prompt Table: CARRIER_VW
26	REQ_ARRIVAL_DATE	Date(10)	DATE	Requested Arrival Date
27	UID20F_SHIP	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID...................................................................
28	BO_ID_EIP_SHP	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems
29	PRO_CM_SEQ_EIP_SHP	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.