CST_INCM_TXN_COST_SRC_S_GT
This table is used to temporarily store a subset of data from CST_INCOMING_TXN_COST_SOURCES table to support internal processing within the Cost Processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: DEFAULT
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Inventory transaction. | |
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Identifies the PO distribution that contributed to this acquisition cost. | |
| PO_EVENT_DATE | TIMESTAMP | Identifies the event date of the PO distribution that contributed to this acquisition cost. | |||
| CMR_AP_INVOICE_DIST_ID | NUMBER | 18 | Yes | Identifies the AP invoice distribution that contributed to this acquisition cost. | |
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Identifies the trade operation that contributed to this acquisition cost. | |
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | Yes | Single Column FK: Indiciates the fiscal document header. | |
| CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | Identifies the trade operation charge line that contributed to this acquisition cost. | |
| CONS_PRICE_UPD_EFFECTIVE_DATE | TIMESTAMP | Effective date of the consigned purchase order price update. | |||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_INCM_TXN_COST_SRC_S_GT_U1 | Unique | CST_INV_TRANSACTION_ID, CMR_PO_DISTRIBUTION_ID, CMR_AP_INVOICE_DIST_ID, TRADE_OPERATION_ID, CHARGE_LINE_NUMBER, FISCAL_DOC_HEADER_ID |