| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field use to store the capture ID in order capture.
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RO_NONVW
|
| 5 |
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
|
| 6 |
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
|
| 7 |
CAPTURE_DATE |
Date(10) |
DATE NOT NULL |
Order capture date used for orders and quotes
Default Value: %date
|
| 8 |
CAPTURE_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote
SO=Order
Prompt Table:
RO_TYPE
|
| 9 |
CONFIDENCE_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Confidence Percentage
|
| 10 |
CONFIRM_PO_RECVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Received
Y/N Table Edit
Default Value: N
|
| 11 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
ORDER_EXPIRE_DT |
Date(10) |
DATE |
Order Expire Date
|
| 13 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 14 |
CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer PO
|
| 15 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 16 |
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
|
| 17 |
PRICE_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Price Rule Code
|
| 18 |
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
|
| 19 |
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
|
| 20 |
QUOTE_DUE_DATE |
Date(10) |
DATE |
This field is used to show the quotes due date and the order scheduled fulfillment date
|
| 21 |
QUOTE_EXPIRE_DT |
Date(10) |
DATE |
Quote Expire Date
|
| 22 |
DUE_DATE |
Date(10) |
DATE |
Delivery Due Date from PO
|
| 23 |
RA_PROMOTION_CODE |
Character(35) |
VARCHAR2(35) NOT NULL |
Marketing - campaign wave promotion code
Prompt Table:
RA_WAVEPROMO_VW
|
| 24 |
RESELL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that the products on an order will are for resell.
Y/N Table Edit
|
| 25 |
REVISION_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Revision
|
| 26 |
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
|
| 27 |
RO_PRIORITY |
Character(3) |
VARCHAR2(3) NOT NULL |
Order Capture Priority
Prompt Table:
RO_DEFN_PRIORTY
|
| 28 |
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
|
| 29 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule for integration with Contracts.
Prompt Table:
RO_SCHEDULE_VW
|
| 30 |
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
|
| 31 |
SOURCE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Source Code
Prompt Table:
RO_DEFN_SOURCE
|
| 32 |
SUB_SOURCE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Field used for storing sub source information
Prompt Table:
RO_DEFN_SUB_SRC
|
| 33 |
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.
|
| 34 |
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
|
| 35 |
STATUS_CODE |
Number(5,0) |
INTEGER NOT NULL |
Status Code
Prompt Table:
RO_DEFN_HDSTAT
|
| 36 |
SUBMIT_DTTM |
DateTime(26) |
TIMESTAMP |
Submitted Datetime
|
| 37 |
TOTAL_PRICE |
Signed Number(30,4) |
DECIMAL(28,4) NOT NULL |
Total Price
|
| 38 |
UID20F |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID...................................................................
|
| 39 |
UID20F_BILL |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 40 |
UID20F_BILLC |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 41 |
UID20F_R_BILL |
Character(20) |
VARCHAR2(20) NOT NULL |
Field used to store UID of Recurring billing owner
|
| 42 |
UID20F_R_BILLC |
Character(20) |
VARCHAR2(20) NOT NULL |
Field used to store UID of Recurring billing owner contact
|
| 43 |
UID20F_CCOT |
Character(20) |
VARCHAR2(20) NOT NULL |
Credit Card
|
| 44 |
UID20F_CCRC |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 45 |
UID20F_PARTNER |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for UID of 20 characters long.
|
| 46 |
UID20F_PARTNERC |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for UID of 20 characters long.
|
| 47 |
UID20F_SOLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 48 |
UID20F_SOLDC |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 49 |
UID20F_SOLDTC |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for foreign UID of 20 characters long.
|
| 50 |
FIN_ACCOUNT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Financial Account Number
|
| 51 |
RO_MULTILINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to indicate the order is a multi-line service management order
Default Value: N
|
| 52 |
RO_EXEC_DATE |
Date(10) |
DATE |
Field to control the execution date of the business projects for the order. Used by Future Dated Orders.
|
| 53 |
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.
|
| 54 |
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
|
| 55 |
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.
|
| 56 |
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.
|
| 57 |
RBT_ICCID_SRCH |
Character(20) |
VARCHAR2(20) NOT NULL |
Field indicating that the ICCID was already checked during Activation Search
|
| 58 |
PRC_ORDER_DATE |
Date(10) |
DATE |
Pricing order date - for repricing an order based on a user date.
|
| 59 |
SELLING_PERIOD_DT |
Date(10) |
DATE |
Product selling period date- date to use on the order for limiting which products are configured
|
| 60 |
RBTNEWACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Account
E=Existing Account
N=New Account
R=Reuse New Account
|
| 61 |
RBTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
Prompt Table:
RBT_CUSREPAC_VW
|
| 62 |
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
|
| 63 |
RBTPARENTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Parent Account Id
Prompt Table:
RBT_PARACCT_VW
|
| 64 |
RBTSPONSOREDACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sponsored Account Id
Prompt Table:
RBT_SPINGACT_VW
|
| 65 |
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
|
| 66 |
RBTACCTID_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
|
| 67 |
RBTACCTID_NONR |
Character(15) |
VARCHAR2(15) NOT NULL |
Field used for storing nonrecurring Billing Account ID
Prompt Table:
RBT_CUSREPAC_VW
|
| 68 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 69 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 70 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 71 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 72 |
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.
|
| 73 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|