CA_PE_CASL_PRS

(SQL Table)
Index Back

Contract Sales Personalization

ESA Portal Packs OTA: Contract Sales Personalization record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

Y/N Table Edit

3 MY_CONTRACTS Character(1) VARCHAR2(1) NOT NULL Contracts

Y/N Table Edit

4 CA_BU_SOURCE Character(1) VARCHAR2(1) NOT NULL Determines source of the Business Unit CA - from user preference or specified value.
S=Specify
U=User Preferences

Default Value: U

5 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

Prompt Table: SP_BU_CA_NONVW

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

7 CA_REGION_SOURCE Character(1) VARCHAR2(1) NOT NULL Region code source
S=Specifiy Region Code
U=From User Preference

Default Value: U

8 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

Prompt Table: CA_REGION_CD_VW

9 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

Prompt Table: CA_TYPE_TBL

10 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
FED=Federal Reimbursable Agreement
GEN=Generic Application
GOV=Government
INT=Internal
OND=CRM Field Services On Demand
STD=Standard
11 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status

Prompt Table: CA_STATUS_TBL

12 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW

13 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

Prompt Table: PC_CAL_BP_VW

14 NUM_PER Number(3,0) SMALLINT NOT NULL Number of Periods
15 TARGET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Target Sales
16 WARNING_PERCENT Number(3,0) SMALLINT NOT NULL The percentage of the target threshold that would trigger a warning.
17 SHOW_ALERT_IND Character(1) VARCHAR2(1) NOT NULL Indicator to determine whether to always show threshold alert or only when in Alert condition.
N=No
Y=Only if Alert

Y/N Table Edit