AMIF1000_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ERRNUM	Number(5,0)	INTEGER NOT NULL	Error Number
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
6	PROCESSING_SEQ	Number(5,0)	INTEGER NOT NULL	Processing Sequence
7	FROM_INTFC_ID	Number(8,0)	INTEGER NOT NULL	From Interface ID
8	TO_INTFC_ID	Number(8,0)	INTEGER NOT NULL	To Interface ID
9	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
10	INTFC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Trans Load Type
11	LAST_ASSET_ID	Number(12,0)	DECIMAL(12) NOT NULL	Last Asset ID Used
12	LAST_ASSET_ID_CHAR	Character(12)	VARCHAR2(12) NOT NULL
13	INCR_BY	Signed Number(10,0)	DECIMAL(9) NOT NULL	Increment Number Default Value: 1
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	PREV_INTFC_ID	Number(8,0)	INTEGER NOT NULL	Previous Interface ID
16	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
17	AMFIN_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
18	AMFIN_ERR_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
19	AMPHY_A_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
20	AMPHY_A_ERR_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
21	AMPHY_B_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
22	AMLEASE_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
23	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
24	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
25	DEFAULT_PROFILE_Y	Character(1)	VARCHAR2(1) NOT NULL	Default Books from Profile Default Value: N
26	DEFAULT_PROFILE_N	Character(1)	VARCHAR2(1) NOT NULL	Default Books from Profile Default Value: N
27	DEFAULT_PROFILE_G	Character(1)	VARCHAR2(1) NOT NULL	Default Books from Profile Default Value: N
28	DEFAULT_PROFILE_C	Character(1)	VARCHAR2(1) NOT NULL	Default Books from Profile Default Value: N
29	DEFAULT_PROFILE_B	Character(1)	VARCHAR2(1) NOT NULL	Default Books from Profile Default Value: N
30	CF_SEQNO_LAST	Number(6,0)	INTEGER NOT NULL	Last Chartfield Sequence Numbe
31	IU_MAP_KEY	Number(7,0)	INTEGER NOT NULL	InterUnit transfer map key
32	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
33	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
34	SETID_CAL_DETP	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetId
35	SETID_CONV_DT	Character(5)	VARCHAR2(5) NOT NULL	Convention Detail SetId
36	SETID_DEPR_ALLOC	Character(5)	VARCHAR2(5) NOT NULL	Depreciation Allocation SetId
37	SETID_DEPR_SCHED	Character(5)	VARCHAR2(5) NOT NULL	Depreciation Schedule SetId
38	SETID_BOOK_DEFN	Character(5)	VARCHAR2(5) NOT NULL	Book Definition SetId
39	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
40	SETID_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit SetId
41	SETID_PROFILE	Character(5)	VARCHAR2(5) NOT NULL	Profile SetID
42	SETID_INV_ITEM	Character(5)	VARCHAR2(5) NOT NULL	Inv Items SETID
43	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
44	RECNAME_PROFILEDET	Character(15)	VARCHAR2(15) NOT NULL	Asset Book Profile - Detail
45	AMAUCTION_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
46	RT_EFFDT	Date(10)	DATE	The effective date for a given item of market rate data.
47	MULTI_CURR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Multi-Currency N=No Y=Yes
48	FIRST_ROW	Character(1)	VARCHAR2(1) NOT NULL	First Row
49	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
50	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
51	PRIMARY_BOOK	Character(10)	VARCHAR2(10) NOT NULL	AM Primary Book
52	LEDGERS_SYNC	Character(1)	VARCHAR2(1) NOT NULL	Keep Ledgers in Sync
53	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
54	BOOK_SEL	Character(1)	VARCHAR2(1) NOT NULL	Book Select field for RowSel Default Value: N
55	LED_GRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Default Journal Generator Ledger Group of a Business Unit
56	FLAG1	Character(1)	VARCHAR2(1) NOT NULL	Flag1
57	FLAG2	Character(1)	VARCHAR2(1) NOT NULL	Flag2
58	PROPERTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Property ID
59	INSERT_LONG	Long Character(4000)	CLOB	INSERT_LONG
60	BUSINESS_UNIT_SEL	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit entered as a run time parameter when executing the automat
61	WA_CAP_LIM_SW	Character(1)	VARCHAR2(1) NOT NULL	Error out Capitalzation Limit Y/N Table Edit Default Value: N
62	MULTI_SEL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Multiple Select Option
63	AM_GRP_SEQ_NBR	Number(8,0)	INTEGER NOT NULL	Group Sequence Number
64	AM_GRP_SEQ_NBR_NXT	Number(8,0)	INTEGER NOT NULL	Group Sequence Number
65	RECNAME_TEMP	Character(18)	VARCHAR2(18) NOT NULL	Temporary Record
66	PROFILE_WHERE	Character(254)	VARCHAR2(254) NOT NULL	PROFILE_WHERE