Sourcing Quote Request Export

Sourcing exports include various details of Sourcing event records.

Sourcing Event

Field NameDescriptionField TypeRequired/UniquePossible Values
Quote RequestQuote RequestNo/No
Quote Request Header IDQuote Request Header IDintegerNo/No
Original IDOriginal IDintegerNo/No
RevisionRevisionstring(255)No/No
Quote Request Header NameQuote Request Header NametextNo/No
Created At DateCreated At DatedatetimeNo/No
Created by IDCreated by IDintegerNo/No
Updated At DateUpdated At DatedatetimeNo/No
Updated by IDUpdated by IDintegerNo/No
Start DateStart DatedatetimeNo/No
End DateEnd DatedatetimeNo/No
StateStatestring(255)No/No
Event TypeEvent Typestring(255)Yes/No
TypeTypestring(255)No/No
Start On SubmitStart On SubmitbooleanNo/No
Bid On StartBid On StartbooleanNo/No
Time To RespondTime To RespondintegerNo/No
Beaten Price Options - Total EventBeaten Price Options - Total EventNo/No
Beaten Price Options - Any LotBeaten Price Options - Any LotNo/No
Beaten Price Options - Individual LineBeaten Price Options - Individual LineNo/No
Incremental Bidding Options - Any Lot Allow - Tie For First PlaceIncremental Bidding Options - Any Lot Allow - Tie For First PlaceNo/No
Incremental Bidding Options - Any Lot - Require To Improve SizeIncremental Bidding Options - Any Lot - Require To Improve SizeNo/No
Incremental Bidding Options - Any Lot - SizeIncremental Bidding Options - Any Lot - SizeNo/No
Incremental Bidding Options - Any Lot - Size TotalIncremental Bidding Options - Any Lot - Size TotalNo/No
Incremental Bidding Options - Individual Line Allow - Tie For First PlaceIncremental Bidding Options - Individual Line Allow - Tie For First PlaceNo/No
Incremental Bidding Options - Individual Line - Require To Improve - SizeIncremental Bidding Options - Individual Line - Require To Improve - SizeNo/No
Incremental Bidding Options - Individual Line - SizeIncremental Bidding Options - Individual Line - SizeNo/No
Incremental Bidding Options - Individual Line - Size TotalIncremental Bidding Options - Individual Line - Size TotalNo/No
Incremental Bidding Options - Total Event Allow - Tie For First PlaceIncremental Bidding Options - Total Event Allow - Tie For First PlaceNo/No
Incremental Bidding Options - Total Event - Require To Improve - SizeIncremental Bidding Options - Total Event - Require To Improve - SizeNo/No
Incremental Bidding Options - Total Event - SizeIncremental Bidding Options - Total Event - SizeNo/No
Incremental Bidding Options - Total Event - Size TotalIncremental Bidding Options - Total Event - Size TotalNo/No
Suppliers SeeSuppliers Seestring(255)No/No
Automatic Bid ExtensionsAutomatic Bid ExtensionsbooleanNo/No
Competitive BiddingCompetitive BiddingbooleanNo/No
Currency CodeCurrency CodeNo/No
Banner TitleBanner Titlestring(255)No/No
Banner TextBanner TexttextNo/No
Commodity NameCommodity NameNo/No
Custom Field 1Custom Field 1string(255)No/No
Custom Field 1Custom Field 1string(255)No/No
Custom Field 3Custom Field 3string(255)No/No
Custom Field 4Custom Field 4string(255)No/No
Custom Field 5Custom Field 5string(255)No/No
Custom Field 6Custom Field 6string(255)No/No
Custom Field 7Custom Field 7string(255)No/No
Custom Field 8Custom Field 8string(255)No/No
Custom Field 9Custom Field 9string(255)No/No
Custom Field 10Custom Field 10string(255)No/No
Custom Field 11Custom Field 11string(255)No/No
Custom Field 12Custom Field 12string(255)No/No
Custom Field 13Custom Field 13string(255)No/No
Custom Field 14Custom Field 14string(255)No/No
Custom Field 15Custom Field 15string(255)No/No
Custom Field 16Custom Field 16string(255)No/No
Custom Field 17Custom Field 17string(255)No/No
Custom Field 18Custom Field 18string(255)No/No
Custom Field 19Custom Field 19string(255)No/No
Custom Field 20Custom Field 20string(255)No/No
SavingsSavingsdecimal(32,4)No/No
Weight Attachments ScoreWeight Attachments Score (Points)integerNo/No
Weight Questionnaires ScoreWeight Questionnaires Score (Points)integerNo/No
Weight Items ScoreWeight Items Score (Points)integerNo/No
Closed At StateClosed At Statestring(255)No/No
Allow Multiple ResponseAllow Multiple ResponsebooleanNo/No
Sealed BidsSealed BidsbooleanNo/No
Item Required FieldsItem Required FieldstextNo/No
Pause Start TimePause Start TimedatetimeNo/No
Paused At StatePaused At Statestring(255)No/No
Creatable From Object IDCreatable From Object IDintegerNo/No
Creatable From Object TypeCreatable From Object Typestring(255)No/No
Followed From Event #Followed From Event #integerNo/No
Reporting SavingsReporting Savingsdecimal(32,4)No/No
Next Revision Event IDNext Revision Event IDintegerNo/No
Allow Award Individual Line ItemsAllow Award Individual Line ItemstrueNo/No
Event TimezoneEvent Timezonestring(255)No/No
End At PriceEnd At Pricedecimal(30,6)No/No
Max Number Of StepsMax Number Of StepsintegerNo/No
Price Increase IntervalPrice Increase IntervalintegerNo/No
Planned SavingsPlanned Savingsdecimal(30,6)No/No
Reporting Planned SavingsReporting Planned Savingsdecimal(30,6)No/No
Allow Suppliers To Choose CurrencyAllow Suppliers To Choose CurrencybooleanNo/No
Sealing TypeSealing TypeintegerNo/Noone_step_unsealing, two_steps_unsealing
Sealing StageSealing StageintegerNo/Noall_envelopes_sealed, envelope1_unsealed, envelope2_unsealed
Base Price Calculation MethodBase Price Calculation MethodintegerNo/No
Cost AvoidanceCost Avoidancedecimal(30,4)No/No
PublicPublicbooleanNo/No
Allow Supplier To Send AttachmentsAllow Supplier To Send AttachmentsbooleanNo/No
Allow Evaluators To View EventAllow Evaluators To View EventbooleanNo/No
Related RequisitionsRelated RequisitionsNo/No
Related ContractsRelated ContractsNo/No
Related OrdersRelated OrdersNo/No
Related InvoicesRelated InvoicesNo/No
HiddenHiddenbooleanNo/No
Template IDTemplate IDintegerNo/No
Planned ProfitPlanned Profitdecimal(30,6)No/No
Negotiated ProfitNegotiated Profitdecimal(30,6)No/No
CommentsCommentstextNo/No

Quote Request Line columns

Columns with line-level details for a Sourcing event.

Position Column Name Description Req/Unique Unique Type Allowable Values
1 Quote Request Line Quote Request Line FALSE FALSE
2 Quote Request Line Id Quote Request Line Id FALSE FALSE integer
3 Created At Date Created At Date FALSE FALSE datetime
4 Created by ID Created by ID FALSE FALSE integer
5 Updated At Date Updated At Date FALSE FALSE datetime
6 Updated by ID Updated by ID FALSE FALSE integer
7 Event # Event # FALSE FALSE integer
8 Type Type TRUE FALSE string(255)
9 Quantity Quantity FALSE FALSE decimal(30,6)
10 UOM UOM FALSE FALSE integer
11 Position Position FALSE FALSE integer
12 Price Amount Price Amount FALSE FALSE decimal(30,6)
13 Price Currency Code Price Currency Code FALSE FALSE integer
14 Item ID Item ID FALSE FALSE integer
15 Description Description FALSE FALSE string(255)
16 Ship To Address ID Ship To Address ID FALSE FALSE integer
17 Ship To Address Street Line 1 Ship To Address Street Line 1 FALSE FALSE string(255)
18 Ship To Address Street Line 2 Ship To Address Street Line 2 FALSE FALSE string(255)
19 Ship To Address City Ship To Address City FALSE FALSE string(255)
20 Ship To Address State/Province Ship To Address State/Province FALSE FALSE string(255)
21 Ship To Address Postal Code Ship To Address Postal Code FALSE FALSE string(255)
22 Ship To Address Country Code Ship To Address Country Code FALSE FALSE string(4)
23 Ship To Address Location Code Ship To Address Location Code FALSE FALSE
24 Reporting Price Amount Reporting Price Amount FALSE FALSE decimal(30,6)
25 Lot ID Lot ID FALSE FALSE integer
26 Commodity Name Commodity Name FALSE FALSE string(255)
27 Weight Weight FALSE FALSE integer
28 Creatable From Object ID Creatable From Object ID FALSE FALSE integer
29 Creatable From Object Type Creatable From Object Type FALSE FALSE string(255)
30 Cost Formula ID Cost Formula ID FALSE FALSE integer
31 Initial Price Initial Price FALSE FALSE decimal(30,6)
32 Incremental Increase Unit Incremental Increase Unit FALSE FALSE string(255)
33 Incremental Increase Incremental Increase FALSE FALSE decimal(30,6)
34 Need By Date Need By Date FALSE FALSE datetime
35 Price Amount In Event Currency Price Amount In Event Currency FALSE FALSE decimal(30,6)
36 Form ID Form ID FALSE FALSE integer
37 Manually Entered Base Price Manually Entered Base Price FALSE FALSE boolean
38 Manufacturer Name Manufacturer Name FALSE FALSE string(255)
39 Manufacturer Part Number Manufacturer Part Number FALSE FALSE string(255)

Quote Request User columns

Columns that detail the team from the buyer side.

Position Column Name Description Req/Unique Unique Type Allowable Values
1 Quote Request User Quote Request User FALSE FALSE
2 Quote Request User Id Quote Request User Id FALSE FALSE integer
3 Quote Request ID Quote Request ID FALSE FALSE integer
4 User ID User ID FALSE TRUE integer
5 Attitude Attitude FALSE TRUE string(255) creator, owner, watcher, evaluator
6 Evaluation State Evaluation State FALSE FALSE string(255)
7 Evaluation File Evaluation File FALSE FALSE string(255)
8 Evaluation Sections Evaluation Sections FALSE FALSE integer
9 Created At Date Created At Date FALSE FALSE datetime
10 Updated At Date Updated At Date FALSE FALSE datetime