GEN_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	FLDVALUE2	Character(30)	VARCHAR2(30) NOT NULL	FldVal
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	FLDVALUE3	Character(30)	VARCHAR2(30) NOT NULL	FldVal
21	FLDVALUE4	Character(30)	VARCHAR2(30) NOT NULL	FldVal
22	FLDVALUE5	Character(30)	VARCHAR2(30) NOT NULL	FldVal
23	FLDVALUE6	Character(30)	VARCHAR2(30) NOT NULL	FldVal
24	FLDVALUE7	Character(30)	VARCHAR2(30) NOT NULL	FldVal
25	FLDVALUE8	Character(30)	VARCHAR2(30) NOT NULL	FldVal
26	FLDVALUE9	Character(30)	VARCHAR2(30) NOT NULL	Field Value 9
27	FLDVALUE10	Character(30)	VARCHAR2(30) NOT NULL	FldVal
28	FLDVALUE11	Character(30)	VARCHAR2(30) NOT NULL	FldVal
29	FLDVALUE12	Character(30)	VARCHAR2(30) NOT NULL	FldVal
30	FLDVALUE13	Character(30)	VARCHAR2(30) NOT NULL	FldVal
31	FLDVALUE14	Character(30)	VARCHAR2(30) NOT NULL	FldVal
32	FLDVALUE15	Character(30)	VARCHAR2(30) NOT NULL	FldVal
33	FLDVALUE16	Character(30)	VARCHAR2(30) NOT NULL	FldVal
34	FLDVALUE17	Character(30)	VARCHAR2(30) NOT NULL	FldVal
35	FLDVALUE18	Character(30)	VARCHAR2(30) NOT NULL	FldVal
36	FLDVALUE19	Character(30)	VARCHAR2(30) NOT NULL	FldVal
37	FLDVALUE20	Character(30)	VARCHAR2(30) NOT NULL	FldVal
38	TRANSFER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transfer Status C=Completed E=Error P=In Process
39	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
40	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.
41	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.