RUN_CNTL_CUST

(SQL Table)
Index Back

FS/CUST Process Run Control

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

Default Value: PRCSRUNCNTL.OPRID

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Default Value: PRCSRUNCNTL.RUN_CNTL_ID

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 RPT_DEST Character(50) VARCHAR2(50) NOT NULL File Destination
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUARDS_NONVW

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

7 CR_ANALYST Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.

Prompt Table: %EDITTABLE

8 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.

Prompt Table: %EDITTABLE2

9 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.

Prompt Table: %EDITTABLE3

10 CUST_TYPE_DSP Character(1) VARCHAR2(1) NOT NULL Customer Type
%=All
1=User 1
2=User 2
3=User 3
4=User 4
11 CUST_STATUS_DSP Character(1) VARCHAR2(1) NOT NULL Customer Status
%=All
A=Active
I=Inactive
12 USER_CHOICE Character(1) VARCHAR2(1) NOT NULL Sort Option
1=Sort by Customer Number
2=Sort by Customer Name
3=Sort by Customer Type

Default Value: 2