CURR_WRK_KK002

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
3	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
4	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
6	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPER_UNIT_TBL
7	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_TBL
8	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_TBL
9	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_TBL
10	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_TBL
11	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_TBL
12	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
13	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
14	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
15	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CHARTFIELD1_TBL
16	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CHARTFIELD2_TBL
17	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CHARTFIELD3_TBL
18	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: PC_BU_GL_VW
19	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: KK_PROJ_ID_VW
20	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACT_FVW2
21	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS
22	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period Prompt Table: KK_BP_ALL_VW
23	GAINLOSS_ACCT	Character(1)	VARCHAR2(1) NOT NULL	A flag for the associated account, whether it is a gain/loss account or other accounts. Used in Multicurrency process. Default Value: N
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
25	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
26	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
27	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.
28	KK_BUDG_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Budget Entry Type 0=Original 1=Adjustment 2=Transfer Adjustment 3=Transfer Original 4=Closing 5=Roll Forward
29	POSTED_TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination.
30	POSTED_TRAN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Posted Transaction Amount
31	RESTATED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Remeasured Amount
32	POSTED_BASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination, in the base currency of the business unit. Unless the Separate Debit/Credit option is set up, the ledger stores net amounts only.
33	REVAL_ADJUSTMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revaluation Adjustment Amount
34	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
35	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
36	TARGET_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Target Currency
37	BUDGET_DT	Date(10)	DATE	Budget Date