RBT_LINECMP_AET

(SQL Table)
Index Back

CRM account AE record

This record is used in application engine program for communication industry

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.
5 ACTIVITY_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Activity Instance
6 RC_MAIN_BP_INSTNCE Number(18,0) DECIMAL(18) NOT NULL RC_MAIN_BP_INSTNCE
7 PARENT_BP_INSTNCE Number(18,0) DECIMAL(18) NOT NULL Parent BP Instance
8 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
9 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
10 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.
11 MAIN_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Main Activity Id
12 MAIN_ACTIVITY_INST Number(18,0) DECIMAL(18) NOT NULL Main Activity Instance
13 PARENT_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Parent Activity Id
14 PARENT_ACTVTY_INST Number(18,0) DECIMAL(18) NOT NULL Parent Activity Instance
15 RC_TASK_ID Character(15) VARCHAR2(15) NOT NULL Task ID used for Business Process tracking.
16 NESTED_BP_IND Character(1) VARCHAR2(1) NOT NULL Sub Business Project
N=No
Y=Yes
17 RC_TASK_STATUS Character(1) VARCHAR2(1) NOT NULL Task Status used in Business Process tracking.
C=Complete
L=Cancelled
N=Not Started
P=In Process
18 RC_OUTCOME Character(1) VARCHAR2(1) NOT NULL Outcome of a Task for Business Process tracking. See translates for possible values.
F=Failure
S=Success
19 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
20 PROCESSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
21 PROCESSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
22 MARKET Character(3) VARCHAR2(3) NOT NULL Market