CST_LIQUIDATION_AMTS
This table is used to store liquidation amounts.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_LIQUIDATION_AMTS_PK |
DISTRIBUTION_ID, PO_DISTRIBUTION_ID, CST_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DISTRIBUTION_ID | NUMBER | 18 | Yes | Identifies the cost distribution header record. | |
| PO_DISTRIBUTION_ID | VARCHAR2 | 30 | Yes | Purchase order distribution unique identifier. | |
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. | ||
| TRANSACTION_QTY | NUMBER | Receiving transaction quantity in source document UOM. | |||
| PO_PRICE | NUMBER | Indicates the unit purchase price for accrual and tax components. | |||
| PO_ITEM_DESCRIPTION_TYPE | VARCHAR2 | 20 | Indicates the type of purchase in case purchase is made for non-inventory item based on a description. Valid values are GOODS or SERVICE. | ||
| CST_TRANSACTION_ID | NUMBER | 18 | Yes | Transaction identifier which uniquely identifies a transaction in costing. | |
| RCV_TRANSACTION_ID | NUMBER | 18 | Receiving transaction identifier. | ||
| TRANSACTION_DATE | DATE | The date when this transaction happened. | |||
| RECEIPT_CREATION_DATE | DATE | Stores actual receipt creation date to calculate if a transaction is back dated or not. | |||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Identifies the SLA event type as defined in CST cost distributions. | ||
| BC_FLAG | VARCHAR2 | 1 | Budgetary control enabled flag. Y - Budget Control enabled transaction. N/NULL - Not enabled. | ||
| EA_FLAG | VARCHAR2 | 1 | Encumbrance Accounting Flag indicator. Y - encumbrance enabled transaction. X - Might be applicable or not. N/NULL - Not enabled. | ||
| POSTED_FLAG | VARCHAR2 | 5 | Flag to indicate if the transaction is processed or not. | ||
| LIQUIDATED_QTY | NUMBER | Liquidated qty that will be used for calculation of Reversal Amount. | |||
| TRANSACTION_TYPE | VARCHAR2 | 40 | Identifies the Receiving event types associated with the transaction. | ||
| ORDERED_QTY | NUMBER | The quantity of a good or service ordered. | |||
| EXCHANGE_RATE | NUMBER | Exchange Rate from transaction (entered) to base currency. | |||
| PO_PRICE_DIFF | NUMBER | The difference between latest and previous purchase order price. | |||
| CURR_PO_PRICE | NUMBER | The latest purchase order price. | |||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_LIQUIDATION_AMTS_N1 | Non Unique | Default | PO_DISTRIBUTION_ID |
| CST_LIQUIDATION_AMTS_N2 | Non Unique | Default | CST_TRANSACTION_ID |
| CST_LIQUIDATION_AMTS_U1 | Unique | Default | DISTRIBUTION_ID, PO_DISTRIBUTION_ID, CST_TRANSACTION_ID |