DW_PROC_CONTRACT_FULFILL_LINES_CF (Preview)

This table requires activation of Procurement Contracts functional area. This table stores contract fulfillment lines for buy intent.

Details

Module: Procurement Contracts

Key Columns

CONTRACT_FULFILL_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTRACT_FULFILL_LINE_ID NUMBER 38 0 True Contract fulfillment line identifier. DW_PROC_CONTRACT_FULFILL_LINES_TL CONTRACT_FULFILL_LINE_ID
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier.
CONTRACT_HEADER_ID NUMBER 38 0 Contract header unique identifier. DW_CONTRACT_HEADER_D_TL CONTRACT_HEADER_ID
CONTRACT_LINE_ID NUMBER 38 0 Contract line identifier (It will be populated with -99999,if lines are not available).#3 DW_CONTRACT_LINE_TL CONTRACT_LINE_ID
CONTRACT_NUMBER VARCHAR2 128 Contract number
CONTRACT_TYPE_ID NUMBER 38 0 This column stores the contract type used in contract. DW_CONTRACT_TYPE_D CONTRACT_TYPE_ID
LEDGER_ID NUMBER 38 0 Business unit primary ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 This column stores Legal entity used in contract DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type based on primary ledger of business unit. #2 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name based on primary ledger of business unit. #2 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
BUSINESS_UNIT_ID NUMBER 38 0 Business unit identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
TXN_CURRENCY_CODE VARCHAR2 16 Transaction currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency conversion rate
MASTER_CONTRACT_ID NUMBER 38 0 Unique contract identifier used during creation for Purchase Document.
CONTRACT_MAJOR_VERSION NUMBER 38 0 Contract Header Version.
CONTRACT_STATUS_CODE VARCHAR2 32 Status of the contract. DW_OKC_STATUS_LKP_TL OKC_STATUS_CODE
CONTRACT_UNDER_AMEND_VERSION_FLAG VARCHAR2 16 It stores - N: if version wasn't created for amendment, Y or NOVALUE - if under amendment with versioning DW_Y_N_D_TL CODE_TYPE
CONTRACT_ITEM_MASTER_ORGANIZATION_ID NUMBER 38 0 Inventory Organization for the contract points. DW_INV_ORGANIZATION_D INV_ORGANIZATION_ID
CONTRACT_ASSIGNEE_ID NUMBER 38 0 Current assignee of a contract. DW_PARTY_D PARTY_ID
CONTRACT_AP_PAYMENT_TERMS_ID NUMBER 38 0 Payment term for a contract. DW_AP_TERMS_D PAYMENT_TERMS_ID
CONTRACT_FREIGHT_TERMS_CODE VARCHAR2 256 Determines the freight terms for the contract. DW_FREIGHT_TERMS_LKP_TL FREIGHT_TERMS_CODE
CONTRACT_CARRIER_ID NUMBER 38 0 Type of carrier used for a contract. DW_PARTY_D PARTY_ID
CONTRACT_FOB_CODE VARCHAR2 256 Determines the point of transfer of ownership. DW_FOB_LKP_TL FOB_CODE
CONTRACT_ENCUMBRANCE_LEVEL VARCHAR2 32 This column stores level of restiction on agreement. DW_OKC_AGR_ENCUMB_LEVEL_LKP_TL OKC_AGR_ENCUMB_LEVEL_CODE
CONTRACT_SOURCE_DOC_SYSTEM_CODE VARCHAR2 32 This column stores the source system details which helped to generate contract. DW_ORA_OKC_SOURCE_SYSTEM_LKP_TL ORA_OKC_SOURCE_SYSTEM_CODE
CONTRACT_SOURCE_DOC_ID NUMBER 38 0 Source document identified from where contract sourced from.
CONTRACT_CREATION_DATE DATE Who column: indicates the date of the creation of the row. DW_DAY_D CALENDAR_DATE
CONTRACT_CREATION_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the creation of the row.
CONTRACT_START_DATE DATE Start date of the contract. DW_DAY_D CALENDAR_DATE
CONTRACT_APPROVED_DATE DATE Date when contract was approved. DW_DAY_D CALENDAR_DATE
CONTRACT_SIGNED_DATE DATE Date when contract was signed. DW_DAY_D CALENDAR_DATE
CONTRACT_HOLD_UNTIL_DATE DATE Date until which the hold is effective on the contract. DW_DAY_D CALENDAR_DATE
CONTRACT_HOLD_REASON_CODE VARCHAR2 32 Hold Reason for a contract. DW_OKC_APPLY_HOLD_REASON_LKP_TL OKC_APPLY_HOLD_REASON_CODE
CONTRACT_TERMINATED_DATE DATE Effective date on which the contract will be terminated. DW_DAY_D CALENDAR_DATE
CONTRACT_TERMINATION_REASON_CODE VARCHAR2 32 Closed reason for a contract. DW_CONTRACT_TRN_CODE_LKP_TL OKC_TRN_CODE
CONTRACT_END_DATE DATE End date of the contract. DW_DAY_D CALENDAR_DATE
CONTRACT_LAST_UPDATE_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the last update of the row.
CONTRACT_AMOUNT NUMBER Contract's total amount
CONTRACT_AGREEMENT_AMOUNT NUMBER Contract agreed amount - valid for agreement contract class.
CONTRACT_AGREEMENT_MIN_RELEASE_AMT NUMBER Contract minimum released amount - valid for agreement contract class.
CONTRACT_AGREEMENT_AMT_LIMIT NUMBER Contract amount limit - valid for agreement contract class.
GLOBAL_CONTRACT_AMOUNT NUMBER Contract's total amount in global currency.
GLOBAL_CONTRACT_AGR_AMOUNT NUMBER Contract agreed amount - valid for agreement contract class in global currency.
GLOBAL_CONTRACT_AGR_MIN_RELEASE_AMT NUMBER Contract minimum released amount - valid for agreement contract class in global currency.
GLOBAL_CONTRACT_AGR_AMT_LIMIT NUMBER Contract amount limit - valid for agreement contract class in global currency.
LINE_MAJOR_VERSION NUMBER 38 0 Contract line version number.
CONTRACT_LINE_NUMBER VARCHAR2 256 Contract line number
LINE_STATUS_CODE VARCHAR2 32 Status of the contract line. DW_OKC_STATUS_LKP_TL OKC_STATUS_CODE
CONTRACT_LINE_TYPE_ID NUMBER 38 0 Contract line type identifier DW_CONTRACT_LINE_TYPE_TL LINE_TYPE_ID
LINE_INVENTORY_ITEM_ID NUMBER 38 0 This column stores the inventory item unique identifier of the document. #1 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID ,ORGANIZATION_ID
LINE_INVENTORY_ORGANIZATION_ID NUMBER 38 0 Inventory organization unique identifier. DW_INV_ORGANIZATION_D INV_ORGANIZATION_ID
LINE_PURCHASING_CATEGORY_ID NUMBER 38 0 Item category unique identifier DW_ITEM_CATEGORIES_D CATEGORY_ID
LINE_AP_PAYMENT_TERMS_ID NUMBER 38 0 Payment term for a contract line. DW_AP_TERMS_D PAYMENT_TERMS_ID
LINE_FREIGHT_TERMS_CODE VARCHAR2 32 Determines the freight terms for the contract line. DW_FREIGHT_TERMS_LKP_TL FREIGHT_TERMS_CODE
LINE_CARRIER_ID NUMBER 38 0 Type of carrier used for a contract line. DW_PARTY_D PARTY_ID
LINE_FOB_CODE VARCHAR2 32 Determines the point of transfer of ownership for a contract line. DW_FOB_LKP_TL FOB_CODE
LINE_FIXED_PRICE_SERVICE_FLAG VARCHAR2 16 Fixed price service flag for agreement contract class. DW_Y_N_D_TL CODE
LINE_AGREEMENT_PRICE_OVERRIDE_ALLOWED VARCHAR2 16 Price overide applicable for agreement contract class. DW_Y_N_D_TL CODE
LINE_SUPPLIER_PARTY_ID NUMBER 38 0 Supplier identifier. DW_PARTY_D PARTY_ID
LINE_SUPPLIER_PARTY_SITE_ID NUMBER 38 0 Supplier site identifier.
LINE_SUPPLIER_PARTY_SITE_NAME VARCHAR2 256 Supplier site name.
LINE_SUPPLIER_PARTY_SITE_NUMBER VARCHAR2 32 Supplier site number.
LINE_SUPPLIER_PARTY_SITE_LOCATION_ID NUMBER 38 0 Supplier site location identifier DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
LINE_RECEIVING_ORGANIZATION_ID NUMBER 38 0 Receiving Inventory Organization for Buy Intent contracts DW_INV_ORGANIZATION_D INV_ORGANIZATION_ID
LINE_RECEIVING_LOCATION_ID NUMBER 38 0 Receiving location identifier. DW_WORKER_LOCATION_D LOCATION_ID
LINE_CREATION_DATE DATE Contract line creation date. DW_DAY_D CALENDAR_DATE
LINE_CREATION_TIMESTAMP TIMESTAMP Contract line creation date with timestamp.
LINE_NEED_BY_DATE DATE Due date of the contract line. DW_DAY_D CALENDAR_DATE
LINE_START_DATE DATE Start date of the contract line. DW_DAY_D CALENDAR_DATE
LINE_HOLD_UNTIL_DATE DATE Date until which the hold is effective on the contract line. DW_DAY_D CALENDAR_DATE
LINE_HOLD_REASON_CODE VARCHAR2 32 Hold Reason for a contract line. DW_OKC_APPLY_HOLD_REASON_LKP_TL OKC_APPLY_HOLD_REASON_CODE
LINE_TERMINATED_DATE DATE Contract line closed date. DW_DAY_D CALENDAR_DATE
LINE_TERMINATION_CODE VARCHAR2 32 Closed reason for a contract line. DW_CONTRACT_TRN_CODE_LKP_TL OKC_TRN_CODE
LINE_END_DATE DATE End date of the contract line. DW_DAY_D CALENDAR_DATE
LINE_LAST_UPDATE_TIMESTAMP TIMESTAMP Contract line last date with timestamp.
LINE_UOM_CODE VARCHAR2 16 Unit of measure for the contract line DW_UNIT_OF_MEASURE_D_TL UOM_CODE
LINE_QUANTITY NUMBER Quantity at contract lines applicable for enterprise contract class.
LINE_AGREEMENT_QUANTITY NUMBER Agreed quantity at contract lines applicable for agreement contract class.
LINE_AGREEMENT_QUANTITY_LIMIT NUMBER Agreed limit quantity at contract lines applicable for agreement contract class.
LINE_AGREEMENT_MIN_RELEASE_QUANTITY NUMBER Agreed minimum released quantity at contract lines applicable for agreement contract class.
LINE_PUOM_CODE VARCHAR2 16 Primary unit of measure for the contract line DW_UNIT_OF_MEASURE_D_TL UOM_CODE
LINE_PUOM_CONVERSION_FACTOR NUMBER Conversion factor from transaction to primary unit of measure.
PUOM_LINE_QUANTITY NUMBER Quantity at contract lines applicable for enterprise contract in primary unit of measure.
PUOM_LINE_AGREEMENT_QUANTITY NUMBER Agreed quantity at contract lines applicable for agreement contract class in primary unit of measure.
PUOM_LINE_AGREEMENT_QUANTITY_LIMIT NUMBER Agreed limit quantity at contract lines applicable for agreement contract class in primary unit of measure.
PUOM_LINE_AGR_MIN_RELEASE_QUANTITY NUMBER Agreed minimum released quantity at contract lines applicable for agreement contract class in primary unit of measure.
LINE_UNIT_PRICE NUMBER Price per unit applicable for enterprise contract class.
LINE_AMOUNT NUMBER Amount at contract lines applicable for enterprise contract class.
LINE_AGREEMENT_UNIT_PRICE NUMBER Price per unit applicable for agreement contract class.
LINE_AGREEMENT_AMOUNT NUMBER Agreed amount at contract lines applicable for agreement contract class.
LINE_AGREEMENT_AMOUNT_LIMIT NUMBER Agreed limit amount at contract lines applicable for agreement contract class.
LINE_AGREEMENT_MIN_RELEASE_AMOUNT NUMBER Agreed minimum released amount at contract lines applicable for agreement contract class.
GLOBAL_LINE_AMOUNT NUMBER Amount at contract lines applicable for enterprise contract class in global currency.
GLOBAL_LINE_AGREEMENT_AMOUNT NUMBER Agreed amount at contract lines applicable for agreement contract class in global currency.
GLOBAL_LINE_AGREEMENT_AMOUNT_LIMIT NUMBER Agreed limit amount at contract lines applicable for agreement contract class in global currency.
GLOBAL_LINE_AGR_MIN_RELEASE_AMOUNT NUMBER Agreed minimum released amount at contract lines applicable for agreement contract class in global currency.
FULFILL_LINE_NUMBER NUMBER 38 0 Contract fulfillment line number
FULFILL_LINE_TYPE VARCHAR2 32 Contract fulfillment line type identifier DW_OKC_DTS_DELIVERABLE_TYPE_LKP_TL OKC_DTS_DELIVERABLE_TYPE_CODE
FULFILL_LINE_DIRECTION VARCHAR2 32 The direction of deliverable i.e Inbound or Outbound. DW_OKC_DTS_DELIVERABLE_DIRECTION_LKP_TL OKC_DTS_DELIVERABLE_DIRECTION_CODE
FULFILL_LINE_STATUS VARCHAR2 32 Contract fulfillment line status DW_OKC_DTS_DELIVERABLE_STATUS_LKP_TL OKC_DTS_DELIVERABLE_STATUS_CODE
FULFILL_LINE_CREATION_DATE DATE Contract fulfillment line creation date. DW_DAY_D CALENDAR_DATE
FULFILL_LINE_CREATION_TIMESTAMP TIMESTAMP Contract fulfillment line creation date with timestamp.
FULFILL_LINE_LAST_UPDATE_TIMESTAMP TIMESTAMP Contract fulfillment line last date with timestamp.
FULFILL_LINE_COMPLETION_DATE DATE Completion date of the contract line. DW_DAY_D CALENDAR_DATE
PURCHASING_CATEGORY_ID NUMBER 38 0 Item category unique identifier DW_ITEM_CATEGORIES_D CATEGORY_ID
PURCHASING_DOCUMENT_NUMBER VARCHAR2 256 Purchasing document number associated with contract fulfillment line.
PURCHASING_DOC_CREATION_DATE DATE Purchasing Document creation date. DW_DAY_D CALENDAR_DATE
FULFILL_LINE_AGR_END_DATE DATE Contract fulfillment agreement end date. DW_DAY_D CALENDAR_DATE
PURCHASING_DOC_LINE_NUMBER VARCHAR2 256 Purchasing document line number associated with contract fulfillment line.
PURCHASING_DOCUMENT_ID VARCHAR2 512 Purchasing document header identifier associated with contract fulfillment line.
PURCHASING_DOC_LINE_ID VARCHAR2 512 Purchasing document line identifier number associated with contract fulfillment line.
BUYER_ID NUMBER 38 0 Buyer unique identifier. DW_PARTY_D PARTY_ID
REQUESTER_ID NUMBER 38 0 Requester unique identifier. DW_PARTY_D PARTY_ID
PROCUREMENT_BUSINESS_UNIT_ID NUMBER 38 0 Procurement business unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
REQUISITION_BUSINESS_UNIT_ID NUMBER 38 0 Requisition business unit identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
FULFILL_LINE_AP_PAYMENT_TERMS_ID NUMBER 38 0 Payment term for a contract fulfillment line. DW_AP_TERMS_D PAYMENT_TERMS_ID
FULFILL_LINE_FREIGHT_TERMS_CODE VARCHAR2 32 Determines the freight terms for the contract fulfillment line. DW_FREIGHT_TERMS_LKP_TL FREIGHT_TERMS_CODE
FULFILL_LINE_CARRIER_ID NUMBER 38 0 Type of carrier used for a contract fulfillment line. DW_PARTY_D PARTY_ID
FULFILL_LINE_FOB_CODE VARCHAR2 32 Determines the point of transfer of ownership for a contract fulfillment line. DW_FOB_LKP_TL FOB_CODE
FULFILL_LINE_SUPPLIER_PARTY_ID NUMBER 38 0 Supplier identifier. DW_PARTY_D PARTY_ID
FULFILL_LINE_SUPPLIER_PARTY_SITE_ID NUMBER 38 0 Supplier site identifier..
FULFILL_LINE_SUPPLIER_PARTY_SITE_NAME VARCHAR2 256 Supplier site name.
FULFILL_LINE_SUPPLIER_PARTY_SITE_NUMBER VARCHAR2 32 Supplier site number.
FULFILL_LINE_SUPPLIER_PARTY_SITE_LOCATION_ID NUMBER 38 0 Supplier site location identifier DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
FULFILL_LINE_RECEIVING_ORGANIZATION_ID NUMBER 38 0 Receiving Inventory Organization for Buy Intent contracts DW_INV_ORGANIZATION_D INV_ORGANIZATION_ID
FULFILL_LINE_RECEIVING_LOCATION_ID NUMBER 38 0 Receiving location identifier. DW_WORKER_LOCATION_D LOCATION_ID
FULFILL_LINE_BILL_TO_LOCATION_ID NUMBER 38 0 Bill to location identifier. DW_WORKER_LOCATION_D LOCATION_ID
FULFILL_LINE_INVENTORY_ITEM_ID NUMBER 38 0 This column stores the inventory item unique identifier of the document. #3 DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID ,ORGANIZATION_ID
FULFILL_LINE_INVENTORY_ORGANIZATION_ID NUMBER 38 0 Inventory organization unique identifier. DW_INV_ORGANIZATION_D INV_ORGANIZATION_ID
FULFILL_LINE_FIXED_PRICE_SERVICE_FLAG VARCHAR2 16 Fixed price service flag for agreement contract class. DW_Y_N_D_TL CODE
FULFILL_LINE_AGR_PRICE_OVERRIDE_ALLOWED VARCHAR2 16 Price overide applicable for agreement contract class. DW_Y_N_D_TL CODE
FULFILL_LINE_UOM_CODE VARCHAR2 32 Unit of measure for the contract fulfillment line. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
FULFILL_LINE_QUANTITY NUMBER Quantity at contract fulfillment lines applicable for enterprise contract class.
FULFILL_LINE_AGR_QUANTITY NUMBER Agreed quantity at contract fulfillment lines applicable for agreement contract class.
FULFILL_LINE_AGR_QUANTITY_LIMIT NUMBER Agreed limit quantity at contract fulfillment lines applicable for agreement contract class.
FULFILL_LINE_MIN_RELEASE_QUANTITY NUMBER Agreed minimum released quantity at contract fulfillment lines applicable for agreement contract class.
FULFILL_LINE_PUOM_CODE VARCHAR2 16 Unit of measure for the contract fulfillment line in Primary unit of measure. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
FULFILL_LINE_PUOM_CONVERSION_FACTOR NUMBER Conversion factor from transaction to primary unit of measure.
PUOM_FULFILL_LINE_QUANTITY NUMBER Quantity at contract fulfillment lines applicable for enterprise contract class in primary unit of measure.
PUOM_FULFILL_LINE_AGR_QUANTITY NUMBER Agreed quantity at contract fulfillment lines applicable for agreement contract class in primary unit of measure.
PUOM_FULFILL_LINE_AGR_QUANTITY_LIMIT NUMBER Agreed limit quantity at contract fulfillment lines applicable for agreement contract class in primary unit of measure.
PUOM_FULFILL_LINE_MIN_RELEASE_QUANTITY NUMBER Agreed minimum released quantity at contract fulfillment lines applicable for agreement contract class in primary unit of measure.
FULFILL_LINE_UNIT_PRICE NUMBER Price per unit applicable for enterprise contract class.
FULFILL_LINE_AMOUNT NUMBER Amount at contract fulfillment lines applicable for enterprise contract class.
FULFILL_LINE_AGREEMENT_UNIT_PRICE NUMBER Price per unit applicable for agreement contract class.
FULFILL_LINE_AGR_AMOUNT NUMBER Agreed amount at contract fulfillment lines applicable for agreement contract class.
FULFILL_LINE_AGR_AMOUNT_LIMIT NUMBER Agreed limit amount at contract fulfillment lines applicable for agreement contract class.
FULFILL_LINE_MIN_RELEASE_AMOUNT NUMBER Agreed minimum released amount at contract fulfillment lines applicable for agreement contract class.
GLOBAL_FULFILL_LINE_AMOUNT NUMBER Amount at contract fulfillment lines applicable for enterprise contract class in global currency.
GLOBAL_FULFILL_LINE_AGR_AMOUNT NUMBER Agreed amount at contract fulfillment lines applicable for agreement contract class in global currency.
GLOBAL_FULFILL_LINE_AGR_AMOUNT_LIMIT NUMBER Agreed limit amount at contract fulfillment lines applicable for agreement contract class in global currency.
GLOBAL_FULFILL_LINE_MIN_RELEASE_AMOUNT NUMBER Agreed minimum released amount at contract fulfillment lines applicable for agreement contract class in global currency.

Notes

#1 In these cases in addition to the item columns LINE_INVENTORY_ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D.#2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on FULFILL_LINE_CREATION_DATE column.#3 In these cases in addition to the item columns FULFILL_LINE_INVENTORY_ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D