DW_PO_AGENT_ASSIGNMENTS_D
PO Agent Assignment Dimension
Details
Module: Purchasing
Key Columns
ASSIGNMENT_ID
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 |