INTFC_BI_NOTE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
2	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
3	TRANS_TYPE_BI	Character(4)	VARCHAR2(4) NOT NULL	Transaction Type AE=Accounting Entry AHDR=Adjustment Header DDS=Deferred Discount/Surcharge DS=Discount/Surcharge EXSD=Indian Excise/Sales Tax Detail LINE=Chargeable Line NOTE=Note/Comment TAX=Sales/Use Tax Detail Default Value: NOTE
4	TRANS_TYPE_BI_SEQ	Number(3,0)	SMALLINT NOT NULL	Transaction Type Seq 010=Invalid Transaction Type 020=Too many charge lines 030=No charge line for activity 040=Invalid Business Unit 050=Invalid bill-to customer 060=Invalid Billing Address 070=Invalid bill-to contact 080=No Bill Source provided 090=Invalid Bill Source 100=Invalid Bill Type 110=Invalid Bill Cycle 120=Invalid Payment Term 130=Invalid Tax Code 140=Invalid Unit of measure 200=Invalid Standard Note Code 210=No Note Code or Text exists 300=Both Amount & Percentage are 0
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
7	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
8	LAST_UPDATE_DTTM	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.