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 |