BP_BKOUT_AET(SQL Table) |
Index Back |
|---|---|
FS BP: Backout state recordFS BP: Backout state record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 2 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 3 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | KK_TRAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
| 6 | KK_TRAN_DT | Date(10) | DATE | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
| 7 | KK_TRAN_LN | Number(9,0) | DECIMAL(9) NOT NULL | Commitment Control Transaction Line number. |
| 8 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 9 | DELETE_PRIOR | Character(1) | VARCHAR2(1) NOT NULL |
Delete All Previous Results
Default Value: N |
| 10 | KK_CLOSE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control Close Flag |
| 11 | KK_ACCOUNTING_DT | Date(10) | DATE | Used in the Budget Processor. Accounting date from the source transaction header. |
| 12 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 13 | 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. |
| 14 | 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. |
| 15 | KK_QUANTITY | Signed Number(20,4) | DECIMAL(18,4) NOT NULL | Commitment Control Quantity |
| 16 | ACTIVITY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Activity |
| 17 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 18 | 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. |
| 19 | FUND_SOURCE | Character(6) | VARCHAR2(6) NOT NULL | Funding Source |
| 20 | KK_REFD_ID | Character(10) | VARCHAR2(10) NOT NULL | Comm Cntrl Referenced Tran ID |
| 21 | KK_REFD_DT | Date(10) | DATE | Comm Cntrl Referenced Tran Dt |
| 22 | KK_REFD_LN | Number(9,0) | DECIMAL(9) NOT NULL | Comm Cntrl Referenced Tran Ln |