FS_MC_STEP_AET

(SQL Table)
Index Back

FS MC - step defn 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CURR_STEP Character(10) VARCHAR2(10) NOT NULL Process Step
4 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
5 EFFDT Date(10) DATE Effective Date
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 FROM_LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL From Ledger Group
9 FROM_LEDGER Character(10) VARCHAR2(10) NOT NULL From Ledger
10 FROM_CURRENCY_TYPE Character(1) VARCHAR2(1) NOT NULL From Currency Type
L=Ledger Base Currency
S=Specify
11 FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL From Currency
12 TARGET_LEDGER_GRP Character(10) VARCHAR2(10) NOT NULL Target Ledger Group
13 TARGET_LEDGER Character(10) VARCHAR2(10) NOT NULL Target Ledger
14 TARGET_CURRENCY Character(3) VARCHAR2(3) NOT NULL Target Currency
15 BAL_CHECK Character(1) VARCHAR2(1) NOT NULL Check Balance of Step

Y/N Table Edit

16 GEN_ADJUST Character(1) VARCHAR2(1) NOT NULL Generate Adjustment

Y/N Table Edit

17 JOURNAL_ID_MASK Character(6) VARCHAR2(6) NOT NULL Journal ID Mask
18 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
19 TO_ADJ_PER_FLG Character(1) VARCHAR2(1) NOT NULL If = 'Y', the result juornal of the process will be in an adjusting period, specificed in the process rule defintion.

Y/N Table Edit

20 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
21 REVERSAL_CD Character(1) VARCHAR2(1) NOT NULL A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process.
B=Beginning of Next Period
D=On Date Specified By User
E=End of Next Period
N=Do Not Generate Reversal
R=Created by Reversal Process
U=Adjustment Period
X=Next Day
22 REVERSAL_ADJ_PER Number(3,0) SMALLINT NOT NULL Adjustment Period
23 REVERSAL_DATE Date(10) DATE Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
24 RVR_NEXT_YEAR Character(1) VARCHAR2(1) NOT NULL Reverse even if cross years

Y/N Table Edit

25 CREATE_JRNL_ENTRY Character(1) VARCHAR2(1) NOT NULL Create Journal Entries

Y/N Table Edit

26 JRNL_EDIT_OPTN Character(1) VARCHAR2(1) NOT NULL Edit Journal(s)

Y/N Table Edit

27 EDIT_CHARTFIELD Character(1) VARCHAR2(1) NOT NULL Edit ChartField Values

Y/N Table Edit

28 JRNL_BGTCHK_OPTN Character(1) VARCHAR2(1) NOT NULL Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid.

Y/N Table Edit

29 JRNL_POST_OPTN Character(1) VARCHAR2(1) NOT NULL Post Journal(s)

Y/N Table Edit

30 GL_ADJUST_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
31 SAVE_INC_JRNL Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator

Y/N Table Edit

32 STEP_TYPE Character(1) VARCHAR2(1) NOT NULL Currency Processing Step Type
FIN=Final
FST=First
INT=Intermediate
M=Translate Within Ledger
R=Currency Revaluation
T=Currency Translation
33 TIME_SPAN Character(10) VARCHAR2(10) NOT NULL TimeSpan
34 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
35 DESCRLONG Long Character CLOB Long Description
36 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
37 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
38 UNDO_PREV_PROCESS Character(1) VARCHAR2(1) NOT NULL Undo Previous Process

Y/N Table Edit

39 DONOT_DELETE_JRNL Character(1) VARCHAR2(1) NOT NULL Undo - Do Not Delete Journals
N=Physical Delete
X=Retain/Do Not Delete
Y=Mark as Deleted
40 DEPLOYED Character(1) VARCHAR2(1) NOT NULL Identify whether an element has been deployed or not.
N=No
Y=Yes
41 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence
42 CONTINUE_WITH_GRP Character(1) VARCHAR2(1) NOT NULL Continue Processing the Group
43 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
44 HOW_FIELD_SPECIFY Character(1) VARCHAR2(1) NOT NULL How Specified
1=All Detail Values
2=Selected Detail Values
3=Detail - Selected Parents
4=Selected Tree Nodes
5=Children at a Level
6=All Nodes at Selected Levels
7=Selected Summary ChrtFld Nodes
9=Value Mask
A=Account Type
R=Range of Values
45 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
46 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number
47 LED_REQ_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies if the process request uses full ledger or incremental ledger data.
F=Full
I=Incremental
48 SETID_ACCOUNT Character(5) VARCHAR2(5) NOT NULL Account Table Setid
49 SETID_ALTACCT Character(5) VARCHAR2(5) NOT NULL AltAcct SetID
50 SETID_CALENDAR Character(5) VARCHAR2(5) NOT NULL Calendar Setid
51 SETID_LEDGER Character(5) VARCHAR2(5) NOT NULL Ledger Table Setid
52 SETID_KK Character(5) VARCHAR2(5) NOT NULL Commitment Control SetID
53 SETID_TIMESPANS Character(5) VARCHAR2(5) NOT NULL TimeSpans SetID
54 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
55 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
56 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
57 ACCOUNT_GAIN Character(10) VARCHAR2(10) NOT NULL Account
58 ACCOUNT_LOSS Character(10) VARCHAR2(10) NOT NULL Account
59 ACCOUNT_TGT Character(10) VARCHAR2(10) NOT NULL Account
60 ALTACCT_GAIN Character(10) VARCHAR2(10) NOT NULL Alternate Account
61 ALTACCT_LOSS Character(10) VARCHAR2(10) NOT NULL Alternate Account
62 ALTACCT_TGT Character(10) VARCHAR2(10) NOT NULL Alternate Account
63 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
64 BAL_SHEET_IND Character(2) VARCHAR2(2) NOT NULL Balance Sheet Indicator
BS=Balance Sheet
OB=Off Balance Sheet
65 TO_KK_LEDGRP_FLAG Character(1) VARCHAR2(1) NOT NULL Flag for Multi-Currency processing.

Y/N Table Edit

Default Value: N

66 LED_TYPE_BUDGET Character(1) VARCHAR2(1) NOT NULL Flag for Multi-Currency processing.

Y/N Table Edit

Default Value: N

67 BUDGET_PERIOD_SW Character(1) VARCHAR2(1) NOT NULL Show Budget Period
68 REVAL_XLEDGER Character(1) VARCHAR2(1) NOT NULL Flag for Multi-Currency processing to indicate translation within ledger.
69 RETAIN_CF_VALUE Character(1) VARCHAR2(1) NOT NULL Flag for Multi-Currency processing.
70 SAME_CHARTFIELD Character(1) VARCHAR2(1) NOT NULL Flag for Multi-Currency processing.
71 SOURCE_INSTANCE Number(15,4) DECIMAL(14,4) NOT NULL Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier.
72 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
73 JOURNAL_ID_FROM Character(10) VARCHAR2(10) NOT NULL Range From Journal ID
74 JOURNAL_ID_TO Character(10) VARCHAR2(10) NOT NULL Range to Journal ID
75 JOURNAL_NUM_ASSIGN Number(10,0) DECIMAL(10) NOT NULL Journal Number - Auto Assigned
76 NBR_JOURNALS Number(10,0) DECIMAL(10) NOT NULL Number of Journals
77 JRNL_EDIT_ERR_STAT Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not there are edit errors in a journal entry.
E=Error - Edit Error(s)
N=No Status
V=Valid - No Edit Errors
78 TRANS_RUN_STATUS Character(1) VARCHAR2(1) NOT NULL Run Status
A=Aborted
E=Error
S=Successful
U=Process was Undone
79 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
80 AUTO_GEN_LINES Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) journal lines should be automatically generated for other ledgers in a ledger group. This option is automatically on if the Keep Ledgers in Sync option is on for the specified ledger group. You can select the Auto Generate Lines option for a multibook ledger group specified on a journal header.
81 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
82 SQLROWS Number(5,0) INTEGER NOT NULL SQL Rows
83 SQLROWS_LED Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)
84 SQLROWS_RATE Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)
85 SQLROWS_SUB Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)
86 SQLROWS_TEMP Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)
87 SQLROWS_TSEL Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)
88 SQLROWS_UNDO Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)
89 SQLROWS_WRK Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)
90 SQLROWS_WRK1 Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)
91 CONTN_GNLS_LOOP Character(1) VARCHAR2(1) NOT NULL Continue Gain/Loss Loop in MultiCurrency.
92 KK_BUDG_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Budget Entry Type
0=Original
1=Adjustment
2=Transfer Adjustment
3=Transfer Original
4=Closing
5=Roll Forward
93 JRNL_LINE_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal line and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
94 COMMITMENT_CNTL Character(1) VARCHAR2(1) NOT NULL Enable Commitment Control
95 FILTER_CHARTFIELD Character(18) VARCHAR2(18) NOT NULL Ruleset ChartField
96 CALENDAR_BP Character(2) VARCHAR2(2) NOT NULL Budget Period Calendar ID
97 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
98 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive