BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_NONVW
LEDGER_GROUPPrompt Table: SP_KKFSLG_NONVW
CHARTFIELD_VALUEPrompt Table: %EDITTABLE
N=Percentage
P=Priority
Default Value: N
Y/N Table Edit
Default Value: N
KK_FS_VALUE(SQL Table) |
Index Back |
|---|---|
Comm. Control Funding Source |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
| 2 | LEDGER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: SP_KKFSLG_NONVW |
| 3 | CHARTFIELD_VALUE |
Character(30) | VARCHAR2(30) NOT NULL |
ChartField Value
Prompt Table: %EDITTABLE |
| 4 | PROJECT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Overall Project/Grant Amount |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | KK_FS_ALLOC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Funding Source Allocation Method
N=Percentage P=Priority Default Value: N |
| 7 | KK_FS_ERROR | Character(1) | VARCHAR2(1) NOT NULL |
Funding Source Error
Y/N Table Edit Default Value: N |