| Oracle iProcurement - ICX_AUDIT | Web transactions audit table |
|---|---|
| Column Name | Descritpion |
| AUDIT_ID | Identifier of audit record |
| PARAMETER_NAME_2 | Second parameter name |
| PARAMETER_2 | Second parameter value |
| PARAMETER_NAME_3 | Third parameter name |
| PARAMETER_3 | Third parameter value |
| PARAMETER_NAME_4 | Fourth parameter name |
| PARAMETER_4 | Fourth parameter value |
| PARAMETER_NAME_5 | Fifth parameter name |
| PARAMETER_5 | Fifth parameter value |
| PARAMETER_NAME_6 | Sixth parameter name |
| PARAMETER_6 | Sixth parameter value |
| SESSION_ID | Identifier of session in which audit record created |
| PARAMETER_NAME_7 | Seventh parameter name |
| PARAMETER_7 | Seventh parameter value |
| PARAMETER_NAME_8 | Eighth parameter name |
| PARAMETER_8 | Eighth parameter value |
| PARAMETER_NAME_9 | Nineth parameter name |
| PARAMETER_9 | Nineth parameter value |
| CONNECT_DATE | Audit record creation date and time |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| WEB_USER_ID | Identifier of user when audit record created |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SERVER_NAME | Server name |
| SERVER_PORT | Server port |
| SCRIPT_NAME | What was being run |
| PATH_INFO | What URL was being accessed |
| PARAMETER_NAME_1 | First parameter name |
| PARAMETER_1 | First parameter value |
| Oracle iProcurement - ICX_FAILURES | Web Store failures table |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| USER_NAME | Username of the web user when the failure ocurred |
| PASSWORD | Obsolete |
| FAILURE_CODE | Failure code |
| FAILURE_DATE | Date of failure |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| Oracle iProcurement - ICX_SESSIONS | Session context table |
|---|---|
| Column Name | Descritpion |
| SESSION_ID | Identifier for each session created by a user login |
| DATE_FORMAT_MASK | Date format preference |
| COUNTER | How many hits a User has made |
| FIRST_CONNECT | Date and time of login |
| LAST_CONNECT | Date and time of last hit |
| LIMIT_TIME | Time limit for this session |
| LIMIT_CONNECTS | Number of hits allowed in this session |
| DISABLED_FLAG | Indicates whether this is a valid session |
| PSEUDO_FLAG | Indicates whether this session was created due to an access external to Oracle Applications, for example email. |
| CREATED_BY | Identifier for each session created by a user login |
| CREATION_DATE | Standard Who column |
| USER_ID | Identifier of the user logged in for this session |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| WINDOW_ID | |
| RESPONSIBILITY_APPLICATION_ID | |
| SECURITY_GROUP_ID | |
| FUNCTION_TYPE | |
| LANGUAGE_CODE | |
| NLS_DATE_LANGUAGE | Date Language preference |
| NLS_NUMERIC_CHARACTERS | Numeric Characters preference |
| MODE_CODE | Type code for the session; WEBAPPS for full access and SLAVE for function calling. |
| NLS_SORT | Collating sequence for order by clauses |
| NLS_TERRITORY | |
| PAGE_ID | |
| LOGIN_ID | FND_LOGINS_S derived. Used for auditing with LAST_UPDATE_LOGIN columns |
| NODE_ID | |
| MAC_KEY | |
| ENC_KEY | |
| XSID | |
| TIME_OUT | |
| GUEST | |
| HOME_URL | Home URL address. If it is not null, it overrides HOME_URL in ICX_PARAMETERS when exit icon clicked |
| DISTRIBUTED | |
| PROXY_USER_ID | |
| RESPONSIBILITY_ID | Identifier of current Responsibility |
| ORG_ID | Identifier of current Organization |
| MENU_ID | Identifier of current Menu |
| FUNCTION_ID | Identifier of current Function |
| NLS_LANGUAGE | Language preference |
| Oracle iProcurement - ICX_SHOPPING_CARTS | Web Requisitions headers table |
|---|---|
| Column Name | Descritpion |
| CART_ID | Requisition header unique identifier |
| EMERGENCY_FLAG | Indicates whether emergency requisition or not |
| APPROVER_ID | Approver unique identifier |
| APPROVER_NAME | Approver name |
| NOTE_TO_APPROVER | Note to approver |
| REQ_NUMBER_SEGMENT1 | Requisition number |
| LAST_UPDATE_DATE | Standard Who Column |
| HEADER_DESCRIPTION | Header description |
| HEADER_ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
| HEADER_ATTRIBUTE1 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE2 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE3 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard Who Column |
| HEADER_ATTRIBUTE4 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE5 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE6 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE7 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE8 | Descriptive flexfield segment |
| CREATION_DATE | Standard Who Column |
| HEADER_ATTRIBUTE9 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE10 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE11 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE12 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE13 | Descriptive flexfield segment |
| CREATED_BY | Standard Who Column |
| HEADER_ATTRIBUTE14 | Descriptive flexfield segment |
| HEADER_ATTRIBUTE15 | Descriptive flexfield segment |
| NOTE_TO_BUYER | Note to buyer |
| RESERVED_PO_NUM | PO number for emergency requisitions |
| LAST_UPDATE_LOGIN | Standard Who Column |
| DESTINATION_TYPE_CODE | Requisition destination type |
| DESTINATION_ORGANIZATION_ID | Destination organization unique identifier |
| DELIVER_TO_LOCATION_ID | Deliver-to-location unique identifier |
| DELIVER_TO_REQUESTOR_ID | Requester unique identifier |
| SHOPPER_ID | User ID of the person logged in |
| NEED_BY_DATE | Date the order is needed (default for all items) |
| ORG_ID | Organization unique identifier |
| DELIVER_TO_LOCATION | Deliver-to-location code |
| DELIVER_TO_REQUESTOR | Requester name |
| SAVED_FLAG | Indicates whether requisition submitted or saved for later completion |
| Oracle iProcurement - ICX_SHOPPING_CART_LINES | Web Requisitions lines table |
|---|---|
| Column Name | Descritpion |
| CART_LINE_ID | Requisition line unique identifier |
| LAST_UPDATE_LOGIN | Standard Who column |
| CUSTOM_DEFAULTED | Indicates defaulting accounts have been customized |
| CART_ID | Requisition header unique identifier |
| LINE_ID | Document line unique identifier (from PO_LINES) |
| ITEM_DESCRIPTION | Item description |
| QUANTITY | Quantity |
| UNIT_PRICE | Unit price |
| ITEM_ID | Item unique identifier |
| ITEM_REVISION | Item revision |
| CATEGORY_ID | Category unique identifier |
| UNIT_OF_MEASURE | Unit of measure |
| LINE_TYPE_ID | Requisition line type unique identifier |
| EXPENDITURE_TYPE | Project Accounting expenditure type |
| CART_LINE_NUMBER | Line number |
| DESTINATION_ORGANIZATION_ID | Destination organization unique identifier |
| DELIVER_TO_LOCATION_ID | Deliver-to-location unique identifier |
| SUGGESTED_BUYER_ID | Suggested buyer unique identifier |
| SUGGESTED_VENDOR_NAME | Suggested supplier name |
| SUGGESTED_VENDOR_SITE | Suggested supplier site |
| LAST_UPDATE_DATE | Standard Who column |
| LINE_ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
| LINE_ATTRIBUTE1 | Descriptive flexfield segment |
| LINE_ATTRIBUTE2 | Descriptive flexfield segment |
| LINE_ATTRIBUTE3 | Descriptive flexfield segment |
| LINE_ATTRIBUTE4 | Descriptive flexfield segment |
| LINE_ATTRIBUTE5 | Descriptive flexfield segment |
| LINE_ATTRIBUTE6 | Descriptive flexfield segment |
| LINE_ATTRIBUTE7 | Descriptive flexfield segment |
| LINE_ATTRIBUTE8 | Descriptive flexfield segment |
| LINE_ATTRIBUTE9 | Descriptive flexfield segment |
| LINE_ATTRIBUTE10 | Descriptive flexfield segment |
| LINE_ATTRIBUTE11 | Descriptive flexfield segment |
| LINE_ATTRIBUTE12 | Descriptive flexfield segment |
| LINE_ATTRIBUTE13 | Descriptive flexfield segment |
| LINE_ATTRIBUTE14 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| LINE_ATTRIBUTE15 | Descriptive flexfield segment |
| NEED_BY_DATE | Date the item is needed internally |
| AUTOSOURCE_DOC_HEADER_ID | Autosource document header unique identifier |
| AUTOSOURCE_DOC_LINE_NUM | Autosource document line number |
| PROJECT_ID | Project Accounting project unique identifier |
| CREATION_DATE | Standard Who column |
| TASK_ID | Project Accounting task unique identifier |
| EXPENDITURE_ITEM_DATE | Project Accounting expenditure item date |
| SUGGESTED_VENDOR_CONTACT | Suggested supplier contact |
| SUGGESTED_VENDOR_PHONE | Suggested supplier phone number |
| SUGGESTED_VENDOR_ITEM_NUM | Suggested supplier item number |
| EXPENDITURE_ORGANIZATION_ID | Project Accounting expenditure organization unique identifier |
| CREATED_BY | Standard Who column |
| SUPPLIER_ITEM_NUM | Supplier's item number |
| ORG_ID | Organization unique identifier |
| EXPRESS_NAME | Template name |
| ITEM_NUMBER | Item number |
| DELIVER_TO_LOCATION | Deliver-to-location code |
| Oracle iProcurement - ICX_WEB_STORE_OPTIONS | Default values for Web Store system configurable options per operating unit |
|---|---|
| Column Name | Descritpion |
| ITEM_TEMPLATE | |
| CATEGORY_TEMPLATE | |
| ITEM_DESC | Designated freight charge item description |
| FCURRENCY_CODE | Default freight charge currency code |
| FREIGHT_AMT | Default freight charge amount |
| GUEST_USERNAME | Default guest customer web user logon name |
| FREIGHT_FLAG | Indicator of freight charge calculated as 'P'ercentage,'F'ixed, or 'C'ustom rate |
| NON_SHIPITEM_ID | Default non-shippable item ID |
| ORG_ID | Operating Unit ID |
| ORDER_TYPE_ID | Default order type ID lookup from so_order_types_all |
| CATEGORY_SET_ID | Default cateogry set ID lookup from so_category_sets |
| PRICE_LIST_ID | Default business partner price list ID lookup from SO_PRICE_LISTS |
| ORDER_SOURCE_ID | Default order source ID lookup from SO_ORDER_SOURCES |
| USE_WEB_ORDER_TYPE | Indicator for ordering using order type ID from this table |
| USE_WEB_PRICE_LIST | Indicator for ordering using price list ID from this table |
| USE_ORDER_IMPORT_PRICING_RULES | Indicator for using order import pricing rule |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CONSUMER_ALLOW_CREDIT_CARDS | Indicates if credit card orders are allowed for consumers |
| GUEST_PASSWORD | Default customer web user account password |
| PARTNER_ALLOW_CREDIT_CARDS | Indicates if credit card orders are allowed for business partners |
| CREDIT_CARD_ORDER_TYPE_ID | Order type used for credit card orders |
| RECEIPT_METHOD_ID | |
| OTS_CARTRIDGE_PATH | |
| ENABLE_CALL_BACK | |
| EMAIL_CARTRIDGE_PATH | |
| GUEST_PRICE_LIST_ID | Default consumer price list id |
| ENABLE_EMAIL | |
| DEFAULT_EMAIL_ADDRESS | |
| COMPANY_HOME_PAGE_URL | |
| DEFAULT_UOM |
| Oracle iProcurement - ICX_VERSIONS | Current version table for Oracle Self Service Web Applications |
|---|---|
| Column Name | Descritpion |
| VERSION | Current version of OSSWA |
| DESCRIPTION | Description for the current version of OSSWA |
| Oracle iProcurement - ICX_PARAMETERS | Setup information table |
|---|---|
| Column Name | Descritpion |
| SESSION_COOKIE | Session Cookie |
| 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 |
| HOME_URL | The default URL when the user clicks on Exit |
| QUERY_SET | The maximum number of rows to be displayed at one time. If the number of result rows is larger then the user has to be provided with a method to view next and previous sets of records. |
| MAX_ROWS | |
| WEBMASTER_EMAIL | Email address of the sites Webmaster |
| SESSION_COOKIE_NAME | Session Cookie Name |
| WINDOW_COOKIE_NAME | Window Cookie Name |
| SESSION_COOKIE_DOMAIN | Session Cookie Domain |
| Oracle iProcurement - ICX_COLORS | Color standards table |
|---|---|
| Column Name | Descritpion |
| NAME | Code of color |
| COLOR_VALUE | Hexadecimal color value |
| DESCRIPTION | Description of color |
| Oracle iProcurement - ICX_TEXT | Parameter encryption table |
|---|---|
| Column Name | Descritpion |
| TEXT_ID | Identifier placed on HTML page, then used to recover data |
| SESSION_ID | Used to ensure the user accessing data is the user who put it there |
| TEXT | Unvalidated text |
| TIMESTAMP | Creation date. It is used to remove old rows. |
| Oracle iProcurement - ICX_USER_PROFILES | Obsolete |
|---|---|
| Column Name | Descritpion |
| REQ_OVERRIDE_LOCATION_FLAG | |
| DAYS_NEEDED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| WEB_USER_ID | |
| LAST_UPDATE_LOGIN | |
| REQ_DEFAULT_TEMPLATE | |
| REQ_OVERRIDE_REQUESTOR_CODE |
| Oracle iProcurement - ICX_CART_DISTRIBUTIONS | Web Requisitions headers distribution table |
|---|---|
| Column Name | Descritpion |
| CART_ID | Requisition header unique identifier |
| CHARGE_ACCOUNT_SEGMENT3 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT4 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT5 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT6 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT7 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT8 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT9 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT10 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT11 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT12 | Key flexfield segment |
| DISTRIBUTION_ID | Requisition distribution unique identifier |
| CHARGE_ACCOUNT_SEGMENT13 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT14 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT15 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT16 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT17 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT18 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT19 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT20 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT21 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT22 | Key flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| CHARGE_ACCOUNT_SEGMENT23 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT24 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT25 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT26 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT27 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT28 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT29 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT30 | Key flexfield segment |
| ORG_ID | Organization unique identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| CHARGE_ACCOUNT_SEGMENT1 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT2 | Key flexfield segment |
| Oracle iProcurement - ICX_CART_LINE_DISTRIBUTIONS | Web Requisitions lines distribution table |
|---|---|
| Column Name | Descritpion |
| CART_LINE_ID | Requisiton line unique identifier |
| CHARGE_ACCOUNT_SEGMENT2 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT3 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT4 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT5 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT6 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT7 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT8 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT9 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT10 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT11 | Key flexfield segment |
| DISTRIBUTION_ID | Requisition distribution unique identifier |
| CHARGE_ACCOUNT_SEGMENT12 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT13 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT14 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT15 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT16 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT17 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT18 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT19 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT20 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT21 | Key flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| CHARGE_ACCOUNT_SEGMENT22 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT23 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT24 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT25 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT26 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT27 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT28 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT29 | Key flexfield segment |
| CHARGE_ACCOUNT_SEGMENT30 | Key flexfield segment |
| DIST_ATTRIBUTE_CATEGORY | Descriptive flexfield structure defining column |
| LAST_UPDATE_DATE | Standard Who column |
| DISTRIBUTION_ATTRIBUTE1 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE2 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE3 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE4 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE5 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE6 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE7 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE8 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE9 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE10 | Descriptive flexfield segment |
| LAST_UPDATE_LOGIN | Standard Who column |
| DISTRIBUTION_ATTRIBUTE11 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE12 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE13 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE14 | Descriptive flexfield segment |
| DISTRIBUTION_ATTRIBUTE15 | Descriptive flexfield segment |
| ACCRUAL_ACCOUNT_ID | GL accrual account unique identifier |
| VARIANCE_ACCOUNT_ID | GL variance account unique identifier |
| BUDGET_ACCOUNT_ID | GL budget account unique identifier |
| ORG_ID | Organization unique identifier |
| CREATION_DATE | Standard Who column |
| CART_ID | Requisition header unique identifier |
| ALLOCATION_TYPE | Specifies the method of allocation across distributions. Can be PERCENT. |
| ALLOCATION_VALUE | Allocation split value |
| ALLOCATION_QUANTITY | For future use |
| CHARGE_ACCOUNT_NUM | Concatenated charge account segment |
| CREATED_BY | Standard Who column |
| DISTRIBUTION_NUM | Distribution number |
| CHARGE_ACCOUNT_ID | GL charge account unique identifier |
| CHARGE_ACCOUNT_SEGMENT1 | Key flexfield segment |
| Oracle iProcurement - ICX_OE_CART_LINES | Obsolete |
|---|---|
| Column Name | Descritpion |
| CART_LINE_ID | |
| ITEM_NUMBER | |
| ORG_ID | |
| DESCRIPTION | |
| LINE_ID | |
| CATEGORY_ID | |
| ITEM_ID | |
| UNIT_OF_MEASURE | |
| CREATION_DATE | |
| QUANTITY | |
| PRICE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| CART_ID |
| Oracle iProcurement - ICX_RELATED_CATEGORIES | Table used to define category hierarchies |
|---|---|
| Column Name | Descritpion |
| CATEGORY_SET_ID | Category set ID for the relation defined by this row |
| CATEGORY_ID | Parent category for the parent-child relation defined by this row |
| RELATED_CATEGORY_ID | Child category for the parent-child relation defined by this row |
| RELATIONSHIP_TYPE | Relation defined in this row. If releation is TOP, then the category in CATEGORY_ID is at the top of the heirarchy and RELATED_CATEGORY_ID will be the same as CATEGORY_ID. |
| 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 |
| Oracle iProcurement - ICX_REQ_CART_ERRORS | Web Requisitions errors table |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| ERROR_TEXT | Error text |
| ERROR_ID | Error unique identifier |
| CART_ID | Requisition header unique identifier |
| CART_LINE_ID | Requisition line unique identifier |
| DISTRIBUTION_NUM | Distribution number |
| LAST_UPDATED_BY | Standard Who column |
| Oracle iProcurement - ICX_OE_CARTS | Obsolete |
|---|---|
| Column Name | Descritpion |
| CART_ID | |
| ORDER_TYPE | |
| NEED_BY_DATE | |
| SITE_ID | |
| PRICE_LIST_ID | |
| PURCHASE_ORDER_NUM | |
| ORG_ID | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| SHOPPER_ID | |
| SAVED_FLAG | |
| WEB_ORDER_NUM |
| Oracle iProcurement - ICX_OE_CART_ERRORS | Obsolete |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_LOGIN | |
| CREATION_DATE | |
| CREATED_BY | |
| ERROR_TEXT | |
| ERROR_ID | |
| CART_ID | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE |
| Oracle iProcurement - ICX_MARGIN_ANALYSIS | Margin analysis by different categories for different periods |
|---|---|
| Column Name | Descritpion |
| BUILD_ID | Build identifier |
| INVOICED_AMOUNT | Invoiced amount |
| COGS_AMOUNT | Cost of goods sold amount |
| MARGIN | Margin amount for the specified period |
| CUSTOMER_ID | Customer identifier |
| PRIMARY_SALESREP_ID | Primary sales person identifier |
| TERRITORY_ID | Territory identifier |
| INVENTORY_ITEM_ID | Inventory item identifier |
| PARENT_INVENTORY_ITEM_ID | Parent inventory item identifier in case of a non-standard item |
| ORG_ID | Organization unique identifier |
| SOLD_TO_CUSTOMER_NAME | Customer name based on customer identifier |
| PERIOD | Period of the margin analysis: 7 days, 30 days, or 90 days |
| Oracle iProcurement - ICX_MARGIN_ANALYSIS_ERR | Stores failing record while building ICX_MARGIN_ANALYSIS table |
|---|---|
| Column Name | Descritpion |
| BUILD_ID | Build identifier |
| CUSTOMER_ID | Customer identifier |
| PRIMARY_SALESREP_ID | Primary sales person identifier |
| TERRITORY_ID | Territory identifier |
| INVENTORY_ITEM_ID | Inventory item identifier |
| PERIOD | Period of the margin analysis: 7 days, 30 days, or 90 days |
| Oracle iProcurement - ICX_PANEL_SUMMARY | Customer summary including orders, returns, cancellations, and service requests |
|---|---|
| Column Name | Descritpion |
| LAST_ORDER_HEADER_ID | Identifier of the last order |
| ORDERS_AMOUNT_LAST_WEEK | Total amount of orders placed last week |
| ORDERS_LAST_WEEK | Number of orders placed last week |
| ORDERS_AMOUNT_LAST_MONTH | Total amount of orders placed last month |
| ORDERS_LAST_MONTH | Number of orders placed last month |
| ORDERS_AMOUNT_LAST_3_MONTHS | Total amount of orders placed in last 3 months |
| ORDERS_LAST_3_MONTHS | Number of placed in last 3 months |
| ORDERS_AMOUNT_LAST_6_MONTHS | Total amount of orders placed in last 6 months |
| ORDERS_LAST_6_MONTHS | Number of orders placed in last 6 months |
| ORG_ID | Organization unique identifier |
| ORDERS_AMOUNT_LAST_12_MONTHS | Total amount of orders placed in last 12 months |
| ORDERS_LAST_12_MONTHS | Number of orders placed in last 12 months |
| CANCELLED_ORDERS_3_MONTHS | Number of orders cancelled within last 3 months |
| CANCELLED_AMOUNT_3_MONTHS | Total amount of orders cancelled within last 3 months |
| CANCELLED_ORDERS_6_MONTHS | Number of orders cancelled within last 6 months |
| CANCELLED_AMOUNT_6_MONTHS | Total amount of orders cancelled within last 6 months |
| RMA_3_MONTHS | Number of returns within last 3 months |
| RMA_AMOUNT_3_MONTHS | Total amount of returns within last 3 months |
| RMA_6_MONTHS | Number of returns within last 6 months |
| RMA_AMOUNT_6_MONTHS | Total amount of returns within last 6 months |
| CUSTOMER_ID | Customer identifier |
| LAST_ORDER_DATE | Date of the last order |
| LAST_ORDER_NUMBER | User-visible number of the last order |
| SHIPMENTS_OPEN | Not used |
| SHIPMENTS_LATE | Not used |
| CREDIT_RATING | Credit rating for the customer |
| RISK_CODE | Risk code for the customer |
| LATE_PAYMENTS_3_MONTHS | Total amount of late payments within last 3 months |
| LATE_PAYMENTS_6_MONTHS | Total amount of late payments within last 6 months |
| AMOUNT_DUE | Current amount due |
| SERVICE_CALLS_3_MONTHS | Number of service calls within last 3 months |
| DATA_AS_OF_DATE | Record creation date |
| DATE_OF_LAST_SERVICE_CALL | Date of last service call |
| SITE_ID_LAST_SERVICE_CALL | Site id from which the last service call was made |
| SERVICE_AMOUNT_6_MONTHS | Total amount of service order requests within last 6 months |
| SERVICE_ORDERS_6_MONTHS | Total number of service order requests within last 6 months |
| SERVICE_AMOUNT_12_MONTHS | Total amount of service order requests within last 12 months |
| SERVICE_ORDERS_12_MONTHS | Total number of service order requests within last 12 months |
| PROGRAM_APPLICATION_ID | Concurrent who column |
| LAST_SERVICE_CALL_CONTACT | Customer contact for the last service call |
| ATTRIBUTE1 | Descriptive flexfield segment column |
| ATTRIBUTE2 | Descriptive flexfield segment column |
| ATTRIBUTE3 | Descriptive flexfield segment column |
| ATTRIBUTE4 | Descriptive flexfield segment column |
| ATTRIBUTE5 | Descriptive flexfield segment column |
| ATTRIBUTE6 | Descriptive flexfield segment column |
| ATTRIBUTE7 | Descriptive flexfield segment column |
| ATTRIBUTE8 | Descriptive flexfield segment column |
| PROGRAM_UPDATE_DATE | Concurrent who column |
| ATTRIBUTE9 | Descriptive flexfield segment column |
| ATTRIBUTE10 | Descriptive flexfield segment column |
| ATTRIBUTE11 | Descriptive flexfield segment column |
| ATTRIBUTE12 | Descriptive flexfield segment column |
| SAME_SUPPLY_CHAIN_FLAG | Is the customer a supplier as well? |
| CURRENCY_CODE | Currency for all amounts |
| Oracle iProcurement - ICX_PO_REVISIONS_TEMP | Comparison results of two revisions of a PO |
|---|---|
| Column Name | Descritpion |
| LINE_SEQ | Unique identifier for comparison results of two PO revisions |
| REVISION_NUM | Revision number for the PO |
| LINE_NUM | Corresponding PO line number |
| LOCATION_NUM | Location number of the corresponding PO line |
| DISTRIBUTION_NUM | Distribution number of the corresponding PO line |
| LEVEL_ALTERED | Level alteration. Possible values are for header, line, location, or distribution. |
| FIELD_ALTERED | Field alteration, such as quantity, amount, or promised date |
| CHANGES_FROM | Old value of the altered field |
| CHANGES_TO | New value of the altered field |
| CREATION_DATE | Time stamp of the comparison |
| HEADER_ID | Unique identifier of the corresponding PO headers record |
| RELEASE_ID | Unique identifier of the corresponding PO release record |
| LINE_ID | Unique identifier of the corresponding PO line record |
| LOCATION_ID | Unique identifier of the corresponding PO line location record |
| DISTRIBUTION_ID | Unique identifier of the corresponding PO distribution record |
| ITEM_ID | Unique identifier for the corresponding line item record |
| PO_NUM | PO number |
| Oracle iProcurement - ICX_CONTEXT_RESULTS_TEMP | ConText queries table |
|---|---|
| Column Name | Descritpion |
| TEXTKEY | First Column for primary key returned by ConText query |
| TEXTKEY2 | Second Column for primary key returned by ConText query |
| SCORE | Score returned by ConText query |
| CONID | Identifier for a specific ConText query result set |
| DATESTAMP | Creation date. It is used to remove old rows. |
| Oracle iProcurement - ICX_STORE_INDEX | Web Store Index table |
|---|---|
| Column Name | Descritpion |
| CATEGORY_ID | Category identifier |
| CATEGORY_DESCRIPTION | Category description |
| ORGANIZATION_ID | Inventory organization identifier |
| CATEGORY_SET_ID | Category set identifier |
| PRICE_LIST_ID | Price list identifier |
| GROUP_ROW_NUMBER | Category's sequence within a group |
| INDEX_GROUP | Index grouping that the category belongs to |
| Oracle iProcurement - ICX_CATG_DETLS_INFO | Category details display attributes |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who column |
| DEFAULT_TEMPLATE_CONSUMER | Default consumer template for the items in the category |
| MARKETING_TEXT_FILE | Marketing text file name |
| MARKETING_TEXT | Marketing text - displayed on the web page |
| SPECIAL_FLAG_BUSINESS | Special flag - Indicates whether a category item is on sale for business |
| SPECIAL_IMAGE_BUSINESS | Special image file name for the business user |
| SPECIAL_TEXT_BUSINESS | Special text file name for the business user |
| SPECIAL_THUMBNAIL_BUSINESS | Thumbnail image for business user |
| SPECIAL_START_DATE_BUSINESS | Start date for special image display for business |
| CREATED_DATE | Standard Who column |
| SPECIAL_END_DATE_BUSINESS | End date for special image display for business |
| SPECIAL_FLAG_CONSUMER | Special flag - Indicates whether a category item is on sale for consumer |
| SPECIAL_START_DATE_CONSUMER | Start date for special image display for consumer |
| SPECIAL_END_DATE_CONSUMER | End date for special image display for consumer |
| SPECIAL_THUMBNAIL_CONSUMER | Thumbnail image for consumer |
| SPECIAL_IMAGE_CONSUMER | Special image file name for the consumer user |
| LAST_UPDATED_BY | Standard Who column |
| SPECIAL_TEXT_CONSUMER | Special text file name for the consumer user |
| IMAGE_FILE_1 | Image file name |
| IMAGE_FILE_2 | Image file name |
| IMAGE_FILE_3 | Image file name |
| IMAGE_FILE_4 | Image file name |
| IMAGE_FILE_5 | Image file name |
| IMAGE_FILE_6 | Image file name |
| IMAGE_FILE_7 | Image file name |
| IMAGE_FILE_8 | Image file name |
| IMAGE_FILE_9 | Image file name |
| LAST_UPDATE_DATE | Standard Who column |
| IMAGE_FILE_10 | Image file name |
| IMAGE_FILE_11 | Image file name |
| IMAGE_FILE_12 | Image file name |
| IMAGE_FILE_13 | Image file name |
| IMAGE_FILE_14 | Image file name |
| IMAGE_FILE_15 | Image file name |
| LAST_UPDATE_LOGIN | Standard Who column |
| CATEGORY_ID | Category unique identifier |
| TEMPLATE_BUSINESS | Business user category template |
| TEMPLATE_CONSUMER | Consumer user category template |
| DEFAULT_TEMPLATE_BUSINESS | Default business template for the items in the category |
| Oracle iProcurement - ICX_ITEM_DETLS_INFO | Item details display attributes |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who column |
| MARKETING_TEXT | Marketing text displayed in the item details page |
| SPECIAL_FLAG_BUSINESS | Special flag for business user enabled, when item is on sale |
| SPECIAL_TEXT_BUSINESS | Special text file name for business user |
| SPECIAL_IMAGE_BUSINESS | Special image file name for business user |
| SPECIAL_THUMBNAIL_BUSINESS | Thumbnail image for business user |
| SPECIAL_START_DATE_BUSINESS | Start date for the special image display for business |
| SPECIAL_END_DATE_BUSINESS | End date for special image display for business |
| CREATED_DATE | Standard Who column |
| SPECIAL_FLAG_CONSUMER | Special flag for consumer user enabled, when item is on sale |
| SPECIAL_START_DATE_CONSUMER | Start date for special image display for consumer |
| SPECIAL_END_DATE_CONSUMER | End date for special image display for consumer |
| SPECIAL_THUMBNAIL_CONSUMER | Thumbnail image for consumer user |
| SPECIAL_TEXT_CONSUMER | Special text file name for consumer user |
| SPECIAL_IMAGE_CONSUMER | Special image file name for consumer user |
| IMAGE_FILE_1 | Image file name |
| LAST_UPDATED_BY | Standard Who column |
| IMAGE_FILE_2 | Image file name |
| IMAGE_FILE_3 | Image file name |
| IMAGE_FILE_4 | Image file name |
| IMAGE_FILE_5 | Image file name |
| IMAGE_FILE_6 | Image file name |
| IMAGE_FILE_7 | Image file name |
| IMAGE_FILE_8 | Image file name |
| IMAGE_FILE_9 | Image file name |
| IMAGE_FILE_10 | Image file name |
| IMAGE_FILE_11 | Image file name |
| LAST_UPDATE_DATE | Standard Who column |
| IMAGE_FILE_12 | Image file name |
| IMAGE_FILE_13 | Image file name |
| IMAGE_FILE_14 | Image file name |
| IMAGE_FILE_15 | Image file name |
| LAST_UPDATE_LOGIN | Standard Who column |
| INVENTORY_ITEM_ID | Inventory item unique identifier |
| TEMPLATE_BUSINESS | Business user template name |
| TEMPLATE_CONSUMER | Consumer user template name |
| MARKETING_TEXT_FILE | Marketing text file name |
| Oracle iProcurement - ICX_CATG_DETLS_INFO_TL | Translation table for category marketing text |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who Column |
| CREATED_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| CATEGORY_ID | Category Id |
| MARKETING_TEXT | Language specific marketing text |
| SOURCE_LANG | Source language |
| LANGUAGE | Marketing text language |
| Oracle iProcurement - ICX_ITEM_DETLS_INFO_TL | Translation table for item marketing text |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who column |
| CREATED_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| INVENTORY_ITEM_ID | Inventory item id |
| MARKETING_TEXT | Language specfic marketing text |
| SOURCE_LANG | Source language |
| LANGUAGE | Marketing text language |
| Oracle iProcurement - ICX_CUSTOM_MENU_ENTRIES | Contains menu entries which user can access |
|---|---|
| Column Name | Descritpion |
| USER_ID | User ID of the logged-on user |
| RESPONSIBILITY_APPLICATION_ID | Application ID of the responsibility for accessing this plug |
| RESPONSIBILITY_ID | Responsibility ID of the responsibility for accessing this plug |
| SECURITY_GROUP_ID | security group identifier, in which security groups is used to partition data in a Service Bureau architecture |
| FUNCTION_ID | The corresponding function ID of this plug |
| FUNCTION_TYPE | Function type of this function |
| URL | URL of this function (if any) |
| NEW_WINDOW | |
| PLUG_ID | ID of a plug (region) |
| REFERENCE_PATH | |
| FAVORITE_TYPE | Favorite_type col |
| DISPLAY_SEQUENCE | display order of plugs (regions) |
| CREATED_BY | Standard who col |
| CREATION_DATE | Standard Who Col |
| PROMPT | A descriptive name of plug (region) |
| LAST_UPDATED_BY | Standard Who Col |
| LAST_UPDATE_DATE | Standard Who Col |
| LAST_UPDATE_LOGIN | Standard Who Col |
| Oracle iProcurement - ICX_PAGES | Defines all pages information of each PHP user |
|---|---|
| Column Name | Descritpion |
| PAGE_ID | Unique identifier of page, ID is generated by ICX_PAGES_S sequence |
| PAGE_NAME | Name of a page (it's used in Old BIS style PHP only) |
| PAGE_DESCRIPTION | Description of a page (it's used in Old Style BIS PHP only) |
| RESPONSIBILITY_ID | Responsibility ID for accessing this page |
| SEQUENCE_NUMBER | Display sequence of page |
| PAGE_TYPE | Type of page, valid values are: MAIN and USER |
| MAIN_REGION_ID | First Region ID of page |
| REFRESH_RATE | Refresh rate of page |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| PAGE_CODE | Unique code of a page |
| USER_ID | ID of a PHP user |
| Oracle iProcurement - ICX_PAGE_COLORS | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| COLOR_ID | - Retrofitted |
| LAST_UPDATE_DATE | - Retrofitted |
| LAST_UPDATED_BY | - Retrofitted |
| CREATION_DATE | - Retrofitted |
| CREATED_BY | - Retrofitted |
| LAST_UPDATE_LOGIN | - Retrofitted |
| COLOR_HEX_VALUE | - Retrofitted |
| Oracle iProcurement - ICX_PAGE_COLORS_TL | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| COLOR_ID | - Retrofitted |
| LANGUAGE | - Retrofitted |
| LAST_UPDATE_DATE | - Retrofitted |
| LAST_UPDATED_BY | - Retrofitted |
| CREATION_DATE | - Retrofitted |
| CREATED_BY | - Retrofitted |
| LAST_UPDATE_LOGIN | - Retrofitted |
| NAME | - Retrofitted |
| Oracle iProcurement - ICX_PAGE_COLOR_SCHEME | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| USER_ID | - Retrofitted |
| BACKGROUND_COLOR | - Retrofitted |
| COLOR_SCHEME | - Retrofitted |
| LAST_UPDATE_DATE | - Retrofitted |
| LAST_UPDATED_BY | - Retrofitted |
| CREATION_DATE | - Retrofitted |
| CREATED_BY | - Retrofitted |
| LAST_UPDATE_LOGIN | - Retrofitted |
| BANNER_COLOR | - Retrofitted |
| HEADING_COLOR | - Retrofitted |
| TOOLBAR_COLOR | - Retrofitted |
| Oracle iProcurement - ICX_PAGE_PLUGS | Defines plugs of a page |
|---|---|
| Column Name | Descritpion |
| PLUG_ID | Unique identifier of plug, ID is generated by ICX_PAGE_PLUGS_S sequence. |
| MENU_ID | Identifier of menu |
| ENTRY_SEQUENCE | Sequence number under this menu |
| DISPLAY_NAME | Display name of plug, this is customized by user |
| REGION_ID | Identifier of region which the plug resides in. |
| LAST_UPDATE_DATE | Standard who column |
| PAGE_ID | ID of page which the plug is on |
| LAST_UPDATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| DISPLAY_SEQUENCE | Display sequence of plug within a page region |
| RESPONSIBILITY_APPLICATION_ID | Application ID of responsibility |
| RESPONSIBILITY_ID | ID of responsibility |
| SECURITY_GROUP_ID | security group identifier, in which security groups is used to partition data in a Service Bureau architecture |
| Oracle iProcurement - ICX_POR_BUGSEYE_CONFIG | Controls the look and feel of Bugseye. |
|---|---|
| Column Name | Descritpion |
| CONFIG_NAME | Configuration name |
| NAME | Name |
| VALUE | Value |
| COMMENTS | Comments |
| Oracle iProcurement - ICX_POR_CATEGORY_DATA_SOURCES | This table stores a list of external category data sources. |
|---|---|
| Column Name | Descritpion |
| CATEGORY_KEY | We load the primary key of the category in the originating system |
| EXTERNAL_SOURCE | Original system data source/publishing entity. Set to Oracle for Oracle-source data. |
| EXTERNAL_SOURCE_KEY | This is the primary key of the category in the orginating system |
| 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 |
| REQUEST_ID | Request unique identifier |
| PROGRAM_APPLICATION_ID | Program application unique identifier |
| PROGRAM_ID | Program unique identifier |
| PROGRAM_UPDATE_DATE | Program update date |
| Oracle iProcurement - ICX_POR_CATEGORY_ITEMS | Intersection table creating a relationship between categories and all the items they contain. |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | Internal item identifier within the catalog |
| RT_CATEGORY_ID | Internal category identifier within the catalog |
| Oracle iProcurement - ICX_POR_EXT_QUERY | |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | |
| QUERY | |
| TYPE | |
| LABEL | |
| PICTURE | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| REQUEST_ID | |
| PROGRAM_APPLICATION_ID | |
| PROGRAM_ID | |
| PROGRAM_UPDATE_DATE |
| Oracle iProcurement - ICX_POR_ITEMS | Stores information and root descriptors for non translatable data for each item in the catalog. Root descriptor columns are in the format Axxxx where xxxx is an integer. Some of the root descriptors are seeded by Oracle while others may b |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | Internally generated Item identifier |
| A2 | Reserved for Supplier ID |
| A3 | Reserved for Supplier Item Number |
| A4 | Reserved for Manufactuer (Not used in WR4) |
| A5 | Reserved for Manufactuer Part Number (Not used in WR4) |
| A10 | Not used |
| A11 | Not used |
| A12 | Reserved for Internal Item Number (IP only) |
| A13 | Reserved for Picture or Image file name (PICTURE) |
| A14 | Reserved for Picture or image URL (PICTURE_URL) |
| A15 | Reserved for Contract Number (IP only) |
| A16 | Reserved for Contract Line (IP only) |
| A17 | Reserved for Contract Price (IP only) |
| A18 | Reserved for Contract Currency (IP only) |
| A19 | Reserved for Contract Rate Type (IP only) |
| ORC_ITEM_ID | Item unique identifier in Oracle (IP only) |
| A20 | Reserved for Contract Rate Date (IP Only) |
| A21 | Reserved for Contract Rate (IP only) |
| A22 | Reserved for attachment URL (ATTACHMENT_URL) |
| A24 | Reserved for UNSPSC code (UNSPSC) |
| A25 | Reserved for Availability |
| A26 | Reserved for order lead time (LEAD_TIME). specified in days |
| A27 | Reserved for Functional Currency Price (IP only) |
| A28 | Reserved for Functional Currency (IP only) |
| ORC_ITEM_NUM | Item number in Oracle (IP only) |
| A29 | Reserved for item type (ITEM_TYPE) |
| TITLE | ID of the Originating system data source/publishing entity set to 'Oracle' for Oracle-sourced data |
| SUPPLIER_ID | Unique identifier for the supplier owning the item. |
| BATCH_JOB_NUM | Batch job number that created/updated the item |
| 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 |
| QUERY | Not used |
| TYPE | Not used |
| REQUEST_ID | Extended Who Column |
| PROGRAM_APPLICATION_ID | Extended Who Column |
| PROGRAM_ID | Extended Who Column |
| PROGRAM_UPDATE_DATE | Extended Who Column |
| A30 | Reserved for sellable item (SELLABLE_ITEM). Product Development specific attribute. If set to N, the item will not be visible in the standard catalog. |
| A31 | Reserved for development item (DEVELOPMENT_ITEM). Product development specific attribute. |
| A32 | Reserved for Owner Party Id. Product development specific attribute. Should be populated if A31 is Yes. |
| A33 | Reserved for Minimum Inventory Quantity |
| A34 | Reserved for Maximum Inventory Quantity |
| A35 | Reserved for pricing attributes. |
| A36 | Reserved for pricing attributes. |
| ACTION | Action last taken on the item. Possible values are ADD and UPDATE. |
| STATUS | Status of the item relative to publication. Possible values are PUBLISHED and UNPUBLISHED. |
| ITEM_SOURCE_TYPE | Item Source Type |
| SEARCH_TYPE | Search Type |
| A1 | Reserved for Supplier name |
| Oracle iProcurement - ICX_POR_ITEMS_TL | Stores information and root descriptors for translatable data for each item in the catalog. Root descriptor columns are in the format Axxxx where xxxx is an integer. Some of the root descriptors are seeded by Oracle while others may be g |
|---|---|
| Column Name | Descritpion |
| A23 | Reserved for extended item description (LONG_DESCRIPTION) |
| RT_ITEM_ID | Internally generated Item identifier |
| CTX_EG | Context related column for Egyptian |
| CTX_EL | Context related column for Greek |
| CTX_ESA | Context related column for Latin American Spanish |
| CTX_F | Context related column for French |
| CTX_FRC | Context related column for Canadian French |
| CTX_GB | Context related column for English |
| CTX_HR | Context related column for Croatian |
| CTX_HU | Context related column for Hungarian |
| CTX_I | Context related column for Italian |
| CTX_IS | Context related column for Icelandic |
| CTX_IW | Context related column for Hebrew |
| CTX_JA | Context related column for Japanese |
| A8 | Reserved for comments (COMMENTS) (IP Only) |
| CTX_KO | Context related column for Korean |
| CTX_LT | Context related column for Lithuanian |
| CTX_N | Context related column for Norwegian |
| A9 | Reserved for alias (ALIAS) |
| CTX_NL | Context related column for Dutch |
| CTX_PL | Context related column for Polish |
| CTX_PT | Context related column for Portuguese |
| LANGUAGE | Defined language for the row |
| CTX_PTB | Context related column for Brazilian Portuguese |
| CTX_RO | Context related column for Romamian |
| CTX_RU | Context related column for Russian |
| CTX_S | Context related column for Swedish |
| CTX_SF | Context related column for Finnish |
| CTX_SK | Context related column for Slovak |
| CTX_SL | Context related column for Slovenian |
| CTX_TH | Context related column for Thai |
| CTX_TR | Context related column for Turkish |
| CTX_US | Context related column for American English |
| CTX_ZHT | Context related column for Traditional Chinese |
| SOURCE_LANG | Actual language for the row |
| CTX_ZHS | Context related column for Simplified Chinese |
| REBUILD_CTX_JOBNO | Rebuild Context Job Number |
| CREATED_BY | Standard Who column |
| CTX_DESC | Text column used as the basis for the ConText query (IP Only) |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REQUEST_ID | Extended Who Column |
| PROGRAM_APPLICATION_ID | Extended Who Column |
| PROGRAM_ID | Extended Who Column |
| PROGRAM_UPDATE_DATE | Extended Who Column |
| A6 | Reserved for pricing attributes. |
| A7 | Reserved for short Item Description (DESCRIPTION) |
| CTX_AR | Context related column for Arabic |
| CTX_BG | Context related column for Bulgarian |
| CTX_CA | Context related column for Catalan |
| CTX_CS | Context related column for Czech |
| CTX_D | Context related column for German |
| CTX_DK | Context related column for Danish |
| CTX_E | Context related column for Spanish |
| Oracle iProcurement - ICX_POR_ITEM_CTX_INDEX | This table tracks which of the 2 indexes is currently available |
|---|---|
| Column Name | Descritpion |
| INDEX_NUMBER | 1 or 2 |
| USED | Y or N indicating whether the index is currency used for ConText queries |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| INDEX_NAME | Index name |
| Oracle iProcurement - ICX_POR_ITEM_SOURCES_TL | Translation table for ICX_POR_ITEM_SOURCES. |
|---|---|
| Column Name | Descritpion |
| LANGUAGE | Defined language for the row |
| SOURCE_LANG | Actual language for the row |
| ITEM_SOURCE_NAME | Name |
| DESCRIPTION | Description |
| CTX_KEYWORDS | Contains list of keywords to be used in searching for external supplier sites within an item search. |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| ITEM_SOURCE_ID | Item source unique identifier |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| Oracle iProcurement - ICX_POR_LOADER_VALUES | Stores a single record with the setup data for the Extraction process. |
|---|---|
| Column Name | Descritpion |
| LOAD_CATEGORIES | Flag indicating whether Item Categories should be extracted |
| LOAD_TEMPLATE_HEADERS | Flag indicating whether ReqExpress Template Headers should be extracted |
| LOAD_ITEM_MASTER | Flag indicating whether Item Master/ASL records should be extracted |
| LOAD_TEMPLATE_LINES | Flag indicating whether ReqExpress Template Lines should be extracted |
| LOAD_CATALOG_GROUPS | Not used in WebReqs 4 |
| CATALOG_GROUPS_LAST_RUN_DATE | Not used in WebReq 4 (future) |
| CATEGORIES_LAST_RUN_DATE | Date when extract program last extracted item Cage |
| TEMPLATE_HEADERS_LAST_RUN_DATE | Date when extract program last extracted Template Headers |
| TEMPLATE_LINES_LAST_RUN_DATE | Date when extract program last extracted Template Lines |
| ITEM_MASTER_LAST_RUN_DATE | Date when extract program last extracted Item Master/ASL data |
| CONTRACTS_LAST_RUN_DATE | Date when extract program last extracted Contract Lines |
| VENDOR_LAST_RUN_DATE | Date when extract program last extracted Vendor Name changes |
| LOAD_INTERNAL_ITEM | Flag indicating whether internal items should be extracted |
| INTERNAL_ITEM_LAST_RUN_DATE | Date when extract program last extracted internal items |
| CLEANUP_FLAG | Clean up flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REQUEST_ID | Request unique identifier |
| PROGRAM_APPLICATION_ID | Program application unique identifier |
| PROGRAM_ID | Program unique identifier |
| PROGRAM_UPDATE_DATE | Program update date |
| Oracle iProcurement - ICX_POR_LOAD_ITEM_MATCH | Table defines criteria for determining item uniqueness. |
|---|---|
| Column Name | Descritpion |
| SOURCENAME | Source Name |
| DESCRIPTOR | Descriptor |
| SEQUENCE | Sequence |
| Oracle iProcurement - ICX_POR_LOG | Internal audit table for editing tools. |
|---|---|
| Column Name | Descritpion |
| ID | Unique identifier |
| USERID | User ID |
| TYPE | Type |
| DESCRIPTION | Description |
| REFERENCE_ID | Reference ID |
| CREATE_DATE | Creation Date |
| Oracle iProcurement - ICX_POR_ORACLE_ITEM_SUBTABLE | Stores Oracle-specific reference information about a Catalog item. |
|---|---|
| Column Name | Descritpion |
| ORC_CONTRACT_ID | Contract header (Blanket Agreement or Catalog Quotation) |
| CURRENCY | Currency |
| UNIT_OF_MEASURE | Unit of measure |
| FUNCTIONAL_PRICE | Functional price |
| ORC_CONTRACT_LINE_ID | Contract line |
| ORC_CONTRACT_NUM | Contract Number |
| ORC_CONTRACT_LINE_NUM | Contract Line Number |
| ORC_TEMPLATE_ID | Template header |
| ORC_TEMPLATE_LINE_ID | Template line |
| RT_ITEM_ID | Item unique identifier within the Catalog |
| CREATED_BY | Standard Who column |
| ORC_CATEGORY_ID | Category |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REQUEST_ID | Request unique identifier |
| ORC_ASL_ID | ASL entry |
| PROGRAM_APPLICATION_ID | Program application unique identifier |
| PROGRAM_ID | Program unique identifier |
| PROGRAM_UPDATE_DATE | Program update date |
| ORC_SUPPLIER_SITE_ID | Supplier site |
| ORC_SUPPLIER_SITE_CODE | Supplier Site Code |
| ORC_OPERATING_UNIT_ID | Operating unit |
| SEARCH_TYPE | Search Type |
| ACTIVE_FLAG | Flag indicates whether this subtable row is active |
| UNIT_PRICE | Unit price |
| Oracle iProcurement - ICX_POR_TITLE_ADMIN | Stores information about the titles (supplier catalogs). |
|---|---|
| Column Name | Descritpion |
| TITLE | Title name |
| SOURCE | Document author (it could be a tool or a user, for example) |
| CREATIONDATE | Creation date |
| UPDATEDATE | Update date |
| TITLE_ID | Populate from sequence |
| CONNECTSTRING | Connect string |
| DOMAIN | Represents the type of content in the catalog |
| DESCRIPTION | Title description |
| TYPE | Type |
| PICTURE | Logo associated with the title |
| PRELOAD | Preload |
| Oracle iProcurement - ICX_POR_UNIT | This table enables you to associate units with a descriptor (like a UOM). |
|---|---|
| Column Name | Descritpion |
| UNIT_ID | Unit unique identifier |
| RT_DESCRIPTOR_ID | Descriptor |
| NAME | Name |
| MULT | Muliplier |
| ADDER | Adder |
| Oracle iProcurement - ICX_POR_VERSION_INFO | Version tracking table for internal use. |
|---|---|
| Column Name | Descritpion |
| VERSION | Version |
| LASTUPDATEBY | Last updated by |
| LASTUPDATEDATE | Last update date |
| NOTES | Notes |
| Oracle iProcurement - ICX_PROCUREMENT_SERVER_SETUP | Connection information for an external Catalog source |
|---|---|
| Column Name | Descritpion |
| AUTHENTICATION_URL | URL for the Oracle Application Server that resides outside the firewall |
| CALLBACK_URL | URL called by external catalog to reach Self-Service Purchasing |
| ITEM_SOURCE_ID | Item source unique identifier |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| COMPANY | Company name known to the buyer service |
| Oracle iProcurement - ICX_QUESTIONS | Defines question information for Asking Oracle plug |
|---|---|
| Column Name | Descritpion |
| QUESTION_CODE | Unique identifier of question |
| CREATION_DATE | Standard who column |
| APPLICATION_ID | Application ID of product team which owns this question |
| TYPE | Type of question, valid values are QUESTION and FUNCTION |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Oracle iProcurement - ICX_QUESTIONS_TL | Translation table of ICX_QUESTIONS |
|---|---|
| Column Name | Descritpion |
| QUESTION_CODE | - Retrofitted |
| SOURCE_LANG | |
| LAST_UPDATE_DATE | - Retrofitted |
| LAST_UPDATED_BY | - Retrofitted |
| CREATION_DATE | - Retrofitted |
| CREATED_BY | - Retrofitted |
| LANGUAGE | - Retrofitted |
| LAST_UPDATE_LOGIN | - Retrofitted |
| QUESTION | - Retrofitted |
| Oracle iProcurement - ICX_QUESTION_FUNCTIONS | - Retrofitted |
|---|---|
| Column Name | Descritpion |
| QUESTION_ID | |
| FUNCTION_ID | |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| QUESTION_CODE | Unique identifier of a question |
| FUNCTION_NAME | Corresponding function of question |
| Oracle iProcurement - ICX_REQUISITIONER_INFO | TPN Requisitioner Parameters Table |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_LOGIN | Standard Who column |
| ENCRYPTED_SESSION_ID | Encrypted session id |
| REQ_TOKEN | Requisition token |
| SHIP_TO | Ship to location |
| DELIVER_TO | Deliver to location |
| OPERATING_UNIT | Operating unit unique identifier |
| HTTP_HOST | Return URL from TPN |
| SESSION_ID | Session Id |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Oracle iProcurement - ICX_TEMPLATE_TAGS | Template tags table |
|---|---|
| Column Name | Descritpion |
| TAG_NAME | Name of the template tag |
| CREATED_BY | Standard Who Column |
| APPLICATION_ID | Oracle Application ID |
| TAG_DESCRIPTION | Description of the template tag |
| REPLACEMENT_TEXT | Text that replaces the tag in the html template |
| PROTECTED | Tag is protected from update if this field is Y |
| LAST_UPDATED_BY | Standand Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| Oracle iProcurement - POR_FAVORITE_LIST_HEADERS | Headers Table for implementing favorite lists |
|---|---|
| Column Name | Descritpion |
| EMPLOYEE_ID | Employee Id |
| INACTIVE_DATE | Currently not used |
| ATTRIBUTE_CATEGORY | Attribute Category |
| ATTRIBUTE1 | Descriptive Flex |
| ATTRIBUTE2 | Descriptive flex |
| ATTRIBUTE3 | Descriptive Flex |
| ATTRIBUTE4 | Descriptive Flex |
| ATTRIBUTE5 | Descriptive Flex |
| ATTRIBUTE6 | Descriptive Flex |
| ATTRIBUTE7 | Descriptive Flex |
| ATTRIBUTE8 | Descriptive Flex |
| FAVORITE_LIST_ID | Id generated from sequence which serves as primary key |
| ATTRIBUTE9 | Descriptive Flex |
| ATTRIBUTE10 | Descriptive Flex |
| ATTRIBUTE11 | Descriptive Flex |
| ATTRIBUTE12 | Descriptive Flex |
| ATTRIBUTE13 | Descriptive Flex |
| ATTRIBUTE14 | Descriptive Flex |
| ATTRIBUTE15 | Descriptive Flex |
| FAVORITE_LIST_NAME | Favorite List Name,currently not used but potentially could be used to store different lists for a single user. |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Favorite List Description |
| Oracle iProcurement - POR_FAVORITE_LIST_LINES | Table for storing items added to favorite lists. |
|---|---|
| Column Name | Descritpion |
| FAVORITE_LIST_LINE_ID | Primary Key generated from a sequence |
| ITEM_ID | The id for the item as available in the mtl_system_items_table |
| ITEM_DESCRIPTION | Description of the Item |
| LINE_TYPE_ID | Id which indicates the type (whether goods,amount or rate-based line) |
| ITEM_REVISION | Item Revision |
| CATEGORY_ID | Category Id |
| UNIT_MEAS_LOOKUP_CODE | Unit of Measure |
| UNIT_PRICE | Price per unit |
| CURRENCY | Currency |
| RATE_TYPE | Rate Type |
| SUGGESTED_VENDOR_ID | Id identifying the vendor referred to in the favorites list. Obtained from po_vendors table. |
| RATE | Rate |
| SUGGESTED_VENDOR_NAME | Name of the Supplier |
| SUGGESTED_VENDOR_SITE_ID | Supplier Site Id |
| FAVORITE_LIST_ID | Favorite List unique identifier |
| SUGGESTED_VENDOR_SITE | Supplier Site |
| SUGGESTED_VENDOR_CONTACT_ID | Supplier Contact Id |
| SUGGESTED_VENDOR_CONTACT | Supplier Contact Name |
| SUPPLIER_URL | URL giving information about supplier |
| SUGGESTED_BUYER_ID | Buyer Id |
| SUGGESTED_BUYER | Buyer Name |
| SUPPLIER_ITEM_NUM | Item Number used by the supplier. |
| MANUFACTURER_ID | Currently Not used |
| MANUFACTURER_NAME | Not begin used |
| MANUFACTURER_PART_NUMBER | Not being used |
| LAST_UPDATE_DATE | Standard Who column |
| RFQ_REQUIRED_FLAG | Not Used |
| ATTRIBUTE_CATEGORY | Attribute Category |
| ATTRIBUTE1 | Descriptive Flex |
| ATTRIBUTE2 | Descriptive Flex |
| ATTRIBUTE3 | Descriptive Flex |
| ATTRIBUTE4 | Descriptive Flex |
| ATTRIBUTE5 | Descriptive Flex |
| ATTRIBUTE6 | Descriptive Flex |
| ATTRIBUTE7 | Descriptive Flex |
| ATTRIBUTE8 | Descriptive Flex |
| LAST_UPDATED_BY | Standard Who column |
| ATTRIBUTE9 | Descriptive Flex |
| ATTRIBUTE10 | Descriptive Flex |
| ATTRIBUTE11 | Descriptive Flex |
| ATTRIBUTE12 | Descriptive Flex |
| ATTRIBUTE13 | Descriptive Flex |
| ATTRIBUTE14 | Descriptive Flex |
| ATTRIBUTE15 | Descriptive Flex |
| CATEGORY | Item Category |
| RT_ITEM_ID | Refers to the item id used in the catalog |
| RT_CATEGORY_ID | Category Id which is used in the catalog. |
| SUGGESTED_VENDOR_CONTACT_PHONE | Phone number of the Supplier Contact |
| CREATION_DATE | Standard Who column |
| NEW_SUPPLIER | Flag indicating if it is a new supplier or not. |
| ASL_ID | Id for the approved supplier lists from which this item is sourced. |
| TEMPLATE_NAME | Template name (REQ_EXPRESS_HEADERS) from which the item is sourced |
| TEMPLATE_LINE_NUM | Template Line Num as obtained from REQ_EXPRESS_LINES table. |
| PRICE_LIST_ID | Foreign key reference to PRICE_LIST_ID column in Table ICX_CAT_ITEM_PRICES |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SOURCE_DOC_HEADER_ID | The header_id for the document to which this item is referring. (documents include blankets and quotations) |
| SOURCE_DOC_LINE_ID | Line Id of the blanket or quotation to which this item refers. |
| Oracle iProcurement - POR_TEMPLATE_ASSOC | Self-Service Purchasing Information Template |
|---|---|
| Column Name | Descritpion |
| TEMPLATE_ASSOC_ID | Template association identifier |
| ATTRIBUTE1 | Descriptive Flexfield segment |
| ATTRIBUTE2 | Descriptive Flexfield segment |
| ATTRIBUTE3 | Descriptive Flexfield segment |
| ATTRIBUTE4 | Descriptive Flexfield segment |
| ATTRIBUTE5 | Descriptive Flexfield segment |
| ATTRIBUTE6 | Descriptive Flexfield segment |
| ATTRIBUTE7 | Descriptive Flexfield segment |
| ATTRIBUTE8 | Descriptive Flexfield segment |
| ATTRIBUTE9 | Descriptive Flexfield segment |
| ATTRIBUTE10 | Descriptive Flexfield segment |
| REGION_CODE | Ak region code |
| ATTRIBUTE11 | Descriptive Flexfield segment |
| ATTRIBUTE12 | Descriptive Flexfield segment |
| ATTRIBUTE13 | Descriptive Flexfield segment |
| ATTRIBUTE14 | Descriptive Flexfield segment |
| ATTRIBUTE15 | Descriptive Flexfield segment |
| ITEM_OR_CATEGORY_FLAG | Flag to determine item or category |
| ITEM_OR_CATEGORY_ID | Item/Cateogry ID |
| 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 |
| Oracle iProcurement - ICX_POR_REALMS | Stores information about realms. |
|---|---|
| Column Name | Descritpion |
| AK_ATTRIBUTE_CODE | AK attribute code |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REALM_ID | Realm unique identifier |
| Oracle iProcurement - ICX_POR_REALMS_TL | Translation table for ICX_POR_REALMS. |
|---|---|
| Column Name | Descritpion |
| REALM_DESCRIPTION | Description |
| LANGUAGE | Defined language for the row |
| SOURCE_LANG | Actual language for the row |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REALM_ID | Realm unique identifier |
| REALM_NAME | Name |
| Oracle iProcurement - ICX_POR_REALM_COMPONENTS | Stores information about realm components. |
|---|---|
| Column Name | Descritpion |
| REALM_ID | Realm unique identifier |
| REALM_COMPONENT_VALUE | The value of the item source or category to include in the realm |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REALM_COMPONENT_ID | Realm component unique identifier. Indicates whether this is an item source or category type |
| Oracle iProcurement - ICX_SESSION_ATTRIBUTES | Session context table |
|---|---|
| Column Name | Descritpion |
| SESSION_ID | Identifier for each session created by a user login |
| VALUE | Corresponding value of User defined Name column. |
| NAME | User defined descriptive name of information within a session |
| Oracle iProcurement - ICX_POR_CATEGORIES_TL | Stores information about the categories that exist within a catalog. Categories are used to classify items into groups of related items. |
|---|---|
| Column Name | Descritpion |
| RT_CATEGORY_ID | Internal identifier for a category. |
| LANGUAGE | Defined language for the row |
| SOURCE_LANG | Actual language for the row |
| CATEGORY_NAME | Category name |
| UPPER_CATEGORY_NAME | Category Name in Upper Case |
| TYPE | Indicates whether this category is 0 - Root 1 - Navigational 2 - Item/Genus Category 3 - Oracle Template. Note that type 3 is only valid in IP. |
| KEY | User-defined Key that identifies a Category. |
| UPPER_KEY | Category Key in Upper Case |
| TITLE | ID of the originating system data source |
| ITEM_COUNT | Number of items in this category. |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| DESCRIPTION | Category Description |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REQUEST_ID | Extended Who Column |
| PROGRAM_APPLICATION_ID | Extended Who Column |
| PROGRAM_ID | Extended Who Column |
| PROGRAM_UPDATE_DATE | Extended Who Column |
| BATCH_JOB_NUM | Job Number of the job that rebuilds the Intermedia Index due to changes in the Category. |
| REBUILD_FLAG | Indicates whether the Intermedia Index should be rebuilt due to changes in the Category Definition. |
| SECTION_MAP | Section Map is a bitmap (0 or 1) indicating which section a searchable descriptor belonging to the category is given while building Intermedia Sections for searching. |
| Oracle iProcurement - ICX_POR_CONFIG_PARAMETERS | Stores configuration parameters. |
|---|---|
| Column Name | Descritpion |
| CONFIGURATION_NAME | Configuration name |
| PARAMETER_NAME | Parameter name |
| GROUP_NAME | Group name |
| MESSAGE_NAME | Message name |
| PARAMETER_TYPE | Parameter type |
| LOCAL_PARAMETERS | Local parameters |
| DESCRIPTION | Description |
| Oracle iProcurement - ICX_POR_TABLE_OF_CONTENTS_TL | Stores the user-defined hierarchical relationship between navigational categories to create a more traditional hierarchical view of the catalog. |
|---|---|
| Column Name | Descritpion |
| RT_CATEGORY_ID | Parent Category ID |
| CHILD | Child Category ID |
| TYPE | Not used |
| NAME | Not used |
| QUERY | Not used |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Not used |
| LANGUAGE | Not used |
| SOURCE_LANG | Not used |
| SEQUENCE | Not used |
| CREATED_BY | Standard Who column |
| Oracle iProcurement - ICX_POR_DESCRIPTORS_TL | Stores information about descriptors associated with a given category. Root descriptors are associated with the category ID of zero. |
|---|---|
| Column Name | Descritpion |
| RT_DESCRIPTOR_ID | Internal identifier for a descriptor. |
| TITLE | ID of the Originating system data source/publishing entity set to Oracle for Oracle-sourced data |
| DEFAULTVALUE | Reserved for future use. |
| MULTI_VALUE_TYPE | Reserved for future use. |
| MULTI_VALUE_KEY | Reserved for future use. |
| 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 |
| REQUEST_ID | Extended Who Column |
| LANGUAGE | Defined language for the row |
| PROGRAM_APPLICATION_ID | Extended Who Column |
| PROGRAM_ID | Extended Who Column |
| PROGRAM_UPDATE_DATE | Extended Who Column |
| BATCH_JOB_NUM | Batch job number for the job generated to rebuild the Intermedia Index due to changes in descriptor/category definition. |
| REBUILD_FLAG | Indicates whether a change in the definition of the descriptor requires rebuilding of the Intermedia Index. |
| CLASS | Class of the descriptor. Possible values are : POM_BASE_ATTR - Base attribute, IPD_BASE_ATTR - Product Development specific base attribute, POM_CAT_ATTR - Category attribute, POM_PRICE_ATTR - Pricing attribute |
| CUSTOMIZATION_LEVEL | Bitmap indicating the level of customization allowed. By position 1-Can attribute be deleted, 2-can user modify item detail visible property, 3-can user modify search results visible property, 4-can user modify searchable property, 5-can u |
| MULTIVALUE | Reserved for future use. |
| SECTION_TAG | Indicates the section assigned to the descriptor during section building for the Intermedia Index. |
| SOURCE_LANG | Actual language for the row |
| KEY | User-defined identifer for a descriptor. |
| DESCRIPTOR_NAME | Descriptor name |
| DESCRIPTION | Description |
| RT_CATEGORY_ID | Identifier for the Category the descriptor is associated with. |
| HIDDEN | |
| TYPE | Indicates the type of data the descriptor is intended to hold. 0-Text, 1-Number, 2-Translatable Text, 3-Date, 4-URL |
| SEARCH_RESULTS_VISIBLE | Indicates whether the descriptor will be visible in search results pages. |
| ITEM_DETAIL_VISIBLE | Indicates whether the descriptor will be visible in the Item Detail, Item Compare pages. |
| REQUIRED | Indicates whether the descriptor is required during item creation/update. |
| REFINABLE | Not used. |
| SEARCHABLE | Indicates whether users can search for items based on values on this descriptor. |
| VALIDATED | Reserved for future use. |
| SEQUENCE | Indicates the sequence in which this descriptor will be displayed relative to other descriptors of the same category. |
| Oracle iProcurement - ICX_POR_TITLE_ADMIN_TL | Stores information about the titles (supplier catalogs). |
|---|---|
| Column Name | Descritpion |
| PICTURE | |
| LANGUAGE | Defined language for the row |
| SOURCE_LANG | Actual language for the row |
| TITLE | Title name |
| SOURCE | Document author (it could be a tool or a user, for example) |
| TITLE_ID | Title identifier |
| IMAGE | Image |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATIONDATE | |
| UPDATEDATE | |
| DOMAIN | Represents the type of content in the catalog |
| DESCRIPTION | Title description |
| TYPE | Type |
| Oracle iProcurement - ICX_POR_ITEM_SOURCES | Stores information about Catalog content sources. Associated with the Item Source form. |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| URL | URL for 3rd party catalog service |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| PUBLISHED_FLAG | 'Y' is published and 'N' is unpublished. |
| ICX_SESSION_SERVLET_FLAG | It is value indicates whether IP is going t o send icx session callback url to the supplier or not in punchout login request document(in ICXSessionCallbackURL element). |
| IMAGE_URL | URL for the logo |
| COMPANY_NAME | |
| COMPANY_NUMBER | |
| DISPLAY_ALWAYS | Indicates whether an external site should always be displayed in search results. |
| SUPPLIER_NAME | |
| SUPPLIER_NUMBER | |
| AUTHENTICATED_KEY | |
| USER_INFO_FLAG | |
| SUPPLIER_ID_LIST | |
| INCLUDE_INTERNAL_SOURCE_FLAG | |
| ENCODING | |
| OBJECT_VERSION_NUMBER | |
| PASSWORD | (Encrypted)Password for accessing the external source |
| PROTOCOL_SUPPORTED | Protocol Supported by the external source site. E.g. http, https |
| PARTY_SITE_ID | Not used |
| ITEM_SOURCE_ID | Item source unique identifier |
| OPERATOR_ID | Identifier for the Operator (Exchange only). |
| LOCK_ITEM_FLAG | Not used |
| TYPE | Indicates whether this is an internal or external source |
| USER_DATA_LIST_ID | Not used |
| USER_NAME | Not used |
| IS_HUB | Not used |
| SEQUENCE_NUMBER | Not used |
| CREATED_BY | Standard Who column |
| Oracle iProcurement - ICX_POR_BUGSEYE_FLAGS | Table stores flags for BugsEye system. |
|---|---|
| Column Name | Descritpion |
| VALUE | Value |
| NAME | Name |
| Oracle iProcurement - ICX_POR_CATEGORY_DEFAULTS | Stores category default values |
|---|---|
| Column Name | Descritpion |
| RT_DESCRIPTOR_ID | Unique identifier for the descriptor |
| DEFAULTVALUE | Default Value |
| RT_CATEGORY_ID | Unique identifier for the category |
| Oracle iProcurement - ICX_POR_CATEGORY_ORDER_MAP | Mapping of internal categories to external categories. |
|---|---|
| Column Name | Descritpion |
| EXTERNAL_SOURCE | //Oracle template, Oracle category or Oracle catalog group?? |
| EXTERNAL_SOURCE_KEY | //category_id, catalog_group_id, or template_name?? |
| RT_CATEGORY_ID | Category name |
| 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 |
| Oracle iProcurement - ICX_POR_CONTEXT_POLICY | Store context policies. |
|---|---|
| Column Name | Descritpion |
| TABLENAME | Table name |
| CATEGORY_TABLE | Category table |
| SQL_TEXT | SQL text |
| POLICY_ID | Policy identifier |
| NAME | Name |
| Oracle iProcurement - ICX_POR_ITEM_CONSTRAINT | Stores the information about Item Constraint. |
|---|---|
| Column Name | Descritpion |
| TYPE | Type |
| VALUE | Value |
| NAME | Name |
| Oracle iProcurement - ICX_POR_ITEM_SITE | Stores information about item Site. |
|---|---|
| Column Name | Descritpion |
| KEY | Key |
| ITEMID | Item identity |
| Oracle iProcurement - ICX_POR_SEARCH_CONFIG | Stores search configuration information. |
|---|---|
| Column Name | Descritpion |
| NAME | Name |
| DESCRIPTION | Description |
| SEARCH_CONFIG_ID | Search config identity |
| Oracle iProcurement - ICX_POR_SEARCH_CONFIG_POLICY | Stores search configuration policy information. |
|---|---|
| Column Name | Descritpion |
| POLICY_ID | Policy identity |
| SEQUENCE | Sequence |
| SEARCH_TYPE | Search type |
| SEARCH_CONFIG_ID | Search config identity |
| Oracle iProcurement - ICX_POR_SITE | Stores site information. |
|---|---|
| Column Name | Descritpion |
| NAME | Name |
| DESCRIPTION | Description |
| SITE_ID | Site identity |
| Oracle iProcurement - ICX_POR_TITLE_REGISTRY | Stores title registry information. |
|---|---|
| Column Name | Descritpion |
| DBDRIVER | DB Driver |
| DBURL | DB URL |
| DBUSER | DB User |
| DBPASSWORD | DB password |
| MINCONNS | Minimum connections |
| MAXCONNS | Maximum Connections |
| MAXCONNTIME | Maximum connection time |
| CLEANUPSEC | Cleanup seconds |
| CATALOG | Catalog |
| PRELOAD | Preload |
| LANGUAGE | Language |
| Oracle iProcurement - ICX_PROMPTS | Dummy prompt object |
|---|---|
| Column Name | Descritpion |
| PROMPT |
| Oracle iProcurement - ICX_PAGES_TL | Translation tabe of ICX_PAGES |
|---|---|
| Column Name | Descritpion |
| PAGE_ID | Unique identifier of page |
| LANGUAGE | - Retrofitted |
| SOURCE_LANG | |
| PAGE_NAME | Name of page |
| PAGE_DESCRIPTION | Description of page |
| LAST_UPDATE_DATE | - Retrofitted |
| LAST_UPDATED_BY | - Retrofitted |
| CREATION_DATE | - Retrofitted |
| CREATED_BY | - Retrofitted |
| LAST_UPDATE_LOGIN | - Retrofitted |
| Oracle iProcurement - ICX_REGIONS | Defines region information of a Self-Service Web Applications page. |
|---|---|
| Column Name | Descritpion |
| PARENT_REGION_ID | ID of this region's parent |
| SPLIT_MODE | Defines which mode this region is split to, valid values are 0 and 1. |
| PORTLET_ALIGNMENT | Alignment of portlets within the same region, valid values are 0 and 1. |
| HEIGHT | Height of region |
| WIDTH | width of region |
| WIDTH_RESTRICT | it's in ICX code, but not being used for painting plugs of PHP. |
| PORTLET_FLOW | Not being used, may use for future development |
| BORDER | border width of region |
| NAVWIDGET_ID | Not being used, may be used for future development |
| REGION_ID | Unique identifier of region, ID is generated by ICX_REGIONS_S sequence |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| Oracle iProcurement - ICX_POR_CTX_TL | ICX_POR_CTX_TL is created for Advanced Search capabilities. The table implements the 'detail-datastore' for intermedia index. This table stores the CTX_ |
|---|---|
| Column Name | Descritpion |
| CTX_BG | Bulgarian |
| CTX_KO | Korean |
| CTX_LT | Lithuanian |
| CTX_N | Norwegian |
| CTX_NL | Dutch |
| CTX_PL | Polish |
| CTX_PT | Portugese |
| CTX_PTB | Brazilian Portugese |
| CTX_RO | Romamian |
| CTX_RU | Russian |
| CTX_S | Swedish |
| CTX_CA | Catalan |
| CTX_SF | Finnish |
| CTX_SK | Slovek |
| CTX_SL | Slovenian |
| CTX_TH | Thai |
| CTX_TR | Turkish |
| CTX_ZHT | Traditional Chinese |
| CTX_ZHS | Simplified Chinese |
| RT_ITEM_ID | Item ID |
| LANGUAGE | Defined language for the row |
| CTX_US | American English |
| SEQUENCE | Sequence |
| CTX_DESC | For development use only |
| CTX_CS | Czech |
| BUYER_ID | Buyer Id |
| CTX_D | German |
| CTX_DK | Danish |
| CTX_E | Spanish |
| CTX_EG | Egyptian |
| CTX_EL | Greek |
| CTX_AR | Arabic |
| CTX_ESA | Latin American Spanish |
| CTX_F | French |
| CTX_FRC | Canadian French |
| CTX_GB | English |
| CTX_HR | Croatian |
| CTX_HU | Hungarian |
| CTX_I | Italian |
| CTX_IS | Icelandic |
| CTX_IW | Hebrew |
| CTX_JA | Japanese |
| Oracle iProcurement - ICX_POR_CATALOG_ATTACHMENTS | Table for storing Catalog Attachments |
|---|---|
| Column Name | Descritpion |
| FILE_ID | Unique Identifier for the File/Attachment |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| FILE_NAME | File Name |
| SUPPLIER_ID | Supplier ID owning the file/attachment |
| CONTENT | Content of the attachment |
| MIME_TYPE | Mime Type |
| FILE_SIZE | File size |
| CREATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| Oracle iProcurement - ICX_POR_FAILED_ATTACHMENTS | Stores information relative to rejections that may occur during loading of attachments. |
|---|---|
| Column Name | Descritpion |
| JOB_NUMBER | Internally generated job identifier for the batch process. |
| SUPPLIER_ID | Supplier ID for the supplier requesting loading of the attachment(s). |
| FILE_NAME | File Name given by the user for the attachment. |
| ACTION | Indicates the action to perform on the attachment. |
| MESSAGE_NAME | Stores the message name indicating the reason for the rejection. |
| Oracle iProcurement - ICX_POR_DOWNLOAD_JOB_DETAILS | Holds detail information related to an export of content or catalog structure job. |
|---|---|
| Column Name | Descritpion |
| USER_ID | User ID submitting export job. |
| OPTION_CODE | Parameter to the export job indicating the type of content to download. |
| LANGUAGE | Language to be used in the generated content export file. |
| FILE_NAME | Name of the xml file generated. |
| JOB_FILE | File storing the exported content. |
| FILE_SIZE | File size of the file generated by the job. |
| SUPPLIER_ID | Supplier ID of the owner of the content being exported. Applicable to jobs exporting items. |
| BUYER_ID | Buyer related to the export operation if any. Applicable to export of items. |
| JOB_NUMBER | Internally generated unique identifier assigned to the batch process. |
| TBD | TBD price codes to be included in the Price? (Y/N) |
| HEADER_ID | Header identifier |
| MODIFY_BEGIN_DATE | Begin date of the period items to be downloaded are modified in. |
| MODIFY_END_DATE | End date of the period items to be downloaded are modified in. |
| ENCODING | Encoding of the spreadsheet. |
| Oracle iProcurement - ICX_POR_UPLOAD_ITEMS_IT | Temporary table that holds transient data during an item bulk load process. This table will be truncated after each bulk load job. |
|---|---|
| Column Name | Descritpion |
| JOB_NUMBER | Unique identifier for the bulk load job |
| CATEGORY_KEY | Key of category that contains this item |
| ROOT63 | Stores base/root attribute value |
| ROOT64 | Stores base/root attribute value |
| ROOT65 | Stores base/root attribute value |
| ROOT66 | Stores base/root attribute value |
| ROOT67 | Stores base/root attribute value |
| ROOT68 | Stores base/root attribute value |
| ROOT69 | Stores base/root attribute value |
| ROOT70 | Stores base/root attribute value |
| ROOT71 | Stores base/root attribute value |
| ROOT72 | Stores base/root attribute value |
| SUPPLIER_NAME | Name of supplier |
| ROOT73 | Stores base/root attribute value |
| ROOT74 | Stores base/root attribute value |
| ROOT75 | Stores base/root attribute value |
| ROOT76 | Stores base/root attribute value |
| ROOT77 | Stores base/root attribute value |
| ROOT78 | Stores base/root attribute value |
| ROOT79 | Stores base/root attribute value |
| ROOT80 | Stores base/root attribute value |
| ROOT81 | Stores base/root attribute value |
| ROOT82 | Stores base/root attribute value |
| PRICE_BREAK_ID | Price break identifier |
| SUPPLIER_PART_NUM | Supplier Item Number |
| ROOT83 | Stores base/root attribute value |
| ROOT84 | Stores base/root attribute value |
| ROOT85 | Stores base/root attribute value |
| ROOT86 | Stores base/root attribute value |
| ROOT87 | Stores base/root attribute value |
| ROOT88 | Stores base/root attribute value |
| ROOT89 | Stores base/root attribute value |
| ROOT90 | Stores base/root attribute value |
| ROOT91 | Stores base/root attribute value |
| ROOT92 | Stores base/root attribute value |
| DESCRIPTION | Item Description |
| ROOT93 | Stores base/root attribute value |
| ROOT94 | Stores base/root attribute value |
| ROOT95 | Stores base/root attribute value |
| ROOT96 | Stores base/root attribute value |
| ROOT97 | Stores base/root attribute value |
| ROOT98 | Stores base/root attribute value |
| ROOT99 | Stores base/root attribute value |
| ROOT100 | Stores base/root attribute value |
| ROOT101 | Stores base/root attribute value |
| ROOT102 | Stores base/root attribute value |
| UNSPSC_CODE | UNSPSC Code |
| ROOT103 | Stores base/root attribute value |
| ROOT104 | Stores base/root attribute value |
| ROOT105 | Stores base/root attribute value |
| ROOT106 | Stores base/root attribute value |
| ROOT107 | Stores base/root attribute value |
| ROOT108 | Stores base/root attribute value |
| ROOT109 | Stores base/root attribute value |
| ROOT110 | Stores base/root attribute value |
| ROOT111 | Stores base/root attribute value |
| ROOT112 | Stores base/root attribute value |
| BEGINDATE | Begin date |
| ITEM_TYPE | Item Type |
| ROOT113 | Stores base/root attribute value |
| ROOT114 | Stores base/root attribute value |
| ROOT115 | Stores base/root attribute value |
| ROOT116 | Stores base/root attribute value |
| ROOT117 | Stores base/root attribute value |
| ROOT118 | Stores base/root attribute value |
| ROOT119 | Stores base/root attribute value |
| ROOT120 | Stores base/root attribute value |
| ROOT121 | Stores base/root attribute value |
| ROOT122 | Stores base/root attribute value |
| OWNER_NAME | Item owner name |
| ROOT123 | Stores base/root attribute value |
| ROOT124 | Stores base/root attribute value |
| ROOT125 | Stores base/root attribute value |
| ROOT126 | Stores base/root attribute value |
| ROOT127 | Stores base/root attribute value |
| ROOT128 | Stores base/root attribute value |
| ROOT129 | Stores base/root attribute value |
| ROOT130 | Stores base/root attribute value |
| ROOT131 | Stores base/root attribute value |
| ROOT132 | Stores base/root attribute value |
| ENDDATE | End date |
| RT_CATEGORY_ID | Internal ID of the category that contains this item |
| ROOT133 | Stores base/root attribute value |
| ROOT134 | Stores base/root attribute value |
| ROOT135 | Stores base/root attribute value |
| ROOT136 | Stores base/root attribute value |
| ROOT137 | Stores base/root attribute value |
| ROOT138 | Stores base/root attribute value |
| ROOT139 | Stores base/root attribute value |
| ROOT140 | Stores base/root attribute value |
| ROOT141 | Stores base/root attribute value |
| ROOT142 | Stores base/root attribute value |
| PRICE_BREAK_COUNT | Price break count |
| OLD_CATEGORY_ID | Internal ID of the original category that contained this item |
| ROOT143 | Stores base/root attribute value |
| ROOT144 | Stores base/root attribute value |
| ROOT145 | Stores base/root attribute value |
| ROOT146 | Stores base/root attribute value |
| ROOT147 | Stores base/root attribute value |
| ROOT148 | Stores base/root attribute value |
| ROOT149 | Stores base/root attribute value |
| ROOT150 | Stores base/root attribute value |
| ROOT151 | Stores base/root attribute value |
| ROOT152 | Stores base/root attribute value |
| RT_ITEM_ID | Internal item ID |
| ROOT153 | Stores base/root attribute value |
| ROOT154 | Stores base/root attribute value |
| ROOT155 | Stores base/root attribute value |
| ROOT156 | Stores base/root attribute value |
| ROOT157 | Stores base/root attribute value |
| ROOT158 | Stores base/root attribute value |
| ROOT159 | Stores base/root attribute value |
| ROOT160 | Stores base/root attribute value |
| ROOT161 | Stores base/root attribute value |
| ROOT162 | Stores base/root attribute value |
| LINE_NUMBER | Line number |
| UNPUBLISHED_ITEM_ID | Internal item ID for corresponding unpublished item |
| ROOT163 | Stores base/root attribute value |
| ROOT164 | Stores base/root attribute value |
| ROOT165 | Stores base/root attribute value |
| ROOT166 | Stores base/root attribute value |
| ROOT167 | Stores base/root attribute value |
| ROOT168 | Stores base/root attribute value |
| ROOT169 | Stores base/root attribute value |
| ROOT170 | Stores base/root attribute value |
| ROOT171 | Stores base/root attribute value |
| ROOT172 | Stores base/root attribute value |
| UNPUBLISHED_CATEGORY_ID | Internal Category ID for corresponding unpublished item |
| ROOT173 | Stores base/root attribute value |
| ROOT174 | Stores base/root attribute value |
| ROOT175 | Stores base/root attribute value |
| ROOT176 | Stores base/root attribute value |
| ROOT177 | Stores base/root attribute value |
| ROOT178 | Stores base/root attribute value |
| ROOT179 | Stores base/root attribute value |
| ROOT180 | Stores base/root attribute value |
| ROOT181 | Stores base/root attribute value |
| ROOT182 | Stores base/root attribute value |
| SUPPLIER_ID | Supplier internal ID |
| ROOT183 | Stores base/root attribute value |
| ROOT184 | Stores base/root attribute value |
| ROOT185 | Stores base/root attribute value |
| ROOT186 | Stores base/root attribute value |
| ROOT187 | Stores base/root attribute value |
| ROOT188 | Stores base/root attribute value |
| ROOT189 | Stores base/root attribute value |
| ROOT190 | Stores base/root attribute value |
| ROOT191 | Stores base/root attribute value |
| ROOT192 | Stores base/root attribute value |
| OWNER_ID | Owner internal ID |
| ROOT193 | Stores base/root attribute value |
| ROOT194 | Stores base/root attribute value |
| ROOT195 | Stores base/root attribute value |
| ROOT196 | Stores base/root attribute value |
| ROOT197 | Stores base/root attribute value |
| ROOT198 | Stores base/root attribute value |
| ROOT199 | Stores base/root attribute value |
| ROOT200 | Stores base/root attribute value |
| ROOT201 | Stores base/root attribute value |
| ROOT202 | Stores base/root attribute value |
| BUYER_ID | Buyer internal ID |
| ROOT203 | Stores base/root attribute value |
| ROOT204 | Stores base/root attribute value |
| ROOT205 | Stores base/root attribute value |
| ROOT206 | Stores base/root attribute value |
| ROOT207 | Stores base/root attribute value |
| ROOT208 | Stores base/root attribute value |
| ROOT209 | Stores base/root attribute value |
| ROOT210 | Stores base/root attribute value |
| ROOT211 | Stores base/root attribute value |
| ROOT212 | Stores base/root attribute value |
| PRICELIST_ID | Price List internal ID |
| ROOT213 | Stores base/root attribute value |
| ROOT214 | Stores base/root attribute value |
| ROOT215 | Stores base/root attribute value |
| ROOT216 | Stores base/root attribute value |
| ROOT217 | Stores base/root attribute value |
| ROOT218 | Stores base/root attribute value |
| ROOT219 | Stores base/root attribute value |
| ROOT220 | Stores base/root attribute value |
| ROOT221 | Stores base/root attribute value |
| ROOT222 | Stores base/root attribute value |
| PRICELINE_ROWID | ROWID in ICX_POR_PRICE_LIST_LINES for corresponding price |
| ROOT223 | Stores base/root attribute value |
| ROOT224 | Stores base/root attribute value |
| ROOT225 | Stores base/root attribute value |
| ROOT226 | Stores base/root attribute value |
| ROOT227 | Stores base/root attribute value |
| ROOT228 | Stores base/root attribute value |
| ROOT229 | Stores base/root attribute value |
| ROOT230 | Stores base/root attribute value |
| ROOT231 | Stores base/root attribute value |
| ROOT232 | Stores base/root attribute value |
| UNAPPROVED_PRICELINE_ROWID | ROWID in ICX_POR_PRICE_LIST_LINES for corresponding unpublished price |
| ROOT233 | Stores base/root attribute value |
| ROOT234 | Stores base/root attribute value |
| ROOT235 | Stores base/root attribute value |
| ROOT236 | Stores base/root attribute value |
| ROOT237 | Stores base/root attribute value |
| ROOT238 | Stores base/root attribute value |
| ROOT239 | Stores base/root attribute value |
| ROOT240 | Stores base/root attribute value |
| ROOT241 | Stores base/root attribute value |
| ROOT242 | Stores base/root attribute value |
| UOM_NAME | Unit of measure name |
| ROOT243 | Stores base/root attribute value |
| ROOT244 | Stores base/root attribute value |
| ROOT245 | Stores base/root attribute value |
| ROOT246 | Stores base/root attribute value |
| ROOT247 | Stores base/root attribute value |
| ROOT248 | Stores base/root attribute value |
| ROOT249 | Stores base/root attribute value |
| ROOT250 | Stores base/root attribute value |
| LOCAL1 | Stores category attribute value |
| LOCAL2 | Stores category attribute value |
| BUYER_NAME | Buyer name |
| LOCAL3 | Stores category attribute value |
| LOCAL4 | Stores category attribute value |
| LOCAL5 | Stores category attribute value |
| LOCAL6 | Stores category attribute value |
| LOCAL7 | Stores category attribute value |
| LOCAL8 | Stores category attribute value |
| LOCAL9 | Stores category attribute value |
| LOCAL10 | Stores category attribute value |
| LOCAL11 | Stores category attribute value |
| LOCAL12 | Stores category attribute value |
| ROW_TYPE | Type of the line |
| PRICE_STRING | Unit price |
| LOCAL13 | Stores category attribute value |
| LOCAL14 | Stores category attribute value |
| LOCAL15 | Stores category attribute value |
| LOCAL16 | Stores category attribute value |
| LOCAL17 | Stores category attribute value |
| LOCAL18 | Stores category attribute value |
| LOCAL19 | Stores category attribute value |
| LOCAL20 | Stores category attribute value |
| LOCAL21 | Stores category attribute value |
| LOCAL22 | Stores category attribute value |
| PRICELIST_NAME | Price List name |
| LOCAL23 | Stores category attribute value |
| LOCAL24 | Stores category attribute value |
| LOCAL25 | Stores category attribute value |
| LOCAL26 | Stores category attribute value |
| LOCAL27 | Stores category attribute value |
| LOCAL28 | Stores category attribute value |
| LOCAL29 | Stores category attribute value |
| LOCAL30 | Stores category attribute value |
| LOCAL31 | Stores category attribute value |
| LOCAL32 | Stores category attribute value |
| CURRENCY_CODE | Currency code |
| LOCAL33 | Stores category attribute value |
| LOCAL34 | Stores category attribute value |
| LOCAL35 | Stores category attribute value |
| LOCAL36 | Stores category attribute value |
| LOCAL37 | Stores category attribute value |
| LOCAL38 | Stores category attribute value |
| LOCAL39 | Stores category attribute value |
| LOCAL40 | Stores category attribute value |
| LOCAL41 | Stores category attribute value |
| LOCAL42 | Stores category attribute value |
| UOM_CODE | Unit of measure code |
| LOCAL43 | Stores category attribute value |
| LOCAL44 | Stores category attribute value |
| LOCAL45 | Stores category attribute value |
| LOCAL46 | Stores category attribute value |
| LOCAL47 | Stores category attribute value |
| LOCAL48 | Stores category attribute value |
| LOCAL49 | Stores category attribute value |
| LOCAL50 | Stores category attribute value |
| PRICE_CODE | Price code |
| SUPPLIER_COMMENTS | Supplier comments |
| REQUIRED_DESCRIPTORS | Key of required attributes that have no values |
| REQUIRED_TL_DESCRIPTORS | Key of required translatable attributes that have no values |
| OLD_PRICE_BREAK_ID | The price break id of the line from which this line is copied. |
| PROCESSED_FLAG | Processed Flag which indicates whether the row is processed. |
| ROOT1 | Stores base/root attribute value |
| ROOT2 | Stores base/root attribute value |
| LANGUAGE | Language of the line |
| ROOT3 | Stores base/root attribute value |
| ROOT4 | Stores base/root attribute value |
| ROOT5 | Stores base/root attribute value |
| ROOT6 | Stores base/root attribute value |
| ROOT7 | Stores base/root attribute value |
| ROOT8 | Stores base/root attribute value |
| ROOT9 | Stores base/root attribute value |
| ROOT10 | Stores base/root attribute value |
| ROOT11 | Stores base/root attribute value |
| ROOT12 | Stores base/root attribute value |
| ACTION | Action specified by user |
| ROOT13 | Stores base/root attribute value |
| ROOT14 | Stores base/root attribute value |
| ROOT15 | Stores base/root attribute value |
| ROOT16 | Stores base/root attribute value |
| ROOT17 | Stores base/root attribute value |
| ROOT18 | Stores base/root attribute value |
| ROOT19 | Stores base/root attribute value |
| ROOT20 | Stores base/root attribute value |
| ROOT21 | Stores base/root attribute value |
| ROOT22 | Stores base/root attribute value |
| SYSTEM_ACTION | System defined action |
| ROOT23 | Stores base/root attribute value |
| ROOT24 | Stores base/root attribute value |
| ROOT25 | Stores base/root attribute value |
| ROOT26 | Stores base/root attribute value |
| ROOT27 | Stores base/root attribute value |
| ROOT28 | Stores base/root attribute value |
| ROOT29 | Stores base/root attribute value |
| ROOT30 | Stores base/root attribute value |
| ROOT31 | Stores base/root attribute value |
| ROOT32 | Stores base/root attribute value |
| ERROR_FLAG | Indicates whether this item has errors |
| ROOT33 | Stores base/root attribute value |
| ROOT34 | Stores base/root attribute value |
| ROOT35 | Stores base/root attribute value |
| ROOT36 | Stores base/root attribute value |
| ROOT37 | Stores base/root attribute value |
| ROOT38 | Stores base/root attribute value |
| ROOT39 | Stores base/root attribute value |
| ROOT40 | Stores base/root attribute value |
| ROOT41 | Stores base/root attribute value |
| ROOT42 | Stores base/root attribute value |
| ERROR_MESSAGE | Errors associated with this item |
| ROOT43 | Stores base/root attribute value |
| ROOT44 | Stores base/root attribute value |
| ROOT45 | Stores base/root attribute value |
| ROOT46 | Stores base/root attribute value |
| ROOT47 | Stores base/root attribute value |
| ROOT48 | Stores base/root attribute value |
| ROOT49 | Stores base/root attribute value |
| ROOT50 | Stores base/root attribute value |
| ROOT51 | Stores base/root attribute value |
| ROOT52 | Stores base/root attribute value |
| CATEGORY_NAME | Name of category that contains this item |
| ROOT53 | Stores base/root attribute value |
| ROOT54 | Stores base/root attribute value |
| ROOT55 | Stores base/root attribute value |
| ROOT56 | Stores base/root attribute value |
| ROOT57 | Stores base/root attribute value |
| ROOT58 | Stores base/root attribute value |
| ROOT59 | Stores base/root attribute value |
| ROOT60 | Stores base/root attribute value |
| ROOT61 | Stores base/root attribute value |
| ROOT62 | Stores base/root attribute value |
| Oracle iProcurement - ICX_POR_UPLOAD_PRICES_IT | Temporary table that holds transient data during a price bulk load process. This table will be truncated after each bulk load job. |
|---|---|
| Column Name | Descritpion |
| JOB_NUMBER | Unique identifier for the bulk load job |
| CATEGORY_KEY | Not used |
| ROOT63 | Not used |
| ROOT64 | Not used |
| ROOT65 | Not used |
| ROOT66 | Not used |
| ROOT67 | Not used |
| ROOT68 | Not used |
| ROOT69 | Not used |
| ROOT70 | Not used |
| ROOT71 | Not used |
| ROOT72 | Not used |
| SUPPLIER_NAME | Name of supplier |
| ROOT73 | Not used |
| ROOT74 | Not used |
| ROOT75 | Not used |
| ROOT76 | Not used |
| ROOT77 | Not used |
| ROOT78 | Not used |
| ROOT79 | Not used |
| ROOT80 | Not used |
| ROOT81 | Not used |
| ROOT82 | Not used |
| SUPPLIER_PART_NUM | Supplier Item Number |
| ROOT83 | Not used |
| ROOT84 | Not used |
| ROOT85 | Not used |
| ROOT86 | Not used |
| ROOT87 | Not used |
| ROOT88 | Not used |
| ROOT89 | Not used |
| ROOT90 | Not used |
| ROOT91 | Not used |
| ROOT92 | Not used |
| DESCRIPTION | Not used |
| ROOT93 | Not used |
| ROOT94 | Not used |
| ROOT95 | Not used |
| ROOT96 | Not used |
| ROOT97 | Not used |
| ROOT98 | Not used |
| ROOT99 | Not used |
| ROOT100 | Not used |
| ROOT101 | Not used |
| ROOT102 | Not used |
| UNSPSC_CODE | Not used |
| ROOT103 | Not used |
| ROOT104 | Not used |
| ROOT105 | Not used |
| ROOT106 | Not used |
| ROOT107 | Not used |
| ROOT108 | Not used |
| ROOT109 | Not used |
| ROOT110 | Not used |
| ROOT111 | Not used |
| ROOT112 | Not used |
| PRICE_BREAK_ID | Price break id |
| ITEM_TYPE | Not used |
| ROOT113 | Not used |
| ROOT114 | Not used |
| ROOT115 | Not used |
| ROOT116 | Not used |
| ROOT117 | Not used |
| ROOT118 | Not used |
| ROOT119 | Not used |
| ROOT120 | Not used |
| ROOT121 | Not used |
| ROOT122 | Not used |
| OWNER_NAME | Not used |
| ROOT123 | Not used |
| ROOT124 | Not used |
| ROOT125 | Not used |
| ROOT126 | Not used |
| ROOT127 | Not used |
| ROOT128 | Not used |
| ROOT129 | Not used |
| ROOT130 | Not used |
| ROOT131 | Not used |
| ROOT132 | Not used |
| PRICE_BREAK_COUNT | Price break count |
| RT_CATEGORY_ID | Not used |
| ROOT133 | Not used |
| ROOT134 | Not used |
| ROOT135 | Not used |
| ROOT136 | Not used |
| ROOT137 | Not used |
| ROOT138 | Not used |
| ROOT139 | Not used |
| ROOT140 | Not used |
| ROOT141 | Not used |
| ROOT142 | Not used |
| BEGINDATE | Begin date |
| OLD_CATEGORY_ID | Not used |
| ROOT143 | Not used |
| ROOT144 | Not used |
| ROOT145 | Not used |
| ROOT146 | Not used |
| ROOT147 | Not used |
| ROOT148 | Not used |
| ROOT149 | Not used |
| ROOT150 | Not used |
| ROOT151 | Not used |
| ROOT152 | Not used |
| ENDDATE | End date |
| RT_ITEM_ID | Internal item ID |
| ROOT153 | Not used |
| ROOT154 | Not used |
| ROOT155 | Not used |
| ROOT156 | Not used |
| ROOT157 | Not used |
| ROOT158 | Not used |
| ROOT159 | Not used |
| ROOT160 | Not used |
| ROOT161 | Not used |
| ROOT162 | Not used |
| LINE_NUMBER | Line number |
| UNPUBLISHED_ITEM_ID | Internal item ID for corresponding unpublished item |
| ROOT163 | Not used |
| ROOT164 | Not used |
| ROOT165 | Not used |
| ROOT166 | Not used |
| ROOT167 | Not used |
| ROOT168 | Not used |
| ROOT169 | Not used |
| ROOT170 | Not used |
| ROOT171 | Not used |
| ROOT172 | Not used |
| UNPUBLISHED_CATEGORY_ID | Not used |
| ROOT173 | Not used |
| ROOT174 | Not used |
| ROOT175 | Not used |
| ROOT176 | Not used |
| ROOT177 | Not used |
| ROOT178 | Not used |
| ROOT179 | Not used |
| ROOT180 | Not used |
| ROOT181 | Not used |
| ROOT182 | Not used |
| SUPPLIER_ID | Supplier internal ID |
| ROOT183 | Not used |
| ROOT184 | Not used |
| ROOT185 | Not used |
| ROOT186 | Not used |
| ROOT187 | Not used |
| ROOT188 | Not used |
| ROOT189 | Not used |
| ROOT190 | Not used |
| ROOT191 | Not used |
| ROOT192 | Not used |
| OWNER_ID | Not used |
| ROOT193 | Not used |
| ROOT194 | Not used |
| ROOT195 | Not used |
| ROOT196 | Not used |
| ROOT197 | Not used |
| ROOT198 | Not used |
| ROOT199 | Not used |
| ROOT200 | Not used |
| ROOT201 | Not used |
| ROOT202 | Not used |
| BUYER_ID | Buyer internal ID |
| ROOT203 | Not used |
| ROOT204 | Not used |
| ROOT205 | Not used |
| ROOT206 | Not used |
| ROOT207 | Not used |
| ROOT208 | Not used |
| ROOT209 | Not used |
| ROOT210 | Not used |
| ROOT211 | Not used |
| ROOT212 | Not used |
| PRICELIST_ID | Price List internal ID |
| ROOT213 | Not used |
| ROOT214 | Not used |
| ROOT215 | Not used |
| ROOT216 | Not used |
| ROOT217 | Not used |
| ROOT218 | Not used |
| ROOT219 | Not used |
| ROOT220 | Not used |
| ROOT221 | Not used |
| ROOT222 | Not used |
| PRICELINE_ROWID | ROWID in ICX_POR_PRICE_LIST_LINES for corresponding price |
| ROOT223 | Not used |
| ROOT224 | Not used |
| ROOT225 | Not used |
| ROOT226 | Not used |
| ROOT227 | Not used |
| ROOT228 | Not used |
| ROOT229 | Not used |
| ROOT230 | Not used |
| ROOT231 | Not used |
| ROOT232 | Not used |
| UNAPPROVED_PRICELINE_ROWID | ROWID in ICX_POR_PRICE_LIST_LINES for corresponding unpublished price |
| ROOT233 | Not used |
| ROOT234 | Not used |
| ROOT235 | Not used |
| ROOT236 | Not used |
| ROOT237 | Not used |
| ROOT238 | Not used |
| ROOT239 | Not used |
| ROOT240 | Not used |
| ROOT241 | Not used |
| ROOT242 | Not used |
| UOM_NAME | Unit of measure name |
| ROOT243 | Not used |
| ROOT244 | Not used |
| ROOT245 | Not used |
| ROOT246 | Not used |
| ROOT247 | Not used |
| ROOT248 | Not used |
| ROOT249 | Not used |
| ROOT250 | Not used |
| LOCAL1 | Not used |
| LOCAL2 | Not used |
| BUYER_NAME | Buyer name |
| LOCAL3 | Not used |
| LOCAL4 | Not used |
| LOCAL5 | Not used |
| LOCAL6 | Not used |
| LOCAL7 | Not used |
| LOCAL8 | Not used |
| LOCAL9 | Not used |
| LOCAL10 | Not used |
| LOCAL11 | Not used |
| LOCAL12 | Not used |
| ROW_TYPE | Type of the line |
| PRICE_STRING | Unit price |
| LOCAL13 | Not used |
| LOCAL14 | Not used |
| LOCAL15 | Not used |
| LOCAL16 | Not used |
| LOCAL17 | Not used |
| LOCAL18 | Not used |
| LOCAL19 | Not used |
| LOCAL20 | Not used |
| LOCAL21 | Not used |
| LOCAL22 | Not used |
| PRICELIST_NAME | Price List name |
| LOCAL23 | Not used |
| LOCAL24 | Not used |
| LOCAL25 | Not used |
| LOCAL26 | Not used |
| LOCAL27 | Not used |
| LOCAL28 | Not used |
| LOCAL29 | Not used |
| LOCAL30 | Not used |
| LOCAL31 | Not used |
| LOCAL32 | Not used |
| CURRENCY_CODE | Currency code |
| LOCAL33 | Not used |
| LOCAL34 | Not used |
| LOCAL35 | Not used |
| LOCAL36 | Not used |
| LOCAL37 | Not used |
| LOCAL38 | Not used |
| LOCAL39 | Not used |
| LOCAL40 | Not used |
| LOCAL41 | Not used |
| LOCAL42 | Not used |
| UOM_CODE | Unit of measure code |
| LOCAL43 | Not used |
| LOCAL44 | Not used |
| LOCAL45 | Not used |
| LOCAL46 | Not used |
| LOCAL47 | Not used |
| LOCAL48 | Not used |
| LOCAL49 | Not used |
| LOCAL50 | Not used |
| PRICE_CODE | Price code |
| SUPPLIER_COMMENTS | Supplier comments |
| REQUIRED_DESCRIPTORS | Not used |
| REQUIRED_TL_DESCRIPTORS | Not used |
| OLD_PRICE_BREAK_ID | The price break id of the line from which this line is copied. |
| PROCESSED_FLAG | Processed Flag which indicates whether the row is processed. |
| ROOT1 | Not used |
| ROOT2 | Not used |
| LANGUAGE | Language of the line |
| ROOT3 | Not used |
| ROOT4 | Not used |
| ROOT5 | Not used |
| ROOT6 | Not used |
| ROOT7 | Not used |
| ROOT8 | Not used |
| ROOT9 | Not used |
| ROOT10 | Not used |
| ROOT11 | Not used |
| ROOT12 | Not used |
| ACTION | Action specified by user |
| ROOT13 | Not used |
| ROOT14 | Not used |
| ROOT15 | Not used |
| ROOT16 | Not used |
| ROOT17 | Not used |
| ROOT18 | Not used |
| ROOT19 | Not used |
| ROOT20 | Not used |
| ROOT21 | Not used |
| ROOT22 | Not used |
| SYSTEM_ACTION | System defined action |
| ROOT23 | Not used |
| ROOT24 | Not used |
| ROOT25 | Not used |
| ROOT26 | Not used |
| ROOT27 | Not used |
| ROOT28 | Not used |
| ROOT29 | Not used |
| ROOT30 | Not used |
| ROOT31 | Not used |
| ROOT32 | Not used |
| ERROR_FLAG | Indicates whether this price has errors |
| ROOT33 | Not used |
| ROOT34 | Not used |
| ROOT35 | Not used |
| ROOT36 | Not used |
| ROOT37 | Not used |
| ROOT38 | Not used |
| ROOT39 | Not used |
| ROOT40 | Not used |
| ROOT41 | Not used |
| ROOT42 | Not used |
| ERROR_MESSAGE | Errors associated with this price |
| ROOT43 | Not used |
| ROOT44 | Not used |
| ROOT45 | Not used |
| ROOT46 | Not used |
| ROOT47 | Not used |
| ROOT48 | Not used |
| ROOT49 | Not used |
| ROOT50 | Not used |
| ROOT51 | Not used |
| ROOT52 | Not used |
| CATEGORY_NAME | Not used |
| ROOT53 | Not used |
| ROOT54 | Not used |
| ROOT55 | Not used |
| ROOT56 | Not used |
| ROOT57 | Not used |
| ROOT58 | Not used |
| ROOT59 | Not used |
| ROOT60 | Not used |
| ROOT61 | Not used |
| ROOT62 | Not used |
| Oracle iProcurement - ICX_POR_PRICE_HISTORY | Stores price list lines information. |
|---|---|
| Column Name | Descritpion |
| SUPPLIER_ID | Supplier ID |
| RATE | Not used |
| RATE_TYPE | Not used |
| RATE_DATE | Not used |
| BUYER_FUNCTIONAL_CURRENCY | Not used |
| SUPPLIER_SITE | Supplier site (IP only) |
| BUYER_ID | Buyer ID |
| JOB_NUMBER | Job Number for batch job that generated the price line. |
| ACTION | Action on price such as ADD, UPDATE |
| PUBLISHED_DATE | Date price line was published |
| OUTDATED_DATE | Date price line was outdated |
| DELETED_DATE | Date price line was deleted |
| ITEM_ID | Item ID |
| REJECTED_DATE | Date price line was rejected |
| COMMENTS | Comments given by a buyer while rejecting a price line. |
| SUPPLIERCOMMENTS | Comments provided by the supplier on pricing |
| PRICE_BREAK_ID | Price break id |
| PRICE_BREAK_COUNT | Price break count |
| EFFECTIVE_BEGINDATE | Effective begin date |
| EFFECTIVE_ENDDATE | Effective end date |
| BEGINDATE | Start date |
| ENDDATE | End date |
| CONTRACT_REFERENCE_NUM | Contract regference number |
| CONTRACT_REFERENCE_ID | Contract reference id |
| UNIT_PRICE | Price |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| UOM | Unit of Measure |
| HEADER_ID | Price List ID |
| CURRENCY_CODE | Currency Code |
| PRICE_CODE | price code used when no price available |
| BUYER_APPROVAL_STATUS | Buyer Approval Status. Possible values are: APPROVED, DELETED, OUTDATED, PUBLISHED, UNPUBLISHED |
| BUYER_APPROVAL_DATE | Buyer Approval Date |
| INACTIVE_DATE | Inactive Date |
| DESCRIPTION | Price Line Description |
| Oracle iProcurement - ICX_POR_PRICE_LIST_LINES | Stores price list lines information. |
|---|---|
| Column Name | Descritpion |
| HEADER_ID | Price List ID |
| INACTIVE_DATE | Inactive Date |
| DESCRIPTION | Price Line Description |
| RATE | Not used |
| RATE_TYPE | Not used |
| RATE_DATE | Not used |
| BUYER_FUNCTIONAL_CURRENCY | Not used |
| SUPPLIER_SITE | Supplier site (IP only) |
| JOB_NUMBER | Job Number for batch job that generated the price line. |
| ACTION | Action on price such as ADD, UPDATE |
| PUBLISHED_DATE | Date price line was published |
| SUPPLIER_ID | Supplier ID |
| OUTDATED_DATE | Date price line was outdated |
| DELETED_DATE | Date price line was deleted |
| REJECTED_DATE | Date price line was rejected |
| COMMENTS | Comments given by a buyer while rejecting a price line. |
| SUPPLIERCOMMENTS | Comments provided by the supplier on pricing |
| PRICE_BREAK_ID | Price Break identifier |
| PRICE_BREAK_COUNT | Number of Price Breaks associated with this line. |
| EFFECTIVE_BEGINDATE | Effective begin date of the price line. This depends on the begin date of the price list if begin date is inherited. |
| EFFECTIVE_ENDDATE | Effective end date of the price line. This depends on the end date of the price list if the end date of the price line is inherited. |
| BEGINDATE | Begin date of the price line. |
| ENDDATE | End date of the price line. |
| BUYER_ID | Buyer ID |
| CONTRACT_REFERENCE_NUM | Contract Reference Number |
| CONTRACT_REFERENCE_ID | Contract Reference ID |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ITEM_ID | Item ID |
| UNIT_PRICE | Price |
| UOM | Unit of Measure |
| CURRENCY_CODE | Currency Code |
| PRICE_CODE | price code used when no price available |
| BUYER_APPROVAL_STATUS | Buyer Approval Status. Possible values are: APPROVED, DELETED, OUTDATED, PUBLISHED, UNPUBLISHED |
| BUYER_APPROVAL_DATE | Buyer Approval Date |
| Oracle iProcurement - ICX_POR_UPLOAD_IT_DUMP | Internal table used to store temporary data during an item/price bulk load job |
|---|---|
| Column Name | Descritpion |
| JOB_NUMBER | Job unique identifier |
| CATEGORY_KEY | Category Key |
| ROOT63 | Stores base/root attribute value |
| ROOT64 | Stores base/root attribute value |
| ROOT65 | Stores base/root attribute value |
| ROOT66 | Stores base/root attribute value |
| ROOT67 | Stores base/root attribute value |
| ROOT68 | Stores base/root attribute value |
| ROOT69 | Stores base/root attribute value |
| ROOT70 | Stores base/root attribute value |
| ROOT71 | Stores base/root attribute value |
| ROOT72 | Stores base/root attribute value |
| SUPPLIER_NAME | Supplier Name |
| ROOT73 | Stores base/root attribute value |
| ROOT74 | Stores base/root attribute value |
| ROOT75 | Stores base/root attribute value |
| ROOT76 | Stores base/root attribute value |
| ROOT77 | Stores base/root attribute value |
| ROOT78 | Stores base/root attribute value |
| ROOT79 | Stores base/root attribute value |
| ROOT80 | Stores base/root attribute value |
| ROOT81 | Stores base/root attribute value |
| ROOT82 | Stores base/root attribute value |
| PRICE_BREAK_ID | Price break identifier |
| SUPPLIER_PART_NUM | Supplier Item Number |
| ROOT83 | Stores base/root attribute value |
| ROOT84 | Stores base/root attribute value |
| ROOT85 | Stores base/root attribute value |
| ROOT86 | Stores base/root attribute value |
| ROOT87 | Stores base/root attribute value |
| ROOT88 | Stores base/root attribute value |
| ROOT89 | Stores base/root attribute value |
| ROOT90 | Stores base/root attribute value |
| ROOT91 | Stores base/root attribute value |
| ROOT92 | Stores base/root attribute value |
| DESCRIPTION | Item Description |
| ROOT93 | Stores base/root attribute value |
| ROOT94 | Stores base/root attribute value |
| ROOT95 | Stores base/root attribute value |
| ROOT96 | Stores base/root attribute value |
| ROOT97 | Stores base/root attribute value |
| ROOT98 | Stores base/root attribute value |
| ROOT99 | Stores base/root attribute value |
| ROOT100 | Stores base/root attribute value |
| ROOT101 | Stores base/root attribute value |
| ROOT102 | Stores base/root attribute value |
| UNSPSC_CODE | UNSPSC Code. |
| ROOT103 | Stores base/root attribute value |
| ROOT104 | Stores base/root attribute value |
| ROOT105 | Stores base/root attribute value |
| ROOT106 | Stores base/root attribute value |
| ROOT107 | Stores base/root attribute value |
| ROOT108 | Stores base/root attribute value |
| ROOT109 | Stores base/root attribute value |
| ROOT110 | Stores base/root attribute value |
| ROOT111 | Stores base/root attribute value |
| ROOT112 | Stores base/root attribute value |
| PRICE_BREAK_COUNT | Price break count |
| ITEM_TYPE | Item Type |
| ROOT113 | Stores base/root attribute value |
| ROOT114 | Stores base/root attribute value |
| ROOT115 | Stores base/root attribute value |
| ROOT116 | Stores base/root attribute value |
| ROOT117 | Stores base/root attribute value |
| ROOT118 | Stores base/root attribute value |
| ROOT119 | Stores base/root attribute value |
| ROOT120 | Stores base/root attribute value |
| ROOT121 | Stores base/root attribute value |
| ROOT122 | Stores base/root attribute value |
| OWNER_NAME | Item Owner Name |
| ROOT123 | Stores base/root attribute value |
| ROOT124 | Stores base/root attribute value |
| ROOT125 | Stores base/root attribute value |
| ROOT126 | Stores base/root attribute value |
| ROOT127 | Stores base/root attribute value |
| ROOT128 | Stores base/root attribute value |
| ROOT129 | Stores base/root attribute value |
| ROOT130 | Stores base/root attribute value |
| ROOT131 | Stores base/root attribute value |
| ROOT132 | Stores base/root attribute value |
| BEGINDATE | Begin date |
| RT_CATEGORY_ID | Category ID |
| ROOT133 | Stores base/root attribute value |
| ROOT134 | Stores base/root attribute value |
| ROOT135 | Stores base/root attribute value |
| ROOT136 | Stores base/root attribute value |
| ROOT137 | Stores base/root attribute value |
| ROOT138 | Stores base/root attribute value |
| ROOT139 | Stores base/root attribute value |
| ROOT140 | Stores base/root attribute value |
| ROOT141 | Stores base/root attribute value |
| ROOT142 | Stores base/root attribute value |
| ENDDATE | End date |
| OLD_CATEGORY_ID | Old Category ID. Used for reclassification. |
| ROOT143 | Stores base/root attribute value |
| ROOT144 | Stores base/root attribute value |
| ROOT145 | Stores base/root attribute value |
| ROOT146 | Stores base/root attribute value |
| ROOT147 | Stores base/root attribute value |
| ROOT148 | Stores base/root attribute value |
| ROOT149 | Stores base/root attribute value |
| ROOT150 | Stores base/root attribute value |
| ROOT151 | Stores base/root attribute value |
| ROOT152 | Stores base/root attribute value |
| RT_ITEM_ID | Item ID |
| ROOT153 | Stores base/root attribute value |
| ROOT154 | Stores base/root attribute value |
| ROOT155 | Stores base/root attribute value |
| ROOT156 | Stores base/root attribute value |
| ROOT157 | Stores base/root attribute value |
| ROOT158 | Stores base/root attribute value |
| ROOT159 | Stores base/root attribute value |
| ROOT160 | Stores base/root attribute value |
| ROOT161 | Stores base/root attribute value |
| ROOT162 | Stores base/root attribute value |
| LINE_NUMBER | Line Number |
| UNPUBLISHED_ITEM_ID | Unpublished Item ID |
| ROOT163 | Stores base/root attribute value |
| ROOT164 | Stores base/root attribute value |
| ROOT165 | Stores base/root attribute value |
| ROOT166 | Stores base/root attribute value |
| ROOT167 | Stores base/root attribute value |
| ROOT168 | Stores base/root attribute value |
| ROOT169 | Stores base/root attribute value |
| ROOT170 | Stores base/root attribute value |
| ROOT171 | Stores base/root attribute value |
| ROOT172 | Stores base/root attribute value |
| UNPUBLISHED_CATEGORY_ID | Unpublished Category ID |
| ROOT173 | Stores base/root attribute value |
| ROOT174 | Stores base/root attribute value |
| ROOT175 | Stores base/root attribute value |
| ROOT176 | Stores base/root attribute value |
| ROOT177 | Stores base/root attribute value |
| ROOT178 | Stores base/root attribute value |
| ROOT179 | Stores base/root attribute value |
| ROOT180 | Stores base/root attribute value |
| ROOT181 | Stores base/root attribute value |
| ROOT182 | Stores base/root attribute value |
| SUPPLIER_ID | Supplier ID |
| ROOT183 | Stores base/root attribute value |
| ROOT184 | Stores base/root attribute value |
| ROOT185 | Stores base/root attribute value |
| ROOT186 | Stores base/root attribute value |
| ROOT187 | Stores base/root attribute value |
| ROOT188 | Stores base/root attribute value |
| ROOT189 | Stores base/root attribute value |
| ROOT190 | Stores base/root attribute value |
| ROOT191 | Stores base/root attribute value |
| ROOT192 | Stores base/root attribute value |
| OWNER_ID | Item Owner ID |
| ROOT193 | Stores base/root attribute value |
| ROOT194 | Stores base/root attribute value |
| ROOT195 | Stores base/root attribute value |
| ROOT196 | Stores base/root attribute value |
| ROOT197 | Stores base/root attribute value |
| ROOT198 | Stores base/root attribute value |
| ROOT199 | Stores base/root attribute value |
| ROOT200 | Stores base/root attribute value |
| ROOT201 | Stores base/root attribute value |
| ROOT202 | Stores base/root attribute value |
| BUYER_ID | Buyer ID |
| ROOT203 | Stores base/root attribute value |
| ROOT204 | Stores base/root attribute value |
| ROOT205 | Stores base/root attribute value |
| ROOT206 | Stores base/root attribute value |
| ROOT207 | Stores base/root attribute value |
| ROOT208 | Stores base/root attribute value |
| ROOT209 | Stores base/root attribute value |
| ROOT210 | Stores base/root attribute value |
| ROOT211 | Stores base/root attribute value |
| ROOT212 | Stores base/root attribute value |
| PRICELIST_ID | Price List ID |
| ROOT213 | Stores base/root attribute value |
| ROOT214 | Stores base/root attribute value |
| ROOT215 | Stores base/root attribute value |
| ROOT216 | Stores base/root attribute value |
| ROOT217 | Stores base/root attribute value |
| ROOT218 | Stores base/root attribute value |
| ROOT219 | Stores base/root attribute value |
| ROOT220 | Stores base/root attribute value |
| ROOT221 | Stores base/root attribute value |
| ROOT222 | Stores base/root attribute value |
| PRICELINE_ROWID | Price Line ROW ID |
| ROOT223 | Stores base/root attribute value |
| ROOT224 | Stores base/root attribute value |
| ROOT225 | Stores base/root attribute value |
| ROOT226 | Stores base/root attribute value |
| ROOT227 | Stores base/root attribute value |
| ROOT228 | Stores base/root attribute value |
| ROOT229 | Stores base/root attribute value |
| ROOT230 | Stores base/root attribute value |
| ROOT231 | Stores base/root attribute value |
| ROOT232 | Stores base/root attribute value |
| UNAPPROVED_PRICELINE_ROWID | Unapproved Price Line ROWID |
| ROOT233 | Stores base/root attribute value |
| ROOT234 | Stores base/root attribute value |
| ROOT235 | Stores base/root attribute value |
| ROOT236 | Stores base/root attribute value |
| ROOT237 | Stores base/root attribute value |
| ROOT238 | Stores base/root attribute value |
| ROOT239 | Stores base/root attribute value |
| ROOT240 | Stores base/root attribute value |
| ROOT241 | Stores base/root attribute value |
| ROOT242 | Stores base/root attribute value |
| UOM_NAME | Unit of Measure Name |
| ROOT243 | Stores base/root attribute value |
| ROOT244 | Stores base/root attribute value |
| ROOT245 | Stores base/root attribute value |
| ROOT246 | Stores base/root attribute value |
| ROOT247 | Stores base/root attribute value |
| ROOT248 | Stores base/root attribute value |
| ROOT249 | Stores base/root attribute value |
| ROOT250 | Stores base/root attribute value |
| LOCAL1 | Stores category attribute value |
| LOCAL2 | Stores category attribute value |
| BUYER_NAME | Buyer Name |
| LOCAL3 | Stores category attribute value |
| LOCAL4 | Stores category attribute value |
| LOCAL5 | Stores category attribute value |
| LOCAL6 | Stores category attribute value |
| LOCAL7 | Stores category attribute value |
| LOCAL8 | Stores category attribute value |
| LOCAL9 | Stores category attribute value |
| LOCAL10 | Stores category attribute value |
| LOCAL11 | Stores category attribute value |
| LOCAL12 | Stores category attribute value |
| ROW_TYPE | Indicates type of line being loaded. It could be ITEM_PRICE or PRICE |
| PRICE_STRING | Stores price. |
| LOCAL13 | Stores category attribute value |
| LOCAL14 | Stores category attribute value |
| LOCAL15 | Stores category attribute value |
| LOCAL16 | Stores category attribute value |
| LOCAL17 | Stores category attribute value |
| LOCAL18 | Stores category attribute value |
| LOCAL19 | Stores category attribute value |
| LOCAL20 | Stores category attribute value |
| LOCAL21 | Stores category attribute value |
| LOCAL22 | Stores category attribute value |
| PRICELIST_NAME | Price List Name |
| LOCAL23 | Stores category attribute value |
| LOCAL24 | Stores category attribute value |
| LOCAL25 | Stores category attribute value |
| LOCAL26 | Stores category attribute value |
| LOCAL27 | Stores category attribute value |
| LOCAL28 | Stores category attribute value |
| LOCAL29 | Stores category attribute value |
| LOCAL30 | Stores category attribute value |
| LOCAL31 | Stores category attribute value |
| LOCAL32 | Stores category attribute value |
| CURRENCY_CODE | Currency Code |
| LOCAL33 | Stores category attribute value |
| LOCAL34 | Stores category attribute value |
| LOCAL35 | Stores category attribute value |
| LOCAL36 | Stores category attribute value |
| LOCAL37 | Stores category attribute value |
| LOCAL38 | Stores category attribute value |
| LOCAL39 | Stores category attribute value |
| LOCAL40 | Stores category attribute value |
| LOCAL41 | Stores category attribute value |
| LOCAL42 | Stores category attribute value |
| UOM_CODE | Unit of Measure Code |
| LOCAL43 | Stores category attribute value |
| LOCAL44 | Stores category attribute value |
| LOCAL45 | Stores category attribute value |
| LOCAL46 | Stores category attribute value |
| LOCAL47 | Stores category attribute value |
| LOCAL48 | Stores category attribute value |
| LOCAL49 | Stores category attribute value |
| LOCAL50 | Stores category attribute value |
| PRICE_CODE | Price Code |
| SUPPLIER_COMMENTS | Supplier Comments |
| REQUIRED_DESCRIPTORS | Key of required attributes that have no values |
| REQUIRED_TL_DESCRIPTORS | Key of required translatable attributes that have no values |
| PROCESSED_FLAG | Processed Flag which indicates whether the row is processed. |
| OLD_PRICE_BREAK_ID | The price break id of the line from which this line is copied. |
| ROOT1 | Stores base/root attribute value |
| ROOT2 | Stores base/root attribute value |
| LANGUAGE | Language of the line |
| ROOT3 | Stores base/root attribute value |
| ROOT4 | Stores base/root attribute value |
| ROOT5 | Stores base/root attribute value |
| ROOT6 | Stores base/root attribute value |
| ROOT7 | Stores base/root attribute value |
| ROOT8 | Stores base/root attribute value |
| ROOT9 | Stores base/root attribute value |
| ROOT10 | Stores base/root attribute value |
| ROOT11 | Stores base/root attribute value |
| ROOT12 | Stores base/root attribute value |
| ACTION | Action requested by the user on the line |
| ROOT13 | Stores base/root attribute value |
| ROOT14 | Stores base/root attribute value |
| ROOT15 | Stores base/root attribute value |
| ROOT16 | Stores base/root attribute value |
| ROOT17 | Stores base/root attribute value |
| ROOT18 | Stores base/root attribute value |
| ROOT19 | Stores base/root attribute value |
| ROOT20 | Stores base/root attribute value |
| ROOT21 | Stores base/root attribute value |
| ROOT22 | Stores base/root attribute value |
| SYSTEM_ACTION | Defined system action. |
| ROOT23 | Stores base/root attribute value |
| ROOT24 | Stores base/root attribute value |
| ROOT25 | Stores base/root attribute value |
| ROOT26 | Stores base/root attribute value |
| ROOT27 | Stores base/root attribute value |
| ROOT28 | Stores base/root attribute value |
| ROOT29 | Stores base/root attribute value |
| ROOT30 | Stores base/root attribute value |
| ROOT31 | Stores base/root attribute value |
| ROOT32 | Stores base/root attribute value |
| ERROR_FLAG | Indicates whether an error has been found during validation. |
| ROOT33 | Stores base/root attribute value |
| ROOT34 | Stores base/root attribute value |
| ROOT35 | Stores base/root attribute value |
| ROOT36 | Stores base/root attribute value |
| ROOT37 | Stores base/root attribute value |
| ROOT38 | Stores base/root attribute value |
| ROOT39 | Stores base/root attribute value |
| ROOT40 | Stores base/root attribute value |
| ROOT41 | Stores base/root attribute value |
| ROOT42 | Stores base/root attribute value |
| ERROR_MESSAGE | Stores error messages if any. |
| ROOT43 | Stores base/root attribute value |
| ROOT44 | Stores base/root attribute value |
| ROOT45 | Stores base/root attribute value |
| ROOT46 | Stores base/root attribute value |
| ROOT47 | Stores base/root attribute value |
| ROOT48 | Stores base/root attribute value |
| ROOT49 | Stores base/root attribute value |
| ROOT50 | Stores base/root attribute value |
| ROOT51 | Stores base/root attribute value |
| ROOT52 | Stores base/root attribute value |
| CATEGORY_NAME | Category Name |
| ROOT53 | Stores base/root attribute value |
| ROOT54 | Stores base/root attribute value |
| ROOT55 | Stores base/root attribute value |
| ROOT56 | Stores base/root attribute value |
| ROOT57 | Stores base/root attribute value |
| ROOT58 | Stores base/root attribute value |
| ROOT59 | Stores base/root attribute value |
| ROOT60 | Stores base/root attribute value |
| ROOT61 | Stores base/root attribute value |
| ROOT62 | Stores base/root attribute value |
| Oracle iProcurement - ICX_POR_DESCRIPTORS_CACHE | Table to implement Caching in the Base Attributes creation and management. This table has been designed to give the operator a facility to do Review and Submit for all the changes done. |
|---|---|
| Column Name | Descritpion |
| SESSION_KEY | Unique Identifier for the user session |
| DESCRIPTOR_NAME | Descriptor Name |
| DESCRIPTION | Description |
| ITEM_DETAIL_VISIBLE | Indicates whether this Descriptor will be visible when Item Details are displayed. |
| SEARCH_RESULTS_VISIBLE | Indicates whether this Descriptor will be visible when Search Results are displayed. |
| SEARCHABLE | Indicates whether items are searchable based on this Descriptor's value. |
| REQUIRED | Indicates whether the attribute/descriptor is required. |
| MULTIVALUE | Reserved for future use. |
| CUSTOMIZATION_LEVEL | Customization Level (All the attributes of this attribute are implemented in a bitmap 0 - No1 - Yes) |
| SECTION_TAG | Section Tag used for the descriptor in the Section based searching |
| CREATED_BY | Standard Who column |
| DB_ACTION | Database Action - ADD/EDIT/DELETE |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| RT_DESCRIPTOR_ID | Unique Identifier for attribute/descriptor |
| RT_CATEGORY_ID | Unique Identifier for Category |
| LANGUAGE | Language |
| KEY | Attribute/Descriptor Key |
| CLASS | Descriptor Class - POM_BASE_ATTR / IPD_BASE_ATTR / POM_CAT_ATTR |
| TYPE | Descriptor/Attribute Type |
| SEQUENCE | Sequence |
| Oracle iProcurement - ICX_POR_THIRD_PARTY_LOG_VALUES | Table to store detail log information of the Third Party Authoring changes performed on behalf of Suppliers for Items and Prices. |
|---|---|
| Column Name | Descritpion |
| DESCRIPTOR_KEY | Descriptor Key for the descriptor which was updated |
| OLD_VALUE | Value stored in the descriptor/attribute prior to the update. |
| NEW_VALUE | Value stored in the descriptor/attribute after the update. |
| 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 |
| LOG_ID | Log ID |
| Oracle iProcurement - ICX_POR_THIRD_PARTY_LOGS | Table that stores historical data of Third Party Content Provider activity on Suppliers' catalogs. |
|---|---|
| Column Name | Descritpion |
| THIRD_PARTY_ID | Third Party Content Provider ID |
| THIRD_PARTY_NAME | Third Party Content Provider Name |
| THIRD_PARTY_USER_ID | Third Party Content Provider User ID |
| SUPPLIER_ID | Supplier ID |
| SUPPLIER_NAME | Supplier Name |
| ACTION | Action performed on the Item or Price |
| ITEM_ID | Item ID |
| ITEM_NUMBER | Supplier Item Number |
| ITEM_DESCRIPTION | Item Description |
| LOG_ID | Log ID |
| PRICE_LIST_ID | Price List ID |
| PRICE_LIST_NAME | Price List Name |
| LANGUAGE | Language |
| LOG_DATE | Log Date |
| 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 |
| Oracle iProcurement - ICX_POR_UPLOADER_SUBTABLE | Temp Information for uploader |
|---|---|
| Column Name | Descritpion |
| BUSINESS_GROUP_ID | Business group ID |
| OPERATING_UNIT | Operating Unit |
| SUPPLIER_NAME | Supplier name |
| SUPPLIER_SITE | Supplier Site |
| CONTRACT_REFERENCE_NUM | Contract Reference Number |
| JOB_NUMBER | Upload job number |
| Oracle iProcurement - ICX_POR_DAILY_NOTIFICATIONS | Table to store the Daily Notifications generated due to Publishing or Discarding of Item Loader Jobs and due to Approval or Rejection of pricing by buyers. |
|---|---|
| Column Name | Descritpion |
| PARTY_TYPE | Party Type |
| LAST_RUN_DATE | Last Run Date |
| USER_ID | User ID |
| PARTY_ID | Unique Identifier for a Trading Partner. |
| Oracle iProcurement - ICX_POR_BUYER_APPROVAL_JOBS | Holds detail information on Buyer Pricing Approval/Rejection batch processes. |
|---|---|
| Column Name | Descritpion |
| PRICE_LIST_HEADER_ID | Unique identifier for a Price List |
| MAX_PUBLISHED_DATE | Max Published date used to handle concurrency for the case of 2 or more jobs trying to Approve/Reject lines on the same Price List. |
| ACTION | Action requested by the user. Possible values are APPROVE or REJECT. |
| COMMENTS | Comments used to justify rejecting Price Lines. |
| JOB_NUMBER | Job Number assigned to the process for Approval or Rejection of Buyer Specific Prices. |
| Oracle iProcurement - ICX_POR_FAILED_LINE_MESSAGES | Maintains information about items/prices/schema elements that the loader rejected during a load job. |
|---|---|
| Column Name | Descritpion |
| LINE_NUMBER | Line number rejected during the load. |
| DESCRIPTOR_KEY | Key for the descriptor causing the rejection if any. |
| MESSAGE_NAME | Name of the message describing the cause for the rejection. |
| TOKEN_LIST | Has the tokens that need to be displayed with the failed line message |
| JOB_NUMBER | Internally generated identifier for the batch process. |
| Oracle iProcurement - ICX_POR_FAILED_LINES | Maintains information about items/prices/schema elements that the loader rejected during a load job. |
|---|---|
| Column Name | Descritpion |
| LINE_NUMBER | Line number rejected during the load. |
| ACTION | Action requested for the Item/Price or Schema element. |
| ROW_TYPE | Row Type owning the rejection. Possible values are: CATEGORY, DESCRIPTOR, ITEM_PRICE, PRICE, RELATIONSHIP |
| DESCRIPTOR_KEY | Key for the descriptor whose value is stored in descriptor_value for the rejected line. |
| DESCRIPTOR_VALUE | Value given for the descriptor in the file submitted for loading. |
| JOB_NUMBER | Internally generated identifier for the batch process. |
| Oracle iProcurement - ICX_POR_EXT_QUERY_TL | Stores named extended queries or a URL for an item. |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | Item unique identifier |
| LANGUAGE | Language |
| SOURCE_LANG | Source language |
| QUERY | BugsEye query or URL |
| TYPE | QUERY or URL |
| LABEL | Text displayed next to icon in results |
| PICTURE | Icon to use |
| 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 |
| REQUEST_ID | Request ID |
| PROGRAM_APPLICATION_ID | Program application ID |
| PROGRAM_ID | Program ID |
| PROGRAM_UPDATE_DATE | Program update date |
| Oracle iProcurement - ICX_POR_TEMPLATE_FILES | Stores information for template files. |
|---|---|
| Column Name | Descritpion |
| FILENAME | File name |
| USAGE | Usage |
| DESCRIPTION | Description |
| TEMPLATE_TYPE | Template type |
| Oracle iProcurement - ICX_POR_BATCH_JOBS | Holds information about submitted catalog batch processes. |
|---|---|
| Column Name | Descritpion |
| SUPPLIER_ID | Supplier ID |
| MAX_FAILED_LINES | User defined maximum allowed failed lines in a load job before the job is terminated. |
| LOAD_SUPPLIER_ID | Supplier Internal Identifier for owner of items during an item loader job. The SUPPLIER_ID in this case represents the Third Party Catalog Author Internal Identifier if the job was submitted by a Third Party. |
| CREATED_BY | Standard WHO Columns |
| CREATION_DATE | Standard WHO Columns |
| LAST_UPDATED_BY | Standard WHO Columns |
| SUPPLIER_FILE_NAME | Supplier file name as supplied by the supplier at upload time |
| LAST_UPDATE_DATE | Standard WHO Columns |
| DESCRIPTION | |
| EXCHANGE_FILE_NAME | File name that Exchange uses to save the file |
| ITEMS_LOADED | Count of Items successfully loaded |
| ITEMS_FAILED | Count of Items that failed during a Loader batch process. |
| JOB_STATUS | Job Status. Valid Statuses are PENDING, RUNNING, COMPLETED, COMPLETED W/ERRORS, FAILED, PENDING PUBLICATION, FAILED PUBLICATION, PUBLISHED, PENDING DISCARD, FAILED DISCARD, DISCARDED |
| SUBMISSION_DATETIME | Date and Time of job submission |
| START_DATETIME | Date and Time the job started processing |
| JOB_NUMBER | This column will hold the concurrent request id |
| COMPLETION_DATETIME | Date and Time the job completed |
| FAILURE_MESSAGE | Failure message |
| REQUEST_ID | This is the concurrent request id |
| HOST_IP_ADDRESS | IP Address of the Web Server from where the job was submitted. This helps us balance the load in a multi-loader setup. |
| EXCHANGE_OPERATOR_NAME | Exchange Operator Name |
| HEADERS_LOADED | Count of headers successfully loaded |
| JOB_TYPE | Job Type. Valid values are defined in the Catalog Loader and Downloader Configuration File |
| SYSTEM_FAILURE_MESSAGE | Operating System Failure message, if any. |
| HEADERS_FAILED | Count of headers that failed the load |
| LANGUAGE | Language in which the job is submitted |
| PRICES_LOADED | Count of Price Lines that were successfully loaded. |
| TIMEZONE | Time zone |
| PRICES_FAILED | Count of Price Lines that failed the load. |
| EXCHANGE_OPERATOR_ID | Exchange Operator Internal Identification Number |
| Oracle iProcurement - ICX_UNSPSC_CODES | Contains information of the UNSPSC commodity codes. |
|---|---|
| Column Name | Descritpion |
| DESCRIPTION | Description |
| UNSPSC_CODE | UNSPSC Code |
| Oracle iProcurement - ICX_POR_PRICE_LISTS | Stores price lists information. There is 1 price list per buyer/supplier combination. |
|---|---|
| Column Name | Descritpion |
| HEADER_ID | Price List unique identifier |
| BUYERCOMMENTS | Comments from buyer |
| NAME | Price List Name |
| SUPPLIER_ID | Supplier ID for supplier providing the Price List. |
| BUYER_ID | Buyer ID which can either be the Operator ID if Price List is for all buyers or a specific buyer for buyer specific Price List. |
| DESCRIPTION | Description |
| CURRENCY_CODE | Currency Code |
| JOB_NUMBER | Job Number |
| ACTION | Action |
| TYPE | Type of the price list. |
| PARENT_HEADER_ID | Header id of the parent price list. |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| BEGINDATE | Begin date |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CONTRACT_NUMBER | This column holds the contract agreement number associated with the price list |
| ENDDATE | End date |
| STATUS | Status |
| PUBLISHED_DATE | Date published |
| OUTDATED_DATE | Date outdated |
| APPROVAL_DATE | Date of approval |
| REJECTED_DATE | Date rejected |
| DELETED_DATE | Date deleted |
| Oracle iProcurement - ICX_POR_PRICE_LIST_LINES_CACHE | Cache table for price list lines information. |
|---|---|
| Column Name | Descritpion |
| HEADER_ID | price list ID |
| PRICE_CODE | Price Code |
| SUPPLIERCOMMENTS | Supplier Comments |
| EFFECTIVE_BEGINDATE | Effective begin date |
| EFFECTIVE_ENDDATE | Effective end date |
| BEGINDATE | Begin date |
| ENDDATE | End date |
| LIST_NAME | Price List Name |
| DB_ACTION | Database Action - ADD/EDIT/DELETE |
| SESSION_KEY | Unique Identifier for the user session |
| SUPPLIER_ID | supplier id |
| BUYER_ID | buyer id |
| ITEM_ID | item id |
| UNIT_PRICE | unit price |
| UOM | unit of measure |
| CURRENCY_CODE | Currency Code |
| BUYER_APPROVAL_STATUS | Buyer approval status |
| COMMENTS | Buyer Comments |
| Oracle iProcurement - ICX_POR_UNSPSC_CODES | Contains a complete listing of the UNSPSC commodity codes. |
|---|---|
| Column Name | Descritpion |
| NAME | Name |
| SEGMENT | Segment |
| FAMILY | Family |
| CLASS | Class |
| EXTENDED_COMMODITY | Extended commodity |
| COMMODITY | Commodity |
| LANGUAGE | Language |
| SOURCE_LANG | Source Language |
| Oracle iProcurement - POR_LOV_DISPLAY_RESULTS | LOV display results |
|---|---|
| Column Name | Descritpion |
| SESSION_ID | Session id |
| VALUE8 | Temporary value 8 |
| VALUE98 | Temporary value 98 |
| VALUE99 | Temporary value 99 |
| VALUE100 | Temporary value 100 |
| 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 |
| VALUE9 | Temporary value 9 |
| VALUE10 | Temporary value 10 |
| VALUE11 | Temporary value 11 |
| VALUE12 | Temporary value 12 |
| SEQUENCE | Sequence |
| VALUE13 | Temporary value 13 |
| VALUE14 | Temporary value 14 |
| VALUE15 | Temporary value 15 |
| VALUE16 | Temporary value 16 |
| VALUE17 | Temporary value 17 |
| TYPE | Type of the display result |
| VALUE18 | Temporary value 18 |
| VALUE19 | Temporary value 19 |
| VALUE20 | Temporary value 20 |
| VALUE21 | Temporary value 21 |
| VALUE22 | Temporary value 22 |
| VALUE23 | Temporary value 23 |
| VALUE24 | Temporary value 24 |
| VALUE25 | Temporary value 25 |
| VALUE26 | Temporary value 26 |
| VALUE27 | Temporary value 27 |
| VALUE1 | Temporary value 1 |
| VALUE28 | Temporary value 28 |
| VALUE29 | Temporary value 29 |
| VALUE30 | Temporary value 30 |
| VALUE31 | Temporary value 31 |
| VALUE32 | Temporary value 32 |
| VALUE33 | Temporary value 33 |
| VALUE34 | Temporary value 34 |
| VALUE35 | Temporary value 35 |
| VALUE36 | Temporary value 36 |
| VALUE37 | Temporary value 37 |
| VALUE2 | Temporary value 2 |
| VALUE38 | Temporary value 38 |
| VALUE39 | Temporary value 39 |
| VALUE40 | Temporary value 40 |
| VALUE41 | Temporary value 41 |
| VALUE42 | Temporary value 42 |
| VALUE43 | Temporary value 43 |
| VALUE44 | Temporary value 44 |
| VALUE45 | Temporary value 45 |
| VALUE46 | Temporary value 46 |
| VALUE47 | Temporary value 47 |
| VALUE3 | Temporary value 3 |
| VALUE48 | Temporary value 48 |
| VALUE49 | Temporary value 49 |
| VALUE50 | Temporary value 50 |
| VALUE51 | Temporary value 51 |
| VALUE52 | Temporary value 52 |
| VALUE53 | Temporary value 53 |
| VALUE54 | Temporary value 54 |
| VALUE55 | Temporary value 55 |
| VALUE56 | Temporary value 56 |
| VALUE57 | Temporary value 57 |
| VALUE4 | Temporary value 4 |
| VALUE58 | Temporary value 58 |
| VALUE59 | Temporary value 59 |
| VALUE60 | Temporary value 60 |
| VALUE61 | Temporary value 61 |
| VALUE62 | Temporary value 62 |
| VALUE63 | Temporary value 63 |
| VALUE64 | Temporary value 64 |
| VALUE65 | Temporary value 65 |
| VALUE66 | Temporary value 66 |
| VALUE67 | Temporary value 67 |
| VALUE5 | Temporary value 5 |
| VALUE68 | Temporary value 68 |
| VALUE69 | Temporary value 69 |
| VALUE70 | Temporary value 70 |
| VALUE71 | Temporary value 71 |
| VALUE72 | Temporary value 72 |
| VALUE73 | Temporary value 73 |
| VALUE74 | Temporary value 74 |
| VALUE75 | Temporary value 75 |
| VALUE76 | Temporary value 76 |
| VALUE77 | Temporary value 77 |
| VALUE6 | Temporary value 6 |
| VALUE78 | Temporary value 78 |
| VALUE79 | Temporary value 79 |
| VALUE80 | Temporary value 80 |
| VALUE81 | Temporary value 81 |
| VALUE82 | Temporary value 82 |
| VALUE83 | Temporary value 83 |
| VALUE84 | Temporary value 84 |
| VALUE85 | Temporary value 85 |
| VALUE86 | Temporary value 86 |
| VALUE87 | Temporary value 87 |
| VALUE7 | Temporary value 7 |
| VALUE88 | Temporary value 88 |
| VALUE89 | Temporary value 89 |
| VALUE90 | Temporary value 90 |
| VALUE91 | Temporary value 91 |
| VALUE92 | Temporary value 92 |
| VALUE93 | Temporary value 93 |
| VALUE94 | Temporary value 94 |
| VALUE95 | Temporary value 95 |
| VALUE96 | Temporary value 96 |
| VALUE97 | Temporary value 97 |
| Oracle iProcurement - POR_CONFIGURABLE_USER_DATA | User Configurable Data |
|---|---|
| Column Name | Descritpion |
| XML_TAG | XML tag |
| USER_ATTRIBUTE_CODE | User attribute code |
| SQL_STATEMENT | SQL statement |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| DATA_ID | Data ID |
| Oracle iProcurement - POR_CONTAINER_IMAGES | Container images |
|---|---|
| Column Name | Descritpion |
| CONTAINER_IMAGE_TYPE | Type of the container image |
| IMAGE_NAME | Image name |
| DISPLAY_SEQUENCE | Image display sequence |
| CONTAINER_IMAGE_NAME | Name of the container image |
| Oracle iProcurement - POR_IMAGES | Images |
|---|---|
| Column Name | Descritpion |
| MESSAGE_NAME | Message name |
| ALT_TEXT_KEY | Key for the ALT text |
| IMAGE_TYPE | Image type |
| IMAGE_NAME | Image name |
| Oracle iProcurement - POR_IMAGE_LANG_SETTINGS | Image language setting |
|---|---|
| Column Name | Descritpion |
| ANTIALIASED | Anti-aliased indicator |
| FONT_NAME | Font name |
| FONT_SIZE | Font size |
| MARGIN_TOP_SMALL | Small margin top |
| MARGIN_TOP_LARGE | Large top margin |
| MARGIN_BOTTOM_SMALL | Small buttom margin |
| MARGIN_BOTTOM_LARGE | Large buttom margin |
| LANGUAGE_CODE | Language code |
| Oracle iProcurement - POR_ITEM_ATTRIBUTE_VALUES | Item attribute values |
|---|---|
| Column Name | Descritpion |
| REQUISITION_HEADER_ID | Requisition header id |
| 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 |
| REQUISITION_LINE_ID | Requisition line id |
| ATTRIBUTE1 | Attribute 1 |
| ATTRIBUTE2 | Attribute 2 |
| ATTRIBUTE3 | Attribute 3 |
| ATTRIBUTE4 | Attribute 4 |
| ATTRIBUTE5 | Attribute 5 |
| ATTRIBUTE6 | Attribute 6 |
| ITEM_TYPE | Item type |
| ATTRIBUTE7 | Attribute 7 |
| ATTRIBUTE8 | Attribute 8 |
| ATTRIBUTE9 | Attribute 9 |
| ATTRIBUTE10 | Attribute 10 |
| ATTRIBUTE11 | Attribute 11 |
| ATTRIBUTE12 | Attribute 12 |
| ATTRIBUTE13 | Attribute 13 |
| ATTRIBUTE14 | Attribute 14 |
| ATTRIBUTE15 | Attribute 15 |
| ORG_ID | Organization id |
| Oracle iProcurement - POR_LOV_RESULT_VALUES | LOV result values |
|---|---|
| Column Name | Descritpion |
| SESSION_ID | Session id |
| VALUE8 | Temporary value 8 |
| VALUE98 | Temporary value 98 |
| VALUE99 | Temporary value 99 |
| VALUE100 | Temporary value 100 |
| 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 |
| VALUE9 | Temporary value 9 |
| VALUE10 | Temporary value 10 |
| VALUE11 | Temporary value 11 |
| VALUE12 | Temporary value 12 |
| VALUE13 | Temporary value 13 |
| VALUE14 | Temporary value 14 |
| VALUE15 | Temporary value 15 |
| VALUE16 | Temporary value 16 |
| VALUE17 | Temporary value 17 |
| TYPE | Type of the LOV result value |
| VALUE18 | Temporary value 18 |
| VALUE19 | Temporary value 19 |
| VALUE20 | Temporary value 20 |
| VALUE21 | Temporary value 21 |
| VALUE22 | Temporary value 22 |
| SEQUENCE | Sequence |
| VALUE23 | Temporary value 23 |
| VALUE24 | Temporary value 24 |
| VALUE25 | Temporary value 25 |
| VALUE26 | Temporary value 26 |
| VALUE27 | Temporary value 27 |
| VALUE1 | Temporary value 1 |
| VALUE28 | Temporary value 28 |
| VALUE29 | Temporary value 29 |
| VALUE30 | Temporary value 30 |
| VALUE31 | Temporary value 31 |
| VALUE32 | Temporary value 32 |
| VALUE33 | Temporary value 33 |
| VALUE34 | Temporary value 34 |
| VALUE35 | Temporary value 35 |
| VALUE36 | Temporary value 36 |
| VALUE37 | Temporary value 37 |
| VALUE2 | Temporary value 2 |
| VALUE38 | Temporary value 38 |
| VALUE39 | Temporary value 39 |
| VALUE40 | Temporary value 40 |
| VALUE41 | Temporary value 41 |
| VALUE42 | Temporary value 42 |
| VALUE43 | Temporary value 43 |
| VALUE44 | Temporary value 44 |
| VALUE45 | Temporary value 45 |
| VALUE46 | Temporary value 46 |
| VALUE47 | Temporary value 47 |
| VALUE3 | Temporary value 3 |
| VALUE48 | Temporary value 48 |
| VALUE49 | Temporary value 49 |
| VALUE50 | Temporary value 50 |
| VALUE51 | Temporary value 51 |
| VALUE52 | Temporary value 52 |
| VALUE53 | Temporary value 53 |
| VALUE54 | Temporary value 54 |
| VALUE55 | Temporary value 55 |
| VALUE56 | Temporary value 56 |
| VALUE57 | Temporary value 57 |
| VALUE4 | Temporary value 4 |
| VALUE58 | Temporary value 58 |
| VALUE59 | Temporary value 59 |
| VALUE60 | Temporary value 60 |
| VALUE61 | Temporary value 61 |
| VALUE62 | Temporary value 62 |
| VALUE63 | Temporary value 63 |
| VALUE64 | Temporary value 64 |
| VALUE65 | Temporary value 65 |
| VALUE66 | Temporary value 66 |
| VALUE67 | Temporary value 67 |
| VALUE5 | Temporary value 5 |
| VALUE68 | Temporary value 68 |
| VALUE69 | Temporary value 69 |
| VALUE70 | Temporary value 70 |
| VALUE71 | Temporary value 71 |
| VALUE72 | Temporary value 72 |
| VALUE73 | Temporary value 73 |
| VALUE74 | Temporary value 74 |
| VALUE75 | Temporary value 75 |
| VALUE76 | Temporary value 76 |
| VALUE77 | Temporary value 77 |
| VALUE6 | Temporary value 6 |
| VALUE78 | Temporary value 78 |
| VALUE79 | Temporary value 79 |
| VALUE80 | Temporary value 80 |
| VALUE81 | Temporary value 81 |
| VALUE82 | Temporary value 82 |
| VALUE83 | Temporary value 83 |
| VALUE84 | Temporary value 84 |
| VALUE85 | Temporary value 85 |
| VALUE86 | Temporary value 86 |
| VALUE87 | Temporary value 87 |
| VALUE7 | Temporary value 7 |
| VALUE88 | Temporary value 88 |
| VALUE89 | Temporary value 89 |
| VALUE90 | Temporary value 90 |
| VALUE91 | Temporary value 91 |
| VALUE92 | Temporary value 92 |
| VALUE93 | Temporary value 93 |
| VALUE94 | Temporary value 94 |
| VALUE95 | Temporary value 95 |
| VALUE96 | Temporary value 96 |
| VALUE97 | Temporary value 97 |
| Oracle iProcurement - ICX_PORTLET_CUSTOMIZATIONS | |
|---|---|
| Column Name | Descritpion |
| REFERENCE_PATH | |
| PAGE_ID | page id of portal pages |
| START_CACHING_TIMEMILLI | |
| FUNCTION_ID | |
| USER_AGENT | |
| PLUG_ID | |
| APPLICATION_ID | |
| RESPONSIBILITY_ID | |
| SECURITY_GROUP_ID | |
| CACHING_KEY | |
| CACHING_PERIOD | |
| TITLE | |
| USER_ID |
| Oracle iProcurement - ICX_TRANSACTIONS | Not used in Exchange Catalog. |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_ID | |
| LAST_CONNECT | |
| DISABLED_FLAG | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| XTID | |
| SESSION_ID | |
| RESPONSIBILITY_APPLICATION_ID | |
| RESPONSIBILITY_ID | |
| SECURITY_GROUP_ID | |
| MENU_ID | |
| FUNCTION_ID | |
| FUNCTION_TYPE | |
| PAGE_ID |
| Oracle iProcurement - POR_EMPLOYEE_LOADER_VALUES | Employee information populated by loader |
|---|---|
| Column Name | Descritpion |
| EMPLOYEE_NUMBER | This is the employee number for the employee in the organization. |
| SET_OF_BOOKS | This is the set of books associated with the organization, that the employee belongs to |
| DEFAULT_EXPENSE_ACCOUNT | This is the default expense account for the employee |
| JOB_NAME | This is the job name for the employee |
| SUPERVISOR_EMP_NUM | This is the employee number of the employee's supervisor. |
| USER_NAME | This is the employee's user name for the applications. |
| PASSWORD | This is the employee's password name for the applications. |
| EMAIL_ADDRESS | This is the employee's email address |
| WORK_TELEPHONE | This is the work telephone number of the employee |
| LOADER_STATUS | This indicates if this employee record was loaded correctly. |
| LAST_UPDATE_DATE | Date the record was last updated |
| LAST_UPDATE_LOGIN | The user name of the person who last updated it |
| LAST_UPDATED_BY | The person who last updated it |
| CREATION_DATE | The date the record was created |
| FIRST_NAME | This is the first name of the employee |
| CREATED_BY | The person who created the record |
| LAST_NAME | This is the last name of the employee |
| MIDDLE_NAME | This is the middle name of the employee |
| SEX | This is the sex of the employee |
| START_DATE | This is the start date of the employee in the organization |
| END_DATE | This is the end date of the employee in the organization |
| BUSINESS_GROUP_NAME | This is the name of the business group to which the employee belongs |
| LOCATION_CODE | This is the location code associated with that employee |
| Oracle iProcurement - POR_LOCATION_LOADER_VALUES | Location information populated by loader |
|---|---|
| Column Name | Descritpion |
| COUNTY | The county of the address of the location |
| LOCATION_CODE | The location code for this location |
| STATE | The state of the address of the location |
| POSTAL_CODE | The postal code of the address of the location |
| COUNTRY | The country of the address of the location |
| TELEPHONE | The telephone number at the address of the location |
| FAX | The fax number at the address of the location |
| SHIP_TO_LOCATION | The ship to location associated with this location |
| SHIP_TO_FLAG | Flag to indicate if this is a ship to location |
| BILL_TO_FLAG | Flag to indicate if this is a bill to location |
| RECEIVING_TO_FLAG | Flag to indicate if this is a receive to location |
| OFFICE_SITE | Flag to indicate if this is a office site |
| BUSINESS_GROUP | The business group to which this location belongs to |
| INTERNAL_SITE | Flag to indicate if this is a internal site |
| INVENTORY_ORG | The inventory organization to which this location is associated |
| TAX_NAME | The tax name associated with this location |
| LOADER_STATUS | This indicates if this location record was correctly loaded. |
| LAST_UPDATE_DATE | The date that the record was last updated. |
| CREATED_BY | The person who created the record. |
| CREATION_DATE | The date the record was created |
| LAST_UPDATE_LOGIN | The user name of the person who last updated it |
| LAST_UPDATED_BY | The person who last updated it |
| EFFECTIVE_DATE | The date from which this location is effective |
| DESCRIPTION | The description associated with this location. |
| ADDRESS_STYLE | The address style for the address of this location |
| ADDRESS_LINE_1 | The line 1 of the address of the location |
| ADDRESS_LINE_2 | The line 2 of the address of the location |
| ADDRESS_LINE_3 | The line 3 of the address of the location |
| CITY | The city of the address of the location |
| Oracle iProcurement - ICX_POR_UPLOAD_PRICE_BREAKS_DP | Table that contains information on Price Breaks. The loader will dump debug information to this table when the debug mode is on. |
|---|---|
| Column Name | Descritpion |
| JOB_NUMBER | Loader job number which loads this price break. |
| LINE_NUMBER | Line number in the file the price break is at. |
| TYPE | Type of the price break. |
| APPLICATION_METHOD | Defines how the price break is applied to a quantity. |
| CUMULATIVE | Flag which indicates whether the price break will be applied cumulatively. |
| BREAK_QUANTITY | The quantity at which the price break will be effective. |
| BREAK_AMOUNT | The amount that will be applied at the quantity. |
| Oracle iProcurement - ICX_POR_MANAGE_GROUPS_CACHE | DB Session Cache table for online purchasing group management. |
|---|---|
| Column Name | Descritpion |
| MEMBER_ID | Member id of the party to be added or deleted. |
| DB_ACTION | Action to be performed on the member id. |
| SESSION_KEY | Identifier for the session. |
| LAST_UPDATE_DATE | The last update date of the row. |
| Oracle iProcurement - ICX_POR_BROWSE_CATEGORIES | Table to store category browsing preferences for a company. |
|---|---|
| Column Name | Descritpion |
| PARTY_ID | Party ID of the Company. |
| RT_CATEGORY_ID | Category ID |
| Oracle iProcurement - ICX_POR_BATCH_JOB_DETAILS | Tables that stores the details of a batch job in the ICX_POR_BATCH_JOBS table. |
|---|---|
| Column Name | Descritpion |
| JOB_NUMBER | Batch job number in the ICX_POR_BATCH_JOBS table. |
| ATTRIBUTE9 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE10 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE1 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE2 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE3 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE4 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE5 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE6 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE7 | Attribute column for storing values. Usage is varied for different job types. |
| ATTRIBUTE8 | Attribute column for storing values. Usage is varied for different job types. |
| Oracle iProcurement - ICX_POR_CATALOG_PREFERENCES | Table that stored catalog preferences for the companies. |
|---|---|
| Column Name | Descritpion |
| PREFERENCE_TYPE | The type of the preference |
| ATTRIBUTE2 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| ATTRIBUTE3 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| ATTRIBUTE4 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| ATTRIBUTE5 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| ATTRIBUTE6 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| ATTRIBUTE7 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| ATTRIBUTE8 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| ATTRIBUTE9 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| ATTRIBUTE10 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| SUBJECT_ID | The Party ID of the subject which has this preference |
| OBJECT_ID | The Party ID of the object if this preference involves another party. The vaule will be -1 if no other party is involved. |
| LAST_UPDATE_DATE | Date this preference is last updated. |
| LAST_UPDATED_BY | User ID of the user who last updated this preference. |
| CREATION_DATE | Date this preference is created. |
| CREATED_BY | User ID of the user who creates this preference. |
| LAST_UPDATE_LOGIN | The login of the user who last updated this preference. |
| ATTRIBUTE1 | Column for storing value for the preference. How the value is interpreted depends on different preference types. |
| Oracle iProcurement - ICX_POR_PRICE_BREAKS | Table that contain information for Price Breaks. |
|---|---|
| Column Name | Descritpion |
| PRICE_BREAK_ID | Unique identifier for the Price Break. This ID is unique for a price line. |
| TYPE | The type of the Price Break. |
| APPLICATION_METHOD | Defines how the price break is applied to a quantity. |
| BREAK_QUANTITY | The quantity at which the break is effective. |
| BREAK_AMOUNT | The amount at that quantity. |
| CUMULATIVE | Flag which indicates whether the price break is applied cumulatively. |
| Oracle iProcurement - ICX_POR_UPLOAD_PRICE_BREAKS_IT | Temporary table that holds transient data about price breaks during an item bulk load process. This table will be truncated after each bulk load job. |
|---|---|
| Column Name | Descritpion |
| JOB_NUMBER | Loader job number which loads this price break. |
| LINE_NUMBER | Line number in the file this price break is at. |
| TYPE | Type of the Price Break. |
| APPLICATION_METHOD | Defines how the price break is applied to a quantity. |
| CUMULATIVE | Flag which indicates whether the price break will be applied cumulatively. |
| BREAK_QUANTITY | The quantity at which the price break will be effective. |
| BREAK_AMOUNT | The amount that will be applied at the quantity. |
| Oracle iProcurement - ICX_POR_CONTRACT_REFERENCES | Stores contract information for loader job |
|---|---|
| Column Name | Descritpion |
| JOB_NUMBER | Bulkloader job Concurrent request id |
| BUYER_ID | Buyer Identifier |
| BUYER_NAME | Buyer Name |
| CONTRACT_REFERENCE_ID | Contract Reference Id from ERP |
| CONTRACT_REFERENCE_NUM | Contract Number from ERP Purchasing |
| SUPPLIER_ID | Supplier id of the supplier |
| SUPPLIER_SITE | Supplier Site |
| PRICELIST_ID | Price List Id |
| CURRENCY_CODE | Currency Code |
| ERROR_MESSAGE | Error Message |
| REQUEST_ID | Bulkloader job Concurrent request id |
| LINE_NUMBER | Line Number |
| SUPPLIER_SITE_ID | Supplier site id from po_vendor_sites_all table |
| Oracle iProcurement - POR_FEED_RECORDS | PO distribution records |
|---|---|
| Column Name | Descritpion |
| CONCURRENT_REQUEST_ID | Concurrent request identifier of the run |
| VENDOR_SITE_CODE | Site code name |
| VENDOR_ID | Supplier identifier |
| VENDOR_SITE_ID | Supplier site identifier |
| ORDER_DATE | Last update date of PO document |
| BASE_CURRENCY_CODE | Operating unit's currency / Base currency |
| LOCAL_CURRENCY_CODE | Unique identifier for the currency |
| UNIT_OF_MEASURE | Unit of measure |
| ITEM_NUMBER | Item number |
| ITEM_DESCRIPTION | Item description |
| QUANTITY | Quantity ordered |
| PO_NUMBER | Document number |
| UNIT_PRICE | Unit price |
| AMOUNT | PO distribution amount: Quantity * Unit Price |
| PO_HEADER_AMOUNT | Sum of all distribution amounts for PO |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| ACCOUNTING_CODE | Concatenated accounting flexfield segments |
| APPROVAL_STATUS | Authorization status of the purchase order |
| APPROVED_DATE | Date the purchase order was last approved |
| CONTROL_STATUS | Closure status of the document |
| CANCEL_FLAG | Indicates whether the purchase order is cancelled or not |
| HOLD_FLAG | Indicates whether the purchase order is on hold or not |
| LINE_CANCEL_FLAG | Indicates whether the purchase order line is canceled or not |
| SHIPMENT_CANCEL_FLAG | Indicates whether the purchase order shipment is cancelled or not |
| ERROR_FLAG | Indicates whether this record has an error or not. Errored records are not included in po history feed. |
| RELEASE_NUMBER | Release number (Used in header) |
| PO_HEADER_ID | Purchase order header identifier |
| PO_RELEASE_ID | Purchase order release identifier |
| CARD_NUMBER | Card number |
| CARD_MEMBER_NAME | Card member name |
| CARD_BRAND_LOOKUP_CODE | Credit card brand lookup code |
| CARD_TYPE_LOOKUP_CODE | Credit card type lookup code |
| REQUESTER_ID | Requester identifier |
| VENDOR_NAME | Supplier name |
| Oracle iProcurement - POR_FEED_HISTORY | Run-time parameter values for the PO History Feed program |
|---|---|
| Column Name | Descritpion |
| CONCURRENT_REQUEST_ID | Concurrent Request identifier of the run |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| CARD_BRAND_LOOKUP_CODE | Credit card brand lookup code |
| VENDOR_ID | Supplier identifier |
| VENDOR_SITE_ID | Supplier site identifier |
| FROM_DATE_TIME | Starting date range for record selection (inclusive) |
| TO_DATE_TIME | Ending date range for record selection |
| OUTPUT_FILENAME | User entered filename |
| STATUS | Execution status of concurrent program |
| LAST_UPDATE_LOGIN | Standard Who column |
| Oracle iProcurement - POR_FEED_FIELD_FORMATS | Field formatting definitions per procurement card issuer |
|---|---|
| Column Name | Descritpion |
| FORMAT_ID | Format identifier |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| COLUMN_NAME | Name of column |
| RECORD_TYPE | Indicates whether column is part of the C/ontrol, H/eader or D/etail record |
| FIELD_LENGTH | Size definition for column |
| START_POSITION | Starting position for column |
| DEFAULT_VALUE | Default value for the column |
| PAD_CHARACTER | Padding character; Null implies space value |
| EFFECTIVE_DATE | Date on which format is effective |
| EXPIRATION_DATE | Date on which column definition expires |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| Oracle iProcurement - POR_FAV_CHARGE_ACCOUNTS | This table stores the information about the account preferences |
|---|---|
| Column Name | Descritpion |
| ACCOUNT_PREF_ID | Account preference identifier |
| LAST_UPDATED_BY | Standard who column |
| LAST_UPDATE_DATE | Standard who column |
| EMPLOYEE_ID | Employee id of the user |
| RESPONSIBILITY_ID | Responsibility id of the user |
| SET_OF_BOOKS_ID | Set of books id defined for the responsibility id |
| NICKNAME | Nickname associated with the account preference |
| CHARGE_ACCOUNT_ID | Charge account identifier of the account |
| DEFAULT_ACCOUNT | Whether the account is the default account for the particular user and responsibility (Y/N) |
| CREATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| Oracle iProcurement - ICX_CAT_CATEGORIES_TL | Categories Table |
|---|---|
| Column Name | Descritpion |
| LANGUAGE | Defined language for the row |
| BATCH_JOB_NUM | Job number that created this category |
| REBUILD_FLAG | Indicates whether the Intermedia Index should be rebuilt due to changes in the Category Definition. |
| UPPER_KEY | Category Key in Upper Case |
| SECTION_MAP | A bitmap that controls which columns in ICX_CAT_ITEMS_TL and ICX_CAT_EXT_ITEMS_TLP are free and can be assigned to new attributes. |
| SOURCE_LANG | Actual language for the row |
| CATEGORY_NAME | Name of the Category |
| DESCRIPTION | Description for the Category |
| TYPE | Type of the category - Genus or Navigational |
| KEY | Uniquw key for the Category |
| TITLE | ID of the originating system data source |
| ITEM_COUNT | Number of items in this category |
| RT_CATEGORY_ID | Internal identifier for a category. |
| CREATED_BY | Standard WHO column |
| CREATION_DATE | Date on which Category was created |
| LAST_UPDATED_BY | Standard WHO Column |
| LAST_UPDATE_DATE | Date on which the category was last updated |
| LAST_UPDATE_LOGIN | Standard WHO COlumn |
| REQUEST_ID | Extended Who Column |
| PROGRAM_APPLICATION_ID | Extended Who Column |
| PROGRAM_ID | Extended WHO column |
| PROGRAM_UPDATE_DATE | Extended WHO Column |
| UPPER_CATEGORY_NAME | Category name in upper case |
| Oracle iProcurement - ICX_CAT_EXT_ITEMS_TLP | Stores category attribute values. |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | Surrogate key |
| TEXT_CAT_ATTRIBUTE5 | 5th category attribute of type 0 |
| NUM_CAT_ATTRIBUTE45 | 45th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE46 | 46th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE47 | 47th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE48 | 48th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE49 | 49th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE50 | 50th category attribute of type 1 |
| TL_TEXT_CAT_ATTRIBUTE1 | 1st category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE2 | 2nd category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE3 | 3rd category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE4 | 4th category attribute of type 2 |
| TEXT_CAT_ATTRIBUTE6 | 6th category attribute of type 0 |
| TL_TEXT_CAT_ATTRIBUTE5 | 5th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE6 | 6th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE7 | 7th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE8 | 8th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE9 | 9th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE10 | 10th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE11 | 11th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE12 | 12th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE13 | 13th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE14 | 14th category attribute of type 2 |
| TEXT_CAT_ATTRIBUTE7 | 7th category attribute of type 0 |
| TL_TEXT_CAT_ATTRIBUTE15 | 15th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE16 | 16th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE17 | 17th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE18 | 18th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE19 | 19th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE20 | 20th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE21 | 21th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE22 | 22th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE23 | 23th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE24 | 24th category attribute of type 2 |
| TEXT_CAT_ATTRIBUTE8 | 8th category attribute of type 0 |
| TL_TEXT_CAT_ATTRIBUTE25 | 25th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE26 | 26th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE27 | 27th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE28 | 28th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE29 | 29th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE30 | 30th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE31 | 31th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE32 | 32th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE33 | 33th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE34 | 34th category attribute of type 2 |
| TEXT_CAT_ATTRIBUTE9 | 9th category attribute of type 0 |
| TL_TEXT_CAT_ATTRIBUTE35 | 35th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE36 | 36th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE37 | 37th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE38 | 38th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE39 | 39th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE40 | 40th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE41 | 41th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE42 | 42th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE43 | 43th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE44 | 44th category attribute of type 2 |
| TEXT_CAT_ATTRIBUTE10 | 10th category attribute of type 0 |
| TL_TEXT_CAT_ATTRIBUTE45 | 45th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE46 | 46th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE47 | 47th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE48 | 48th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE49 | 49th category attribute of type 2 |
| TL_TEXT_CAT_ATTRIBUTE50 | 50 |
| LAST_UPDATE_LOGIN | Standard WHO column |
| LAST_UPDATED_BY | Standard WHO column |
| LAST_UPDATE_DATE | Standard WHO column |
| CREATED_BY | Standard WHO column |
| TEXT_CAT_ATTRIBUTE11 | 11th category attribute of type 0 |
| CREATION_DATE | Standard WHO column |
| REQUEST_ID | Extended WHO column |
| PROGRAM_APPLICATION_ID | Extended WHO column |
| PROGRAM_ID | Extended WHO column |
| PROGRAM_UPDATE_DATE | Extended WHO column |
| TEXT_CAT_ATTRIBUTE12 | 12th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE13 | 13th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE14 | 14th category attribute of type 0 |
| LANGUAGE | Language |
| TEXT_CAT_ATTRIBUTE15 | 15th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE16 | 16th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE17 | 17th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE18 | 18th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE19 | 19th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE20 | 20th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE21 | 21th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE22 | 22th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE23 | 23th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE24 | 24th category attribute of type 0 |
| ORG_ID | Operating unit id |
| TEXT_CAT_ATTRIBUTE25 | 25th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE26 | 26th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE27 | 27th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE28 | 28th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE29 | 29th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE30 | 30th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE31 | 31th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE32 | 32th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE33 | 33th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE34 | 34th category attribute of type 0 |
| RT_CATEGORY_ID | Category id |
| TEXT_CAT_ATTRIBUTE35 | 35th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE36 | 36th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE37 | 37th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE38 | 38th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE39 | 39th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE40 | 40th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE41 | 41th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE42 | 42th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE43 | 43th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE44 | 44th category attribute of type 0 |
| PRIMARY_FLAG | Primary flag |
| TEXT_CAT_ATTRIBUTE45 | 45th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE46 | 46th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE47 | 47th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE48 | 48th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE49 | 49th category attribute of type 0 |
| TEXT_CAT_ATTRIBUTE50 | 50th category attribute of type 0 |
| NUM_CAT_ATTRIBUTE1 | 1st category attribute of type 1 |
| NUM_CAT_ATTRIBUTE2 | 2nd category attribute of type 1 |
| NUM_CAT_ATTRIBUTE3 | 3rd category attribute of type 1 |
| NUM_CAT_ATTRIBUTE4 | 4th category attribute of type 1 |
| TEXT_CAT_ATTRIBUTE1 | 1st category attribute of type 0 |
| NUM_CAT_ATTRIBUTE5 | 5th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE6 | 6th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE7 | 7th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE8 | 8th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE9 | 9th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE10 | 10th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE11 | 11th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE12 | 12th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE13 | 13th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE14 | 14th category attribute of type 1 |
| TEXT_CAT_ATTRIBUTE2 | 2nd category attribute of type 0 |
| NUM_CAT_ATTRIBUTE15 | 15th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE16 | 16th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE17 | 17th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE18 | 18th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE19 | 19th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE20 | 20th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE21 | 21th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE22 | 22th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE23 | 23th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE24 | 24th category attribute of type 1 |
| TEXT_CAT_ATTRIBUTE3 | 3rd category attribute of type 0 |
| NUM_CAT_ATTRIBUTE25 | 25th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE26 | 26th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE27 | 27th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE28 | 28th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE29 | 29th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE30 | 30th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE31 | 31th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE32 | 32th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE33 | 33th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE34 | 34th category attribute of type 1 |
| TEXT_CAT_ATTRIBUTE4 | 4th category attribute of type 0 |
| NUM_CAT_ATTRIBUTE35 | 35th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE36 | 36th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE37 | 37th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE38 | 38th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE39 | 39th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE40 | 40th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE41 | 41th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE42 | 42th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE43 | 43th category attribute of type 1 |
| NUM_CAT_ATTRIBUTE44 | 44th category attribute of type 1 |
| Oracle iProcurement - ICX_CAT_BROWSE_TREES | |
|---|---|
| Column Name | Descritpion |
| PARENT_CATEGORY_ID | |
| CHILD_CATEGORY_ID | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE |
| Oracle iProcurement - ICX_CAT_DESCRIPTORS_TL | |
|---|---|
| Column Name | Descritpion |
| RT_DESCRIPTOR_ID | |
| SEQUENCE | |
| KEY | |
| DEFAULTVALUE | |
| MULTI_VALUE_TYPE | |
| MULTI_VALUE_KEY | |
| REQUIRED | |
| REFINABLE | |
| SEARCHABLE | |
| CREATED_BY | |
| CREATION_DATE | |
| LANGUAGE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| REQUEST_ID | |
| PROGRAM_APPLICATION_ID | |
| PROGRAM_ID | |
| PROGRAM_UPDATE_DATE | |
| SEARCH_RESULTS_VISIBLE | |
| ITEM_DETAIL_VISIBLE | |
| VALIDATED | |
| SOURCE_LANG | |
| BATCH_JOB_NUM | |
| REBUILD_FLAG | |
| CLASS | |
| CUSTOMIZATION_LEVEL | |
| MULTIVALUE | |
| SECTION_TAG | |
| STORED_IN_TABLE | |
| STORED_IN_COLUMN | |
| TITLE | |
| DESCRIPTOR_NAME | |
| DESCRIPTION | |
| RT_CATEGORY_ID | |
| TYPE | |
| HIDDEN |
| Oracle iProcurement - ICX_CAT_DELETED_ATTRIBUTES | |
|---|---|
| Column Name | Descritpion |
| RT_CATEGORY_ID | |
| RT_DESCRIPTOR_ID | |
| STORED_IN_COLUMN | |
| STORED_IN_TABLE |
| Oracle iProcurement - ICX_CAT_CATEGORY_ITEMS | |
|---|---|
| Column Name | Descritpion |
| RT_CATEGORY_ID | |
| PROGRAM_ID | |
| PROGRAM_UPDATE_DATE | |
| RT_ITEM_ID | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE | |
| REQUEST_ID | |
| PROGRAM_APPLICATION_ID |
| Oracle iProcurement - ICX_CAT_ADV_SRCH_SETUP | |
|---|---|
| Column Name | Descritpion |
| RT_DESCRIPTOR_ID | |
| DEFAULT_FIELD_FLAG | |
| DISPLAY_SEQUENCE | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE |
| Oracle iProcurement - ICX_CAT_ITEMS_B | |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | |
| EXTRACTOR_UPDATED_FLAG | |
| REQUEST_ID | |
| CATALOG_NAME | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE | |
| PROGRAM_APPLICATION_ID | |
| PROGRAM_ID | |
| OBJECT_VERSION_NUMBER | |
| PROGRAM_UPDATE_DATE | |
| ORG_ID | |
| SUPPLIER_ID | |
| SUPPLIER | |
| SUPPLIER_PART_NUM | |
| SUPPLIER_PART_AUXID | |
| INTERNAL_ITEM_ID | |
| INTERNAL_ITEM_NUM |
| Oracle iProcurement - ICX_CAT_STORES_TL | |
|---|---|
| Column Name | Descritpion |
| STORE_ID | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| LANGUAGE | |
| SOURCE_LANG | |
| STORE_NAME | |
| SHORT_DESCRIPTION | |
| LONG_DESCRIPTION | |
| IMAGE_LOCATION | |
| CREATED_BY | |
| CREATION_DATE |
| Oracle iProcurement - ICX_CAT_STORES_B | |
|---|---|
| Column Name | Descritpion |
| STORE_ID | |
| SEQUENCE_NUMBER | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN |
| Oracle iProcurement - ICX_CAT_SCHEMA_VERSIONS | |
|---|---|
| Column Name | Descritpion |
| DESCRIPTOR_SET_ID | |
| VERSION | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE |
| Oracle iProcurement - ICX_CAT_PRICE_LISTS | |
|---|---|
| Column Name | Descritpion |
| PRICE_LIST_ID | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| REQUEST_ID | |
| BEGINDATE | |
| ENDDATE | |
| STATUS | |
| PUBLISHED_DATE | |
| OUTDATED_DATE | |
| APPROVAL_DATE | |
| REJECTED_DATE | |
| NAME | |
| DELETED_DATE | |
| BUYERCOMMENTS | |
| ACTION | |
| TYPE | |
| PARENT_HEADER_ID | |
| SUPPLIER_ID | |
| BUYER_ID | |
| DESCRIPTION | |
| CURRENCY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE |
| Oracle iProcurement - ICX_CAT_PRICE_HISTORY | |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | |
| TEMPLATE_ID | |
| TEMPLATE_LINE_ID | |
| MTL_CATEGORY_ID | |
| ORG_ID | |
| SEARCH_TYPE | |
| UNIT_PRICE | |
| CURRENCY | |
| UNIT_OF_MEASURE | |
| FUNCTIONAL_PRICE | |
| SUPPLIER_SITE_CODE | |
| STATUS | |
| CONTRACT_NUM | |
| CONTRACT_LINE_NUM | |
| PRICE_LIST_ID | |
| ARCHIVED_DATE | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE | |
| REQUEST_ID | |
| PRICE_TYPE | |
| PROGRAM_APPLICATION_ID | |
| PROGRAM_ID | |
| PROGRAM_UPDATE_DATE | |
| ACTIVE_FLAG | |
| OBJECT_VERSION_NUMBER | |
| ASL_ID | |
| SUPPLIER_SITE_ID | |
| CONTRACT_ID | |
| CONTRACT_LINE_ID |
| Oracle iProcurement - ICX_CAT_ITEM_SRC_DETAILS | |
|---|---|
| Column Name | Descritpion |
| INFO_ID | |
| LAST_UPDATE_LOGIN | |
| ITEM_SOURCE_ID | |
| SUPPLIER_ID | |
| NAME | |
| VALUE | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE |
| Oracle iProcurement - ICX_CAT_ITEM_PRICES | |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | |
| TEMPLATE_LINE_ID | |
| INVENTORY_ITEM_ID | |
| MTL_CATEGORY_ID | |
| ORG_ID | |
| SEARCH_TYPE | |
| UNIT_PRICE | |
| CURRENCY | |
| UNIT_OF_MEASURE | |
| FUNCTIONAL_PRICE | |
| SUPPLIER_SITE_CODE | |
| PRICE_TYPE | |
| CONTRACT_NUM | |
| CONTRACT_LINE_NUM | |
| PRICE_LIST_ID | |
| SUPPLIER_NUMBER | |
| SUPPLIER_CONTACT_ID | |
| ITEM_REVISION | |
| LINE_TYPE_ID | |
| BUYER_ID | |
| RATE_TYPE | |
| RATE_DATE | |
| ACTIVE_FLAG | |
| RATE | |
| LOCAL_RT_ITEM_ID | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE | |
| REQUEST_ID | |
| PROGRAM_APPLICATION_ID | |
| PROGRAM_ID | |
| PROGRAM_UPDATE_DATE | |
| OBJECT_VERSION_NUMBER | |
| ASL_ID | |
| SUPPLIER_SITE_ID | |
| CONTRACT_ID | |
| CONTRACT_LINE_ID | |
| TEMPLATE_ID |
| Oracle iProcurement - ICX_CAT_ITEMS_TLP | |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | |
| INTERNAL_ITEM_NUM | |
| TEXT_BASE_ATTRIBUTE71 | |
| TEXT_BASE_ATTRIBUTE72 | |
| TEXT_BASE_ATTRIBUTE73 | |
| TEXT_BASE_ATTRIBUTE74 | |
| TEXT_BASE_ATTRIBUTE75 | |
| TEXT_BASE_ATTRIBUTE76 | |
| TEXT_BASE_ATTRIBUTE77 | |
| TEXT_BASE_ATTRIBUTE78 | |
| TEXT_BASE_ATTRIBUTE79 | |
| TEXT_BASE_ATTRIBUTE80 | |
| SUPPLIER | |
| TEXT_BASE_ATTRIBUTE81 | |
| TEXT_BASE_ATTRIBUTE82 | |
| TEXT_BASE_ATTRIBUTE83 | |
| TEXT_BASE_ATTRIBUTE84 | |
| TEXT_BASE_ATTRIBUTE85 | |
| TEXT_BASE_ATTRIBUTE86 | |
| TEXT_BASE_ATTRIBUTE87 | |
| TEXT_BASE_ATTRIBUTE88 | |
| TEXT_BASE_ATTRIBUTE89 | |
| TEXT_BASE_ATTRIBUTE90 | |
| SUPPLIER_PART_NUM | |
| TEXT_BASE_ATTRIBUTE91 | |
| TEXT_BASE_ATTRIBUTE92 | |
| TEXT_BASE_ATTRIBUTE93 | |
| TEXT_BASE_ATTRIBUTE94 | |
| TEXT_BASE_ATTRIBUTE95 | |
| TEXT_BASE_ATTRIBUTE96 | |
| TEXT_BASE_ATTRIBUTE97 | |
| TEXT_BASE_ATTRIBUTE98 | |
| TEXT_BASE_ATTRIBUTE99 | |
| TEXT_BASE_ATTRIBUTE100 | |
| SUPPLIER_PART_AUXID | |
| NUM_BASE_ATTRIBUTE1 | |
| NUM_BASE_ATTRIBUTE2 | |
| NUM_BASE_ATTRIBUTE3 | |
| NUM_BASE_ATTRIBUTE4 | |
| NUM_BASE_ATTRIBUTE5 | |
| NUM_BASE_ATTRIBUTE6 | |
| NUM_BASE_ATTRIBUTE7 | |
| NUM_BASE_ATTRIBUTE8 | |
| NUM_BASE_ATTRIBUTE9 | |
| NUM_BASE_ATTRIBUTE10 | |
| MANUFACTURER | |
| NUM_BASE_ATTRIBUTE11 | |
| NUM_BASE_ATTRIBUTE12 | |
| NUM_BASE_ATTRIBUTE13 | |
| NUM_BASE_ATTRIBUTE14 | |
| NUM_BASE_ATTRIBUTE15 | |
| NUM_BASE_ATTRIBUTE16 | |
| NUM_BASE_ATTRIBUTE17 | |
| NUM_BASE_ATTRIBUTE18 | |
| NUM_BASE_ATTRIBUTE19 | |
| NUM_BASE_ATTRIBUTE20 | |
| MANUFACTURER_PART_NUM | |
| NUM_BASE_ATTRIBUTE21 | |
| NUM_BASE_ATTRIBUTE22 | |
| NUM_BASE_ATTRIBUTE23 | |
| NUM_BASE_ATTRIBUTE24 | |
| NUM_BASE_ATTRIBUTE25 | |
| NUM_BASE_ATTRIBUTE26 | |
| NUM_BASE_ATTRIBUTE27 | |
| NUM_BASE_ATTRIBUTE28 | |
| NUM_BASE_ATTRIBUTE29 | |
| NUM_BASE_ATTRIBUTE30 | |
| SUPPLIER_URL | |
| NUM_BASE_ATTRIBUTE31 | |
| NUM_BASE_ATTRIBUTE32 | |
| NUM_BASE_ATTRIBUTE33 | |
| NUM_BASE_ATTRIBUTE34 | |
| NUM_BASE_ATTRIBUTE35 | |
| NUM_BASE_ATTRIBUTE36 | |
| NUM_BASE_ATTRIBUTE37 | |
| NUM_BASE_ATTRIBUTE38 | |
| NUM_BASE_ATTRIBUTE39 | |
| NUM_BASE_ATTRIBUTE40 | |
| MANUFACTURER_URL | |
| NUM_BASE_ATTRIBUTE41 | |
| NUM_BASE_ATTRIBUTE42 | |
| NUM_BASE_ATTRIBUTE43 | |
| NUM_BASE_ATTRIBUTE44 | |
| NUM_BASE_ATTRIBUTE45 | |
| NUM_BASE_ATTRIBUTE46 | |
| NUM_BASE_ATTRIBUTE47 | |
| NUM_BASE_ATTRIBUTE48 | |
| NUM_BASE_ATTRIBUTE49 | |
| NUM_BASE_ATTRIBUTE50 | |
| DESCRIPTION | |
| NUM_BASE_ATTRIBUTE51 | |
| NUM_BASE_ATTRIBUTE52 | |
| NUM_BASE_ATTRIBUTE53 | |
| NUM_BASE_ATTRIBUTE54 | |
| NUM_BASE_ATTRIBUTE55 | |
| NUM_BASE_ATTRIBUTE56 | |
| NUM_BASE_ATTRIBUTE57 | |
| NUM_BASE_ATTRIBUTE58 | |
| NUM_BASE_ATTRIBUTE59 | |
| NUM_BASE_ATTRIBUTE60 | |
| COMMENTS | |
| NUM_BASE_ATTRIBUTE61 | |
| NUM_BASE_ATTRIBUTE62 | |
| NUM_BASE_ATTRIBUTE63 | |
| NUM_BASE_ATTRIBUTE64 | |
| NUM_BASE_ATTRIBUTE65 | |
| NUM_BASE_ATTRIBUTE66 | |
| NUM_BASE_ATTRIBUTE67 | |
| NUM_BASE_ATTRIBUTE68 | |
| NUM_BASE_ATTRIBUTE69 | |
| NUM_BASE_ATTRIBUTE70 | |
| LANGUAGE | |
| ALIAS | |
| NUM_BASE_ATTRIBUTE71 | |
| NUM_BASE_ATTRIBUTE72 | |
| NUM_BASE_ATTRIBUTE73 | |
| NUM_BASE_ATTRIBUTE74 | |
| NUM_BASE_ATTRIBUTE75 | |
| NUM_BASE_ATTRIBUTE76 | |
| NUM_BASE_ATTRIBUTE77 | |
| NUM_BASE_ATTRIBUTE78 | |
| NUM_BASE_ATTRIBUTE79 | |
| NUM_BASE_ATTRIBUTE80 | |
| PICTURE | |
| NUM_BASE_ATTRIBUTE81 | |
| NUM_BASE_ATTRIBUTE82 | |
| NUM_BASE_ATTRIBUTE83 | |
| NUM_BASE_ATTRIBUTE84 | |
| NUM_BASE_ATTRIBUTE85 | |
| NUM_BASE_ATTRIBUTE86 | |
| NUM_BASE_ATTRIBUTE87 | |
| NUM_BASE_ATTRIBUTE88 | |
| NUM_BASE_ATTRIBUTE89 | |
| NUM_BASE_ATTRIBUTE90 | |
| PICTURE_URL | |
| NUM_BASE_ATTRIBUTE91 | |
| NUM_BASE_ATTRIBUTE92 | |
| NUM_BASE_ATTRIBUTE93 | |
| NUM_BASE_ATTRIBUTE94 | |
| NUM_BASE_ATTRIBUTE95 | |
| NUM_BASE_ATTRIBUTE96 | |
| NUM_BASE_ATTRIBUTE97 | |
| NUM_BASE_ATTRIBUTE98 | |
| NUM_BASE_ATTRIBUTE99 | |
| NUM_BASE_ATTRIBUTE100 | |
| THUMBNAIL_IMAGE | |
| TL_TEXT_BASE_ATTRIBUTE1 | |
| TL_TEXT_BASE_ATTRIBUTE2 | |
| TL_TEXT_BASE_ATTRIBUTE3 | |
| TL_TEXT_BASE_ATTRIBUTE4 | |
| TL_TEXT_BASE_ATTRIBUTE5 | |
| TL_TEXT_BASE_ATTRIBUTE6 | |
| TL_TEXT_BASE_ATTRIBUTE7 | |
| TL_TEXT_BASE_ATTRIBUTE8 | |
| TL_TEXT_BASE_ATTRIBUTE9 | |
| TL_TEXT_BASE_ATTRIBUTE10 | |
| ATTACHMENT_URL | |
| TL_TEXT_BASE_ATTRIBUTE11 | |
| TL_TEXT_BASE_ATTRIBUTE12 | |
| TL_TEXT_BASE_ATTRIBUTE13 | |
| TL_TEXT_BASE_ATTRIBUTE14 | |
| TL_TEXT_BASE_ATTRIBUTE15 | |
| TL_TEXT_BASE_ATTRIBUTE16 | |
| TL_TEXT_BASE_ATTRIBUTE17 | |
| TL_TEXT_BASE_ATTRIBUTE18 | |
| TL_TEXT_BASE_ATTRIBUTE19 | |
| TL_TEXT_BASE_ATTRIBUTE20 | |
| LONG_DESCRIPTION | |
| TL_TEXT_BASE_ATTRIBUTE21 | |
| TL_TEXT_BASE_ATTRIBUTE22 | |
| TL_TEXT_BASE_ATTRIBUTE23 | |
| TL_TEXT_BASE_ATTRIBUTE24 | |
| TL_TEXT_BASE_ATTRIBUTE25 | |
| TL_TEXT_BASE_ATTRIBUTE26 | |
| TL_TEXT_BASE_ATTRIBUTE27 | |
| TL_TEXT_BASE_ATTRIBUTE28 | |
| TL_TEXT_BASE_ATTRIBUTE29 | |
| TL_TEXT_BASE_ATTRIBUTE30 | |
| UNSPSC_CODE | |
| TL_TEXT_BASE_ATTRIBUTE31 | |
| TL_TEXT_BASE_ATTRIBUTE32 | |
| TL_TEXT_BASE_ATTRIBUTE33 | |
| TL_TEXT_BASE_ATTRIBUTE34 | |
| TL_TEXT_BASE_ATTRIBUTE35 | |
| TL_TEXT_BASE_ATTRIBUTE36 | |
| TL_TEXT_BASE_ATTRIBUTE37 | |
| TL_TEXT_BASE_ATTRIBUTE38 | |
| TL_TEXT_BASE_ATTRIBUTE39 | |
| TL_TEXT_BASE_ATTRIBUTE40 | |
| AVAILABILITY | |
| TL_TEXT_BASE_ATTRIBUTE41 | |
| TL_TEXT_BASE_ATTRIBUTE42 | |
| TL_TEXT_BASE_ATTRIBUTE43 | |
| TL_TEXT_BASE_ATTRIBUTE44 | |
| TL_TEXT_BASE_ATTRIBUTE45 | |
| TL_TEXT_BASE_ATTRIBUTE46 | |
| TL_TEXT_BASE_ATTRIBUTE47 | |
| TL_TEXT_BASE_ATTRIBUTE48 | |
| TL_TEXT_BASE_ATTRIBUTE49 | |
| TL_TEXT_BASE_ATTRIBUTE50 | |
| LEAD_TIME | |
| TL_TEXT_BASE_ATTRIBUTE51 | |
| TL_TEXT_BASE_ATTRIBUTE52 | |
| TL_TEXT_BASE_ATTRIBUTE53 | |
| TL_TEXT_BASE_ATTRIBUTE54 | |
| TL_TEXT_BASE_ATTRIBUTE55 | |
| TL_TEXT_BASE_ATTRIBUTE56 | |
| TL_TEXT_BASE_ATTRIBUTE57 | |
| TL_TEXT_BASE_ATTRIBUTE58 | |
| TL_TEXT_BASE_ATTRIBUTE59 | |
| TL_TEXT_BASE_ATTRIBUTE60 | |
| ITEM_TYPE | |
| TL_TEXT_BASE_ATTRIBUTE61 | |
| TL_TEXT_BASE_ATTRIBUTE62 | |
| TL_TEXT_BASE_ATTRIBUTE63 | |
| TL_TEXT_BASE_ATTRIBUTE64 | |
| TL_TEXT_BASE_ATTRIBUTE65 | |
| TL_TEXT_BASE_ATTRIBUTE66 | |
| TL_TEXT_BASE_ATTRIBUTE67 | |
| TL_TEXT_BASE_ATTRIBUTE68 | |
| TL_TEXT_BASE_ATTRIBUTE69 | |
| TL_TEXT_BASE_ATTRIBUTE70 | |
| ORG_ID | |
| TEXT_BASE_ATTRIBUTE1 | |
| TL_TEXT_BASE_ATTRIBUTE71 | |
| TL_TEXT_BASE_ATTRIBUTE72 | |
| TL_TEXT_BASE_ATTRIBUTE73 | |
| TL_TEXT_BASE_ATTRIBUTE74 | |
| TL_TEXT_BASE_ATTRIBUTE75 | |
| TL_TEXT_BASE_ATTRIBUTE76 | |
| TL_TEXT_BASE_ATTRIBUTE77 | |
| TL_TEXT_BASE_ATTRIBUTE78 | |
| TL_TEXT_BASE_ATTRIBUTE79 | |
| TL_TEXT_BASE_ATTRIBUTE80 | |
| TEXT_BASE_ATTRIBUTE2 | |
| TL_TEXT_BASE_ATTRIBUTE81 | |
| TL_TEXT_BASE_ATTRIBUTE82 | |
| TL_TEXT_BASE_ATTRIBUTE83 | |
| TL_TEXT_BASE_ATTRIBUTE84 | |
| TL_TEXT_BASE_ATTRIBUTE85 | |
| TL_TEXT_BASE_ATTRIBUTE86 | |
| TL_TEXT_BASE_ATTRIBUTE87 | |
| TL_TEXT_BASE_ATTRIBUTE88 | |
| TL_TEXT_BASE_ATTRIBUTE89 | |
| TL_TEXT_BASE_ATTRIBUTE90 | |
| TEXT_BASE_ATTRIBUTE3 | |
| TL_TEXT_BASE_ATTRIBUTE91 | |
| TL_TEXT_BASE_ATTRIBUTE92 | |
| TL_TEXT_BASE_ATTRIBUTE93 | |
| TL_TEXT_BASE_ATTRIBUTE94 | |
| TL_TEXT_BASE_ATTRIBUTE95 | |
| TL_TEXT_BASE_ATTRIBUTE96 | |
| TL_TEXT_BASE_ATTRIBUTE97 | |
| TL_TEXT_BASE_ATTRIBUTE98 | |
| TL_TEXT_BASE_ATTRIBUTE99 | |
| TL_TEXT_BASE_ATTRIBUTE100 | |
| TEXT_BASE_ATTRIBUTE4 | |
| CTX_DESC | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE | |
| REQUEST_ID | |
| PROGRAM_APPLICATION_ID | |
| PROGRAM_ID | |
| PROGRAM_UPDATE_DATE | |
| TEXT_BASE_ATTRIBUTE5 | |
| TEXT_BASE_ATTRIBUTE6 | |
| TEXT_BASE_ATTRIBUTE7 | |
| TEXT_BASE_ATTRIBUTE8 | |
| TEXT_BASE_ATTRIBUTE9 | |
| TEXT_BASE_ATTRIBUTE10 | |
| SUPPLIER_ID | |
| TEXT_BASE_ATTRIBUTE11 | |
| TEXT_BASE_ATTRIBUTE12 | |
| TEXT_BASE_ATTRIBUTE13 | |
| TEXT_BASE_ATTRIBUTE14 | |
| TEXT_BASE_ATTRIBUTE15 | |
| TEXT_BASE_ATTRIBUTE16 | |
| TEXT_BASE_ATTRIBUTE17 | |
| TEXT_BASE_ATTRIBUTE18 | |
| TEXT_BASE_ATTRIBUTE19 | |
| TEXT_BASE_ATTRIBUTE20 | |
| ITEM_SOURCE_TYPE | |
| TEXT_BASE_ATTRIBUTE21 | |
| TEXT_BASE_ATTRIBUTE22 | |
| TEXT_BASE_ATTRIBUTE23 | |
| TEXT_BASE_ATTRIBUTE24 | |
| TEXT_BASE_ATTRIBUTE25 | |
| TEXT_BASE_ATTRIBUTE26 | |
| TEXT_BASE_ATTRIBUTE27 | |
| TEXT_BASE_ATTRIBUTE28 | |
| TEXT_BASE_ATTRIBUTE29 | |
| TEXT_BASE_ATTRIBUTE30 | |
| SEARCH_TYPE | |
| TEXT_BASE_ATTRIBUTE31 | |
| TEXT_BASE_ATTRIBUTE32 | |
| TEXT_BASE_ATTRIBUTE33 | |
| TEXT_BASE_ATTRIBUTE34 | |
| TEXT_BASE_ATTRIBUTE35 | |
| TEXT_BASE_ATTRIBUTE36 | |
| TEXT_BASE_ATTRIBUTE37 | |
| TEXT_BASE_ATTRIBUTE38 | |
| TEXT_BASE_ATTRIBUTE39 | |
| TEXT_BASE_ATTRIBUTE40 | |
| PRIMARY_CATEGORY_ID | |
| TEXT_BASE_ATTRIBUTE41 | |
| TEXT_BASE_ATTRIBUTE42 | |
| TEXT_BASE_ATTRIBUTE43 | |
| TEXT_BASE_ATTRIBUTE44 | |
| TEXT_BASE_ATTRIBUTE45 | |
| TEXT_BASE_ATTRIBUTE46 | |
| TEXT_BASE_ATTRIBUTE47 | |
| TEXT_BASE_ATTRIBUTE48 | |
| TEXT_BASE_ATTRIBUTE49 | |
| TEXT_BASE_ATTRIBUTE50 | |
| PRIMARY_CATEGORY_NAME | |
| TEXT_BASE_ATTRIBUTE51 | |
| TEXT_BASE_ATTRIBUTE52 | |
| TEXT_BASE_ATTRIBUTE53 | |
| TEXT_BASE_ATTRIBUTE54 | |
| TEXT_BASE_ATTRIBUTE55 | |
| TEXT_BASE_ATTRIBUTE56 | |
| TEXT_BASE_ATTRIBUTE57 | |
| TEXT_BASE_ATTRIBUTE58 | |
| TEXT_BASE_ATTRIBUTE59 | |
| TEXT_BASE_ATTRIBUTE60 | |
| INTERNAL_ITEM_ID | |
| TEXT_BASE_ATTRIBUTE61 | |
| TEXT_BASE_ATTRIBUTE62 | |
| TEXT_BASE_ATTRIBUTE63 | |
| TEXT_BASE_ATTRIBUTE64 | |
| TEXT_BASE_ATTRIBUTE65 | |
| TEXT_BASE_ATTRIBUTE66 | |
| TEXT_BASE_ATTRIBUTE67 | |
| TEXT_BASE_ATTRIBUTE68 | |
| TEXT_BASE_ATTRIBUTE69 | |
| TEXT_BASE_ATTRIBUTE70 |
| Oracle iProcurement - ICX_CAT_ITEMS_CTX_TLP | |
|---|---|
| Column Name | Descritpion |
| RT_ITEM_ID | |
| CREATION_DATE | |
| REQUEST_ID | |
| PROGRAM_APPLICATION_ID | |
| PROGRAM_ID | |
| PROGRAM_UPDATE_DATE | |
| LANGUAGE | |
| SEQUENCE | |
| CTX_DESC | |
| ORG_ID | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY |
| Oracle iProcurement - ICX_CAT_UPLOAD_PRICE_DUMP | |
|---|---|
| Column Name | Descritpion |
| LINE_NUMBER | |
| SUPPLIER | |
| SUPPLIER_PART_NUM | |
| SUPPLIER_PART_AUXID | |
| UNIT_PRICE | |
| CURRENCY | |
| UNIT_OF_MEASURE | |
| PRICE_LIST_NAME | |
| PRICE_LIST_ID | |
| BUYER_NAME | |
| ORG_ID | |
| ROW_TYPE | |
| SUPPLIER_SITE_ID | |
| SUPPLIER_SITE_CODE | |
| CONTRACT_NUM | |
| CONTRACT_ID | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| CREATION_DATE | |
| PROCESSED_FLAG | |
| LANGUAGE | |
| ACTION | |
| SYSTEM_ACTION | |
| ERROR_FLAG | |
| ERROR_MESSAGE | |
| SUPPLIER_ID |
| Oracle iProcurement - ICX_CAT_UPLOAD_IT_DUMP | |
|---|---|
| Column Name | Descritpion |
| LINE_NUMBER | |
| REQUIRED_TL_DESCRIPTORS | |
| TEXT_BASE_ATTRIBUTE63 | |
| TEXT_BASE_ATTRIBUTE64 | |
| TEXT_BASE_ATTRIBUTE65 | |
| TEXT_BASE_ATTRIBUTE66 | |
| TEXT_BASE_ATTRIBUTE67 | |
| TEXT_BASE_ATTRIBUTE68 | |
| TEXT_BASE_ATTRIBUTE69 | |
| TEXT_BASE_ATTRIBUTE70 | |
| TEXT_BASE_ATTRIBUTE71 | |
| TEXT_BASE_ATTRIBUTE72 | |
| HAS_CAT_ATTRIBUTE_FLAG | |
| TEXT_BASE_ATTRIBUTE73 | |
| TEXT_BASE_ATTRIBUTE74 | |
| TEXT_BASE_ATTRIBUTE75 | |
| TEXT_BASE_ATTRIBUTE76 | |
| TEXT_BASE_ATTRIBUTE77 | |
| TEXT_BASE_ATTRIBUTE78 | |
| TEXT_BASE_ATTRIBUTE79 | |
| TEXT_BASE_ATTRIBUTE80 | |
| TEXT_BASE_ATTRIBUTE81 | |
| TEXT_BASE_ATTRIBUTE82 | |
| RT_CATEGORY_ID | |
| TEXT_BASE_ATTRIBUTE83 | |
| TEXT_BASE_ATTRIBUTE84 | |
| TEXT_BASE_ATTRIBUTE85 | |
| TEXT_BASE_ATTRIBUTE86 | |
| TEXT_BASE_ATTRIBUTE87 | |
| TEXT_BASE_ATTRIBUTE88 | |
| TEXT_BASE_ATTRIBUTE89 | |
| TEXT_BASE_ATTRIBUTE90 | |
| TEXT_BASE_ATTRIBUTE91 | |
| TEXT_BASE_ATTRIBUTE92 | |
| CATEGORY_NAME | |
| TEXT_BASE_ATTRIBUTE93 | |
| TEXT_BASE_ATTRIBUTE94 | |
| TEXT_BASE_ATTRIBUTE95 | |
| TEXT_BASE_ATTRIBUTE96 | |
| TEXT_BASE_ATTRIBUTE97 | |
| TEXT_BASE_ATTRIBUTE98 | |
| TEXT_BASE_ATTRIBUTE99 | |
| TEXT_BASE_ATTRIBUTE100 | |
| NUM_BASE_ATTRIBUTE1 | |
| NUM_BASE_ATTRIBUTE2 | |
| ORG_ID | |
| NUM_BASE_ATTRIBUTE3 | |
| NUM_BASE_ATTRIBUTE4 | |
| NUM_BASE_ATTRIBUTE5 | |
| NUM_BASE_ATTRIBUTE6 | |
| NUM_BASE_ATTRIBUTE7 | |
| NUM_BASE_ATTRIBUTE8 | |
| NUM_BASE_ATTRIBUTE9 | |
| NUM_BASE_ATTRIBUTE10 | |
| NUM_BASE_ATTRIBUTE11 | |
| NUM_BASE_ATTRIBUTE12 | |
| INTERNAL_ITEM_NUM | |
| NUM_BASE_ATTRIBUTE13 | |
| NUM_BASE_ATTRIBUTE14 | |
| NUM_BASE_ATTRIBUTE15 | |
| NUM_BASE_ATTRIBUTE16 | |
| NUM_BASE_ATTRIBUTE17 | |
| NUM_BASE_ATTRIBUTE18 | |
| NUM_BASE_ATTRIBUTE19 | |
| NUM_BASE_ATTRIBUTE20 | |
| NUM_BASE_ATTRIBUTE21 | |
| NUM_BASE_ATTRIBUTE22 | |
| SUPPLIER_ID | |
| NUM_BASE_ATTRIBUTE23 | |
| NUM_BASE_ATTRIBUTE24 | |
| NUM_BASE_ATTRIBUTE25 | |
| NUM_BASE_ATTRIBUTE26 | |
| NUM_BASE_ATTRIBUTE27 | |
| NUM_BASE_ATTRIBUTE28 | |
| NUM_BASE_ATTRIBUTE29 | |
| NUM_BASE_ATTRIBUTE30 | |
| NUM_BASE_ATTRIBUTE31 | |
| NUM_BASE_ATTRIBUTE32 | |
| SUPPLIER | |
| NUM_BASE_ATTRIBUTE33 | |
| NUM_BASE_ATTRIBUTE34 | |
| NUM_BASE_ATTRIBUTE35 | |
| NUM_BASE_ATTRIBUTE36 | |
| NUM_BASE_ATTRIBUTE37 | |
| NUM_BASE_ATTRIBUTE38 | |
| NUM_BASE_ATTRIBUTE39 | |
| NUM_BASE_ATTRIBUTE40 | |
| NUM_BASE_ATTRIBUTE41 | |
| NUM_BASE_ATTRIBUTE42 | |
| SUPPLIER_PART_NUM | |
| NUM_BASE_ATTRIBUTE43 | |
| NUM_BASE_ATTRIBUTE44 | |
| NUM_BASE_ATTRIBUTE45 | |
| NUM_BASE_ATTRIBUTE46 | |
| NUM_BASE_ATTRIBUTE47 | |
| NUM_BASE_ATTRIBUTE48 | |
| NUM_BASE_ATTRIBUTE49 | |
| NUM_BASE_ATTRIBUTE50 | |
| NUM_BASE_ATTRIBUTE51 | |
| NUM_BASE_ATTRIBUTE52 | |
| SUPPLIER_PART_AUXID | |
| NUM_BASE_ATTRIBUTE53 | |
| NUM_BASE_ATTRIBUTE54 | |
| NUM_BASE_ATTRIBUTE55 | |
| NUM_BASE_ATTRIBUTE56 | |
| NUM_BASE_ATTRIBUTE57 | |
| NUM_BASE_ATTRIBUTE58 | |
| NUM_BASE_ATTRIBUTE59 | |
| NUM_BASE_ATTRIBUTE60 | |
| NUM_BASE_ATTRIBUTE61 | |
| NUM_BASE_ATTRIBUTE62 | |
| ROW_TYPE | |
| MANUFACTURER | |
| NUM_BASE_ATTRIBUTE63 | |
| NUM_BASE_ATTRIBUTE64 | |
| NUM_BASE_ATTRIBUTE65 | |
| NUM_BASE_ATTRIBUTE66 | |
| NUM_BASE_ATTRIBUTE67 | |
| NUM_BASE_ATTRIBUTE68 | |
| NUM_BASE_ATTRIBUTE69 | |
| NUM_BASE_ATTRIBUTE70 | |
| NUM_BASE_ATTRIBUTE71 | |
| NUM_BASE_ATTRIBUTE72 | |
| MANUFACTURER_PART_NUM | |
| NUM_BASE_ATTRIBUTE73 | |
| NUM_BASE_ATTRIBUTE74 | |
| NUM_BASE_ATTRIBUTE75 | |
| NUM_BASE_ATTRIBUTE76 | |
| NUM_BASE_ATTRIBUTE77 | |
| NUM_BASE_ATTRIBUTE78 | |
| NUM_BASE_ATTRIBUTE79 | |
| NUM_BASE_ATTRIBUTE80 | |
| NUM_BASE_ATTRIBUTE81 | |
| NUM_BASE_ATTRIBUTE82 | |
| DESCRIPTION | |
| NUM_BASE_ATTRIBUTE83 | |
| NUM_BASE_ATTRIBUTE84 | |
| NUM_BASE_ATTRIBUTE85 | |
| NUM_BASE_ATTRIBUTE86 | |
| NUM_BASE_ATTRIBUTE87 | |
| NUM_BASE_ATTRIBUTE88 | |
| NUM_BASE_ATTRIBUTE89 | |
| NUM_BASE_ATTRIBUTE90 | |
| NUM_BASE_ATTRIBUTE91 | |
| NUM_BASE_ATTRIBUTE92 | |
| COMMENTS | |
| NUM_BASE_ATTRIBUTE93 | |
| NUM_BASE_ATTRIBUTE94 | |
| NUM_BASE_ATTRIBUTE95 | |
| NUM_BASE_ATTRIBUTE96 | |
| NUM_BASE_ATTRIBUTE97 | |
| NUM_BASE_ATTRIBUTE98 | |
| NUM_BASE_ATTRIBUTE99 | |
| NUM_BASE_ATTRIBUTE100 | |
| TL_TEXT_BASE_ATTRIBUTE1 | |
| TL_TEXT_BASE_ATTRIBUTE2 | |
| ALIAS | |
| TL_TEXT_BASE_ATTRIBUTE3 | |
| TL_TEXT_BASE_ATTRIBUTE4 | |
| TL_TEXT_BASE_ATTRIBUTE5 | |
| TL_TEXT_BASE_ATTRIBUTE6 | |
| TL_TEXT_BASE_ATTRIBUTE7 | |
| TL_TEXT_BASE_ATTRIBUTE8 | |
| TL_TEXT_BASE_ATTRIBUTE9 | |
| TL_TEXT_BASE_ATTRIBUTE10 | |
| TL_TEXT_BASE_ATTRIBUTE11 | |
| TL_TEXT_BASE_ATTRIBUTE12 | |
| PICTURE | |
| TL_TEXT_BASE_ATTRIBUTE13 | |
| TL_TEXT_BASE_ATTRIBUTE14 | |
| TL_TEXT_BASE_ATTRIBUTE15 | |
| TL_TEXT_BASE_ATTRIBUTE16 | |
| TL_TEXT_BASE_ATTRIBUTE17 | |
| TL_TEXT_BASE_ATTRIBUTE18 | |
| TL_TEXT_BASE_ATTRIBUTE19 | |
| TL_TEXT_BASE_ATTRIBUTE20 | |
| TL_TEXT_BASE_ATTRIBUTE21 | |
| TL_TEXT_BASE_ATTRIBUTE22 | |
| PICTURE_URL | |
| TL_TEXT_BASE_ATTRIBUTE23 | |
| TL_TEXT_BASE_ATTRIBUTE24 | |
| TL_TEXT_BASE_ATTRIBUTE25 | |
| TL_TEXT_BASE_ATTRIBUTE26 | |
| TL_TEXT_BASE_ATTRIBUTE27 | |
| TL_TEXT_BASE_ATTRIBUTE28 | |
| TL_TEXT_BASE_ATTRIBUTE29 | |
| TL_TEXT_BASE_ATTRIBUTE30 | |
| TL_TEXT_BASE_ATTRIBUTE31 | |
| TL_TEXT_BASE_ATTRIBUTE32 | |
| THUMBNAIL_IMAGE | |
| TL_TEXT_BASE_ATTRIBUTE33 | |
| TL_TEXT_BASE_ATTRIBUTE34 | |
| TL_TEXT_BASE_ATTRIBUTE35 | |
| TL_TEXT_BASE_ATTRIBUTE36 | |
| TL_TEXT_BASE_ATTRIBUTE37 | |
| TL_TEXT_BASE_ATTRIBUTE38 | |
| TL_TEXT_BASE_ATTRIBUTE39 | |
| TL_TEXT_BASE_ATTRIBUTE40 | |
| TL_TEXT_BASE_ATTRIBUTE41 | |
| TL_TEXT_BASE_ATTRIBUTE42 | |
| ATTACHMENT_URL | |
| TL_TEXT_BASE_ATTRIBUTE43 | |
| TL_TEXT_BASE_ATTRIBUTE44 | |
| TL_TEXT_BASE_ATTRIBUTE45 | |
| TL_TEXT_BASE_ATTRIBUTE46 | |
| TL_TEXT_BASE_ATTRIBUTE47 | |
| TL_TEXT_BASE_ATTRIBUTE48 | |
| TL_TEXT_BASE_ATTRIBUTE49 | |
| TL_TEXT_BASE_ATTRIBUTE50 | |
| TL_TEXT_BASE_ATTRIBUTE51 | |
| TL_TEXT_BASE_ATTRIBUTE52 | |
| SUPPLIER_URL | |
| TL_TEXT_BASE_ATTRIBUTE53 | |
| TL_TEXT_BASE_ATTRIBUTE54 | |
| TL_TEXT_BASE_ATTRIBUTE55 | |
| TL_TEXT_BASE_ATTRIBUTE56 | |
| TL_TEXT_BASE_ATTRIBUTE57 | |
| TL_TEXT_BASE_ATTRIBUTE58 | |
| TL_TEXT_BASE_ATTRIBUTE59 | |
| TL_TEXT_BASE_ATTRIBUTE60 | |
| TL_TEXT_BASE_ATTRIBUTE61 | |
| TL_TEXT_BASE_ATTRIBUTE62 | |
| PROCESSED_FLAG | |
| MANUFACTURER_URL | |
| TL_TEXT_BASE_ATTRIBUTE63 | |
| TL_TEXT_BASE_ATTRIBUTE64 | |
| TL_TEXT_BASE_ATTRIBUTE65 | |
| TL_TEXT_BASE_ATTRIBUTE66 | |
| TL_TEXT_BASE_ATTRIBUTE67 | |
| TL_TEXT_BASE_ATTRIBUTE68 | |
| TL_TEXT_BASE_ATTRIBUTE69 | |
| TL_TEXT_BASE_ATTRIBUTE70 | |
| TL_TEXT_BASE_ATTRIBUTE71 | |
| TL_TEXT_BASE_ATTRIBUTE72 | |
| LONG_DESCRIPTION | |
| TL_TEXT_BASE_ATTRIBUTE73 | |
| TL_TEXT_BASE_ATTRIBUTE74 | |
| TL_TEXT_BASE_ATTRIBUTE75 | |
| TL_TEXT_BASE_ATTRIBUTE76 | |
| TL_TEXT_BASE_ATTRIBUTE77 | |
| TL_TEXT_BASE_ATTRIBUTE78 | |
| TL_TEXT_BASE_ATTRIBUTE79 | |
| TL_TEXT_BASE_ATTRIBUTE80 | |
| TL_TEXT_BASE_ATTRIBUTE81 | |
| TL_TEXT_BASE_ATTRIBUTE82 | |
| UNSPSC_CODE | |
| TL_TEXT_BASE_ATTRIBUTE83 | |
| TL_TEXT_BASE_ATTRIBUTE84 | |
| TL_TEXT_BASE_ATTRIBUTE85 | |
| TL_TEXT_BASE_ATTRIBUTE86 | |
| TL_TEXT_BASE_ATTRIBUTE87 | |
| TL_TEXT_BASE_ATTRIBUTE88 | |
| TL_TEXT_BASE_ATTRIBUTE89 | |
| TL_TEXT_BASE_ATTRIBUTE90 | |
| TL_TEXT_BASE_ATTRIBUTE91 | |
| TL_TEXT_BASE_ATTRIBUTE92 | |
| AVAILABILITY | |
| TL_TEXT_BASE_ATTRIBUTE93 | |
| TL_TEXT_BASE_ATTRIBUTE94 | |
| TL_TEXT_BASE_ATTRIBUTE95 | |
| TL_TEXT_BASE_ATTRIBUTE96 | |
| TL_TEXT_BASE_ATTRIBUTE97 | |
| TL_TEXT_BASE_ATTRIBUTE98 | |
| TL_TEXT_BASE_ATTRIBUTE99 | |
| TL_TEXT_BASE_ATTRIBUTE100 | |
| TEXT_CAT_ATTRIBUTE1 | |
| TEXT_CAT_ATTRIBUTE2 | |
| LEAD_TIME | |
| TEXT_CAT_ATTRIBUTE3 | |
| TEXT_CAT_ATTRIBUTE4 | |
| TEXT_CAT_ATTRIBUTE5 | |
| TEXT_CAT_ATTRIBUTE6 | |
| TEXT_CAT_ATTRIBUTE7 | |
| TEXT_CAT_ATTRIBUTE8 | |
| TEXT_CAT_ATTRIBUTE9 | |
| TEXT_CAT_ATTRIBUTE10 | |
| TEXT_CAT_ATTRIBUTE11 | |
| TEXT_CAT_ATTRIBUTE12 | |
| ITEM_TYPE | |
| TEXT_CAT_ATTRIBUTE13 | |
| TEXT_CAT_ATTRIBUTE14 | |
| TEXT_CAT_ATTRIBUTE15 | |
| TEXT_CAT_ATTRIBUTE16 | |
| TEXT_CAT_ATTRIBUTE17 | |
| TEXT_CAT_ATTRIBUTE18 | |
| TEXT_CAT_ATTRIBUTE19 | |
| TEXT_CAT_ATTRIBUTE20 | |
| TEXT_CAT_ATTRIBUTE21 | |
| TEXT_CAT_ATTRIBUTE22 | |
| CONTRACT_NUM | |
| TEXT_CAT_ATTRIBUTE23 | |
| TEXT_CAT_ATTRIBUTE24 | |
| TEXT_CAT_ATTRIBUTE25 | |
| TEXT_CAT_ATTRIBUTE26 | |
| TEXT_CAT_ATTRIBUTE27 | |
| TEXT_CAT_ATTRIBUTE28 | |
| TEXT_CAT_ATTRIBUTE29 | |
| TEXT_CAT_ATTRIBUTE30 | |
| TEXT_CAT_ATTRIBUTE31 | |
| TEXT_CAT_ATTRIBUTE32 | |
| CONTRACT_ID | |
| TEXT_CAT_ATTRIBUTE33 | |
| TEXT_CAT_ATTRIBUTE34 | |
| TEXT_CAT_ATTRIBUTE35 | |
| TEXT_CAT_ATTRIBUTE36 | |
| TEXT_CAT_ATTRIBUTE37 | |
| TEXT_CAT_ATTRIBUTE38 | |
| TEXT_CAT_ATTRIBUTE39 | |
| TEXT_CAT_ATTRIBUTE40 | |
| TEXT_CAT_ATTRIBUTE41 | |
| TEXT_CAT_ATTRIBUTE42 | |
| TEXT_BASE_ATTRIBUTE1 | |
| TEXT_CAT_ATTRIBUTE43 | |
| TEXT_CAT_ATTRIBUTE44 | |
| TEXT_CAT_ATTRIBUTE45 | |
| TEXT_CAT_ATTRIBUTE46 | |
| TEXT_CAT_ATTRIBUTE47 | |
| TEXT_CAT_ATTRIBUTE48 | |
| TEXT_CAT_ATTRIBUTE49 | |
| TEXT_CAT_ATTRIBUTE50 | |
| NUM_CAT_ATTRIBUTE1 | |
| NUM_CAT_ATTRIBUTE2 | |
| TEXT_BASE_ATTRIBUTE2 | |
| NUM_CAT_ATTRIBUTE3 | |
| NUM_CAT_ATTRIBUTE4 | |
| NUM_CAT_ATTRIBUTE5 | |
| NUM_CAT_ATTRIBUTE6 | |
| NUM_CAT_ATTRIBUTE7 | |
| NUM_CAT_ATTRIBUTE8 | |
| NUM_CAT_ATTRIBUTE9 | |
| NUM_CAT_ATTRIBUTE10 | |
| NUM_CAT_ATTRIBUTE11 | |
| NUM_CAT_ATTRIBUTE12 | |
| LANGUAGE | |
| TEXT_BASE_ATTRIBUTE3 | |
| NUM_CAT_ATTRIBUTE13 | |
| NUM_CAT_ATTRIBUTE14 | |
| NUM_CAT_ATTRIBUTE15 | |
| NUM_CAT_ATTRIBUTE16 | |
| NUM_CAT_ATTRIBUTE17 | |
| NUM_CAT_ATTRIBUTE18 | |
| NUM_CAT_ATTRIBUTE19 | |
| NUM_CAT_ATTRIBUTE20 | |
| NUM_CAT_ATTRIBUTE21 | |
| NUM_CAT_ATTRIBUTE22 | |
| TEXT_BASE_ATTRIBUTE4 | |
| NUM_CAT_ATTRIBUTE23 | |
| NUM_CAT_ATTRIBUTE24 | |
| NUM_CAT_ATTRIBUTE25 | |
| NUM_CAT_ATTRIBUTE26 | |
| NUM_CAT_ATTRIBUTE27 | |
| NUM_CAT_ATTRIBUTE28 | |
| NUM_CAT_ATTRIBUTE29 | |
| NUM_CAT_ATTRIBUTE30 | |
| NUM_CAT_ATTRIBUTE31 | |
| NUM_CAT_ATTRIBUTE32 | |
| TEXT_BASE_ATTRIBUTE5 | |
| NUM_CAT_ATTRIBUTE33 | |
| NUM_CAT_ATTRIBUTE34 | |
| NUM_CAT_ATTRIBUTE35 | |
| NUM_CAT_ATTRIBUTE36 | |
| NUM_CAT_ATTRIBUTE37 | |
| NUM_CAT_ATTRIBUTE38 | |
| NUM_CAT_ATTRIBUTE39 | |
| NUM_CAT_ATTRIBUTE40 | |
| NUM_CAT_ATTRIBUTE41 | |
| NUM_CAT_ATTRIBUTE42 | |
| TEXT_BASE_ATTRIBUTE6 | |
| NUM_CAT_ATTRIBUTE43 | |
| NUM_CAT_ATTRIBUTE44 | |
| NUM_CAT_ATTRIBUTE45 | |
| NUM_CAT_ATTRIBUTE46 | |
| NUM_CAT_ATTRIBUTE47 | |
| NUM_CAT_ATTRIBUTE48 | |
| NUM_CAT_ATTRIBUTE49 | |
| NUM_CAT_ATTRIBUTE50 | |
| TL_TEXT_CAT_ATTRIBUTE1 | |
| TL_TEXT_CAT_ATTRIBUTE2 | |
| TEXT_BASE_ATTRIBUTE7 | |
| TL_TEXT_CAT_ATTRIBUTE3 | |
| TL_TEXT_CAT_ATTRIBUTE4 | |
| TL_TEXT_CAT_ATTRIBUTE5 | |
| TL_TEXT_CAT_ATTRIBUTE6 | |
| TL_TEXT_CAT_ATTRIBUTE7 | |
| TL_TEXT_CAT_ATTRIBUTE8 | |
| TL_TEXT_CAT_ATTRIBUTE9 | |
| TL_TEXT_CAT_ATTRIBUTE10 | |
| TL_TEXT_CAT_ATTRIBUTE11 | |
| TL_TEXT_CAT_ATTRIBUTE12 | |
| TEXT_BASE_ATTRIBUTE8 | |
| TL_TEXT_CAT_ATTRIBUTE13 | |
| TL_TEXT_CAT_ATTRIBUTE14 | |
| TL_TEXT_CAT_ATTRIBUTE15 | |
| TL_TEXT_CAT_ATTRIBUTE16 | |
| TL_TEXT_CAT_ATTRIBUTE17 | |
| TL_TEXT_CAT_ATTRIBUTE18 | |
| TL_TEXT_CAT_ATTRIBUTE19 | |
| TL_TEXT_CAT_ATTRIBUTE20 | |
| TL_TEXT_CAT_ATTRIBUTE21 | |
| TL_TEXT_CAT_ATTRIBUTE22 | |
| TEXT_BASE_ATTRIBUTE9 | |
| TL_TEXT_CAT_ATTRIBUTE23 | |
| TL_TEXT_CAT_ATTRIBUTE24 | |
| TL_TEXT_CAT_ATTRIBUTE25 | |
| TL_TEXT_CAT_ATTRIBUTE26 | |
| TL_TEXT_CAT_ATTRIBUTE27 | |
| TL_TEXT_CAT_ATTRIBUTE28 | |
| TL_TEXT_CAT_ATTRIBUTE29 | |
| TL_TEXT_CAT_ATTRIBUTE30 | |
| TL_TEXT_CAT_ATTRIBUTE31 | |
| TL_TEXT_CAT_ATTRIBUTE32 | |
| TEXT_BASE_ATTRIBUTE10 | |
| TL_TEXT_CAT_ATTRIBUTE33 | |
| TL_TEXT_CAT_ATTRIBUTE34 | |
| TL_TEXT_CAT_ATTRIBUTE35 | |
| TL_TEXT_CAT_ATTRIBUTE36 | |
| TL_TEXT_CAT_ATTRIBUTE37 | |
| TL_TEXT_CAT_ATTRIBUTE38 | |
| TL_TEXT_CAT_ATTRIBUTE39 | |
| TL_TEXT_CAT_ATTRIBUTE40 | |
| TL_TEXT_CAT_ATTRIBUTE41 | |
| TL_TEXT_CAT_ATTRIBUTE42 | |
| TEXT_BASE_ATTRIBUTE11 | |
| TL_TEXT_CAT_ATTRIBUTE43 | |
| TL_TEXT_CAT_ATTRIBUTE44 | |
| TL_TEXT_CAT_ATTRIBUTE45 | |
| TL_TEXT_CAT_ATTRIBUTE46 | |
| TL_TEXT_CAT_ATTRIBUTE47 | |
| TL_TEXT_CAT_ATTRIBUTE48 | |
| TL_TEXT_CAT_ATTRIBUTE49 | |
| TL_TEXT_CAT_ATTRIBUTE50 | |
| UNIT_PRICE | |
| CURRENCY | |
| TEXT_BASE_ATTRIBUTE12 | |
| UNIT_OF_MEASURE | |
| SUPPLIER_SITE_ID | |
| SUPPLIER_SITE_CODE | |
| PRICE_LIST_NAME | |
| PRICE_LIST_ID | |
| BUYER_NAME | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| CREATED_BY | |
| ACTION | |
| TEXT_BASE_ATTRIBUTE13 | |
| CREATION_DATE | |
| TEXT_BASE_ATTRIBUTE14 | |
| TEXT_BASE_ATTRIBUTE15 | |
| TEXT_BASE_ATTRIBUTE16 | |
| TEXT_BASE_ATTRIBUTE17 | |
| TEXT_BASE_ATTRIBUTE18 | |
| TEXT_BASE_ATTRIBUTE19 | |
| TEXT_BASE_ATTRIBUTE20 | |
| TEXT_BASE_ATTRIBUTE21 | |
| TEXT_BASE_ATTRIBUTE22 | |
| SYSTEM_ACTION | |
| TEXT_BASE_ATTRIBUTE23 | |
| TEXT_BASE_ATTRIBUTE24 | |
| TEXT_BASE_ATTRIBUTE25 | |
| TEXT_BASE_ATTRIBUTE26 | |
| TEXT_BASE_ATTRIBUTE27 | |
| TEXT_BASE_ATTRIBUTE28 | |
| TEXT_BASE_ATTRIBUTE29 | |
| TEXT_BASE_ATTRIBUTE30 | |
| TEXT_BASE_ATTRIBUTE31 | |
| TEXT_BASE_ATTRIBUTE32 | |
| ERROR_FLAG | |
| TEXT_BASE_ATTRIBUTE33 | |
| TEXT_BASE_ATTRIBUTE34 | |
| TEXT_BASE_ATTRIBUTE35 | |
| TEXT_BASE_ATTRIBUTE36 | |
| TEXT_BASE_ATTRIBUTE37 | |
| TEXT_BASE_ATTRIBUTE38 | |
| TEXT_BASE_ATTRIBUTE39 | |
| TEXT_BASE_ATTRIBUTE40 | |
| TEXT_BASE_ATTRIBUTE41 | |
| TEXT_BASE_ATTRIBUTE42 | |
| ERROR_MESSAGE | |
| TEXT_BASE_ATTRIBUTE43 | |
| TEXT_BASE_ATTRIBUTE44 | |
| TEXT_BASE_ATTRIBUTE45 | |
| TEXT_BASE_ATTRIBUTE46 | |
| TEXT_BASE_ATTRIBUTE47 | |
| TEXT_BASE_ATTRIBUTE48 | |
| TEXT_BASE_ATTRIBUTE49 | |
| TEXT_BASE_ATTRIBUTE50 | |
| TEXT_BASE_ATTRIBUTE51 | |
| TEXT_BASE_ATTRIBUTE52 | |
| REQUIRED_DESCRIPTORS | |
| TEXT_BASE_ATTRIBUTE53 | |
| TEXT_BASE_ATTRIBUTE54 | |
| TEXT_BASE_ATTRIBUTE55 | |
| TEXT_BASE_ATTRIBUTE56 | |
| TEXT_BASE_ATTRIBUTE57 | |
| TEXT_BASE_ATTRIBUTE58 | |
| TEXT_BASE_ATTRIBUTE59 | |
| TEXT_BASE_ATTRIBUTE60 | |
| TEXT_BASE_ATTRIBUTE61 | |
| TEXT_BASE_ATTRIBUTE62 |
| Oracle iProcurement - ICX_CAT_STORE_CATALOGS | |
|---|---|
| Column Name | Descritpion |
| STORE_ID | |
| ITEM_SOURCE_ID | |
| SEQUENCE_NUMBER | |
| DISPLAY_ALWAYS_FLAG | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN |
| Oracle iProcurement - ICX_ENABLED_PLSQL | |
|---|---|
| Column Name | Descritpion |
| PLSQL_TYPE | |
| PLSQL_NAME | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_LOGIN | |
| APPLICATION_ID | |
| ENABLED |
| Oracle iProcurement - ICX_CAT_POPULATE_CTX_GT | |
|---|---|
| Column Name | Descritpion |
| INVENTORY_ITEM_ID | |
| IP_CATEGORY_ID | |
| IP_CATEGORY_NAME | |
| IP_CATEGORY_KEY | |
| PO_CATEGORY_ID | |
| PO_CATEGORY_NAME | |
| SUPPLIER_ID | |
| SUPPLIER_PART_NUM | |
| SUPPLIER_PART_AUXID | |
| SUPPLIER_SITE_ID | |
| STATUS | |
| PO_LINE_ID | |
| OWNING_ORG_ID | |
| CTX_SUPPLIER_PART_NUM | |
| CTX_SUPPLIER_PART_AUXID | |
| CTX_IP_CATEGORY_ID | |
| CTX_PO_CATEGORY_ID | |
| CTX_ROWID | |
| PROCESSED_FLAG | |
| REQ_TEMPLATE_NAME | |
| REQ_TEMPLATE_LINE_NUM | |
| ASL_ID | |
| ORG_ID | |
| LANGUAGE | |
| SOURCE_TYPE | |
| PURCHASING_ORG_ID |
| Oracle iProcurement - POR_TEMPLATE_INFO | Self-Service Purchasing Information Template Data |
|---|---|
| Column Name | Descritpion |
| REQUISITION_LINE_ID | Requisition line identifier |
| ATTRIBUTE1 | Descriptive Flexfield segment |
| ATTRIBUTE2 | Descriptive Flexfield segment |
| ATTRIBUTE3 | Descriptive Flexfield segment |
| ATTRIBUTE4 | Descriptive Flexfield segment |
| ATTRIBUTE5 | Descriptive Flexfield segment |
| ATTRIBUTE6 | Descriptive Flexfield segment |
| ATTRIBUTE7 | Descriptive Flexfield segment |
| ATTRIBUTE8 | Descriptive Flexfield segment |
| ATTRIBUTE9 | Descriptive Flexfield segment |
| ATTRIBUTE10 | Descriptive Flexfield segment |
| ATTRIBUTE_CODE | Ak attribute code |
| ATTRIBUTE11 | Descriptive Flexfield segment |
| ATTRIBUTE12 | Descriptive Flexfield segment |
| ATTRIBUTE13 | Descriptive Flexfield segment |
| ATTRIBUTE14 | Descriptive Flexfield segment |
| ATTRIBUTE15 | Descriptive Flexfield segment |
| ATTRIBUTE_LABEL_LONG | Long label ak attribute |
| ATTRIBUTE_VALUE | Ak attribute value |
| 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 |
| Oracle iProcurement - POS_ACK_SELECT | |
|---|---|
| Column Name | Descritpion |
| ROW_NUM | |
| PO_NUMBER | |
| RELEASE_NUMBER | |
| REVISION_NUMBER | |
| DOCUMENT_TYPE_CODE | |
| DOCUMENT_TYPE | |
| CURRENCY_CODE | |
| TOTAL | |
| ACCEPTANCE_REQUIRED | |
| ACCEPTANCE_STATUS | |
| ACCEPTANCE_REQUIRED_BY | |
| ACCEPTANCE_FLAG | |
| APPROVAL_STATUS | |
| SHIPTO_LOCATION_ID | |
| SHIPTO_LOCATION | |
| CARRIER_CODE | |
| CARRIER | |
| BUYER_ID | |
| BUYER_NAME | |
| SUPPLIER_ORG_ID | |
| SUPPLIER_ID | |
| SUPPLIER_NAME | |
| ACCEPT | |
| SUPPLIER_SITE_ID | |
| SUPPLIER_SITE | |
| REJECT | |
| ACCEPTANCE_TYPE_CODE | |
| ACCEPTANCE_TYPE | |
| COMMENTS | |
| PO_HEADER_ID | |
| PO_RELEASE_ID |
| Oracle iProcurement - POS_ASN_SEARCH_RESULT | |
|---|---|
| Column Name | Descritpion |
| SESSION_ID | |
| SHIP_TO_LOCATION_CODE | |
| SUPPLIER_ITEM_NUMBER | |
| ITEM_DESCRIPTION | |
| QUANTITY_ORDERED | |
| UNIT_OF_MEASURE_CODE | |
| DUE_DATE | |
| SUPPLIER_ID | |
| SUPPLIER_NAME | |
| SUPPLIER_SITE_ID | |
| SUPPLIER_SITE_CODE | |
| PO_HEADER_ID | |
| SHIP_TO_ORGANIZATION_ID | |
| SHIP_TO_ORGANIZATION_CODE | |
| SHIP_TO_ORGANIZATION_NAME | |
| ITEM_ID | |
| ITEM_NUMBER | |
| ITEM_REVISION | |
| CATEGORY_ID | |
| CATEGORY | |
| PO_NUMBER | |
| PO_RELEASE_ID | |
| PO_LINE_ID | |
| LINE_NUMBER | |
| PO_SHIPMENT_ID | |
| SHIPMENT_NUMBER | |
| SHIP_TO_LOCATION_ID |
| Oracle iProcurement - POS_ASN_SHOP_CART_DETAILS | |
|---|---|
| Column Name | Descritpion |
| SESSION_ID | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| CREATION_DATE | |
| CREATED_BY | |
| ITEM_ID | |
| EXPECTED_RECEIPT_DATE | |
| COMMENTS | |
| WAYBILL_AIRBILL_NUM | |
| BARCODE_LABEL | |
| ASN_LINE_ID | |
| BILL_OF_LADING | |
| CONTAINER_NUM | |
| COUNTRY_OF_ORIGIN_CODE | |
| VENDOR_CUM_SHIPPED_QTY | |
| FREIGHT_CARRIER_CODE | |
| VENDOR_LOT_NUM | |
| TRUCK_NUM | |
| NUM_OF_CONTAINERS | |
| PACKING_SLIP | |
| REASON_ID | |
| PO_HEADER_ID | |
| ACTUAL_COST | |
| TRANSFER_COST | |
| TRANSPORTATION_COST | |
| RMA_REFERENCE | |
| TRANSPORTATION_ACCOUNT_ID | |
| QUANTITY_INVOICED | |
| NOTICE_UNIT_PRICE | |
| UNIT_PRICE | |
| EXTENDED_PRICE | |
| TAX_NAME | |
| PO_LINE_ID | |
| TAX_AMOUNT | |
| CURRENCY_CODE | |
| CURRENCY_CONVERSION_TYPE | |
| CURRENCY_CONVERSION_RATE | |
| CURRENCY_CONVERSION_DATE | |
| ATTRIBUTE_CATEGORY | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| PO_LINE_LOCATION_ID | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| SHIP_TO_ORGANIZATION_ID | |
| ATTRIBUTE15 | |
| ASN_LINE_SPLIT_ID | |
| INTERFACE_TRANSACTION_ID | |
| HEADER_INTERFACE_ID | |
| WIP_ENTITY_ID | |
| WIP_LINE_ID | |
| WIP_OPERATION_SEQ_NUM | |
| PO_DISTRIBUTION_ID | |
| WIP_JOB_INFO | |
| QUANTITY_SHIPPED | |
| UNIT_OF_MEASURE | |
| UOM_CODE |
| Oracle iProcurement - POS_ASN_SHOP_CART_HEADERS | |
|---|---|
| Column Name | Descritpion |
| SESSION_ID | |
| CREATION_DATE | |
| CREATED_BY | |
| ASN_TYPE | |
| SHIPMENT_NUM | |
| EXPECTED_RECEIPT_DATE | |
| PACKING_SLIP | |
| WAYBILL_AIRBILL_NUM | |
| BILL_OF_LADING | |
| FREIGHT_CARRIER_CODE | |
| FREIGHT_TERMS | |
| SHIP_TO_LOCATION_ID | |
| PAYMENT_TERMS | |
| NUM_OF_CONTAINERS | |
| COMMENTS | |
| CARRIER_METHOD | |
| CARRIER_EQUIPMENT | |
| FREIGHT_BILL_NUMBER | |
| GROSS_WEIGHT | |
| GROSS_WEIGHT_UOM_CODE | |
| NET_WEIGHT | |
| NET_WEIGHT_UOM_CODE | |
| SHIP_TO_ORGANIZATION_ID | |
| TAR_WEIGHT | |
| TAR_WEIGHT_UOM_CODE | |
| PACKAGING_CODE | |
| SPECIAL_HANDLING_CODE | |
| INVOICE_NUM | |
| INVOICE_DATE | |
| TOTAL_INVOICE_AMOUNT | |
| FREIGHT_AMOUNT | |
| TAX_NAME | |
| TAX_AMOUNT | |
| VENDOR_ID | |
| CURRENCY_CODE | |
| CURRENCY_CONVERSION_TYPE | |
| CURRENCY_CONVERSION_RATE | |
| CURRENCY_CONVERSION_DATE | |
| ATTRIBUTE_CATEGORY | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| VENDOR_SITE_ID | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| SHIP_DATE | |
| TRANSACTION_TYPE | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN |
| Oracle iProcurement - POR_USER_DATA_CONF_LIST_ITEMS | User data configuration list items |
|---|---|
| Column Name | Descritpion |
| LIST_ID | List id |
| DATA_ID | Configuration data id |
| LAST_UPDATE_DATE | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LIST_ITEM_ID | List item id |
| Oracle iProcurement - POR_USER_DATA_CONF_LIST | User data configuration list |
|---|---|
| Column Name | Descritpion |
| LIST_NAME | List name |
| LAST_UPDATE_DATE | Standard who column |
| CREATION_DATE | Standard who column |
| CREATED_BY | Standard who column |
| LAST_UPDATE_LOGIN | Standard who column |
| LAST_UPDATED_BY | Standard who column |
| LIST_ID | List id |
No hay comentarios:
Publicar un comentario