OSS_ASSET_TRANSACTION_LINES
Table for asset transaction lines
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_ASSET_TXN_LINES_PK |
TRANSACTION_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_LINE_ID | NUMBER | 18 | Yes | Primary key for asset transaction lines. | |
| TRANSACTION_LINE_NUMBER | VARCHAR2 | 120 | Yes | Alternate key for asset transaction lines. | |
| TRANSACTION_LINE_SEQUENCE | NUMBER | 18 | Transaction line sequence | ||
| TRANSACTION_ID | NUMBER | 18 | Yes | Foreign key to asset transactions. | |
| TRANSACTION_LINE_STATUS | VARCHAR2 | 30 | Status of the asset transaction line. | ||
| TRANSACTION_LINE_ACTION | VARCHAR2 | 30 | Asset transaction line action | ||
| SALES_PRODUCT_TYPE | VARCHAR2 | 30 | Sales product type of the coverage | ||
| FULFILLMENT_LINE_ID | NUMBER | 18 | Identifier of asset fulfillment line. | ||
| PARENT_TRANSACTION_LINE_ID | NUMBER | 18 | Parent asset transaction identifier. | ||
| HOLD_PROCESSING | VARCHAR2 | 30 | Default hold processing flag for asset transactions. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Business unit identifier for included warranty creation. | ||
| SUBSCRIPTION_PROFILE_ID | NUMBER | 18 | Subscription profile identifier. | ||
| CLOSE_REASON | VARCHAR2 | 30 | Close reason to be used incase of asset expiration. | ||
| CANCEL_REASON | VARCHAR2 | 30 | Cancellation reason to be used incase of asset expiration. | ||
| CLOSE_CREDIT_METHOD | VARCHAR2 | 30 | Close credit method to be used incase of asset expiration. | ||
| TRANSFER_OPTION | VARCHAR2 | 30 | Transfer option to be used incase of asset transfer. | ||
| WARRANTY_UPGRADE_OPTION | VARCHAR2 | 30 | Warranty upgrade option to be used incase of asset upgrade. | ||
| COVERAGE_UPGRADE_OPTION | VARCHAR2 | 30 | Coverage upgrade option to be used incase of asset upgrade. | ||
| COVERED_ASSET_CUD | VARCHAR2 | 3 | Covered asset create, update, delete flag | ||
| PRODUCT_ASSOCIATION_ID | NUMBER | 18 | Foreign key to product association. | ||
| SUBSCRIPTION_PRODUCT_ID | NUMBER | 18 | Foreign key to subscription products. | ||
| SUBSCRIPTION_ID | NUMBER | 18 | Foreign key to subscriptions. | ||
| SUBSCRIPTION_START_DATE | DATE | Subscription start date. | |||
| SUBSCRIPTION_END_DATE | DATE | Subscription end date. | |||
| PRODUCT_ITEM_ID | NUMBER | 18 | Identifier of the product inventory item. | ||
| PRODUCT_ORGANIZATION_ID | NUMBER | 18 | Identifier of the inventory organization where product Item is defined. | ||
| PRODUCT_COVERAGE_SCHEDULE_ID | NUMBER | 18 | Product coverage schedule identifier. | ||
| PRODUCT_START_DATE | DATE | Product start date. | |||
| PRODUCT_END_DATE | DATE | Product end date. | |||
| PRODUCT_LINE_NUMBER | VARCHAR2 | 300 | Line number of the product | ||
| PRODUCT_QUANTITY | NUMBER | Coverage product quantity. | |||
| PRODUCT_UOM | VARCHAR2 | 3 | Unit of measure of the coverage product. | ||
| COVERED_LEVEL_LINE_NUMBER | VARCHAR2 | 300 | Line number of the covered level | ||
| ASSET_ID | NUMBER | 18 | Identifier of the customer asset | ||
| QUANTITY | NUMBER | Customer asset quantity. | |||
| UOM | VARCHAR2 | 3 | Unit of measure of the customer asset. | ||
| ASSET_ITEM_ID | NUMBER | 18 | Identifier of the asset inventory item. | ||
| START_DATE | DATE | Product association start date. | |||
| END_DATE | DATE | Product association end date. | |||
| CLOSED_DATE | DATE | Closed date. | |||
| CANCELED_DATE | DATE | Cancelled date. | |||
| REINSTATEMENT_DATE | DATE | Reinstatement date. | |||
| SPLIT_DATE | DATE | Split date | |||
| REPLACEMENT_DATE | DATE | Replacement date. | |||
| PRORATE_FRACTION | NUMBER | Amount prorate fraction. | |||
| MERGE_SUBSCRIPTION_KEY | NUMBER | 18 | Key used for merging covered asset to a subscription | ||
| MERGE_PRODUCT_KEY | NUMBER | 18 | Key used for merging covered asset to a product | ||
| CUSTOMER_ID | NUMBER | 18 | Identifier of the customer. | ||
| BILL_TO_ACCT_ID | NUMBER | 18 | Bill-to account identifier. | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Bill-to site use identifier. | ||
| SHIP_TO_PARTY_ID | NUMBER | 18 | Ship-to party identifier. | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | Ship-to-party-site identifier. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code | ||
| AMOUNT | NUMBER | Amount | |||
| TAX_AMOUNT | NUMBER | Tax amount | |||
| TOTAL_AMOUNT | NUMBER | Total amount | |||
| INVOICED_AMOUNT | NUMBER | Invoiced amount | |||
| CANCELED_AMOUNT | NUMBER | Canceled amount | |||
| CLOSED_AMOUNT | NUMBER | Closed amount | |||
| SUPPRESSED_CREDIT_AMOUNT | NUMBER | Suppressed credit amount | |||
| CREDITED_AMOUNT | NUMBER | Credited amount | |||
| PRIOR_SUBSCRIPTION_START_DATE | DATE | Prior subscription start date. | |||
| PRIOR_SUBSCRIPTION_END_DATE | DATE | Prior subscription end date. | |||
| PRIOR_PRODUCT_START_DATE | DATE | Prior product start date. | |||
| PRIOR_PRODUCT_END_DATE | DATE | Prior product end date. | |||
| PRIOR_ASSET_ID | NUMBER | 18 | Identifier of the prior customer asset. | ||
| PRIOR_QUANTITY | NUMBER | Prior covered asset quantity. | |||
| PRIOR_UOM | VARCHAR2 | 3 | Prior unit of measure of the covered asset. | ||
| PRIOR_ASSET_ITEM_ID | NUMBER | 18 | Identifier of the prior customer asset item | ||
| PRIOR_CLOSED_DATE | DATE | Prior closed date. | |||
| PRIOR_CLOSE_REASON | VARCHAR2 | 30 | Prior close reason. | ||
| PRIOR_AMOUNT | NUMBER | Prior amount | |||
| PRIOR_TAX_AMOUNT | NUMBER | Prior tax amount | |||
| PRIOR_TOTAL_AMOUNT | NUMBER | Prior total amount | |||
| PRIOR_INVOICED_AMOUNT | NUMBER | Prior invoiced amount | |||
| PRIOR_CANCELED_AMOUNT | NUMBER | Prior canceled amount | |||
| PRIOR_CLOSED_AMOUNT | NUMBER | Prior closed amount | |||
| PRIOR_SUPPRESS_CREDIT_AMOUNT | NUMBER | Prior suppressed credit amount | |||
| PRIOR_CREDITED_AMOUNT | NUMBER | Prior credited amount | |||
| MERGE_SUBSCRIPTION_COUNT | NUMBER | Field used to capture merge subscription count for reprocess asset ess job | |||
| MERGE_PRODUCT_COUNT | NUMBER | Field used to capture merge product count for reprocess asset ess job | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OSS_ASSET_TXN_LINES_N1 | Non Unique | Default | TRANSACTION_ID |
| OSS_ASSET_TXN_LINES_N2 | Non Unique | Default | MERGE_PRODUCT_KEY |
| OSS_ASSET_TXN_LINES_N3 | Non Unique | Default | MERGE_SUBSCRIPTION_KEY |
| OSS_ASSET_TXN_LINES_N4 | Non Unique | Default | BILL_TO_ACCT_ID |
| OSS_ASSET_TXN_LINES_N5 | Non Unique | Default | BILL_TO_SITE_USE_ID |
| OSS_ASSET_TXN_LINES_N6 | Non Unique | Default | CUSTOMER_ID |
| OSS_ASSET_TXN_LINES_N7 | Non Unique | Default | SHIP_TO_PARTY_ID |
| OSS_ASSET_TXN_LINES_N8 | Non Unique | Default | SHIP_TO_PARTY_SITE_ID |
| OSS_ASSET_TXN_LINES_U1 | Unique | Default | TRANSACTION_LINE_ID |
| OSS_ASSET_TXN_LINES_U2 | Unique | Default | TRANSACTION_LINE_NUMBER |