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
| 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. |