KK_AF_LFLD_VW

#	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	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.
5	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
6	SPEEDCHART_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedChart Key
7	SPEEDTYPE_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedType Key
8	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
9	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
12	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
13	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
14	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
15	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
16	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
17	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
18	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
19	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
20	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
21	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
22	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
23	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
24	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
25	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
26	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
27	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
28	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
29	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.
30	JOURNAL_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Journal Class
31	KK_CUM_BEGIN_DT	Date(10)	DATE	Begin Date
32	KK_CUM_END_DT	Date(10)	DATE	End Date
33	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
34	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.
35	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.
36	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
37	FUND_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	Funding Source
38	BUDGET_DT	Date(10)	DATE	Budget Date