FS_BP_REFD_AET(SQL Table) |
Index Back |
|---|---|
FS BP: Ref Doc State RecordThis state record is used to process liquidation. The fields are referenced in FS_BP_LQDA, FS_BP_PEOD, FS_BP_PROC, FS_BP_RBAL, FS_BP_REFD, FS_BP_RELF & FS_BP_SREF. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RECNAME_HEADER | Character(15) | VARCHAR2(15) NOT NULL | Header Record |
| 3 | RECNAME_LINE | Character(15) | VARCHAR2(15) NOT NULL | Line Record |
| 4 | SQLROWS_REFDBK | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 5 | SQLROWS_REFD | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 6 | SQLROWS_LQD | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 7 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 8 | KK_TRAN_LN | Number(9,0) | DECIMAL(9) NOT NULL | Commitment Control Transaction Line number. |
| 9 | KK_REFD_ID | Character(10) | VARCHAR2(10) NOT NULL | Comm Cntrl Referenced Tran ID |
| 10 | KK_REFD_DT | Date(10) | DATE | Comm Cntrl Referenced Tran Dt |
| 11 | KK_REFD_LN | Number(9,0) | DECIMAL(9) NOT NULL | Comm Cntrl Referenced Tran Ln |
| 12 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 13 | EFFDT_SOURCE | Date(10) | DATE | Effective Date for Journal Source |
| 14 | KK_ACCOUNTING_DT | Date(10) | DATE | Used in the Budget Processor. Accounting date from the source transaction header. |
| 15 | KK_SKIP_EDITS | Character(1) | VARCHAR2(1) NOT NULL |
Skip Budget Processor Edits
N=Re-edit valid lines Y=Do not re-edit valid lines |
| 16 | KK_CLOSE_PRIOR | Character(1) | VARCHAR2(1) NOT NULL | Close Prior Transaction |
| 17 | KK_TRAN_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No Y=Yes |
| 18 | KK_TRAN_OVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Commitment Control source transaction override operator |
| 19 | KK_TRAN_OVER_DTTM | DateTime(26) | TIMESTAMP | Commitment Control source transaction override datetime |
| 20 | KK_OVERRIDE_ACCT | Character(1) | VARCHAR2(1) NOT NULL | Override Commitment Control Budget Editting. |
| 21 | EXPIRED_YEAR | Character(1) | VARCHAR2(1) NOT NULL | Expired Year |
| 22 | 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. " |
| 23 | 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. |
| 24 | MONETARY_AMOUNT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Monetary Amount 2 |
| 25 | MONETARY_AMOUNT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Monetary Amount 3 |
| 26 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 27 | 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. |
| 28 | FOREIGN_AMOUNT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Foreign Amount 2 |
| 29 | 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. |
| 30 | STATISTICS_CODE2 | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 31 | 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. |
| 32 | STATISTIC_AMOUNT2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Statistic Amount 2 |
| 33 | STATISTIC_AMOUNT3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Statistic Amount 3 |
| 34 | KK_QUANTITY | Signed Number(20,4) | DECIMAL(18,4) NOT NULL | Commitment Control Quantity |
| 35 | KK_QUANTITY2 | Signed Number(20,4) | DECIMAL(18,4) NOT NULL | Commitment Control Quantity |
| 36 | KK_QUANTITY3 | Signed Number(20,4) | DECIMAL(18,4) NOT NULL | Commitment Control Quantity |
| 37 | MONETARY_AMOUNT4 | 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. |
| 38 | FOREIGN_AMOUNT4 | 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. |
| 39 | STATISTIC_AMOUNT4 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Statistic Amount 3 |
| 40 | STATISTICS_CODE4 | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 41 | KK_QUANTITY4 | Signed Number(20,4) | DECIMAL(18,4) NOT NULL | Commitment Control Quantity |
| 42 | ACTIVITY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Activity |
| 43 | KK_POSTED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted Amount |
| 44 | KK_FRN_POSTED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Foreign Posted Amount |
| 45 | KK_STAT_POSTED_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Statistic Posted Amount |
| 46 | KK_POSTED_QTY | Signed Number(20,4) | DECIMAL(18,4) NOT NULL | Commitment Control Posted Qty |
| 47 | KK_FINAL | Character(1) | VARCHAR2(1) NOT NULL | Finalized |
| 48 | KK_FINAL3 | Character(1) | VARCHAR2(1) NOT NULL | Finalized |
| 49 | LIQUIDATE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Liquidate by
A=Amount Q=Quantity |
| 50 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 51 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 52 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 53 | SETID1 | Character(5) | VARCHAR2(5) NOT NULL | SetID Value |
| 54 | SETID_LEDGER | Character(5) | VARCHAR2(5) NOT NULL | Ledger Table Setid |
| 55 | EFFDT_BD | Date(10) | DATE | Effective Date for Budget Defn |
| 56 | 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 |
| 57 | BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Status
0=Open 1=Closed 2=Hold 3=Default |
| 58 | FILTER_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Ruleset ChartField |
| 59 | CONTROL_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Control ChartField |
| 60 | ENABLE_FS | Character(1) | VARCHAR2(1) NOT NULL | Enable Funding Source |
| 61 | BUDG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Budget Type
E=Expense R=Revenue |
| 62 | ASSOC_EXP_BD | Character(10) | VARCHAR2(10) NOT NULL | Associated Expenditure Budget |
| 63 | KK_REV_TRACK_LG | Character(10) | VARCHAR2(10) NOT NULL | Revenue Tracking Ledger Group |
| 64 | TOLERANCE | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Tolerance Percent |
| 65 | BALANCED_LINES | Character(1) | VARCHAR2(1) NOT NULL | Entries Must Balance |
| 66 | KK_ENABLE_STAT | Character(1) | VARCHAR2(1) NOT NULL | Enable Statistical Budgeting |
| 67 | SUBTYPE | Character(10) | VARCHAR2(10) NOT NULL | Ruleset |
| 68 | EXPIRE_CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Prior Year Adj Chartfield |
| 69 | KEY_CF_BLANK | Character(1) | VARCHAR2(1) NOT NULL | Req'd Key ChartField is Blank |
| 70 | SETID_CONTROL_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
| 71 | SETID_RULESET_CF | Character(5) | VARCHAR2(5) NOT NULL | KK Control Chartfield SetID |
| 72 | SETID_EXP_CF | Character(5) | VARCHAR2(5) NOT NULL | Expiration ChartField Setid |
| 73 | KK_DETAIL_LED | Character(1) | VARCHAR2(1) NOT NULL | Commitment Detail Ledger |
| 74 | RECNAME_LEDGER | Character(15) | VARCHAR2(15) NOT NULL | Leger Record Name |
| 75 | 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 |
| 76 | AFFECT_SPEND_OPTN | Character(1) | VARCHAR2(1) NOT NULL | Affect Spending Authority |
| 77 | KK_INCLUDE_PRE_ENC | Character(1) | VARCHAR2(1) NOT NULL |
Indicator - Include Pre-Encumbrance in RSA
1=Include 2=Exclude 3=Default |
| 78 | KK_ALLOW_INC_SA | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator - Allow Increase Spending Authority |
| 79 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 80 | ACCOUNT_TRXOFF | Character(10) | VARCHAR2(10) NOT NULL | Transaction Offset Account. Used in budget processor AE program (FS_BP_KKDFN). |
| 81 | RECNAME_SIBL | Character(15) | VARCHAR2(15) NOT NULL | KK Source Header Record |
| 82 | WHERE_TXT_LONG3 | Long Character(4000) | CLOB | Where clause |