| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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.
|
| 2 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 3 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 4 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 5 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 6 |
KK_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control
B=Budget Check
C=Budget Create
D=Distributed
E=Posting Error
K=Post to Commitment control
N=None
S=Security Error
|
| 7 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
Default Value: N
|
| 8 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Commitment Control source transaction override datetime
|
| 9 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
Default Value: N
|
| 10 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Commitment Control source transaction override operator
|
| 11 |
KK_GEN_PARENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Generate Parent Budgets
Y/N Table Edit
Default Value: N
|
| 12 |
KK_DEFAULT_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Use Default Entry Event
Y/N Table Edit
Default Value: N
|
| 13 |
KK_PARENT_ENT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator - Parent Budget Entry Type
0=Original
1=Adjustment
2=Transfer Adjustment
3=Transfer Original
|
| 14 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 15 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_PCB_CODES_VW
Set Control Field: BUSINESS_UNIT_GL
|
| 16 |
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
|
| 17 |
PC_KK_AE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Engine Flag for Commitment Control. 1 = Budget Creation, 2 = Budget Checking
1=Budget Creation
2=Budget Check
|
| 18 |
KK_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Source Transaction Type
|
| 19 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
|
| 20 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 21 |
PC_BUDGET_ID |
Number(3,0) |
SMALLINT NOT NULL |
Budget Plan ID
|
| 22 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|