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.