FAH_ACCTG_LINE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AE_HEADER_ID	Number(18,0)	DECIMAL(18) NOT NULL	AE Header ID
2	ANCHOR_BU	Character(5)	VARCHAR2(5) NOT NULL	5 character value used to identify the anchor business unit.
3	AE_LINE_NUM	Number(18,0)	DECIMAL(18) NOT NULL	AE Line Number
4	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
5	FAI_TRANSACTION_ID	Character(10)	VARCHAR2(10) NOT NULL	FAI Transaction ID
6	FAI_LINE_NBR	Number(9,0)	DECIMAL(9) NOT NULL	FAI Line Number
7	GL_SL_LINK_ID	Number(18,0)	DECIMAL(18) NOT NULL	eBusiness Suite Sub-Ledger Accounting Link ID
8	SEGMENT2	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT2
9	IU_ANCHOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
10	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
11	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. "
12	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
13	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
14	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
15	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
16	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
17	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
18	BUSINESS_UNIT_CHRG	Character(5)	VARCHAR2(5) NOT NULL	Charged Business Unit
19	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
20	SEGMENT3	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT3
21	SEGMENT4	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT4
22	SEGMENT5	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT5
23	SEGMENT6	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT6
24	SEGMENT7	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT7
25	SEGMENT8	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT8
26	SEGMENT9	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT9
27	SEGMENT10	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT10
28	SEGMENT11	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT11
29	SEGMENT12	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT12
30	SEGMENT13	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT13
31	SEGMENT14	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT14
32	SEGMENT15	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT15
33	SEGMENT16	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT16
34	SEGMENT17	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT17
35	SEGMENT18	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT18
36	SEGMENT19	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT19
37	SEGMENT20	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT20
38	SEGMENT21	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT21
39	SEGMENT22	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT22
40	SEGMENT23	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT23
41	SEGMENT24	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT24
42	SEGMENT25	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT25
43	SEGMENT26	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT26
44	SEGMENT27	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT27
45	SEGMENT28	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT28
46	SEGMENT29	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT29
47	SEGMENT30	Character(25)	VARCHAR2(25) NOT NULL	SEGMENT30
48	TRANSFER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transfer Status C=Completed E=Error P=In Process
49	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
50	LASTUPDDTTM	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.
51	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.