XCC_SIM_HEADERS
Stores transaction information for a pseudo application used for testing the budgetary control engine.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
XCC_SIM_HEADERS_PK |
TRANSACTION_TYPE_CODE, SOURCE_HEADER_ID_1, SOURCE_HEADER_ID_2 |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Transaction type of the pseudo application transaction | |
SOURCE_HEADER_ID_1 | VARCHAR2 | 30 | Yes | Second part of the unique identifier for the pseudo application transaction. | |
SOURCE_HEADER_ID_2 | VARCHAR2 | 30 | Yes | Thrid part of the unique identifier for the pseudo application transaction. | |
TRANSACTION_NUMBER | VARCHAR2 | 240 | Transaction number of the pseudo application transaction. | ||
DESTINATION_TYPE_CODE | VARCHAR2 | 30 | Destination type of the pseudo application transaction (Expense or Invemtory) | ||
TRANSACTION_SOURCE_CODE | VARCHAR2 | 30 | Transaction source of the pseudo application transaction. | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Document type of the pseudo application transaction. | ||
JE_SOURCE_CODE | VARCHAR2 | 25 | General Ledger journal source of the pseudo application transaction. | ||
LEDGER_ID | NUMBER | 18 | Ledger of the pseudo application transaction in those cases where the transaction refrences only a single ledger. | ||
BUSINESS_UNIT_ID | NUMBER | 18 | Business unit of the pseudo application transaction in those cases where the transaction references only a single business unit. | ||
DATA_SET_ID | NUMBER | 18 | Budgetary control data set. Identifies the data to be processed by a particular budgetary control request. | ||
FUNDS_CHECK_RESULT_CODE | VARCHAR2 | 30 | Budgetary control status of this transaction as of the last funds check done on this transaction. | ||
FUNDS_RESERVATION_RESULT_CODE | VARCHAR2 | 30 | Budgetary control status of this transaction as of the last funds reserve done on this transaction. | ||
HEADER_GROUP_CODE | VARCHAR2 | 30 | Used to control whether multiple transactions should be grouped together for budgetary control purpose. If provided, any transactions with the same value for this column will pass or fail budgetary control as a unit. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
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_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. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
xcc_sim_lines | xcc_sim_headers | TRANSACTION_TYPE_CODE, SOURCE_HEADER_ID_1, SOURCE_HEADER_ID_2 |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
XCC_SIM_HEADERS_N1 | Non Unique | FUSION_TS_TX_DATA | DATA_SET_ID |
XCC_SIM_HEADERS_U1 | Unique | FUSION_TS_TX_DATA | TRANSACTION_TYPE_CODE, SOURCE_HEADER_ID_1, SOURCE_HEADER_ID_2 |