RO_HEADER

(SQL Table)
Index Back

Capture Header Table

This record is the main level 0 record used by order capture to create an order.

  • Related Language Record: RO_HEADER_LANG
  • Parent Record Of RF_IPRD_RO_LNVW ROT_LINE RO_ADDRESS RO_ADDRESS_HST RO_BOID RO_BOID_HST RO_BOID_SBR RO_DEST RO_DEST_LANG RO_DEST_LG_HST RO_HOLD RO_HOLD_HST RO_LINE RO_LINE_EXT RO_LINE_HST RO_NOTE RO_NOTE_LANG RO_NOTE_LG_HST RO_PP_ACCT RO_XML RO_XML_HST UPG_RO_RBILL UPG_RO_RBILLC
  • # 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