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