Application Object Library - WF_ACTIVITIES | Defines a unit of work that contributes to the accomplishment of a process. |
---|---|
Column Name | Descritpion |
NAME | Internal name for the activity |
ERROR_ITEM_TYPE | Name of item type to execute in case of error |
RUNNABLE_FLAG | Flag (Y or N) to indicate if activity is runnable |
FUNCTION_TYPE | Indicates whether function type is pl/sql or internal |
EVENT_NAME | Event name to be raised, sent or received. |
DIRECTION | What direction the above event is used (RAISE, SEND, RECEIVE). |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
VERSION | Version of the activity |
TYPE | Type of activity (FOLDER, FUNCTION, NOTICE or PROCESS) |
RERUN | Determines if activity is rerun during looping |
EXPAND_ROLE | Determines how many roles are required to respond to a notification activity. |
PROTECT_LEVEL | level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
BEGIN_DATE | Start date |
ITEM_TYPE | Internal name for the Item Type that owns the message |
END_DATE | Date finished |
FUNCTION | PL/SQL function run for PL/SQL activities |
RESULT_TYPE | Result code of the activity |
COST | Assigned cost of the activity |
READ_ROLE | Not currently used |
WRITE_ROLE | Not currently used |
EXECUTE_ROLE | Not currently used |
ICON_NAME | Name of activity icon used in process window |
MESSAGE | Name of the message for a notification activity |
ERROR_PROCESS | Workflow process to run in case of an error |
Application Object Library - WF_ACTIVITIES_TL | Translations for WF_ACTIVITIES |
---|---|
Column Name | Descritpion |
NAME | Internal name |
VERSION | Version of the activity |
DISPLAY_NAME | Name displayed to the user |
LANGUAGE | Language |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
DESCRIPTION | Description |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
ITEM_TYPE | Internal name for the Item Type |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
Application Object Library - WF_ACTIVITY_ATTRIBUTES | Defines attributes for activities |
---|---|
Column Name | Descritpion |
ACTIVITY_ITEM_TYPE | Item type the activity is associated with |
SUBTYPE | Determines if attribute is send or respond |
FORMAT | Format mask or Lookup type |
TEXT_DEFAULT | Default value if type is text |
NUMBER_DEFAULT | Default value if type is number |
DATE_DEFAULT | Default value if type is date |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
ACTIVITY_NAME | Internal name of the activity |
ACTIVITY_VERSION | Version of the activity |
NAME | Internal name of the attribute |
SEQUENCE | Order of the attribute within the message |
TYPE | Type of attribute |
VALUE_TYPE | Defines if the default is a constant or a reference to a item attribute |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
Application Object Library - WF_ACTIVITY_ATTR_VALUES | Values for activity attributes |
---|---|
Column Name | Descritpion |
PROCESS_ACTIVITY_ID | Reference to the instance identification |
NAME | Internal name |
VALUE_TYPE | Defines if the default is a constant or a reference to a item attribute |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
TEXT_VALUE | Holds a value if the type is text |
NUMBER_VALUE | Holds a value if the type is number |
DATE_VALUE | Holds a value if the type is date |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
Application Object Library - WF_ACTIVITY_ATTRIBUTES_TL | Translations for WF_ACTIVITY_ATTRIBUTES |
---|---|
Column Name | Descritpion |
ACTIVITY_ITEM_TYPE | Item type the activity is associated with |
DESCRIPTION | Description |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
SECURITY_GROUOP_ID | identifier reserved for hosting environment |
ACTIVITY_NAME | Internal name of the activity |
ACTIVITY_VERSION | Version of the activity |
NAME | Internal name |
LANGUAGE | Language |
DISPLAY_NAME | Name displayed to the user |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
Application Object Library - WF_ACTIVITY_TRANSITIONS | Transition definitions |
---|---|
Column Name | Descritpion |
FROM_PROCESS_ACTIVITY | Origin activity of the transition |
RESULT_CODE | Y or N code asociated with the transition |
TO_PROCESS_ACTIVITY | Destination activity of the transition |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
ARROW_GEOMETRY | Coordinates of the transition arrow |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
Application Object Library - WF_ITEM_ACTIVITY_STATUSES | Runtime table for a work item |
---|---|
Column Name | Descritpion |
ITEM_TYPE | Internal name for the Item Type |
EXECUTION_TIME | Used to sequence activities while running |
ERROR_NAME | Internal message name |
ERROR_MESSAGE | Translated message text |
ERROR_STACK | Stack of function calls |
OUTBOUND_QUEUE_ID | Identifier for workflow outbound advanced queue |
ITEM_KEY | Holds the primary key generated for the item type |
DUE_DATE | Date after which activity is timed out |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PROCESS_ACTIVITY | Activity in process |
ACTION | ACTION |
PERFORMED_BY | PERFORMED_BY |
ACTIVITY_STATUS | Status determines how an activity should run & what it should be after it was run |
ACTIVITY_RESULT_CODE | The result code that determines which path to take to next activity |
ASSIGNED_USER | Role assigned at runtime |
NOTIFICATION_ID | Notification identifier |
BEGIN_DATE | Activity's start date |
END_DATE | Activity's end date |
Application Object Library - WF_ITEM_ACTIVITY_STATUSES_H | Stores history of WF_ITEM_ACTIVITY_STATUSES |
---|---|
Column Name | Descritpion |
ITEM_TYPE | Internal name for the Item Type |
EXECUTION_TIME | Used to sequence activities while running |
ERROR_NAME | Internal message name |
ERROR_MESSAGE | Translated message text |
ERROR_STACK | Stack of function calls |
OUTBOUND_QUEUE_ID | Identifier for workflow outbound advanced queue |
ITEM_KEY | Holds the primary key generated for the item type |
DUE_DATE | Date after which activity is timed out |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PROCESS_ACTIVITY | Activity in process |
ACTION | ACTION |
PERFORMED_BY | PERFORMED_BY |
ACTIVITY_STATUS | Activity status |
ACTIVITY_RESULT_CODE | Value of activity result |
ASSIGNED_USER | Role assigned at runtime |
NOTIFICATION_ID | Notification identifier |
BEGIN_DATE | Activity's start date |
END_DATE | Activity's end date |
Application Object Library - WF_ITEM_ATTRIBUTES | Stores item attribute definitions |
---|---|
Column Name | Descritpion |
ITEM_TYPE | Internal name for the item type that owns the attribute |
NUMBER_DEFAULT | Default value if type is number |
DATE_DEFAULT | Default value if type is date |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
NAME | Internal name of the attribute |
SEQUENCE | Order of the attribute within the message |
TYPE | Type of attribute |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
SUBTYPE | Determines if attribute is send or respond |
FORMAT | Format mask or Lookup type |
TEXT_DEFAULT | Default value if type is text |
Application Object Library - WF_ITEM_ATTRIBUTES_TL | Translations for WF_ITEM_ATTRIBUTES |
---|---|
Column Name | Descritpion |
ITEM_TYPE | Internal name for the Item Type |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
NAME | Internal name |
LANGUAGE | Language |
DISPLAY_NAME | Name displayed to the user |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
DESCRIPTION | Description |
Application Object Library - WF_ITEM_ATTRIBUTE_VALUES | Contains values for item attributes |
---|---|
Column Name | Descritpion |
ITEM_KEY | Holds the primary key generated for the item type |
NAME | Internal name of attribute |
TEXT_VALUE | Value of the Text attribute |
NUMBER_VALUE | Value of the Number attribute |
DATE_VALUE | Value of the Date attribute |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
ITEM_TYPE | Internal name for the Item Type |
Application Object Library - WF_ITEM_TYPES | Item type definition |
---|---|
Column Name | Descritpion |
NAME | Internal name of the item type |
PERSISTENCE_TYPE | Indicates whether item type is temporary or permanent |
PERSISTENCE_DAYS | Number of days until purge if persistence is temporary |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
WF_SELECTOR | Selector function |
READ_ROLE | Not currently used |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
NUM_ACTIVE | Active Work Items |
WRITE_ROLE | Not currently used |
NUM_ERROR | Errored Work Items |
NUM_DEFER | Deferred Work Items |
EXECUTE_ROLE | Not currently used |
NUM_SUSPEND | Suspended Work Items |
NUM_COMPLETE | Completed Work Items |
NUM_PURGEABLE | Purgeable Work Items |
Application Object Library - WF_ITEM_TYPES_TL | Translations for WF_ITEM_TYPES |
---|---|
Column Name | Descritpion |
NAME | Internal name of the item type |
LANGUAGE | Language |
DISPLAY_NAME | Display name of the item type |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
DESCRIPTION | Description |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
Application Object Library - WF_ITEMS | Workflow runtime table |
---|---|
Column Name | Descritpion |
ITEM_TYPE | Internal name for the Item Type |
END_DATE | Date finished |
USER_KEY | User friendly key |
HA_MIGRATION_FLAG | Supports Workflow migration for the High Availability project. |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
ITEM_KEY | Holds the primary key generated for the item type |
ROOT_ACTIVITY | Top level proces it is running |
ROOT_ACTIVITY_VERSION | Version of the top level process |
OWNER_ROLE | Role of user who launched process |
PARENT_ITEM_TYPE | Identifies components of the parent process |
PARENT_ITEM_KEY | Identifies components of the parent process |
PARENT_CONTEXT | Identifies components of the parent process |
BEGIN_DATE | Start date |
Application Object Library - WF_LOOKUPS_TL | Translations for WF_LOOKUPS |
---|---|
Column Name | Descritpion |
LOOKUP_TYPE | QuickCode lookup type |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
LOOKUP_CODE | QuickCode code |
MEANING | QuickCode meaning |
LANGUAGE | Language |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
DESCRIPTION | Description |
Application Object Library - WF_LOOKUP_TYPES_TL | Translations for WF_LOOKUP_TYPES |
---|---|
Column Name | Descritpion |
LOOKUP_TYPE | QuickCode lookup type |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
DISPLAY_NAME | Name displayed to the user |
LANGUAGE | Language |
ITEM_TYPE | Internal name for the Item Type |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
DESCRIPTION | Description |
Application Object Library - WF_MESSAGES | Message definitions |
---|---|
Column Name | Descritpion |
TYPE | Item type that owns the message |
NAME | Internal name of the message |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
DEFAULT_PRIORITY | Priority given to a message |
READ_ROLE | Not currently used |
WRITE_ROLE | Not currently used |
Application Object Library - WF_MESSAGES_TL | Translations for WF_MESSAGES |
---|---|
Column Name | Descritpion |
TYPE | Item type that owns the message |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
HTML_BODY | The html version of the body text of message to be sent |
NAME | Internal name of the message |
LANGUAGE | Language |
DISPLAY_NAME | Message name displayed to the user |
SUBJECT | The subject line of the message |
PROTECT_LEVEL | Level at which the data is protected |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
CUSTOM_LEVEL | Level of user who last updated the row |
DESCRIPTION | Description |
BODY | Body text of message to be sent |
Application Object Library - WF_MESSAGE_ATTRIBUTES | Attributes of the message |
---|---|
Column Name | Descritpion |
MESSAGE_TYPE | Item type of the message |
FORMAT | Format mask or Lookup type |
TEXT_DEFAULT | Default value if type is text |
NUMBER_DEFAULT | Default value if type is number |
DATE_DEFAULT | Default value if type is date |
ATTACH | If attribute is a document or url, indicates if it should be as an attachment in the notication (Y or N) |
MESSAGE_NAME | Internal name of the message |
NAME | Internal name |
SEQUENCE | Order of the attribute within the message |
TYPE | Type of attribute |
SUBTYPE | Indicates if a message is Respond or Send |
VALUE_TYPE | Defines if the default is a constant or a reference to a item attribute |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
Application Object Library - WF_MESSAGE_ATTRIBUTES_TL | Translations for WF_MESSAGE_ATTRIBUTES |
---|---|
Column Name | Descritpion |
MESSAGE_TYPE | Item type of the message |
MESSAGE_NAME | Internal name of the message |
NAME | Internal name |
LANGUAGE | Language |
DISPLAY_NAME | Name displayed to the user |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
DESCRIPTION | Description |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
Application Object Library - WF_NOTIFICATIONS | Runtime table of messages sent |
---|---|
Column Name | Descritpion |
NOTIFICATION_ID | Unique notification identifier |
MESSAGE_TYPE | Item type of the message |
LANGUAGE | Language in which the denormalized values is in |
MORE_INFO_ROLE | More information is requested from this role |
FROM_ROLE | The role that send this notification |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
USER_KEY | User key |
ITEM_KEY | Item Key |
PROTECTED_TEXT_ATTRIBUTE1 | Protected Text Custom Column1 |
PROTECTED_TEXT_ATTRIBUTE2 | Protected Text Custom Column2 |
PROTECTED_TEXT_ATTRIBUTE3 | Protected Text Custom Column3 |
PROTECTED_TEXT_ATTRIBUTE4 | Protected Text Custom Column4 |
MESSAGE_NAME | Internal name of the message |
PROTECTED_TEXT_ATTRIBUTE5 | Protected Text Custom Column5 |
PROTECTED_TEXT_ATTRIBUTE6 | Protected Text Custom Column6 |
PROTECTED_TEXT_ATTRIBUTE7 | Protected Text Custom Column7 |
PROTECTED_TEXT_ATTRIBUTE8 | Protected Text Custom Column8 |
PROTECTED_TEXT_ATTRIBUTE9 | Protected Text Custom Column9 |
PROTECTED_TEXT_ATTRIBUTE10 | Protected Text Custom Column10 |
PROTECTED_FORM_ATTRIBUTE1 | Protected Form Custom Column1 |
PROTECTED_FORM_ATTRIBUTE2 | Protected Form Custom Column2 |
PROTECTED_FORM_ATTRIBUTE3 | Protected Form Custom Column3 |
PROTECTED_FORM_ATTRIBUTE4 | Protected Form Custom Column4 |
RECIPIENT_ROLE | Role of person to receive notification |
PROTECTED_FORM_ATTRIBUTE5 | Protected Form Custom Column5 |
PROTECTED_URL_ATTRIBUTE1 | Protected URL Custom Column1 |
PROTECTED_URL_ATTRIBUTE2 | Protected URL Custom Column2 |
PROTECTED_URL_ATTRIBUTE3 | Protected URL Custom Column3 |
PROTECTED_URL_ATTRIBUTE4 | Protected URL Custom Column4 |
PROTECTED_URL_ATTRIBUTE5 | Protected URL Custom Column5 |
PROTECTED_DATE_ATTRIBUTE1 | Protected Date Custom Column1 |
PROTECTED_DATE_ATTRIBUTE2 | Protected Date Custom Column2 |
PROTECTED_DATE_ATTRIBUTE3 | Protected Date Custom Column3 |
PROTECTED_DATE_ATTRIBUTE4 | Protected Date Custom Column4 |
STATUS | Determines whether the notification is open or closed |
PROTECTED_DATE_ATTRIBUTE5 | Protected Date Custom Column5 |
PROTECTED_NUMBER_ATTRIBUTE1 | Protected Number Custom Column1 |
PROTECTED_NUMBER_ATTRIBUTE2 | Protected Number Custom Column2 |
PROTECTED_NUMBER_ATTRIBUTE3 | Protected Number Custom Column3 |
PROTECTED_NUMBER_ATTRIBUTE4 | Protected Number Custom Column4 |
PROTECTED_NUMBER_ATTRIBUTE5 | Protected Number Custom Column5 |
TEXT_ATTRIBUTE1 | Text Custom Column1 |
TEXT_ATTRIBUTE2 | Text Custom Column2 |
TEXT_ATTRIBUTE3 | Text Custom Column3 |
TEXT_ATTRIBUTE4 | Text Custom Column4 |
TEXT_ATTRIBUTE5 | Text Custom Column5 |
ACCESS_KEY | Access key for notifications |
TEXT_ATTRIBUTE6 | Text Custom Column6 |
TEXT_ATTRIBUTE7 | Text Custom Column7 |
TEXT_ATTRIBUTE8 | Text Custom Column8 |
TEXT_ATTRIBUTE9 | Text Custom Column9 |
TEXT_ATTRIBUTE10 | Text Custom Column10 |
FORM_ATTRIBUTE1 | Text Custom Column1 |
FORM_ATTRIBUTE2 | Text Custom Column2 |
FORM_ATTRIBUTE3 | Text Custom Column3 |
FORM_ATTRIBUTE4 | Text Custom Column4 |
FORM_ATTRIBUTE5 | Text Custom Column5 |
MAIL_STATUS | Status tells mailer if it should send, and mailer records the result here if sent operation is successful |
URL_ATTRIBUTE1 | Text Custom Column1 |
URL_ATTRIBUTE2 | Text Custom Column2 |
URL_ATTRIBUTE3 | Text Custom Column3 |
URL_ATTRIBUTE4 | Text Custom Column4 |
URL_ATTRIBUTE5 | Text Custom Column5 |
DATE_ATTRIBUTE1 | Date Custom Column1 |
DATE_ATTRIBUTE2 | Date Custom Column2 |
DATE_ATTRIBUTE3 | Date Custom Column3 |
DATE_ATTRIBUTE4 | Date Custom Column4 |
DATE_ATTRIBUTE5 | Date Custom Column5 |
PRIORITY | Priority assigned to the message (1-100) |
NUMBER_ATTRIBUTE1 | Number Custom Column1 |
NUMBER_ATTRIBUTE2 | Number Custom Column2 |
NUMBER_ATTRIBUTE3 | Number Custom Column3 |
NUMBER_ATTRIBUTE4 | Number Custom Column4 |
NUMBER_ATTRIBUTE5 | Number Custom Column5 |
BEGIN_DATE | Start date |
GROUP_ID | Grouping of notifications |
END_DATE | Date finished |
DUE_DATE | Indicates the reply-by date |
RESPONDER | Role or e-mail address that responded to a notification |
USER_COMMENT | User comment |
CALLBACK | Package and procedure name used by the notification |
CONTEXT | Data used by callback to call the procedure |
ORIGINAL_RECIPIENT | Original recipient (as opposed to forwarded recipient) |
FROM_USER | Denormalized value (display name) of FROM_ROLE |
TO_USER | Denormalized value of RECIPEINT_ROLE |
SUBJECT | Denormalized value of subject |
Application Object Library - WF_NOTIFICATION_ATTRIBUTES | Notification attributes created when a message is sent |
---|---|
Column Name | Descritpion |
NAME | Internal name |
TEXT_VALUE | Holds a value if the type is text |
NUMBER_VALUE | Holds a value if the type is number |
DATE_VALUE | Holds a value if the type is date |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
NOTIFICATION_ID | Unique notification identifier |
Application Object Library - WF_PROCESS_ACTIVITIES | Activity data within a process |
---|---|
Column Name | Descritpion |
PROCESS_NAME | Name of the process |
PROCESS_VERSION | Version of the process |
ACTIVITY_ITEM_TYPE | Item type of the activity |
ACTIVITY_NAME | Internal name of the activity |
INSTANCE_ID | Instance ID of an activity used more than once in a process |
INSTANCE_LABEL | Unique name for an activity in a process |
PERFORM_ROLE_TYPE | A constant or an attribute |
PROTECT_LEVEL | Level at which the data is protected |
PROCESS_ITEM_TYPE | Item type of the process |
CUSTOM_LEVEL | Level of user who last updated the row |
START_END | Indicates if an activity is a Start or End activity |
DEFAULT_RESULT | Default result if no result is returned |
ICON_GEOMETRY | Geometry placement of an activity icon in a Workflow diagram |
PERFORM_ROLE | The role a notification is sent to |
USER_COMMENT | User comments |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
Application Object Library - WF_RESOURCES | Internal messages table |
---|---|
Column Name | Descritpion |
NAME | Internal name |
LANGUAGE | Language |
ID | Unique identifier |
TEXT | Text of the message |
PROTECT_LEVEL | Level at which the data is protected |
CUSTOM_LEVEL | Level of user who last updated the row |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
TYPE | Type of resource |
Application Object Library - WF_LOCAL_ROLES | Local Roles table |
---|---|
Column Name | Descritpion |
NAME | Internal name |
ORIG_SYSTEM_ID | |
START_DATE | |
STATUS | Indicates if available to participate in a workflow process |
EXPIRATION_DATE | Date workflow role expires |
PARENT_ORIG_SYSTEM | |
PARENT_ORIG_SYSTEM_ID | |
OWNER_TAG | |
DISPLAY_NAME | Name displayed to the user |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
DESCRIPTION | Description |
NOTIFICATION_PREFERENCE | Preferred notification delivery method |
LANGUAGE | Language |
TERRITORY | Territory |
EMAIL_ADDRESS | E-mail address |
FAX | FAX number |
ORIG_SYSTEM |
Application Object Library - WF_LOCAL_USERS | Local Users table |
---|---|
Column Name | Descritpion |
DISPLAY_NAME | Name displayed to the user |
DESCRIPTION | Description |
NOTIFICATION_PREFERENCE | Preferred notification delivery method |
LANGUAGE | Language |
TERRITORY | Territory |
FAX | FAX number |
STATUS | Indicates if available to participate in a workflow process |
NAME | Internal name |
EXPIRATION_DATE | Date workflow user expires |
ORIG_SYSTEM | |
ORIG_SYSTEM_ID | |
START_DATE | |
EMAIL_ADDRESS | E-mail address |
Application Object Library - WF_LOCAL_USER_ROLES | Local User Roles table |
---|---|
Column Name | Descritpion |
USER_NAME | User name |
OWNER_TAG | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
ASSIGNMENT_TYPE | |
PARENT_ORIG_SYSTEM | |
PARENT_ORIG_SYSTEM_ID | |
ROLE_NAME | Internal name of the role |
USER_START_DATE | |
ROLE_START_DATE | |
USER_END_DATE | |
ROLE_END_DATE | |
EFFECTIVE_START_DATE | |
EFFECTIVE_END_DATE | |
ASSIGNMENT_REASON | |
USER_ORIG_SYSTEM | Identifies the source of the user name |
USER_ORIG_SYSTEM_ID | Unique identifier of user in the orginal system |
ROLE_ORIG_SYSTEM | Identifies the source of the role name |
ROLE_ORIG_SYSTEM_ID | Unique identifier of the role in the original system |
START_DATE | |
EXPIRATION_DATE |
Application Object Library - WF_ROUTING_RULE_ATTRIBUTES | Attributes for notification routing rules. |
---|---|
Column Name | Descritpion |
NAME | Name of the attribute |
TYPE | Type of attribute, either number, date or text |
TEXT_VALUE | The text value |
NUMBER_VALUE | The number value |
DATE_VALUE | The date value |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
RULE_ID | Internal Id and foreign key to WF_ROUTING_RULES |
Application Object Library - WF_ROUTING_RULES | User defined rules for processing notifications |
---|---|
Column Name | Descritpion |
ROLE | Owner of rule |
ACTION | Action to take (either forward, respond or ignore) |
BEGIN_DATE | Start date |
END_DATE | Date finished |
MESSAGE_TYPE | foreign key to WF_MESSAGES |
MESSAGE_NAME | Foreign key to WF_MESSAGES |
ACTION_ARGUMENT | Currently only of use for forward actions (stores the name of who to forward to) |
RULE_COMMENT | User defined comment |
RULE_ID | Internal Identifier |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
Application Object Library - WF_WORKLIST_COL_DEFINITIONS | Workflow Customized Worklist Column Definitions |
---|---|
Column Name | Descritpion |
USERNAME | Internal name of workflow user |
DEFINITION_NAME | Name of customized worklist |
COLUMN_NUMBER | Order in which column is displayed |
COLUMN_NAME | Name of column |
COLUMN_SIZE | Reserved for future use |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PLUG_ID | Unique identifier of homepage region |
Application Object Library - WF_WORKLIST_DEFINITIONS | Workflow Customized Worklist Selection Criteria |
---|---|
Column Name | Descritpion |
USERNAME | Internal name of workflow user |
DEFINITION_NAME | Name of customized worklist |
WHERE_STATUS | Message is open (OPEN) or not open (*) |
WHERE_FROM | Name of workflow user that sent the message |
WHERE_ITEM_TYPE | Internal name of item type of message |
WHERE_NOTIF_TYPE | Notification type of message |
WHERE_SUBJECT | Character string contained in message subject |
WHERE_SENT_START | Message sent after this date |
PLUG_ID | Unique identifier of homepage region |
WHERE_SENT_END | Message sent before this date |
WHERE_DUE_START | Message due after this date |
WHERE_DUE_END | Message due before this date |
WHERE_PRIORITY | Priority assigned to message (1 - 100) |
WHERE_NOTIF_DEL_BY_ME | Flag to indicate if message was delegated by user |
ORDER_PRIMARY | Name of column used to sort messages |
ORDER_ASC_DESC | Sort order ascending (ASC) or descending (DESC) |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
Application Object Library - WF_LOCAL_LANGUAGES | Local languages table |
---|---|
Column Name | Descritpion |
CODE | Language code |
DISPLAY_NAME | Name displayed to the user |
NLS_LANGUAGE | Default convention used |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
NLS_TERRITORY | Default convention used |
NLS_CODESET | Default convention used |
INSTALLED_FLAG | Indicates if language is installed |
Application Object Library - WF_QUEUES | Workflow Generic Queues |
---|---|
Column Name | Descritpion |
INBOUND_OUTBOUND | Queue Direction specifier |
DESCRIPTION | Queue Description |
QUEUE_COUNT | Number of Queus for protocol and direction |
DISABLE_FLAG | Queue Enabled flag |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PROTOCOL | Protocol Identifier |
Application Object Library - WF_AGENTS | Agent definitions for Business Event System |
---|---|
Column Name | Descritpion |
GUID | Global Unique ID |
DISPLAY_NAME | Display name of this agent |
DESCRIPTION | Description of this agent |
TYPE | type of the agent which could be AGENT or GROUP |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
JAVA_QUEUE_HANDLER | JAVA_QUEUE_HANDLER |
NUM_READY | Number of Ready Messages |
NUM_WAITING | Number of Waiting Messages |
NUM_EXPIRED | Number of Expired Messages |
NUM_UNDELIV | Number of Undelivered Messages |
NUM_ERROR | Number of Errored Messages |
NUM_PROCESS | Number of Processed Messages |
NAME | Agent Name |
SYSTEM_GUID | System global unique id that this agent belongs to |
PROTOCOL | Protocol of this agent like SQLNET, SMTP or HTTP |
ADDRESS | Send or retrieve message from this address |
QUEUE_HANDLER | Package or program that knows how to translate a queue payload to an event payload |
QUEUE_NAME | Advanced Queue Name |
DIRECTION | Direction of the agent like IN or OUT |
STATUS | Status of the agent which could be ENABLED or DISABLED |
Application Object Library - WF_EVENTS | Event definitions for Business Event System |
---|---|
Column Name | Descritpion |
NAME | Event Name |
TYPE | Type of event which could be EVENT or GROUP |
STATUS | Status of event which could be ENABLED OR DISABLED |
GENERATE_FUNCTION | Function to generate the message body of such event |
OWNER_NAME | Event owner name which usually is the product name |
OWNER_TAG | Event owner tag which usually is the product short code |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
CUSTOMIZATION_LEVEL | CUSTOMIZATION_LEVEL |
GUID | Global Unique ID |
LICENSED_FLAG | LICENSED_FLAG |
JAVA_GENERATE_FUNC | JAVA_GENERATE_FUNC |
IREP_ANNOTATION | Business Event Annotation |
Application Object Library - WF_EVENTS_TL | Translatable portions of events for Business Event System |
---|---|
Column Name | Descritpion |
LANGUAGE | Language code that indicates what language these columns are in |
DISPLAY_NAME | Display name of event |
DESCRIPTION | Description of event |
SOURCE_LANG | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
GUID | Global Unique ID |
Application Object Library - WF_EVENT_GROUPS | Groups of events for Business Event System |
---|---|
Column Name | Descritpion |
MEMBER_GUID | Event global unique id that belongs to above group |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
GROUP_GUID | Event group global unique id |
Application Object Library - WF_EVENT_SUBSCRIPTIONS | Subscription for Business Event System |
---|---|
Column Name | Descritpion |
SYSTEM_GUID | System that this subscription should take action |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
CUSTOMIZATION_LEVEL | CUSTOMIZATION_LEVEL |
LICENSED_FLAG | LICENSED_FLAG |
INVOCATION_ID | INVOCATION_ID |
MAP_CODE | MAP_CODE |
STANDARD_TYPE | STANDARD_TYPE |
STANDARD_CODE | STANDARD_CODE |
JAVA_RULE_FUNC | JAVA_RULE_FUNC |
ON_ERROR_CODE | ON_ERROR_CODE |
ACTION_CODE | ACTION_CODE |
SOURCE_TYPE | Where the event comes from like ERROR, EXTERNAL or LOCAL |
SOURCE_AGENT_GUID | From which agent the event comes from |
EVENT_FILTER_GUID | What event this subscription is interested in |
PHASE | Order of subscriptions to take place when there are multiple subscriptions on an event. when phase is 100 or above, the subscription is considered deferred. |
STATUS | Subscription status which could be ENALBLED or DISABLED. |
RULE_DATA | Data that the rule function is interested in which could be KEY or MESSAGE |
OUT_AGENT_GUID | Send the event to this agent |
GUID | Event subscription global unique id |
TO_AGENT_GUID | Retrive event from this agent |
PRIORITY | Subscription priority |
RULE_FUNCTION | Function to be run for this subscription |
WF_PROCESS_TYPE | Item type of a workflow to be invoked |
WF_PROCESS_NAME | Process in above item type to be invoked |
PARAMETERS | Parameters to be passed in |
OWNER_NAME | Subscription owner name which usually is the product name |
OWNER_TAG | Subscription owner tag wich usually is the product short code |
DESCRIPTION | Description of the subscription |
EXPRESSION | something that will be evaluated at runtime to further restrict if an event subscription rule applied |
Application Object Library - WF_SYSTEMS | System definitions for Business Event System |
---|---|
Column Name | Descritpion |
NAME | System name |
MASTER_GUID | Global unique id of the master system it belongs to |
DISPLAY_NAME | Display name of system |
DESCRIPTION | Description of system |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
GUID | System global unique id |
Application Object Library - WF_AGENT_GROUPS | Agent Group Relations |
---|---|
Column Name | Descritpion |
MEMBER_GUID | global unique id for member agent. |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
GROUP_GUID | global unique id for group. |
Application Object Library - WF_MAILER_PARAMETERS | Workflow Mailer parameter table to replace wfmail.cfg file |
---|---|
Column Name | Descritpion |
PARAMETER | Name for the parameter |
VALUE | Value of theparameter |
REQUIRED | Flag to indicate if the parameter is required or manditory |
CB | Call back function to validate the value of the parameter |
ALLOW_RELOAD | Flag to indicate if the mailer can reload the parameter at runtime |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
NAME | Instance name for the maile |
Application Object Library - WF_MAILER_TAGS | Workflow Mailer Tag table to replace wfmail.tag file |
---|---|
Column Name | Descritpion |
TAG_ID | Numeric ID for a tag within a mailer instance |
ACTION | The action for the mailer to take on matching a PATTERN |
PATTERN | The pattern to search for in the incoming email |
ALLOW_RELOAD | Flag to indicate if the mailer can reload the parameter at runtime |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
NAME | Instance name for the mailer |
Application Object Library - WF_ATTRIBUTE_CACHE | This table is used to store attribute name / attribute value pairs for entities. |
---|---|
Column Name | Descritpion |
ENTITY_KEY_VALUE | The entity's primary key. |
ATTRIBUTE_NAME | The name of the attribute. |
ATTRIBUTE_VALUE | The attribute's value. |
LAST_UPDATE_DATE | Timestamp of last change |
CHANGE_NUMBER | Tag used to group like updates |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
ENTITY_TYPE | The type of entity. |
Application Object Library - WF_COMMENTS | This is a table for notification comments |
---|---|
Column Name | Descritpion |
FROM_ROLE | the role that make the comment |
FROM_USER | display name of the above role |
COMMENT_DATE | date to make that comment |
ACTION | action can be 'QUESTION','ANSWER','TRANSFER','FORWARD','CANCEL' and 'RESPOND' |
USER_COMMENT | the comment entered by user |
LANGUAGE | the language code for FROM_USER |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
TO_ROLE | TO_ROLE |
NOTIFICATION_ID | it is foreign key to that in WF_NOTIFICATIONS table |
TO_USER | TO_USER |
PROXY_ROLE | PROXY_ROLE |
ACTION_TYPE | ACTION_TYPE |
SEQUENCE | Sequence number for Notification Comments |
Application Object Library - WF_DIG_CAS | certificate authorities table |
---|---|
Column Name | Descritpion |
CA_URL | url for authority |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
CA_NAME | name of authority |
Application Object Library - WF_DIG_CERTS | digital certificates table |
---|---|
Column Name | Descritpion |
CERT_ID | certificate ID |
CERT_TYPE | type of certificate |
PARENT_CERT_ID | pointer to parent certificate |
OWNER_ID | id of entity associated |
OWNER_DOMAIN | type of entity associated with certificate |
VALID | valid flag |
SOT_FLAG | source of truth flag |
INTERMEDIATE_FLAG | intermediate flag |
CERT | certificate data |
FINGERPRINT | fingerprint of certificate |
EXPIRE | expire date |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
SUBJECTDN | The subject name of the certificate |
Application Object Library - WF_DIG_CRLS | certificate revocation lists table |
---|---|
Column Name | Descritpion |
ISSUE_DATE | date issued |
CRL_DATA | CRL data |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
NEXT_ISSUE_DATE | Next issue date of the crl |
ISSUER | The issuer of the crl |
CRL_ID | ID of certificate revocation list |
Application Object Library - WF_DIG_SIGS | digital signatures table |
---|---|
Column Name | Descritpion |
SIG_ID | signature id |
REQUESTED_SIGNER_ID | id of signer requested |
STATUS | status |
CREATION_DATE | sig created on |
SIGNED_DATE | sig signed on |
VERIFIED_DATE | sig verified on |
LAST_VALIDATION_ATTEMPT | attempted validation of sig last time on |
VALIDATED_COMPLETE_DATE | actually validated on |
ERRBUF | error info |
ERRSTACK | error info |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
CERT_ID | certificate id for signature |
SIG_POLICY | signature policy used |
SIG_FLAVOR | signature flavor |
SIG_OBJ_TYPE | object type associated with sig |
SIG_OBJ_ID | id of object associated with sig |
PLAINTEXT | text to be signed |
SIGNATURE | signature data |
REQUESTED_SIGNER_TYPE | type of signer requested |
Application Object Library - WF_DIG_SIG_SPI_FLAVORS | digital signature service provider interface info table |
---|---|
Column Name | Descritpion |
VERIFY_SPI | Verifier SPI |
VALIDATE_SPI | Validator SPI |
CERT_MAPPER | Certificate mapper |
FLAVOR | Type of Technology |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
BSR_FWK_CO | OA Framework Controller for BSR |
VALIDATOR_STORE | Name of the validator Store |
VALIDATION_MODE | Mode of validation |
BSR_SPI | Browser Sign Request SPI |
SIGNATURE_FORMAT | new column for signature format |
SIGNATURE_MODE | new column for signature mode |
Application Object Library - WF_BES_SUBSCRIBER_PINGS | This table contains one row for each ping for each queue subscriber |
---|---|
Column Name | Descritpion |
PING_TIME | The time the ping was sent |
QUEUE_NAME | The queue name |
SUBSCRIBER_NAME | The subscriber name |
STATUS | The status |
ACTION_TIME | The time corresponding to the status |
SECURITY_GROUP_ID | identifier reserved for hosting environment |
PING_NUMBER | The ping number |
Application Object Library - WF_ENTITY_CHANGES | Stores pending changes for OID |
---|---|
Column Name | Descritpion |
ENTITY_KEY_VALUE | The identifying key value for this entity |
FLAVOR | Specifies what kind of entity this is |
CHANGE_DATE | Specifies when this entity change was 'enqueued' |
ENTITY_ID | Sequence Number generated for OID at runtime |
ENTITY_TYPE | Specifies entity type |
Application Object Library - WF_DIRECTORY_PARTITIONS | Lookup table for orig system in partitioned tables. |
---|---|
Column Name | Descritpion |
PARTITION_ID | partition identifier |
ORIG_SYSTEM | Original System |
SECURITY_GROUP_ID | ID used in VPD for hosting |
ROLE_VIEW | |
USER_ROLE_VIEW | |
ROLE_TL_VIEW | |
BULKSYNC_DATE | |
SUMMARY_DATE | |
LAST_UPDATE_DATE |
Application Object Library - WF_DIRECTORY_PARTITIONS_TL | Translated Directory Partitions |
---|---|
Column Name | Descritpion |
DISPLAY_NAME | Display Name for Orig System |
LANGUAGE | Language Code For Orig System |
SOURCE_LANG | Language Code Indicates where the translated values are from |
SECURITY_GROUP_ID | |
ORIG_SYSTEM | ORIGINAL SYSTEM |
Application Object Library - UMX_REG_SERVICES_TL | Translation table for UMX_REG_SERVICES_B |
---|---|
Column Name | Descritpion |
REG_SERVICE_CODE | Registration Process Identifier |
LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
SECURITY_GROUP_ID | |
USAGE | Usage Description |
LANGUAGE | Language |
SOURCE_LANG | |
DISPLAY_NAME | Display Name |
DESCRIPTION | End User Description |
CREATION_DATE | Standard who column - date when this row was created. |
CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
Application Object Library - UMX_REG_SERVICES_B | Stores metadata for various registration processes available through the Oracle User Management module. |
---|---|
Column Name | Descritpion |
CREATION_DATE | Standard who column - date when this row was created. |
LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
SECURITY_GROUP_ID | |
END_DATE | End Date |
WF_ROLE_NAME | WF Role Code |
REG_FUNCTION_ID | Registration Function Id |
AME_APPLICATION_ID | Approval Transaction Type Application Id |
AME_TRANSACTION_TYPE_ID | Approval Manager Transaction Type |
REG_SERVICE_CODE | Registration Process Identifier |
REG_SERVICE_TYPE | Registration Process Type |
WF_NOTIFICATION_EVENT_GUID | Notifications (Business Event) |
WF_BUS_LOGIC_EVENT_GUID | Business Logic (Business Event) |
EMAIL_VERIFICATION_FLAG | Enable Identity Verification |
APPLICATION_ID | Application Id |
START_DATE | Start Date |
CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
Application Object Library - WF_LOCAL_ROLES_OLD | |
---|---|
Column Name | Descritpion |
NAME | |
ORIG_SYSTEM_ID | |
START_DATE | |
STATUS | |
EXPIRATION_DATE | |
SECURITY_GROUP_ID | |
USER_FLAG | |
PARTITION_ID | |
PARENT_ORIG_SYSTEM | |
PARENT_ORIG_SYSTEM_ID | |
OWNER_TAG | |
DISPLAY_NAME | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
DESCRIPTION | |
NOTIFICATION_PREFERENCE | |
LANGUAGE | |
TERRITORY | |
EMAIL_ADDRESS | |
FAX | |
ORIG_SYSTEM |
Application Object Library - WF_LOCAL_ROLES_STAGE | |
---|---|
Column Name | Descritpion |
PARENT_ORIG_SYSTEM | |
PARENT_ORIG_SYSTEM_ID | |
OWNER_TAG | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN |
Application Object Library - WF_LOCAL_ROLES_TL_STAGE | |
---|---|
Column Name | Descritpion |
NAME | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
DISPLAY_NAME | |
DESCRIPTION | |
ORIG_SYSTEM | |
ORIG_SYSTEM_ID | |
PARTITION_ID | |
LANGUAGE | |
OWNER_TAG | |
CREATED_BY |
Application Object Library - UMX_REG_REQUESTS | Stores information about registration requests |
---|---|
Column Name | Descritpion |
REG_REQUEST_ID | Request Id |
AME_TRANSACTION_TYPE_ID | The approval routing rules identifier (defined in Oracle Approval Manager - AME) for this request |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
SECURITY_GROUP_ID | Security Group |
JUSTIFICATION | Justification / reason for the request, provided by the requester |
REG_SERVICE_TYPE | The type of registration process for this request |
STATUS_CODE | Status of the request |
REQUESTED_BY_USER_ID | What user submitted this request |
REQUESTED_FOR_USER_ID | On what user's behalf was this request submitted |
REQUESTED_FOR_PARTY_ID | On what person's behalf was this request submitted |
REQUESTED_USERNAME | The User Name being requested |
REQUESTED_END_DATE | |
REQUESTED_START_DATE | |
WF_ROLE_NAME | The role being requested |
REG_SERVICE_CODE | The registration process for this request |
AME_APPLICATION_ID | Application that owns the approval routing rules (defined in Oracle Approval Manager - AME)for this request |
Application Object Library - WF_LOCAL_USER_ROLES_STAGE | |
---|---|
Column Name | Descritpion |
USER_NAME | |
PARTITION_ID | |
OWNER_TAG | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
ASSIGNMENT_TYPE | |
PARENT_ORIG_SYSTEM | |
PARENT_ORIG_SYSTEM_ID | |
ROLE_NAME | |
USER_START_DATE | |
ROLE_START_DATE | |
USER_END_DATE | |
ROLE_END_DATE | |
EFFECTIVE_START_DATE | |
EFFECTIVE_END_DATE | |
ASSIGNMENT_REASON | |
USER_ORIG_SYSTEM | |
USER_ORIG_SYSTEM_ID | |
ROLE_ORIG_SYSTEM | |
ROLE_ORIG_SYSTEM_ID | |
START_DATE | |
EXPIRATION_DATE | |
SECURITY_GROUP_ID |
Application Object Library - WF_LOCAL_ROLES_TL | |
---|---|
Column Name | Descritpion |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
OWNER_TAG | |
CREATED_BY |
Application Object Library - WF_LOCAL_USER_ROLES_OLD | |
---|---|
Column Name | Descritpion |
USER_NAME | |
PARTITION_ID | |
OWNER_TAG | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
ASSIGNMENT_TYPE | |
PARENT_ORIG_SYSTEM | |
PARENT_ORIG_SYSTEM_ID | |
ROLE_NAME | |
USER_ORIG_SYSTEM | |
USER_ORIG_SYSTEM_ID | |
ROLE_ORIG_SYSTEM | |
ROLE_ORIG_SYSTEM_ID | |
START_DATE | |
EXPIRATION_DATE | |
SECURITY_GROUP_ID |
Application Object Library - WF_UR_ASSIGNMENTS_STAGE | |
---|---|
Column Name | Descritpion |
USER_NAME | |
LAST_UPDATE_DATE | |
LAST_UPDATE_LOGIN | |
USER_START_DATE | |
ROLE_START_DATE | |
ASSIGNING_ROLE_START_DATE | |
USER_END_DATE | |
ROLE_END_DATE | |
ASSIGNING_ROLE_END_DATE | |
PARTITION_ID | |
EFFECTIVE_START_DATE | |
ROLE_NAME | |
EFFECTIVE_END_DATE | |
USER_ORIG_SYSTEM | |
USER_ORIG_SYSTEM_ID | |
ROLE_ORIG_SYSTEM | |
ROLE_ORIG_SYSTEM_ID | |
PARENT_ORIG_SYSTEM | |
PARENT_ORIG_SYSTEM_ID | |
OWNER_TAG | |
ASSIGNMENT_REASON | |
RELATIONSHIP_ID | |
ASSIGNING_ROLE | |
START_DATE | |
END_DATE | |
CREATED_BY | |
CREATION_DATE | |
LAST_UPDATED_BY |
Application Object Library - WF_USER_ROLE_ASSIGNMENTS | |
---|---|
Column Name | Descritpion |
EFFECTIVE_START_DATE | |
EFFECTIVE_END_DATE | |
USER_ORIG_SYSTEM | |
USER_ORIG_SYSTEM_ID | |
ROLE_ORIG_SYSTEM | |
ROLE_ORIG_SYSTEM_ID | |
PARENT_ORIG_SYSTEM | |
PARENT_ORIG_SYSTEM_ID | |
OWNER_TAG | |
ASSIGNMENT_REASON |
Application Object Library - WF_NTF_SECURITY_POLICIES | Table for storing the security policies |
---|---|
Column Name | Descritpion |
EMAIL_ALLOWED | Specifies whether email is allowed for the corresponding policy name |
POLICY_NAME | Security Policy Name |
Application Object Library - WF_SIGNATURE_POLICIES | table for storing the signature policies |
---|---|
Column Name | Descritpion |
SIG_REQUIRED | If the signature is required for this sig policy |
FWK_SIG_FLAVOR | framework signature flavor |
EMAIL_SIG_FLAVOR | email signature flavour |
RENDER_HINT | hint on how to construct the text to be signed |
VALIDATION_OFFSET_TIME | The offset time in hours to be added bfore validation |
DEFAULT_POLICY | new column Y/N to flag default policy |
SIG_POLICY | Sinature policy |
Application Object Library - WF_NTF_RULES | |
---|---|
Column Name | Descritpion |
OWNER_TAG | |
OWNER_NAME | |
CREATION_DATE | |
RULE_NAME | |
CUSTOMIZATION_LEVEL | |
PHASE | |
STATUS |
Application Object Library - WF_NTF_RULES_TL | |
---|---|
Column Name | Descritpion |
OWNER_TAG | |
CREATION_DATE | |
RULE_NAME | |
USER_RULE_NAME | |
DESCRIPTION | |
LANGUAGE | |
SOURCE_LANG |
Application Object Library - WF_UR_VALIDATE_STG | |
---|---|
Column Name | Descritpion |
WURA_ID | |
USER_START_DATE | |
USER_END_DATE | |
ROLE_ORIG_SYSTEM | |
ROLE_ORIG_SYSTEM_ID | |
USER_ORIG_SYSTEM | |
USER_ORIG_SYSTEM_ID | |
ASSIGNING_ROLE_START_DATE | |
ASSIGNING_ROLE_END_DATE | |
EFFECTIVE_START_DATE | |
EFFECTIVE_END_DATE | |
WUR_ID | |
RELATIONSHIP_ID | |
ROLE_NAME | |
USER_NAME | |
ASSIGNING_ROLE | |
START_DATE | |
END_DATE | |
ROLE_START_DATE | |
ROLE_END_DATE |
Application Object Library - WF_NTF_RULE_MAPS | |
---|---|
Column Name | Descritpion |
RULE_NAME | |
COLUMN_NAME | |
ATTRIBUTE_NAME | |
CREATION_DATE |
Application Object Library - WF_NTF_RULE_CRITERIA | |
---|---|
Column Name | Descritpion |
RULE_NAME | |
MESSAGE_TYPE | |
CREATION_DATE |
Application Object Library - WF_WS_MSG_TRACKING | No longer used |
---|---|
Column Name | Descritpion |
REMOTE_MSGID | Remote Message ID |
ATTRIBUTE5 | attribute5 |
ATTRIBUTE6 | attribute6 |
ATTRIBUTE7 | attribute7 |
ATTRIBUTE8 | attribute8 |
ATTRIBUTE9 | attribute9 |
ATTRIBUTE10 | attribute10 |
ATTRIBUTE11 | attribute11 |
ATTRIBUTE12 | attribute12 |
ATTRIBUTE13 | attribute13 |
ATTRIBUTE14 | attribute14 |
MSGSEQ | Message sequence inside request |
ATTRIBUTE15 | attribute15 |
CREATED_BY | CREATED_BY |
CREATION_DATE | CREATION_DATE |
LAST_UPDATED_BY | LAST_UPDATED_BY |
LAST_UPDATE_DATE | LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN | LAST_UPDATE_LOGIN |
SECURITY_GROUP_ID | SECURITY_GROUP_ID |
DIRECTION | Message direction |
SOURCE_IP | Source IP Address |
TARGET_URI | Target URI |
STATUS | Status |
ERROR_DESC | Error description |
ERROR_DETAIL | Error detail |
START_TIMESTAMP | Start time stamp |
LOCAL_MSGID | Local Message ID |
END_TIMESTAMP | End time stamp |
LANGUAGE | Language |
USERNAME | Username |
ROLE | Role |
INTERFACE | Interface name |
METHOD | Method name |
ATTRIBUTE1 | attribute1 |
ATTRIBUTE2 | attribute2 |
ATTRIBUTE3 | attribute3 |
ATTRIBUTE4 | attribute4 |
Application Object Library - POA_IDL_BS_J_MV | |
---|---|
Column Name | Descritpion |
UMARKER | Union Operator Marker |
COMPANY_ID | Company Identifier |
COST_CENTER_ID | Cost center Identifier |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
DAY_ID | FII Day Identifier |
AMOUNT_B | Invoice Amount in Functional Currency |
AMOUNT_G | Invoice Amount in Global Currency |
AMOUNT_SG | Invoice Amount in Secondary Global Currency |
PO_MATCHED_FLAG | Flag if Invoice is PO Matched or not |
FRID | FRID |
RECEIPT_REQUIRED_FLAG | Indicates whether shipment must be received before the invoice is paid |
VRID | VRID |
VSRID | VSRID |
CRID | CRID |
ORG_ID | Operating Unit Identifier |
SUPPLIER_ID | Supplier Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
INV_D_CREATED_BY | Invoice Distribution Creator Identifier |
Application Object Library - POA_ITEMS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00008$ | |
TRID | TRID |
VRID | VRID |
SYS_NC00007$ | |
PO_ITEM_ID | Purchased Item Identifier |
VENDOR_PRODUCT_NUM | Vendor Item Number |
VENDOR_NAME | Vendor Name |
DESCRIPTION | Item Description |
CATEGORY_ID |
Application Object Library - POA_NEG_000_MV | |
---|---|
Column Name | Descritpion |
UMARKER | Union Marker |
AUCTION_HEADER_ID | Negotiation Header Identifier |
AUCTION_LINE_NUMBER | Negotiation Line Number |
BID_NUMBER | Negotiation Bid Number |
BID_LINE_NUMBER | Negotiation Bid Line Number |
PO_HEADER_ID | PO Header Identifier |
DOCTYPE_ID | Negotiation document type Identifier |
AUCTION_ROUND_NUMBER | Negotiation Round Number |
AUCTION_CREATION_DATE | Negotiation Creation Date |
PUBLISH_DATE | Negotiation Publish Date |
OPEN_BIDDING_DATE | Negotiation Opened for Bidding Date |
CRID | Row Identifier for Time Dimension |
CLOSE_BIDDING_DATE | Negotiation Closed for Bidding Date |
PREV_ROUND_CLOSE_DATE | Negotiation Previous Round Close Date |
NEXT_ROUND_CREATION_DATE | |
AWARD_DATE | Negotiation Award Date |
AWARD_COMPLETE_DATE | Negotiation Award Complete Date |
RFI_COMPLETE_DATE | RFI Complete Date |
ORG_ID | Operating Unit Identifier |
COMMODITY_ID | Commodity Identifier |
NEGOTIATION_CREATOR_ID | Negotiation Creator Identifier |
CATEGORY_ID | Category Identifier |
COMRID | Row Identifier for Commodity Dimension |
PO_ITEM_ID | PO Item Identifier |
SUPPLIER_ID | Supplier Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
QUANTITY | Quantity Specified in Negotiation |
AWARD_QTY | Awarded Quantity |
AWARD_PRICE | Awarded Price |
CURRENT_PRICE | Current Price of Item at the beginning of Negotiation |
AWARD_AMOUNT_T | Awarded Amount in Transactional Currency |
AWARD_AMOUNT_B | Awarded Amount in Functional Currency |
AWARD_AMOUNT_G | Awarded Amount in Global Currency |
FRID | Row Identifier for Negotiations Fact |
AWARD_AMOUNT_SG | Awarded Amount in Secondary Global Currency |
CURRENT_AMOUNT_T | Current Amount in Transactional Currency |
CURRENT_AMOUNT_B | Current Amount in Functional Currency |
CURRENT_AMOUNT_G | Current Amount in Global Currency |
CURRENT_AMOUNT_SG | Current Amount in Secondary Global Currency |
AUCTION_STATUS | Negotiation Status |
AWARD_STATUS | Negotiation Award Status |
ALLOCATION_STATUS | Negotiation Allocation Status |
SUPPLIER_INVITE_DATE | Date on which the Awarded Supplier was invited |
BASE_UOM | Base Unit of Measure |
ENT_YEAR_ID | Enterprise Year Identifier |
CONTRACT_TYPE | Negotiation Outcome Document |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | Week Identifier |
DAY_ID | Day Identifier |
Application Object Library - POA_MID_BS_J_MV | |
---|---|
Column Name | Descritpion |
UMARKER | Union Operator Marker |
ENT_YEAR_ID | Enterprise Year Identifier |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
DAY_ID | FII Day Identifier |
DIST_COUNT | Count of Invoice Distributions |
FRID | FRID |
CRID | CRID |
VRID | VRID |
ORG_ID | Operating Unit Identifier |
SUPPLIER_ID | Supplier Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
INV_D_CREATED_BY | Invoice Distribution Creator Identifier |
SOURCE | Source of Invoice |
Application Object Library - POA_POD_BS_J_MV | |
---|---|
Column Name | Descritpion |
FRID | FRID |
CATEGORY_ID | Category on the PO Line Identifier |
PO_ITEM_ID | Purchased Item Identifier |
BUYER_ID | Buyer Identifier |
SHIPMENT_TYPE | Shipment Type |
COMPANY_ID | Company Identifier |
COST_CENTER_ID | Cost-center Identifier |
ENT_YEAR_ID | |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
CRID | CRID |
DAY_ID | FII Day Identifier |
QUANTITY | Quantity in Base UOM |
PURCHASE_AMT_B | Purchase Amount in Functional Currency |
PURCHASE_AMT_G | Purchase Amount in Global Currency |
PURCHASE_AMT_SG | Purchase Amount in Secondary Global Currency |
P_CONTRACT_AMT_B | Contract Leakage Amount in Functional Currency |
P_CONTRACT_AMT_G | Contract Leakage Amount in Global Currency |
P_CONTRACT_AMT_SG | Contract Leakage Amount in Secondary Global Currency |
N_CONTRACT_AMT_B | Non-Contract Amount in Functional Currency |
N_CONTRACT_AMT_G | Non-Contract Amount in Global Currency |
COMRID | COMRID |
N_CONTRACT_AMT_SG | Non-Contract Amount in Secondary Global Currency |
P_SAVINGS_AMT_B | Potential Savings Amount in Functional Currency |
P_SAVINGS_AMT_G | Potential Savings Amount in Global Currency |
P_SAVINGS_AMT_SG | Potential Savings Amount in Secondary Global Currency |
CONTRACT_AMT_B | Contract Amount in Functional Currency |
CONTRACT_AMT_G | Contract Amount in Global Currency |
CONTRACT_AMT_SG | Contract Amount in secondary Global Currency |
BELOW_CONTRACT_AMT_B | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Functional Currency. |
BELOW_CONTRACT_AMT_G | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Global Currency. |
BELOW_CONTRACT_AMT_SG | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Secondary Global Currency. |
MRID | MRID |
ABOVE_CONTRACT_AMT_B | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Function Currency. |
ABOVE_CONTRACT_AMT_G | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Global Currency. |
ABOVE_CONTRACT_AMT_SG | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in secondary Global Currency. |
CONSIGNED_CODE | Consigned Code - 0 for normal shipment, 1 for consigned shipment, 2 for consumption advice |
NZ_QUANTITY | Non Zero Quantity |
AUCTION_HEADER_ID | Negotiation Header Identifier |
AUCTION_LINE_NUMBER | Negotiation Line Number |
BID_NUMBER | Negotiation Bid Number |
BID_LINE_NUMBER | Negotiation Bid Line Number |
PO_RELEASE_ID | PO Release Identifier |
ORG_ID | Operating Unit Identifier |
PO_HEADER_ID | PO Header Identifier |
NEGOTIATION_CREATOR_ID | Negotiation Creator Identifier |
DOCTYPE_ID | Negotiation Document Type Identifier |
CURRENT_AMT_B | Negotiation Amount at Current Price in functional currency |
CURRENT_AMT_G | Negotiation Amount at Current Price in global currency |
CURRENT_AMT_SG | Negotiation Amount at Current Price in secondary global currency |
CONTRACT_TYPE | 1 for Blkt Releases, 2 for Scheduled Releases, 3 for PO referencing Global Agrmt, 4 for PO with Negotiated Pricing |
COMMODITY_ID | Commodity Identifier |
BASE_UOM | Base UOM |
SUPPLIER_ID | Supplier Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
Application Object Library - POA_REQ_000_MV | |
---|---|
Column Name | Descritpion |
AGGREGATION_LEVEL | Grouping ID Column |
NUM_DAYS_UNPROCESSED | Number of Days since the Requisition Line is Unprocessed |
UNFULFILLED_AMT_B_AGE_B4 | Unfulfilled Amount in Functional Currency in Bucket Range 4 |
UNFULFILLED_AMT_B_AGE_B5 | Unfulfilled Amount in Functional Currency in Bucket Range 5 |
UNFULFILLED_AMT_B_AGE_B6 | Unfulfilled Amount in Functional Currency in Bucket Range 6 |
UNFULFILLED_AMT_B_AGE_B7 | Unfulfilled Amount in Functional Currency in Bucket Range 7 |
UNFULFILLED_AMT_B_AGE_B8 | Unfulfilled Amount in Functional Currency in Bucket Range 8 |
UNFULFILLED_AMT_B_AGE_B9 | Unfulfilled Amount in Functional Currency in Bucket Range 9 |
UNFULFILLED_AMT_B_AGE_B10 | Unfulfilled Amount in Functional Currency in Bucket Range 10 |
UNFULFILLED_AMT_SG_AGE_B1 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 1 |
UNFULFILLED_AMT_SG_AGE_B2 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 2 |
UNFULFILLED_AMT_SG_AGE_B3 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 3 |
NUM_DAYS_UNFULFILLED | Number of Days since the Requisition Line is Unfulfilled |
UNFULFILLED_AMT_SG_AGE_B4 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 4 |
UNFULFILLED_AMT_SG_AGE_B5 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 5 |
UNFULFILLED_AMT_SG_AGE_B6 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 6 |
UNFULFILLED_AMT_SG_AGE_B7 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 7 |
UNFULFILLED_AMT_SG_AGE_B8 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 8 |
UNFULFILLED_AMT_SG_AGE_B9 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 9 |
UNFULFILLED_AMT_SG_AGE_B10 | Unfulfilled Amount in Secondary Global Currency in Bucket Range 10 |
UNFULFILLED_CNT_AGE_B1 | Number of Unfulfilled Requisition Lines in Bucket Range 1 |
UNFULFILLED_CNT_AGE_B2 | Number of Unfulfilled Requisition Lines in Bucket Range 2 |
UNFULFILLED_CNT_AGE_B3 | Number of Unfulfilled Requisition Lines in Bucket Range 3 |
PEN_SRC_AMT_G | Requisition Amount Pending in Sourcing Phase in Global Currency |
UNFULFILLED_CNT_AGE_B4 | Number of Unfulfilled Requisition Lines in Bucket Range 4 |
UNFULFILLED_CNT_AGE_B5 | Number of Unfulfilled Requisition Lines in Bucket Range 5 |
UNFULFILLED_CNT_AGE_B6 | Number of Unfulfilled Requisition Lines in Bucket Range 6 |
UNFULFILLED_CNT_AGE_B7 | Number of Unfulfilled Requisition Lines in Bucket Range 7 |
UNFULFILLED_CNT_AGE_B8 | Number of Unfulfilled Requisition Lines in Bucket Range 8 |
UNFULFILLED_CNT_AGE_B9 | Number of Unfulfilled Requisition Lines in Bucket Range 9 |
UNFULFILLED_CNT_AGE_B10 | Number of Unfulfilled Requisition Lines in Bucket Range 10 |
C_PEN_SRC_AMT_G | Count Columns |
C_PEN_BUYER_WK_AMT_G | Count Columns |
C_PEN_PO_SUBMIT_AMT_G | Count Columns |
PEN_SRC_AMT_B | Requisition Amount Pending in Sourcing Phase in functional Currency |
C_PEN_PO_APPR_AMT_G | Count Columns |
C_UNPROCESSED_AMT_G | Count Columns |
C_PEN_FULFILL_AMT_G | Count Columns |
C_UNFULFILLED_AMT_G | Count Columns |
PEN_SRC_AMT_SG | Requisition Amount Pending in Sourcing Phase in Secondary Global Currency |
PEN_BUYER_WK_AMT_G | Requisition Amount Pending in Buyers Workbench Phase in global Currency |
PEN_BUYER_WK_AMT_B | Requisition Amount Pending in Buyers Workbench Phase in function Currency |
PEN_BUYER_WK_AMT_SG | Requisition Amount Pending in Buyers Workbench Phase in Secondary Global Currency |
PEN_PO_SUBMIT_AMT_G | Requisition Amount Pending Submission for PO Approval in Global Currency |
PEN_PO_SUBMIT_AMT_B | Requisition Amount Pending Submission for PO Approval in functional Currency |
CATEGORY_ID | Category on the PO Line Identifier |
PEN_PO_SUBMIT_AMT_SG | Requisition Amount Pending Submission for PO Approval in Secondary Global Currency |
PEN_PO_APPR_AMT_G | Requisition Amount Pending PO Approval in Global Currency |
PEN_PO_APPR_AMT_B | Requisition Amount Pending PO Approval in functional Currency |
PEN_PO_APPR_AMT_SG | Requisition Amount Pending PO Approval in Secondary Global Currency |
UNPROCESSED_AMT_G | Unprocessed Requisition Amount in Global Currency |
UNPROCESSED_AMT_B | Unprocessed Requisition Amount in functional Currency |
UNPROCESSED_AMT_SG | Unprocessed Requisition Amount in Secondary Global Currency |
PEN_FULFILL_AMT_G | Requisition Amount Pending PO Fulfillment in Global Currency |
PEN_FULFILL_AMT_B | Requisition Amount Pending PO Fulfillment in functional Currency |
PEN_FULFILL_AMT_SG | Requisition Amount Pending PO Fulfillement in Secondary Global Currency |
PO_ITEM_ID | Purchased Item Identifier |
UNFULFILLED_AMT_G | Unfulfilled Requisition Amount in Global Currency |
UNFULFILLED_AMT_B | Unfulfilled Requisition Amount in functional Currency |
UNFULFILLED_AMT_SG | Unfulfilled Requisition Amount in Secondary Global Currency |
PEN_SRC_CNT | Count of Requisition Lines in Pending Sourcing Phase |
PEN_BUYER_WK_CNT | Count of Requisition Lines in Pending Buyers Workbench Phase |
PEN_PO_SUBMIT_CNT | Count of Requisition Lines in Pending PO Submission for Approval Phase |
PEN_PO_APPR_CNT | Count of Requisition Lines in Pending PO Approval Phase |
UNPROCESSED_CNT | Count of Unprocessed Requisition Lines |
PEN_FULFILL_CNT | Count of Pending Fulfillmemt Requisition Lines |
UNFULFILLED_CNT | Count of Unfulfilled Requisition Lines |
SUPPLIER_ID | Supplier Identifier |
UNPROCESSED_PED_CNT | Count of Unprocessed Requisition Lines Past Expected Date |
UNPROCESSED_EMER_CNT | Count of Unprocessed Requisition Lines tagged as Emergency |
UNPROCESSED_URG_CNT | Count of Unprocessed Requisition Lines tagged as Urgent |
UNFULFILLED_PED_CNT | Count of Unfulfilled Requisition Lines Past Expected Date |
UNPROCESSED_QTY | Quantity in Unprocessed Phase |
UNFULFILLED_QTY | Quantity in Unfulfilled Phase |
UNFUL_PO_REVISIONS | Number of PO Revisions for an Unfulfilled Requisition |
UNPROCESSED_AMT_G_AGE_B1 | Unprocessed Amount in Global Currency in Bucket Range 1 |
UNPROCESSED_AMT_G_AGE_B2 | Unprocessed Amount in Global Currency in Bucket Range 2 |
UNPROCESSED_AMT_G_AGE_B3 | Unprocessed Amount in Global Currency in Bucket Range 3 |
BUYER_ID | Buyer Identifier |
UNPROCESSED_AMT_G_AGE_B4 | Unprocessed Amount in Global Currency in Bucket Range 4 |
UNPROCESSED_AMT_G_AGE_B5 | Unprocessed Amount in Global Currency in Bucket Range 5 |
UNPROCESSED_AMT_G_AGE_B6 | Unprocessed Amount in Global Currency in Bucket Range 6 |
UNPROCESSED_AMT_G_AGE_B7 | Unprocessed Amount in Global Currency in Bucket Range 7 |
UNPROCESSED_AMT_G_AGE_B8 | Unprocessed Amount in Global Currency in Bucket Range 8 |
UNPROCESSED_AMT_G_AGE_B9 | Unprocessed Amount in Global Currency in Bucket Range 9 |
UNPROCESSED_AMT_G_AGE_B10 | Unprocessed Amount in Global Currency in Bucket Range 10 |
UNPROCESSED_AMT_B_AGE_B1 | Unprocessed Amount in Functional Currency in Bucket Range 1 |
UNPROCESSED_AMT_B_AGE_B2 | Unprocessed Amount in Functional Currency in Bucket Range 2 |
UNPROCESSED_AMT_B_AGE_B3 | Unprocessed Amount in Functional Currency in Bucket Range 3 |
SHIP_TO_ORG_ID | Ship To Organization Identifier |
UNPROCESSED_AMT_B_AGE_B4 | Unprocessed Amount in Functional Currency in Bucket Range 4 |
UNPROCESSED_AMT_B_AGE_B5 | Unprocessed Amount in Functional Currency in Bucket Range 5 |
UNPROCESSED_AMT_B_AGE_B6 | Unprocessed Amount in Functional Currency in Bucket Range 6 |
UNPROCESSED_AMT_B_AGE_B7 | Unprocessed Amount in Functional Currency in Bucket Range 7 |
UNPROCESSED_AMT_B_AGE_B8 | Unprocessed Amount in Functional Currency in Bucket Range 8 |
UNPROCESSED_AMT_B_AGE_B9 | Unprocessed Amount in Functional Currency in Bucket Range 9 |
UNPROCESSED_AMT_B_AGE_B10 | Unprocessed Amount in Functional Currency in Bucket Range 10 |
UNPROCESSED_AMT_SG_AGE_B1 | Unprocessed Amount in Secondary Global Currency in Bucket Range 1 |
UNPROCESSED_AMT_SG_AGE_B2 | Unprocessed Amount in Secondary Global Currency in Bucket Range 2 |
UNPROCESSED_AMT_SG_AGE_B3 | Unprocessed Amount in Secondary Global Currency in Bucket Range 3 |
REQUESTER_ID | Requester Identifier |
UNPROCESSED_AMT_SG_AGE_B4 | Unprocessed Amount in Secondary Global Currency in Bucket Range 4 |
UNPROCESSED_AMT_SG_AGE_B5 | Unprocessed Amount in Secondary Global Currency in Bucket Range 5 |
UNPROCESSED_AMT_SG_AGE_B6 | Unprocessed Amount in Secondary Global Currency in Bucket Range 6 |
UNPROCESSED_AMT_SG_AGE_B7 | Unprocessed Amount in Secondary Global Currency in Bucket Range 7 |
UNPROCESSED_AMT_SG_AGE_B8 | Unprocessed Amount in Secondary Global Currency in Bucket Range 8 |
UNPROCESSED_AMT_SG_AGE_B9 | Unprocessed Amount in Secondary Global Currency in Bucket Range 9 |
UNPROCESSED_AMT_SG_AGE_B10 | Unprocessed Amount in Secondary Global Currency in Bucket Range 10 |
UNPROCESSED_CNT_AGE_B1 | Number of Unprocessed Requisition Lines in Bucket Range 1 |
UNPROCESSED_CNT_AGE_B2 | Number of Unprocessed Requisition Lines in Bucket Range 2 |
UNPROCESSED_CNT_AGE_B3 | Number of Unprocessed Requisition Lines in Bucket Range 3 |
ORG_ID | Operating Unit Identifier |
UNPROCESSED_CNT_AGE_B4 | Number of Unprocessed Requisition Lines in Bucket Range 4 |
UNPROCESSED_CNT_AGE_B5 | Number of Unprocessed Requisition Lines in Bucket Range 5 |
UNPROCESSED_CNT_AGE_B6 | Number of Unprocessed Requisition Lines in Bucket Range 6 |
UNPROCESSED_CNT_AGE_B7 | Number of Unprocessed Requisition Lines in Bucket Range 7 |
UNPROCESSED_CNT_AGE_B8 | Number of Unprocessed Requisition Lines in Bucket Range 8 |
UNPROCESSED_CNT_AGE_B9 | Number of Unprocessed Requisition Lines in Bucket Range 9 |
UNPROCESSED_CNT_AGE_B10 | Number of Unprocessed Requisition Lines in Bucket Range 10 |
UNFULFILLED_AMT_G_AGE_B1 | Unfulfilled Amount in Global Currency in Bucket Range 1 |
UNFULFILLED_AMT_G_AGE_B2 | Unfulfilled Amount in Global Currency in Bucket Range 2 |
UNFULFILLED_AMT_G_AGE_B3 | Unfulfilled Amount in Global Currency in Bucket Range 3 |
BASE_UOM | Base UOM |
UNFULFILLED_AMT_G_AGE_B4 | Unfulfilled Amount in Global Currency in Bucket Range 4 |
UNFULFILLED_AMT_G_AGE_B5 | Unfulfilled Amount in Global Currency in Bucket Range 5 |
UNFULFILLED_AMT_G_AGE_B6 | Unfulfilled Amount in Global Currency in Bucket Range 6 |
UNFULFILLED_AMT_G_AGE_B7 | Unfulfilled Amount in Global Currency in Bucket Range 7 |
UNFULFILLED_AMT_G_AGE_B8 | Unfulfilled Amount in Global Currency in Bucket Range 8 |
UNFULFILLED_AMT_G_AGE_B9 | Unfulfilled Amount in Global Currency in Bucket Range 9 |
UNFULFILLED_AMT_G_AGE_B10 | Unfulfilled Amount in Global Currency in Bucket Range 10 |
UNFULFILLED_AMT_B_AGE_B1 | Unfulfilled Amount in Functional Currency in Bucket Range 1 |
UNFULFILLED_AMT_B_AGE_B2 | Unfulfilled Amount in Functional Currency in Bucket Range 2 |
UNFULFILLED_AMT_B_AGE_B3 | Unfulfilled Amount in Functional Currency in Bucket Range 3 |
Application Object Library - POA_PQC_BS_J_MV | |
---|---|
Column Name | Descritpion |
FRID | FRID |
SUPPLIER_SITE_ID | Supplier Site Identifier |
CATEGORY_ID | Category on the PO Line Identifier |
PO_ITEM_ID | Purchased Item Identifier |
BUYER_ID | Buyer Identifier |
COMPANY_ID | Company identifier |
COST_CENTER_ID | Cost-center Identifier |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
DAY_ID | FII Day Identifier |
CRID | CRID |
PURCHASE_AMT_B | Purchased Amount in functional currency |
PURCHASE_AMT_G | Purchased Amount in global currency |
PURCHASE_AMT_SG | Purchased Amount in secondary global currency |
QUANTITY | Quantity in Base UOM |
P_ENT_YEAR_ID | prior enterprise year identifier |
ENT_YEAR_ID | Enterprise Year Identifier |
GLOBAL_CUR_CONV_RATE | Global currency conversion rate |
PO_HEADER_ID | PO header identifier |
PO_LINE_ID | PO line identifier |
PO_RELEASE_ID | PO release identifier |
COMRID | COMRID |
APPROVED_DATE | Earliest approval date |
CONSIGNED_CODE | Consigned Code |
ORDER_TYPE | Order Type |
COMPLEX_WORK_FLAG | Complex work flag |
LINE_LOCATION_ID | |
PO_DISTRIBUTION_ID | |
MRID | MRID |
ORG_ID | Operating Unit Identifier |
SHIP_TO_ORG_ID | Ship to Organization Identifier |
COMMODITY_ID | Commodity Identifier |
BASE_UOM | Base UOM |
SUPPLIER_ID | Supplier Identifier |
Application Object Library - POA_REQ_001_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00107$ | |
GRP_ID | Grouping ID Column |
REQUESTER_ID | Requester Identifier |
SYS_NC00099$ | |
ORG_ID | Operating Unit Identifier |
BASE_UOM | Base UOM |
SYS_NC00104$ | |
ENT_YEAR_ID | |
ENT_QTR_ID | Enterprise Quarter Identifier |
SYS_NC00098$ | |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
SYS_NC00103$ | |
DAY_ID | FII Day Identifier |
PROCESSED_AMT_G | Processed Amount in Global Currency |
SYS_NC00109$ | |
PROCESSED_AMT_B | Processed Amount in Functional Currency |
TIME_ID | Nested Grouping ID Column for Time |
PROCESSED_AMT_SG | Processed Amount in Secondary Global Currency |
SYS_NC00097$ | |
SYS_NC00095$ | |
PROCESSED_MAN_AMT_G | Manually Processed Amount in Global Currency |
PROCESSED_MAN_AMT_B | Manually Processed Amount in Functional Currency |
SYS_NC00102$ | |
PROCESSED_MAN_AMT_SG | Manually Processed Amount in Secondary Global Currency |
PROCESSED_QTY | Processed Quantity |
SYS_NC00108$ | |
DAYS_TO_PROCESS | Number of Days for a Requisition to become Processed |
PROCESSED_CNT_G | Count of Requisition Lines in Processed State |
SYS_NC00096$ | |
PROCESSED_CNT_B | Count of Requisition Lines in Processed State |
PROCESSED_CNT_SG | Count of Requisition Lines in Processed State |
SYS_NC00101$ | |
PROCESSED_MAN_CNT_G | Count of Requisition Lines that have been Manually Processed |
PERIOD_TYPE_ID | Period Type Identifier |
PROCESSED_MAN_CNT_B | Count of Requisition Lines that have been Manually Processed |
PROCESSED_MAN_CNT_SG | Count of Requisition Lines that have been Manually Processed |
PROCESSED_QTY_CNT | Count of Processed Quantity |
DAYS_TO_PROCESS_CNT | Count of Days to Process a Requisition |
PROCESSED_AMT_G_AGE_B1 | Processed Amount in Global Currency in Bucket Range 1 |
PROCESSED_AMT_G_AGE_B2 | Processed Amount in Global Currency in Bucket Range 2 |
PROCESSED_AMT_G_AGE_B3 | Processed Amount in Global Currency in Bucket Range 3 |
PROCESSED_AMT_G_AGE_B4 | Processed Amount in Global Currency in Bucket Range 4 |
PROCESSED_AMT_G_AGE_B5 | Processed Amount in Global Currency in Bucket Range 5 |
PROCESSED_AMT_G_AGE_B6 | Processed Amount in Global Currency in Bucket Range 6 |
AGGREGATION_LEVEL | Grouping ID Column |
PROCESSED_AMT_G_AGE_B7 | Processed Amount in Global Currency in Bucket Range 7 |
SYS_NC00100$ | |
PROCESSED_AMT_G_AGE_B8 | Processed Amount in Global Currency in Bucket Range 8 |
PROCESSED_AMT_G_AGE_B9 | Processed Amount in Global Currency in Bucket Range 9 |
PROCESSED_AMT_G_AGE_B10 | Processed Amount in Global Currency in Bucket Range 10 |
PROCESSED_AMT_B_AGE_B1 | Processed Amount in Functional Currency in Bucket Range 1 |
PROCESSED_AMT_B_AGE_B2 | Processed Amount in Functional Currency in Bucket Range 2 |
PROCESSED_AMT_B_AGE_B3 | Processed Amount in Functional Currency in Bucket Range 3 |
PROCESSED_AMT_B_AGE_B4 | Processed Amount in Functional Currency in Bucket Range 4 |
PROCESSED_AMT_B_AGE_B5 | Processed Amount in Functional Currency in Bucket Range 5 |
PROCESSED_AMT_B_AGE_B6 | Processed Amount in Functional Currency in Bucket Range 6 |
CATEGORY_ID | Category on the PO Line Identifier |
PROCESSED_AMT_B_AGE_B7 | Processed Amount in Functional Currency in Bucket Range 7 |
PROCESSED_AMT_B_AGE_B8 | Processed Amount in Functional Currency in Bucket Range 8 |
PROCESSED_AMT_B_AGE_B9 | Processed Amount in Functional Currency in Bucket Range 9 |
PROCESSED_AMT_B_AGE_B10 | Processed Amount in Functional Currency in Bucket Range 10 |
PROCESSED_AMT_SG_AGE_B1 | Processed Amount in Secondary Global Currency in Bucket Range 1 |
PROCESSED_AMT_SG_AGE_B2 | Processed Amount in Secondary Global Currency in Bucket Range 2 |
PROCESSED_AMT_SG_AGE_B3 | Processed Amount in Secondary Global Currency in Bucket Range 3 |
PROCESSED_AMT_SG_AGE_B4 | Processed Amount in Secondary Global Currency in Bucket Range 4 |
PROCESSED_AMT_SG_AGE_B5 | Processed Amount in Secondary Global Currency in Bucket Range 5 |
PROCESSED_AMT_SG_AGE_B6 | Processed Amount in Secondary Global Currency in Bucket Range 6 |
PO_ITEM_ID | Purchased Item Identifier |
PROCESSED_AMT_SG_AGE_B7 | Processed Amount in Secondary Global Currency in Bucket Range 7 |
SYS_NC00106$ | |
PROCESSED_AMT_SG_AGE_B8 | Processed Amount in Secondary Global Currency in Bucket Range 8 |
PROCESSED_AMT_SG_AGE_B9 | Processed Amount in Secondary Global Currency in Bucket Range 9 |
PROCESSED_AMT_SG_AGE_B10 | Processed Amount in Secondary Global Currency in Bucket Range 10 |
PROCESSED_CNT_G_AGE_B1 | Number of Processed Requisitions in Bucket Range 1 |
PROCESSED_CNT_G_AGE_B2 | Number of Processed Requisitions in Bucket Range 2 |
PROCESSED_CNT_G_AGE_B3 | Number of Processed Requisitions in Bucket Range 3 |
PROCESSED_CNT_G_AGE_B4 | Number of Processed Requisitions in Bucket Range 4 |
PROCESSED_CNT_G_AGE_B5 | Number of Processed Requisitions in Bucket Range 5 |
PROCESSED_CNT_G_AGE_B6 | Number of Processed Requisitions in Bucket Range 6 |
SUPPLIER_ID | Supplier Identifier |
PROCESSED_CNT_G_AGE_B7 | Number of Processed Requisitions in Bucket Range 7 |
PROCESSED_CNT_G_AGE_B8 | Number of Processed Requisitions in Bucket Range 8 |
PROCESSED_CNT_G_AGE_B9 | Number of Processed Requisitions in Bucket Range 9 |
PROCESSED_CNT_G_AGE_B10 | Number of Processed Requisitions in Bucket Range 10 |
PROCESSED_CNT_B_AGE_B1 | Number of Processed Requisitions in Bucket Range 1 |
PROCESSED_CNT_B_AGE_B2 | Number of Processed Requisitions in Bucket Range 2 |
PROCESSED_CNT_B_AGE_B3 | Number of Processed Requisitions in Bucket Range 3 |
PROCESSED_CNT_B_AGE_B4 | Number of Processed Requisitions in Bucket Range 4 |
PROCESSED_CNT_B_AGE_B5 | Number of Processed Requisitions in Bucket Range 5 |
PROCESSED_CNT_B_AGE_B6 | Number of Processed Requisitions in Bucket Range 6 |
BUYER_ID | Buyer Identifier |
PROCESSED_CNT_B_AGE_B7 | Number of Processed Requisitions in Bucket Range 7 |
SYS_NC00105$ | |
PROCESSED_CNT_B_AGE_B8 | Number of Processed Requisitions in Bucket Range 8 |
PROCESSED_CNT_B_AGE_B9 | Number of Processed Requisitions in Bucket Range 9 |
PROCESSED_CNT_B_AGE_B10 | Number of Processed Requisitions in Bucket Range 10 |
PROCESSED_CNT_SG_AGE_B1 | Number of Processed Requisitions in Bucket Range 1 |
PROCESSED_CNT_SG_AGE_B2 | Number of Processed Requisitions in Bucket Range 2 |
PROCESSED_CNT_SG_AGE_B3 | Number of Processed Requisitions in Bucket Range 3 |
PROCESSED_CNT_SG_AGE_B4 | Number of Processed Requisitions in Bucket Range 4 |
PROCESSED_CNT_SG_AGE_B5 | Number of Processed Requisitions in Bucket Range 5 |
PROCESSED_CNT_SG_AGE_B6 | Number of Processed Requisitions in Bucket Range 6 |
SHIP_TO_ORG_ID | Ship To Organization Identifier |
PROCESSED_CNT_SG_AGE_B7 | Number of Processed Requisitions in Bucket Range 7 |
PROCESSED_CNT_SG_AGE_B8 | Number of Processed Requisitions in Bucket Range 8 |
PROCESSED_CNT_SG_AGE_B9 | Number of Processed Requisitions in Bucket Range 9 |
PROCESSED_CNT_SG_AGE_B10 | Number of Processed Requisitions in Bucket Range 10 |
C_TOTAL | Count columns |
Application Object Library - POA_REQ_002_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00107$ | |
GRP_ID | Grouping ID Column |
REQUESTER_ID | Requester Identifier |
SYS_NC00099$ | |
ORG_ID | Operating Unit Identifier |
BASE_UOM | Base UOM |
SYS_NC00104$ | |
ENT_YEAR_ID | |
ENT_QTR_ID | Enterprise Quarter Identifier |
SYS_NC00098$ | |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
SYS_NC00103$ | |
DAY_ID | FII Day Identifier |
FULFILLED_AMT_B | Fulfilled (Fully Received/Invoiced depending on match option) Amount in Functional Currency |
SYS_NC00109$ | |
FULFILLED_AMT_G | Fulfilled (Fully Received/Invoiced depending on match option) Amount in Global Currency |
TIME_ID | Nested Grouping ID Column for Time |
FULFILLED_AMT_SG | Fulfilled (Fully Received/Invoiced depending on match option) Amount in Secondary Global Currency |
SYS_NC00097$ | |
SYS_NC00110$ | |
FULFILLED_MAN_AMT_B | Amount that has been fulfilled Manually in Functional Currency |
FULFILLED_MAN_AMT_G | Amount that has been fulfilled Manually in Global Currency |
SYS_NC00102$ | |
FULFILLED_MAN_AMT_SG | Amount that has been fulfilled Manually in Secondary Global Currency |
FULFILLED_QTY | Fulfilled Quantity |
SYS_NC00108$ | |
DAYS_TO_FULFILL | Number of Days for a Requisition to become Fulfilled |
FULFILLED_CNT_B | Count of Fulfilled Requisitions |
SYS_NC00096$ | |
FULFILLED_CNT_G | Count of Fulfilled Requisitions |
FULFILLED_CNT_SG | Count of Fulfilled Requisitions |
SYS_NC00101$ | |
FULFILLED_MAN_CNT_B | Count of Requisitions that have been fulfilled Manually |
PERIOD_TYPE_ID | Period Type Identifier |
FULFILLED_MAN_CNT_G | Count of Requisitions that have been fulfilled Manually |
FULFILLED_MAN_CNT_SG | Count of Requisitions that have been fulfilled Manually |
FULFILLED_QTY_CNT | Count of Quantity of Fulfilled Requisitions |
DAYS_TO_FULFILL_CNT | Count of Days taken to Fulfill a Requisition |
FULFILLED_PED_CNT | Count of Fulfilled Requisitions that are Past Expected Date |
FULFILLED_AMT_B_AGE_B1 | Fulfilled Amount in Functional Currency in Bucket Range 1 |
FULFILLED_AMT_B_AGE_B2 | Fulfilled Amount in Functional Currency in Bucket Range 2 |
FULFILLED_AMT_B_AGE_B3 | Fulfilled Amount in Functional Currency in Bucket Range 3 |
FULFILLED_AMT_B_AGE_B4 | Fulfilled Amount in Functional Currency in Bucket Range 4 |
FULFILLED_AMT_B_AGE_B5 | Fulfilled Amount in Functional Currency in Bucket Range 5 |
AGGREGATION_LEVEL | Grouping ID Column |
FULFILLED_AMT_B_AGE_B6 | Fulfilled Amount in Functional Currency in Bucket Range 6 |
SYS_NC00100$ | |
FULFILLED_AMT_B_AGE_B7 | Fulfilled Amount in Functional Currency in Bucket Range 7 |
FULFILLED_AMT_B_AGE_B8 | Fulfilled Amount in Functional Currency in Bucket Range 8 |
FULFILLED_AMT_B_AGE_B9 | Fulfilled Amount in Functional Currency in Bucket Range 9 |
FULFILLED_AMT_B_AGE_B10 | Fulfilled Amount in Functional Currency in Bucket Range 10 |
FULFILLED_AMT_G_AGE_B1 | Fulfilled Amount in Global Currency in Bucket Range 1 |
FULFILLED_AMT_G_AGE_B2 | Fulfilled Amount in Global Currency in Bucket Range 2 |
FULFILLED_AMT_G_AGE_B3 | Fulfilled Amount in Global Currency in Bucket Range 3 |
FULFILLED_AMT_G_AGE_B4 | Fulfilled Amount in Global Currency in Bucket Range 4 |
FULFILLED_AMT_G_AGE_B5 | Fulfilled Amount in Global Currency in Bucket Range 5 |
CATEGORY_ID | Category on the PO Line Identifier |
FULFILLED_AMT_G_AGE_B6 | Fulfilled Amount in Global Currency in Bucket Range 6 |
FULFILLED_AMT_G_AGE_B7 | Fulfilled Amount in Global Currency in Bucket Range 7 |
FULFILLED_AMT_G_AGE_B8 | Fulfilled Amount in Global Currency in Bucket Range 8 |
FULFILLED_AMT_G_AGE_B9 | Fulfilled Amount in Global Currency in Bucket Range 9 |
FULFILLED_AMT_G_AGE_B10 | Fulfilled Amount in Global Currency in Bucket Range 10 |
FULFILLED_AMT_SG_AGE_B1 | Fulfilled Amount in Secondary Global Currency in Bucket Range 1 |
FULFILLED_AMT_SG_AGE_B2 | Fulfilled Amount in Secondary Global Currency in Bucket Range 2 |
FULFILLED_AMT_SG_AGE_B3 | Fulfilled Amount in Secondary Global Currency in Bucket Range 3 |
FULFILLED_AMT_SG_AGE_B4 | Fulfilled Amount in Secondary Global Currency in Bucket Range 4 |
FULFILLED_AMT_SG_AGE_B5 | Fulfilled Amount in Secondary Global Currency in Bucket Range 5 |
PO_ITEM_ID | Purchased Item Identifier |
FULFILLED_AMT_SG_AGE_B6 | Fulfilled Amount in Secondary Global Currency in Bucket Range 6 |
SYS_NC00106$ | |
FULFILLED_AMT_SG_AGE_B7 | Fulfilled Amount in Secondary Global Currency in Bucket Range 7 |
FULFILLED_AMT_SG_AGE_B8 | Fulfilled Amount in Secondary Global Currency in Bucket Range 8 |
FULFILLED_AMT_SG_AGE_B9 | Fulfilled Amount in Secondary Global Currency in Bucket Range 9 |
FULFILLED_AMT_SG_AGE_B10 | Fulfilled Amount in Secondary Global Currency in Bucket Range 10 |
FULFILLED_CNT_B_AGE_B1 | Number of Fulfilled Requisitions in Bucket Range 1 |
FULFILLED_CNT_B_AGE_B2 | Number of Fulfilled Requisitions in Bucket Range 2 |
FULFILLED_CNT_B_AGE_B3 | Number of Fulfilled Requisitions in Bucket Range 3 |
FULFILLED_CNT_B_AGE_B4 | Number of Fulfilled Requisitions in Bucket Range 4 |
FULFILLED_CNT_B_AGE_B5 | Number of Fulfilled Requisitions in Bucket Range 5 |
SUPPLIER_ID | Supplier Identifier |
FULFILLED_CNT_B_AGE_B6 | Number of Fulfilled Requisitions in Bucket Range 6 |
FULFILLED_CNT_B_AGE_B7 | Number of Fulfilled Requisitions in Bucket Range 7 |
FULFILLED_CNT_B_AGE_B8 | Number of Fulfilled Requisitions in Bucket Range 8 |
FULFILLED_CNT_B_AGE_B9 | Number of Fulfilled Requisitions in Bucket Range 9 |
FULFILLED_CNT_B_AGE_B10 | Number of Fulfilled Requisitions in Bucket Range 10 |
FULFILLED_CNT_G_AGE_B1 | Number of Fulfilled Requisitions in Bucket Range 1 |
FULFILLED_CNT_G_AGE_B2 | Number of Fulfilled Requisitions in Bucket Range 2 |
FULFILLED_CNT_G_AGE_B3 | Number of Fulfilled Requisitions in Bucket Range 3 |
FULFILLED_CNT_G_AGE_B4 | Number of Fulfilled Requisitions in Bucket Range 4 |
FULFILLED_CNT_G_AGE_B5 | Number of Fulfilled Requisitions in Bucket Range 5 |
BUYER_ID | Buyer Identifier |
FULFILLED_CNT_G_AGE_B6 | Number of Fulfilled Requisitions in Bucket Range 6 |
SYS_NC00105$ | |
FULFILLED_CNT_G_AGE_B7 | Number of Fulfilled Requisitions in Bucket Range 7 |
FULFILLED_CNT_G_AGE_B8 | Number of Fulfilled Requisitions in Bucket Range 8 |
FULFILLED_CNT_G_AGE_B9 | Number of Fulfilled Requisitions in Bucket Range 9 |
FULFILLED_CNT_G_AGE_B10 | Number of Fulfilled Requisitions in Bucket Range 10 |
FULFILLED_CNT_SG_AGE_B1 | Number of Fulfilled Requisitions in Bucket Range 1 |
FULFILLED_CNT_SG_AGE_B2 | Number of Fulfilled Requisitions in Bucket Range 2 |
FULFILLED_CNT_SG_AGE_B3 | Number of Fulfilled Requisitions in Bucket Range 3 |
FULFILLED_CNT_SG_AGE_B4 | Number of Fulfilled Requisitions in Bucket Range 4 |
FULFILLED_CNT_SG_AGE_B5 | Number of Fulfilled Requisitions in Bucket Range 5 |
SHIP_TO_ORG_ID | Ship To Organization Identifier |
FULFILLED_CNT_SG_AGE_B6 | Number of Fulfilled Requisitions in Bucket Range 6 |
FULFILLED_CNT_SG_AGE_B7 | Number of Fulfilled Requisitions in Bucket Range 7 |
FULFILLED_CNT_SG_AGE_B8 | Number of Fulfilled Requisitions in Bucket Range 8 |
FULFILLED_CNT_SG_AGE_B9 | Number of Fulfilled Requisitions in Bucket Range 9 |
FULFILLED_CNT_SG_AGE_B10 | Number of Fulfilled Requisitions in Bucket Range 10 |
C_TOTAL | Count column |
Application Object Library - POA_IDL_001_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00036$ | |
GRP_ID | Grouping ID Column |
ENT_PERIOD_ID | Enterprise Period Identifier |
SYS_NC00028$ | |
WEEK_ID | FII Week Identifier |
DAY_ID | FII Day Identifier |
SYS_NC00031$ | |
AMOUNT_B | Invoice Amount in Functional Currency |
AMOUNT_G | Invoice Amount in Global Currency |
SYS_NC00034$ | |
AMOUNT_SG | Invoice Amount in Secondary Global Currency |
LEAKAGE_AMOUNT_B | Payables Leakage Amount in Functional Currency |
SYS_NC00027$ | |
LEAKAGE_AMOUNT_G | Payables Leakage Amount in Global Currency |
LEAKAGE_AMOUNT_SG | Payables Leakage Amount in Secondary Global Currency |
SYS_NC00030$ | |
C_AMOUNT_B | Count Columns |
TIME_ID | Nested Grouping ID Column for Time |
C_AMOUNT_G | Count Columns |
SYS_NC00033$ | |
SYS_NC00026$ | |
C_AMOUNT_SG | Count Columns |
C_LEAKAGE_AMOUNT_B | Count Columns |
C_LEAKAGE_AMOUNT_G | Count Columns |
C_LEAKAGE_AMOUNT_SG | Count Columns |
C_TOTAL | Row Count |
AGGREGATION_LEVEL | Grouping ID Column |
ORG_ID | Operating Unit Identifier |
SYS_NC00029$ | |
SUPPLIER_ID | Supplier Identifier |
INV_D_CREATED_BY | Invoice Distribution Creator Identifier |
SYS_NC00032$ | |
COMPANY_ID | Company Identifier |
COST_CENTER_ID | Cost-center Identifier |
SYS_NC00035$ | |
ENT_QTR_ID | Enterprise Quarter Identifier |
Application Object Library - POA_NEG_001_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00062$ | |
GRP_ID | Grouping Identifier |
NEGOTIATION_CREATOR_ID | Negotiation Creator Identifier |
SYS_NC00064$ | |
BASE_UOM | Base Unit of Measure |
DOCTYPE_ID | Negotiation Document Type Identifier |
SYS_NC00051$ | |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
SYS_NC00054$ | |
WEEK_ID | Week Identifier |
DAY_ID | Day Identifier |
SYS_NC00057$ | |
AWARD_QTY | Award Quantity |
AWARD_AMT_B | Award Amount in Functional Currency |
SYS_NC00060$ | |
AWARD_AMT_G | Award Amount in Global Currency |
TIME_ID | Time Identifier |
AWARD_AMT_SG | Award Amount in Secondary Global Currency |
SYS_NC00063$ | |
SYS_NC00052$ | |
CURRENT_AMT_B | Amount calculated using Current Price in Functional Currency |
CURRENT_AMT_G | Amount calculated using Current Price in Global Currency |
SYS_NC00050$ | |
CURRENT_AMT_SG | Amount calculated using Current Price in Secondary Global Currency |
PROJ_SAVINGS_AMT_B | Projected Savings Amount in Functional Currency |
SYS_NC00053$ | |
PROJ_SAVINGS_AMT_G | Projected Savings Amount in Global Currency |
PROJ_SAVINGS_AMT_SG | Projected Savings Amount in Secondary Global Currency |
SYS_NC00056$ | |
PREPARATION_TIME | Time taken for Negotiation Preparation |
BIDDING_TIME | Time taken for Negotiation Bidding |
SYS_NC00059$ | |
ANALYSIS_TIME | Time taken for analysing the responses of Negotiation |
AGGREGATION_LEVEL | Aggregation Level |
AWARD_TIME | Time taken to award a Negotiation |
NEGOTIATED_LINES | Total Negotiated Lines |
NEG_LINES_WITH_CP | Negotiated Lines with a valid Current Price |
C_AWARD_QTY | Count column for Award Quantity |
C_AWARD_AMT_B | Count column for Award Amount in Functional Currency |
C_AWARD_AMT_G | Count column for Award Amount in Global Currency |
C_AWARD_AMT_SG | Count column for Award Amount in Secondary Global Currency |
C_CURRENT_AMT_B | Count column for Amount calculated using Current Price in Functional Currency |
C_CURRENT_AMT_G | Count column for Amount calculated using Current Price in Global Currency |
C_CURRENT_AMT_SG | Count column for Amount calculated using Current Price in Secondary Global Currency |
ORG_ID | Operating Unit Identifier |
C_PROJ_SAVINGS_AMT_B | Count column for Projected Savings Amount in Functional Currency |
SYS_NC00055$ | |
C_PROJ_SAVINGS_AMT_G | Count column for Projected Savings Amount in Global Currency |
C_PROJ_SAVINGS_AMT_SG | Count column for Projected Savings Amount in Secondary Global Currency |
C_PREPARATION_TIME | Count column for Time taken for Negotiation Preparation |
C_BIDDING_TIME | Count column for Time taken for Negotiation Bidding |
C_AWARD_TIME | Count column for Time taken to award a Negotiation |
C_ANALYSIS_TIME | Count column for Time taken for analysing the responses of Negotiation |
C_NEGOTIATED_LINES | Count column for Total Negotiated Lines |
C_NEG_LINES_WITH_CP | Count column for Negotiated Lines with a valid Current Price |
C_TOTAL | Total Negotiation Lines including RFI documents |
COMMODITY_ID | Commodity Identifier |
CATEGORY_ID | Category Identifier |
SYS_NC00058$ | |
SUPPLIER_ID | Supplier Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
SYS_NC00061$ | |
PO_ITEM_ID | PO Item Identifier |
Application Object Library - POA_POD_001_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00066$ | |
GRP_ID | Grouping ID Column |
ENT_QTR_ID | Enterprise Quarter Identifier |
SYS_NC00073$ | |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
SYS_NC00063$ | |
DAY_ID | FII Day Identifier |
PURCHASE_AMT_B | Purchase Amount in Functional Currency |
SYS_NC00069$ | |
PURCHASE_AMT_G | Purchase Amount in Global Currency |
PURCHASE_AMT_SG | Purchase Amount in Secondary Global Currency |
SYS_NC00072$ | |
P_CONTRACT_AMT_B | Contract Leakage Amount in Functional Currency |
P_CONTRACT_AMT_G | Contract Leakage Amount in Global Currency |
SYS_NC00062$ | |
P_CONTRACT_AMT_SG | Contract Leakage Amount in Secondary Global Currency |
TIME_ID | Nested Grouping ID Column for Time |
N_CONTRACT_AMT_B | Non-Contract Amount in Functional Currency |
SYS_NC00068$ | |
SYS_NC00075$ | |
N_CONTRACT_AMT_G | Non-Contract Amount in Global Currency |
N_CONTRACT_AMT_SG | Non-Contract Amount in Secondary Global Currency |
SYS_NC00071$ | |
P_SAVINGS_AMT_B | Potential Savings Amount in Functional Currency |
P_SAVINGS_AMT_G | Potential Savings Amount in Global Currency |
SYS_NC00067$ | |
P_SAVINGS_AMT_SG | Potential Savings Amount in Secondary Global Currency |
C_PURCHASE_AMT_B | Count Columns |
SYS_NC00070$ | |
C_PURCHASE_AMT_G | Count Columns |
C_PURCHASE_AMT_SG | Count Columns |
SYS_NC00076$ | |
C_P_CONTRACT_AMT_B | Count Columns |
AGGREGATION_LEVEL | Grouping ID Column |
C_P_CONTRACT_AMT_G | Count Columns |
C_P_CONTRACT_AMT_SG | Count Columns |
C_N_CONTRACT_AMT_B | Count Columns |
C_N_CONTRACT_AMT_G | Count Columns |
C_N_CONTRACT_AMT_SG | Count Columns |
C_P_SAVINGS_AMT_B | Count Columns |
C_P_SAVINGS_AMT_G | Count Columns |
C_P_SAVINGS_AMT_SG | Count Columns |
C_TOTAL | Row Count |
COMMODITY_ID | Commodity Identifier |
ORG_ID | Operating Unit Identifier |
BASE_UOM | Base UOM |
SYS_NC00065$ | |
QUANTITY | Quantity in Base UOM |
CONTRACT_AMT_B | Contract Amount in Functional Currency |
CONTRACT_AMT_G | Contract Amount in Global Currency |
CONTRACT_AMT_SG | Contract Amount in secondary Global Currency |
ABOVE_CONTRACT_AMT_B | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Function Currency. |
ABOVE_CONTRACT_AMT_G | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Global Currency. |
ABOVE_CONTRACT_AMT_SG | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in secondary Global Currency. |
BELOW_CONTRACT_AMT_B | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Functional Currency. |
BELOW_CONTRACT_AMT_G | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Global Currency. |
SUPPLIER_ID | Supplier Identifier |
BELOW_CONTRACT_AMT_SG | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Secondary Global Currency. |
C_QUANTITY | Count Columns |
C_CONTRACT_AMT_B | Count Columns |
C_CONTRACT_AMT_G | Count Columns |
C_CONTRACT_AMT_SG | Count Columns |
C_ABOVE_CONTRACT_AMT_B | Count Columns |
C_ABOVE_CONTRACT_AMT_G | Count Columns |
C_ABOVE_CONTRACT_AMT_SG | Count Columns |
C_BELOW_CONTRACT_AMT_B | Count Columns |
C_BELOW_CONTRACT_AMT_G | Count Columns |
CATEGORY_ID | Category on the PO Line Identifier |
C_BELOW_CONTRACT_AMT_SG | Count Columns |
SYS_NC00074$ | |
CONTRACT_TYPE | 1 for Blkt Releases, 2 for Scheduled Releases, 3 for PO referencing Global Agrmt, 4 for PO with Negotiated Pricing |
PO_ITEM_ID | Purchased Item Identifier |
COMPANY_ID | Company Identifier |
SYS_NC00064$ | |
COST_CENTER_ID | Cost-center Identifier |
Application Object Library - POA_IDL_BS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
GRP_ID | Grouping ID Column |
WEEK_ID | FII Week Identifier |
SYS_NC00031$ | |
DAY_ID | FII Day Identifier |
AMOUNT_B | Invoice Amount in Functional Currency |
SYS_NC00034$ | |
AMOUNT_G | Invoice Amount in Global Currency |
AMOUNT_SG | Invoice Amount in Secondary Global Currency |
SYS_NC00026$ | |
LEAKAGE_AMOUNT_B | Payables Leakage Amount in Functional Currency |
LEAKAGE_AMOUNT_G | Payables Leakage Amount in Global Currency |
SYS_NC00029$ | |
LEAKAGE_AMOUNT_SG | Payables Leakage Amount in Secondary Global Currency |
C_AMOUNT_B | Count Columns |
SYS_NC00032$ | |
C_AMOUNT_G | Count Columns |
TIME_ID | Nested Grouping ID Column for Time |
C_AMOUNT_SG | Count Columns |
SYS_NC00030$ | |
C_LEAKAGE_AMOUNT_B | Count Columns |
C_LEAKAGE_AMOUNT_G | Count Columns |
C_LEAKAGE_AMOUNT_SG | Count Columns |
C_TOTAL | Row Count |
AGGREGATION_LEVEL | Grouping ID Column |
ORG_ID | Operating Unit Identifier |
SYS_NC00033$ | |
SUPPLIER_ID | Supplier Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
SYS_NC00025$ | |
INV_D_CREATED_BY | Invoice Distribution Creator Identifier |
ENT_QTR_ID | Enterprise Quarter Identifier |
SYS_NC00028$ | |
ENT_PERIOD_ID | Enterprise Period Identifier |
Application Object Library - POA_MID_BS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
GRP_ID | Grouping ID Column |
ENT_PERIOD_ID | Enterprise Period Identifier |
SYS_NC00023$ | |
WEEK_ID | FII Week Identifier |
DAY_ID | FII Day Identifier |
SYS_NC00026$ | |
DIST_COUNT | Count of Invoice Distributions |
C_DIST_COUNT | Count Columns |
SYS_NC00018$ | |
MANUAL_DIST_COUNT | Count of manual Invoice Distributions |
C_MANUAL_DIST_COUNT | Count Columns |
SYS_NC00021$ | |
C_TOTAL | Row Count |
SYS_NC00024$ | |
TIME_ID | Nested Grouping ID Column for Time |
SYS_NC00019$ | |
PERIOD_TYPE_ID | Nested Grouping ID Column for Period Type Identifier |
AGGREGATION_LEVEL | |
SYS_NC00022$ | |
ORG_ID | Operating Unit Identifier |
SUPPLIER_ID | Supplier Identifier |
SYS_NC00025$ | |
SUPPLIER_SITE_ID | Supplier Site Identifier |
INV_D_CREATED_BY | Invoice Distribution Creator Identifier |
SYS_NC00020$ | |
ENT_QTR_ID | Enterprise Quarter Identifier |
Application Object Library - POA_POD_BS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00101$ | |
GRP_ID | Grouping ID Column |
BUYER_ID | Buyer Identifier |
SYS_NC00099$ | |
NEGOTIATION_CREATOR_ID | Negotiation Creator Identifier |
DOCTYPE_ID | Negotiation Document Type Identifier |
SYS_NC00089$ | |
ENT_YEAR_ID | |
ENT_QTR_ID | Enterprise Quarter Identifier |
SYS_NC00092$ | |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
SYS_NC00098$ | |
DAY_ID | FII Day Identifier |
PURCHASE_AMT_B | Purchase Amount in Functional Currency |
SYS_NC00088$ | |
PURCHASE_AMT_G | Purchase Amount in Global Currency |
TIME_ID | Nested Grouping ID Column for Time |
PURCHASE_AMT_SG | Purchase Amount in Secondary Global Currency |
SYS_NC00103$ | |
SYS_NC00095$ | |
P_CONTRACT_AMT_B | Contract Leakage Amount in Functional Currency |
P_CONTRACT_AMT_G | Contract Leakage Amount in Global Currency |
SYS_NC00091$ | |
P_CONTRACT_AMT_SG | Contract Leakage Amount in Secondary Global Currency |
N_CONTRACT_AMT_B | Non-Contract Amount in Functional Currency |
SYS_NC00097$ | |
N_CONTRACT_AMT_G | Non-Contract Amount in Global Currency |
N_CONTRACT_AMT_SG | Non-Contract Amount in Secondary Global Currency |
SYS_NC00087$ | |
P_SAVINGS_AMT_B | Potential Savings Amount in Functional Currency |
P_SAVINGS_AMT_G | Potential Savings Amount in Global Currency |
SYS_NC00102$ | |
P_SAVINGS_AMT_SG | Potential Savings Amount in Secondary Global Currency |
AGGREGATION_LEVEL | Grouping ID Column |
NEG_PURCHASE_AMT_B | Negotiated Purchases Amount in Functional Currency |
SYS_NC00090$ | |
NEG_PURCHASE_AMT_G | Negotiated Purchases Amount in Global Currency |
NEG_PURCHASE_AMT_SG | Negotiated Purchases Amount in Secondary Global Currency |
SYS_NC00096$ | |
CURRENT_AMT_B | Negotiation Amount at Current Price in Functional Currency |
CURRENT_AMT_G | Negotiation Amount at Current Price in Global Currency |
SYS_NC00086$ | |
CURRENT_AMT_SG | Negotiation Amount at Current Price in Secondary Global Currency |
REAL_SVNGS_AMT_B | Realized Savings Amount in Functional Currency |
REAL_SVNGS_AMT_G | Realized Savings Amount in Global Currency |
REAL_SVNGS_AMT_SG | Realized Savings Amount in Secondary Global Currency |
QUANTITY | Quantity in Base UOM |
PERIOD_TYPE_ID | Period Type Identifier |
CONTRACT_AMT_B | Contract Amount in Functional Currency |
SYS_NC00100$ | |
CONTRACT_AMT_G | Contract Amount in Global Currency |
CONTRACT_AMT_SG | Contract Amount in secondary Global Currency |
ABOVE_CONTRACT_AMT_B | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Function Currency. |
ABOVE_CONTRACT_AMT_G | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Global Currency. |
ABOVE_CONTRACT_AMT_SG | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in secondary Global Currency. |
BELOW_CONTRACT_AMT_B | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Functional Currency. |
BELOW_CONTRACT_AMT_G | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Global Currency. |
BELOW_CONTRACT_AMT_SG | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Secondary Global Currency. |
NZ_QUANTITY | Non Zero Quantity |
ORG_ID | Operating Unit Identifier |
C_PURCHASE_AMT_B | Count Columns |
C_PURCHASE_AMT_G | Count Columns |
C_PURCHASE_AMT_SG | Count Columns |
C_P_CONTRACT_AMT_B | Count Columns |
C_P_CONTRACT_AMT_G | Count Columns |
C_P_CONTRACT_AMT_SG | Count Columns |
C_N_CONTRACT_AMT_B | Count Columns |
C_N_CONTRACT_AMT_G | Count Columns |
C_N_CONTRACT_AMT_SG | Count Columns |
C_P_SAVINGS_AMT_B | Count Columns |
SUPPLIER_ID | Supplier Identifier |
C_P_SAVINGS_AMT_G | Count Columns |
SYS_NC00094$ | |
C_P_SAVINGS_AMT_SG | Count Columns |
C_NEG_PURCHASE_AMT_B | Count column for Negotiated Purchases Amount in Functional Currency |
C_NEG_PURCHASE_AMT_G | Count column for Negotiated Purchases Amount in Global Currency |
C_NEG_PURCHASE_AMT_SG | Count column for Negotiated Purchases Amount in Secondary Global Currency |
C_REAL_SVNGS_AMT_B | Count column for Realized Savings Amount in Functional Currency |
C_REAL_SVNGS_AMT_G | Count column for Realized Savings Amount in Global Currency |
C_REAL_SVNGS_AMT_SG | Count column for Realized Savings Amount in Secondary Global Currency |
C_TOTAL | Row Count |
COMMODITY_ID | Commodity Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
BASE_UOM | Base UOM |
C_QUANTITY | Count Columns |
C_CONTRACT_AMT_B | Count Columns |
C_CONTRACT_AMT_G | Count Columns |
C_CONTRACT_AMT_SG | Count Columns |
C_ABOVE_CONTRACT_AMT_B | Count Columns |
C_ABOVE_CONTRACT_AMT_G | Count Columns |
C_ABOVE_CONTRACT_AMT_SG | Count Columns |
C_BELOW_CONTRACT_AMT_B | Count Columns |
C_BELOW_CONTRACT_AMT_G | Count Columns |
CATEGORY_ID | Category on the PO Line Identifier |
C_BELOW_CONTRACT_AMT_SG | Count Columns |
SYS_NC00093$ | |
C_NZ_QUANTITY | Count Columns |
C_CURRENT_AMT_B | Count column for Negotiation Amount at Current Price in Functional Currency |
C_CURRENT_AMT_G | Count column for Negotiation Amount at Current Price in Global Currency |
C_CURRENT_AMT_SG | Count column for Negotiation Amount at Current Price in Secondary Global Currency |
CONTRACT_TYPE | 1 for Blkt Releases, 2 for Scheduled Releases, 3 for PO referencing Global Agrmt, 4 for PO with Negotiated Pricing |
PO_ITEM_ID | Purchased Item Identifier |
Application Object Library - POA_RTX_BS_J_MV | |
---|---|
Column Name | Descritpion |
RRID | RRID |
SUPPLIER_SITE_ID | Supplier Site Identifier |
BUYER_ID | Buyer Identifier |
RECEIVING_ORG_ID | Receiving Organization Identifier |
REASON_ID | Return Reason Identifier |
BASE_UOM | Base UOM |
TRANSACTION_TYPE | Transaction type from receiving transactions table, values:ACCEPT, CORRECT, MATCH, RECEIVE, REJECT, RETURN TO VENDOR |
ENT_YEAR_ID | |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
PRID | PRID |
DAY_ID | FII Day Identifier |
MX_ID | Multiplexer Identifier |
QUANTITY | Quantity in Base UOM |
AMOUNT_B | Receipt or Return Amount in functional currency |
AMOUNT_G | Receipt or Return Amount in global currency |
AMOUNT_SG | Receipt or Return Amount in secondary global currency |
AMT_AFTERDUE_B | Amount Received after late tolerance in functional currency |
AMT_AFTERDUE_G | Amount Received after late tolerance in global currency |
AMT_AFTERDUE_SG | Amount Received after late tolerance in secondary global currency |
AMT_BEFOREDUE_B | Amount Received before early tolerance in functional currency |
CRID | CRID |
AMT_BEFOREDUE_G | Amount Received before early tolerance in global currency |
AMT_BEFOREDUE_SG | Amount Received before early tolerance in secondary global currency |
AMT_EXPT_B | Amount Received outside tolerance in functional currency |
AMT_EXPT_G | Amount Received outside tolerance in global currency |
AMT_EXPT_SG | Amount Received outside tolerance in secondary global currency |
QTY_INTOL | Quantity received in tolerance |
QTY_AFTERDUE | Quantity received after late tolerance |
QTY_BEFOREDUE | Quantity recieved before early tolerance |
NUM_DAYS_LATE | the number of days late the receipt transactions took place |
NUM_DAYS_EARLY | the number of days early the receipt transactions took place |
MXROWID | MXROWID |
TRANSACTION_FLAG | Transaction type, values: ACCEPT, RECEIVE, REJECT, RETURN TO VENDOR |
DROPSHIP_TYPE_CODE | Dropship type for global procurement |
COMMODITY_ID | Commodity Identifier |
CATEGORY_ID | Category on the PO Line Identifier |
PO_ITEM_ID | Purchased Item Identifier |
ORG_ID | Operating Unit Identifier |
SUPPLIER_ID | Supplier Identifier |
Application Object Library - POA_IDL_002_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00027$ | |
GRP_ID | Grouping ID Column |
AMOUNT_B | Invoice Amount in Functional Currency |
SYS_NC00031$ | |
AMOUNT_G | Invoice Amount in Global Currency |
AMOUNT_SG | Invoice Amount in Secondary Global Currency |
SYS_NC00026$ | |
LEAKAGE_AMOUNT_B | Payables Leakage Amount in Functional Currency |
LEAKAGE_AMOUNT_G | Payables Leakage Amount in Global Currency |
SYS_NC00029$ | |
LEAKAGE_AMOUNT_SG | Payables Leakage Amount in Secondary Global Currency |
C_AMOUNT_B | Count Columns |
SYS_NC00032$ | |
C_AMOUNT_G | Count Columns |
C_AMOUNT_SG | Count Columns |
SYS_NC00024$ | |
C_LEAKAGE_AMOUNT_B | Count Columns |
TIME_ID | Nested Grouping ID Column for Time |
C_LEAKAGE_AMOUNT_G | Count Columns |
SYS_NC00030$ | |
C_LEAKAGE_AMOUNT_SG | Count Columns |
C_TOTAL | Row Count |
AGGREGATION_LEVEL | Grouping ID Column |
ORG_ID | Operating Unit Identifier |
SUPPLIER_ID | Supplier Identifier |
SYS_NC00033$ | |
INV_D_CREATED_BY | Invoice Distribution Creator Identifier |
PARENT_COMPANY_ID | Parent Company Identifier |
SYS_NC00025$ | |
PARENT_CC_ID | Parent Cost-center Identifier |
COMPANY_ID | Company Identifier |
SYS_NC00028$ | |
COST_CENTER_ID | Cost-center Identifier |
Application Object Library - POA_POD_002_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00066$ | |
GRP_ID | Grouping ID Column |
COST_CENTER_ID | Cost-center Identifier |
SYS_NC00069$ | |
PURCHASE_AMT_B | Purchase Amount in Functional Currency |
PURCHASE_AMT_G | Purchase Amount in Global Currency |
SYS_NC00072$ | |
PURCHASE_AMT_SG | Purchase Amount in Secondary Global Currency |
P_CONTRACT_AMT_B | Contract Leakage Amount in Functional Currency |
SYS_NC00062$ | |
P_CONTRACT_AMT_G | Contract Leakage Amount in Global Currency |
P_CONTRACT_AMT_SG | Contract Leakage Amount in Secondary Global Currency |
SYS_NC00068$ | |
N_CONTRACT_AMT_B | Non-Contract Amount in Functional Currency |
N_CONTRACT_AMT_G | Non-Contract Amount in Global Currency |
SYS_NC00071$ | |
N_CONTRACT_AMT_SG | Non-Contract Amount in Secondary Global Currency |
TIME_ID | Nested Grouping ID Column for Time |
P_SAVINGS_AMT_B | Potential Savings Amount in Functional Currency |
SYS_NC00061$ | |
SYS_NC00065$ | |
P_SAVINGS_AMT_G | Potential Savings Amount in Global Currency |
P_SAVINGS_AMT_SG | Potential Savings Amount in Secondary Global Currency |
SYS_NC00067$ | |
C_PURCHASE_AMT_B | Count Columns |
C_PURCHASE_AMT_G | Count Columns |
SYS_NC00070$ | |
C_PURCHASE_AMT_SG | Count Columns |
C_P_CONTRACT_AMT_B | Count Columns |
SYS_NC00060$ | |
C_P_CONTRACT_AMT_G | Count Columns |
C_P_CONTRACT_AMT_SG | Count Columns |
C_N_CONTRACT_AMT_B | Count Columns |
ORG_ID | Operating Unit Identifier |
C_N_CONTRACT_AMT_G | Count Columns |
C_N_CONTRACT_AMT_SG | Count Columns |
C_P_SAVINGS_AMT_B | Count Columns |
C_P_SAVINGS_AMT_G | Count Columns |
C_P_SAVINGS_AMT_SG | Count Columns |
C_TOTAL | Row Count |
COMMODITY_ID | Commodity Identifier |
BASE_UOM | Base UOM |
QUANTITY | Quantity in Base UOM |
CONTRACT_AMT_B | Contract Amount in Functional Currency |
SUPPLIER_ID | Supplier Identifier |
CONTRACT_AMT_G | Contract Amount in Global Currency |
SYS_NC00064$ | |
CONTRACT_AMT_SG | Contract Amount in secondary Global Currency |
ABOVE_CONTRACT_AMT_B | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Function Currency. |
ABOVE_CONTRACT_AMT_G | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Global Currency. |
ABOVE_CONTRACT_AMT_SG | Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in secondary Global Currency. |
BELOW_CONTRACT_AMT_B | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Functional Currency. |
BELOW_CONTRACT_AMT_G | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Global Currency. |
BELOW_CONTRACT_AMT_SG | Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Secondary Global Currency. |
C_QUANTITY | Count Columns |
C_CONTRACT_AMT_B | Count Columns |
CATEGORY_ID | Category on the PO Line Identifier |
C_CONTRACT_AMT_G | Count Columns |
C_CONTRACT_AMT_SG | Count Columns |
C_ABOVE_CONTRACT_AMT_B | Count Columns |
C_ABOVE_CONTRACT_AMT_G | Count Columns |
C_ABOVE_CONTRACT_AMT_SG | Count Columns |
C_BELOW_CONTRACT_AMT_B | Count Columns |
C_BELOW_CONTRACT_AMT_G | Count Columns |
C_BELOW_CONTRACT_AMT_SG | Count Columns |
CONTRACT_TYPE | 1 for Blkt Releases, 2 for Scheduled Releases, 3 for PO referencing Global Agrmt, 4 for PO with Negotiated Pricing |
AGGREGATION_LEVEL | Grouping ID Column |
PO_ITEM_ID | Purchased Item Identifier |
SYS_NC00073$ | |
PARENT_COMPANY_ID | Parent Company Identifier |
COMPANY_ID | Company Identifier |
SYS_NC00063$ | |
PARENT_CC_ID | Parent Cost-center Identifier |
Application Object Library - POA_RTX_BS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00107$ | |
GRP_ID | Grouping ID Column |
SUPPLIER_SITE_ID | Supplier Site Identifier |
NUM_TXNS_RETURN_CNT | The number of return transactions |
SYS_NC00105$ | |
NUM_TXNS_RECEIPT_RETURN_CNT | The number of Receipt Returned transactions |
RECEIVING_ORG_ID | Receiving Organization Identifier |
BUYER_ID | Buyer Identifier |
SYS_NC00114$ | |
REASON_ID | Return Reason Identifier |
BASE_UOM | Base UOM |
SYS_NC00104$ | |
ENT_YEAR_ID | |
ENT_QTR_ID | Enterprise Quarter Identifier |
SYS_NC00113$ | |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
SYS_NC00103$ | |
DAY_ID | FII Day Identifier |
TIME_ID | Nested Grouping ID Column for Time |
AMT_RECEIPT_AND_DROPSHIP_B | Receipt amount excluding dropship transactions in functional currency |
SYS_NC00109$ | |
SYS_NC00110$ | |
AMT_RECEIPT_AND_DROPSHIP_G | Receipt amount excluding dropship transactions in primary global currency |
AMT_RECEIPT_AND_DROPSHIP_SG | Receipt amount excluding dropship transactions in secondary global currency |
SYS_NC00112$ | |
AMT_RECEIPT_B | Receipt Amount in functional currency |
AMT_RECEIPT_G | Receipt Amount in global currency |
SYS_NC00118$ | |
AMT_RECEIPT_SG | Receipt Amount in secondary global currency |
AMT_RETURN_B | Amount returned aggregated based on inspection date in functional currency |
SYS_NC00102$ | |
AMT_RETURN_G | Amount returned aggregated based on inspection date in global currency |
AMT_RETURN_SG | Amount returned aggregated based on inspection date in secondary global currency |
SYS_NC00108$ | |
AMT_RECEIPT_RETURN_B | Amount Returned aggregated based on Receipt Date in functional currency |
PERIOD_TYPE_ID | Nested Grouping ID Column for Period Type |
AMT_RECEIPT_RETURN_G | Amount Returned aggregated based on Receipt Date in global currency |
SYS_NC00111$ | |
AMT_RECEIPT_RETURN_SG | Amount Returned aggregated based on Receipt Date in secondary global currency |
QTY_RECEIPT_AND_DROPSHIP | Receipt quantity excluding dropship transactions |
SYS_NC00117$ | |
QTY_RECEIPT | Quantity Received |
QTY_RETURN | Quantity Returned |
QTY_REJECT | Quantity Rejected |
AMT_AFTERDUE_B | Amount Received after late tolerance in functional currency |
AMT_AFTERDUE_G | Amount Received after late tolerance in global currency |
AMT_AFTERDUE_SG | Amount Received after late tolerance in secondary global currency |
AMT_BEFOREDUE_B | Amount Received before early tolerance in functional currency |
AGGREGATION_LEVEL | Grouping ID Column |
AMT_BEFOREDUE_G | Amount Received before early tolerance in global currency |
SYS_NC00116$ | |
AMT_BEFOREDUE_SG | Amount Received before early tolerance in secondary global currency |
AMT_EXPT_B | Amount Received outside tolerance in functional currency |
AMT_EXPT_G | Amount Received outside tolerance in global currency |
AMT_EXPT_SG | Amount Received outside tolerance in secondary global currency |
QTY_INTOL | Quantity received in tolerance |
QTY_AFTERDUE | Quantity received after late tolerance |
QTY_BEFOREDUE | Quantity recieved before early tolerance |
NUM_DAYS_EARLY | the number of days early the receipt transactions took place |
NUM_DAYS_LATE | the number of days late the receipt transactions took place |
COMMODITY_ID | Commodity Identifier |
AMT_REJECT_B | Amount rejected aggregated based on inspection date in functional currency |
AMT_REJECT_G | Amount rejected aggregated based on inspection date in global currency |
AMT_REJECT_SG | Amount rejected aggregated based on inspection date in secondary global currency |
AMT_INSPECTED_B | Receipt Amount inspected in functional currency |
AMT_INSPECTED_G | Receipt Amount inspected in global currency |
AMT_INSPECTED_SG | Receipt Amount inspected in secondary global currency |
AMT_RECEIPT_REJECT_B | Amount Rejected aggregated based on Receipt Date in functional currency |
AMT_RECEIPT_REJECT_G | Amount Rejected aggregated based on Receipt Date in global currency |
AMT_RECEIPT_REJECT_SG | Amount Rejected aggregated based on Receipt Date in gsecondary lobal currency |
C_AMT_RECEIPT_AND_DROPSHIP_B | Count Columns |
CATEGORY_ID | Category on the PO Line Identifier |
C_AMT_RECEIPT_AND_DROPSHIP_G | Count Columns |
SYS_NC00106$ | |
C_AMT_RECEIPT_AND_DROPSHIP_SG | Count Columns |
C_AMT_RECEIPT_B | Count Columns |
C_AMT_RECEIPT_G | Count Columns |
C_AMT_RECEIPT_SG | Count Columns |
C_AMT_RETURN_B | Count Columns |
C_AMT_RETURN_G | Count Columns |
C_AMT_RETURN_SG | Count Columns |
C_AMT_RECEIPT_RETURN_B | Count Columns |
C_AMT_RECEIPT_RETURN_G | Count Columns |
PO_ITEM_ID | Purchased Item Identifier |
C_AMT_RECEIPT_RETURN_SG | Count Columns |
C_QTY_RECEIPT_AND_DROPSHIP | Count Columns |
C_QTY_RECEIPT | Count Columns |
C_QTY_RETURN | Count Columns |
C_QTY_REJECT | Count Columns |
C_AMT_AFTERDUE_B | Count Columns |
C_AMT_AFTERDUE_G | Count Columns |
C_AMT_AFTERDUE_SG | Count Columns |
C_AMT_BEFOREDUE_B | Count Columns |
C_AMT_BEFOREDUE_G | Count Columns |
ORG_ID | Operating Unit Identifier |
C_AMT_BEFOREDUE_SG | Count Columns |
SYS_NC00115$ | |
C_AMT_EXPT_B | Count Columns |
C_AMT_EXPT_G | Count Columns |
C_AMT_EXPT_SG | Count Columns |
C_QTY_INTOL | Count Columns |
C_QTY_AFTERDUE | Count Columns |
C_QTY_BEFOREDUE | Count Columns |
NUM_TXNS_EARLY_CNT | The number of receipt transactions that were early |
NUM_TXNS_LATE_CNT | The number of receipt transactions that were late |
C_AMT_REJECT_B | Count Columns |
SUPPLIER_ID | Supplier Identifier |
C_AMT_REJECT_G | Count Columns |
C_AMT_REJECT_SG | Count Columns |
C_AMT_INSPECTED_B | Count Columns |
C_AMT_INSPECTED_G | Count Columns |
C_AMT_INSPECTED_SG | Count Columns |
C_AMT_RECEIPT_REJECT_B | Count Columns |
C_AMT_RECEIPT_REJECT_G | Count Columns |
C_AMT_RECEIPT_REJECT_SG | Count Columns |
C_TOTAL | Row Count |
NUM_TXNS_RECEIPT_CNT | The number of receipt transactions |
Application Object Library - POA_PQC_BS_J2_MV | |
---|---|
Column Name | Descritpion |
FRID | FRID |
PO_ITEM_ID | Purchased Item Identifier |
BASE_UOM | Base UOM |
BUYER_ID | Buyer Identifier |
COMPANY_ID | Company identifier |
COST_CENTER_ID | Cost-center Identifier |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
DAY_ID | FII Day Identifier |
ENT_YEAR_ID | Enterprise Year Identifier |
PRID | PRID |
P_ENT_YEAR_ID | prior enterprise year identifier |
PURCHASE_AMT_G | Purchased Amount in global currency |
PURCHASE_AMT_SG | Purchased Amount in secondary global currency |
PURCHASE_AMT_B | Purchased Amount in functional currency |
QUANTITY | Quantity in Base UOM |
GLOBAL_CUR_CONV_RATE | Global currency conversion rate |
PIP_AMT_G | Prior enterprise year total purchased amount of the same item,uom,and operating unit, in global currency |
PIP_AMT_SG | Prior enterprise year total purchased amount of the same item,uom,and operating unit, in global currency |
PIP_AMT_B | Prior enterprise year total purchased amount of the same item,uom,and operating unit, in functional currency |
PIP_QUANTITY | Prior enterprise year total quantity of the same item,uom,and operating unit, in base UOM |
PSRID | PSRID |
PISP_AMT_G | Prior enterprise year total purchase amount of the same item,uom,and supplier, in global currency |
PISP_AMT_SG | Prior enterprise year total purchase amount of the same item,uom,and supplier, in global currency |
PISP_QUANTITY | Prior enterprise year total quantity of the same item,uom,and supplier, in base UOM |
PO_HEADER_ID | PO header identifier |
PO_LINE_ID | PO line identifier |
PO_RELEASE_ID | PO release identifier |
APPROVED_DATE | Earliest approval date |
ORDER_TYPE | Order Type |
CONSIGNED_CODE | Consigned Code |
COMPLEX_WORK_FLAG | Complex work flag |
ORG_ID | Operating Unit Identifier |
SHIP_TO_ORG_ID | Ship to Organization Identifier |
SUPPLIER_ID | Supplier Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
COMMODITY_ID | Commodity Identifier |
CATEGORY_ID | Category on the PO Line Identifier |
Application Object Library - POA_PQC_001_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
GRP_ID | Grouping ID Column |
COMPANY_ID | Company Identifier |
SYS_NC00051$ | |
COST_CENTER_ID | Cost-center Identifier |
ENT_QTR_ID | Enterprise Quarter Identifier |
SYS_NC00054$ | |
ENT_PERIOD_ID | Enterprise Period Identifier |
WEEK_ID | FII Week Identifier |
SYS_NC00044$ | |
DAY_ID | FII Day Identifier |
PBCQCO_AMT_G | Benchmark fallback amount per OU in global currency, ie, Current quantity * Current enterprise year benchmark price |
SYS_NC00047$ | |
PBCQCO_AMT_SG | Benchmark fallback amount per OU in secondary global currency, ie, Current quantity * Current enterprise year benchmark price |
C_PBCQCO_AMT_G | Count Columns |
SYS_NC00050$ | |
C_PBCQCO_AMT_SG | Count Columns |
TIME_ID | Nested Grouping ID Column for Time |
PBCQCO_AMT_B | Benchmark fallback amount per OU in functional currency, ie, Current quantity * Current enterprise year benchmark price |
SYS_NC00053$ | |
SYS_NC00052$ | |
C_PBCQCO_AMT_B | Count Columns |
PBPCQCO_AMT_G | Benchmark amount per OU in global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
SYS_NC00056$ | |
PBPCQCO_AMT_SG | Benchmark amount per OU in secondary global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
C_PBPCQCO_AMT_G | Count Columns |
SYS_NC00043$ | |
C_PBPCQCO_AMT_SG | Count Columns |
PBPCQCO_AMT_B | Benchmark amount per OU in functional currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
SYS_NC00046$ | |
C_PBPCQCO_AMT_B | Count Columns |
PBPCQCS_AMT_G | Benchmark amount per supplier in global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
PBPCQCS_AMT_SG | Benchmark amount per supplier in secondary global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
AGGREGATION_LEVEL | Grouping ID Column |
C_PBPCQCS_AMT_G | Count Columns |
C_PBPCQCS_AMT_SG | Count Columns |
PBPCQCS_AMT_B | Benchmark amount per supplier in functional currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
C_PBPCQCS_AMT_B | Count Columns |
PURCHASE_AMT_B | Purchased Amount in functional currency |
C_PURCHASE_AMT_B | Count Columns |
PURCHASE_AMT_G | Purchased Amount in global currency |
PURCHASE_AMT_SG | Purchased Amount in secondary global currency |
C_PURCHASE_AMT_G | Count |
C_PURCHASE_AMT_SG | Count |
ORG_ID | Operating Unit Identifier |
QUANTITY | Quantity in Base UOM |
SYS_NC00055$ | |
C_QUANTITY | Count Columns |
C_TOTAL | Row Count |
SUPPLIER_ID | Supplier Identifier |
COMMODITY_ID | Commodity Identifier |
SYS_NC00045$ | |
CATEGORY_ID | Category on the PO Line Identifier |
PO_ITEM_ID | Purchased Item Identifier |
SYS_NC00048$ | |
BASE_UOM | Base UOM |
Application Object Library - POA_PQC_BS_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
GRP_ID | Grouping ID Column |
CATEGORY_ID | Category on the PO Line Identifier |
SYS_NC00061$ | |
PO_ITEM_ID | Purchased Item Identifier |
BASE_UOM | Base UOM |
SYS_NC00051$ | |
BUYER_ID | Buyer Identifier |
ENT_YEAR_ID | |
SYS_NC00054$ | |
ENT_QTR_ID | Enterprise Quarter Identifier |
ENT_PERIOD_ID | Enterprise Period Identifier |
SYS_NC00057$ | |
WEEK_ID | FII Week Identifier |
DAY_ID | FII Day Identifier |
SYS_NC00047$ | |
PBCQCO_AMT_G | Benchmark fallback amount per OU in global currency, ie, Current quantity * Current enterprise year benchmark price |
TIME_ID | Nested Grouping ID Column for Time |
PBCQCO_AMT_SG | Benchmark fallback amount per OU in secondary global currency, ie, Current quantity * Current enterprise year benchmark price |
SYS_NC00060$ | |
SYS_NC00052$ | |
C_PBCQCO_AMT_G | Count Columns |
C_PBCQCO_AMT_SG | Count Columns |
SYS_NC00050$ | |
PBCQCO_AMT_B | Benchmark fallback amount per OU in functional currency, ie, Current quantity * Current enterprise year benchmark price |
C_PBCQCO_AMT_B | Count Columns |
SYS_NC00053$ | |
PBPCQCO_AMT_G | Benchmark amount per OU in global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
PBPCQCO_AMT_SG | Benchmark amount per OU in secondary global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
SYS_NC00056$ | |
C_PBPCQCO_AMT_G | Count Columns |
C_PBPCQCO_AMT_SG | Count Columns |
SYS_NC00059$ | |
PBPCQCO_AMT_B | Benchmark amount per OU in functional currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
PERIOD_TYPE_ID | Period Type |
C_PBPCQCO_AMT_B | Count Columns |
SYS_NC00046$ | |
PBPCQCS_AMT_G | Benchmark amount per supplier in global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
PBPCQCS_AMT_SG | Benchmark amount per supplier in secondary global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
C_PBPCQCS_AMT_G | Count Columns |
C_PBPCQCS_AMT_SG | Count Columns |
PBPCQCS_AMT_B | Benchmark amount per supplier in functional currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
C_PBPCQCS_AMT_B | Count Columns |
PURCHASE_AMT_B | Purchased Amount in functional currency |
C_PURCHASE_AMT_B | Count Columns |
PURCHASE_AMT_G | Purchased Amount in global currency |
AGGREGATION_LEVEL | Grouping ID Column |
PURCHASE_AMT_SG | Purchased Amount in secondary global currency |
SYS_NC00055$ | |
C_PURCHASE_AMT_G | Count |
C_PURCHASE_AMT_SG | Count |
QUANTITY | Quantity in Base UOM |
C_QUANTITY | Count Columns |
C_TOTAL | Row Count |
ORG_ID | Operating Unit Identifier |
SHIP_TO_ORG_ID | Ship to Organization Identifier |
SYS_NC00058$ | |
SUPPLIER_ID | Supplier Identifier |
SUPPLIER_SITE_ID | Supplier Site Identifier |
SYS_NC00048$ | |
COMMODITY_ID | Commodity Identifier |
Application Object Library - POA_PQC_002_MV | |
---|---|
Column Name | Descritpion |
SYS_NC00049$ | |
GRP_ID | Grouping ID Column |
COMPANY_ID | Company Identifier |
SYS_NC00051$ | |
COST_CENTER_ID | Cost-center Identifier |
TIME_ID | Nested Grouping ID Column for Time |
SYS_NC00041$ | |
PBCQCO_AMT_G | Benchmark fallback amount per OU in global currency, ie, Current quantity * Current enterprise year benchmark price |
PBCQCO_AMT_SG | Benchmark fallback amount per OU in secondary global currency, ie, Current quantity * Current enterprise year benchmark price |
SYS_NC00044$ | |
C_PBCQCO_AMT_G | Count Columns |
C_PBCQCO_AMT_SG | Count Columns |
SYS_NC00047$ | |
PBCQCO_AMT_B | Benchmark fallback amount per OU in functional currency, ie, Current quantity * Current enterprise year benchmark price |
C_PBCQCO_AMT_B | Count Columns |
SYS_NC00050$ | |
PBPCQCO_AMT_G | Benchmark amount per OU in global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
ORG_ID | Operating Unit Identifier |
PBPCQCO_AMT_SG | Benchmark amount per OU in secondary global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
SYS_NC00053$ | |
SYS_NC00052$ | |
C_PBPCQCO_AMT_G | Count Columns |
C_PBPCQCO_AMT_SG | Count Columns |
SYS_NC00043$ | |
PBPCQCO_AMT_B | Benchmark amount per OU in functional currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
C_PBPCQCO_AMT_B | Count Columns |
SYS_NC00046$ | |
PBPCQCS_AMT_G | Benchmark amount per supplier in global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
PBPCQCS_AMT_SG | Benchmark amount per supplier in secondary global currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
C_PBPCQCS_AMT_G | Count Columns |
C_PBPCQCS_AMT_SG | Count Columns |
PBPCQCS_AMT_B | Benchmark amount per supplier in functional currency, ie, Current quantity * Prior enterprise year benchmark price (use current if prior does not exist) |
SUPPLIER_ID | Supplier Identifier |
C_PBPCQCS_AMT_B | Count Columns |
PURCHASE_AMT_B | Purchased Amount in functional currency |
C_PURCHASE_AMT_B | Count Columns |
PURCHASE_AMT_G | Purchased Amount in global currency |
PURCHASE_AMT_SG | Purchased Amount in secondary global currency |
C_PURCHASE_AMT_G | Count |
C_PURCHASE_AMT_SG | Count |
QUANTITY | Quantity in Base UOM |
C_QUANTITY | Count Columns |
C_TOTAL | Row Count |
COMMODITY_ID | Commodity Identifier |
AGGREGATION_LEVEL | Grouping ID Column |
SYS_NC00042$ | |
CATEGORY_ID | Category on the PO Line Identifier |
PO_ITEM_ID | Purchased Item Identifier |
SYS_NC00045$ | |
BASE_UOM | Base UOM |
PARENT_COMPANY_ID | Parent Company Identifier |
SYS_NC00048$ | |
PARENT_CC_ID | Parent Cost-center Identifier |
Application Object Library - POS_PRODUCTS_SERVICES_GT | |
---|---|
Column Name | Descritpion |
SEGMENT_VALUE | |
LAST_UPDATE_LOGIN | |
CREATION_DATE | |
CREATED_BY | |
SEGMENT_VALUE_DESCRIPTION | |
SUPPLIER_SELECTION | |
PARENT_SEGMENT_VALUE | |
PARENT_SEGMENT_VALUE_ID | |
HIERARCHY_LEVEL | |
SEGMENT_VALUE_ID | |
LAST_UPDATE_DATE | |
LAST_UPDATED_BY |
Application Object Library - UMX_LSA_ROLE | |
---|---|
Column Name | Descritpion |
ADMIN_ROLE | |
PRIVILEGE8 | |
PRIVILEGE9 | |
PRIVILEGE10 | |
PRIVILEGE11 | |
PRIVILEGE12 | |
PRIVILEGE13 | |
PRIVILEGE14 | |
ROLE_SET_ID | |
CAN_UPDATE | |
CAN_CREATE_GRANT | |
CAN_ALTER_HIERARCHY | |
CAN_ASSIGN | |
CAN_REVOKE | |
SECURITY_WIZARD | |
PRIVILEGE7 |
Application Object Library - UMX_LSA_ROLE_GLOBAL_PRIVS | |
---|---|
Column Name | Descritpion |
ADMIN_ROLE | |
GLOBAL_PRIV9 | |
CAN_CREATE | |
GLOBAL_PRIV2 | |
GLOBAL_PRIV3 | |
GLOBAL_PRIV4 | |
GLOBAL_PRIV5 | |
GLOBAL_PRIV6 | |
GLOBAL_PRIV7 | |
GLOBAL_PRIV8 |
Application Object Library - UMX_LSA_ROLE_SET_CRITERIA | |
---|---|
Column Name | Descritpion |
ROLE_SET_ID | |
ROLE_SET_NAME | |
ROLE_CAT | |
ROLE_APPL | |
ROLE_NAME |
Application Object Library - UMX_LSA_ROLE_SET_ROLES | |
---|---|
Column Name | Descritpion |
ROLE_SET_ID | |
ROLE_NAME |