DW_AGREEMENT_CHANGE_HEADERS_CF
Contains details for Purchase Agreement Headers 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 headers as part of the Agreement Version (Changes may happen for details which are not available on the Fact)
Details
Module: Purchasing
Key Columns
AGREEMENT_HEADER_ID, FROM_CHANGE_ORDER_SEQUENCE
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| AGREEMENT_HEADER_ID | NUMBER | 38 | 0 | True | Agreement Header 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_NUMBER | VARCHAR2 | 32 | Agreement Number | ||||
| TYPE_LOOKUP_CODE | VARCHAR2 | 32 | Type of the Document | ||||
| CURRENCY_CODE | VARCHAR2 | 16 | Currency Code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| PREVIOUS_CURRENCY_CODE | VARCHAR2 | 16 | Currency Code of previous version | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| CURRENCY_CODE_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Currency Code changed from previous version | ||||
| AGREEMENT_DESCRIPTION | VARCHAR2 | 256 | Descriptive comments for the document | ||||
| PREVIOUS_AGREEMENT_DESCRIPTION | VARCHAR2 | 256 | Descriptive comments of previous version | ||||
| AGREEMENT_DESCRIPTION_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Descriptive comments for the document changed from previous version | ||||
| SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Supplier site unique identifier | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| PREVIOUS_SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Supplier site unique identifier of previous version | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
| SUPPLIER_SITE_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Supplier site unique identifier changed from previous version | ||||
| BUYER_ID | NUMBER | 38 | 0 | Buyer unique identifier | DW_PERSON_NAME_CURRENT_D | PERSON_ID | |
| PREVIOUS_BUYER_ID | NUMBER | 38 | 0 | Buyer unique identifier of previous version | DW_PERSON_NAME_CURRENT_D | PERSON_ID | |
| BUYER_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Buyer unique identifier changed from previous version | ||||
| PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Payment terms unique identifier | DW_AP_TERMS_D | PAYMENT_TERMS_ID | |
| PREVIOUS_PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Payment terms unique identifier of previous version | DW_AP_TERMS_D | PAYMENT_TERMS_ID | |
| PAYMENT_TERMS_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Payment terms unique identifier changed from previous version | ||||
| CARRIER_ID | NUMBER | 38 | 0 | Carrier Identifier | DW_PARTY_D | PARTY_ID | |
| PREVIOUS_CARRIER_ID | NUMBER | 38 | 0 | Carrier Identifier of previous version | DW_PARTY_D | PARTY_ID | |
| CARRIER_ID_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Carrier Identifier changed from previous version | ||||
| MODE_OF_TRANSPORT | VARCHAR2 | 32 | Mode of Transport | ||||
| PREVIOUS_MODE_OF_TRANSPORT | VARCHAR2 | 32 | Mode of Transport of previous version | ||||
| MODE_OF_TRANSPORT_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Mode of Transport changed from previous version | ||||
| SERVICE_LEVEL | VARCHAR2 | 32 | Service Level | ||||
| PREVIOUS_SERVICE_LEVEL | VARCHAR2 | 32 | Service Level of previous version | ||||
| SERVICE_LEVEL_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Service Level changed from previous version | ||||
| FREIGHT_TERMS_CODE | VARCHAR2 | 32 | Type of freight terms for the document | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE | ||
| PREVIOUS_FREIGHT_TERMS_CODE | VARCHAR2 | 32 | Type of freight terms for the previous version | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE | ||
| FREIGHT_TERMS_CODE_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if freight terms changed from previous version | ||||
| FOB_CODE | VARCHAR2 | 32 | Type of free-on-board terms for the document | DW_FOB_LKP_TL | FOB_CODE | ||
| PREVIOUS_FOB_CODE | VARCHAR2 | 32 | Type of free-on-board terms for the previous version document | DW_FOB_LKP_TL | FOB_CODE | ||
| FOB_CODE_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if free-on-board terms changed from previous version | ||||
| PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 | Indicator of whether the Agreement will be paid upon receipt | ||||
| PREVIOUS_PAY_ON_RECEIPT_INDICATOR | VARCHAR2 | 16 | Indicator of whether the Agreement will be paid upon receipt of previous version | ||||
| PAY_ON_RECEIPT_INDICATOR_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if paid upon receipt 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 | ||||
| NOTE_TO_RECEIVER | VARCHAR2 | 999 | Note to receiver | ||||
| PREVIOUS_NOTE_TO_RECEIVER | VARCHAR2 | 999 | Note to receiver of previous version | ||||
| NOTE_TO_RECEIVER_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Note to receiver changed from previous version | ||||
| COMMUNICATION_METHOD | VARCHAR2 | 32 | Supplier Notification Method | DW_DOC_COMM_METHOD_D_TL | CODE | ||
| PREVIOUS_COMMUNICATION_METHOD | VARCHAR2 | 32 | Supplier Notification Method of previous version | DW_DOC_COMM_METHOD_D_TL | CODE | ||
| COMMUNICATION_METHOD_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Supplier Notification Method changed from pervious version | ||||
| START_DATE | DATE | Date the document becomes effective | |||||
| PREVIOUS_START_DATE | DATE | Date the document becomes effective of previous version | |||||
| START_DATE_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Date the document becomes effective is modified from previous version | ||||
| END_DATE | DATE | Expiration date of the document | |||||
| PREVIOUS_END_DATE | DATE | Expiration date of the document of previous version | |||||
| END_DATE_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Expiration date of the document is modified from previous version | ||||
| AGREEMENT_AMOUNT | NUMBER | Amount agreed for the agreement | |||||
| PREVIOUS_AGREEMENT_AMOUNT | NUMBER | Amount agreed for the agreement of previous version | |||||
| AGREEMENT_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Amount agreed for the agreement changed from pervious version | ||||
| MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against the agreement | |||||
| PREVIOUS_MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against the agreement of previous version | |||||
| MIN_RELEASE_AMOUNT_CHANGED_FLAG | VARCHAR2 | 16 | Set to Y if Minimum amount that can be released against the agreement changed from pervious 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. |