JRNL_SUS_LN_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
4	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
5	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.
6	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
7	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_TBL
8	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_TBL
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
11	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
12	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
13	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
14	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
15	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
16	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
17	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
18	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
19	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
20	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
21	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
22	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
23	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
24	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
25	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.
26	MOVEMENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign. N=Natural R=Reversal
27	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
28	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.
29	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.
30	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
31	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.
32	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.
33	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
34	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
35	JRNL_LINE_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal line and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
36	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
37	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
38	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
39	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
40	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
41	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
42	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
43	GL_ADJUST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Adjustment Type
44	SETTLEMENT_DT	Date(10)	DATE	The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
45	DATE_CODE	Character(1)	VARCHAR2(1) NOT NULL	This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.
46	TAS_GWA	Character(26)	VARCHAR2(26) NOT NULL	TAS GWA
47	BETC_CD	Character(8)	VARCHAR2(8) NOT NULL	Business Event Type Code
48	JRNL_LINE_ORIG_SRC	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal line source to use for incremental ledger process. Release 9.2