OKC_CONTRACT_LINES_INT
Interface table for Contract Lines standard import.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
OKC_CONTRACT_LINES_INT_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Import Batch Id, every batch of data being imported should be assigned a batch id. | |
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Unique identifier for a record within a batch, source system should populate this. | |
| ERROR_MESSAGE | VARCHAR2 | 2000 | ERROR_MESSAGE | ||
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Status of row in the interface table, source system should leave this as null. | ||
| FILE_RECORD_NUM | NUMBER | 18 | Used by import utility to relate the record in interface table to the file row. | ||
| ACTION_CODE | VARCHAR2 | 30 | Code specifying the action for the import for e.g., INSERT, UPDATE or NULL. In the current release only INSERT is supported. | ||
| INTERNAL_ACTION_CODE | VARCHAR2 | 30 | Used internally by the bulk import ODI program. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
| 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. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | Save the individual sys task id for each input csv file | ||
| FUSION_CONTRACT_LINE_ID | NUMBER | 18 | FUSION_CONTRACT_LINE_ID | ||
| MAJOR_VERSION | NUMBER | 18 | MAJOR_VERSION | ||
| LINE_PUID | VARCHAR2 | 120 | Line Public UID | ||
| CONTRACT_PUID | VARCHAR2 | 120 | Parent Contract PUID | ||
| EXTERNAL_SOURCE | VARCHAR2 | 120 | User or External source | ||
| EXTERNAL_KEY | VARCHAR2 | 120 | User or External key | ||
| CHR_ID | NUMBER | 18 | Contract ID | ||
| DNZ_CHR_ID | NUMBER | 18 | Denorm Contract ID | ||
| ID | NUMBER | 18 | ID | ||
| LINE_ID | NUMBER | 18 | LINE_ID, PK column | ||
| LINE_TYPE_ID | NUMBER | 18 | Line Type ID | ||
| LINE_TYPE_NAME | VARCHAR2 | 150 | Line Type Name | ||
| INTERNAL_LINE_SOURCE_CODE | VARCHAR2 | 30 | Line source code | ||
| LINE_NUMBER | VARCHAR2 | 150 | Line Number | ||
| OBJECT1_ID1 | NUMBER | 18 | OBJECT1_ID1, item ID column | ||
| OBJECT1_ID2 | NUMBER | 18 | OBJECT1_ID2 | ||
| ITEM_ID | NUMBER | 18 | Internal column for ItemID | ||
| ITEM_NAME | VARCHAR2 | 1995 | Item Name | ||
| ITEM_DESCRIPTION | VARCHAR2 | 1995 | Item Description | ||
| COMMENTS | VARCHAR2 | 1995 | Line comments | ||
| COGNOMEN | VARCHAR2 | 300 | COGNOMEN | ||
| START_DATE | DATE | Line Start Date | |||
| END_DATE | DATE | Line End Date | |||
| STATUS_CODE | VARCHAR2 | 30 | Status Code | ||
| LINE_STATUS | VARCHAR2 | 30 | Line Status | ||
| LINE_AUTONUM | VARCHAR2 | 1 | Internal, LINE_AUTONUM | ||
| DISPLAY_SEQUENCE | NUMBER | 18 | Internal, DISPLAY_SEQUENCE | ||
| TRN_CODE | VARCHAR2 | 30 | Cancel/Close reason code | ||
| TRN_CODE_SET_ID | NUMBER | 18 | Cancel/Close reason set ID | ||
| TRN_SET_CODE | VARCHAR2 | 30 | Cancel/Close set code | ||
| CLOSE_DATE | DATE | Line close date | |||
| CLOSE_REASON_CODE | VARCHAR2 | 30 | Internal, CLOSE_REASON_CODE | ||
| CLOSE_REASON_MEANING | VARCHAR2 | 80 | CLOSE_REASON_MEANING | ||
| CLOSE_REASON_SET_ID | NUMBER | 18 | CLOSE_REASON_SET_ID | ||
| CLOSE_REASON_SET_CODE | VARCHAR2 | 30 | CLOSE_REASON_SET_CODE | ||
| CANCEL_DATE | DATE | Cancel date | |||
| CANCEL_REASON_CODE | VARCHAR2 | 30 | CANCEL_REASON_CODE | ||
| CANCEL_REASON_MEANING | VARCHAR2 | 80 | CANCEL_REASON_MEANING | ||
| CANCEL_REASON_SET_ID | NUMBER | 18 | CANCEL_REASON_SET_ID | ||
| CANCEL_REASON_SET_CODE | VARCHAR2 | 30 | CANCEL_REASON_SET_CODE | ||
| HOLD_UNTIL_DATE | DATE | HOLD_UNTIL_DATE | |||
| HOLD_REASON_CODE | VARCHAR2 | 30 | HOLD_REASON_CODE | ||
| HOLD_REASON_MEANING | VARCHAR2 | 80 | HOLD_REASON_MEANING | ||
| HOLD_REASON_SET_ID | NUMBER | 18 | HOLD_REASON_SET_ID | ||
| HOLD_REASON_SET_CODE | VARCHAR2 | 30 | HOLD_REASON_SET_CODE | ||
| SUPPLIER_ID | NUMBER | 18 | SUPPLIER_ID | ||
| SUPPLIER_NAME | VARCHAR2 | 360 | SUPPLIER_NAME | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | SUPPLIER_SITE_ID | ||
| SUPPLIER_SITE_NAME | VARCHAR2 | 240 | SUPPLIER_SITE_NAME | ||
| SHIP_INV_ORG_ID | NUMBER | 18 | SHIP_INV_ORG_ID | ||
| SHIP_INV_ORG_NAME | VARCHAR2 | 240 | SHIP_INV_ORG_NAME | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | SHIP_TO_LOCATION_ID | ||
| SHIP_TO_LOCATION_NAME | VARCHAR2 | 240 | SHIP_TO_LOCATION_NAME | ||
| RECV_INV_ORG_ID | NUMBER | 18 | RECV_INV_ORG_ID | ||
| RECV_INV_ORG_NAME | VARCHAR2 | 240 | RECV_INV_ORG_NAME | ||
| RECV_LOCATION_ID | NUMBER | 18 | RECV_LOCATION_ID | ||
| RECV_LOCATION_NAME | VARCHAR2 | 240 | RECV_LOCATION_NAME | ||
| PAYMENT_TERMS_ID | NUMBER | 18 | PAYMENT_TERMS_ID | ||
| PAYMENT_TERMS_NAME | VARCHAR2 | 50 | PAYMENT_TERMS_NAME | ||
| FOB_CODE | VARCHAR2 | 30 | FOB_CODE | ||
| FOB | VARCHAR2 | 80 | FOB | ||
| CARRIER_ID | NUMBER | 18 | CARRIER_ID | ||
| CARRIER_NAME | VARCHAR2 | 360 | CARRIER_NAME | ||
| FREIGHT_TERMS_CODE | VARCHAR2 | 30 | FREIGHT_TERMS_CODE | ||
| FREIGHT_TERMS | VARCHAR2 | 80 | FREIGHT_TERMS | ||
| UOM | VARCHAR2 | 25 | UOM | ||
| UOM_CODE | VARCHAR2 | 15 | UOM_CODE | ||
| PRICE_UNIT | NUMBER | PRICE_UNIT | |||
| LINE_QUANTITY | NUMBER | LINE_QUANTITY | |||
| LINE_AMOUNT | NUMBER | LINE_AMOUNT | |||
| PURCHASING_CATEGORY_NAME | VARCHAR2 | 250 | PURCHASING_CATEGORY_NAME | ||
| PURCHASING_CATEGORY_ID | NUMBER | 18 | PURCHASING_CATEGORY_ID | ||
| NEED_BY_DATE | DATE | NEED_BY_DATE | |||
| FIXED_PRICE_SERVICE_YN | VARCHAR2 | 1 | FIXED_PRICE_SERVICE_YN | ||
| AGREEMENT_UNIT_PRICE | NUMBER | AGREEMENT_UNIT_PRICE | |||
| AGREEMENT_PRICE_OVER_ALLWD_YN | VARCHAR2 | 1 | AGREEMENT_PRICE_OVER_ALLWD_YN | ||
| AGREEMENT_PRICE_LIMIT | NUMBER | AGREEMENT_PRICE_LIMIT | |||
| AGREEMENT_QTY_LIMIT | NUMBER | AGREEMENT_QTY_LIMIT | |||
| AGREEMENT_AMT_LIMIT | NUMBER | AGREEMENT_AMT_LIMIT | |||
| AGREED_QTY | NUMBER | AGREED_QTY | |||
| AGREED_AMT | NUMBER | AGREED_AMT | |||
| MIN_RELEASE_QTY | NUMBER | MIN_RELEASE_QTY | |||
| MIN_RELEASE_AMT | NUMBER | MIN_RELEASE_AMT | |||
| AT_RISK_YN | VARCHAR2 | 1 | AT_RISK_YN | ||
| PERCENT_COMPLETE | NUMBER | 5 | PERCENT_COMPLETE | ||
| SHIP_TO_ACCT_ID | NUMBER | 18 | SHIP_TO_ACCT_ID | ||
| SHIP_TO_ACCT_NUMBER | VARCHAR2 | 30 | SHIP_TO_ACCT_NUMBER | ||
| SHIP_TO_SITE_USE_ID | NUMBER | 18 | SHIP_TO_SITE_USE_ID | ||
| SHIP_TO_SITE_USE_LOCATION | VARCHAR2 | 150 | SHIP_TO_SITE_USE_LOCATION | ||
| WAREHOUSE_ID | NUMBER | 18 | WAREHOUSE_ID | ||
| WAREHOUSE_NAME | VARCHAR2 | 240 | WAREHOUSE_NAME | ||
| BILL_PLAN_ID | NUMBER | 18 | BILL_PLAN_ID | ||
| BILL_PLAN_EXT_SOURCE | VARCHAR2 | 120 | BILL_PLAN_EXT_SOURCE | ||
| BILL_PLAN_EXT_KEY | VARCHAR2 | 120 | BILL_PLAN_EXT_KEY | ||
| REVENUE_PLAN_ID | NUMBER | 18 | REVENUE_PLAN_ID | ||
| REVENUE_PLAN_EXT_SOURCE | VARCHAR2 | 120 | REVENUE_PLAN_EXT_SOURCE | ||
| REVENUE_PLAN_EXT_KEY | VARCHAR2 | 120 | REVENUE_PLAN_EXT_KEY | ||
| CUST_PO_NUMBER | VARCHAR2 | 50 | CUST_PO_NUMBER | ||
| OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 50 | OUTPUT_TAX_CLASSIFICATION_CODE | ||
| OUTPUT_TAX_CLASSIFICATION | VARCHAR2 | 80 | OUTPUT_TAX_CLASSIFICATION | ||
| TAX_EXEMPTION_CONTROL_CODE | VARCHAR2 | 30 | TAX_EXEMPTION_CONTROL_CODE | ||
| TAX_EXEMPTION_CONTROL | VARCHAR2 | 80 | TAX_EXEMPTION_CONTROL | ||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | 80 | EXEMPT_CERTIFICATE_NUMBER | ||
| EXEMPT_REASON_CODE | VARCHAR2 | 30 | EXEMPT_REASON_CODE | ||
| EXEMPT_REASON | VARCHAR2 | 80 | EXEMPT_REASON | ||
| INTERNAL_LINES_OVN | NUMBER | 9 | INTERNAL_LINES_OVN | ||
| SOURCE_SYSTEM_ATTRIBUTES | CLOB | SOURCE_SYSTEM_ATTRIBUTES | |||
| BILL_TO_ACCT_ID | NUMBER | 18 | BILL_TO_ACCT_ID | ||
| BILL_TO_ACCT_NUMBER | VARCHAR2 | 30 | BILL_TO_ACCT_NUMBER | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | BILL_TO_SITE_USE_ID | ||
| BILL_TO_SITE_USE_LOCATION | VARCHAR2 | 150 | BILL_TO_SITE_USE_LOCATION | ||
| PRICE_LIST_ID | NUMBER | 18 | PRICE_LIST_ID | ||
| PRICE_LIST_NAME | VARCHAR2 | 150 | PRICE_LIST_NAME | ||
| COMMIT_LEVEL | VARCHAR2 | 80 | COMMIT_LEVEL | ||
| COMMIT_LEVEL_CODE | VARCHAR2 | 30 | COMMIT_LEVEL_CODE | ||
| ALLOW_PRICELIST_OVERRIDE_YN | VARCHAR2 | 1 | ALLOW_PRICELIST_OVERRIDE_YN | ||
| TAX_AMOUNT | NUMBER | TAX_AMOUNT | |||
| DATE_RENEWED | DATE | DATE_RENEWED | |||
| RENEWED_FROM_LINE_PUID | VARCHAR2 | 120 | RENEWED_FROM_LINE_PUID | ||
| RENEWAL_TYPE | VARCHAR2 | 30 | RENEWAL_TYPE | ||
| RENEWAL_TYPE_NAME | VARCHAR2 | 80 | RENEWAL_TYPE_NAME | ||
| EST_VAR_CONSIDERATION_AMT | NUMBER | EST_VAR_CONSIDERATION_AMT | |||
| STANDALONE_SELLING_PRICE | NUMBER | STANDALONE_SELLING_PRICE | |||
| ADJUSTMENT_AMOUNT | NUMBER | ADJUSTMENT_AMOUNT | |||
| ADJUSTMENT_BASIS_CODE | VARCHAR2 | 30 | ADJUSTMENT_BASIS_CODE | ||
| ADJUSTMENT_BASIS_ID | NUMBER | ADJUSTMENT_BASIS_ID | |||
| ADJUSTMENT_TYPE | VARCHAR2 | 80 | ADJUSTMENT_TYPE | ||
| ADJUSTMENT_TYPE_CODE | VARCHAR2 | 30 | ADJUSTMENT_TYPE_CODE | ||
| ALLOW_CUSTOM_ADJUSTMENTS_FLAG | VARCHAR2 | 1 | ALLOW_CUSTOM_ADJUSTMENTS_FLAG | ||
| ALLOW_PROMOTIONS_YN | VARCHAR2 | 1 | ALLOW_PROMOTIONS_YN | ||
| AUTO_APPLY_STRTGY_PRICE_ADJ | VARCHAR2 | 1 | AUTO_APPLY_STRTGY_PRICE_ADJ | ||
| BILL_PLAN | VARCHAR2 | 250 | BILL_PLAN | ||
| REVENUE_PLAN | VARCHAR2 | 250 | REVENUE_PLAN | ||
| LINE_VALUE_AMOUNT | NUMBER | LINE_VALUE_AMOUNT | |||
| ORIG_SYSTEM_REFERENCE1 | VARCHAR2 | 30 | ORIG_SYSTEM_REFERENCE1 | ||
| ORIG_SYSTEM_SOURCE_CODE | VARCHAR2 | 30 | ORIG_SYSTEM_SOURCE_CODE | ||
| PRICE_APPLICATION_RULE | VARCHAR2 | 30 | PRICE_APPLICATION_RULE | ||
| PRICE_BOOK | VARCHAR2 | 255 | PRICE_BOOK | ||
| PRICE_BOOK_ID | NUMBER | PRICE_BOOK_ID | |||
| SHIP_TO_ACCOUNT | VARCHAR2 | 255 | SHIP_TO_ACCOUNT | ||
| VENDOR_SITE_ID | NUMBER | VENDOR_SITE_ID | |||
| ITEM_NAME_TXT | VARCHAR2 | 200 | ITEM_NAME_TXT | ||
| INTERNAL_LINE_CLASS | VARCHAR2 | 30 | Used internally to store Contract Line Class. | ||
| LIST_PRICE | NUMBER | LIST_PRICE | |||
| SOURCE_DOC_SYSTEM_CODE | VARCHAR2 | 30 | SOURCE_DOC_SYSTEM_CODE | ||
| SOURCE_DOC_ID | NUMBER | 18 | SOURCE_DOC_ID | ||
| SOURCE_DOC_LINE_ID | NUMBER | 18 | SOURCE_DOC_LINE_ID | ||
| LAST_REVENUE_RECOG_DATE | DATE | LAST_REVENUE_RECOG_DATE | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 500 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| INTERNAL_OLD_STATUS_CODE | VARCHAR2 | 30 | INTERNAL_OLD_STATUS_CODE | ||
| SHIP_TO_PARTY_ID | NUMBER | 18 | SHIP_TO_PARTY_ID | ||
| SHIP_TO_PARTY_NAME | VARCHAR2 | 240 | SHIP_TO_PARTY_NAME | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | SHIP_TO_PARTY_SITE_ID | ||
| SHIP_TO_PARTY_SITE_NUMBER | VARCHAR2 | 30 | SHIP_TO_PARTY_SITE_NUMBER | ||
| PRICE_UOM_CODE | VARCHAR2 | 30 | PRICE_UOM_CODE | ||
| PRICE_UOM | VARCHAR2 | 80 | PRICE_UOM | ||
| ACCT_RULE_ID | NUMBER | 18 | ACCT_RULE_ID | ||
| ACCT_RULE_NAME | VARCHAR2 | 240 | ACCT_RULE_NAME | ||
| INVOICE_RULE_ID | NUMBER | 18 | INVOICE_RULE_ID | ||
| INVOICE_RULE | VARCHAR2 | 240 | INVOICE_RULE | ||
| BILLING_FREQ | VARCHAR2 | 30 | BILLING_FREQ | ||
| INVOICE_TEXT | VARCHAR2 | 2000 | INVOICE_TEXT | ||
| ORDER_NUMBER | VARCHAR2 | 120 | ORDER_NUMBER | ||
| ORDER_LINE_NUMBER | VARCHAR2 | 120 | ORDER_LINE_NUMBER | ||
| ORDER_ID | NUMBER | 18 | ORDER_ID | ||
| ORDER_LINE_ID | NUMBER | 18 | ORDER_LINE_ID | ||
| ORDER_SOURCE | VARCHAR2 | 30 | ORDER_SOURCE | ||
| ORDER_SOURCE_NAME | VARCHAR2 | 80 | ORDER_SOURCE_NAME | ||
| LINE_VALUE | NUMBER | LINE_VALUE | |||
| INVOICED_AMOUNT | NUMBER | INVOICED_AMOUNT | |||
| CREDITED_AMOUNT | NUMBER | CREDITED_AMOUNT | |||
| CANCELLED_AMOUNT | NUMBER | CANCELLED_AMOUNT | |||
| TERMINATED_AMOUNT | NUMBER | TERMINATED_AMOUNT | |||
| RETURN_CREDIT_METHOD | VARCHAR2 | 80 | RETURN_CREDIT_METHOD | ||
| RETURN_CREDITED_METHOD_CODE | VARCHAR2 | 30 | RETURN_CREDITED_METHOD_CODE | ||
| RECURRING_AMOUNT | NUMBER | RECURRING_AMOUNT | |||
| ONETIME_AMOUNT | NUMBER | ONETIME_AMOUNT | |||
| SUPPRESSED_CREDIT_AMOUNT | NUMBER | SUPPRESSED_CREDIT_AMOUNT | |||
| COVERAGE_SCHEDULE_ID | NUMBER | 18 | COVERAGE_SCHEDULE_ID | ||
| COVERAGE_SCHEDULE_NAME | VARCHAR2 | 150 | COVERAGE_SCHEDULE_NAME | ||
| BILLING_DATE_METHOD | VARCHAR2 | 80 | BILLING_DATE_METHOD | ||
| BILLING_DATE_METHOD_CODE | VARCHAR2 | 30 | BILLING_DATE_METHOD_CODE | ||
| BILL_DAY | NUMBER | 9 | BILL_DAY | ||
| BILL_OFFSET_DAYS | NUMBER | 9 | BILL_OFFSET_DAYS | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | PAYMENT_METHOD_CODE | ||
| PAYMENT_METHOD | VARCHAR2 | 80 | PAYMENT_METHOD | ||
| PRICE_DURING_BILLING_YN | VARCHAR2 | 1 | PRICE_DURING_BILLING_YN | ||
| USG_BILLED_AMOUNT | NUMBER | USG_BILLED_AMOUNT | |||
| USG_CREDITED_AMOUNT | NUMBER | USG_CREDITED_AMOUNT | |||
| USG_SUPPRESSED_CREDIT_AMT | NUMBER | USG_SUPPRESSED_CREDIT_AMT | |||
| PO_NUMBER | VARCHAR2 | 30 | PO_NUMBER | ||
| WIRE_NUMBER | VARCHAR2 | 30 | WIRE_NUMBER | ||
| LANG | VARCHAR2 | 4 | Language column | ||
| SRC_LANG | VARCHAR2 | 4 | Source language |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_CONTRACT_LINES_INT_N1 | Non Unique | Default | BATCH_ID, IMPORT_STATUS_CODE, INTERNAL_ACTION_CODE, INTERFACE_ROW_ID |
| OKC_CONTRACT_LINES_INT_N2 | Non Unique | Default | BATCH_ID, LINE_PUID, IMPORT_STATUS_CODE, STATUS_CODE |
| OKC_CONTRACT_LINES_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |