RO_SEARCH_VW_B(SQL View) |
Index Back |
|---|---|
Order Capture Search VWUsed to search for Capture Records |
| SELECT A.CAPTURE_ID , B.BO_ID , C.BO_ID , B.ROLE_TYPE_ID , C.ROLE_TYPE_ID , D.PRODUCT_ID , %subrec(RO_HEADER_SBR,A) FROM PS_RO_HEADER A , PS_RO_BOID C , PS_RO_BOID B , PS_RO_LINE D WHERE A.CAPTURE_ID=B.CAPTURE_ID AND A.UID20F_SOLD=B.UID20 AND A.CAPTURE_ID=D.CAPTURE_ID AND A.CAPTURE_ID=C.CAPTURE_ID (+) AND A.UID20F_SOLDC=C.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 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 3 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 4 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 5 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 6 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RO_NONVW |
| 8 | 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 |
| 9 | 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 |
| 10 | CAPTURE_DATE | Date(10) | DATE NOT NULL |
Order capture date used for orders and quotes
Default Value: %date |
| 11 | CAPTURE_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order Prompt Table: RO_TYPE |
| 12 | CONFIDENCE_PCT | Number(3,0) | SMALLINT NOT NULL | Confidence Percentage |
| 13 | CONFIRM_PO_RECVD | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Order Received
Y/N Table Edit Default Value: N |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL |
| 15 | ORDER_EXPIRE_DT | Date(10) | DATE | Order Expire Date |
| 16 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 17 | CUSTOMER_PO | Character(25) | VARCHAR2(25) NOT NULL | Customer PO |
| 18 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 19 | 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 |
| 20 | PRICE_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Price Rule Code |
| 21 | 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 |
| 22 | 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 |
| 23 | QUOTE_DUE_DATE | Date(10) | DATE | This field is used to show the quotes due date and the order scheduled fulfillment date |
| 24 | QUOTE_EXPIRE_DT | Date(10) | DATE | Quote Expire Date |
| 25 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |
| 26 | RA_PROMOTION_CODE | Character(35) | VARCHAR2(35) NOT NULL |
Marketing - campaign wave promotion code
Prompt Table: RA_WAVEPROMO_VW |
| 27 | RESELL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates that the products on an order will are for resell.
Y/N Table Edit |
| 28 | REVISION_NUMBER | Number(3,0) | SMALLINT NOT NULL | Revision |
| 29 | 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 |
| 30 | RO_PRIORITY | Character(3) | VARCHAR2(3) NOT NULL |
Order Capture Priority
Prompt Table: RO_DEFN_PRIORTY |
| 31 | 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 |
| 32 | SCHEDULE | Character(10) | VARCHAR2(10) NOT NULL |
Schedule for integration with Contracts.
Prompt Table: RO_SCHEDULE_VW |
| 33 | 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 |
| 34 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL |
Source Code
Prompt Table: RO_DEFN_SOURCE |
| 35 | SUB_SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL |
Field used for storing sub source information
Prompt Table: RO_DEFN_SUB_SRC |
| 36 | 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. |
| 37 | 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 |
| 38 | STATUS_CODE | Number(5,0) | INTEGER NOT NULL |
Status Code
Prompt Table: RO_DEFN_HDSTAT |
| 39 | SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Submitted Datetime |
| 40 | TOTAL_PRICE | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Total Price |
| 41 | UID20F | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID................................................................... |
| 42 | UID20F_BILL | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID |
| 43 | UID20F_BILLC | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID |
| 44 | UID20F_R_BILL | Character(20) | VARCHAR2(20) NOT NULL | Field used to store UID of Recurring billing owner |
| 45 | UID20F_R_BILLC | Character(20) | VARCHAR2(20) NOT NULL | Field used to store UID of Recurring billing owner contact |
| 46 | UID20F_CCOT | Character(20) | VARCHAR2(20) NOT NULL | Credit Card |
| 47 | UID20F_CCRC | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID |
| 48 | UID20F_PARTNER | Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 49 | UID20F_PARTNERC | Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 50 | UID20F_SOLD | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID |
| 51 | UID20F_SOLDC | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID |
| 52 | UID20F_SOLDTC | Character(20) | VARCHAR2(20) NOT NULL | This field is for foreign UID of 20 characters long. |
| 53 | FIN_ACCOUNT_ID | Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 54 | RO_MULTILINE | Character(1) | VARCHAR2(1) NOT NULL |
Field to indicate the order is a multi-line service management order
Default Value: N |
| 55 | RO_EXEC_DATE | Date(10) | DATE | Field to control the execution date of the business projects for the order. Used by Future Dated Orders. |
| 56 | 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. |
| 57 | 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 |
| 58 | 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. |
| 59 | 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. |
| 60 | RBT_ICCID_SRCH | Character(20) | VARCHAR2(20) NOT NULL | Field indicating that the ICCID was already checked during Activation Search |
| 61 | PRC_ORDER_DATE | Date(10) | DATE | Pricing order date - for repricing an order based on a user date. |
| 62 | SELLING_PERIOD_DT | Date(10) | DATE | Product selling period date- date to use on the order for limiting which products are configured |