FS_MC_RECS_AET

(SQL Table)
Index Back

FS MC - recname state record

State record for record names (temporary tables and SQL tables).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 STATE_RECORD Character(15) VARCHAR2(15) NOT NULL State Record
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
4 RECNAME_CURR_LOG Character(15) VARCHAR2(15) NOT NULL MultiCurrency Log
5 RECNAME_CURR_WRK Character(15) VARCHAR2(15) NOT NULL MultiCurrency Tmp
6 RECNAME_CUR_WRK1 Character(15) VARCHAR2(15) NOT NULL MultiCurrency Tmp1
7 RECNAME_JRNL_HDR Character(15) VARCHAR2(15) NOT NULL Journal Header
8 RECNAME_JRNL_LN Character(15) VARCHAR2(15) NOT NULL Journal Line
9 RECNAME_LGLED_TMP Character(15) VARCHAR2(15) NOT NULL Temp table holding Ledger Group/Ledger values
10 RECNAME_RATE_TMP Character(15) VARCHAR2(15) NOT NULL Temp table holding Ledger Group/Ledger values
11 RECNAME_SUBTYP_TMP Character(15) VARCHAR2(15) NOT NULL Temp table holding KK SubType values
12 RECNAME_TREESEL Character(15) VARCHAR2(15) NOT NULL Tree Selector Record Name
13 RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
14 RECNAME_INSTALL Character(15) VARCHAR2(15) NOT NULL Installation Table name
15 RECNAME_ACCOUNT Character(15) VARCHAR2(15) NOT NULL Account ChartField