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