AM_CON2_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INST_STG	Number(10,0)	DECIMAL(10) NOT NULL	Stage Record Process Instance
2	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
3	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AM_NONVW
5	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
6	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.
7	MC_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Mass Change Definition
8	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
9	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
10	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
11	INTFC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Trans Load Type
12	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
13	INTFC_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Interface Status CON=Consolidated DON=Mass Changes Generated ERR=Error NEW=Mass Changes Not Generated REP=Replaced by Other Records (AP) UNI=Unitized Default Value: DON
14	ORIG_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Original Interface ID
15	ORIG_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Original Interface Line Number
16	LOAD_STATUS	Character(3)	VARCHAR2(3) NOT NULL	/* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */ CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized Default Value: NEW
17	MARKED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Marked Flag Default Value: Y