GL_JRN_CYDWN_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TMPLT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Template Type A=All C=Permission O=User ID
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
4	COPY_DOWN_ID	Character(10)	VARCHAR2(10) NOT NULL	Copy Down ID
5	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Default Y/N Table Edit Default Value: N
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Y/N Table Edit Default Value: Y
7	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Y/N Table Edit Default Value: Y
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Y/N Table Edit Default Value: Y
9	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Y/N Table Edit Default Value: Y
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Y/N Table Edit Default Value: Y
11	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Y/N Table Edit Default Value: Y
12	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Y/N Table Edit Default Value: Y
13	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Y/N Table Edit Default Value: Y
14	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Y/N Table Edit Default Value: Y
15	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Y/N Table Edit Default Value: Y
16	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Y/N Table Edit Default Value: Y
17	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Y/N Table Edit Default Value: Y
18	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Y/N Table Edit Default Value: Y
19	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Y/N Table Edit Default Value: Y
20	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Y/N Table Edit Default Value: Y
21	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Y/N Table Edit Default Value: Y
22	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Y/N Table Edit Default Value: Y
23	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Y/N Table Edit Default Value: Y
24	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period Y/N Table Edit Default Value: Y
25	SCENARIO	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca Y/N Table Edit Default Value: Y
26	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code Y/N Table Edit Default Value: Y
27	STATISTIC_AMT_CY	Character(1)	VARCHAR2(1) NOT NULL	STATISTIC_AMOUNT Y/N Table Edit Default Value: Y
28	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code Y/N Table Edit Default Value: Y
29	FOREIGN_AMOUNT_CY	Character(1)	VARCHAR2(1) NOT NULL	FOREIGN_AMOUNT Y/N Table Edit Default Value: Y
30	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. Y/N Table Edit Default Value: Y
31	BUDGET_DT_CY	Character(1)	VARCHAR2(1) NOT NULL	BUDGET_DT Y/N Table Edit Default Value: Y
32	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. Y/N Table Edit Default Value: Y
33	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. Y/N Table Edit Default Value: Y
34	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Y/N Table Edit Default Value: Y
35	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Y/N Table Edit Default Value: Y
36	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Y/N Table Edit Default Value: Y
37	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Y/N Table Edit Default Value: Y
38	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Y/N Table Edit Default Value: Y
39	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Y/N Table Edit Default Value: Y