AM_JGEN_AET

(SQL Table)
Index Back

AM Journal Gen State Rec

AM 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
Set Control Field: SETID