DW_AGREEMENT_VERSION_CHANGE_DETAILS_CF

Purchase Agreement Version change details

Details

Module: Purchasing

Key Columns

AGREEMENT_HEADER_ID, AGREEMENT_LINE_ID, AGREEMENT_SCHEDULE_ID, AGREEMENT_VERSION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AGREEMENT_VERSION_ID NUMBER 38 0 True Agreement Version identifier
AGREEMENT_HEADER_ID NUMBER 38 0 True Agreement Header identifier
AGREEMENT_LINE_ID NUMBER 38 0 True Agreement Line identifier
AGREEMENT_SCHEDULE_ID NUMBER 38 0 True Agreement Shipment schedule identifier
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier
CHANGE_ORDER_SEQUENCE NUMBER Change Order Sequence
CHANGE_ORDER_NUMBER VARCHAR2 128 Change Order Number
AGREEMENT_NUMBER VARCHAR2 32 Agreement Number
TYPE_LOOKUP_CODE VARCHAR2 32 Type of the Document
H_AVAILABLE_FOR_VERSION_FLAG VARCHAR2 16 Set to Y if any changes happened in Header for this version
H_AGREEMENT_VERSION_ID NUMBER 38 0 Agreement Version identifier for the Header record
H_FROM_CHANGE_ORDER_SEQUENCE NUMBER From Change Order Sequence for the Header
H_TO_CHANGE_ORDER_SEQUENCE NUMBER Headers The ending point of the co sequence range within which the record is valid (Exclusive) of Agreement Headers
H_CURRENCY_CODE VARCHAR2 16 Currency Code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
H_PREVIOUS_CURRENCY_CODE VARCHAR2 16 Currency Code of previous version DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
H_CURRENCY_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if Currency Code changed from previous version
H_AGREEMENT_DESCRIPTION VARCHAR2 256 Descriptive comments for the document
H_PREVIOUS_AGREEMENT_DESCRIPTION VARCHAR2 256 Descriptive comments of previous version document
H_AGREEMENT_DESCRIPTION_CHANGED_FLAG VARCHAR2 16 Set to Y if Descriptive comments for the document changed from previous version
H_SUPPLIER_SITE_ID NUMBER 38 0 Supplier site unique identifier DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
H_PREVIOUS_SUPPLIER_SITE_ID NUMBER 38 0 Supplier site unique identifier of previous version DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
H_SUPPLIER_SITE_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Supplier site unique identifier changed from previous version
H_BUYER_ID NUMBER 38 0 Buyer unique identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
H_PREVIOUS_BUYER_ID NUMBER 38 0 Buyer unique identifier of previous version DW_PERSON_NAME_CURRENT_D PERSON_ID
H_BUYER_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Buyer unique identifier changed from previous version
H_PAYMENT_TERMS_ID NUMBER 38 0 Payment terms unique identifier DW_AP_TERMS_D PAYMENT_TERMS_ID
H_PREVIOUS_PAYMENT_TERMS_ID NUMBER 38 0 Payment terms unique identifier of previous version DW_AP_TERMS_D PAYMENT_TERMS_ID
H_PAYMENT_TERMS_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Payment terms unique identifier changed from previous version
H_CARRIER_ID NUMBER 38 0 Carrier Identifier DW_PARTY_D PARTY_ID
H_PREVIOUS_CARRIER_ID NUMBER 38 0 Carrier Identifier of previous version DW_PARTY_D PARTY_ID
H_CARRIER_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Carrier Identifier changed from previous version
H_MODE_OF_TRANSPORT VARCHAR2 32 Mode of Transport
H_PREVIOUS_MODE_OF_TRANSPORT VARCHAR2 32 Mode of Transport of previous version
H_MODE_OF_TRANSPORT_CHANGED_FLAG VARCHAR2 16 Set to Y if Mode of Transport changed from previous version
H_SERVICE_LEVEL VARCHAR2 32 Service Level
H_PREVIOUS_SERVICE_LEVEL VARCHAR2 32 Service Level of previous version
H_SERVICE_LEVEL_CHANGED_FLAG VARCHAR2 16 Set to Y if Service Level changed from previous version
H_FREIGHT_TERMS_CODE VARCHAR2 32 Type of freight terms for the document DW_FREIGHT_TERMS_LKP_TL FREIGHT_TERMS_CODE
H_PREVIOUS_FREIGHT_TERMS_CODE VARCHAR2 32 Type of freight terms for the previous version document DW_FREIGHT_TERMS_LKP_TL FREIGHT_TERMS_CODE
H_FREIGHT_TERMS_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if freight terms changed from previous version
H_FOB_CODE VARCHAR2 32 Type of free-on-board terms for the document DW_FOB_LKP_TL FOB_CODE
H_PREVIOUS_FOB_CODE VARCHAR2 32 Type of free-on-board terms for the previous version document DW_FOB_LKP_TL FOB_CODE
H_FOB_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if free-on-board terms changed from previous version
H_PAY_ON_RECEIPT_INDICATOR VARCHAR2 16 Indicator of whether the Agreement will be paid upon receipt
H_PREVIOUS_PAY_ON_RECEIPT_INDICATOR VARCHAR2 16 Indicator of whether the Agreement will be paid upon receipt of previous version
H_PAY_ON_RECEIPT_INDICATOR_CHANGED_FLAG VARCHAR2 16 Set to Y if paid upon receipt changed from previous version
H_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier
H_PREVIOUS_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier of previous version
H_NOTE_TO_SUPPLIER_CHANGED_FLAG VARCHAR2 16 Set to Y if Short note to supplier changed from previous version
H_NOTE_TO_RECEIVER VARCHAR2 999 Note to receiver
H_PREVIOUS_NOTE_TO_RECEIVER VARCHAR2 999 Note to receiver of previous version
H_NOTE_TO_RECEIVER_CHANGED_FLAG VARCHAR2 16 Set to Y if Note to receiver changed from previous version
H_COMMUNICATION_METHOD VARCHAR2 32 Supplier Notification Method DW_DOC_COMM_METHOD_D_TL CODE
H_PREVIOUS_COMMUNICATION_METHOD VARCHAR2 32 Supplier Notification Method of previous version DW_DOC_COMM_METHOD_D_TL CODE
H_COMMUNICATION_METHOD_CHANGED_FLAG VARCHAR2 16 Set to Y if Supplier Notification Method changed from pervious version
H_START_DATE DATE Date the document becomes effective
H_PREVIOUS_START_DATE DATE Date the document becomes effective of previous version
H_START_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Date the document becomes effective is modified from previous version
H_END_DATE DATE Expiration date of the document
H_PREVIOUS_END_DATE DATE Expiration date of the document of previous version
H_END_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Expiration date of the document is modified from previous version
H_AGREEMENT_AMOUNT NUMBER Amount agreed for the agreement
H_PREVIOUS_AGREEMENT_AMOUNT NUMBER Amount agreed for the agreement of previous version
H_AGREEMENT_AMOUNT_CHANGED_FLAG VARCHAR2 16 Set to Y if Amount agreed for the agreement changed from pervious version
H_MIN_RELEASE_AMOUNT NUMBER Minimum amount that can be released against the agreement
H_PREVIOUS_MIN_RELEASE_AMOUNT NUMBER Minimum amount that can be released against the agreement of previous version
H_MIN_RELEASE_AMOUNT_CHANGED_FLAG VARCHAR2 16 Set to Y if Minimum amount that can be released against the agreement changed from pervious version
L_AVAILABLE_FOR_VERSION_FLAG VARCHAR2 16 Set to Y if any changes happened in Line for this version
L_AGREEMENT_VERSION_ID NUMBER 38 0 Agreement Version identifier for the Line record
L_FROM_CHANGE_ORDER_SEQUENCE NUMBER From Change Order Sequence for the Line
L_TO_CHANGE_ORDER_SEQUENCE NUMBER Headers The ending point of the co sequence range within which the record is valid (Exclusive) of Agreement Lines
L_TRANSACTION_UOM_CODE VARCHAR2 16 Transaction unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
L_AGREEMENT_LINE_NUMBER NUMBER Agreement Line Number
L_PREVIOUS_AGREEMENT_LINE_NUMBER NUMBER Agreement Line Number of previous version
L_AGREEMENT_LINE_NUMBER_CHANGED_FLAG VARCHAR2 16 Set to Y if Agreement Line Number changed from previous version
L_LINE_DESCRIPTION VARCHAR2 256 Line Item description
L_PREVIOUS_LINE_DESCRIPTION VARCHAR2 256 Line Item description of previous version
L_LINE_DESCRIPTION_CHANGED_FLAG VARCHAR2 16 Set to Y if Line Item description changed from previous version
L_SUPPLIER_ITEM VARCHAR2 512 Supplier product number
L_PREVIOUS_SUPPLIER_ITEM VARCHAR2 512 Supplier product number of previous version
L_SUPPLIER_ITEM_CHANGED_FLAG VARCHAR2 16 Set to Y if Supplier product number changed from previous version
L_UNIT_PRICE NUMBER Unit price for the line
L_PREVIOUS_UNIT_PRICE NUMBER Unit price for the line of previous version
L_UNIT_PRICE_CHANGED_FLAG VARCHAR2 16 Set to Y if Unit price for the line changed from previous version
L_EXPIRATION_DATE DATE Expiration Date For Catalog Lines
L_PREVIOUS_EXPIRATION_DATE DATE Expiration Date For Catalog Lines of previous version
L_EXPIRATION_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Expiration Date For Catalog Lines changed from previous version
L_PRICE_BREAK_CODE VARCHAR2 32 Describes the pricing scheme for blanket agreement line price breaks DW_PRICE_BREAK_TYPE_D_TL CODE
L_PREVIOUS_PRICE_BREAK_CODE VARCHAR2 32 Describes the pricing scheme for blanket agreement line price breaks DW_PRICE_BREAK_TYPE_D_TL CODE
L_PRICE_BREAK_CODE_CHANGED_FLAG VARCHAR2 16 Set to Y if Price Breakup Code changed from previous version
L_AGREEMENT_QUANTITY NUMBER Quantity agreed for an agreement line
L_PREVIOUS_AGREEMENT_QUANTITY NUMBER Quantity agreed for an agreement line of previous version
L_AGREEMENT_QUANTITY_CHANGED_FLAG VARCHAR2 16 Set to Y if Quantity agreed for an agreement line changed from previous version
L_AGREEMENT_AMOUNT NUMBER Amount agreed for an agreement line
L_PREVIOUS_AGREEMENT_AMOUNT NUMBER Amount agreed for an agreement line of previous version
L_AGREEMENT_AMOUNT_CHANGED_FLAG VARCHAR2 16 Set to Y if Quantity agreed for an agreement line changed from previous version
L_MIN_RELEASE_AMOUNT NUMBER Minimum amount that can be released
L_PREVIOUS_MIN_RELEASE_AMOUNT NUMBER Minimum amount that can be released of previous version
L_MIN_RELEASE_AMOUNT_CHANGED_FLAG VARCHAR2 16 Set to Y if Minimum amount that can be released changed from previous version
L_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier
L_PREVIOUS_NOTE_TO_SUPPLIER VARCHAR2 999 Short note to supplier of previous version
L_NOTE_TO_SUPPLIER_CHANGED_FLAG VARCHAR2 16 Set to Y if Short note to supplier changed from previous version
LO_AVAILABLE_FOR_VERSION_FLAG VARCHAR2 16 Set to Y if any changes happened in Schedule for this version
LO_AGREEMENT_VERSION_ID NUMBER 38 0 Agreement Version identifier for the Schedule record
LO_FROM_CHANGE_ORDER_SEQUENCE NUMBER From Change Order Sequence for the Schedule
LO_TO_CHANGE_ORDER_SEQUENCE NUMBER The ending point of the co sequence range within which the record is valid (Exclusive) of Agreement Line Locations
LO_TRANSACTION_UOM_CODE VARCHAR2 16 Transaction unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
LO_AGREEMENT_SCHEDULE_NUMBER NUMBER Agreement Schedule Number
LO_PREVIOUS_AGREEMENT_SCHEDULE_NUMBER NUMBER Agreement Schedule Number of previous version
LO_AGREEMENT_SCHEDULE_NUMBER_CHANGED_FLAG VARCHAR2 16 Set to Y if Agreement Schedule Number changed from previous version
LO_PRICE NUMBER Price for the Agreement
LO_PREVIOUS_PRICE NUMBER Price for the Agreement of previous version
LO_PRICE_CHANGED_FLAG VARCHAR2 16 Set to Y if Price for the Agreement changed from previous version
LO_QUANTITY NUMBER Quantity for the Agreement
LO_PREVIOUS_QUANTITY NUMBER Quantity for the Agreement of previous version
LO_QUANTITY_CHANGED_FLAG VARCHAR2 16 Set to Y if Quantity for the Agreement changed from previous version
LO_START_DATE DATE Effective date of the price
LO_PREVIOUS_START_DATE DATE Effective date of the price of previous version
LO_START_DATE_CHANGED_FLAG VARCHAR2 16 Set to Y if Effective date of the price changed from previous version
LO_SHIP_TO_ORGANIZATION_ID NUMBER 38 0 Ship-to organization unique identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
LO_PREVIOUS_SHIP_TO_ORGANIZATION_ID NUMBER 38 0 Ship-to organization unique identifier of previous version DW_INTERNAL_ORG_D ORGANIZATION_ID
LO_SHIP_TO_ORGANIZATION_ID_CHANGED_FLAG VARCHAR2 16 Set to Y if Ship-to organization unique identifier changed from previous version