FS_BP_CHECK_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 4 | SUBTYPE | Character(10) | VARCHAR2(10) NOT NULL | Ruleset |
| 5 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 7 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 8 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 9 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 10 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 11 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 12 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 13 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 14 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 15 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 16 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 17 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 18 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 19 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 20 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 21 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 22 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 23 | BUDGET_PERIOD | Character(8) | VARCHAR2(8) NOT NULL | Budget Period |
| 24 | 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. " |
| 25 | 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. |
| 26 | 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. |
| 27 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 28 | STATISTICS_CODE_E | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code-IU Expense |
| 29 | EFFDT_SOURCE | Date(10) | DATE | Effective Date for Journal Source |
| 30 | EFFDT_BD | Date(10) | DATE | Effective Date for Budget Defn |
| 31 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 32 | AFFECT_SPEND_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Affect Spending Authority |
| 33 | KK_INCLUDE_PRE_ENC | Character(1) | VARCHAR2(1) NOT NULL |
Indicator - Include Pre-Encumbrance in RSA
1=Include 2=Exclude 3=Default |
| 34 | KK_ALLOW_INC_SA | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator - Allow Increase Spending Authority |
| 35 | KK_CF_CHANGE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
CFs Have Changed
Y/N Table Edit Default Value: N |
| 36 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Error Flag |
| 37 | ENABLE_FS | Character(1) | VARCHAR2(1) NOT NULL | Enable Funding Source |
| 38 | KK_DETAIL_LED | Character(1) | VARCHAR2(1) NOT NULL | Commitment Detail Ledger |
| 39 | RECNAME_LEDGER | Character(15) | VARCHAR2(15) NOT NULL | Leger Record Name |
| 40 | BUDG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Budget Type
E=Expense R=Revenue |
| 41 | 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 |
| 42 | BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Status
0=Open 1=Closed 2=Hold 3=Default |
| 43 | TOLERANCE | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Tolerance Percent |
| 44 | KK_ENABLE_CUM | Character(1) | VARCHAR2(1) NOT NULL | Enable Cumulative Budgeting |
| 45 | KK_DERIVE_DATES | Character(1) | VARCHAR2(1) NOT NULL |
Derive Cumulative Date Range
0=Derive Yes 1=Derive No 2=Default |
| 46 | KK_CUM_CAL_ID | Character(2) | VARCHAR2(2) NOT NULL | Cumulative Calendar |
| 47 | KK_CUM_BEGIN_DT | Date(10) | DATE | Begin Date |
| 48 | KK_CUM_END_DT | Date(10) | DATE | End Date |
| 49 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 50 | END_DT | Date(10) | DATE | End Date |
| 51 | KK_BUDGET_CLOSED | Character(1) | VARCHAR2(1) NOT NULL | Budget Closed |
| 52 | KK_TRAN_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No Y=Yes |
| 53 | KK_TRAN_OVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Commitment Control source transaction override operator |
| 54 | KK_TRAN_OVER_DTTM | DateTime(26) | TIMESTAMP | Commitment Control source transaction override datetime |
| 55 | KK_BD_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Override Budget
N=No Y=Yes |
| 56 | KK_BD_OVER_MON | Character(1) | VARCHAR2(1) NOT NULL | Monetary Budget Override Flag |
| 57 | KK_BD_OVER_STAT | Character(1) | VARCHAR2(1) NOT NULL | Stat Budget Override Flag |
| 58 | KK_OVERRIDE_ACCT | Character(1) | VARCHAR2(1) NOT NULL | Override Commitment Control Budget Editting. |
| 59 | SETID_LEDGER | Character(5) | VARCHAR2(5) NOT NULL | Ledger Table Setid |
| 60 | SETID1 | Character(5) | VARCHAR2(5) NOT NULL | SetID Value |
| 61 | SETID_BPCAL | Character(5) | VARCHAR2(5) NOT NULL | Calendar Setid |
| 62 | CALENDAR_BP | Character(2) | VARCHAR2(2) NOT NULL | Budget Period Calendar ID |
| 63 | SETID_RULESET_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
| 64 | SETID_CONTROL_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
| 65 | SETID_EXP_CF | Character(5) | VARCHAR2(5) NOT NULL | Expiration ChartField Setid |
| 66 | FILTER_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Ruleset ChartField |
| 67 | EXPIRE_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Prior Year Adj Chartfield |
| 68 | CONTROL_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Control ChartField |
| 69 | ASSOC_EXP_BD | Character(10) | VARCHAR2(10) NOT NULL | Associated Expenditure Budget |
| 70 | CK_EXP_SA | Character(1) | VARCHAR2(1) NOT NULL | Check Assoc Expenditures RSA |
| 71 | KK_ENABLE_STAT | Character(1) | VARCHAR2(1) NOT NULL | Enable Statistical Budgeting |
| 72 | CHECK_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Check Statistical Budget
Default Value: N |
| 73 | CNTRL_CF_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Control ChartField Value |
| 74 | RS_CF_VALUE | Character(30) | VARCHAR2(30) NOT NULL | RuleSet ChartField Value |
| 75 | EXP_CF_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Expiration ChartField Value |
| 76 | ACCOUNT_TRXOFF | Character(10) | VARCHAR2(10) NOT NULL | Transaction Offset Account. Used in budget processor AE program (FS_BP_KKDFN). |
| 77 | ACCOUNT_BDOFF | Character(10) | VARCHAR2(10) NOT NULL | Budget Offset Account. Used in budget processor AE program (FS_BP_KKDFN). |
| 78 | EXCPTN_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Exception Type |
| 79 | KK_REFD_ID | Character(10) | VARCHAR2(10) NOT NULL | Comm Cntrl Referenced Tran ID |
| 80 | INIT_DOC_PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Initial Document Processed
Y/N Table Edit |
| 81 | KK_INCREASED_OBLIG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net obligation change |
| 82 | KK_INCR_OBLIG_STAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net obligation change - Stat |
| 83 | CK_FOR_BUDG_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Only check for budg existence |
| 84 | KK_CHECK_INCR_SA | Character(1) | VARCHAR2(1) NOT NULL | Check Increase Spending Auth. |
| 85 | OVERRIDE_EXISTS | Character(1) | VARCHAR2(1) NOT NULL | KK Override Exists |
| 86 | KEY_CF_BLANK | Character(1) | VARCHAR2(1) NOT NULL | Req'd Key ChartField is Blank |
| 87 | KEY_CF_BLANK_ERROR | Character(1) | VARCHAR2(1) NOT NULL | Value Req'd Error Logged |
| 88 | UNIQUE_ROW_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Used in budget processor (FS_BP). |