AMIF_GRP_TMP (SQL Table)	Index Back
AMIF1000 - Group Asset Temp

AMIF_GRP_TMP

(SQL Table)

AMIF1000 - Group Asset Temp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

4 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

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

6 TRANS_DT Date(10) DATE Transaction Date

7 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	GROUP_ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Group Asset ID
4	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
5	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.
6	TRANS_DT	Date(10)	DATE	Transaction Date
7	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple