AM_JGEN_AET(SQL Table) |
Index Back |
---|---|
AM Journal Gen State RecAM Journal Gen State Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
5 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
6 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
7 | 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 |
8 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |
9 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
11 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
12 | ASSET_ID_FROM | Character(12) | VARCHAR2(12) NOT NULL | From Asset ID |
13 | ASSET_ID_TO | Character(12) | VARCHAR2(12) NOT NULL | Asset ID to |
14 | RP_ACTION | Character(1) | VARCHAR2(1) NOT NULL | Receivables Update Action |
15 | MULTI_SEL_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Multiple Select Option |
16 | AM_PROCESS_GL | Character(1) | VARCHAR2(1) NOT NULL |
AM Process Jgen field
Y/N Table Edit Default Value: N |
17 | AM_SETID | Character(5) | VARCHAR2(5) NOT NULL |
AM Setid
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
18 | 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
|