RF_IPRD_RO_LNVW

(SQL View)
 Index Back

Order Line Record

This view is used by the Installed Product record to retrieve order line details associated with a Capture ID.

SELECT A.CAPTURE_ID , A.UID20 , %subrec(RO_LINE_SBR, A) , %subrec(RB_AUDIT_SBR, A) FROM PS_RO_LINE A

  • Parent record: RO_HEADER

    • # 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 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 RO_VAL_ZERO_PRICE Character(1) VARCHAR2(1) NOT NULL Valid Zero onetime list price

    Y/N Table Edit

    Default Value: N

    5 RO_VAL_ZERO_RPRICE Character(1) VARCHAR2(1) NOT NULL Valid Zero recurring list price

    Y/N Table Edit

    Default Value: N

    6 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    7 ACNT_ID Character(18) VARCHAR2(18) NOT NULL Contract ID

    Prompt Table: RBF_ACNT

    8 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier

    Prompt Table: RBT_CUSREPAC_VW

    9 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
    11 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
    12 END_DT Date(10) DATE This field stores the end date values.
    13 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.

    Prompt Table: RO_DEFN_HLD_DEN

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

    Prompt Table: RF_INST_PROD

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

    Prompt Table: RO_DEFN_LNACTN

    16 LINE_ACTION_REASON Character(6) VARCHAR2(6) NOT NULL Actions available on an Order - ie Change Features, Renew, Cancel.
    17 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
    18 LINE_NBR_PKG_GROUP Number(5,0) INTEGER NOT NULL Package Group Line Number
    19 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    20 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

    Prompt Table: LOCATION_VW1

    21 MIN_PRICE Number(16,4) DECIMAL(15,4) NOT NULL Minimum Price
    22 ORD_LINE_TAG Number(5,0) INTEGER NOT NULL Order Line tag for Giveaways Products. Identifies which lines have a giveaway.
    23 ORD_LINE_TAG_ADDS Number(5,0) INTEGER NOT NULL Order line tag for Product Adds
    24 PARENT_LINE_NBR Number(5,0) INTEGER NOT NULL Parent Line #
    25 PARENT_LN_TOP_NBR Number(5,0) INTEGER NOT NULL Top Parent Line Number
    26 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    27 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
    28 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected

    Y/N Table Edit

    Default Value: N

    29 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
    30 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
    31 RA_PROMOTION_CODE Character(35) VARCHAR2(35) NOT NULL Marketing - campaign wave promotion code

    Prompt Table: RA_WAVEPROMO_VW

    32 RECUR_LIST_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price
    33 RECUR_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price
    34 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

    Default Value: N

    35 START_DT Date(10) DATE Start date field to store start date value.
    36 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code

    Default Value: 1000

    Prompt Table: RO_DEFN_LNSTAT

    37 UID20F Character(20) VARCHAR2(20) NOT NULL Foreign UID...................................................................
    38 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_PRDUOMDSC_VW

    39 AGREE_LINE_NBR Number(5,0) INTEGER NOT NULL Agreement Line
    40 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
    41 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    42 DURATION Number(5,0) INTEGER NOT NULL Field for IBM development. Lead Time used in SM
    43 DURATION_FREQ Character(1) VARCHAR2(1) NOT NULL Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months.
    D=Days
    M=Months
    Q=Quarters
    W=Weeks
    Y=Years
    44 TMP_SERVICE Character(1) VARCHAR2(1) NOT NULL Indicates if the Service is temporary

    Y/N Table Edit

    Default Value: N

    45 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

    Y/N Table Edit

    Default Value: N

    46 RBTNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
    47 RBTOLDNUMBER Character(15) VARCHAR2(15) NOT NULL Number For Telco
    48 RO_EXISTING_PHONE Character(1) VARCHAR2(1) NOT NULL Field to indicate on the line whether to use the existing phone during conversion.

    Y/N Table Edit

    Default Value: N

    49 RO_EXISTING_SIM Character(1) VARCHAR2(1) NOT NULL Field to indicate whether to use the existing SIM during a conversion.

    Y/N Table Edit

    Default Value: N

    50 CONFIG_STATUS Character(4) VARCHAR2(4) NOT NULL Field used for storing advanced product configuration status of order line information

    Prompt Table: CFG_STATUS_TBL

    51 APC_PROD_INSTANCE Character(20) VARCHAR2(20) NOT NULL Field used for storing Controller product instance information
    52 APC_COMM_INSTANCE Character(20) VARCHAR2(20) NOT NULL Field store UID of Commitment Product.
    53 APC_PARENT_INSNC Character(20) VARCHAR2(20) NOT NULL Field used for storing Controller instance of parent product information
    54 UID20F_SOLDTO Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.
    55 MIGRATED_FLAG Character(1) VARCHAR2(1) NOT NULL Field used for storing information that order line is migrated
    56 APC_CHG_ACTION_FLG Character(1) VARCHAR2(1) NOT NULL Field used for storing change action returned from advanced product configurator
    57 REL_CONTRACT_FLG Character(1) VARCHAR2(1) NOT NULL Field used for storing information that contract is related with other contract(s) by order line relationship(s)
    58 OLD_LINE_NBR_P_GRP Number(5,0) INTEGER NOT NULL Field used for storing old LINE_NBR_PKG_GROUP before migration
    59 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    60 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    61 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    62 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    63 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.
    64 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time