AMAEJGEN_RQST(SQL Table) |
Index Back |
|---|---|
Request for program AM_JGENRequest record for AM_JGEN, that calls Journal Generator. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 4 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 5 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once Default Value: N |
| 6 | 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 |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 8 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler Default Value: P |
| 9 | 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. |
| 10 | PARALLEL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Process in Parallel
N=Synchronous Processing Y=Parallel Processing Y/N Table Edit Default Value: N |
| 11 | PROCESSING_SEQ | Number(5,0) | INTEGER NOT NULL | Processing Sequence |
| 12 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 13 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 14 | ASSET_ID_FROM | Character(12) | VARCHAR2(12) NOT NULL | From Asset ID |
| 15 | ASSET_ID_TO | Character(12) | VARCHAR2(12) NOT NULL | Asset ID to |
| 16 | MULTI_SEL_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Multiple Select Option |
| 17 | AM_PROCESS_GL | Character(1) | VARCHAR2(1) NOT NULL |
AM Process Jgen field
Y/N Table Edit Default Value: N |
| 18 | AM_SETID | Character(5) | VARCHAR2(5) NOT NULL |
AM Setid
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 19 | AM_ACCTG_DEF_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.
Prompt Table:
JRNLGEN_DEFN
|