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