CST_COGS_TXNS_GT
This global temp table contains the COGS / RMA Recognition events created by COGS Processor for the Shipment / RMA Transactions specific to cost org and cost book.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_COGS_TXNS_GT_PK |
TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Unique identifier for COGS Event. | |
| POSTED_FLAG | VARCHAR2 | 5 | Posted Flag: Y to be picked for distributions, E for error status. | ||
| VARIANCE_POSTED_FLAG | VARCHAR2 | 5 | A flag that indicates whether variance cost is expected for COGS or RMA Recognition transaction. Possible values are: NULL: Variance cost is not expected. N: Variance cost is expected and is yet to be created. | ||
| CST_TRANSACTION_ID | NUMBER | 18 | Yes | Stores the Costing specific transaction identifier from CST_TRANSACTIONS table. | |
| COST_ORG_ID | NUMBER | 18 | Single Column FK: Identifies the Cost Organization associated with the Inventory Organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | ||
| TRANSACTION_DATE | TIMESTAMP | For ship-bill case, indicates the accounting date when the revenue recognition had happened. For ship-only case, indicates the transaction date of sales order shipment or RMA receipt transaction. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| REVENUE_LINE_ID | NUMBER | 18 | Yes | Unique revenue distribution identifier. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the Inventory Organization to which the Item belongs. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Value that uniquely identifies the inventory item. | ||
| TRANSACTION_TYPE_ID | NUMBER | 18 | Transaction type identifier: 1 for COGS recognition and 9 for RMA recognition. | ||
| TRANSACTION_SOURCE_TYPE_ID | NUMBER | Transaction source type identifier: 0 for both COGS and RMA recognition. | |||
| TRANSACTION_ACTION_ID | NUMBER | 18 | Transaction action identifier: 1 for COGS recognition and 9 for RMA recognition. | ||
| COGS_PERCENTAGE | NUMBER | Indicates COGS or RMA recognition percentage. | |||
| SHIPMENT_FULLFILL_LINE_ID | NUMBER | 18 | Yes | Reference to the unique identifier of the source fulfillment line in distributed order orchestration (DOO). | |
| DOO_SPLIT_FULFILL_LINE_ID | NUMBER | 18 | Reference to the distributed order orchestration (DOO) fulfillment line identifier. | ||
| CT_DOO_SPLIT_FLINE_ID | NUMBER | 18 | Reference to the distributed order orchestration (DOO) fulfillment line identifier. | ||
| DELIVERY_ID | NUMBER | 18 | Identifies the delivery associated with the shipment transactions. | ||
| RMA_TRANSACTION_ID | NUMBER | 18 | Yes | Identifies the receipt associated with the RMA receipt transactions. | |
| DS_SOURCE_LINE_ID | NUMBER | 18 | Based on Flow Type(ASN OR INVOICE) either Shipment Line Id or Transaction Event Id will be stored. | ||
| DOCUMENT_TYPE | VARCHAR2 | 20 | Document identifier: Invoice & Credit Memo. | ||
| LE_TIMEZONE_CODE | VARCHAR2 | 50 | Value that identifies the legal entity time zone. If NULL, then LE time zone is not enabled for the data in the row and the dates are assumed to be in database time zone. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_COGS_TXNS_GT_U1 | Unique | TRANSACTION_ID |