KK_ACT_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
2	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
3	KK_TRAN_DT	Date(10)	DATE NOT NULL	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
4	KK_TRAN_LN	Number(9,0)	DECIMAL(9) NOT NULL	Commitment Control Transaction Line number.
5	REFERENCED_BUDGET	Character(1)	VARCHAR2(1) NOT NULL	Referenced Budget Y/N Table Edit Default Value: N
6	BALANCING_LINE	Character(1)	VARCHAR2(1) NOT NULL	Balancing Line Y/N Table Edit Default Value: N
7	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
8	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
9	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
10	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.
11	RVRSL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Reversal Flag
12	CLOSED_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Closed Status field value Y/N Table Edit
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
16	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
17	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
18	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
19	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
20	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
21	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
22	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
23	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
24	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
25	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
26	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
27	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
28	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
29	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
30	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
31	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
32	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
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	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
36	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.
37	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
38	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.
39	KK_QUANTITY	Signed Number(20,4)	DECIMAL(18,4) NOT NULL	Commitment Control Quantity
40	BUDGET_DT	Date(10)	DATE	Budget Date
41	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
42	KK_GEN_PARENT	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Indicator - Generate Parent Budgets Default Value: N
43	KK_AUTO_GEN	Character(1)	VARCHAR2(1) NOT NULL	Budget Processor Generated Ln Default Value: N
44	KK_PROCESS_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Process Prior Document
45	AFFECT_SPEND_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Affect Spending Authority
46	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program. N=Not Posted X=Don't Post Y=Posted Default Value: N
47	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
48	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
49	EE_PROC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Entry Event Line Status
50	EXPIRED_YEAR	Character(1)	VARCHAR2(1) NOT NULL	Expired Year Y/N Table Edit Default Value: N
51	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
52	KK_CF_CHANGE_FLG	Character(1)	VARCHAR2(1) NOT NULL	CFs Have Changed Y/N Table Edit Default Value: N
53	KK_EXCLUDE	Character(1)	VARCHAR2(1) NOT NULL	Exclude N=No Y=Yes
54	LIQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	LIQUIDATIONS ONLY N=NO Y=YES
55	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag
56	LIQUIDATE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Liquidate by A=Amount Q=Quantity
57	ACTIVITY	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Activity