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 |