AMRJGEN_REQUEST

(SQL Table)
Index Back

Amortization Jrnl Gen Req

# 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 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

Default Value: 9999

4 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

5 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler
8 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

11 AMORTIZATION_ID Character(10) VARCHAR2(10) NOT NULL Amortization ID

Prompt Table: AMR_ID_DVW

12 AMORT_ID_TO Character(10) VARCHAR2(10) NOT NULL To Amortization ID

Prompt Table: AMR_ID_DVW

13 AS_OF_DATE Date(10) DATE NOT NULL As of Date
14 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
N=No
Y=Yes
15 JRNL_EDIT_OPTN Character(1) VARCHAR2(1) NOT NULL Edit Journal(s)

Y/N Table Edit

Default Value: N

16 JRNL_BGTCHK_OPTN Character(1) VARCHAR2(1) NOT NULL Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid.

Y/N Table Edit

Default Value: N

17 JRNL_POST_OPTN Character(1) VARCHAR2(1) NOT NULL Post Journal(s)

Y/N Table Edit

Default Value: N

18 JRNL_DT_ALT_OPTN Character(2) VARCHAR2(2) NOT NULL Alternate Journal Date Option
BF=Begin Date - From Period
BT=Begin Date - To Period
EF=End Date - From Period
ET=End Date - To Period
RD=Retain Primary Journal Date
19 RTM_PRCS_FLG Character(1) VARCHAR2(1) NOT NULL On-Demand Process Flag