OKC_STI_DEFAULTS_H_INT
Contracts Service Transaction Defaults Interface History Table
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
OKC_STI_DEFAULTS_H_INT_PK |
ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 18 | Yes | Id | |
| TXN_ID | NUMBER | 18 | Transaction Id | ||
| TSL_ID | NUMBER | 18 | TSL Id | ||
| TAL_ID | NUMBER | 18 | TAL Id | ||
| DFT_BU_ID | NUMBER | 18 | Default Business Unit Id | ||
| DFT_CONTRACT_TYPE_ID | NUMBER | 18 | Default Contract Type Id | ||
| DFT_ITEM_ORGANIZATION_ID | NUMBER | 18 | Default Item Organization Id | ||
| DFT_K_BUYER_ROLE_CODE | VARCHAR2 | 30 | Default Buyer Roie Code | ||
| DFT_K_SELLER_ROLE_CODE | VARCHAR2 | 30 | Default Seller Role Code | ||
| DFT_K_OWNER_ROLE_CODE | VARCHAR2 | 30 | Default Contract Owner Role Code | ||
| DFT_K_OWNER_ID | NUMBER | 18 | Default Owner Role Id | ||
| DFT_LINE_TYPE_ID | NUMBER | 18 | Default Line Type Id | ||
| DFT_WARRANTY_REL_TYPE_CODE | VARCHAR2 | 30 | Warranty Relation Type Code | ||
| DFT_AUTO_K_LINE_NUM_ENABLED | VARCHAR2 | 10 | Contract Auto Line Number Enabled Flag | ||
| DFT_AUTO_K_NUM_METHOD_CODE | VARCHAR2 | 30 | Contract Auto number method Code | ||
| DFT_AUTO_K_NUM_SEQ_CAT_CODE | VARCHAR2 | 30 | Contract Auto Number Sequence Category | ||
| DFT_AUTO_K_NUM_LEVEL_CODE | VARCHAR2 | 30 | Contract Auto Number Level Code | ||
| DFT_AUTO_K_NUM_LEVEL_ID | NUMBER | 18 | Contract Auto Number Level Id | ||
| DFT_CLOSE_REASON_CODE | VARCHAR2 | 30 | Default Close Reason Code | ||
| DFT_CANCEL_REASON_CODE | VARCHAR2 | 30 | Default Cancel Reason Code | ||
| DFT_RECORD_ID | NUMBER | 18 | Default Record Id | ||
| DFT_ATTRIBUTE_GROUP_CODE | VARCHAR2 | 30 | Default Attribute Group Code | ||
| DFT_LEVEL_CODE | VARCHAR2 | 30 | Default Level Code | ||
| DFT_LEVEL_ID | NUMBER | 18 | Default Level Id | ||
| TXN_REPAIR_FLAG | VARCHAR2 | 10 | Transaction Repair Flag | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Program Name | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Program Application Name | ||
| DFT_TERMN_CREDIT_METHOD_CODE | VARCHAR2 | 30 | Default Termination Credit Method Code | ||
| DFT_RETERMN_CR_METHOD_CODE | VARCHAR2 | 30 | Default Retermination Credit Method Code | ||
| DFT_ASSET_TXN_HOLD | VARCHAR2 | 1 | Default Asset Transaction Hold | ||
| DFT_WARRANTY_TRANSFER_OPTION | VARCHAR2 | 30 | Default Warranty Transfer Option | ||
| DFT_COVERAGE_TRANSFER_OPTION | VARCHAR2 | 30 | Default Coverage Transfer Option | ||
| TCL_ID | NUMBER | 18 | Transaction Contract Line Id | ||
| CAL_STS_CODE | VARCHAR2 | 30 | Asset Line Status Code | ||
| CAL_START_DATE | DATE | Asset Line Start Date | |||
| CAL_END_DATE | DATE | Asset Line End Date | |||
| CAL_TRN_DATE | DATE | Asset Line Transaction Date | |||
| CAL_CANCEL_DATE | DATE | Asset Line Cancel Date | |||
| CAL_TRN_CODE | VARCHAR2 | 30 | Asset Line Transaction Code | ||
| CAL_TRN_CODE_SET_ID | NUMBER | 18 | Asset Line Transaction Code SetId | ||
| CAL_ASSET_TXN_EVENT_CODE | VARCHAR2 | 30 | Asset Line Transaction Event Code | ||
| CAL_TRN_CREDIT_METHOD_CODE | VARCHAR2 | 30 | Asset Line Transaction Credit Method Code | ||
| CHR_NUMBER | VARCHAR2 | 120 | Contract Header Number | ||
| CHR_NUMBER_MODIFIER | VARCHAR2 | 120 | Contract Header Modifier | ||
| CLE_LINE_NUMBER | VARCHAR2 | 150 | Contract Line Number | ||
| CLE_OBJECT_CODE | VARCHAR2 | 30 | Contract Line Object Code | ||
| CAL_LINE_NUMBER | VARCHAR2 | 150 | Asset Line Number | ||
| CHR_BU_ID | NUMBER | 18 | Contract Header Business Unit | ||
| DFT_PARTIAL_PERIOD_START_CODE | VARCHAR2 | 30 | Default Partial Period Start Code | ||
| DFT_PARTIAL_PERIOD_TYPE_CODE | VARCHAR2 | 30 | Default Partial Period Type Code | ||
| DFT_ACCT_RULE_ID | NUMBER | 18 | Default Account Rule Id | ||
| DFT_INV_RULE_ID | NUMBER | 18 | Default Invoice Rule Id | ||
| DFT_PAYMENT_TERM_ID | NUMBER | 18 | Default Payment Term Id | ||
| DFT_BILLING_FREQ_CODE | VARCHAR2 | 30 | Default Billing Frequency Code | ||
| DFT_BILL_SERVICES_CODE | VARCHAR2 | 30 | Default Bill Services Code | ||
| CHR_ID | NUMBER | 18 | Contract Id | ||
| CLE_ID | NUMBER | 18 | Contract Line Id | ||
| CAL_ID | NUMBER | 18 | Covered Asset Line Id | ||
| CAL_ASSET_TXN_ACTION_CODE | VARCHAR2 | 30 | Asset transaction action code | ||
| DFT_BILL_TO_ACCOUNT_ID | NUMBER | 18 | Bill to accoun Id | ||
| DFT_BILL_TO_ACCOUNT_SITE_ID | NUMBER | 18 | bill to account site id | ||
| DFT_BILL_TO_ACT_SITE_USE_ID | NUMBER | 18 | bill to account site use id | ||
| DFT_SHIP_TO_PARTY_ID | NUMBER | 18 | Ship to party id | ||
| DFT_SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | Ship to party site id | ||
| DFT_PNB_RECORD_ID | NUMBER | 18 | Pricing and billing defaults record id | ||
| DFT_PNB_ATTRIBUTE_GROUP_CODE | VARCHAR2 | 30 | PNB Attribute group code | ||
| DFT_PNB_LEVEL_CODE | VARCHAR2 | 30 | PNB level code | ||
| DFT_PNB_LEVEL_ID | NUMBER | 18 | PNB Level Id | ||
| DFT_WARRANTY_UPG_COVRGE_OPTION | VARCHAR2 | 30 | Warranty upgrade coverage option | ||
| DFT_WARRANTY_UPG_PERIOD_OPTION | VARCHAR2 | 30 | Warranty upgrade coverage period option | ||
| DFT_COVERAGE_UPG_PRICE_OPTION | VARCHAR2 | 30 | Asset upgrade coverage pricing option |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_STI_DEFAULTS_H_INT_N1 | Non Unique | FUSION_TS_INTERFACE | TXN_ID |
| OKC_STI_DEFAULTS_H_INT_U1 | Unique | FUSION_TS_INTERFACE | ID |