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