# DW_PO_AGENT_ASSIGNMENTS_D

PO Agent Assignment Dimension

## Details

Module: Purchasing

## Key Columns

ASSIGNMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Automactically generated unique identifier of agent and procuremnet BU combination. |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Source record identifier. |  |
PRC_BU_ID | NUMBER | 38 | 0 |  | Procurement BU unique identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
AGENT_ID | NUMBER | 38 | 0 |  | Internal person identifier. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
ACTIVE_FLAG | VARCHAR2 | 32 |  |  | Indicates if this combination of agent and prc bu is still active. Possible value 'Y' and 'N'. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who created the row. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Date from which the expense template can no longer be used. |  |
LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Indicates the date and time of the last update of the row. |  |
DEFAULT_PRINTER_NAME | VARCHAR2 | 128 |  |  | Default printer name for the procurement agent. |  |
DEFAULT_REQ_BU_ID | NUMBER | 38 | 0 |  | Default requisitioning business unit identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID

Copyright © 2019, 2025, Oracle and/or its affiliates.