CST_I_AR_REVENUE_LINES
This is interface table which contains the revenue lines details imported by Revenue Lines import program for Invoice / credit memo lines specific to business unit level, transfer the revenue lines to persistent table by COGS Processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_I_AR_REVENUE_LINES_PK |
EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REF_ID | NUMBER | 18 | Yes | Value that uniquely identifies the unique 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 | Billing / selling business unit identifier of the revenue line. | ||
| 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 | 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 | 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. | ||
| 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. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the Import Payables Invoices process ID created the row. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Value that uniquely identifies the inventory organization associated with the revenue line. | |
| STATUS | VARCHAR2 | 2 | Indicates the status of the revenue line. Possible values are: NULL: New revenue line. Not yet processed by COGS Processor. P: Picked for processing by COGS Processor. SE: Ship-bill reference is not available to create COGS or RMA Recognition transaction. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_I_AR_REVENUE_LINES_N1 | Non Unique | Default | BUSINESS_UNIT_ID |
| CST_I_AR_REVENUE_LINES_PK | Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE |