XCC_CF_TRANSACTIONS
This table contains purchase orders processed by the carry forward enterprise service scheduler process for final close and reopen actions. The Carry Forward Results Report uses this data to show the results of the carry forward enterprise service scheduler process. Data in this table is purged at a later time by the archive and purge process.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
XCC_CF_TRANSACTIONS_PK |
CF_TRANSACTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CF_TRANSACTION_ID | NUMBER | 18 | Yes | Carry forward transaction identifier. | |
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
PO_HEADER_ID | NUMBER | 18 | Yes | Purchase order document header unique identifier. References PO_HEADERS_ALL.PO_HEADER_ID. | |
PO_LINE_ID | NUMBER | 18 | Purchase order document line unique identifier. References PO_LINES_ALL.PO_LINE_ID. | ||
PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule unique identifier. References PO_LINE_LOCATION_ALL.LINE_LOCATION_ID. | ||
CF_ACTION_CODE | VARCHAR2 | 30 | Yes | Carry forward transaction action. Valid values are CF_FINALLY_CLOSE_PO and CF_REOPEN_PO. | |
DATA_SET_ID | NUMBER | 18 | Budgetary control data set identifier for this transaction. | ||
RESULT_CODE | VARCHAR2 | 30 | Yes | Resulting status of the carry forward transaction action. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
CF_BUDGET_BALANCE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the budget is to be carried forward along with the encumbered purchase order. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
XCC_CF_TRANSACTIONS_U1 | Unique | Default | CF_TRANSACTION_ID |
XCC_CF_TRANSACTIONS_U2 | Unique | Default | REQUEST_ID, CF_ACTION_CODE, PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID |