FSAH_ACTG_LN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GROUP_ID_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Group ID
2	GL_SL_LINK_ID	Number(18,0)	DECIMAL(18) NOT NULL	eBusiness Suite Sub-Ledger Accounting Link ID
3	GL_SL_LINK_TABLE	Character(30)	VARCHAR2(30) NOT NULL	eBusiness Suite Sub-Ledger Accounting Link Table
4	FSAH_HEADER_ID	Number(15,0)	DECIMAL(15) NOT NULL	eBusiness Suite Financial Service Accounting Hub - SLA Journal Header ID
5	FSAH_LINE_NUM	Number(15,0)	DECIMAL(15) NOT NULL	eBusiness Suite Financial Service Accounting Hub - SLA Journal Line Number
6	FSAH_EVENT_ID	Number(15,0)	DECIMAL(15) NOT NULL	eBusiness Suite Financial Service Accounting Hub - SLA Event ID
7	FSAH_APP_ID	Number(5,0)	INTEGER NOT NULL	eBusiness Suite Financial Service Accounting Hub - SLA Application ID
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
10	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
11	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
12	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
13	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
14	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
15	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.
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	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.
18	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.
19	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
20	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
21	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
22	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
23	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
24	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
25	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
26	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
27	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
28	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
29	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
30	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
31	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
32	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
33	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
34	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
35	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
36	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
37	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
38	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
39	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
40	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
41	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
42	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
43	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
44	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
45	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
46	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
47	DTTM_STAMP	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. Default Value: %Datetime