DW_AGREEMENT_DOCUMENT_HISTORY_CF

This table contains action details of all Submitted Agreements and Change Orders for Agreements

Details

Module: Purchasing

Key Columns

OBJECT_SUB_TYPE_CODE, AGREEMENT_HEADER_ID, OBJECT_TYPE_CODE, ACTION_CODE, SEQUENCE_NUMBER

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AGREEMENT_HEADER_ID NUMBER 38 0 True Document header unique identifier
OBJECT_TYPE_CODE VARCHAR2 32 True Object Type Code
OBJECT_SUB_TYPE_CODE VARCHAR2 32 True Object Sub Type Code
SEQUENCE_NUMBER NUMBER True Sequence of the approval or control action for a document
ACTION_CODE VARCHAR2 32 True Approval or control action type DW_PO_ACTION_LKP_TL PO_ACTION_CODE
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Source record identifier
AGREEMENT_NUMBER VARCHAR2 32 Agreement Number
PROCUREMENT_BU_ID NUMBER 38 0 Procurement Business Unit identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
PROCUREMENT_LEDGER_ID NUMBER 38 0 Primary Ledger ID of Procurement Business Unit DW_LEDGER_D LEDGER_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name #1 DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type #1 DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
AGREEMENT_VERSION_ID NUMBER 38 0 Agreement Version identifier
PERFORMER_ROLE_CODE VARCHAR2 32 Role of the action performer DW_PO_USER_ROLE_LKP_TL PO_USER_ROLE_CODE
PERFORMING_PERSON_ID NUMBER 38 0 Identifier of the person performing the action DW_PERSON_NAME_CURRENT_D PERSON_ID
PERFORMING_SUPPLIER_PARTY_ID NUMBER 38 0 Identifier of the supplier performing the action DW_PARTY_D PARTY_ID
ACTION_TIMESTAMP TIMESTAMP Timestamp on which the Action was taken
ACTION_DATE DATE Date on which the Action was taken DW_DAY_D CALENDAR_DATE
NOTE VARCHAR2 999 Note for next approver or reason for control action
IDENTIFICATION_KEY VARCHAR2 128 Identification key for the action
CREATION_TIMESTAMP TIMESTAMP Indicates the date and time of the creation of the row
LAST_UPDATE_TIMESTAMP TIMESTAMP Indicates the date and time of the last update of the row.

Notes

#1 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on ACTION_DATE column