PeopleSoft 9
Asset Management

Table Name JRNLGEN_APPL_ID

Table Description
JRNLGEN_APPL_ID
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
APPL_JRNL_ID char(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
DESCR char(30) No No
JOURNAL_ID_MASK char(6) No No
JRNL_DT_OPTN char(2) No No
JRNL_DT_ALT_OPTN char(2) No No
JOURNAL_DATE PSDATE No No
STAY_IN_PERIOD char(1) No No
SOURCE char(3) No No
CURR_EFFDT_FLG char(1) No No
JRNL_DESCR char(30) No No
LINE_DESCR char(30) No No
TRANS_REF_NUM char(8) No No
JRNL_LN_REF char(10) No No
HOW_SPECIFY char(1) No No
ACCOUNT_SPECIFY char(1) No No
DEFAULT_SPECIFY char(1) No No
TREE_NAME char(18) No No
TREE_LEVEL char(10) No No
REVERSAL_CD char(1) No No
ENTRY_SYNC char(1) No No
BUS_UNIT_OPTN char(1) No No
DOC_TYPE char(8) No No
Index
Name Type Unique Member
PS_JRNLGEN_APPL_ID PK Yes
Member(s) of "PS_JRNLGEN_APPL_ID" Index
SETID
APPL_JRNL_ID
EFFDT

Published December 16, 2006