CST_REVENUE_LINES
This is persistent table which contains the revenue lines details for Invoice / credit memo lines specific to business unit level, transferred by the COGS Processor and to be utilised for the COGS / RMA Recognition.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_REVENUE_LINES_PK |
REVENUE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Value that uniquely identifies the external source system. | |
| EXTERNAL_SYSTEM_REF_ID | NUMBER | 18 | Yes | Value that uniquely identifies the unique transaction in the source system. | |
| REVENUE_LINE_ID | NUMBER | 18 | Yes | Unique revenue distribution identifier auto-created within costing. | |
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | The unique identifier of the invoice or the performance obligation line. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Billing / selling business unit identifier for the revenue line. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | The currency code of the invoice or performance obligation associated with the revenue line. | ||
| LEDGER_ID | NUMBER | 18 | Yes | The unique identifier of the ledger where the revenue distribution is recorded. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | The unique identifier of the legal entity corresponding to the revenue line. | ||
| INVOICE_NUMBER | VARCHAR2 | 20 | Yes | The invoice or contract number associated with the revenue line. | |
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit for the transaction line. | |||
| QUANTITY_INVOICED | NUMBER | Quantity associated with the revenue line. | |||
| UOM_CODE | VARCHAR2 | 10 | Code for the unit of measure associated with the revenue line. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Value that uniquely identifies the inventory item. | ||
| INVOICE_DATE | TIMESTAMP | The date of the invoice or customer contract associated with the revenue line. | |||
| WAREHOUSE_ID | NUMBER | 18 | Value that uniquely identifies the inventory organization for the ship-from location. | ||
| GL_DATE | DATE | The accounting date of the revenue distribution in the general ledger. | |||
| PREVIOUS_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Value that uniquely identifies invoice or the performance obligation line for the Credit Memo. | ||
| CUSTOMER_TRX_ID | NUMBER | 18 | The unique identifier of the invoice or the customer contract header. | ||
| PREVIOUS_CUSTOMER_TRX_ID | NUMBER | 18 | Value that uniquely identifies invoice or customer contract header for the Credit Memo. | ||
| REVENUE_AMOUNT | NUMBER | Transaction line revenue amount. | |||
| EXTENDED_AMOUNT | NUMBER | Transaction line extended amount. | |||
| ACCTD_AMOUNT | NUMBER | Accounted amount in the functional currency. | |||
| REVENUE_PERCENTAGE | NUMBER | Percentage of the revenue recognized. | |||
| INVOICE_SOURCE | VARCHAR2 | 30 | The source of the invoice or contract associated with the revenue line. Possible values are: DOO: Distributed Order Orchestration. FOS: Supply Chain Financial Orchestration. | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Value that uniquely identifies the bill to site. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Value that uniquely identifies the bill to customer. | ||
| POSTED_FLAG | VARCHAR2 | 1 | The option that indicates if the revenue line is posted. Possible values are: Y: Yes. N: No. | ||
| DOO_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the Distributed Order Orchestration fulfillment key. | ||
| DOO_REFERENCE_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the Distributed Order Orchestration reference fulfillment line. | ||
| DOO_ORDER_NUMBER | VARCHAR2 | 30 | Value that indicates Distributed Order Orchestration order number. | ||
| DOO_ORDER_TYPE | VARCHAR2 | 30 | Value that indicates Distributed Order Orchestration order type. | ||
| ROOT_PARENT_FULFILL_LINE_ID | NUMBER | 18 | Unique identifier of the root or model item in case of complex flows involving KIT, PTO or ATO. | ||
| PARENT_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the parent fulfillment line for the component of a complex item. | ||
| INVOICE_LINE_AMOUNT | NUMBER | Amount in the invoice currency. | |||
| DOCUMENT_TYPE | VARCHAR2 | 20 | Indicates the type of document associated with the revenue line. Possible values are: INV: Invoice. CM: Credit Memo. DM: Debit Memo. | ||
| REFERENCE_LINE_ID | NUMBER | 18 | Value that uniquely identifies the reference line. | ||
| VRM_SRC_DOC_ID | NUMBER | 18 | For the revenue line with source as Revenue Management, this will be the unique identifier of the source document for a sales order, invoice, project or service contract. | ||
| VRM_SRC_DOC_LINE_ID | NUMBER | 18 | For the revenue line with source as Revenue Management, this will be the unique identifier of the source document line. Examples of source document line include sales order line, invoice line, project line, and service contract line. | ||
| 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. | ||
| DELIVERY_ID | VARCHAR2 | 30 | Value that uniquely identifies the delivery or the RMA receipt transaction. | ||
| TXN_PROCESSING_GROUP_ID | NUMBER | 18 | The unique identifier of the transaction processing group. | ||
| DOO_FLINE_PRICE_ADJUSTMENT_ID | NUMBER | 18 | Value that uniquely identifies the discount value for the item or manual price adjustment. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Load request identifier used by file based data import process. | ||
| REVENUE_ACCOUNT | NUMBER | 18 | Value that uniquely identifies the sales representative related code combination. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Value that uniquely identifies the inventory organization associated with the revenue line. | |
| GROSS_MARGIN_FLAG | VARCHAR2 | 1 | Indicates if the gross margin calculations have been done for the revenue line. Values: 1. N and R = Not processed 2. NULL = Processed for gross margin calculations 3. U = Inventory Organization identifier is updated on already processed revenue line by COGS Processor. Such revenue lines should be picked up again for gross margin calculations. 4. P = Inventory Organization identifier is not available on Costing revenue line and Inventory Organization identifier in Distributed Order Orchestration is not associated to any Cost Organization. Such revenue lines will not be picked up for gross margin calculations until Inventory Organization identifier is updated by COGS Processor on Costing revenue line. | ||
| ATO_TOP_MODEL_FLINE_ID | NUMBER | 18 | The unique identifier of the ATO model fulfillment line. In case of nested ATO, it represents the top level ATO model fulfillment line identifier. | ||
| ATO_TOP_MODEL_ITEM_ID | NUMBER | 18 | The unique identifier of the ATO model item. In case of nested ATO, it represents the top level ATO model item identifier. | ||
| CONFIG_INVENTORY_ITEM_ID | NUMBER | 18 | The unique identifier of the shippable ATO configured item. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CST_REVENUE_LINES_N1 | Non Unique | FUSION_TS_TX_DATA | DOO_FULFILL_LINE_ID, INVOICE_SOURCE | |
| CST_REVENUE_LINES_N2 | Non Unique | Default | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID | Obsolete |
| CST_REVENUE_LINES_N3 | Non Unique | Default | ROOT_PARENT_FULFILL_LINE_ID | |
| CST_REVENUE_LINES_N4 | Non Unique | Default | INVENTORY_ORG_ID | |
| CST_REVENUE_LINES_N5 | Non Unique | Default | GROSS_MARGIN_FLAG | |
| CST_REVENUE_LINES_PK | Unique | FUSION_TS_TX_DATA | REVENUE_LINE_ID | |
| CST_REVENUE_LINES_U1 | Unique | FUSION_TS_TX_DATA | REVENUE_LINE_ID, EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE | Obsolete |
| CST_REVENUE_LINES_U2 | Unique | Default | EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE |