DW_EB_X_EBS_PROC_W_NEG_RESPONSES_F
DW_EB_X_EBS_PROC_W_NEG_RESPONSES_F stores all response line records (including the awarded and all the other response lines ) with its corresponding negotiation header, negotiation line and response header attributes. For the header records, such as RFI or negotiation with contract as outcome, Sourcing Application allows these headers published without lines created and the responses are only at header level. We will ELT these records into data warehouse with negotiation header attributes and response header attributes only, the NEG_LINE_NUM (LINE_NUMBER in the source system) for these records will be 0
Details
Module: Procurement (EBS_PROC)
Business Name: Negotiation Response
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| ACCEPTANCE_REASON | VARCHAR2 | 80 CHAR | ||||
| ALLOW_ALTERNATE_LINES | VARCHAR2 | 50 CHAR | ||||
| ALTERNATE_LINE_DESC | VARCHAR2 | 250 CHAR | ||||
| ALTERNATE_LINE_FLG | VARCHAR2 | 1 CHAR | ||||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AWARD_PRICE | NUMBER | 28,10 | Award Price in negotiation currency including the cost factors | |||
| AWARD_QTY | NUMBER | 28,10 | Award Quantity for a response line | |||
| BEST_BID_BID_PRICE | NUMBER | 28,10 | Price for bid with the best price / score ratio | |||
| BEST_BID_PRICE | NUMBER | 28,10 | Price in best bid | |||
| BIDDER_WID | NUMBER | 38 | W_BIDDER_D | |||
| BID_CURRENCY_PRICE | NUMBER | 28,10 | Bid Price in response currency including the cost factors | |||
| BID_CURR_CODE | VARCHAR2 | 30 CHAR | Response Currency Code | |||
| BID_LINE_PRICE | NUMBER | 28,10 | Bid Price in negotiation currency not including the cost factors | |||
| BID_PRICE | NUMBER | 28,10 | Bid Price in negotiation currency including the cost factors | |||
| BID_QTY | NUMBER | 28,10 | Response Quantity for a response line | |||
| BID_START_PRICE | NUMBER | 28,10 | Price that bids can start from | |||
| BUYER_MNGD_TRANS_FLG | VARCHAR2 | 1 CHAR | ||||
| BUYER_WID | NUMBER | 38 | Identifies the procurement Buyer. This is the surrogate key from the employee dimension. | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| CANCEL_REASON | VARCHAR2 | 80 CHAR | ||||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CURRENT_PRICE | NUMBER | 28,10 | Current price of item being paid outside auction | |||
| CUSTOMER_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PARTY_D | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DISQUALIFY_REASON | VARCHAR2 | 80 CHAR | ||||
| DOCUMENT_DISP_LINE_NUM | VARCHAR2 | 80 CHAR | Internal Negotiation Line Number | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the document currency. This typically is the currency in which the transaction occurred. Amounts will be stored in this currency. | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| EXCHANGE_DT | TIMESTAMP | 6 | EXCHANGE_DT | |||
| GLOBAL1_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the first Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the second Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the third Global Currency. The Global currencies are defined in global currency master table. | ||||
| GL_MCAL_CAL_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | |||
| GROUP_TYPE_WID | NUMBER | 38 | Identifies the group type associated with this negotiation in line data warehouse. Group type can be ?LINE?, ?GROUP?, ?LOT?, ?LOT LINE?, ?GROUP LINE? | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| INV_ORG_WID | NUMBER | 38 | Identifies the inventory organization. This is the surrogate key from the organization dimension. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| ITEM_DESCRIPTION | VARCHAR2 | 255 CHAR | Document line number to display (e.g. 2.1) | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the local currency. The local currency typically is the one in which the transaction will be posted to meet legal requirements for Company's Financial reporting. Alternatively, it may be linked to the currency used by local/regional business units for reporting purposes. | |||
| LOC_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the Local Currency. | ||||
| MCAL_PUBLISH_DT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | |||
| NEG_AMENDMENT_NUM | VARCHAR2 | 80 CHAR | ||||
| NEG_AUC_LINE_NUM | VARCHAR2 | 80 CHAR | ||||
| NEG_AWARD_COMPLETE_DT_WID | NUMBER | 38 | Identifies the negotiation header award complete date | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| NEG_BU_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_INT_ORG_D | |||
| NEG_DISPLAY_STATUS_WID | NUMBER | 38 | Identifies the negotiation display status | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| NEG_DOCUMENT_NUM | VARCHAR2 | 255 CHAR | Identify Auction display document number | |||
| NEG_HEADER_ID | VARCHAR2 | 80 CHAR | Identify Auction Header ID generated in Fusion Sourcing Application | |||
| NEG_LINE_AWARD_STATUS_WID | NUMBER | 38 | Identifies the negotiation line award status | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| NEG_LINE_NUM | VARCHAR2 | 80 CHAR | Auction header id corresponding to the first amendment for this negotiation | |||
| NEG_PUBLISH_DT_WID | NUMBER | 38 | NEG_PUBLISH_DT_WID | |||
| NEG_ROUND_NUM | VARCHAR2 | 80 CHAR | Negotiation Round Number for multi- round negotiatons | |||
| NEG_TITLE | VARCHAR2 | 80 CHAR | Auction Title displayed in Fusion Sourcing Application | |||
| NEG_TYPE_WID | NUMBER | 38 | Identifies the negotiation type associated with this negotiation in data warehouse. This is defined by negotiation style and negotiation document type in Fusion Sourcing Application | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| OUTCOME_TYPE_WID | NUMBER | 38 | Identify the outcome type of an negotiation. Possible Type Values are ?STANDARD?, ?BLANKET?, ?CONTRACT? | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| PARENT_LINE_DESCRIPTION | VARCHAR2 | 255 CHAR | Item description for one-time product | |||
| PO_LINE_TYPE_WID | NUMBER | 38 | Identifies the PO type associated with this negotiation line in data warehouse. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| PROC_BU_WID | NUMBER | 38 | Identifies the procurement BU. This is the surrogate key from the organization dimension. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| PRODUCT_WID | NUMBER | 38 | Identifies sourcing product. This is the surrogate key from the product dimension. | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PROJECT_WID | NUMBER | 38 | DW_EB_X_EBS_COMMON_W_PROJECT_D | |||
| REQUISITION_NUM | VARCHAR2 | 80 CHAR | Parent line Description for lot line and group line records | |||
| REQ_BU_WID | NUMBER | 38 | Identifies the requsition BU. This is the surrogate key from the organization dimension. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| RESPONSE_LINE_AWARD_STATUS_WID | NUMBER | 38 | Idenfies the response line award status | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| RESPONSE_NUM | VARCHAR2 | 80 CHAR | PO Blanket Line Number for renegotiation | |||
| RESPONSE_STATUS_WID | NUMBER | 38 | Identifies the response status | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| RESPONSE_TYPE_CODE | VARCHAR2 | 30 CHAR | ||||
| RESPONSE_VISIBILITY_CODE_WID | NUMBER | 38 | Identifies response visibility code in data wharehouse. For OPEN_BIDDING the bid are visible to every authorized user, SEALED_AUCTION only the seroneer can view the bids, SEALED_BIDDING neither the auctioneer nor any ser can view the bids until the auctio | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| SHIP_TO_LOCATION_WID | NUMBER | 38 | Identifies ship to location. This is the surrogate key from the business location dimension. | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| SHORTLIST_FLG | VARCHAR2 | 1 CHAR | Stores Y if a supplier is on the shortlist, ?N? otherwise | |||
| SOURCE_PO_DOC_NUM | VARCHAR2 | 80 CHAR | Requisition Number if there is an requisition created | |||
| SOURCE_PO_LINE_NUM | VARCHAR2 | 80 CHAR | PO Blanket Number for renegotiation | |||
| STANDARD_UOM_CODE | VARCHAR2 | 50 CHAR | Standard code for unit of measure | |||
| STANDARD_UOM_CONV_RATE | NUMBER | Standard unit of measure code conversion rate | ||||
| SUPPLIER_SITE_WID | NUMBER | 38 | Identifies the procurement supplier site. This is the surrogate key from the supplier account dimension | DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D | ||
| SUPPLIER_WID | NUMBER | 38 | Identifies the procurement supplier. This is the surrogate key from the party dimension | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| TARGET_PRICE | NUMBER | 28,10 | Target price for item | |||
| TARGET_QTY | NUMBER | 28,10 | Target Quantity for a negotiation line | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| TWO_PART_FLAG | VARCHAR2 | 1 CHAR | ||||
| UOM_CODE | VARCHAR2 | 50 CHAR | Code for unit of measure | |||
| W_NEG_AWARD_STATUS_CODE | VARCHAR2 | 50 CHAR | Identify data warehouse Status code of auction award used for metrics calculation. | |||
| W_NEG_STATUS_CODE | VARCHAR2 | 50 CHAR | Identify data warehouse Status code of auction used for metrics calculation. | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |