DW_AGREEMENT_CHANGE_LINES_CF

Contains details for Purchase Agreement Lines for Accepted Agreement Versions. Data for Cancelled Purchase Agreements and Cancelled Change Order Versions will not be available. Also, data will appear only when some changes happen for the Purchase Agreement lines as part of the Agreement Version (Changes may happen for details which are not available on the Fact)

Details

Module: Purchasing

Key Columns

FROM_CHANGE_ORDER_SEQUENCE, AGREEMENT_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AGREEMENT_LINE_ID NUMBER 38 0 True Agreement line unique identifier
FROM_CHANGE_ORDER_SEQUENCE NUMBER True The starting point of the co sequence range within which the record is valid (Inclusive)
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source record identifier
TO_CHANGE_ORDER_SEQUENCE NUMBER The ending point of the co sequence range within which the record is valid (Exclusive)
AGREEMENT_VERSION_ID NUMBER 38 0 Agreement Version identifier
CHANGE_ORDER_NUMBER VARCHAR2 128 Change Order Number
AGREEMENT_HEADER_ID NUMBER 38 0 Agreement Header identifier
TYPE_LOOKUP_CODE VARCHAR2 32 Type of the Document
TRANSACTION_UOM_CODE VARCHAR2 16 Transaction unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
AGREEMENT_LINE_NUMBER NUMBER Agreement Line Number
PREVIOUS_AGREEMENT_LINE_NUMBER NUMBER Agreement Line Number of previous version
AGREEMENT_LINE_NUMBER_CHANGED_FLAG VARCHAR2 16 Set to Y if Agreement Line Number changed from previous version
LINE_DESCRIPTION VARCHAR2 256 Line Item description
PREVIOUS_LINE_DESCRIPTION VARCHAR2 256 Line Item description of previous version
LINE_DESCRIPTION_CHANGED_FLAG VARCHAR2 16 Set to Y if Line Item description changed from previous version
SUPPLIER_ITEM VARCHAR2 512 Supplier product number
PREVIOUS_SUPPLIER_ITEM VARCHAR2 512 Supplier product number of previous version
SUPPLIER_ITEM_CHANGED_FLAG VARCHAR2 16 Set to Y if Supplier product number changed from previous version
UNIT_PRICE NUMBER Unit price for the line
PREVIOUS_UNIT_PRICE NUMBER Unit price for the line of previous version
UNIT_PRICE_CHANGED_FLAG VARCHAR2 16 Set to Y if Unit price for the line changed from previous version
EXPIRATION_DATE DATE Expiration Date For Catalog Lines
PREVIOUS_EXPIRATION_DATE DATE Expiration Date For Catalog Lines of previous version
EXPIRATION_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Expiration Date For Catalog Lines changed from previous version
PRICE_BREAK_CODE VARCHAR2 32 Describes the pricing scheme for blanket agreement line price breaks DW_PRICE_BREAK_TYPE_D_TL CODE
PREVIOUS_PRICE_BREAK_CODE VARCHAR2 32 Describes the pricing scheme for blanket agreement line price breaks of previous version DW_PRICE_BREAK_TYPE_D_TL CODE
PRICE_BREAK_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if Price Breakup Code changed from previous version
AGREEMENT_QUANTITY NUMBER Quantity agreed for an agreement line
PREVIOUS_AGREEMENT_QUANTITY NUMBER Quantity agreed for an agreement line of previous version
AGREEMENT_QUANTITY_CHANGED_FLAG VARCHAR2 16 Set to Y if Quantity agreed for an agreement line changed from previous version
AGREEMENT_AMOUNT NUMBER Amount agreed for an agreement line
PREVIOUS_AGREEMENT_AMOUNT NUMBER Amount agreed for an agreement line of previous version
AGREEMENT_AMOUNT_CHANGED_FLAG VARCHAR2 16 Set to Y if Quantity agreed for an agreement line changed from previous version
MIN_RELEASE_AMOUNT NUMBER Minimum amount that can be released
PREVIOUS_MIN_RELEASE_AMOUNT NUMBER Minimum amount that can be released of previous version
MIN_RELEASE_AMOUNT_CHANGED_FLAG VARCHAR2 16 Set to Y if Minimum amount that can be released changed from previous version
NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier
PREVIOUS_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier of previous version
NOTE_TO_SUPPLIER_CHANGED_FLAG VARCHAR2 16 Set to Y if Short note to supplier changed from previous version
CREATION_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the last update of the row.