# DW_AGREEMENT_CHANGE_LINE_LOCATIONS_CF

Contains details for Purchase Agreement Schedules 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 Schedules 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_SCHEDULE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
AGREEMENT_SCHEDULE_ID | NUMBER | 38 | 0 | True | Document shipment schedule 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 |  |
AGREEMENT_LINE_ID | NUMBER | 38 | 0 |  | Agreement line unique identifier |  |
TRANSACTION_UOM_CODE | VARCHAR2 | 16 |  |  | Transaction unit of measure | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
AGREEMENT_SCHEDULE_NUMBER | NUMBER |  |  |  | Agreement Schedule Number |  |
PREVIOUS_AGREEMENT_SCHEDULE_NUMBER | NUMBER |  |  |  | Agreement Schedule Number of previous version |  |
AGREEMENT_SCHEDULE_NUMBER_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Agreement Schedule Number changed from previous version |  |
PRICE | NUMBER |  |  |  | Price for the Agreement |  |
PREVIOUS_PRICE | NUMBER |  |  |  | Price for the Agreement of previous version |  |
PRICE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Price for the Agreement changed from previous version |  |
QUANTITY | NUMBER |  |  |  | Quantity for the Agreement |  |
PREVIOUS_QUANTITY | NUMBER |  |  |  | Quantity for the Agreement of previous version |  |
QUANTITY_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Quantity for the Agreement changed from previous version |  |
START_DATE | DATE |  |  |  | Effective date of the price |  |
PREVIOUS_START_DATE | DATE |  |  |  | Effective date of the price of previous version |  |
START_DATE_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Effective date of the price changed from previous version |  |
SHIP_TO_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Ship-to organization unique identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PREVIOUS_SHIP_TO_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Ship-to organization unique identifier of previous version | DW_INTERNAL_ORG_D | ORGANIZATION_ID
SHIP_TO_ORGANIZATION_ID_CHANGED_FLAG | VARCHAR2 | 16 |  |  | Set to Y if Ship-to organization unique identifier 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. |  |

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