1. Tables and Views for SCM
  2. CST_ACCTG_ONLY_TXNS

CST_ACCTG_ONLY_TXNS

Contains accounting only transactions created by the cost preprocessors for events with no physical movement of items such as invoices to expense. The accounting only transactions are created specific to the cost organization books and are created in the currency of the ledger as defined by the cost organization book combination.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_ACCTG_ONLY_TXNS_PK

ACCTG_ONLY_TXNS_ID

Columns

Name Datatype Length Precision Not-null Comments
ACCTG_ONLY_TXNS_ID NUMBER 18 Yes Surrogate key that identifies a row in this table.
INVOICE_TO_EXP_TXN_ID NUMBER 18 Yes Single column FK: Identifies the Invoice to Expense transaction.
COST_ORG_ID NUMBER 18 Yes Identifies the Cost Organization for which this accounting only transaction is created.
COST_BOOK_ID NUMBER 18 Yes Identifies the Cost Book for which this accounting only transaction is created.
INVENTORY_ORG_ID NUMBER 18 Indicates The Inventory Org To Which The Item Belongs
INVENTORY_ITEM_ID NUMBER 18 Identifies the Inventory Item for which this accounting only transaction is created.
INVOICE_TO_EXP_AMT NUMBER Identifies the amount to expense for this accounting only transaction.
CURRENCY_CODE VARCHAR2 15 Identifies currency of the amount for this accounting only transaction.
EVENT_TYPE_CODE VARCHAR2 30 Reference to the event type for which the accounting template is defined.
EVENT_CLASS_CODE VARCHAR2 30 Reference to event class for which the accounting template is defined.
ENTITY_CODE VARCHAR2 30 Reference to the entity code of the event.
TXN_ACCOUNT_DATE TIMESTAMP Identifies the date to be used for accounting this accounting only transaction.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
POSTED_FLAG VARCHAR2 1 Indicates if the accounting only transaction has been accounted by the SLA. N - Not accounted, D - Draft Accounted, F - Final Accounted. The LOOKUP_TYPE for these values is CST_ACCOUNTED_FLAG.
DISTRIBUTION_ID NUMBER 18 Single column FK: Identifies the cost distribution header record.
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.
CONSIGNED_FLAG VARCHAR2 1 Indicates if the corresponding purchase order is a consigned PO.
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.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
COST_STATUS VARCHAR2 1 Current costing status of the transaction for display: N-Not Processed, P-Partially Processed, C-Fully Costed, E-Error, X-Excluded from Costing.
ACCOUNTING_STATUS VARCHAR2 1 Current accounting status of the transaction for display: N-Not Processed, D-Draft Accounted, F-Final Accounted, E-Error, X-Excluded from Accounting.
LE_TIMEZONE_CODE VARCHAR2 50 Legal Entity timezone. If NULL, then LE timezone is not enabled for the data in the row and the dates are assumed to be in database timezone.

Foreign Keys

Table Foreign Table Foreign Key Column
CST_ACCTG_ONLY_TXNS cst_invoice_to_exp_acctg INVOICE_TO_EXP_TXN_ID, COST_ORG_ID, COST_BOOK_ID

Indexes

Index Uniqueness Tablespace Columns
CST_ACCTG_ONLY_TXNS_N1 Non Unique Default TRUNC("TXN_ACCOUNT_DATE"), COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID
CST_ACCTG_ONLY_TXNS_U1 Unique FUSION_TS_TX_DATA INVOICE_TO_EXP_TXN_ID, COST_ORG_ID, COST_BOOK_ID
CST_ACCTG_ONLY_TXNS_U2 Unique FUSION_TS_TX_DATA ACCTG_ONLY_TXNS_ID