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 |