FS_MC_INCR_AET (SQL Table)	Index Back
FS MC - incremental ledger

FS_MC_INCR_AET

(SQL Table)

FS MC - incremental ledger

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 INCR_MODE Character(1) VARCHAR2(1) NOT NULL Run Mode
0=Increment
1=Full
2=End
3=Unlock
4=Clear and Archive

3 PROCESS_ID Character(12) VARCHAR2(12) NOT NULL Process Name

4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

5 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.

6 DETPER_FROM Number(3,0) SMALLINT NOT NULL Detail Period From

7 DETPER_TO Number(3,0) SMALLINT NOT NULL Detail Period To

8 ADJ_PER_FROM Number(3,0) SMALLINT NOT NULL Adjustment Period From

9 ADJ_PER_TO Number(3,0) SMALLINT NOT NULL Adjustment Period To

10 PERIOD_OPTN Character(1) VARCHAR2(1) NOT NULL Period type
0=Regular and Adjustment Periods
1=Regular Periods
2=Adjustment Periods

11 JRNL_LINE_ORIG_SRC Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal line source to use for incremental ledger process. Release 9.2

12 DTTM_STAMP_SEC 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	INCR_MODE	Character(1)	VARCHAR2(1) NOT NULL	Run Mode 0=Increment 1=Full 2=End 3=Unlock 4=Clear and Archive
3	PROCESS_ID	Character(12)	VARCHAR2(12) NOT NULL	Process Name
4	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	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.
6	DETPER_FROM	Number(3,0)	SMALLINT NOT NULL	Detail Period From
7	DETPER_TO	Number(3,0)	SMALLINT NOT NULL	Detail Period To
8	ADJ_PER_FROM	Number(3,0)	SMALLINT NOT NULL	Adjustment Period From
9	ADJ_PER_TO	Number(3,0)	SMALLINT NOT NULL	Adjustment Period To
10	PERIOD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Period type 0=Regular and Adjustment Periods 1=Regular Periods 2=Adjustment Periods
11	JRNL_LINE_ORIG_SRC	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal line source to use for incremental ledger process. Release 9.2
12	DTTM_STAMP_SEC	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.