FS_MC_PRCS_AET (SQL Table)	Index Back
FS MC - process state record

FS_MC_PRCS_AET

(SQL Table)

FS MC - process 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 GL Character(1) VARCHAR2(1) NOT NULL General Ledger

3 ALTACCT_OPTN Character(1) VARCHAR2(1) NOT NULL Enable Alternate Account

4 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

5 BAL_SHEET_ACTIVE Character(1) VARCHAR2(1) NOT NULL Balance Sheet Indicator Active Flag

6 BOOK_CODE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Book Code Active Flag

7 COMMITMENT_CNTL_GL Character(1) VARCHAR2(1) NOT NULL Commitment Control on GL

8 DELETE_LIMIT Number(12,0) DECIMAL(12) NOT NULL Used in GL AE batch processes to perform deletes rather than truncate.
Default Value: 3000

9 DOC_SEQ Character(1) VARCHAR2(1) NOT NULL Enable Document Sequencing

10 DOC_SEQ_BU Character(1) VARCHAR2(1) NOT NULL Business Unit Doc Seq Option

11 JRNL_FOREIGN_OPTN Character(1) VARCHAR2(1) NOT NULL Foreign Currencies per Journal
D=Default to Higher Level Value
M=Multiple Foreign Currencies
N=No Foreign Currencies
O=Only One Foreign Currency

12 POST_DATE_OPTN Character(1) VARCHAR2(1) NOT NULL Journal Process Date Option
C=Current Date
P=Process Date

13 PROCESS_DATE Date(10) DATE Process Date

14 SETID Character(5) VARCHAR2(5) NOT NULL SetID

15 CURR_STEP Character(10) VARCHAR2(10) NOT NULL Process Step

16 LAST_SEQ_NBR_6 Number(6,0) INTEGER NOT NULL Sequence

17 STOP_SEQ_NBR_6 Number(6,0) INTEGER NOT NULL Sequence

18 FIRST_PASS_SW Character(1) VARCHAR2(1) NOT NULL First Pass Switch

19 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes

20 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

21 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

22 SYSTEM_DATE Date(10) DATE System Date

23 SQLROWS_ACCT Number(12,0) DECIMAL(12) NOT NULL Used in GL MultiCurrency AE programs (FS_MC)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GL	Character(1)	VARCHAR2(1) NOT NULL	General Ledger
3	ALTACCT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Enable Alternate Account
4	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
5	BAL_SHEET_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Balance Sheet Indicator Active Flag
6	BOOK_CODE_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Book Code Active Flag
7	COMMITMENT_CNTL_GL	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control on GL
8	DELETE_LIMIT	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL AE batch processes to perform deletes rather than truncate. Default Value: 3000
9	DOC_SEQ	Character(1)	VARCHAR2(1) NOT NULL	Enable Document Sequencing
10	DOC_SEQ_BU	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Doc Seq Option
11	JRNL_FOREIGN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Foreign Currencies per Journal D=Default to Higher Level Value M=Multiple Foreign Currencies N=No Foreign Currencies O=Only One Foreign Currency
12	POST_DATE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Journal Process Date Option C=Current Date P=Process Date
13	PROCESS_DATE	Date(10)	DATE	Process Date
14	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
15	CURR_STEP	Character(10)	VARCHAR2(10) NOT NULL	Process Step
16	LAST_SEQ_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence
17	STOP_SEQ_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence
18	FIRST_PASS_SW	Character(1)	VARCHAR2(1) NOT NULL	First Pass Switch
19	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
20	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
21	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
22	SYSTEM_DATE	Date(10)	DATE	System Date
23	SQLROWS_ACCT	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL MultiCurrency AE programs (FS_MC)