RUN_RE1000

(SQL Table)
Index Back

Reported Sales Run Control

Run Control record for the Reported Sales Inquiry report.

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

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 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: RE_REGION_NAME

4 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number

Prompt Table: RE_LS_OBLG_NBR

5 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name
6 LS_ADMIN Number(10,0) DECIMAL(10) NOT NULL Lease Administrator

Prompt Table: RE_PARTY_LA

7 PRTFL_MGR Number(10,0) DECIMAL(10) NOT NULL Portfolio Manager

Prompt Table: RE_PARTY_PM

8 LSE_TYPE_CD Character(10) VARCHAR2(10) NOT NULL This field contains the code for the Lease Types

Prompt Table: RE_LS_TYPE_NAME

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_RE_NONVW

10 LEASE_STATUS Character(1) VARCHAR2(1) NOT NULL Lease Status
1=Pending
2=Active
3=Canceled
4=Disputed
5=Expired
6=Holdover
7=Closed
8=Transferred
11 BEGIN_DT Date(10) DATE Begin Date
12 END_DT Date(10) DATE End Date