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 |