FS_BP_FSRC_AET(SQL Table) |
Index Back |
|---|---|
FS BP: Fund Source State RecThis state record is used in several modules of the FS Budget Processor (FS_BP). It contains all the necessary fields to process funding source distribution. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SQLROWS_FSRC | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 3 | SQLROWS_LQDFS | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 6 | LEDGER_GROUP_LAST | Character(10) | VARCHAR2(10) NOT NULL | Last Ledger Group |
| 7 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 8 | LEDGER_TYPE_KK | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Ledger Type
0=Budget 1=Expense or Recognized Revenue 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned |
| 9 | BUDGET_LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Budget Ledger |
| 10 | SETID1 | Character(5) | VARCHAR2(5) NOT NULL | SetID Value |
| 11 | SETID_LEDGER | Character(5) | VARCHAR2(5) NOT NULL | Ledger Table Setid |
| 12 | SETID_LAST | Character(5) | VARCHAR2(5) NOT NULL | Last SetID |
| 13 | EFFDT_BD | Date(10) | DATE | Effective Date for Budget Defn |
| 14 | EFFDT_SOURCE | Date(10) | DATE | Effective Date for Journal Source |
| 15 | 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 |
| 16 | SETID_CONTROL_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
| 17 | CONTROL_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Control ChartField |
| 18 | CHARTFIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | ChartField Value |
| 19 | PROJECT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Overall Project/Grant Amount |
| 20 | FUND_SOURCE | Character(6) | VARCHAR2(6) NOT NULL | Funding Source |
| 21 | REV_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Revenue Linking Method
0=Budgeted 1=Recognized 2=Greater of Budget or Recognize 3=Lesser of Budget or Recognized 4=Collected 5=Greater of Budget or Collected 6=Lesser of Budget or Collected |
| 22 | KK_REV_TRACK_LG | Character(10) | VARCHAR2(10) NOT NULL | Revenue Tracking Ledger Group |
| 23 | CAP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Spending Cap |
| 24 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 25 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 26 | KK_TRAN_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No Y=Yes |
| 27 | 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. " |
| 28 | 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. |
| 29 | 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. |
| 30 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |
| 31 | TOTAL_FRN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Foreign Amount |
| 32 | AVAILABLE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Prepayment Available Amount |
| 33 | AVAILABLE_AMT_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Available Amount |
| 34 | BUD_REV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Budget or Revenue Amount |
| 35 | TOT_SPENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Spent |
| 36 | TOT_SPENT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Spent |
| 37 | STOP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Stop Search Here |
| 38 | EXCPTN_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Exception Type |
| 39 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 40 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
| 41 | SQL_STMT_254_2 | Character(254) | VARCHAR2(254) NOT NULL | SQL Statement length 254 |
| 42 | KK_TRAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
| 43 | KK_TRAN_DT | Date(10) | DATE | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
| 44 | KK_TRAN_LN | Number(9,0) | DECIMAL(9) NOT NULL | Commitment Control Transaction Line number. |
| 45 | KK_REFD_ID | Character(10) | VARCHAR2(10) NOT NULL | Comm Cntrl Referenced Tran ID |
| 46 | KK_REFD_DT | Date(10) | DATE | Comm Cntrl Referenced Tran Dt |
| 47 | KK_REFD_LN | Number(9,0) | DECIMAL(9) NOT NULL | Comm Cntrl Referenced Tran Ln |
| 48 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 49 | MONETARY_AMOUNT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Monetary Amount 2 |
| 50 | MONETARY_AMOUNT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Monetary Amount 3 |
| 51 | FOREIGN_AMOUNT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Foreign Amount 2 |
| 52 | FOREIGN_AMOUNT3 | 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. |
| 53 | KK_POSTED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted Amount |
| 54 | KK_FRN_POSTED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Foreign Posted Amount |
| 55 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |