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 |