FS_BP_KKDFN_AET(SQL Table) |
Index Back |
---|---|
BP - KK Definition State RecThe following state record is used in the FS Budget Processor (FS_BP). This state record contains the commitment conrol definition fields. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | EFFDT_BD | Date(10) | DATE | Effective Date for Budget Defn |
3 | CNTRL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Option
0=Control 1=Tracking w/ Budget 2=Track w/o Budget 3=Default from Higher Level 4=Control Initial Document Default Value: 2 |
4 | BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Status
0=Open 1=Closed 2=Hold 3=Default Default Value: 0 |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | BUDG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Budget Type
E=Expense R=Revenue |
7 | ASSOC_EXP_BD | Character(10) | VARCHAR2(10) NOT NULL |
Associated Expenditure Budget
Prompt Table: KK_EXP_BD_VW |
8 | PARENT_BUDGET | Character(10) | VARCHAR2(10) NOT NULL |
Parent Control Budget
Prompt Table: KK_BUDGET_TYPE |
9 | CHILD_EXCEED | Character(1) | VARCHAR2(1) NOT NULL |
Child Budgets Exceed Option
N=No Y=Yes Y/N Table Edit Default Value: N |
10 | CONTROL_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL |
Control ChartField
Prompt Table:
%EDITTABLE8
|
11 | ALL_VALUES | Character(1) | VARCHAR2(1) NOT NULL |
Tree Level All Values flag
N=No Y=Yes Y/N Table Edit Default Value: N |
12 | BYPASS_BLANKS | Character(1) | VARCHAR2(1) NOT NULL | The flag is used in commitment control budget definition to bypass processing when the control value in the transaction is blank. |
13 | FILTER_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL |
Ruleset ChartField
Prompt Table:
%EDITTABLE9
|
14 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: KK_FCF_TREE_DVW |
15 | TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table: %EDITTABLE3 |
16 | ENABLE_FS | Character(1) | VARCHAR2(1) NOT NULL |
Enable Funding Source
Y/N Table Edit Default Value: N |
17 | KK_REV_TRACK_LG | Character(10) | VARCHAR2(10) NOT NULL | Revenue Tracking Ledger Group |
18 | TOLERANCE | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Tolerance Percent |
19 | BALANCED_LINES | Character(1) | VARCHAR2(1) NOT NULL |
Entries Must Balance
Y/N Table Edit Default Value: N |
20 | KK_ENABLE_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Statistical Budgeting
Y/N Table Edit Default Value: N |
21 | SUBTYPE | Character(10) | VARCHAR2(10) NOT NULL | Ruleset |
22 | EXPIRE_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL |
Prior Year Adj Chartfield
Prompt Table:
%EDITTABLE10
|
23 | SETID_EXP_CF | Character(5) | VARCHAR2(5) NOT NULL | Expiration ChartField Setid |
24 | SETID_RULESET_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
25 | SETID_CONTROL_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
26 | ACCOUNT_TRXOFF | Character(10) | VARCHAR2(10) NOT NULL | Transaction Offset Account. Used in budget processor AE program (FS_BP_KKDFN). |
27 | ACCOUNT_BDOFF | Character(10) | VARCHAR2(10) NOT NULL | Budget Offset Account. Used in budget processor AE program (FS_BP_KKDFN). |
28 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
29 | DEFN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Definition Status
E=Not Valid N=Validation Required V=Valid |