IN_FRT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	DELIVERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Delivery ID
5	IN_FRT_P_MANFRT	Character(1)	VARCHAR2(1) NOT NULL	External Manifest
6	IN_FRT_OPTION	Character(2)	VARCHAR2(2) NOT NULL	Freight Options 10=Shop For Rates 20=Best Way 30=Use Specified Carrier 40=Carrier with Best Way
7	IN_BEST_WAY_BTN	Character(2)	VARCHAR2(2) NOT NULL	Best Way Freight Option 10=Least Cost 20=By Commit Date
8	BEST_WAY_OPT	Character(1)	VARCHAR2(1) NOT NULL	Best Way if blank carrier ID
9	RESEND_FRT_RQST	Character(1)	VARCHAR2(1) NOT NULL	02/02/09 EGS: Created
10	RESEND_FRT_RECV	Character(1)	VARCHAR2(1) NOT NULL	02/02/09 EGS: Created
11	IN_FRT_AUTO_PACK	Character(1)	VARCHAR2(1) NOT NULL	10/29/07 EGS: Created
12	IN_FRT_AUTO_SO	Character(1)	VARCHAR2(1) NOT NULL	10/29/07 EGS: Created
13	IN_RECS_EXTRACTED	Number(7,0)	INTEGER NOT NULL	12/99: Created to tract number of records extracted.
14	IN_RECS_PROCESSED	Number(7,0)	INTEGER NOT NULL	12/99: Created to tract number of records extracted.
15	ERROR_CNT	Number(4,0)	SMALLINT NOT NULL	Error Count
16	DUMMY_FLD	Character(1)	VARCHAR2(1) NOT NULL	TEST DUMMY
17	SQL_TEXT	Character(254)	VARCHAR2(254) NOT NULL	SQL Text
18	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
19	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
20	MESSAGE_PARM	Character(254)	VARCHAR2(254) NOT NULL	Message Parameter Text