CST_PROJECT_REVENUE_LINES
This is the shadow table which contains the data from the revenue lines table which are project enabled. We are moving it to a separate here for performance reasons and may be used for special processing in later releases.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_PROJECT_REVENUE_LINES_PK |
PROJECT_REVENUE_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifies the external source system | |
| EXTERNAL_SYSTEM_REF_ID | NUMBER | 18 | Yes | Transaction Unique identifier in the source system | |
| PROJECT_REVENUE_LINE_ID | NUMBER | 18 | Yes | Unique project revenue distribution identifier auto-created within costing | |
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Unique Invoice Transaction Line Identifier | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Billing / selling business Unit Identifier | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency Code | ||
| LEDGER_ID | NUMBER | 18 | Yes | Refer to distinct Ledger values corresponding to the receivables revenue lines | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Refer to the distinct Legal Entity values corresponding to the receivables revenue lines | ||
| INVOICE_NUMBER | VARCHAR2 | 20 | Yes | Line number of the invoice | |
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit for a transaction line | |||
| QUANTITY_INVOICED | NUMBER | Invoice Quantity | |||
| UOM_CODE | VARCHAR2 | 10 | Unit of Measure | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier | ||
| INVOICE_DATE | TIMESTAMP | Invoice Creation Date | |||
| WAREHOUSE_ID | NUMBER | 18 | Inventory Org Identifier the ship-from location | ||
| GL_DATE | DATE | General Ledger Date | |||
| PREVIOUS_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Credit memo invoice line identifier | ||
| CUSTOMER_TRX_ID | NUMBER | 18 | Transaction identifier | ||
| PREVIOUS_CUSTOMER_TRX_ID | NUMBER | 18 | Credit memo Identifier | ||
| REVENUE_AMOUNT | NUMBER | Transaction line revenue amount | |||
| EXTENDED_AMOUNT | NUMBER | Transaction line extended Amount | |||
| ACCTD_AMOUNT | NUMBER | Amount of this record in the functional currency | |||
| REVENUE_PERCENTAGE | NUMBER | Transaction line revenue percentage | |||
| INVOICE_SOURCE | VARCHAR2 | 30 | Invoice Source | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Identify Bill to Site | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Identify Bill to Customer | ||
| POSTED_FLAG | VARCHAR2 | 1 | Revenue Lines posted:Y,N | ||
| DOO_FULFILL_LINE_ID | NUMBER | 18 | DOO Fulfillment key identifier | ||
| DOO_REFERENCE_FULFILL_LINE_ID | NUMBER | 18 | DOO reference Fulfillment line identifier | ||
| DOO_ORDER_NUMBER | VARCHAR2 | 30 | DOO Order Number Details | ||
| DOO_ORDER_TYPE | VARCHAR2 | 30 | DOO order type | ||
| ROOT_PARENT_FULFILL_LINE_ID | NUMBER | 18 | Root parent fulfillment line identifier for model | ||
| PARENT_FULFILL_LINE_ID | NUMBER | 18 | Parent fulfillment line identifier for model | ||
| INVOICE_LINE_AMOUNT | NUMBER | Invoice line amount of this record in the Invoice currency | |||
| DOCUMENT_TYPE | VARCHAR2 | 20 | Accounts receivables document identifier - Invoice & Credit Memo | ||
| REFERENCE_LINE_ID | NUMBER | 18 | Reference line identifier | ||
| 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 | Stores the associated delivery / rma receipt transaction identifier based on the shipment and RMA receipt transaction. | ||
| TXN_PROCESSING_GROUP_ID | NUMBER | 18 | Identifies the Transaction processing group | ||
| DOO_FLINE_PRICE_ADJUSTMENT_ID | NUMBER | 18 | Stores value of discount Identifier for the item or manual price adjustment identifier | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Load request identifier used by file based data import process. | ||
| REVENUE_ACCOUNT | NUMBER | 18 | Sales representative related code combination identifier. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CST_PROJECT_REVENUE_LINES_N1 | Non Unique | FUSION_TS_TX_DATA | DOO_FULFILL_LINE_ID | |
| CST_PROJECT_REVENUE_LINES_PK | Unique | FUSION_TS_TX_DATA | PROJECT_REVENUE_LINE_ID | |
| CST_PROJECT_REVENUE_LINES_U1 | Unique | FUSION_TS_TX_DATA | PROJECT_REVENUE_LINE_ID, EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE | Obsolete |
| CST_PROJECT_REVENUE_LINES_U2 | Unique | FUSION_TS_TX_DATA | EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE, PROJECT_REVENUE_LINE_ID | Obsolete |
| CST_PROJECT_REVENUE_LINES_U3 | Unique | Default | EXTERNAL_SYSTEM_REF_ID, EXTERNAL_SYSTEM_REFERENCE |