Data Table for Accounting Periods Reopen/Close

Tag # - Tag Name	Required/Optional	Data Type	Value/Description of Field

Tag # - Tag Name	Required/Optional	Data Type	Value/Description of Field
2283 - Select Query Option	REQUIRED	CHAR	User defined.
1163 - Entity ID	OPTIONAL	CHAR (8)	Lookup on the Entity ID.
1164 - Entity Name	OPTIONAL	CHAR (30)	Lookup on the Entity Name.
5 - Account	OPTIONAL	CHAR	Account or portfolio Identifier.
3953 - Port Comp Type	OPTIONAL	CHAR	Identifies the portfolio or composite type.
21 - Accounting Basis	OPTIONAL	VARCHAR2(5)	Accounting basis.
920 - Accounting Period Start Date	REQUIRED	DATE (99)	Accounting period start date.
221 - First Acct. Date to Reopen	REQUIRED	DATE	Ending of period date for statements.
1257 - Type of Close	REQUIRED	CHAR	A field to indicate the type of corporate action such as "sdiv", "merg".
2816 - Archive Date	OPTIONAL	DATE	Date of the most recent purge/archive for a basis.
4896 - Process Center	OPTIONAL	VARCHAR2 (2)	Lookup based on Process Center.
3914 - Conversion Status	OPTIONAL	CHAR	Indicates the current status of the fund.
1256 - Query Based On	OPTIONAL	CHAR	A field to specify choice of name, symbol, asset, pool.
988 - Bypass Dup Event Check	OPTIONAL	CHAR	Bypass duplicate event check.
30 - Post Date	OPTIIONAL	DATE	The date the event was processed. Usually process date is current date.
55 - Event Type	REQUIRED	CHAR	The business intent of the event. Used as the primary determinant in the accounting plan identification process.
95 - Partition	REQUIRED	INTEGER	The partition of a database where a position resides.
98 - Source System	REQUIRED	CHAR	The originating source system identifier.
9187 - Operation Switch	OPTIONAL	CHAR	Operation switch.
9403 - Rejection Source	OPTIONAL	CHAR	Rejection source.
944 - Update Source	OPTIONAL	CHAR	The source or userid of the entity that last updated the table.