| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
AGREEMENT_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
This field represents the agreement code (name) for an agreement
|
| 3 |
AGR_RENEWAL_NUM |
Number(4,0) |
SMALLINT NOT NULL |
This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
Default Value: 1
|
| 4 |
RENEWAL_DATE |
Date(10) |
DATE |
This field is used to represent the renewal date for an agreement
|
| 5 |
AGREEMENT_TYPE |
Number(9,0) |
DECIMAL(9) NOT NULL |
This field represents the type of the agreement.
|
| 6 |
AGRT_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
This field represents the agreement status value.
001=Pending
002=Pending Activation
003=Action Required
005=Active
009=Closed
|
| 7 |
AGREEMENT_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for defining the Category for the Agreement, to be used in the Agreement Header Record.
1=External
2=Internal
3=External - No Pricing
Default Value: 1
|
| 8 |
AGR_SCOPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field denotes the scope for the agreement (site, contact, etc.)
CONT=Contact
SITE=Site
|
| 9 |
AGR_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
This field stores the Agreement template id.
|
| 10 |
AGR_TEMPLATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Agreement Template Flag (Indicates if agreement entry is a template)
Y/N Table Edit
|
| 11 |
START_DT |
Date(10) |
DATE NOT NULL |
Start date field to store start date value.
Default Value: %Date
|
| 12 |
END_DT |
Date(10) |
DATE |
This field stores the end date values.
|
| 13 |
DESCR80 |
Character(80) |
VARCHAR2(80) NOT NULL |
This generic field stores the description and used used on various tables.
|
| 14 |
DATE_ACTIVATED |
Date(10) |
DATE |
Date of Acitvation on the Agreement Header which is equivalent to the Signed Date of the Contract
|
| 15 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
This field stores the General Ledger Business Unit. Used for the Integration with Contracts/Billing from CRM.
Prompt Table:
SP_BU_FS_NONVW
|
| 16 |
BILLING_DATE |
Date(10) |
DATE |
This field represents the billing date
|
| 17 |
MAX_CONTACTS |
Number(6,0) |
INTEGER NOT NULL |
This field is used to represent the maximum allowed number of contacts for an agreement.
|
| 18 |
PURCHASE_OPTION |
Character(50) |
VARCHAR2(50) NOT NULL |
This field is used to represent a purchase option.
|
| 19 |
SITE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
RF_REPSITES_VW
|
| 20 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 21 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the value for Sold To Customer
|
| 22 |
CR_ADDRESS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Address ID of a Customer.
|
| 23 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Country Code values.
|
| 24 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
This field stores the Telephone number.
|
| 25 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
This field stores the Phone extension.
|
| 26 |
ENTITLE_PLAN_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
This field represents the Entitlement Plan Name
Prompt Table:
%EDITTABLE4
|
| 27 |
SERVICE_LVL_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
This field stores the Service Level Code.
7X24=7X24
ENH=Enhanced
PREF=Preferred
PREM=Premium
STD=Standard
|
| 28 |
SVC_LVL_DISCOUNT |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Intended to represent the uplift or discount associated with a particular service level
|
| 29 |
RESPONSE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Intended to store a response time name value
Prompt Table:
RF_ENTITLEMENTS
|
| 30 |
RESP_TIME_DISCOUNT |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Intended to store a response time discount amount
|
| 31 |
RESTORE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Intended to store the restore time name value
Prompt Table:
RF_ENTITLEMENTS
|
| 32 |
REST_TIME_DISCOUNT |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Intended to store a restore time discount percent
|
| 33 |
MANUAL_DISCOUNT |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
This field is used as a percentage uplift or discount to the total agreement price
|
| 34 |
AGRT_AMOUNT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
This field represents the total amount (price) for an agreement
|
| 35 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table:
CURRENCY_CD_TBL
|
| 36 |
AGR_MONTHLY_PRICE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
This field represents the monthly price for an agreement or agreement line
|
| 37 |
AGRT_BASE_AMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
This field represents the base amount (price) for an agreement
|
| 38 |
AGR_MONTH_DUR |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
This field represents the duration of an agreement expressed in months
|
| 39 |
PROVIDER_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table:
RF_PROVGRP_VW2
|
| 40 |
GRP_MEMBER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Used to store the PERSON_ID of each group member in the provider group.
Prompt Table:
RF_GRP_MEM_VW
|
| 41 |
AGRT_EXP_LEN |
Number(6,0) |
INTEGER NOT NULL |
This field represents the agreement expense duration length
|
| 42 |
AGRT_EXP_PCT |
Number(3,0) |
SMALLINT NOT NULL |
This field represents the agreement expense percentage
|
| 43 |
AGRT_EXP_UOM |
Character(4) |
VARCHAR2(4) NOT NULL |
This field represents the agreement expense unit of measurement
DAY=Day
MON=Month
WK=Week
YR=Year
|
| 44 |
AGRT_MAT_LEN |
Number(6,0) |
INTEGER NOT NULL |
This field represents the agreement material length
|
| 45 |
AGRT_MAT_PCT |
Number(3,0) |
SMALLINT NOT NULL |
This field represents the agreement material percent
|
| 46 |
AGRT_MAT_UOM |
Character(4) |
VARCHAR2(4) NOT NULL |
This field represents the agreement material unit of measure
DAY=Day
MON=Month
WK=Week
YR=Year
|
| 47 |
AGRT_TIME_LEN |
Number(6,0) |
INTEGER NOT NULL |
This field represents the time length for use by agreement
|
| 48 |
AGRT_TIME_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Time Percentage for use by Agreement
|
| 49 |
AGRT_TIME_UOM |
Character(4) |
VARCHAR2(4) NOT NULL |
Unit of Measurement for Agreement Time
DAY=Day
MON=Month
WK=Week
YR=Year
|
| 50 |
ENTITLE_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
This field represents an entitlement method
BOTH=Site or Contact
CONT=Contact
SITE=Site
|
| 51 |
ALLOW_ALL_SVC |
Number(1,0) |
SMALLINT NOT NULL |
This is intended to allow all Services in the Agreement.
|
| 52 |
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
|
| 53 |
TERMS |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used to represent payment terms
FOC=Free of Charge
N30=Net 30 Days
N90=Net 90 Days
PIF=Pay in Full
|
| 54 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 55 |
BILLING_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
This field represents the Billing Frequency
A=Annually
B=Bi-weekly
M=Monthly
Q=Quarterly
|
| 56 |
PAY_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.
CC=Credit Card
CHK=Check
PO=Purchase Order
|
| 57 |
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
|
| 58 |
NOTE |
Long Character(256) |
VARCHAR2(256) |
This is a generic field to store the note.
|
| 59 |
ACTIVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Status
N=Inactive
Y=Active
|
| 60 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 61 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 62 |
PROFILE_CM_SEQ_SLD |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile Contact Method Sequence Number for the Sold To Address
Prompt Table:
RF_BO_SOLD_ADDR
|
| 63 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 64 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 65 |
PROFILE_CM_SEQ_PH1 |
Number(31,0) |
DECIMAL(31) NOT NULL |
Used to store the contact method sequence number for a primary phone number.
|
| 66 |
BO_ID_BILL |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
Prompt Table:
RF_BO_BILLTO
|
| 67 |
ROLE_TYPE_ID_BILL |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID for Bill to Customer
|
| 68 |
PROFILE_CM_SEQ_BIL |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile Contact Method Sequence Number for Billing
Prompt Table:
RF_BO_BILL_ADDR
|
| 69 |
BO_ID_CONTACT_BILL |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID for Bill to Contact
Prompt Table:
RF_BO_BILL_CONT
|
| 70 |
ROLE_TYPE_ID_C_BIL |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the Bill To Contact
|
| 71 |
PROFILE_CM_SEQ_PH2 |
Number(31,0) |
DECIMAL(31) NOT NULL |
Used to store the contact method sequence number for an alternate phone number.
Prompt Table:
RF_BO_CNTCT_PHN
|
| 72 |
BO_ID_CUST_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 73 |
BO_ID_CONTACT_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 74 |
BO_ID_BILL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 75 |
BO_ID_CNT_BILL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID for Bill to Contact
|
| 76 |
PROFILE_CM_SLD_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile Contact Method Sequence Number for the Sold To Address
|
| 77 |
PROFILE_CM_BIL_INT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Profile Contact Method Sequence Number for Billing
|
| 78 |
ADD_ADJ_AMT |
Signed Number(22,5) |
DECIMAL(20,5) NOT NULL |
Adjustment Amount for Discount or for Uplift
|
| 79 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Used to store the identification number for the reason code.
Prompt Table:
RF_AG_REASON_VW
|
| 80 |
ADJUST_REASON |
Character(254) |
VARCHAR2(254) NOT NULL |
Adhoc Reason for the Adjustment, Uplift or Discount.
|
| 81 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule for integration with Contracts.
Prompt Table:
RF_SCHED_TBL_VW
Set Control Field: SETID
|
| 82 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table:
TAX_HEADER_TBL
|
| 83 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
|
| 84 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
Prompt Table:
RF_BO_TAX_EX_VW
|
| 85 |
LEAD_CREATE_DATE |
Date(10) |
DATE |
Sales Lead Created
|
| 86 |
AGRT_DEF_LEN |
Number(6,0) |
INTEGER NOT NULL |
Agreement Default Length describes the length that that the Order Capture Agreement should last.
|
| 87 |
AGRT_DEF_UOM |
Character(4) |
VARCHAR2(4) NOT NULL |
Agreement Default Unit field describes the unit of measure (month, day, year, etc) for the Order Capture Created Agreement.
DAY=Days
MON=Months
WK=Weeks
YR=Years
|
| 88 |
RO_CAPTURE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if an agreement is created through Order Capture. It also indicates if an Agreement Template may be sold through Order Capture.
N=No
Y=Yes
Default Value: N
|
| 89 |
RH |
Character(1) |
VARCHAR2(1) NOT NULL |
IT HelpDesk
Y/N Table Edit
|
| 90 |
RHHR |
Character(1) |
VARCHAR2(1) NOT NULL |
HR HelpDesk
Y/N Table Edit
|
| 91 |
ROLETYPE_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag value to determine if the worker has Employee Role Type.
|
| 92 |
ROLETYPE_CW |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag value to determine if the worker has Contingent Worker Role Type.
|
| 93 |
ROLETYPE_POI |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag value to determine if the person has POI role type.
|
| 94 |
HR_STAT_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for Active Worker Status.
|
| 95 |
HR_STAT_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for Inactive Worker Status.
|
| 96 |
HDR_PREPAID_QTY |
Number(6,0) |
INTEGER NOT NULL |
This field is used to store the Prepaid Quantity.
|
| 97 |
HDR_PREPAID_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Prepaid Unit. The field is used to store prepaid unit options for agreement of category External - No Pricing.
CASE=Case
HOUR=Hour
SO=Service Order
|
| 98 |
HDR_SERVICE_CTR |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
This field is used to represent the remaining quantity available for pre-paid services
|
| 99 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
|
| 100 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 101 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 102 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 103 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 104 |
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.
|
| 105 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|