This appendix discusses the tables used by the JD Edwards EnterpriseOne Operational Sourcing System.
Tables Used by the Operational Sourcing System
This table lists the JD Edwards EnterpriseOne Operational Sourcing system tables:
|
Table |
Description |
|
Stores event header information, such as business unit, company, start times, event properties, payment information, and buyer contact information. |
|
|
Stores information for each line in an event, such as item number and description, quantity, and line weight. |
|
|
Stores the currencies in which bidders can submit their bids for an event and the corresponding exchange rate. |
|
|
Stores the header questions attached to each event, along with information such as best and worst values, ideal answers, and question weights. |
|
|
Stores the list questions attached to an event and the list of values from which bidders can select responses. |
|
|
Stores the questions attached to each line in an event, along with information such as best and worst values, ideal answers, and question weights. |
|
|
Stores the list questions attached to each line in an event and the list of values from which bidders can select responses. |
|
|
Stores the price component information for each line in an event. |
|
|
Stores the price break information for each line in an event. |
|
|
Stores the bidders and suppliers who were invited to each event and information such as address book number, email address, fax number, bid status (accepted, declined, submitted, and so on), and search type. |
|
|
Stores the address book numbers of bidders and suppliers who have been invited to events and their passwords. |
|
|
Stores the address book numbers of bidders and suppliers who have responded to an event and information such as their bid status and their header score. |
|
|
Stores the responses to all header questions for each bidder and supplier who are participating in an event. |
|
|
Stores the responses to list questions of each bidder and supplier participating in an event. |
|
|
Stores the bidders and suppliers who have declined an event invitation and their reason for declining. |
|
|
Reserved for future use |
|
|
Reserved for future use |
|
|
Stores the line information for each bid for an event, including the quantity, bid amount, question score, and the promised delivery date. |
|
|
Stores the responses to all line questions and the corresponding score for each bidder and supplier who are participating in an event. |
|
|
Stores bidder price break information for each event, including price break quantity and price. |
|
|
Stores price component information for each event, including component description and price. |
|
|
Stores the responses to list questions of each bidder and supplier participating in an event. |
|
|
Stores analysis information by event line for each event, including bidder or supplier number, item number, bid amount, bid question score, award action, award quantity, and award percentage. |
|
|
Stores all bid question templates and their associated information, such as effective date range, best and worst values, and weight. |
|
|
Stores the values for list questions. |
|
|
Stores component information for price questions, including the component descriptions, question weights, and associated item or commodity values. |
|
|
Stores the values specified in the JD Edwards EnterpriseOne Operational Sourcing system constants. |
|
|
Stores bidder registration information such as address book number, currency codes, minimum and maximum order values, and tad identification number. |
|
|
Stores VAT (value added tax ) information for bidders, such as country and VAT identification number. |
|
|
Stores information for items that are added on an ad hoc basis during RFx creation, such as item number, stocking type, location, and so on. |