CST_REJECTED_REV_LINES
This table will store invalid revenue lines that are interfaced from upstream applications.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
CST_REJECTED_REV_LINES_PK |
REJECTED_REV_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REJECTED_REV_LINE_ID | NUMBER | 18 | Yes | Unique revenue distribution identifier auto created within costing. | |
| EXTERNAL_SYSTEM_REF_ID | NUMBER | 18 | Yes | Value that uniquely identifies the transaction in the source system. | |
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Value that uniquely identifies the external source system. | |
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | The unique identifier of the invoice or the performance obligation line. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | The unique identifier for the business unit. | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency code identifier of the invoice line associated to 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 | The unique identifier for 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 | TIMESTAMP | 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. | |||
| 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. | ||
| 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. | ||
| DOO_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the Distributed Order Orchestration fulfillment key. | ||
| DELIVERY_ID | VARCHAR2 | 30 | Value that uniquely identifies the delivery or the RMA receipt transaction. | ||
| DOO_REFERENCE_FULFILL_LINE_ID | NUMBER | 18 | Value that uniquely identifies the Distributed Order Orchestration reference fulfillment line. | ||
| 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. | ||
| REFERENCE_LINE_ID | NUMBER | 18 | Value that uniquely identifies the reference 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. | ||
| DOO_FLINE_PRICE_ADJUSTMENT_ID | NUMBER | 18 | Value that uniquely identifies the discount value for the item or manual price adjustment. | ||
| REVENUE_ACCOUNT | NUMBER | 18 | Value that uniquely identifies the sales representative related code combination. | ||
| 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. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Value that uniquely identifies the inventory organization associated with the revenue line. | |
| VRM_ASE_FLAG | VARCHAR2 | 1 | Indicates whether additional satisfaction events are defined in Revenue Management for the revenue line. Possible values are - Y: Additional satisfaction events are defined, NULL: Additional satisfaction events are not defined. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_REJECTED_REV_LINES_U1 | Unique | Default | REJECTED_REV_LINE_ID |