FV_BE_TRANSACTION_TYPES
This table contains information for budget execution transaction types that will be used when creating budget transactions.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FV_BE_TRANS_TYPES_PK |
TRANSACTION_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_TYPE_ID | NUMBER | 18 | Yes | Identifier for transaction type. | |
| NAME | VARCHAR2 | 30 | Yes | Budget execution transaction type. | |
| DESCRIPTION | VARCHAR2 | 240 | Yes | Description of the budget transaction type. | |
| LEDGER_ID | NUMBER | 18 | Unique identifier for the ledger. | ||
| BUDGET_LEVEL_ID | NUMBER | 18 | Unique identifier for the budget level. | ||
| AUTHORITY_TYPE_CODE | VARCHAR2 | 30 | Spending authority type for a Treasury Account Symbol. | ||
| TRADING_PARTNER_FLAG | VARCHAR2 | 1 | Indicates if a trading partner is required. | ||
| REDUCTION_TYPE_FLAG | VARCHAR2 | 1 | Indicates if a reduction type is required on a budget transaction. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates if an object is active or inactive. | |
| BUDGET_SEQUENCE_NUM | NUMBER | 18 | Yes | Number assigned to budget sequence. | |
| DEFAULT_FLAG | VARCHAR2 | 1 | It includes transaction type defaults. | ||
| DIRECT_OR_REIMBURSEMENT_CODE | VARCHAR2 | 30 | Identifies whether amounts for goods, services, and joint project support are financed by offsetting collections. | ||
| ANTICIPATED_IN_CURRENT_FY_FLAG | VARCHAR2 | 1 | Indicates that the transaction is expected or anticipated to occur in the current fiscal year. | ||
| FUND_TYPE_CODE | VARCHAR2 | 30 | The code that establishes how the account will be funded. | ||
| APPORTIONMENT_CATEGORY_CODE | VARCHAR2 | 30 | Identifies Office of Management and Budget apportionments by quarters (Category A) or by other specified time periods, programs, activities, projects, objects, or combinations of these (Category B), or are not subject to apportionment (Category E). | ||
| ADVANCE_TYPE_FLAG | VARCHAR2 | 1 | Indicates if an advance type is required on a budget transaction. | ||
| PUBLIC_LAW_FLAG | VARCHAR2 | 1 | Indicates if a public law code is required on a budget transaction. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| 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. | ||
| 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. | |
| 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. | |
| CLOSE_BUDGET_FLAG | VARCHAR2 | 1 | Indicates whether a budgetary transaction type for year end close usage is enabled. | ||
| LEDGER_GROUP_ID | NUMBER | 18 | Yes | Unique identifier for ledger groups. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FV_BE_TRANS_TYPES_N1 | Non Unique | FUSION_TS_TX_DATA | LEDGER_GROUP_ID |
| FV_BE_TRANS_TYPES_N2 | Non Unique | FUSION_TS_TX_DATA | BUDGET_SEQUENCE_NUM, LEDGER_GROUP_ID |
| FV_BE_TRANS_TYPES_U1 | Unique | FUSION_TS_TX_DATA | TRANSACTION_TYPE_ID |
| FV_BE_TRANS_TYPES_U2 | Unique | FUSION_TS_TX_DATA | NAME, LEDGER_GROUP_ID |