CST_ACQ_COST_ADJ_EVENTS_GT
Temporary table for processing acquisition cost adjustments by event date.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Yes | Identifies the purchase order distribution in Costing. | |
| EVENT_DATE | TIMESTAMP | Yes | Indicates the acquisition cost adjustment event date. | ||
| EVENT_TYPE | VARCHAR2 | 30 | Indicates the acquisition cost adjustment event type. | ||
| EVENT_RANK | NUMBER | 18 | Indicates the acquisition cost adjustment event processing rank. | ||
| INVOICE_ID | NUMBER | 18 | Identifies the payables invoice. | ||
| ADJUSTMENT_DATE | TIMESTAMP | Indicates the adjustment date derived in the preprocessing to be used in cost processing acquisition cost adjustments. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ACQ_COST_ADJ_EVENTS_GT_N1 | Non Unique | CMR_PO_DISTRIBUTION_ID, EVENT_DATE |