RO_HEADER(SQL Table) |
Index Back |
---|---|
Capture Header TableThis record is the main level 0 record used by order capture to create an order. |
# | 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 |