CST_ACCT_DEFINITIONS
This table contains the accounting definition for the transaction events. These definitions are created as part of SLA setups for Cost Management and are used during cost distributions for accounting.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CST_ACCT_DEFINITIONS_PK |
ACCOUNTING_DEFINITION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNTING_DEFINITION_ID | NUMBER | 18 | Yes | Surrogate identifying the accounting definition line. | |
| PROJECT_ATTRIBUTES_FLAG | VARCHAR2 | 1 | Indicates I- for Material flow equal to Project flow, P- for Material flow not equal to project flow. | ||
| 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. | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Reference to event class for which the accounting template is defined. | ||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Reference to the event type for which the accounting template is defined. | ||
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Identifies whether a transaction is an asset or expense transaction. Expense = Y, Asset = N. | ||
| ALLOW_PROJECT_TXN | VARCHAR2 | 1 | Indicates if the journal line type of the accouting template line can be transferred to projects. | ||
| FOB_POINT | NUMBER | 1 | Indicates if the FOB Point for which the accounting definition is valid. Note this is only applicable for the intransit transfers. Possible values are: Receipt, Shipment | ||
| INTERCOMPANY_INVOICE_FLAG | VARCHAR2 | 1 | Identifies if the inter-company invoice is enabled for a transaction. Y = Yes, N= No | ||
| OVERHEAD_FLAG | VARCHAR2 | 1 | Indicates if the Account definition is applicable for overheads. | ||
| TRANSACTION_TYPE | VARCHAR2 | 10 | Indicates if the transaction is of type issue or receipt. | ||
| TRANSACTION_FLOW_TYPE | NUMBER | 18 | Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others. | ||
| COST_COMPONENT_CODE | VARCHAR2 | 30 | Identifies the cost component. Values are based on the seeded cost components in the lookup type CST_COMPONENT_CODES | ||
| LINE_NO | NUMBER | 5 | Yes | Line number of the accounting template line for an event. | |
| ACCOUNTING_LINE_TYPE | VARCHAR2 | 30 | Yes | Journal Line type of the accounting template line. | |
| DR_CR_SIGN | VARCHAR2 | 6 | Yes | Indicate whether the amount for this line is: Dr, Cr | |
| REVERSE_SIGN_FLAG | VARCHAR2 | 1 | Yes | Indicates if the debit/credit signs should be changes if the amounts are negative. | |
| USE_TXN_CURR_AMOUNT | VARCHAR2 | 1 | Yes | Indicates if the transaction currency amounts are used for accounting enteries as entered amounts. | |
| USE_TXN_ACCOUNT | VARCHAR2 | 1 | Yes | Indicates if the accounts entered on the transaction are used for accounting enteries as entered account. | |
| SOURCE_TABLE | VARCHAR2 | 30 | Yes | Indicates the name of the table from which the distribution will be created. | |
| DISTRIBUTION_TYPE | VARCHAR2 | 30 | Indicates the distribtuion type. Useful if the same event type may go into different accounting line types; depending on some attribute on the cost. | ||
| IGNORE_NULL_EVENT_TYPES | VARCHAR2 | 1 | Do not denormalize any other accounting lines where event_type is null and is not overhead related accounting lines. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates 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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cst_cost_distribution_lines | cst_acct_definitions | ACCOUNTING_DEFINITION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_ACCT_DEFINITIONS_N1 | Non Unique | FUSION_TS_TX_DATA | EVENT_CLASS_CODE, EVENT_TYPE_CODE, EXPENSE_TRANSACTION_FLAG |
| CST_ACCT_DEFINITIONS_U1 | Unique | Default | ACCOUNTING_DEFINITION_ID, ORA_SEED_SET1 |
| CST_ACCT_DEFINITIONS_U11 | Unique | Default | ACCOUNTING_DEFINITION_ID, ORA_SEED_SET2 |