RO_SEARCH_VW (SQL View)	Index Back
Order Capture Search VW Used to search for Capture Records

RO_SEARCH_VW

(SQL View)

Order Capture Search VW

Used to search for Capture Records

SELECT A.CAPTURE_ID , %subrec(RO_HEADER_SBR,A) , A.RBTNEWACCT , ' ' , A.RBTACCTTYPE , A.RBTPARENTACCTID , A.RBTSPONSOREDACCTID , A.RBTRECPAYMETHOD , A.RBTACCTID_TO , A.RBTACCTID_NONR , %subrec(RB_AUDIT_SBR,A) FROM PS_RO_HEADER A UNION SELECT A.CAPTURE_ID , %subrec(RO_HEADER_SBR,A) , %subrec(RBTORDACCT_SBR,A) , %subrec(RB_AUDIT_SBR,A) FROM PS_RO_HEADER A WHERE A.RBTACCTID <> ' ' UNION SELECT A.CAPTURE_ID , %subrec(RO_HEADER_SBR,A) , A.RBTNEWACCT , L.RBTACCTID , A.RBTACCTTYPE , A.RBTPARENTACCTID , A.RBTSPONSOREDACCTID , A.RBTRECPAYMETHOD , A.RBTACCTID_TO , A.RBTACCTID_NONR , %subrec(RB_AUDIT_SBR,A) FROM PS_RO_HEADER A , PS_RO_LINE L WHERE A.CAPTURE_ID = L.CAPTURE_ID AND L.RBTACCTID <> ' ' AND L.RBTACCTID <> A.RBTACCTID

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RO_NONVW

3 BILL_RECIPIENT_FLG Character(1) VARCHAR2(1) NOT NULL Field used in bulk ordering mode to determinate if the bill will be sent to the recipient's billing address or to the address from the master order.
B=Use Address on Bulk Order
R=Use Recipient Customer Address
Default Value: B

4 BULK_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Flag used to determinate if an order is the master order when using bulk ordering.
Y/N Table Edit
Default Value: N

5 CAPTURE_DATE Date(10) DATE NOT NULL Order capture date used for orders and quotes
Default Value: %date

6 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order
Prompt Table: RO_TYPE

7 CONFIDENCE_PCT Number(3,0) SMALLINT NOT NULL Confidence Percentage

8 CONFIRM_PO_RECVD Character(1) VARCHAR2(1) NOT NULL Purchase Order Received
Y/N Table Edit
Default Value: N

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL

10 ORDER_EXPIRE_DT Date(10) DATE Order Expire Date

11 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
Prompt Table: RT_TYPE_TBL

12 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

13 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

14 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
CC=Credit Card
CHK=Check
DD=Direct Debit
DR=Draft
EFT=Electronic Fund Transfer
INV=Invoice

15 PRICE_RULE_CD Character(10) VARCHAR2(10) NOT NULL Price Rule Code

16 PROD_TERM_CODE Character(5) VARCHAR2(5) NOT NULL Code for Subscriptions Terms - determine the length of the subscription
Prompt Table: RO_SUB_TERM_VW

17 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table: PAY_TRMS_VW

18 QUOTE_DUE_DATE Date(10) DATE This field is used to show the quotes due date and the order scheduled fulfillment date

19 QUOTE_EXPIRE_DT Date(10) DATE Quote Expire Date

20 DUE_DATE Date(10) DATE Delivery Due Date from PO

21 RA_PROMOTION_CODE Character(35) VARCHAR2(35) NOT NULL Marketing - campaign wave promotion code
Prompt Table: RA_WAVEPROMO_VW

22 RESELL_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates that the products on an order will are for resell.
Y/N Table Edit

23 REVISION_NUMBER Number(3,0) SMALLINT NOT NULL Revision

24 RO_BILL_TO_TYPE Character(1) VARCHAR2(1) NOT NULL Field use to determinate if the products are shipped to the partner or to the end customer.
C=Customer
P=Partner
Default Value: C

25 RO_PRIORITY Character(3) VARCHAR2(3) NOT NULL Order Capture Priority
Prompt Table: RO_DEFN_PRIORTY

26 RO_PROCESS_TYPE Character(4) VARCHAR2(4) NOT NULL Field decribes the order process type like resume service, suspend service. It has translate values.
ACT=Activate
CHA=Change Service Attribute
CHG=Change Service
CNCL=Cancel Service
DIS=Disconnect Service
EDCH=Change End Date
NEW=New Service
PAC=PAC Code Request
PORT=Port In Request
RDCH=Change Resume Date
RES=Resume Service
RNW=Renew Service
SNC=Suspend/Change Service
SURE=Suspend / Resume Service
SUS=Suspend Service
Prompt Table: RO_TYPE_PROCTYP

27 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule for integration with Contracts.
Prompt Table: RO_SCHEDULE_VW

28 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL field controls whether or not we allow partial shipments
N=Single Shipment
Y=Ship as Items Available

29 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
Prompt Table: RO_DEFN_SOURCE

30 SUB_SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Field used for storing sub source information
Prompt Table: RO_DEFN_SUB_SRC

31 TRIAL_DURATION Number(3,0) SMALLINT NOT NULL Trial Duration - This field tis used for specifying the Trial duration for all the products purchased in the order for communications vertical.

32 TRIAL_END_DATE Date(10) DATE Trial End Date - Date specifies the Trial end date for all the products purchased within the order for communications

33 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code
Prompt Table: RO_DEFN_HDSTAT

34 SUBMIT_DTTM DateTime(26) TIMESTAMP Submitted Datetime

35 TOTAL_PRICE Signed Number(30,4) DECIMAL(28,4) NOT NULL Total Price

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

37 UID20F_BILL Character(20) VARCHAR2(20) NOT NULL Foreign UID

38 UID20F_BILLC Character(20) VARCHAR2(20) NOT NULL Foreign UID

39 UID20F_R_BILL Character(20) VARCHAR2(20) NOT NULL Field used to store UID of Recurring billing owner

40 UID20F_R_BILLC Character(20) VARCHAR2(20) NOT NULL Field used to store UID of Recurring billing owner contact

41 UID20F_CCOT Character(20) VARCHAR2(20) NOT NULL Credit Card

42 UID20F_CCRC Character(20) VARCHAR2(20) NOT NULL Foreign UID

43 UID20F_PARTNER Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.

44 UID20F_PARTNERC Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.

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

46 UID20F_SOLDC Character(20) VARCHAR2(20) NOT NULL Foreign UID

47 UID20F_SOLDTC Character(20) VARCHAR2(20) NOT NULL This field is for foreign UID of 20 characters long.

48 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number

49 RO_MULTILINE Character(1) VARCHAR2(1) NOT NULL Field to indicate the order is a multi-line service management order
Default Value: N

50 RO_EXEC_DATE Date(10) DATE Field to control the execution date of the business projects for the order. Used by Future Dated Orders.

51 RO_EARLIEST_DATE Date(10) DATE Field to control the earliest fulfillment date based on lead times of the selected products. Used by Future Dated Orders.

52 CONVERT_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Convert Order flag indicates the order is a conversion from a prepaid account to postpaid account
1=Move Nothing
2=Move Phone, SIM, Number
3=Move SIM, Number
4=Move Phone, Number
5=Move Number
6=Move Phone, SIM
7=Move SIM
8=Move Phone
N=Not Conversion Order
Y=Conversion Order
Default Value: N

53 CONVERT_ACCT_ID Character(15) VARCHAR2(15) NOT NULL Converted Account ID for a Conversion Order - used on the order converting a prepaid account to a postpaid one.

54 CONVERT_IP Character(20) VARCHAR2(20) NOT NULL Converted Installed Product for a Conversion Order - used on the order converting a prepaid account/service to a postpaid one.

55 RBT_ICCID_SRCH Character(20) VARCHAR2(20) NOT NULL Field indicating that the ICCID was already checked during Activation Search

56 PRC_ORDER_DATE Date(10) DATE Pricing order date - for repricing an order based on a user date.

57 SELLING_PERIOD_DT Date(10) DATE Product selling period date- date to use on the order for limiting which products are configured

58 RBTNEWACCT Character(1) VARCHAR2(1) NOT NULL New Account
E=Existing Account
N=New Account
R=Reuse New Account

59 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
Prompt Table: RBT_CUSREPAC_VW

60 RBTACCTTYPE Character(4) VARCHAR2(4) NOT NULL Determines the type of Billing Account.
IND=Individual Account
NSUB=Parent Account
PRE=Prepaid Account
SPNR=Sponsored Account
SPON=Sponsoring Account
SUB=Subordinate Account

61 RBTPARENTACCTID Character(15) VARCHAR2(15) NOT NULL Parent Account Id
Prompt Table: RBT_PARACCT_VW

62 RBTSPONSOREDACCTID Character(15) VARCHAR2(15) NOT NULL Sponsored Account Id
Prompt Table: RBT_SPINGACT_VW

63 RBTRECPAYMETHOD Character(4) VARCHAR2(4) NOT NULL Payment Method
CC=New Credit Card
DO=Same as Non-Recurring Charges
ECC=Credit Card on File
INV=Invoice

64 RBTACCTID_TO Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

65 RBTACCTID_NONR Character(15) VARCHAR2(15) NOT NULL Field used for storing nonrecurring Billing Account ID
Prompt Table: RBT_CUSREPAC_VW

66 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

67 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

68 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

69 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

70 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

71 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RO_NONVW
3	BILL_RECIPIENT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Field used in bulk ordering mode to determinate if the bill will be sent to the recipient's billing address or to the address from the master order. B=Use Address on Bulk Order R=Use Recipient Customer Address Default Value: B
4	BULK_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag used to determinate if an order is the master order when using bulk ordering. Y/N Table Edit Default Value: N
5	CAPTURE_DATE	Date(10)	DATE NOT NULL	Order capture date used for orders and quotes Default Value: %date
6	CAPTURE_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Capture Type QUO=Quote SO=Order Prompt Table: RO_TYPE
7	CONFIDENCE_PCT	Number(3,0)	SMALLINT NOT NULL	Confidence Percentage
8	CONFIRM_PO_RECVD	Character(1)	VARCHAR2(1) NOT NULL	Purchase Order Received Y/N Table Edit Default Value: N
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
10	ORDER_EXPIRE_DT	Date(10)	DATE	Order Expire Date
11	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
12	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
13	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
14	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. CC=Credit Card CHK=Check DD=Direct Debit DR=Draft EFT=Electronic Fund Transfer INV=Invoice
15	PRICE_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Price Rule Code
16	PROD_TERM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Code for Subscriptions Terms - determine the length of the subscription Prompt Table: RO_SUB_TERM_VW
17	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. Prompt Table: PAY_TRMS_VW
18	QUOTE_DUE_DATE	Date(10)	DATE	This field is used to show the quotes due date and the order scheduled fulfillment date
19	QUOTE_EXPIRE_DT	Date(10)	DATE	Quote Expire Date
20	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
21	RA_PROMOTION_CODE	Character(35)	VARCHAR2(35) NOT NULL	Marketing - campaign wave promotion code Prompt Table: RA_WAVEPROMO_VW
22	RESELL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates that the products on an order will are for resell. Y/N Table Edit
23	REVISION_NUMBER	Number(3,0)	SMALLINT NOT NULL	Revision
24	RO_BILL_TO_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field use to determinate if the products are shipped to the partner or to the end customer. C=Customer P=Partner Default Value: C
25	RO_PRIORITY	Character(3)	VARCHAR2(3) NOT NULL	Order Capture Priority Prompt Table: RO_DEFN_PRIORTY
26	RO_PROCESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Field decribes the order process type like resume service, suspend service. It has translate values. ACT=Activate CHA=Change Service Attribute CHG=Change Service CNCL=Cancel Service DIS=Disconnect Service EDCH=Change End Date NEW=New Service PAC=PAC Code Request PORT=Port In Request RDCH=Change Resume Date RES=Resume Service RNW=Renew Service SNC=Suspend/Change Service SURE=Suspend / Resume Service SUS=Suspend Service Prompt Table: RO_TYPE_PROCTYP
27	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule for integration with Contracts. Prompt Table: RO_SCHEDULE_VW
28	SHIP_PARTIAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	field controls whether or not we allow partial shipments N=Single Shipment Y=Ship as Items Available
29	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code Prompt Table: RO_DEFN_SOURCE
30	SUB_SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Field used for storing sub source information Prompt Table: RO_DEFN_SUB_SRC
31	TRIAL_DURATION	Number(3,0)	SMALLINT NOT NULL	Trial Duration - This field tis used for specifying the Trial duration for all the products purchased in the order for communications vertical.
32	TRIAL_END_DATE	Date(10)	DATE	Trial End Date - Date specifies the Trial end date for all the products purchased within the order for communications
33	STATUS_CODE	Number(5,0)	INTEGER NOT NULL	Status Code Prompt Table: RO_DEFN_HDSTAT
34	SUBMIT_DTTM	DateTime(26)	TIMESTAMP	Submitted Datetime
35	TOTAL_PRICE	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Total Price
36	UID20F	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID...................................................................
37	UID20F_BILL	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
38	UID20F_BILLC	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
39	UID20F_R_BILL	Character(20)	VARCHAR2(20) NOT NULL	Field used to store UID of Recurring billing owner
40	UID20F_R_BILLC	Character(20)	VARCHAR2(20) NOT NULL	Field used to store UID of Recurring billing owner contact
41	UID20F_CCOT	Character(20)	VARCHAR2(20) NOT NULL	Credit Card
42	UID20F_CCRC	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
43	UID20F_PARTNER	Character(20)	VARCHAR2(20) NOT NULL	This field is for UID of 20 characters long.
44	UID20F_PARTNERC	Character(20)	VARCHAR2(20) NOT NULL	This field is for UID of 20 characters long.
45	UID20F_SOLD	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
46	UID20F_SOLDC	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID
47	UID20F_SOLDTC	Character(20)	VARCHAR2(20) NOT NULL	This field is for foreign UID of 20 characters long.
48	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
49	RO_MULTILINE	Character(1)	VARCHAR2(1) NOT NULL	Field to indicate the order is a multi-line service management order Default Value: N
50	RO_EXEC_DATE	Date(10)	DATE	Field to control the execution date of the business projects for the order. Used by Future Dated Orders.
51	RO_EARLIEST_DATE	Date(10)	DATE	Field to control the earliest fulfillment date based on lead times of the selected products. Used by Future Dated Orders.
52	CONVERT_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Convert Order flag indicates the order is a conversion from a prepaid account to postpaid account 1=Move Nothing 2=Move Phone, SIM, Number 3=Move SIM, Number 4=Move Phone, Number 5=Move Number 6=Move Phone, SIM 7=Move SIM 8=Move Phone N=Not Conversion Order Y=Conversion Order Default Value: N
53	CONVERT_ACCT_ID	Character(15)	VARCHAR2(15) NOT NULL	Converted Account ID for a Conversion Order - used on the order converting a prepaid account to a postpaid one.
54	CONVERT_IP	Character(20)	VARCHAR2(20) NOT NULL	Converted Installed Product for a Conversion Order - used on the order converting a prepaid account/service to a postpaid one.
55	RBT_ICCID_SRCH	Character(20)	VARCHAR2(20) NOT NULL	Field indicating that the ICCID was already checked during Activation Search
56	PRC_ORDER_DATE	Date(10)	DATE	Pricing order date - for repricing an order based on a user date.
57	SELLING_PERIOD_DT	Date(10)	DATE	Product selling period date- date to use on the order for limiting which products are configured
58	RBTNEWACCT	Character(1)	VARCHAR2(1) NOT NULL	New Account E=Existing Account N=New Account R=Reuse New Account
59	RBTACCTID	Character(15)	VARCHAR2(15) NOT NULL	Unique service account indentifier Prompt Table: RBT_CUSREPAC_VW
60	RBTACCTTYPE	Character(4)	VARCHAR2(4) NOT NULL	Determines the type of Billing Account. IND=Individual Account NSUB=Parent Account PRE=Prepaid Account SPNR=Sponsored Account SPON=Sponsoring Account SUB=Subordinate Account
61	RBTPARENTACCTID	Character(15)	VARCHAR2(15) NOT NULL	Parent Account Id Prompt Table: RBT_PARACCT_VW
62	RBTSPONSOREDACCTID	Character(15)	VARCHAR2(15) NOT NULL	Sponsored Account Id Prompt Table: RBT_SPINGACT_VW
63	RBTRECPAYMETHOD	Character(4)	VARCHAR2(4) NOT NULL	Payment Method CC=New Credit Card DO=Same as Non-Recurring Charges ECC=Credit Card on File INV=Invoice
64	RBTACCTID_TO	Character(15)	VARCHAR2(15) NOT NULL	Unique service account indentifier
65	RBTACCTID_NONR	Character(15)	VARCHAR2(15) NOT NULL	Field used for storing nonrecurring Billing Account ID Prompt Table: RBT_CUSREPAC_VW
66	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
67	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
68	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
69	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
70	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
71	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time