1. Tables and Views for SCM
  2. CST_INVOICE_TO_EXP_TXNS

CST_INVOICE_TO_EXP_TXNS

This table holds the transactions created to expense the invoice balances where the net delivered quantity for the PO distribution (in case of match to PO invoices) or the PO distribution receipt combination (in case of match to receipt invoices) is zero.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_INVOICE_TO_EXP_TXNS_PK

INVOICE_TO_EXP_TXN_ID

Columns

Name Datatype Length Precision Not-null Comments
INVOICE_TO_EXP_TXN_ID NUMBER 18 Yes Unique identifier of the transaction
CMR_PO_DISTRIBUTION_ID NUMBER 18 Purchase order distribution identifier
CMR_PO_LINE_LOCATION_ID NUMBER 18 Purchase Order Schedule identifier.
CMR_RCV_TRANSACTION_ID NUMBER 18 Receiving transaction identifier
INVOICE_TO_EXP_AMT NUMBER The amount to be moved out of receiving inspection
TXN_ACCOUNT_DATE TIMESTAMP Date to be used for accounting this transaction. It is picked up to be the date of the latest receipt that has caused the net delivered quantity to go to zero. For reversals, the date will be the txn_account_date of the original txn.
INVENTORY_ORG_ID NUMBER 18 Identifier of the inventory organization associated with the purchase order distribution.
INVENTORY_ITEM_ID NUMBER 18 Item associated with the Purchase Order Distribution
REVERSE_INVOICE_TO_EXP_TXN_ID NUMBER 18 The original expensing txn that is being reversed.
CURRENCY_CODE VARCHAR2 15 Identifies the currency of the transaction / cost.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion type that should be used for currency conversion
CURRENCY_CONVERSION_DATE TIMESTAMP The date to be used to determine the exchange rates for currency conversion
CURRENCY_CONVERSION_RATE NUMBER Optional user specified currency conversion rate.
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.
PREPROCESSED_FLAG VARCHAR2 1 Indicates if the record has been picked and expanded by book
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.

Foreign Keys

Table Foreign Table Foreign Key Column
cst_invoice_to_exp_acctg cst_invoice_to_exp_txns INVOICE_TO_EXP_TXN_ID

Indexes

Index Uniqueness Tablespace Columns
CST_INVOICE_TO_EXP_TXNS_PK Unique FUSION_TS_TX_DATA INVOICE_TO_EXP_TXN_ID