1. Tables and Views for Sales, Fusion Service, and Field Service
  2. OKC_IMP_CONTRACT_LINES

OKC_IMP_CONTRACT_LINES

Interface table for importing Contract Lines

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

OKC_IMP_CONTRACT_LINES_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments Status
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.
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.
LANGUAGE VARCHAR2 4 Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG_FLAG VARCHAR2 1 If Y, this record will be used to populate the _B table. It will also be used to create rows in _TL table forlanguages that are enabled, but have no data in the interface table. If Null, this record will used to populate data in the _TL table for translatable attributes
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.
FUSION_CONTRACT_LINE_ID NUMBER 18 For successfully imported ContractLines, stores the Fusion Contract Line Id. This is intended to support reimport.
MAJOR_VERSION NUMBER 18 Identifies the contract major version.
EXT_SOURCE VARCHAR2 120 User or External key, to enable updates or deletes via bulk import or web services, if fusion primary key is not known.
EXT_KEY VARCHAR2 120 See EXT_SOURCE
CHR_ID NUMBER 18 ID of the contract to which this line belongs. The field will have a value only for parent lines. Refers to ID in OKC_K_HEADERS_B.
CLE_ID NUMBER 18 Fusion Contract Line Id which is the parent of this line. If a line is being created and its parent is another contract line, the parent line???s Fusion key or External must be passed.
DNZ_CHR_ID NUMBER 18 Contract ID. Denormalized for performance.
HDR_EXT_SOURCE VARCHAR2 120 External key of the contract to which the line belongs. If a line is being created either the contract???s Fusion key or External key must be passed.
HDR_EXT_KEY VARCHAR2 120 See HDR_EXT_SOURCE
LINE_EXT_SOURCE VARCHAR2 120 External key of the parent line. If a line is being created and its parent is another contract line, the parent line???s Fusion key or External must be passed.
LINE_EXT_KEY VARCHAR2 120 See LINE_EXT_SOURCE
NEW_CLE_ID NUMBER 18 Used for re-parenting lines.
NEW_LINE_EXT_SOURCE VARCHAR2 120 External key of the parent line. If a line is being created and its parent is another contract line, the parent line???s Fusion key or External must be passed.
NEW_LINE_EXT_KEY VARCHAR2 120 See LINE_EXT_SOURCE
LINE_NUMBER VARCHAR2 150 Sequential line number.
LINE_SOURCE_CODE VARCHAR2 30 Identifies the type of line.
ITEM_ID NUMBER 18 Item id of the line item.
ITEM_NAME VARCHAR2 1995 Item name of the line item.
ITEM_DESCRIPTION VARCHAR2 1995 Item description of the line item.
COMMENTS VARCHAR2 1995 Identifies the type of line.
START_DATE DATE The beginning of the active period, one second after midnight on the date indicated.
END_DATE DATE The end of the active period, one second before midnight on the date indicated.
STATUS_CODE VARCHAR2 30 Unique identifier of status code. Refers to status OKC_STATUSES_B.
CLOSE_DATE DATE Identifies the type of line.
CLOSE_REASON_CODE VARCHAR2 30 Identifies the type of line.
LINE_AUTONUM VARCHAR2 1 Internal ODI column to keep track of auto-numbering
DISPLAY_SEQUENCE NUMBER 18 Internal ODI column to keep track of display sequence
IS_CIRCULAR VARCHAR2 1 Internal ODI column to keep track of circular lines
EXTERNAL_ITEM_SOURCE VARCHAR2 120 Item external source system
EXTERNAL_ITEM_KEY VARCHAR2 120 Item key in external system
EXTERNAL_ITEM_REFERENCE1 VARCHAR2 120 Reference field to capture reference attributes for externally sourced items.
EXTERNAL_ITEM_REFERENCE2 VARCHAR2 120 Reference field to capture reference attributes for externally sourced items.
EXTERNAL_ITEM_REFERENCE3 VARCHAR2 120 Reference field to capture reference attributes for externally sourced items.
EXTERNAL_ITEM_REFERENCE4 VARCHAR2 120 Reference field to capture reference attributes for externally sourced items.
EXTERNAL_ITEM_REFERENCE5 VARCHAR2 120 Reference field to capture reference attributes for externally sourced items.
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.
FILE_NAME_SYSTASK_ID NUMBER 18 Save the individual sys task id for each input csv file
SUPPLIER_ID NUMBER 18 Supplier ID for Buy Intent contracts.
SUPPLIER_NAME VARCHAR2 360 Supplier Name for Buy Intent contracts.
SUPPLIER_SITE_ID NUMBER 18 Supplier Site ID for Buy Intent contracts.
SUPPLIER_SITE_NAME VARCHAR2 240 Supplier Site Name for Buy Intent contracts. Defaulted to project lines.
SHIP_TO_ORG_ID NUMBER 18 Receiving Inventory Organization ID for Buy Intent contracts.
SHIP_TO_ORG_NAME VARCHAR2 240 Receiving Inventory Organization Name for Buy Intent contracts.
SHIP_TO_LOCATION_ID NUMBER 18 HR location ID associated with the Ship-to Organization.
SHIP_TO_LOCATION_NAME VARCHAR2 240 HR location associated with the Ship-to Organization.
PAYMENT_TERMS_ID NUMBER 18 Payment term ID for a buy intent contract.
PAYMENT_TERMS_NAME VARCHAR2 50 Payment term for a buy intent contract.
FOB_CODE VARCHAR2 30 Valid only for a contract with buy intent. Determines the point of transfer of ownership CODE.
FOB VARCHAR2 80 Valid only for a contract with buy intent. Determines the point of transfer of ownership.
CARRIER_ID NUMBER 18 Carrier Id
CARRIER_NAME VARCHAR2 360 Carrier Name
FREIGHT_TERMS_CODE VARCHAR2 30 Valid only for a contract with buy intent. Determines the freight terms CODE for the contract.
FREIGHT_TERMS VARCHAR2 80 Valid only for a contract with buy intent. Determines the freight terms for the
UOM VARCHAR2 25 Unit of measure YR(Year) or Ea(Each).
UOM_CODE VARCHAR2 15 Unit of measure Code.
PRICE_UNIT NUMBER Price per unit.
LINE_QUANTITY NUMBER Number of line items.
LINE_AMOUNT NUMBER Usually roll up of sublines if any sub lines are present Line Type id determine whether it can be directly updated by the user.
LINE_NAME VARCHAR2 1995 Free form text attribute for line
LINE_DESCRIPTION VARCHAR2 1995 Free form text attribute for line description.
PURCHASING_CATEGORY_NAME VARCHAR2 250 Purchasing Category Name
PURCHASING_CATEGORY_ID NUMBER 18 Purchasing Category ID
NEED_BY_DATE DATE Need by date.
CLOSE_REASON_SET_ID NUMBER 18 Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.
CLOSE_REASON_SET_CODE VARCHAR2 30 SET_CODE
FIXED_PRICE_SERVICE_YN VARCHAR2 1 Agreement - Fixed Price Service
AGREEMENT_UNIT_PRICE NUMBER Agreement - Unit Price
AGREEMENT_PRICE_OVER_ALLWD_YN VARCHAR2 1 Agreement - Allow Price Override
AGREEMENT_PRICE_LIMIT NUMBER Agreement - Price Limit
AGREEMENT_QTY_LIMIT NUMBER Agreement - Quantity Limit
AGREEMENT_AMT_LIMIT NUMBER Agreement - Amount Limit
AGREED_QTY NUMBER Agreement - Quantity
AGREED_AMT NUMBER Agreement - Amount
MIN_RELEASE_QTY NUMBER Agreement - Minimum Release Quantity
MIN_RELEASE_AMT NUMBER Agreement - Minimum Release Amount
AT_RISK_YN VARCHAR2 1 At Risk indicator
PERCENT_COMPLETE NUMBER 5 PERCENT_COMPLETE
SHIP_TO_ACCT_ID NUMBER 18 Ship to Account (Customer Account) for Sell Intent contracts. Defaulted to lines.
SHIP_TO_ACCT_NUMBER VARCHAR2 30 Ship to Account (Customer Account) for Sell Intent contracts. Defaulted to lines.
SHIP_TO_SITE_USE_ID NUMBER 18 Ship to Site (Customer Account Site Use) for Sell Intent contracts. Defaulted to lines.
SHIP_TO_SITE_USE_LOCATION VARCHAR2 150 Ship to Site (Customer Account Site Use) for Sell Intent contracts. Defaulted to lines.
WAREHOUSE_ID NUMBER 18 Shipping Inventory Organization for Sell Intent contracts. Defaulted to lines.
WAREHOUSE_NAME VARCHAR2 240 Shipping Inventory Organization for Sell Intent contracts. Defaulted to lines.
BILL_PLAN_ID NUMBER 18 Bill plan identifier. Refers to BILL_PLAN_ID in PJB_BILL_PLANS_B.
BILL_PLAN_EXT_SOURCE VARCHAR2 120 Bill plan identifier.
BILL_PLAN_EXT_KEY VARCHAR2 120 BILL_PLAN_EXT_KEY
REVENUE_PLAN_ID NUMBER 18 Revenue plan identifier. Refers to PJB_BILL_PLANS_B.
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 Free form text referring to Customer PO Number, Wire or Check.
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 50 Default Tax Classification Code.
OUTPUT_TAX_CLASSIFICATION VARCHAR2 80 OUTPUT_TAX_CLASSIFICATION
TAX_EXEMPTION_CONTROL_CODE VARCHAR2 30 Can be Standard, Exempt or Required. If no value specified, treated as Standard. If Exempt, Exemption Number and Reason are mandatory. Valid only for a contract type with service lines. In V1.1, this will only be stamped for OM originated contracts.
TAX_EXEMPTION_CONTROL VARCHAR2 80 TAX_EXEMPTION_CONTROL
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Specifies the Tax Exemption Number.
EXEMPT_REASON_CODE VARCHAR2 30 Tax Exemption Reason code associated with the Tax Exemption Number. Auto populated based on the Exemption number.
EXEMPT_REASON VARCHAR2 80 EXEMPT_REASON
INTERNAL_LINES_OVN NUMBER 9 INTERNAL_LINES_OVN
HOLD_UNTIL_DATE DATE HOLD_UNTIL_DATE
HOLD_REASON_CODE VARCHAR2 30 HOLD_REASON_CODE
HOLD_REASON_SET_ID NUMBER 18 HOLD_REASON_SET_ID
HOLD_REASON_SET_CODE VARCHAR2 30 HOLD_REASON_SET_CODE
INTERNAL_OLD_STATUS_CODE VARCHAR2 30 Current status of the line before it is imported or updated
SOURCE_SYSTEM_ATTRIBUTES CLOB Name/Value pairs of attributes captured as part of a transaction in the source system. For example, these attributes could drive configuration, eligibility or pricing.
INVOICE_RULE_ID NUMBER 18 When will billing be done in a billing period. Arrears or Advanced. Will store ID column.
INVOICE_RULE VARCHAR2 240 When will billing be done in a billing period. Arrears or Advanced.
EXTERNAL_SEARCH_KEY1 VARCHAR2 150 EXTERNAL_SEARCH_KEY1
EXTERNAL_SEARCH_KEY2 VARCHAR2 150 EXTERNAL_SEARCH_KEY2
BILL_TO_ACCT_ID NUMBER 18 Bill to Account (Customer Account) for Sell Intent contracts.
BILL_TO_ACCT_NUMBER VARCHAR2 30 Bill to Account number (Customer Account) for Sell Intent contracts.
BILL_TO_SITE_USE_ID NUMBER 18 Bill to Site (Customer Account Site Use) for Sell Intent contracts.
BILL_TO_SITE_USE_LOCATION VARCHAR2 150 Bill to Site Use location (Customer Account Site Use) for Sell Intent contracts.
LINE_TYPE_ID NUMBER 18 ID of the Line Type for this line.
LINE_TYPE_NAME VARCHAR2 150 Name of the Line Type for this line.
PRICE_LIST_ID NUMBER 18 Contract line pricelist ID
PRICE_LIST_NAME VARCHAR2 150 Contrct Line pricelist name
COMMIT_LEVEL VARCHAR2 80 Commitment level
COMMIT_LEVEL_CODE VARCHAR2 30 Commitment level code
ALLOW_PRICELIST_OVERRIDE_YN VARCHAR2 1 Allow Price List Override When Ordering. (Y/N flag)
PRODUCT_ITEM_ID NUMBER 18 Sales catalog product item ID
PRODUCT_ITEM_NAME VARCHAR2 1995 Sales catalog product item name
PRODUCT_GROUP_ID NUMBER 18 Sales catalog group ID
PRODUCT_GROUP_NAME VARCHAR2 250 Sales cataglog group name
SHIP_TO_PARTY_ID NUMBER 18 SHIP_TO_PARTY_ID Active
SHIP_TO_PARTY_NAME VARCHAR2 240 SHIP_TO_PARTY_NAME Active
SHIP_TO_PARTY_SITE_ID NUMBER 18 SHIP_TO_PARTY_SITE_ID Active
SHIP_TO_PARTY_SITE_NUMBER VARCHAR2 30 SHIP_TO_PARTY_SITE_NUMBER Active
PRICE_UOM_CODE VARCHAR2 30 PRICE_UOM_CODE Active
PRICE_UOM VARCHAR2 80 PRICE_UOM Active
ACCT_RULE_ID NUMBER 18 ACCT_RULE_ID Active
ACCT_RULE_NAME VARCHAR2 240 ACCT_RULE_NAME Active
BILLING_FREQ VARCHAR2 30 BILLING_FREQ Active
INVOICE_TEXT VARCHAR2 2000 INVOICE_TEXT Active
ORDER_NUMBER VARCHAR2 120 ORDER_NUMBER Active
ORDER_LINE_NUMBER VARCHAR2 120 ORDER_LINE_NUMBER Active
ORDER_ID NUMBER 18 ORDER_ID Active
ORDER_LINE_ID NUMBER 18 ORDER_LINE_ID Active
ORDER_SOURCE VARCHAR2 30 ORDER_SOURCE Active
ORDER_SOURCE_NAME VARCHAR2 80 Order source name column
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_CREDIT_METHOD_CODE VARCHAR2 30 Return credit method code
INTERNAL_LINE_CLASS VARCHAR2 30 Indicates if the Sell Intent Contract Type with Enterprise Contract Class has SERVICE or PROJECT Lines.
RECURRING_AMOUNT NUMBER RECURRING_AMOUNT
ONETIME_AMOUNT NUMBER ONETIME_AMOUNT
SUPPRESSED_CREDIT_AMOUNT NUMBER SuppressedCreditAmount for reterminate action
TAX_AMOUNT NUMBER Tax amount
DATE_RENEWED DATE Date the Line was renewed
RENEWED_FROM_EXT_SOURCE VARCHAR2 120 Renewal source line ext_source
RENEWED_FROM_EXT_KEY VARCHAR2 120 Renewal source line ext_key
RENEWED_FROM_CLE_ID NUMBER 18 Renewal source line ID
RENEWED_FROM_MAJOR_VERSION NUMBER 18 Renewal source Line major version
INTERNAL_HEADER_STATUS VARCHAR2 30 The final status of contract header.
CANCEL_DATE DATE Date contract line was canceled.
CANCEL_REASON_CODE VARCHAR2 30 Cancel Reason Code
CANCEL_REASON_SET_ID NUMBER 18 Set Id for Cancel Reason Code.
CANCEL_REASON_SET_CODE VARCHAR2 30 Set Code for Cancel Reason Code.
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.
LINE_ID NUMBER 18 LINE_ID
COVERAGE_SCHEDULE_ID NUMBER 18 Coverage schedule ID.
COVERAGE_SCHEDULE_NAME VARCHAR2 150 Coverage schedule name.
BILLING_DATE_METHOD VARCHAR2 30 Billing Date method from lookup ORA_OKC_BILLING_DATE
BILLING_DATE_METHOD_CODE VARCHAR2 80 Billing Date method code for lines
BILL_DAY NUMBER 9 Bill for specific Days value from 1 to 31
BILL_OFFSET_DAYS NUMBER 9 Bill Offset Days for lines
PAYMENT_METHOD_CODE VARCHAR2 30 Paymethod Code for Contract lines
PAYMENT_METHOD VARCHAR2 80 Payment Method for Contract Lines
PRICE_DURING_BILLING_YN VARCHAR2 80 Pricing During Billing
USG_BILLED_AMOUNT NUMBER Usage Billed Amount for Contract lines
USG_CREDITED_AMOUNT NUMBER Usage Credited Amount in Contract Lines
USG_SUPPRESSED_CREDIT_AMT NUMBER Usage Supressed Credit Amount for Contract Lines
PO_NUMBER VARCHAR2 30 po number for Contract lines
WIRE_NUMBER VARCHAR2 30 Wire Number for Lines
EST_VAR_CONSIDERATION_AMT NUMBER Variable amount for lines
STANDALONE_SELLING_PRICE NUMBER Standalone selling price for lines

Indexes

Index Uniqueness Tablespace Columns
OKC_IMP_CONTRACT_LINES_N1 Non Unique Default BATCH_ID, IMPORT_STATUS_CODE, INTERNAL_ACTION_CODE, INTERFACE_ROW_ID, IS_CIRCULAR, NEW_LINE_EXT_SOURCE, NEW_LINE_EXT_KEY
OKC_IMP_CONTRACT_LINES_N2 Non Unique Default BATCH_ID, EXT_SOURCE, EXT_KEY, IMPORT_STATUS_CODE, STATUS_CODE
OKC_IMP_CONTRACT_LINES_N3 Non Unique Default BATCH_ID, FUSION_CONTRACT_LINE_ID, MAJOR_VERSION
OKC_IMP_CONTRACT_LINES_N4 Non Unique Default BATCH_ID, HDR_EXT_SOURCE, HDR_EXT_KEY
OKC_IMP_CONTRACT_LINES_U1 Unique FUSION_TS_TX_IDX BATCH_ID, INTERFACE_ROW_ID