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   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, 2022, Oracle and/or its affiliates.