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 |