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

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.