XCC_SIM_LINES
Stores transaction line 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_LINES_PK |
TRANSACTION_TYPE_CODE, SOURCE_LINE_ID_1, SOURCE_LINE_ID_2, SOURCE_LINE_ID_3, SOURCE_LINE_ID_4, SOURCE_LINE_ID_5, SOURCE_LINE_ID_6 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Transaction type of the pseudo application transaction line. | |
| PJC_FUNDING_SOURCE_ID | NUMBER | 18 | Project accounting funding source unique identifier | ||
| SOURCE_LINE_ID_1 | VARCHAR2 | 30 | Yes | Second part of unique identifier for the pseudo application transaction line. | |
| SOURCE_LINE_ID_2 | VARCHAR2 | 30 | Yes | Third part of unique identifier for the pseudo application transaction line. | |
| SOURCE_LINE_ID_3 | VARCHAR2 | 30 | Yes | Fourth part of unique identifier for the pseudo application transaction line. | |
| SOURCE_LINE_ID_4 | VARCHAR2 | 30 | Yes | Fifth part of unique identifier for the pseudo application transaction line. | |
| SOURCE_LINE_ID_5 | VARCHAR2 | 30 | Yes | Sixth part of unique identifier for the pseudo application transaction line. | |
| SOURCE_LINE_ID_6 | VARCHAR2 | 30 | Yes | Seventh part of unique identifier for the pseudo application transaction line. | |
| SOURCE_HEADER_ID_1 | VARCHAR2 | 30 | Yes | Second part of unique identifier for the associated pseudo application transaction. | |
| SOURCE_HEADER_ID_2 | VARCHAR2 | 30 | Yes | Third part of unique identifier for the associated pseudo application transaction. | |
| LEDGER_ID | NUMBER | 18 | Ledger of the pseudo application transaction line in those cases where the ledger varies from line to line. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Business unit of the pseudo application transaction line in those cases where the business unit varies from line to line. | ||
| LINE_NUM | NUMBER | 18 | Line number. Used to provide an order in which lines should be evaluated to the budgetary control engine. | ||
| LINE_GROUP_CODE | VARCHAR2 | 30 | Groups together lines that should pass or fail funds reservation as a unit. | ||
| TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 30 | Transaction subtype of the pseudo application transaction line. | ||
| JE_CATEGORY_CODE | VARCHAR2 | 25 | General Ledger journal category of the pseudo application transaction line. | ||
| BUDGET_DATE | DATE | Yes | Budget date of the pseudo application transaction line. | ||
| ACCOUNTING_DATE | DATE | Yes | Accounting date of the pseudo application transaction line. | ||
| ENCUMBRANCE_TYPE_CODE | VARCHAR2 | 30 | Encumbrance type of the pseudo application transaction line. | ||
| ENTERED_CURRENCY | VARCHAR2 | 15 | Yes | Currency of the pseudo application transaction line. | |
| UOM_CODE | VARCHAR2 | 3 | Unit of measure of the pseudo application transaction line. | ||
| QUANTITY | NUMBER | Quantity of the pseudo application transaction line. | |||
| PRICE | NUMBER | Unit price of the pseudo application transaction line. | |||
| ENTERED_AMOUNT | NUMBER | Yes | Amount of the pseudo application transaction line in the transaction line currency. | ||
| CONVERSION_TYPE_CODE | VARCHAR2 | 30 | Conversion type to be used to convert the pseudo application transaction line to other currencies. | ||
| CONVERSION_DATE | DATE | Conversion date to be used to convert the pseudo application transaction line to other currencies. | |||
| LEDGER_AMOUNT | NUMBER | Amount of the pseudo application transaction line in the ledger currency. | |||
| STATISTICAL_AMOUNT | NUMBER | Statistical amount associated with the pseudo application transaction line. | |||
| LIQUIDATION_AMOUNT | NUMBER | Amount of the upstream transaction line to liquidate | |||
| LIQUIDATION_DATE | DATE | Date on which to liquidate the upstream transaction line. | |||
| LIQUIDATION_QUANTITY | NUMBER | Quantity of the upstream transaction line to liquidate. | |||
| LIQUIDATION_TRANS_TYPE_CODE | VARCHAR2 | 30 | Transaction type of the upstream transaction line that is to be liquidated. | ||
| LIQUIDATION_LINE_ID_1 | VARCHAR2 | 30 | Second part of unique identifier for the upstream transaction line that is to be liquidated. | ||
| LIQUIDATION_LINE_ID_2 | VARCHAR2 | 30 | Thrid part of unique identifier for the upstream transaction line that is to be liquidated. | ||
| LIQUIDATION_LINE_ID_3 | VARCHAR2 | 30 | Fourth part of unique identifier for the upstream transaction line that is to be liquidated. | ||
| LIQUIDATION_LINE_ID_4 | VARCHAR2 | 30 | Fifth part of unique identifier for the upstream transaction line that is to be liquidated. | ||
| LIQUIDATION_LINE_ID_5 | VARCHAR2 | 30 | Sixth part of unique identifier for the upstream transaction line that is to be liquidated. | ||
| LIQUIDATION_LINE_ID_6 | VARCHAR2 | 30 | Seventh part of unique identifier for the upstream transaction line that is to be liquidated. | ||
| CONTROL_BUDGET_ID | NUMBER | 18 | Control budget associated with the pseudo application transaction line. | ||
| BUDGET_CCID | NUMBER | 18 | Budget account of the pseudo application transaction line. | ||
| VENDOR_ID | NUMBER | 18 | Vendor of the pseudo application transaction line. | ||
| ORDER_TYPE_INFO | VARCHAR2 | 100 | Order type of the pseudo application transaction line. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item of the pseudo application transaction line. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | General Ledger account of the pseudo application transaction line. | ||
| CASH_CODE_COMBINATION_ID | NUMBER | 18 | Cash account of the pseudo application transaction line. | ||
| REVENUE_CODE_COMBINATION_ID | NUMBER | 18 | Revenue account of the pseudo application transaction line. | ||
| PJC_PROJECT_ID | NUMBER | 18 | Project of the pseudo application transaction line. | ||
| PJC_TASK_ID | NUMBER | 18 | Task of the pseudo application transaction line. | ||
| PJC_RESOURCE_ID | NUMBER | 18 | Resource of the pseudo application transaction line. | ||
| PJC_CONTRACT_ID | NUMBER | 18 | Contract of the pseudo application transaction line. | ||
| PJC_CONTRACT_LINE_ID | NUMBER | 18 | Contract line of the pseudo application transaction line. | ||
| PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Funding allocation of the pseudo application transaction line. | ||
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Billable status of the pseudo application transaction line. | ||
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Capitablizable status of the pseudo application transaction line. | ||
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure type of the pseudo application transaction line. | ||
| PJC_EXPENDITURE_ITEM_DATE | DATE | Expenditure item date of the pseudo application transaction line. | |||
| PJC_ORGANIZATION_ID | NUMBER | 18 | Project organization of the pseudo application transaction line. | ||
| PJC_WORK_TYPE_ID | NUMBER | 18 | Work type of the pseudo application transaction line. | ||
| 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 the transaction line, as of the last funds check done on this transaction line. | ||
| FUNDS_RESERVATION_RESULT_CODE | VARCHAR2 | 30 | Budgetary control status of the transaction line, as of the last funds reserve done on this transaction line. | ||
| SOURCE_LINE_TYPE_CODE | VARCHAR2 | 30 | Identifies the type of transaction line. | ||
| 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_LINES_N2 | Non Unique | FUSION_TS_TX_DATA | TRANSACTION_TYPE_CODE, SOURCE_HEADER_ID_1, SOURCE_HEADER_ID_2 |
| XCC_SIM_LINES_N3 | Non Unique | FUSION_TS_TX_DATA | DATA_SET_ID |
| XCC_SIM_LINES_U1 | Unique | FUSION_TS_TX_DATA | TRANSACTION_TYPE_CODE, SOURCE_LINE_ID_1, SOURCE_LINE_ID_2, SOURCE_LINE_ID_3, SOURCE_LINE_ID_4, SOURCE_LINE_ID_5, SOURCE_LINE_ID_6 |