GL_JRCPSJE1_AET

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

5 JRNL_NET_UNITS Signed Number(27,2) DECIMAL(25,2) NOT NULL Represents a running total of the statistical units in a journal entry. It is a hash total since there may be different types of units of measure reflected in a single journal. It is maintained by PeopleSoft General Ledger as lines are entered.

6 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

7 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

8 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

9 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.

10 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.

11 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

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 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.

14 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.

15 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

16 NEW_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL New Amount

17 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID

18 SJE_ID Character(10) VARCHAR2(10) NOT NULL Standard Journal

19 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

20 JRNL_GEN_LEAD_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL For SJE. The number of days the SJE Batch process should look ahead to find standard journals due to be generated.

21 NEW_JOURNAL_DATE Date(10) DATE New Journal Date

22 JRNL_DAY_IN_PER Number(3,0) SMALLINT NOT NULL For SJE. The day within a period (e.g. "day #10") when the user wants standard journals to be generated. This indicates the date stamped on the journal, not the run date for generating it.

23 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

24 COMPOSITE_KEY Character(35) VARCHAR2(35) NOT NULL For SJE. Holds a concatenation of the keys of the SJE_DATE table in a temp table, for ease of walking through the rows.

25 JRNL_FOUND Character(1) VARCHAR2(1) NOT NULL Journal Found

26 PREV_SJE_ID Character(10) VARCHAR2(10) NOT NULL Previous SJE ID

27 PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.

28 TRANSL_LEDGER Character(1) VARCHAR2(1) NOT NULL Currency Translation Ledger

29 SEPARATE_DRCR Character(1) VARCHAR2(1) NOT NULL Enable Separate Debit/Credit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	BUSINESS_UNIT_1	Character(5)	VARCHAR2(5) NOT NULL	Non-Joint Venture BU
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
5	JRNL_NET_UNITS	Signed Number(27,2)	DECIMAL(25,2) NOT NULL	Represents a running total of the statistical units in a journal entry. It is a hash total since there may be different types of units of measure reflected in a single journal. It is maintained by PeopleSoft General Ledger as lines are entered.
6	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
7	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
8	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
9	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.
10	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.
11	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
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	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.
14	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.
15	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
16	NEW_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	New Amount
17	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID
18	SJE_ID	Character(10)	VARCHAR2(10) NOT NULL	Standard Journal
19	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
20	JRNL_GEN_LEAD_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	For SJE. The number of days the SJE Batch process should look ahead to find standard journals due to be generated.
21	NEW_JOURNAL_DATE	Date(10)	DATE	New Journal Date
22	JRNL_DAY_IN_PER	Number(3,0)	SMALLINT NOT NULL	For SJE. The day within a period (e.g. "day #10") when the user wants standard journals to be generated. This indicates the date stamped on the journal, not the run date for generating it.
23	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
24	COMPOSITE_KEY	Character(35)	VARCHAR2(35) NOT NULL	For SJE. Holds a concatenation of the keys of the SJE_DATE table in a temp table, for ease of walking through the rows.
25	JRNL_FOUND	Character(1)	VARCHAR2(1) NOT NULL	Journal Found
26	PREV_SJE_ID	Character(10)	VARCHAR2(10) NOT NULL	Previous SJE ID
27	PRIMARY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
28	TRANSL_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	Currency Translation Ledger
29	SEPARATE_DRCR	Character(1)	VARCHAR2(1) NOT NULL	Enable Separate Debit/Credit