# 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

Copyright © 2019, 2025, Oracle and/or its affiliates.