AUTOMNT_REQ_OPT

(SQL Table)
Index Back

Automnt 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).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

5 AUTOMNT_METHOD Character(15) VARCHAR2(15) NOT NULL Automatic Maintenance Method

Prompt Table: AUTOMNT_MET_TBL

6 ANCHOR_BU Character(5) VARCHAR2(5) NOT NULL 5 character value used to identify the anchor business unit.

Prompt Table: SP_BUARDS_NONVW

7 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
8 AR_DATE_OPTION Character(1) VARCHAR2(1) NOT NULL Last Activity Date
1=All Dates
2=<= Today
3=<= Specific Date
9 LAST_ACTIVITY_DT Date(10) DATE Last Activity Date