CST_INVOICE_TO_EXP

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CST_INVOICE_TO_EXP_ACCTG_PK	INVOICE_TO_EXP_TXN_ID, COST_ORG_ID, COST_BOOK_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INVOICE_TO_EXP_TXN_ID	NUMBER		18	Yes	Surrogate key that Identifies a row in this table.
COST_ORG_ID	NUMBER		18	Yes	Single column FK: Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID	NUMBER		18	Yes	Single column FK: Identifies the Cost Book assigned to the Cost Organization.
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 be moved out of receiving inspection
FROM_CURRENCY_CODE	VARCHAR2	15		Yes	Identifies the original currency, or the currency of the transaction.
TO_CURRENCY_CODE	VARCHAR2	15			Identifies the target, or default currency code as specified by the ledger.
CURRENCY_CONVERSION_TYPE	VARCHAR2	30			Conversion type that should be used for currency conversion.
CURRENCY_CONVERSION_DATE	TIMESTAMP			Yes	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.
TXN_ACCOUNT_DATE	TIMESTAMP				Identifies the date to be used for accounting this transaction
POSTED_FLAG	VARCHAR2	1			Indicates if the invoice to expense by book transaction has been currency converted. N - No, Y - Yes. There is no LOOKUP_TYPE for these codes.
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
CST_INVOICE_TO_EXP_ACCTG	cst_cost_books_b	COST_BOOK_ID
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_INVOICE_TO_EXP_ACCTG_N1	Non Unique	FUSION_TS_TX_DATA	POSTED_FLAG, COST_ORG_ID, COST_BOOK_ID
CST_INVOICE_TO_EXP_ACCTG_PK	Unique	FUSION_TS_TX_DATA	INVOICE_TO_EXP_TXN_ID, COST_ORG_ID, COST_BOOK_ID