XCC_UNDO_REDO_LINES_GT
Contains the transaction lines being processed by the current run of the budgetary control undo and re-reserve process. For each transaction line, it contains a foreign key to the associated budgetary control transaction, as well as the associated transaction type, action, and ledger. In the case of General Ledger and Subledger Accounting, a -99 is stored instead of a ledger.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
XCC_UNDO_REDO_LINES_GT_PK |
HEADER_NUM, LINE_NUM |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
HEADER_NUM | VARCHAR2 | 100 | Yes | Budgetary control transaction to be processed by the budgetary control undo and re-reserve process. | |
LINE_NUM | NUMBER | 18 | Yes | Budgetary control transaction line to be processed by the budgetary control undo and re-reserve process. | |
TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Transaction type of the budgetary control transaction to be processed by the budgetary control undo and re-reserve process. | |
SOURCE_ACTION_CODE | VARCHAR2 | 30 | Yes | Source action of the budgetary control transaction to be processed by the budgetary control undo and re-reserve process. | |
LEDGER_ID | NUMBER | 18 | Yes | Ledger of the budgetary control transaction to be processed by the budgetary control undo and re-reserve process. This is set to -99 for General Ledger and Subledger Accounting. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
XCC_UNDO_REDO_LINES_GT_N1 | Non Unique | TRANSACTION_TYPE_CODE, SOURCE_ACTION_CODE, LEDGER_ID |
XCC_UNDO_REDO_LINES_GT_U1 | Unique | HEADER_NUM, LINE_NUM |