CNAO_JRNL_STG

#	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	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.
4	JOURNAL_SDATE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the date the journal was created.
5	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".
6	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.
7	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
8	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
9	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
10	CREATE_SDATE	Character(8)	VARCHAR2(8) NOT NULL	Creation Date
11	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
12	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.
13	JRNL_CTG_ID	Character(60)	VARCHAR2(60) NOT NULL	Journal Category ID
14	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
15	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
16	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.
17	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
18	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
19	ACCOUNT_NODE	Character(20)	VARCHAR2(20) NOT NULL	GL Account
20	CNAO_ACCOUNT	Character(20)	VARCHAR2(20) NOT NULL	CNAO Account
21	NATURAL_BALANCE	Character(2)	VARCHAR2(2) NOT NULL	Natural Balance CR=Credit DR=Debit
22	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
23	ACCT_CSFL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cash Flow Related
24	SUBSDRY_ITEM_01	Character(30)	VARCHAR2(30) NOT NULL	Customer Subsidiary Item
25	SUBSDRY_ITEM_02	Character(25)	VARCHAR2(25) NOT NULL	Supplier Subsidiary
26	SUBSDRY_ITEM_03	Character(25)	VARCHAR2(25) NOT NULL	Subsidiary Item 3
27	SUBSDRY_ITEM_04	Character(25)	VARCHAR2(25) NOT NULL	Subsidiary Item 4
28	SUBSDRY_ITEM_05	Character(25)	VARCHAR2(25) NOT NULL	Subsidiary Item 5
29	SUBSDRY_ITEM_06	Character(25)	VARCHAR2(25) NOT NULL	Subsidiary Item 6
30	SUBSDRY_ITEM_07	Character(25)	VARCHAR2(25) NOT NULL	Subsidiary Item 7
31	SUBSDRY_ITEM_08	Character(25)	VARCHAR2(25) NOT NULL	Subsidiary Item 8
32	SUBSDRY_ITEM_09	Character(25)	VARCHAR2(25) NOT NULL	Subsidiary Item 9
33	SUBSDRY_ITEM_10	Character(25)	VARCHAR2(25) NOT NULL	Subsidiary Item 10
34	SUBSDRY_ITEM_11	Character(30)	VARCHAR2(30) NOT NULL	Subsidiary Item 11
35	SUBSDRY_ITEM_12	Character(30)	VARCHAR2(30) NOT NULL	Subsidiary Item 12
36	SUBSDRY_ITEM_13	Character(20)	VARCHAR2(20) NOT NULL	Subsidiary Item 13
37	SUBSDRY_ITEM_14	Character(20)	VARCHAR2(20) NOT NULL	Subsidiary Item 14
38	SUBSDRY_ITEM_15	Character(20)	VARCHAR2(20) NOT NULL	Subsidiary Item 15
39	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
40	FOREIGN_AMT_DR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Debit Amount
41	FOREIGN_AMT_CR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Credit Amount
42	MONETARY_AMT_DR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base DR Amount
43	MONETARY_AMT_CR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base CR Amount
44	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.
45	EXCHANGE_RATE	Number(18,4)	DECIMAL(17,4) NOT NULL	Exchange Rate
46	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
47	OPRID_REVIEWED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
48	OPRID_POSTED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
49	AUDLOG_SDTTM	Character(32)	VARCHAR2(32) NOT NULL	Date and time that the event occurred.
50	POSTED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Posted to Projects
51	CANCELLED	Character(1)	VARCHAR2(1) NOT NULL	Cancelled
52	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
53	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code