Skip to content
offerium.
DEEnglish, current

Data formats

What an Offerium export contains

“Export everything” on Data & account gives a firm one ZIP file that opens without Offerium: every bid, its tender papers, the offer exactly as sent, company documents, invoices and the activity record. This page describes that file, folder by folder and field by field. It is the same text the archive carries in its schema/ folder.

Format archive-17. Every archive names its format in manifest.json, and this page keeps the description of every earlier format.

The folders

Every file in the archive belongs to one of these categories; manifest.json names each file’s category.

Index readme
manifest.json, which lists every other file with its size, SHA-256, category and source row, and README.html, the offline index, written last. manifest.json cannot list itself: its own SHA-256 is printed in README.html and shown on Data & account.
Data data
data/<entity>.csv and data/<entity>.json: one pair per entity, the same rows in both.
Schemas schema
schema/<entity>.schema.json: each entity's fields as JSON Schema 2020-12, the same text as this page.
Bid pages bid_page
bids/<reference> <project>/bid.html: one readable page per bid, with links to its files.
Tender papers tender
bids/…/tender/: the buyer's files exactly as received.
Offer as sent offer_as_sent
bids/…/offer-as-sent/: the package files exactly as the buyer received them.
Offer e-mail offer_email
bids/…/offer-as-sent/email.txt: the covering e-mail as approved: sender, recipient, subject, text.
Mail mail
bids/…/mail/*.eml: the bid's kept messages, rebuilt from the text and attachments Offerium kept. Offerium never keeps a message's original bytes, so these are rebuilt, not the originals. Each carries the message's Message-ID and, where Offerium recorded them, the Message-IDs of the messages it answers (In-Reply-To, References), so a mail program threads them as they were.
Company documents document
documents/: every version of every company document, named with its validity.
Calendar calendar
calendar/bids.ics: the Bids calendar as iCalendar (RFC 5545).
Invoices invoice
billing/invoices/<year>/<number>.pdf: Offerium's invoices to the firm and the credit notes that corrected them, each with the e-invoice beside it where there is one.
Other files file
files/: every other file Offerium kept for the firm (a priced form someone dropped in, the letterhead logo, a portal receipt), so none is left behind.

The data, entity by entity

Each entity is written twice, as CSV and as JSON with the same rows, and described once as JSON Schema 2020-12. A field ending in _id holds the id of a row in another entity.

Bids bids

Every bid, one row each: the buyer's invitation Offerium found, and what became of it. Rows with source “rebuilt” are the priced forms recovered from your sent mail; their result is in past_bids. Key facts, addenda, approval requests, the buyer's own form lines, the possible matches Offerium proposed for them from your earlier bids, each reading of the tender documents, the words Offerium drafted for the offer, each market estimate, the prices chosen from them and Offerium's advice on whether the bid is worth making are kept with the bid they belong to.

Also carried here: extracted_facts, addenda, approval_requests, client_form_lines, bid_section_choices, bid_package_lines, bid_email_edits, bid_sending_choices, bid_text_edits, line_comparables, bid_readings, offer_word_drafts, price_estimates, price_estimate_lines, price_estimate_plans, price_choices, bid_fit_advice, bid_tax_facts, outcome_evidence.

Files:data/bids.csvdata/bids.jsonJSON Schema

The fields (73)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
buyer_idreference · an id in buyersThe buyer who asked.
slugtextThe bid's short name in Offerium's web addresses.
projecttextThe project, as the buyer named it.
referencetext · may be emptyThe buyer's own reference for the tender.
sourcechoiceHow the bid came in: found in mail, confirmed from a possible bid, or rebuilt from your sent mail.one of: detected, from_possible, rebuilt
owner_person_idreference · an id in people · may be emptyThe person responsible for the bid.
source_mailbox_idreference · an id in mailboxes · may be emptyThe mailbox the buyer's request arrived in. Empty for a request that arrived in no connected mailbox, such as one uploaded or added by hand.
invitation_message_ididentifier · may be emptyThe buyer's message that invited you; its text is in the bid's mail/ folder.
client_deadlinetime (ISO 8601, UTC) · may be emptyThe buyer's deadline for offers.
client_deadline_fact_ididentifier · may be emptyThe key fact (in facts) the deadline was read from.
planned_send_attime (ISO 8601, UTC) · may be emptyWhen the offer is to go out, once chosen.
send_time_chosentrue or falseSomeone chose the send time, rather than Offerium's default.
submission_kindchoiceWhether the offer goes by e-mail, through the buyer's portal, or on paper.one of: email, portal, post
submit_to_addresstext · may be emptyThe address offers go to.
portal_nametext · may be emptyThe buyer's portal, for portal submissions.
declined_attime (ISO 8601, UTC) · may be emptyWhen the firm decided not to bid.
declined_by_person_idreference · an id in people · may be emptyWho decided not to bid.
trust_confirmed_attime (ISO 8601, UTC) · may be emptyWhen a person said they checked a mail that looked like a trap with the buyer.
trust_confirmed_by_person_idreference · an id in people · may be emptyWho said so.
decline_reasonchoice · may be emptyWhy not.one of: too_busy, not_our_work, deadline_too_short, other
decline_notetext · may be emptyThe note written with it.
decided_attime (ISO 8601, UTC) · may be emptyWhen the buyer's decision became known.
correspondence_langchoice · may be emptyThe language the buyer is answered in: the covering e-mail, every other e-mail to the buyer on this bid and the offer document. “en” is English, “de” German. Empty: the language of the firm's market.one of: en, de
correspondence_lang_sourcechoice · may be emptyHow that language was decided: from the words of the buyer's request, from its documents, from the firm's market, or by a person. Empty when the language is empty.one of: request, documents, market, person
trade_keychoice · may be emptyThe trade of this bid's work: the one most of the buyer's positions name, else Offerium's reading of the documents, or a person's choice for this bid. Prices are looked up for it where a person chose it, or where the firm's own trade is not one Offerium looks up prices for. The firm's own trade never changes with it. Empty: none was read or chosen.one of: hvac_mechanical, electrical, fire_security, facility_services, maintenance, engineering_office
trade_sourcechoice · may be emptyWhere that trade came from: the buyer's positions, Offerium's reading of the documents, or a person. Empty when the trade is empty.one of: lines, reader, person
trade_checked_attime (ISO 8601, UTC) · may be emptyWhen Offerium checked that trade: the buyer's positions and Offerium's reading of the documents named the same trade, Offerium's check decided between them, or a person chose it. With no trade: when Offerium checked that the work is none of the trades it looks up prices for (outside_work names it). Empty: not checked yet.
outside_workJSON · may be emptyThe kind of work of a bid Offerium checked as none of the trades it looks up prices for, in a few words under en and de (“painting work”, “Malerarbeiten”). Only with no trade and trade_checked_at set; empty otherwise.
source_removal_ididentifier · may be emptySet when the invitation came from a person's own mailbox that was later disconnected: its message was deleted then, and the bid kept everything it knew. When and by whom is in audit_log.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
factsrowsKey facts read from the invitation and its papers, each with where it was read.

Each row of facts:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
kindchoiceWhat the fact is.one of: client_deadline, submission, site_walk, questions_close, work_window, other
labeltextIts name on the bid page.
value_labeltextIts value, as shown.
value_attime (ISO 8601, UTC) · may be emptyIts value as an instant, when it is one.
attachment_ididentifier · may be emptyThe tender file it was read from.
source_labeltextWhere it was read (file and page).
source_sentencetext · may be emptyThe sentence it was read from.
conflicts_with_fact_ididentifier · may be emptyAnother fact that says something different.
to_confirmJSON · may be emptyOn a deadline Offerium could not confirm (one kept for a person to confirm, or one beside another deadline), why, under why: scanned (read from a scanned page), relative (worked out from words such as “on Thursday” in an email: those words under words, and that email's day under mailDay, YYYY-MM-DD), weekday (the weekday beside the date does not match it), zone (its time zone is not clear) or date (its words do not make its year, month or hour certain). Empty on every other fact, and on a deadline kept before archive-10.
settled_attime (ISO 8601, UTC) · may be emptyWhen the conflict was settled: by a person, or as read, when a date with no time agreed with the time given on that day (no person then).
settled_by_person_idreference · an id in people · may be emptyWho settled it.
source_removal_ididentifier · may be emptySet when the message it was read from was deleted with a disconnected personal mailbox; the fact keeps what it said.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.
addendarowsAddenda the buyer sent after the invitation.

Each row of addenda:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
numberwhole numberThe addendum's number.
kindchoiceaddendum — a change to the documents; reissue — the buyer sent the documents again in a newer revision, which replaced the earlier one as the bid's basis.one of: addendum, reissue
arrived_attime (ISO 8601, UTC)When it arrived.
message_ididentifier · may be emptyThe message that carried it.
lapsed_package_version_idreference · an id in package_versions · may be emptyThe approved package it made lapse.
changesJSONWhat changed: deadline, scope, requirements, as before and after.
resolved_attime (ISO 8601, UTC) · may be emptyWhen the bid was re-priced for it.
created_attime (ISO 8601, UTC)When the row was written.
approval_requestsrowsWho was asked to approve the bid, and what came of it.

Each row of approval_requests:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
asked_by_person_idreference · an id in people · may be emptyWho asked.
asked_person_idreference · an id in peopleWho was asked.
asked_attime (ISO 8601, UTC)When.
widened_attime (ISO 8601, UTC) · may be emptyWhen the request went to every approver.
changes_requested_attime (ISO 8601, UTC) · may be emptyWhen changes were asked for instead.
changes_requested_by_person_idreference · an id in people · may be emptyWho asked for changes.
changes_requested_notetext · may be emptyWhat they asked for.
answered_attime (ISO 8601, UTC) · may be emptyWhen the request was answered.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
tender_kindchoice · may be emptyWhether the bid is a public tender, which decides the texts its offer prints.one of: public, private
tender_kind_sourcechoice · may be emptyRead from the invitation, or set by a person.one of: reader, person
tender_kind_factJSON · may be emptyWhat the reading was based on: the words or the sender's domain, with where they were found.
tender_kind_set_by_person_idreference · an id in people · may be emptyWho set it.
tender_kind_set_attime (ISO 8601, UTC) · may be emptyWhen.
framework_contract_idreference · an id in framework_contracts · may be emptyThe framework contract the bid is priced under. Empty when none.
framework_contract_sourcechoice · may be emptyWho linked it: Offerium's rules, from the request's words or the customer, or a person.one of: rules, person
framework_contract_factJSON · may be emptyThe words that linked it, and where they were.
framework_contract_set_by_person_idreference · an id in people · may be emptyWho linked it, when a person did.
framework_contract_set_attime (ISO 8601, UTC) · may be emptyWhen it was linked.
framework_contract_declined_attime (ISO 8601, UTC) · may be emptyWhen a person said the bid is not under a contract.
framework_contract_declined_by_person_idreference · an id in people · may be emptyWho said so.
section_choicesrowsAdditional sections a person ticked in or out for this bid.

Each row of section_choices:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
offer_section_idreference · an id in offer_sectionsThe section.
includedtrue or falsePrinted in this bid's offer.
by_person_idreference · an id in people · may be emptyWho chose.
attime (ISO 8601, UTC)When.
offer_templatechoice · may be emptyThe offer layout chosen on this bid; empty uses the firm's default (Classic for a public tender).one of: classic, modern, proposal
offer_notetext · may be emptyA note printed under the offer's opening, for this bid only.
acceptance_blocktrue or false · may be emptyWhether the offer prints the acceptance and signature block; empty uses the firm's default.
show_previous_totaltrue or falseA revised offer shows the previous total struck through.
offer_numbertext · may be emptyThe offer number (“HM-2026-058”), given at the first assembly.
offer_price_viewchoiceWhat the buyer sees of the price: the lines and the total (“lines”), or the single total in place of the lines (“total”). The lines stay in Offerium either way.one of: lines, total
offer_currencytext · may be emptyThe currency the bid is offered in (ISO 4217), where it is not the firm's own; empty is the firm's.
fxJSON · may be emptyThe one exchange rate the bid's figures were converted at: from, to, the rate, the day, the source.
earlier_offerJSON · may be emptyThe firm's earlier offer for the same request, as the mail names it: its number and its day as written (empty where none is given), the sentence that names it, the message it was found in, whether that is the firm's own sent offer (own) or the buyer's words (buyer), and when it was found. Empty when no mail names one.
offer_note_draft_ididentifier · may be emptyWhen the note began as a text Offerium drafted and a person used: that draft (in words).
offer_scopelist of text · may be emptyThe scope the offer prints for this bid, one entry per point, in order; empty when it prints none.
offer_scope_draft_ididentifier · may be emptyWhen the scope began as a text Offerium drafted and a person used: that draft (in words).
package_choicesrowsPackage lines a person removed from this bid's package, and files a person added to it.

Each row of package_choices:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
actionchoiceA proposed line removed, or a file added.one of: removed, added
line_keytext · may be emptyFor a removal: which line (the buyer's form, the references, or the file answering one requirement).
filenametextThe file's name.
content_typetext · may be emptyFor an uploaded file: its media type (MIME).
sha256text · may be emptyFor an uploaded file: SHA-256 of its bytes.
document_idreference · an id in company_documents · may be emptyFor a document added from the firm's documents: which one.
positionwhole numberOrder on the screen, lowest first.
by_person_idreference · an id in people · may be emptyWho did it.
attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.
email_editrowsThe covering e-mail as a person edited it before sending, with the text Offerium had written.

Each row of email_edit:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
subjecttextThe edited subject.
bodytextThe edited text.
generated_subjecttextOfferium's subject the edit started from.
generated_bodytextOfferium's text the edit started from.
edited_by_person_idreference · an id in people · may be emptyWho edited it.
edited_attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
sending_choicerowsWho a person chose to send this bid from, and which colleagues to put in copy.

Each row of sending_choice:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
sending_mailbox_idreference · an id in mailboxes · may be emptyThe mailbox chosen; empty is the usual rule (where the request came in).
send_by_handtrue or falseA person sends it from their own mail program.
cc_person_idsJSON · may be emptyThe colleagues put in copy (in people); empty is the firm's default.
chosen_by_person_idreference · an id in people · may be emptyWho chose it.
chosen_attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
text_editsrowsStandard texts and sections reworded for this offer only, with the words they started from.

Each row of text_edits:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
text_keychoice · may be emptyThe standard text reworded, if it was one.one of: preamble, exclusions, warranty, validity, payment
offer_section_idreference · an id in offer_sections · may be emptyThe section reworded, if it was one.
headingtext · may be emptyA section's heading for this offer; empty keeps its own.
texttextThe words this offer prints.
tableJSON · may be emptyA table section's columns and rows for this offer.
validity_dayswhole number · may be emptyFor the validity text: the number of days it states.
based_on_texttextThe firm's words the edit started from.
based_on_headingtext · may be emptyThe section heading it started from.
based_on_version_numberwhole number · may be emptyThe version of the firm's text it started from.
source_draft_ididentifier · may be emptyWhen the edit began from a clarification Offerium suggested: that suggestion (in words). The edit itself is always a person's.
edited_by_person_idreference · an id in people · may be emptyWho edited it.
edited_attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
client_form_linesrowsThe lines of the buyer's own price form, as received (quantities, units), before pricing.

Each row of client_form_lines:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
attachment_ididentifier · may be emptyThe tender file the line came from.
position_labeltextThe line's number in the form.
descriptiontextWhat the line asks for.
unittext · may be emptyUnit of measure.
quantitytext · may be emptyQuantity, as written in the form.
row_numberwhole number · may be emptyRow in the spreadsheet it came from.
rate_kindchoice · may be emptyWhat kind of rate the line is, as Offerium's rules read it: labour, crew, travel, travel_time, callout, standby, service, item, surcharge, markup (material at cost), small_parts, lump_sum, rental, discount, text or unknown. Empty until the line has been read.one of: labour, crew, travel, travel_time, callout, standby, service, item, surcharge, markup, small_parts, lump_sum, rental, discount, text, unknown
labour_gradechoice · may be emptyThe qualification an hour is charged at (leitung, meister, vorarbeiter, techniker, monteur, helfer, azubi, facility), or trade (a trade word such as “Elektrikerstunde”) or unspecified (no level named). Empty when not read, or not an hour.one of: leitung, meister, vorarbeiter, techniker, monteur, helfer, azubi, facility, trade, unspecified
crewJSON · may be emptyFor a crew line: each level and how many (“1 Monteur + 1 Helfer”).
bandlist of text · may be emptyThe time the rate is for: an empty list is normal hours; otherwise overtime, overtime_150, overtime_200, night, saturday, sunday, holiday, weekend, emergency or difficulty. Empty (null) when it could not be told.
includeslist of textWhat the rate explicitly includes: anfahrt (travel), fahrzeit (travel time), kleinmaterial (small parts). Empty when nothing is said to be included.
supply_scopechoice · may be emptySupply and install, supply only, install only, or removal. Empty when the line does not say.one of: supply_install, supply_only, install_only, remove
item_classtext · may be emptyThe material class, as Offerium's index map names it (a cable, a heat pump …).
item_identityJSON · may be emptyThe item's maker, model, article number and ratings (B16, 30 mA, IP44, R32 …), as read.
sizeslist of textThe sizes the line names (DN, mm, kW, cross-sections).
unit_keytext · may be emptyThe unit in Offerium's words (hour, half_hour, day, each, lump, m, m2, percent …); raw:… for a unit it does not know.
unit_scalewhole numberHow many units one price is for (100 for “per 100 m”).
unit_periodchoice · may be emptyA period the price is per, beside the unit (month, quarter, year or visit).one of: month, quarter, year, visit
line_tradechoice · may be emptyThe trade the line's own words name.one of: heating, ventilation, cooling, plumbing, electrical, alarm, automation, facility, lightning, insulation
pct_bpswhole number · may be emptyFor a percentage line: the percentage in hundredths of a percent (15 % is 1500; a discount is negative).
pct_basechoice · may be emptyWhat the percentage is on: labour, material, ek (purchase price), list (list price), proof (delivery note), total, or unknown.one of: labour, material, ek, list, proof, total, unknown
class_keytext · may be emptyThe identity as one canonical text, which lines are compared by; ? marks what is not known.
class_versionwhole number · may be emptyThe version of the rules that read it; empty until read.
class_sourcesJSONWhere each part of the identity came from: rules, structure (the file's own columns), context (the section or the job), firm_term (your firm's own words), firm_setting, or person.
class_evidenceJSONThe words each part was read from, and where (the line, its long text, its unit, its section, the job).
class_ambiguitylist of textWhy a part stayed open (for example grade:trade_word, band:context, scope:not_stated).
section_pathtext · may be emptyThe headings the line stood under, as written (“02 Stundenlohnarbeiten › 02.1 Notdienst”).
long_texttext · may be emptyThe position's long text, where the file has one.
class_set_by_person_idreference · an id in people · may be emptyWho last corrected the identity.
class_set_attime (ISO 8601, UTC) · may be emptyWhen.
split_cellsJSON · may be emptyThe form's own columns for each part (labour, material, equipment, other, unit price, amount), so the priced form is written into them.
wants_splitlist of textThe parts the form asks to be priced separately (labour, material, equipment, other).
buyer_pct_bpswhole number · may be emptyA percentage the buyer's form states, in hundredths of a percent (“zzgl. 15 %” is 1500): the buyer's term.
buyer_pct_basechoice · may be emptyWhat that percentage is on.one of: labour, material, ek, list, proof, total, unknown
buyer_budgetamount · may be emptyAn amount the buyer states for the line (“Schätzbetrag 2.000 €”).
checked_tradechoice · may be emptyThe trade whose public figures a market estimate prices this line from, as Offerium checked it; none: work outside the trades Offerium looks up prices for, which no public figures price. Empty: not checked; an estimate prices it as the bid's trade.one of: hvac_mechanical, electrical, fire_security, facility_services, maintenance, engineering_office, none
bidder_celltrue or false · may be emptyWhether the buyer's workbook marks a cell of this row for the bidder to fill (an unlocked price cell on a protected sheet, or the form's one fill of its price cells). Empty where the form marks none.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.
comparablesrowsPossible matches Offerium proposed for the buyer's open lines from your own earlier bids, and what a person decided. A proposal never priced a line by itself: a line priced from one says so in priced_lines (price_source archive).

Each row of comparables:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
client_form_line_ididentifierThe buyer's line it is for (in client_form_lines).
scope_item_idreference · an id in priced_lines · may be emptyThe line of your earlier bid it proposed; empty if that line no longer exists.
past_bid_idreference · an id in past_bids · may be emptyThe earlier bid that line belongs to.
lexical_scorewhole numberHow closely the wording matched, from 0 to 1,000.
reasontext · may be emptyWhy Offerium proposed it, in one sentence.
statuschoiceProposed and not yet decided; accepted (a person used its rate); or rejected (a person said it is not the same, or no match was found).one of: proposed, accepted, rejected
decided_by_person_idreference · an id in people · may be emptyWho decided.
decided_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
readingsrowsEach time Offerium read the tender documents for this bid (the first look, the full reading, an addendum, papers a person uploaded), and the dossier it wrote: the facts, requirements, quantities and terms it found, each with the sentence and page it was read from, or marked as not verifiable.

Each row of readings:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
stagechoiceWhich reading: the first look at the invitation (scan), the full reading, an addendum, or papers a person uploaded.one of: scan, full, addendum, papers
versionwhole number1 for the bid's first reading, then counting up; the highest is the current dossier.
requested_by_person_idreference · an id in people · may be emptyWho asked for it (“Prepare this bid”, an upload); empty when Offerium read on its own.
requested_attime (ISO 8601, UTC)When it was asked for.
started_attime (ISO 8601, UTC) · may be emptyWhen the reading began.
finished_attime (ISO 8601, UTC) · may be emptyWhen it finished.
resultchoice · may be emptyWhat it came to: read; partly read (not every page could be read or sent); failed; or not read by rule (refused). Empty while it waited or ran.one of: read, partly, failed, refused
pages_totalwhole number · may be emptyThe pages the tender documents have, counted as Offerium reads them.
pages_sentwhole number · may be emptyHow many of them were read.
selectedJSON · may be emptyWhich pages of which document were read, and which of them as an image.
dossierJSON · may be emptyThe dossier: project, buyer and contacts, location, deadline, submission, site walk, requirements, quantities and the buyer's terms, each item with the document, page and sentence it was read from, or marked as not verifiable.
verificationJSON · may be emptyHow the quoted sentences held up against the documents: how many were found, how many could not be checked, how many were dropped.
source_attachment_idslist of text · may be emptyThe tender files it read, in order.
addendum_ididentifier · may be emptyFor an addendum: which one (in addenda).
failuretext · may be emptyWhy it failed or was not read.
wordsrowsThe words Offerium drafted for this bid's offer (the covering e-mail's paragraph, the opening note, the scope, a suggested clarification or exclusion, a follow-up), each with placeholders for the bid's figures, dates and names, what Offerium's own check removed from it, and whether it was used, dismissed or replaced by a later draft. Only a draft in use is printed.

Each row of words:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
kindchoiceWhat the draft is for: the covering e-mail's paragraph, the opening note, the scope, a clarification, an exclusion, or a follow-up.one of: cover_email, opening_note, scope, clarification, exclusion, follow_up
variantchoiceWhich version was asked for: Offerium's first draft, a shorter one, a more formal one, or one that mentions the revised price.one of: standard, shorter, more_formal, rate_change
statuschoiceProposed and not yet decided; in use (applied: by a person or, for Offerium's first paragraph of the e-mail, by Offerium); dismissed by a person; or replaced by a later draft.one of: proposed, applied, dismissed, superseded
texttextThe draft, with placeholders in braces for the bid's figures, dates, names and file names ({total}, {validUntil}).
filled_texttext · may be emptyThe same words with the bid's facts filled in, as they were when the draft was stored.
target_keychoice · may be emptyFor a clarification or exclusion: the standard text of the offer it collides with.one of: preamble, exclusions, warranty, validity, payment
offer_section_idreference · an id in offer_sections · may be emptyOr the section it collides with.
because_quotetext · may be emptyFor a clarification or exclusion: the sentence of the tender documents it rests on.
because_sourcetext · may be emptyWhere that sentence stands (document and page).
droppedJSONOfferium's own check of the draft: how many sentences it had, how many were kept, and why the others were removed (a figure, a date or a name the bid does not hold). Counts only.
requested_by_person_idreference · an id in people · may be emptyWho asked for this version; empty for Offerium's first draft.
applied_by_person_idreference · an id in people · may be emptyWho used it; empty when Offerium used its first paragraph of the e-mail itself.
applied_attime (ISO 8601, UTC) · may be emptyWhen.
dismissed_by_person_idreference · an id in people · may be emptyWho dismissed it.
dismissed_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
estimatesrowsMarket estimates Offerium made for this bid where your earlier bids could not price it: a cost build-up per line, each figure with its public source or marked as an assumption, and the range computed from it. An estimate never priced a line by itself: a line priced from one says so in priced_lines (price_source market_estimate).

Each row of estimates:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
statuschoiceBeing made; ready; ready with low confidence; failed (failure says why); or replaced by a later estimate.one of: pending, ready, low_confidence, failed, superseded
basischoice · may be emptyWhere the quantities came from: the buyer's own form, the tender documents, or none (rates per unit only, no total). Empty while it was being made.one of: client_form, dossier, rates_only
marketchoiceThe market it was made for.one of: us, de
region_keytext · may be emptyThe region whose public figures it read (a state, a metropolitan area or a German Land, by code).
trade_keychoice · may be emptyThe trade it priced.one of: hvac_mechanical, electrical, fire_security, facility_services, maintenance, engineering_office, other
facts_monthtext · may be emptyThe month of public figures it read (YYYY-MM).
p10amount · may be emptyThe bid's total at the 10th percentile of the range. Empty for rates only.
p25amount · may be emptyAt the 25th percentile.
medianamount · may be emptyAt the median.
p75amount · may be emptyAt the 75th percentile.
p90amount · may be emptyAt the 90th percentile.
cost_flooramount · may be emptyThe cost at your own labour rates, where you gave them: the lowest option never goes below it.
confidencechoice · may be emptyHow far the estimate can be leaned on.one of: high, medium, low
confidence_reasonsJSONThe reasons for that confidence, as keys and figures (how many figures have a source, how old the public figures are).
assumptionsJSONThe figures no source supports, as the estimate assumed them or a person changed them, with who and when.
sourcesJSONCopies of the public figures it used, as they were: the figure, the page it came from and the passage that states it.
research_deeper_attime (ISO 8601, UTC) · may be emptyWhen Research deeper last added to its sources.
missing_tradeslist of textThe trades (as in trade_key) of the buyer's lines for which no public figures were found for the region: those lines were left open, and say so. Empty: none.
offer_currencytext · may be emptyThe currency its figures are in (ISO 4217), where it is not the firm's own; empty is the firm's.
fxJSON · may be emptyThe one exchange rate its figures in the firm's currency were converted at.
home_fxJSON · may be emptyThe one exchange rate between euros and Swiss francs its market figures were converted into its currency at, where they were published in neither its currency nor the firm's own (Swiss figures in Swiss francs for an estimate in euros or dollars): from, to, the rate, the day, the source. Empty where its market figures needed no such rate.
failuretext · may be emptyWhy it failed.
created_attime (ISO 8601, UTC)When the row was written.
superseded_attime (ISO 8601, UTC) · may be emptyWhen a later estimate replaced it.
asked_attime (ISO 8601, UTC) · may be emptyWhen the estimate was asked for: a person's press, or the reading that queued it.
ready_attime (ISO 8601, UTC) · may be emptyWhen its prices were ready.
positions_pricedwhole number · may be emptyHow many of the buyer's positions it priced.
positions_ofwhole number · may be emptyOf how many positions of the buyer's it was to price: those still open when it ran (headings and positions not in the firm's package left out); 0 for a whole job.
crew_planJSON · may be emptyThe crew plan a person set on the price card for this estimate: for each part of the work window the people a shift by role, the shifts, the hours of a shift and the days worked, and the trips and hotel nights a person. Empty where nobody changed it.
crew_plan_by_person_idreference · an id in people · may be emptyWho set that crew plan.
crew_plan_attime (ISO 8601, UTC) · may be emptyWhen that crew plan was set.
linesrowsThe estimate's lines, in order: unit rates, and line totals where the quantity is known, each computed from its cost build-up.

Each row of lines:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
client_form_line_ididentifier · may be emptyThe buyer's line it prices (in client_form_lines).
descriptiontextWhat the line prices.
unittext · may be emptyUnit of measure.
quantitytext · may be emptyQuantity, as the buyer or the tender documents wrote it; empty when none was given.
p25amount · may be emptyPrice per unit at the 25th percentile.
medianamount · may be emptyAt the median.
p75amount · may be emptyAt the 75th percentile.
total_p25amount · may be emptyThe line's total at the 25th percentile; empty without a quantity.
total_medianamount · may be emptyAt the median.
total_p75amount · may be emptyAt the 75th percentile.
build_upJSONThe cost build-up: each component (labour, material, equipment, mobilisation, overhead) with its hours, rate and quantity, its public source or the mark that it is an assumption.
confidencechoice · may be emptyHow far the line can be leaned on.one of: high, medium, low
trade_keychoice · may be emptyThe trade whose public figures priced the line. Empty on an estimate made before each line was priced from its own trade: the estimate's trade.one of: hvac_mechanical, electrical, fire_security, facility_services, maintenance, engineering_office, other
package_statechoice · may be emptyWhere the line stands in your package, as the estimate read the request: not_in_package — the request gives its work to the buyer or to others, or the form marks no cell of its row for you (no price, in no total); firm_share — priced for your share of the work only; added — a line for work the request asks to be included that no position holds; option — the request asks for the position as an option or an alternative (priced in full and shown, in no total); in_total — your own work, in the total as the estimate read the request, whatever the line's words say; added_in_total — an added line, in the total as the estimate read the request, whatever its words say. Empty: your own work.one of: not_in_package, firm_share, added, option, in_total, added_in_total
package_quoteJSON · may be emptyThe sentence that state rests on: the request's own words (sentence) and what the reading took them as (kind), or Offerium's rule over the buyer's form (kind marking).
positionwhole numberOrder on the screen, lowest first.
price_choicesrowsPrices a person chose from a market estimate on the Offer step: the option, its figure when chosen, the range it was chosen against, the reasons shown, who chose and when. A choice priced only the lines still open, or the whole bid when the buyer sent no form; each line priced from one says so in priced_lines (price_source market_estimate). A change of mind is a new row.

Each row of price_choices:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
estimate_ididentifier · may be emptyThe market estimate it was chosen from (in estimates); empty if that estimate no longer exists.
optionchoiceThe option chosen: sharp (below most of the market, never below your costs plus the minimum in your pricing settings), market (the median), premium (above the middle), recommended (Offerium's recommendation within the range, with its reasons), own_history (your own usual price from your earlier bids), own (a price you set yourself on the range, dragged there or typed; on open lines split in proportion to each line's market median), or rates (a price by the hours worked whose every rate is your own, taken as they are).one of: sharp, market, premium, recommended, own_history, own, rates
totalamount · may be emptyThe figure the option stood at when it was chosen: for the whole bid, or for the open lines it priced. Empty for a price by the hours worked that states no total.
bandJSONThe range it was chosen against, as shown: the 25th percentile, the median and the 75th percentile of the estimate, and the cost at your own labour rates, each in the currency's smallest unit; a figure the estimate did not have is empty.
reasonsJSONThe reasons shown with the option, as keys and figures.
chosen_by_person_idreference · an id in people · may be emptyWho chose it.
chosen_attime (ISO 8601, UTC)When.
priced_form_ididentifier · may be emptyThe priced form the choice wrote (in priced_lines, priced_form_id).
created_attime (ISO 8601, UTC)When the row was written.
fit_advicerowsOfferium's advice on whether this bid is worth making: the facts it rests on, computed from your own records (the trade, the working days to the deadline, the other bids due around it, the buyer's record with you, your results of the last twelve months, whether the work is in your region), up to three reasons citing those facts, and a lean. Advice, not a decision.

Each row of fit_advice:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
factsJSONThe facts, by key, each a count, a number of days, a yes or no, or the trade's fit (fits, partly, outside). A fact that was not known is absent.
reasonsJSONUp to three reasons, each with the keys of the facts it cites.
leanchoice · may be emptyWhich way the advice leans: worth bidding, or think twice. Empty when fewer than three facts were known.one of: worth_bidding, think_twice
computed_attime (ISO 8601, UTC)When it was worked out.
superseded_attime (ISO 8601, UTC) · may be emptyWhen the facts it rests on changed, before it was worked out again.
tax_factsrowsThe facts the offer's VAT or sales tax is decided from that a person entered or Offerium's rules read: the job site, the planned execution date, the contract form, the building, a PV system, the US job facts and the rates found for the site, and a person's choice of how the offer is taxed. At most one row.

Each row of tax_facts:

FieldTypeMeaning
site_countrytext · may be emptyThe job site's country (ISO 3166-1 alpha-2).
site_regiontext · may be emptyIts US state, two letters.
site_ziptext · may be emptyIts postcode.
site_countytext · may be emptyIts US county.
execution_datetext · may be emptyThe planned execution date (YYYY-MM-DD).
execution_date_sourcechoice · may be emptyRead by Offerium's rules, or entered by a person.one of: rules, person
contract_formchoice · may be emptyLump sum, itemized, or time and materials.one of: lump_sum, itemized, tm
building_usechoice · may be emptyWhat the building is used for.one of: residential, public, commercial, mixed
residential_pctwhole number · may be emptyFor a mixed-use building, the residential share of its floor area, in percent.
property_usechoice · may be emptyThe US property use.one of: owner_occ_res, rental_res, commercial, industrial, mixed
building_agechoice · may be emptyA new building, or an existing one.one of: new, existing
existing_householdtrue or false · may be emptyThe work is in an existing household.
dwellingswhole number · may be emptyDwelling units in the building.
unit_conditionchoice · may be emptyThe unit replaced was defective or working.one of: defective, working
free_porttrue or false · may be emptyThe site lies in a free zone.
pv_operatorchoice · may be emptyThe buyer is the PV system's operator.one of: yes, no
pv_wpwhole number · may be emptyThe PV system's capacity, in watt peak.
pv_existing_wpwhole number · may be emptyAn existing system's capacity, in watt peak.
pv_mastr_requiredtrue or false · may be emptyThe system must be registered in the Marktstammdatenregister.
labour_share_notetrue or false · may be emptyThe offer shows its labour share for the customer's tax deduction.
period_netJSON · may be emptyFor a maintenance contract billed per visit or period: the net of one billed visit, per part of the offer.
us_relationchoice · may be emptyPrime contractor or subcontractor.one of: prime, sub
us_workchoice · may be emptyThe kind of work the request is for, as US rules class it.one of: new_build, cap_improvement, rp_repair, rp_maint_scheduled, cleaning, tpp_install, tpp_repair, tpp_sale, monitoring
us_one_sitetrue or false · may be emptyThe work is done at one job site.
us_scheduled_documentedtrue or false · may be emptyScheduled, documented periodic maintenance (Texas).
us_az_alterationchoice · may be emptyArizona: maintenance, repair, replacement or alteration, or a modification.one of: mrra, modification
us_cleaningchoice · may be emptyWashington: regular or specialized cleaning.one of: regular, specialized
us_public_roadtrue or false · may be emptyWashington: public road construction.
us_repair_sizechoice · may be emptyDistrict of Columbia: a minor repair or a major one.one of: minor, major
us_cleaning_contractchoice · may be emptyMinnesota: a building cleaning and maintenance contract, or a repair contract.one of: cleaning, repair
us_ratesJSON · may be emptyThe rates found for the site from the state's own source, with the source and the quarter.
sourcesJSONFor a value set by Offerium's rules or read from a document rather than entered by a person: how, how sure, and the words it was read from, by column. A value not named here was entered by a person.
tax_choiceJSON · may be emptyA person's choice of how the offer is taxed, which wins over Offerium's; empty when Offerium's applies.
tax_choice_by_person_idreference · an id in people · may be emptyWho chose it.
tax_choice_attime (ISO 8601, UTC) · may be emptyWhen.
set_by_person_idreference · an id in people · may be emptyWho last entered a fact.
set_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
outcome_evidencerowsEvery piece of evidence about how the bid ended, kept for good, both sides of a later contrary statement included, also where no outcome is recorded.

Each row of outcome_evidence:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
resultchoiceThe result the evidence states.one of: won, lost, no_decision
kindchoiceWhat the evidence is: an explicit statement, the buyer's purchase order, the firm's own order confirmation or invoice, an offer signed and returned, an award letter, a notice under § 134 GWB naming another bidder, a weak sign, or a person.one of: explicit_statement, purchase_order, own_order_confirmation, own_invoice, countersigned_offer, award_letter, gwb_134_notice, weak_sign, person, ted_award_notice
strengthchoice · may be emptyExplicit, strong or weak; none for a person.one of: explicit, strong, weak
statechoicepossible: matched by too little, waiting for a person; recorded: the result rests on it; probable: a weak sign (“probably won”), counted as won nowhere; superseded: replaced by later evidence or a person; dismissed: a person said it does not belong here.one of: possible, recorded, probable, superseded, dismissed
recorded_bychoiceRecorded by Offerium's rules, or by a person.one of: rules, person
quoteJSON · may be emptyThe sentence, verified in the document, and where it stands.
message_ididentifier · may be emptyThe message it is in.
attachment_ididentifier · may be emptyThe attachment it is in.
pagewhole number · may be emptyThe page.
document_datetext · may be emptyThe date the document gives (YYYY-MM-DD).
directionchoice · may be emptyFrom the buyer's side, or the firm's own outbound order confirmation or invoice.one of: inbound, outbound
matched_keysJSONHow it was tied to the bid: the offer number, the buyer's reference, the thread, the buyer's domain, the project or the site, as found.
matchchoice · may be emptyWhat the keys amount to: one decisive key, two agreeing keys, or too little.one of: decisive, agreeing, weak
winner_nametext · may be emptyThe winning bidder, when the notice names one.
stated_priceamount · may be emptyA price the document states (the winner's, or the amount ordered).
stated_price_currencytext · may be emptyIts currency, ISO 4217.
notice_numbertext · may be emptyOnly for the kind ted_award_notice, a contract award notice published on TED: its publication number. Such a notice is tied to the bid by the buyer's reference, the project or the buyer's name (buyer_name in matched_keys).
notice_lottext · may be emptyThe notice's lot it was read from (“all”: the whole notice).
notice_urltext · may be emptyThe notice on ted.europa.eu.
person_idreference · an id in people · may be emptyThe person who recorded, confirmed or dismissed it.
decided_attime (ISO 8601, UTC) · may be emptyWhen its state was last set by a person.
superseded_by_ididentifier · may be emptyThe evidence that replaced it.
superseded_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.

Requirements requirements

The checklist of each bid: what the buyer asks for, and how the firm met it or why it does not apply.

Files:data/requirements.csvdata/requirements.jsonJSON Schema

The fields (43)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
labeltextThe requirement, as shown.
categorychoiceWhat kind of requirement.one of: technical, commercial, legal, form, certificate
source_labeltext · may be emptyWhere the buyer asks for it (file and page).
source_sentencetext · may be emptyThe buyer's sentence.
met_howtext · may be emptyHow it is met, in words.
met_by_document_idreference · an id in company_documents · may be emptyThe company document that meets it.
met_by_fact_ididentifier · may be emptyThe key fact that meets it.
met_attime (ISO 8601, UTC) · may be emptyWhen it was met.
missing_labeltext · may be emptyWhat is still missing, as shown.
action_keytext · may be emptyThe action Offerium offered for it.
must_be_valid_throughtime (ISO 8601, UTC) · may be emptyA document must be valid until then.
is_mandatory_site_walktrue or falseA site walk the buyer requires.
site_walk_attime (ISO 8601, UTC) · may be emptyWhen the site walk is.
site_walk_person_idreference · an id in people · may be emptyWho attends it.
site_walk_attended_attime (ISO 8601, UTC) · may be emptyWhen attendance was confirmed.
needs_signature_by_person_idreference · an id in people · may be emptyWho has to sign.
signed_attime (ISO 8601, UTC) · may be emptyWhen it was signed.
signed_typed_nametext · may be emptyThe name typed to sign.
not_applicable_attime (ISO 8601, UTC) · may be emptyWhen it was marked as not applying.
not_applicable_by_person_idreference · an id in people · may be emptyWho marked it.
not_applicable_reasontext · may be emptyWhy it does not apply.
remembered_for_buyertrue or falseRemembered for this buyer's next bids.
document_kind_keytext · may be emptyThe kind of company document it asks for.
max_age_dayswhole number · may be emptyThe document may be at most this many days old.
needs_buyer_as_holdertrue or falseThe certificate must name this buyer as its holder.
buyer_term_keychoice · may be emptyThe standard text the buyer's documents set their own terms for.one of: preamble, exclusions, warranty, validity, payment
buyer_terms_quotetext · may be emptyThe buyer's own words.
buyer_terms_summarytext · may be emptyTheir terms in short (“Net 45”).
buyer_terms_choicechoice · may be emptyThe answer: which terms the offer prints, the buyer's or the firm's own; or, for a term the offer does not print (retention, liquidated damages, insurance, bonds, prices, delivery terms), noted as read.one of: buyers, ours, noted
buyer_terms_chosen_by_person_idreference · an id in people · may be emptyWho answered.
buyer_terms_chosen_attime (ISO 8601, UTC) · may be emptyWhen.
buyer_term_topicchoice · may be emptyWhich of the buyer's terms the question is about: payment, retention, liquidated damages, warranty, insurance, validity, exclusions, bonds, prices (fixed prices or a price adjustment) or delivery terms.one of: payment, retention, liquidated_damages, warranty, insurance, validity, exclusions, bonds, prices, delivery_terms
buyer_terms_theirsJSON · may be emptyTheir terms as figures, read from the buyer's own sentence: payment days, retention and bonds in hundredths of a per cent, liquidated damages per day and insurance limits in the currency's minor unit (cents) with the currency, liquidated damages as a share per day, working day, business day or week and their cap (a share, with what it is of, or an amount), warranty in months, validity in days, fixed prices and until when, the Incoterm of the delivery terms. A figure the sentence does not state is absent.
buyer_terms_suggestiontext · may be emptyThe clarification Offerium suggested for it, if any. It is printed only if a person adds it.
buyer_terms_raised_bychoice · may be emptyWho raised the question: Offerium, from the tender documents (reader); the demonstration data (seed); or a person.one of: reader, seed, person
send_later_attime (ISO 8601, UTC) · may be emptyWhen a person decided the document is sent later, not with this offer (at onboarding or on request).
send_later_by_person_idreference · an id in people · may be emptyWho decided it.
send_later_notetext · may be emptyThe note written with it.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.

Priced lines priced_lines

Every priced line of every priced form, with the form it belongs to. A lump-sum price with no lines appears as the offer total in package_versions.

Also carried here: priced_forms, line_tax_facts.

Files:data/priced_lines.csvdata/priced_lines.jsonJSON Schema

The fields (80)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
priced_form_ididentifierThe priced form the line is on.
form_originchoiceWhere the form came from: your earlier bids, a form someone dropped in, a lump sum, or a price for the whole bid a person chose from a market estimate.one of: archive, dropped_form, lump_sum, market_estimate
form_filenametext · may be emptyThe form's file name, if it was a file.
form_totalamount · may be emptyThe form's total. Empty for a price by the hours worked, whose price is its rates, and for a form whose every position is priced per unit only.
form_totals_reconciletrue or falseThe lines add up to the form's total.
form_unplaced_lineswhole number · may be emptyWhen the form was written with the buyer's own workbook filled in: how many of its priced lines could not be written into that workbook (0: every one was). Empty when no workbook was filled in, and on forms written before this was recorded.
form_superseded_attime (ISO 8601, UTC) · may be emptyWhen a newer form replaced this one.
form_chargingJSON · may be emptyFor a price by the hours worked: how a person set it to be charged — a rate per item, one all-in rate, or prices of the firm's own — with each rate. Empty where nobody changed it.
form_scenariotext · may be emptyWhich of the request's scenarios the form prices, by the name the request gives it, when the request asks for more than one; empty is the request's base scenario, which the offer, the approval and the totals take.
form_price_choice_ididentifier · may be emptyWhen the form was written for a price a person chose from a market estimate: that choice (in bids, price_choices).
form_price_eventsJSONThe changes of the whole price made on this bid up to this form, oldest first: each says whether a person typed a total (total_set) or applied a percentage (markup, in hundredths of a percent), who, when, the total before and after in minor units, and whether the difference was spread over the lines (spread) or written as one adjustment line (adjustment).
form_replaces_form_ididentifier · may be emptyThe form a “Start over” or “Back to the previous price” replaced with this one (in priced_lines, priced_form_id).
position_labeltext · may be emptyThe line's number.
descriptiontextWhat the line prices.
quantitytext · may be emptyQuantity, as written.
unittext · may be emptyUnit of measure.
unit_priceamount · may be emptyPrice per unit.
line_totalamount · may be emptyThe line's total.
carried_from_past_bid_idreference · an id in past_bids · may be emptyThe past bid the price was carried from.
carried_from_labeltext · may be emptyThat past bid, as shown.
is_opentrue or falseStill to be priced.
price_sourcechoice · may be emptyWhere the line's price came from: carried across from your earlier bids, an earlier price brought up to date by an official price index, a market estimate a person chose, typed by a person, from a priced form someone dropped in, a framework contract's rate (contract), your own selling rates (rate_card, also a percentage of one of them), a number a person accepted that Offerium computed (composed: from two of your own sources, or from a country's default surcharge or the line's own “time and a half” / “double time” a person chose — the price basis's rule says which), or the customer's own surcharge you recorded on its page (buyer_terms: its percentage, or the normal hour plus it). Empty on lines priced before this was recorded.one of: archive, escalated, market_estimate, typed, dropped_form, contract, rate_card, composed, buyer_terms
base_unit_priceamount · may be emptyFor a price brought up to date by an index: the earlier price per unit it started from. On a line where a person took the index's update back (price_source archive, with an escalation), the unit price is this earlier price again.
escalationJSON · may be emptyFor a price brought up to date by an index: the index (source: bls_ppi, destatis_bpi, destatis_tarif or destatis_ppi; series), the earlier and the later period (YYYY-MM or YYYY-Qn) and the index's value in each, times 1,000 as whole numbers. The unit price is the earlier price times the later value divided by the earlier value, rounded to the cent. Where a person took the update back (price_source archive), the unit price is the earlier price, and this records what the index would have made of it. A price brought up to date by the firm's own yearly increase instead says source own_rate, the rate in tenths of a percent (permille: 35 is 3.5 %) and the months from the earlier to the later month (months; both periods YYYY-MM); its earlier value is 1,000,000,000 and its later value the factor (1 + rate)^(months / 12) on that scale, so the same rule gives the unit price. A price whose labour and material parts were brought up to date one by one lists each part under components (part, index or the reason it was not moved, the values, the part before and after); the unit price is their sum.
estimate_line_ididentifier · may be emptyFor a market estimate a person chose: the line of the estimate it came from.
priced_by_person_idreference · an id in people · may be emptyWho typed the price, chose the estimate, or chose the earlier price over the index's update. Empty when Offerium carried the price across from your earlier bids.
priced_attime (ISO 8601, UTC) · may be emptyWhen the line's price was decided: when Offerium carried it across from your earlier bids (and brought it up to date by an index, or did not), or when a person typed it, chose the estimate or chose the earlier price.
editsJSONEvery change a person made to this line, oldest first: the kind (added, edited, adjustment, spread, markup, left_out or put_back), when, who, and the line as it was before (description, quantity, unit, unit price, line total, where its price came from) — empty for a line nobody touched. A line whose amount a person changed has price_source typed; its first source is the first entry's “was”.
is_adjustmenttrue or falseThe one line “Adjustment” that carries the difference between the lines and a total a person set.
left_out_attime (ISO 8601, UTC) · may be emptyWhen a person left the line out. A line left out is kept, counts in no total and is not on the offer; “Put back” brings it back in a new form. Empty for a line on the offer.
left_out_by_person_idreference · an id in people · may be emptyWho left the line out.
package_statechoice · may be emptyWhere the line stands in your package, as the market estimate a person chose read the request: not_in_package — the request gives its work to the buyer or to others, or the form marks no cell of its row for you to fill, so Offerium left it out (no price, in no total); firm_share — priced for your share of the work only, its supply given to others; added — work the request asks to be included that no position of the buyer's form holds; option — the request asks for the position as an option or an alternative, so it is priced in full and shown, and in no total unless a person counts it in (option_in_total); in_total — your own work, in the total as the estimate read the request, whatever the line's words say; added_in_total — an added line, in the total as the estimate read the request, whatever its words say; firm — a person put a line Offerium had left out back on the offer. Empty: your own work.one of: not_in_package, firm_share, added, option, in_total, added_in_total, firm
package_quoteJSON · may be emptyThe sentence that state rests on: the request's own words (sentence) and what the reading took them as (kind: package_limit, by_others, buyer_supplies, asked_unlisted), or Offerium's rule over the buyer's form (kind marking).
option_in_totaltrue or falseAn option (package_state option) a person counted into the offer's total: it stays an option and is shown as one, and its price is in the total as well. False on every other line.
option_in_total_attime (ISO 8601, UTC) · may be emptyWhen a person last counted the option in or out of the total; empty when nobody did.
option_in_total_by_person_idreference · an id in people · may be emptyWho last counted the option in or out of the total.
origin_price_sourcechoice · may be emptyFor a price carried across from an earlier bid: where that number was first set (typed by a person, read from a priced form, chosen from a market estimate …). Empty when it was not carried, or this was not recorded.one of: archive, escalated, market_estimate, typed, dropped_form, contract, rate_card, composed, buyer_terms
recovered_fromJSON · may be emptyFor a line read from an old offer: the message, the attachment and the place in the file (page, sheet and row, or the GAEB position).
rate_kindchoice · may be emptyWhat kind of rate the line is, as Offerium's rules read it: labour, crew, travel, travel_time, callout, standby, service, item, surcharge, markup (material at cost), small_parts, lump_sum, rental, discount, text or unknown. Empty until the line has been read.one of: labour, crew, travel, travel_time, callout, standby, service, item, surcharge, markup, small_parts, lump_sum, rental, discount, text, unknown
labour_gradechoice · may be emptyThe qualification an hour is charged at (leitung, meister, vorarbeiter, techniker, monteur, helfer, azubi, facility), or trade (a trade word such as “Elektrikerstunde”) or unspecified (no level named). Empty when not read, or not an hour.one of: leitung, meister, vorarbeiter, techniker, monteur, helfer, azubi, facility, trade, unspecified
crewJSON · may be emptyFor a crew line: each level and how many (“1 Monteur + 1 Helfer”).
bandlist of text · may be emptyThe time the rate is for: an empty list is normal hours; otherwise overtime, overtime_150, overtime_200, night, saturday, sunday, holiday, weekend, emergency or difficulty. Empty (null) when it could not be told.
includeslist of textWhat the rate explicitly includes: anfahrt (travel), fahrzeit (travel time), kleinmaterial (small parts). Empty when nothing is said to be included.
supply_scopechoice · may be emptySupply and install, supply only, install only, or removal. Empty when the line does not say.one of: supply_install, supply_only, install_only, remove
item_classtext · may be emptyThe material class, as Offerium's index map names it (a cable, a heat pump …).
item_identityJSON · may be emptyThe item's maker, model, article number and ratings (B16, 30 mA, IP44, R32 …), as read.
sizeslist of textThe sizes the line names (DN, mm, kW, cross-sections).
unit_keytext · may be emptyThe unit in Offerium's words (hour, half_hour, day, each, lump, m, m2, percent …); raw:… for a unit it does not know.
unit_scalewhole numberHow many units one price is for (100 for “per 100 m”).
unit_periodchoice · may be emptyA period the price is per, beside the unit (month, quarter, year or visit).one of: month, quarter, year, visit
line_tradechoice · may be emptyThe trade the line's own words name.one of: heating, ventilation, cooling, plumbing, electrical, alarm, automation, facility, lightning, insulation
pct_bpswhole number · may be emptyFor a percentage line: the percentage in hundredths of a percent (15 % is 1500; a discount is negative).
pct_basechoice · may be emptyWhat the percentage is on: labour, material, ek (purchase price), list (list price), proof (delivery note), total, or unknown.one of: labour, material, ek, list, proof, total, unknown
class_keytext · may be emptyThe identity as one canonical text, which lines are compared by; ? marks what is not known.
class_versionwhole number · may be emptyThe version of the rules that read it; empty until read.
class_sourcesJSONWhere each part of the identity came from: rules, structure (the file's own columns), context (the section or the job), firm_term (your firm's own words), firm_setting, or person.
class_evidenceJSONThe words each part was read from, and where (the line, its long text, its unit, its section, the job).
class_ambiguitylist of textWhy a part stayed open (for example grade:trade_word, band:context, scope:not_stated).
section_pathtext · may be emptyThe headings the line stood under, as written (“02 Stundenlohnarbeiten › 02.1 Notdienst”).
long_texttext · may be emptyThe position's long text, where the file has one.
class_set_by_person_idreference · an id in people · may be emptyWho last corrected the identity.
class_set_attime (ISO 8601, UTC) · may be emptyWhen.
labour_partamount · may be emptyThe labour part (Lohn) of the unit price, when it is split; the parts add up to the unit price.
material_partamount · may be emptyThe material part (Stoff).
equipment_partamount · may be emptyThe equipment part (Geräte).
other_partamount · may be emptyAny other part (Sonstiges).
split_sourcechoice · may be emptyWhere the split came from: the GAEB file's price components, the workbook's columns, an EFB 223 sheet, a contract, or a person.one of: gaeb_upcomp, sheet_columns, efb_223, contract, person
labour_minuteswhole number · may be emptyThe time allowance per unit (EFB 223), in hundredths of a minute.
stated_labour_share_bpswhole number · may be emptyA labour share as the form states it (“Lohnanteil 40 %” is 4000), in hundredths of a percent; shown, never applied.
metal_clauseJSON · may be emptyA copper or metal clause as written: the metal, the basis per 100 kg, and whether the price includes it.
source_scope_item_ididentifier · may be emptyFor a rate carried across: the earlier line it came from (in priced_lines).
decision_keytext · may be emptyWhich pricing decision of the firm the number belongs to: copies of one rate share it, so the rate counts once. Empty when the line is its own decision.
price_basisJSON · may be emptyWhy the number is what it is: the step it came from (contract, rate_card, same_buyer, same_type, firm, person_pick; buyer for a term the customer wrote on its form, buyer_terms for the customer's own surcharge you recorded, surcharge_default for a country's default a person chose), the rule, its inputs, the earlier line, selling rate or contract rate it cites, any unit conversion and index steps, the rates it compared and those it left out with the reason, and how sure it is. Offerium recomputes the number from this.
rate_card_entry_ididentifier · may be emptyFor a price from your selling rates: the value it came from (in rate_cards, entries).
contract_rate_ididentifier · may be emptyFor a price from a framework contract: the contract's rate (in framework_contracts, rates).
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.
tax_factsrowsWhat a person said of the line for its tax: the part of the offer it belongs to, its kind of work, and the US facts. At most one row.

Each row of tax_facts:

FieldTypeMeaning
grouptext · may be emptyThe independent part of the offer it belongs to (a maintenance contract beside an installation); empty for the main scope.
de_workchoice · may be emptyThe kind of work, for German VAT.one of: material_supply, planning, commissioning, measurement_listed, measurement, site_services, removal, accessory, building_install, fixed_plant, split_unit, movable_unit, machine_foundation, lamps, attached_device, terminal_devices, wallbox, drain_cleaning, fire_portable, planting, chimney, cleaning, cleaning_excluded, movable_repair, pv_system, repair, maintenance, maintenance_parts, maintenance_consumables, auxiliary, unknown
us_workchoice · may be emptyThe kind of work, as US rules class it.one of: new_build, cap_improvement, rp_repair, rp_maint_scheduled, cleaning, tpp_install, tpp_repair, tpp_sale, monitoring
us_objectchoice · may be emptyWhat the work is done on, as US rules class it.one of: passive, unit, fixture, freestanding, process_machine, comm_refrigeration
us_hvacchoice · may be emptyThe heating and cooling job type of the US rules.one of: j1, j2, j3, j4, j5, j6
us_kindchoice · may be emptyWhat the line charges for, as US rules class it.one of: labor, material, unit, subcontract, fee, travel
us_costamount · may be emptyThe actual cost of the line's materials.
us_cost_statedtrue or false · may be emptyThe offer states that cost separately (New Jersey).
us_material_statedtrue or false · may be emptyThe offer states the fixture's price separately (California).
set_by_person_idreference · an id in people · may be emptyWho said it.
set_attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.

Package versions package_versions

Each version of a bid's offer package: the price, the standard texts as used, the covering e-mail and the files. The package that went out is also under the bid's offer-as-sent/ folder, byte for byte.

Also carried here: package_files.

Files:data/package_versions.csvdata/package_versions.jsonJSON Schema

The fields (49)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
version_numberwhole number1 for the first version, then counting up.
priced_form_ididentifier · may be emptyThe priced form it was built from.
offer_totalamount · may be emptyThe offer's total.
text_preambletext · may be emptyOpening text, as used.
text_exclusionstext · may be emptyExclusions, as used.
text_warrantytext · may be emptyWarranty text, as used.
text_validitytext · may be emptyValidity text, as used.
text_paymenttext · may be emptyPayment terms, as used.
currencytextISO 4217 currency code.
email_fromtext · may be emptyThe covering e-mail's sender.
email_from_mailbox_idreference · an id in mailboxes · may be emptyThe mailbox the e-mail goes out from.
email_cclist of textThe colleagues in copy (Cc); empty is no one.
email_totext · may be emptyIts recipient.
email_subjecttext · may be emptyIts subject.
email_bodytext · may be emptyIts text.
langchoice · may be emptyThe language this version's offer document and e-mail are written in: “en” English, “de” German. Empty on versions from before this was recorded, which are in the language of the firm's market.one of: en, de
letterheadJSON · may be emptyThe letterhead as this version printed it: the firm's name, address, officers and statements at the moment it was assembled.
sender_nametext · may be emptyThe bid owner's name as this version printed it: “Prepared by” on the offer and the e-mail's signature. Empty when the bid had no owner.
sender_titletext · may be emptyTheir job title, as printed beside the name.
text_sectionsJSON · may be emptyThe additional sections this version printed, in order, with their headings and words. Empty on versions from before sections existed.
text_provenanceJSON · may be emptyFor each standard text: which wording printed (the firm's default, the public-tender or a buyer's version), which version of it, and why.
valid_untiltime (ISO 8601, UTC) · may be emptyThe offer's “Valid until”: the day it was assembled plus the validity text's days, at the end of that day in the firm's time zone.
designJSON · may be emptyThe offer's design as this version printed it: layout, logo, footer, acceptance block, greeting, recipient, note, signer and signature, revision. Empty on versions from before it existed.
offer_numbertext · may be emptyThe offer number this version printed.
revisionwhole number0 for the offer as first priced, then one more each time it was re-priced.
price_viewchoiceWhat the buyer saw of the price in this version's offer: the lines and the total (“lines”), or the single total (“total”).one of: lines, total
removed_linesJSONFiles Offerium proposed that a person removed from this version, with who and when.
email_generated_subjecttext · may be emptyWhen a person edited the e-mail: the subject Offerium had written.
email_generated_bodytext · may be emptyAnd the text Offerium had written.
email_edited_by_person_idreference · an id in people · may be emptyWho edited the e-mail.
email_edited_attime (ISO 8601, UTC) · may be emptyWhen.
words_provenanceJSON · may be emptyWhich of this version's words Offerium drafted (the covering e-mail's paragraph, the opening note, the scope), each with its draft (in bids, words) and the words as printed. Empty when nothing on it was drafted.
price_choiceJSON · may be emptyWhen this version's price came from a market estimate a person chose: that choice as the version froze it (in bids, price_choices), with the option, the figure, the range, the estimate's confidence, how many lines it priced, who chose and when. It was shown to the approver and never printed for the buyer. Empty when no such choice priced the version.
assembled_attime (ISO 8601, UTC)When the version was assembled.
created_attime (ISO 8601, UTC)When the row was written.
tax_marketchoice · may be emptyWhose tax rules decided the offer's tax: German VAT or US sales tax. Empty when the version printed the fixed rate.one of: de, us
tax_engine_versionwhole number · may be emptyThe version of the rules that decided it.
tax_treatmentJSON · may be emptyThe offer's tax as decided and frozen with the version: its parts with their rates, net, tax and gross, the notes the offer printed, and, for the firm only, the reason, the evidence and how sure it was.
tax_automatic_codetext · may be emptyWhat Offerium's rules chose, kept beside a person's choice.
tax_automatic_confidencechoice · may be emptyHow sure the rules were.one of: high, medium, low
tax_choiceJSON · may be emptyA person's choice that applied, which won over the rules'.
tax_chosen_by_person_idreference · an id in people · may be emptyWho chose it.
tax_chosen_attime (ISO 8601, UTC) · may be emptyWhen.
tax_factsJSON · may be emptyThe facts it was decided from (the lines' words are in priced_lines).
tax_decided_attime (ISO 8601, UTC) · may be emptyWhen it was decided.
price_termsJSON · may be emptyThe price terms this version's offer printed under its totals, as they stood when it was assembled: material billed at cost with its percentage, the copper clause with its base per 100 kg, and the surcharges and billing of hours from the firm's selling rates or a framework contract. A term that did not apply is left out. Empty on versions from before this was recorded and on a package without an offer.
filesrowsThe package's files, in order. Their bytes are identified by sha256 in manifest.json.

Each row of files:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
filenametextThe file name the buyer receives.
extent_labeltext · may be emptyPages or sheets, as shown.
content_typetext · may be emptyMedia type (MIME).
sha256text · may be emptySHA-256 of the file, lowercase hex.
line_keytext · may be emptyWhich line of the package the file is: the offer, the buyer's form, the references, the file answering one requirement, or one a person added.
added_by_person_idreference · an id in people · may be emptyFor a file a person added: who.
added_attime (ISO 8601, UTC) · may be emptyAnd when.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.

Approvals approvals

Every approval, with a snapshot of exactly what was approved: files, e-mail, send time and total. An approval that lapsed says when and why.

Files:data/approvals.csvdata/approvals.jsonJSON Schema

The fields (29)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
package_version_idreference · an id in package_versionsThe package version approved.
kindchoiceApproved to go out at the chosen time, or at once.one of: scheduled_send, send_now
approved_by_person_idreference · an id in peopleWho approved.
approved_attime (ISO 8601, UTC)When.
approved_fromtext · may be emptyWhere the approval was given (the screen or the e-mail).
prepared_and_approvedtrue or falseThe same person prepared and approved it.
snapshot_filesJSONThe files as approved: name and SHA-256 of each.
snapshot_email_fromtext · may be emptyThe e-mail's sender, as approved.
snapshot_email_totext · may be emptyIts recipient, as approved.
snapshot_email_subjecttext · may be emptyIts subject, as approved.
snapshot_email_bodytext · may be emptyIts text, as approved.
snapshot_email_bcclist of textThe copies (Bcc) the Sending settings asked for, as approved; empty is no copies.
snapshot_langchoice · may be emptyThe language of the offer document and the e-mail, as approved. Empty on approvals from before this was recorded (the language of the firm's market).one of: en, de
snapshot_from_mailbox_idreference · an id in mailboxes · may be emptyThe mailbox the bid goes out from, as approved.
snapshot_email_cclist of textThe colleagues in copy (Cc), as approved; empty is no one.
snapshot_send_attime (ISO 8601, UTC) · may be emptyThe send time, as approved.
snapshot_totalamount · may be emptyThe total, as approved.
snapshot_currencytext · may be emptyIts currency.
snapshot_not_applicable_notesJSONRequirements marked as not applying, with their reasons, as approved.
snapshot_send_later_notesJSONDocuments set to be sent later rather than with the offer, with who and their note, as approved.
snapshot_words_provenanceJSON · may be emptyWhich words of the approved version Offerium drafted, as the approver saw them marked; empty when none were.
snapshot_price_sourcesJSONWhere the approved price came from, as the approver saw it: the lines counted by source (your earlier bids, brought up to date by an index, a market estimate, typed by a person, a dropped-in form); lines a person took from a country's default surcharge (surcharge_default) or as the line's own “time and a half” / “double time” (line_multiplier) counted apart from those put together from your rates; for a market estimate also the option, the estimate's confidence and who chose it. Empty on approvals from before this was recorded.
save_to_drivetrue or falseThe approver asked for the package to be saved to the firm's drive.
lapsed_attime (ISO 8601, UTC) · may be emptyWhen the approval lapsed.
lapse_reasonchoice · may be emptyWhy it lapsed.one of: new_price, new_send_time, requirement_marked_not_applicable, requirement_mark_undone, addendum, changes_requested, papers_added, requirement_sent_later, requirement_send_later_undone, package_changed
lapse_detailtext · may be emptyThe lapse, in words.
created_attime (ISO 8601, UTC)When the row was written.

Holds holds

Every time an approved bid was held back from going out, and released.

Files:data/holds.csvdata/holds.jsonJSON Schema

The fields (8)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
held_by_person_idreference · an id in peopleWho held it.
held_attime (ISO 8601, UTC)When.
notetext · may be emptyThe note written with it.
released_by_person_idreference · an id in people · may be emptyWho released it.
released_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.

Sends sends

Each time an offer went out, or was due to: when, from where, to whom, and what happened.

Files:data/sends.csvdata/sends.jsonJSON Schema

The fields (25)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
approval_idreference · an id in approvals · may be emptyThe approval it went out under.
package_version_idreference · an id in package_versions · may be emptyThe package version sent.
statuschoiceWhat happened to it.one of: scheduled, held, sent, delivered, bounced, failed, submitted_via_portal, deadline_passed_unsent
scheduled_fortime (ISO 8601, UTC) · may be emptyWhen it was due to go out.
sent_attime (ISO 8601, UTC) · may be emptyWhen it went out.
from_addresstext · may be emptyThe address it went from.
to_addresseslist of textThe addresses it went to.
bcc_addresseslist of textThe addresses it went to as copies (Bcc).
from_mailbox_idreference · an id in mailboxes · may be emptyThe mailbox it went from.
cc_addresseslist of textThe colleagues it went to in copy (Cc).
rfc_message_idtext · may be emptyThe sent message's Message-ID header.
file_countwhole number · may be emptyHow many files went with it.
delivered_attime (ISO 8601, UTC) · may be emptyWhen delivery was confirmed.
failure_detailtext · may be emptyWhy it failed or bounced.
held_reasontext · may be emptyWhy it was held.
portal_confirmation_numbertext · may be emptyThe portal's receipt number.
portal_confirmation_filenametext · may be emptyThe portal's receipt file.
portal_submitted_attime (ISO 8601, UTC) · may be emptyWhen it was submitted through the portal.
portal_marked_by_person_idreference · an id in people · may be emptyWho marked it submitted.
sent_by_handtrue or falseA person sent it from the firm's own mail program and recorded it here; Offerium did not send it.
marked_sent_by_person_idreference · an id in people · may be emptyWho recorded that it was sent.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.

Outcomes outcomes

What the buyer decided, as Offerium proposed it and as a person confirmed it.

Files:data/outcomes.csvdata/outcomes.jsonJSON Schema

The fields (24)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
proposed_resultchoice · may be emptyThe result Offerium read from a reply.one of: won, lost, unknown, no_decision, no_bid
proposed_attime (ISO 8601, UTC) · may be emptyWhen it was proposed.
proposed_from_sentencetext · may be emptyThe sentence it was read from.
proposed_from_message_ididentifier · may be emptyThe message that sentence is in.
proposal_rejected_attime (ISO 8601, UTC) · may be emptyWhen a person rejected the proposal.
confirmed_resultchoice · may be emptyThe result a person confirmed.one of: won, lost, unknown, no_decision, no_bid
confirmed_by_person_idreference · an id in people · may be emptyWho confirmed it.
confirmed_attime (ISO 8601, UTC) · may be emptyWhen.
sourcechoice · may be emptyHow the result became known.one of: reply, phone, portal, follow_up_ask, silence
winning_priceamount · may be emptyThe winning price, if known.
told_texttext · may be emptyWhat the buyer said, in their words.
proposed_winning_priceamount · may be emptyThe winning price Offerium read from a reply, in the currency named there; it becomes the winning price only when a person confirms it.
proposed_winning_price_currencytext · may be emptyIts currency, ISO 4217.
proposed_winning_price_quoteJSON · may be emptyWhere it was read: the document, the page and the sentence, verbatim.
proposed_reason_quoteJSON · may be emptyThe sentence of a reply that says why the bid was lost or won, with where it stands, as Offerium read it.
confirmed_by_evidencetrue or falseThe result was recorded from explicit or strong evidence, by no person; the evidence is in the bid's outcome_evidence. A person's change clears it.
award_priceamount · may be emptyThe price the job was awarded at, when it was not the firm's own (a negotiation, an order for less).
award_price_sourcechoice · may be emptyRead from a document, or entered by a person.one of: evidence, person
award_price_set_by_person_idreference · an id in people · may be emptyWho entered it, when a person did.
award_price_set_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.

Follow-ups follow_ups

Questions to the buyer about a decision: when due, the draft, and when sent and answered.

Files:data/follow_ups.csvdata/follow_ups.jsonJSON Schema

The fields (15)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bids · may be emptyThe bid asked about.
past_bid_idreference · an id in past_bids · may be emptyThe past bid asked about.
due_attime (ISO 8601, UTC)When it is due.
to_addresstext · may be emptyWho it goes to.
draft_texttext · may be emptyThe draft.
draft_sourcechoice · may be emptyWhere the draft's words came from: Offerium's fixed template, drafted by Offerium from the sent bid's own facts, or written or changed by a person. Empty on drafts from before this was recorded.one of: template, offerium, person
sent_attime (ISO 8601, UTC) · may be emptyWhen it was sent.
sent_by_person_idreference · an id in people · may be emptyWho sent it.
answered_attime (ISO 8601, UTC) · may be emptyWhen it was answered.
hand_offered_attime (ISO 8601, UTC) · may be emptyWhen no mailbox could send it, and the draft was offered to send yourself.
sent_by_handtrue or falseSent by a person from their own mail program, then marked as sent.
from_mailbox_idreference · an id in mailboxes · may be emptyThe mailbox it is asked from, when a handover moved it; empty is the mailbox the bid went from.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.

Timeline timeline

Each bid's timeline, as the bid page shows it: one sentence per event. Nothing in Offerium edits a line once written.

Files:data/timeline.csvdata/timeline.jsonJSON Schema

The fields (6)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
attime (ISO 8601, UTC)When it happened.
texttextWhat happened, as written at the time.
message_ididentifier · may be emptyThe message it is about.
created_attime (ISO 8601, UTC)When the row was written.

Buyers buyers

Everyone who has asked the firm for a price, with the record of bids won and lost and what they always ask for.

Also carried here: buyer_standing_requirements, buyer_tax_facts, tax_certificates, buyer_surcharge_terms.

Files:data/buyers.csvdata/buyers.jsonJSON Schema

The fields (18)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
slugtextThe buyer's short name in Offerium's web addresses.
nametextFull name.
short_nametextShort name, as shown in lists.
domainslist of textTheir mail domains.
decision_lag_dayswhole number · may be emptyDays they usually take to decide.
kindchoice · may be emptyWhat kind of customer this is: private_person, property_manager, housing_company, commercial, industrial, public, general_contractor, facility_manager or other. Recognised by Offerium in the background, or set by a person. Empty when not determined.one of: private_person, property_manager, housing_company, commercial, industrial, public, general_contractor, facility_manager, other
kind_sourcechoice · may be emptyHow: Offerium's rules, Offerium's rules over a passage read from a document, or a person, whose choice stays.one of: rules, model_evidence, person
kind_confidencechoice · may be emptyHow sure the recognition is. Only a high one, or a person's choice, is used in pricing.one of: high, medium, low
kind_evidenceJSON · may be emptyWhat it was recognised from: each signal, the words and where they were.
kind_set_by_person_idreference · an id in people · may be emptyWho set it, when a person did.
kind_set_attime (ISO 8601, UTC) · may be emptyWhen it was last set.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
standing_requirementsrowsWhat this buyer asks for on most bids.

Each row of standing_requirements:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
labeltextThe requirement.
seen_onwhole numberOn how many of their bids.
out_ofwhole numberOut of how many.
positionwhole numberOrder on the screen, lowest first.
tax_factsrowsWhat is known of the buyer for VAT or sales tax: its seat, VAT ID and type, whether it is a construction or cleaning business and how that became known. At most one row.

Each row of tax_facts:

FieldTypeMeaning
seat_countrytext · may be emptyIts seat's country (ISO 3166-1 alpha-2).
seat_ziptext · may be emptyIts seat's postcode.
vat_idtext · may be emptyIts VAT ID.
vat_buyer_typechoice · may be emptyIts type for German VAT, as a person set it.one of: consumer, business, weg, bund_land, public_body, public_bga, municipal_company, bautraeger, arge
us_buyer_typechoice · may be emptyIts type for US sales tax.one of: private, business, contractor, gov_fed, gov_state_local, nonprofit, manufacturer
is_construction_businesstrue or false · may be emptyIt itself provides construction work; empty when not known.
construction_originchoice · may be emptyHow that became known: its own words read by Offerium's rules, a certificate, or a person.one of: rules, document, person
construction_evidenceJSON · may be emptyThe words it was read from, and where.
construction_set_by_person_idreference · an id in people · may be emptyWho set it, when a person did.
construction_set_attime (ISO 8601, UTC) · may be emptyWhen.
is_cleaning_businesstrue or false · may be emptyIt itself provides building cleaning; empty when not known.
cleaning_originchoice · may be emptyHow that became known.one of: rules, document, person
cleaning_evidenceJSON · may be emptyThe words it was read from, and where.
cleaning_set_by_person_idreference · an id in people · may be emptyWho set it, when a person did.
cleaning_set_attime (ISO 8601, UTC) · may be emptyWhen.
weg_tax_freetrue or false · may be emptyA homeowners' association that passes the work on tax-free.
vat_grouptrue or false · may be emptyIt is part of a VAT group.
us_housing_authoritytrue or false · may be emptyA housing authority (Washington).
us_exemption_claimedtrue or false · may be emptyIt says it is exempt from sales tax.
sourcesJSONFor a value set by Offerium's rules or read from a document rather than entered by a person: how, how sure, and the words it was read from, by column. A value not named here was entered by a person.
set_by_person_idreference · an id in people · may be emptyWho last entered a fact.
set_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
tax_certificatesrowsThe certificates the buyer gave: the tax office's USt 1 TG (it provides construction work or building cleaning), a § 48b certificate, or a US exemption certificate for a state. Kept when they lapse.

Each row of tax_certificates:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bids · may be emptyThe bid it was given for, when it is for one job only.
kindchoiceWhat it is.one of: ust1tg, freistellung, resale, exempt_org, government, manufacturing, capital_improvement, prime_contractor
countrytextIts country (ISO 3166-1 alpha-2).
statetext · may be emptyThe US state it is for.
formtext · may be emptyThe form as named (“USt 1 TG”, “ST-124”).
numbertext · may be emptyIts number, or the tax number it names.
issuing_officetext · may be emptyThe office that issued it.
issued_ontext · may be emptyWhen it was issued (YYYY-MM-DD).
valid_untiltext · may be emptyUntil when it is valid; empty when none is stated (YYYY-MM-DD).
coverslist of textWhat a USt 1 TG covers: bau (construction work), reinigung (building cleaning).
on_filetrue or falseThe document is on file.
viachoiceUploaded, or recorded by a person as present.one of: document, person
attachment_ididentifier · may be emptyThe attachment it came as.
stored_file_ididentifier · may be emptyThe file uploaded for it.
revoked_attime (ISO 8601, UTC) · may be emptyWhen the firm learnt it was revoked.
recorded_by_person_idreference · an id in people · may be emptyWho recorded it.
recorded_attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
surcharge_termsrowsThis customer's own surcharges on the normal hour, as the firm recorded them on the customer's page: one per time, used on this customer's bids before the firm's selling rates. Every value each has had; a value is never changed in place.

Each row of surcharge_terms:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bandchoiceThe time: overtime, overtime_150 (time and a half), overtime_200 (double time), night, saturday, sunday, holiday, weekend or emergency.one of: overtime, overtime_150, overtime_200, night, saturday, sunday, holiday, weekend, emergency
pct_bpswhole numberThe surcharge on the normal hour, in hundredths of a percent.
set_by_person_idreference · an id in people · may be emptyWho recorded it.
set_attime (ISO 8601, UTC)When.
superseded_attime (ISO 8601, UTC) · may be emptyWhen a person changed or removed it; empty while it is current.
superseded_reasonchoice · may be emptyWhy: changed or removed by a person.one of: person_changed, person_removed
created_attime (ISO 8601, UTC)When the row was written.

Buyer contacts buyer_contacts

The people at each buyer who wrote to the firm.

Files:data/buyer_contacts.csvdata/buyer_contacts.jsonJSON Schema

The fields (12)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
buyer_idreference · an id in buyersTheir buyer.
nametextName.
first_nametext · may be emptyFirst name, as used in greetings.
emailtextE-mail address.
roletext · may be emptyTheir role, printed under the name on offers.
salutationchoice · may be emptyHow offers greet them, as a person chose it; empty is the neutral greeting.one of: ms, mr, mx, first_name, full_name, frau, herr, custom
salutation_nametext · may be emptyThe name the greeting prints.
salutation_customtext · may be emptyA greeting written out in full.
salutation_set_by_person_idreference · an id in people · may be emptyWho chose the greeting.
salutation_set_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.

Possible bids possible_bids

Messages that might have been invitations, and what a person decided about each. One that arrived only in a person's own mailbox and never became a bid is that person's, and is left out.

Files:data/possible_bids.csvdata/possible_bids.jsonJSON Schema

The fields (10)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
message_ididentifierThe message.
subject_labeltextIts subject, as shown.
context_labeltext · may be emptySender and date, as shown.
uncertainty_reasontextWhy Offerium was not sure.
sorted_attime (ISO 8601, UTC) · may be emptyWhen a person decided.
sorted_by_person_idreference · an id in people · may be emptyWho decided.
became_bid_idreference · an id in bids · may be emptyThe bid it became, if it did.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.

Past bids past_bids

Decided bids: the ones rebuilt from your sent mail and the ones Offerium carried through, with price, result and reason.

Files:data/past_bids.csvdata/past_bids.jsonJSON Schema

The fields (41)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
buyer_idreference · an id in buyersThe buyer.
bid_idreference · an id in bids · may be emptyThe bid it corresponds to, if Offerium carried it.
projecttextThe project.
sent_attime (ISO 8601, UTC) · may be emptyWhen the offer went out.
sent_labeltext · may be emptyWhen, as shown (a month, when the day is not known).
our_priceamount · may be emptyThe firm's price.
resultchoiceThe result.one of: won, lost, unknown, no_decision, no_bid
winning_priceamount · may be emptyThe winning price, if known.
result_reasontext · may be emptyWhy, if known.
eligible_for_reusetrue or falseIts prices may be carried into new bids.
needs_verificationtrue or falseA person should check what was recovered.
asked_attime (ISO 8601, UTC) · may be emptyWhen the buyer was asked about the result.
source_message_ididentifier · may be emptyThe sent message it was rebuilt from.
price_notetext · may be emptyA note on the price ("from", "about").
recovered_attime (ISO 8601, UTC) · may be emptyWhen it was rebuilt.
source_removal_ididentifier · may be emptySet when the mail it was rebuilt from came from a person's own mailbox that was later disconnected and was deleted then; the row and its result stay.
offer_datetext · may be emptyThe day the offer's prices were decided (YYYY-MM-DD): the offer's own date, else the day it was sent.
job_contextlist of text · may be emptyThe times the whole job ran under (emergency, sunday …), as read from its project, subject or covering mail.
job_context_statuschoice · may be emptyProposed by Offerium's rules, or confirmed or rejected by a person.one of: proposed, confirmed, rejected
job_context_factJSON · may be emptyThe words it was read from, and where.
job_context_set_by_person_idreference · an id in people · may be emptyWho confirmed or rejected it.
job_context_set_attime (ISO 8601, UTC) · may be emptyWhen.
price_reasonchoice · may be emptyFor a lost bid: whether it was lost on price, for another reason, or unknown.one of: price, other, unknown
price_reason_sourcechoice · may be emptyRead by Offerium's rules from the buyer's words, or set by a person.one of: rules, person
price_reason_set_by_person_idreference · an id in people · may be emptyWho set it, when a person did.
price_reason_set_attime (ISO 8601, UTC) · may be emptyWhen.
award_discount_bpswhole number · may be emptyA discount granted on the award (“abzgl. 3 % bei Auftrag” is 300), in hundredths of a percent, as a person recorded it; shown, never applied.
award_discount_set_by_person_idreference · an id in people · may be emptyWho recorded it.
award_discount_set_attime (ISO 8601, UTC) · may be emptyWhen.
award_priceamount · may be emptyThe price the job was awarded at, when it was not the firm's own (a negotiation, an order for less).
award_price_sourcechoice · may be emptyRead from a document, or entered by a person.one of: evidence, person
award_price_set_by_person_idreference · an id in people · may be emptyWho entered it, when a person did.
award_price_set_attime (ISO 8601, UTC) · may be emptyWhen.
framework_contract_idreference · an id in framework_contracts · may be emptyThe framework contract the offer was priced under.
site_countrytext · may be emptyThe country of the job's site (ISO 3166 alpha-2, “CH”): read from the offer where it states the site, found again in the offer's own words, or the site of the bid Offerium sent. Empty when not known, as on every offer imported before archive-15.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
benchmarksrowsRates others named for one of its lines — the winner's, a competitor's or the buyer's budget — with the sentence they were named in. Shown beside your own rates, never used as a price.

Each row of benchmarks:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
scope_item_ididentifier · may be emptyThe line of the offer it is for (in priced_lines), when one was matched.
descriptiontextThe line, as named.
unittext · may be emptyIts unit.
rateamountThe rate named.
basischoice · may be emptyNet or gross, as stated; empty when not stated.one of: net, gross
kindchoiceWhose rate: the winner's, a competitor's, or the buyer's budget.one of: winner, competitor, buyer_budget
quoteJSON · may be emptyThe sentence it was named in, and where.
source_message_ididentifier · may be emptyThe message it was read from.
originchoiceRead by Offerium's rules, by its rules over a passage read from the mail, or entered by a person.one of: rules, model_evidence, person
verifiedtrue or falseOfferium found the figure again in the quoted sentence.
set_by_person_idreference · an id in people · may be emptyWho entered or corrected it.
set_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
outcome_evidencerowsEvery piece of evidence about how the past bid ended, kept for good.

Each row of outcome_evidence:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
resultchoiceThe result the evidence states.one of: won, lost, no_decision
kindchoiceWhat the evidence is: an explicit statement, the buyer's purchase order, the firm's own order confirmation or invoice, an offer signed and returned, an award letter, a notice under § 134 GWB naming another bidder, a weak sign, or a person.one of: explicit_statement, purchase_order, own_order_confirmation, own_invoice, countersigned_offer, award_letter, gwb_134_notice, weak_sign, person, ted_award_notice
strengthchoice · may be emptyExplicit, strong or weak; none for a person.one of: explicit, strong, weak
statechoicepossible: matched by too little, waiting for a person; recorded: the result rests on it; probable: a weak sign (“probably won”), counted as won nowhere; superseded: replaced by later evidence or a person; dismissed: a person said it does not belong here.one of: possible, recorded, probable, superseded, dismissed
recorded_bychoiceRecorded by Offerium's rules, or by a person.one of: rules, person
quoteJSON · may be emptyThe sentence, verified in the document, and where it stands.
message_ididentifier · may be emptyThe message it is in.
attachment_ididentifier · may be emptyThe attachment it is in.
pagewhole number · may be emptyThe page.
document_datetext · may be emptyThe date the document gives (YYYY-MM-DD).
directionchoice · may be emptyFrom the buyer's side, or the firm's own outbound order confirmation or invoice.one of: inbound, outbound
matched_keysJSONHow it was tied to the bid: the offer number, the buyer's reference, the thread, the buyer's domain, the project or the site, as found.
matchchoice · may be emptyWhat the keys amount to: one decisive key, two agreeing keys, or too little.one of: decisive, agreeing, weak
winner_nametext · may be emptyThe winning bidder, when the notice names one.
stated_priceamount · may be emptyA price the document states (the winner's, or the amount ordered).
stated_price_currencytext · may be emptyIts currency, ISO 4217.
notice_numbertext · may be emptyOnly for the kind ted_award_notice, a contract award notice published on TED: its publication number. Such a notice is tied to the bid by the buyer's reference, the project or the buyer's name (buyer_name in matched_keys).
notice_lottext · may be emptyThe notice's lot it was read from (“all”: the whole notice).
notice_urltext · may be emptyThe notice on ted.europa.eu.
person_idreference · an id in people · may be emptyThe person who recorded, confirmed or dismissed it.
decided_attime (ISO 8601, UTC) · may be emptyWhen its state was last set by a person.
superseded_by_ididentifier · may be emptyThe evidence that replaced it.
superseded_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.

Framework contracts framework_contracts

The firm's framework contracts and agreed rates with its customers: read from the documents and mails the firm already had, with each figure's quoted place, or added by a person. The customers each one covers and its rates are kept with it. Figures that could not be verified are listed under not_taken and were never used.

Also carried here: framework_contract_buyers, framework_contract_rates.

Files:data/framework_contracts.csvdata/framework_contracts.jsonJSON Schema

The fields (28)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
kindchoiceA framework contract (Rahmenvertrag, Wartungsvertrag with rates, Zeitvertrag), or rates agreed with one customer.one of: framework, agreed_rates
referencetext · may be emptyIts reference, as written (“RV-2025-07”).
titletextIts title.
valid_fromtext · may be emptyThe day it applies from (YYYY-MM-DD).
valid_totext · may be emptyThe day it ends (YYYY-MM-DD); empty when it runs until notice.
notice_notetext · may be emptyIts notice terms, as written.
currencytext · may be emptyThe currency of its rates (ISO code).
basischoice · may be emptyWhether its rates are net or gross.one of: net, gross
price_clauseJSON · may be emptyIts price clause: none, a fixed yearly percentage, an index, renegotiation, or unknown, with its words and page.
catalogue_adjust_bpswhole number · may be emptyA mark-up or discount on catalogue prices, in hundredths of a percent.
billing_increment_minuteswhole number · may be emptyHow it bills hours: per started block of this many minutes. Empty when it does not say.
min_billable_minuteswhole number · may be emptyThe least it bills for a call-out, in minutes. Empty when it does not say.
originchoiceRead from a document, read from a mail, added by a person, or saved from the firm's own agreeing offers.one of: document, mail, person, observations
source_fileJSON · may be emptyThe file it was read from: its name, and the message and attachment it came with.
quotesJSONWhere each of its own facts was found: the words and the page, sheet or row.
not_takenJSONFigures it states that could not be verified at their place, each with the words and the reason. Never used.
statuschoiceactive (its rates apply to the bids linked to it, inside its validity), not_applied (it could not be read safely; never applied) or ended (by a person).one of: active, not_applied, ended
not_applied_reasontext · may be emptyWhy it does not apply, when it does not.
ended_attime (ISO 8601, UTC) · may be emptyWhen a person ended it.
ended_by_person_idreference · an id in people · may be emptyWho ended it.
created_by_person_idreference · an id in people · may be emptyWho added it, when a person did.
changed_by_person_idreference · an id in people · may be emptyWho last corrected it.
changed_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
buyersrowsThe customers it covers.

Each row of buyers:

FieldTypeMeaning
buyer_idreference · an id in buyersThe customer.
originchoiceNamed in the document, or added by a person.one of: document, person
quoteJSON · may be emptyWhere the document names it.
added_by_person_idreference · an id in people · may be emptyWho added it, when a person did.
created_attime (ISO 8601, UTC)When the row was written.
ratesrowsIts rates, each with its identity and its quoted place, including those a later correction replaced (superseded_at).

Each row of rates:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
position_labeltext · may be emptyIts number in the contract.
descriptiontextWhat it is for, as written.
unittext · may be emptyIts unit, as written.
rate_kindchoice · may be emptyWhat kind of rate the line is, as Offerium's rules read it: labour, crew, travel, travel_time, callout, standby, service, item, surcharge, markup (material at cost), small_parts, lump_sum, rental, discount, text or unknown. Empty until the line has been read.one of: labour, crew, travel, travel_time, callout, standby, service, item, surcharge, markup, small_parts, lump_sum, rental, discount, text, unknown
labour_gradechoice · may be emptyThe qualification an hour is charged at (leitung, meister, vorarbeiter, techniker, monteur, helfer, azubi, facility), or trade (a trade word such as “Elektrikerstunde”) or unspecified (no level named). Empty when not read, or not an hour.one of: leitung, meister, vorarbeiter, techniker, monteur, helfer, azubi, facility, trade, unspecified
crewJSON · may be emptyFor a crew line: each level and how many (“1 Monteur + 1 Helfer”).
bandlist of text · may be emptyThe time the rate is for: an empty list is normal hours; otherwise overtime, overtime_150, overtime_200, night, saturday, sunday, holiday, weekend, emergency or difficulty. Empty (null) when it could not be told.
includeslist of textWhat the rate explicitly includes: anfahrt (travel), fahrzeit (travel time), kleinmaterial (small parts). Empty when nothing is said to be included.
supply_scopechoice · may be emptySupply and install, supply only, install only, or removal. Empty when the line does not say.one of: supply_install, supply_only, install_only, remove
item_classtext · may be emptyThe material class, as Offerium's index map names it (a cable, a heat pump …).
item_identityJSON · may be emptyThe item's maker, model, article number and ratings (B16, 30 mA, IP44, R32 …), as read.
sizeslist of textThe sizes the line names (DN, mm, kW, cross-sections).
unit_keytext · may be emptyThe unit in Offerium's words (hour, half_hour, day, each, lump, m, m2, percent …); raw:… for a unit it does not know.
unit_scalewhole numberHow many units one price is for (100 for “per 100 m”).
unit_periodchoice · may be emptyA period the price is per, beside the unit (month, quarter, year or visit).one of: month, quarter, year, visit
line_tradechoice · may be emptyThe trade the line's own words name.one of: heating, ventilation, cooling, plumbing, electrical, alarm, automation, facility, lightning, insulation
pct_bpswhole number · may be emptyFor a percentage line: the percentage in hundredths of a percent (15 % is 1500; a discount is negative).
pct_basechoice · may be emptyWhat the percentage is on: labour, material, ek (purchase price), list (list price), proof (delivery note), total, or unknown.one of: labour, material, ek, list, proof, total, unknown
class_keytext · may be emptyThe identity as one canonical text, which lines are compared by; ? marks what is not known.
class_versionwhole number · may be emptyThe version of the rules that read it; empty until read.
class_sourcesJSONWhere each part of the identity came from: rules, structure (the file's own columns), context (the section or the job), firm_term (your firm's own words), firm_setting, or person.
class_evidenceJSONThe words each part was read from, and where (the line, its long text, its unit, its section, the job).
class_ambiguitylist of textWhy a part stayed open (for example grade:trade_word, band:context, scope:not_stated).
unit_priceamount · may be emptyThe rate; empty for a percentage (pct_bps).
quoteJSON · may be emptyWhere it stands in the contract: the words and the page, sheet or row.
verifiedtrue or falseOfferium found the figure again at that place.
originchoiceRead from a document or a mail, entered by a person, or saved from the firm's own agreeing offers.one of: document, mail, person, observations
evidenceJSONFor a rate saved from the firm's own offers: the lines it was taken from (in priced_lines).
set_by_person_idreference · an id in people · may be emptyWho entered or corrected it.
set_attime (ISO 8601, UTC) · may be emptyWhen.
superseded_attime (ISO 8601, UTC) · may be emptyWhen a correction replaced it; empty while it is current.
superseded_reasonchoice · may be emptyWhy: a person changed it, removed it, or the contract was read again.one of: person_changed, person_removed, reread
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.

Company documents company_documents

Certificates, licences and other documents the firm keeps for bids, every version. The files are under documents/.

Also carried here: company_document_versions.

Files:data/company_documents.csvdata/company_documents.jsonJSON Schema

The fields (32)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
nametextThe document's name.
kindtextWhat kind of document.
filenametext · may be emptyThe file's name as received.
attachment_ididentifier · may be emptyThe message attachment it came from.
sourcechoiceHow it came in (upload_link: sent by its issuer through a single-use upload link, checked and accepted by a person).one of: uploaded, forwarded_email, old_quotes_folder, past_offer, upload_link
statuschoiceIn use, asked for from its holder, or archived.one of: active, requested, archived
valid_totime (ISO 8601, UTC) · may be emptyValid until.
has_no_expirytrue or falseIt does not expire.
detail_labeltext · may be emptyDetail shown with it (a policy number, a scope).
superseded_by_document_idreference · an id in company_documents · may be emptyThe newer version that replaced it.
uploaded_by_person_idreference · an id in people · may be emptyWho added it.
holder_buyer_idreference · an id in buyers · may be emptyThe buyer who holds or issues it, when it is theirs.
keeper_person_idreference · an id in people · may be emptyWho at the firm looks after it.
requested_attime (ISO 8601, UTC) · may be emptyWhen a new copy was asked for.
requested_by_person_idreference · an id in people · may be emptyWho asked for it.
requested_viachoice · may be emptyHow it was asked for: an e-mail to the broker, the issuer's own instructions, or an upload link.one of: broker_mail, issuer_instructions, upload_link
issuer_nametext · may be emptyWho issues it (a broker, an office).
issuer_emailtext · may be emptyThe issuer's e-mail address, as given.
reminder_planJSON · may be emptyA reminder plan a person set for it: days before expiry, and when the owner is told too. Empty: the catalogue's plan for its kind.
reminders_ontrue or falseReminders are sent for it.
archived_attime (ISO 8601, UTC) · may be emptyWhen it was archived.
archived_by_person_idreference · an id in people · may be emptyWho archived it.
numbertext · may be emptyIts number (a licence or policy number).
jurisdictiontext · may be emptyWhere it applies.
boardtext · may be emptyThe body that issued it.
print_on_offerstrue or falsePrinted on every offer.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
sha256text · may be emptySHA-256 of the current file, lowercase hex: the fingerprint under documents/ and in manifest.json.
versionsrowsEvery version of the document, oldest first. Each file is under documents/.

Each row of versions:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
version_numberwhole number1 for the first version, then counting up.
filenametext · may be emptyThe file's name as received.
attachment_ididentifier · may be emptyThe message attachment it came from.
sourcechoiceHow it came in.one of: uploaded, forwarded_email, old_quotes_folder, past_offer, upload_link
issued_ontime (ISO 8601, UTC) · may be emptyDate of issue.
valid_fromtime (ISO 8601, UTC) · may be emptyValid from.
valid_totime (ISO 8601, UTC) · may be emptyValid until.
has_no_expirytrue or falseIt does not expire.
fieldsJSONWhat Offerium read from the file (holder, insured amounts, scope), as confirmed.
quotesJSONThe sentences each value was read from.
read_statechoiceWhether Offerium read the file, or a person typed the dates.one of: typed, reading, read, no_text, failed
read_attime (ISO 8601, UTC) · may be emptyWhen the file was read.
page_countwhole number · may be emptyPages in the file.
confirmationsJSONEach value a person confirmed or corrected, by whom and when.
questionsJSONWhere the file was unclear, the question asked and the answer given.
confirmed_by_person_idreference · an id in people · may be emptyWho confirmed what was read.
confirmed_attime (ISO 8601, UTC) · may be emptyWhen.
uploaded_by_person_idreference · an id in people · may be emptyWho added it.
created_attime (ISO 8601, UTC)When the row was written.
sha256text · may be emptySHA-256 of this version's file.

Approved references approved_references

Past projects the firm allows Offerium to name as references.

Files:data/approved_references.csvdata/approved_references.jsonJSON Schema

The fields (11)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
past_bid_idreference · an id in past_bidsThe past bid.
buyer_idreference · an id in buyers · may be emptyOnly for this buyer, when set.
labeltextThe reference, as printed.
show_valuetrue or falseThe contract value may be printed with it.
contact_may_be_namedtrue or falseThe buyer's contact may be named.
trade_keychoice · may be emptyThe trade it counts as a reference for.one of: hvac_mechanical, electrical, fire_security, facility_services, maintenance, engineering_office, other
added_by_person_idreference · an id in people · may be emptyWho added it.
added_attime (ISO 8601, UTC) · may be emptyWhen.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.

Standard texts standard_texts

The texts every offer uses: opening, exclusions, warranty, validity, payment; with their versions for public tenders and for single buyers, and every wording each has had.

Also carried here: standard_text_versions.

Files:data/standard_texts.csvdata/standard_texts.jsonJSON Schema

The fields (19)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
keychoiceWhich text.one of: preamble, exclusions, warranty, validity, payment
variant_kindchoiceThe firm's own text, its version for public tenders, or its version for one buyer.one of: default, public_tender, buyer
buyer_idreference · an id in buyers · may be emptyThe buyer a buyer's version is for.
nametextIts name, as shown.
texttextThe text now.
leave_outtrue or falseLeft out of offers.
validity_dayswhole number · may be emptyFor the validity text: the number of days it states, from which “Valid until” is worked out.
buyer_terms_texttext · may be emptyThe sentence the offer prints when a buyer's documents set their own terms and the firm keeps its own.
reviewed_attime (ISO 8601, UTC) · may be emptyWhen a person marked it as reviewed.
reviewed_by_person_idreference · an id in people · may be emptyWho marked it.
guardrail_answersJSONQuestions Offerium asked about the wording that a person answered “Keep as is”, for which version, by whom and when.
removed_attime (ISO 8601, UTC) · may be emptyWhen a version for public tenders or a buyer was removed.
removed_by_person_idreference · an id in people · may be emptyWho removed it.
updated_by_person_idreference · an id in people · may be emptyWho last changed it.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
versionsrowsEvery wording it has had, oldest first; the last is the one in use.

Each row of versions:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
version_numberwhole number1 for the first wording, then counting up.
headingtext · may be emptyA section's heading in this version.
texttextThe wording.
tableJSON · may be emptyA table section's columns and rows in this version.
leave_outtrue or falseLeft out of offers in this version.
validity_dayswhole number · may be emptyFor the validity text: the number of days it states.
sourcechoiceHow the wording came about: when the account was opened, an edit, a restore of an earlier version, a proposal from sent offers, or recorded when history began.one of: opened, edit, restore, proposal, migration
restored_from_version_ididentifier · may be emptyThe earlier version it restored.
proposal_ididentifier · may be emptyThe proposal from sent offers it came from.
changed_by_person_idreference · an id in people · may be emptyWho wrote this version.
changed_attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.

Standard text history standard_text_history

Every change to a standard text, before and after, from the activity record.

Read from the activity record.

Files:data/standard_text_history.csvdata/standard_text_history.jsonJSON Schema

The fields (7)
FieldTypeMeaning
ididentifierThe activity record entry's identifier.
standard_text_idreference · an id in standard_textsThe text changed.
keytext · may be emptyWhich text.
previous_texttext · may be emptyThe text before.
texttext · may be emptyThe text after.
changed_by_person_idreference · an id in people · may be emptyWho changed it.
changed_attime (ISO 8601, UTC)When.

Additional sections offer_sections

The firm's own sections beyond the five standard texts (about us, clarifications, a schedule, a closing), their versions for public tenders and single buyers, and every wording each has had.

Files:data/offer_sections.csvdata/offer_sections.jsonJSON Schema

The fields (19)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
variant_of_section_idreference · an id in offer_sections · may be emptyFor a version: the section it is a version of.
variant_kindchoiceThe section itself, its version for public tenders, or its version for one buyer.one of: default, public_tender, buyer
buyer_idreference · an id in buyers · may be emptyThe buyer a buyer's version is for.
headingtextIts heading, as printed.
texttextIts words now.
kindchoiceWords, or a table (its words are then the lead-in).one of: text, table
tableJSON · may be emptyA table section's column headings and rows.
slotchoiceWhere in the offer it prints.one of: about_us, clarifications, schedule, closing
include_rulechoiceWhen it is included: always, when ticked on the bid, in public tenders only, or in private bids only.one of: always, when_ticked, public_only, private_only
positionwhole numberOrder on the screen, lowest first.
leave_outtrue or falseLeft out of offers.
guardrail_answersJSONQuestions Offerium asked about the wording that a person answered “Keep as is”.
archived_attime (ISO 8601, UTC) · may be emptyWhen it was removed.
archived_by_person_idreference · an id in people · may be emptyWho removed it.
updated_by_person_idreference · an id in people · may be emptyWho last changed it.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
versionsrowsEvery wording it has had, oldest first; the last is the one in use.

Each row of versions:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
version_numberwhole number1 for the first wording, then counting up.
headingtext · may be emptyA section's heading in this version.
texttextThe wording.
tableJSON · may be emptyA table section's columns and rows in this version.
leave_outtrue or falseLeft out of offers in this version.
validity_dayswhole number · may be emptyFor the validity text: the number of days it states.
sourcechoiceHow the wording came about: when the account was opened, an edit, a restore of an earlier version, a proposal from sent offers, or recorded when history began.one of: opened, edit, restore, proposal, migration
restored_from_version_ididentifier · may be emptyThe earlier version it restored.
proposal_ididentifier · may be emptyThe proposal from sent offers it came from.
changed_by_person_idreference · an id in people · may be emptyWho wrote this version.
changed_attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.

Company profile company_profile

One row: the firm as its letterhead prints it: legal name and form, register, officers, tax numbers, bank, address and logo. The logo file is under documents/. With it, the firm's own closed days and public-holiday choices (Region & formats), its Sending choices, its own pricing figures and the writing style Offerium learnt from its sent mail.

Also carried here: company_officers, company_closures, company_holiday_overrides, sending_settings, offer_number_sequences, company_pricing, tone_profiles, firm_rate_terms, company_tax_settings, company_tax_registrations.

Files:data/company_profile.csvdata/company_profile.jsonJSON Schema

The fields (58)
FieldTypeMeaning
legal_formchoice · may be emptyLegal form.one of: gmbh, ug, gmbh_co_kg, kg, ohg, ek, ag, einzelunternehmen, gbr, llc, corporation, partnership, sole_proprietorship, other
registered_nametext · may be emptyThe registered name.
dbatext · may be emptyThe name traded under, when different.
seattext · may be emptyRegistered seat.
register_courttext · may be emptyRegister court.
register_numbertext · may be emptyRegister number.
has_supervisory_boardtrue or falseThe firm has a supervisory board.
supervisory_chairtext · may be emptyChair of the supervisory board.
general_partner_nametext · may be emptyGeneral partner (a GmbH & Co. KG's GmbH).
general_partner_seattext · may be emptyIts seat.
general_partner_register_courttext · may be emptyIts register court.
general_partner_register_numbertext · may be emptyIts register number.
legal_linestext · may be emptyFurther statements printed at the foot.
vat_idtext · may be emptyVAT identification number.
vat_id_checked_valuetext · may be emptyThe number as last checked.
vat_id_checked_attime (ISO 8601, UTC) · may be emptyWhen it was checked.
vat_id_check_resultchoice · may be emptyWhat the check said.one of: valid, invalid, unavailable
tax_numbertext · may be emptyTax number.
print_tax_numbertrue or falsePrinted on offers.
eintext · may be emptyUS Employer Identification Number.
ibantext · may be emptyIBAN printed on offers.
bictext · may be emptyBIC.
bank_nametext · may be emptyBank.
print_banktrue or falseBank details printed on offers.
streettext · may be emptyStreet.
postcodetext · may be emptyPostal code.
citytext · may be emptyCity.
regiontext · may be emptyState or region.
countrytext · may be emptyCountry, ISO 3166 code.
phonetext · may be emptyPhone.
public_emailtext · may be emptyE-mail printed on offers.
websitetext · may be emptyWebsite.
no_logotrue or falseThe letterhead has no logo on purpose.
logo_content_typetext · may be emptyThe logo's media type.
logo_widthwhole number · may be emptyLogo width in pixels.
logo_heightwhole number · may be emptyLogo height in pixels.
logo_cropJSON · may be emptyHow the logo is cropped on the letterhead.
logo_uploaded_by_person_idreference · an id in people · may be emptyWho added the logo.
logo_uploaded_attime (ISO 8601, UTC) · may be emptyWhen.
logo_sha256text · may be emptySHA-256 of the logo file.
offer_templatechoiceThe firm's default offer layout.one of: classic, modern, proposal
offer_number_prefixtext · may be emptyThe prefix of the offer numbers; empty uses the firm's initials.
confidential_footertrue or falseOffers print “Confidential offer” and the page numbers in the footer.
acceptance_block_defaulttrue or falseOffers for private work print the acceptance and signature block.
prepared_with_offeriumtrue or falseOffers print “Prepared with Offerium” in the footer.
offer_numbersrowsPer year, the running number the next offer takes.

Each row of offer_numbers:

FieldTypeMeaning
yearwhole numberThe year.
next_numberwhole numberThe number the next offer that year takes.
updated_attime (ISO 8601, UTC)When the row last changed.
updated_by_person_idreference · an id in people · may be emptyWho last changed it.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
officersrowsThe people who represent the firm, as the letterhead names them.

Each row of officers:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
rolechoiceTheir role.one of: managing_director, general_partner_director, board_member, owner, partner
given_nametextGiven name.
family_nametextFamily name.
positionwhole numberOrder on the screen, lowest first.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
closuresrowsDays the firm is closed (company holidays), on which no bid goes out.

Each row of closures:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
starts_ontextFirst closed day, as a calendar date (YYYY-MM-DD).
ends_ontextLast closed day, as a calendar date (YYYY-MM-DD).
labeltext · may be emptyIts name, if given.
created_by_person_idreference · an id in people · may be emptyWho added it.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
holiday_overridesrowsPublic holidays on which the firm chose to be open, or closed, against its region's calendar.

Each row of holiday_overrides:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
holiday_keytextThe holiday, by Offerium's key for it.
office_opentrue or falseThe office is open that day.
updated_by_person_idreference · an id in people · may be emptyWho chose it.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
sendingrowsThe Sending page's choices: when bids go out, who signs the covering e-mail, and the copies. None until someone changes them.

Each row of sending:

FieldTypeMeaning
send_minute_of_daywhole numberThe time bids go out, in minutes after midnight in the firm's time zone.
working_days_beforewhole numberHow many working days before the buyer's deadline.
signerchoiceWho signs the covering e-mail: the bid's owner, the approver, or the firm.one of: bid_owner, approver, company
bcc_bid_ownertrue or falseThe bid's owner gets a copy (Bcc) of each bid sent.
bcc_archive_addresstext · may be emptyAn archive address that gets a copy (Bcc) of each bid sent.
updated_by_person_idreference · an id in people · may be emptyWho last changed them.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
pricingrowsThe firm's own pricing figures, once someone saves them: labour rates per role, the minimum margin a market estimate's lowest option keeps above the cost, and whether earlier prices older than twelve months are brought up to date by an official price index. None until someone saves them.

Each row of pricing:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
labour_ratesJSONPer role, the firm's own cost of an hour, in the currency's minor unit (cents).
minimum_margin_pctwhole numberThe minimum margin, in per cent.
escalation_ontrue or falseEarlier prices older than twelve months are brought up to date: by an official price index, or by the firm's own yearly increase where own_increase_permille gives one.
own_increase_permillewhole number · may be emptyThe firm's own yearly price increase in tenths of a percent (35 is 3.5 %, at most 250), when it brings earlier prices up to date by that instead of the index; empty for the index, or when that is off.
abroad_premium_bpswhole number · may be emptyThe firm's own premium on the hours on site of a short job abroad (up to 14 days on site abroad), in hundredths of a percent (3500 is 35 %, at most 20000); empty is automatic.
rates_includelist of text · may be emptyWhat the firm's hourly rates hold beside the work: travel_abroad (travel to a job abroad), lodging, meals, tools_ppe (tools and protective gear), fahrzeit (travel time), anfahrt (travel to a site nearby), kleinmaterial (small parts); empty is automatic.
premiums_includedlist of text · may be emptyThe time bands whose premium the firm's hourly rates already hold (overtime, night, saturday, sunday, holiday); empty is automatic.
mobilisation_feeJSON · may be emptyThe firm's fee per worker for a job abroad: its amount in the currency's minor unit, the currency, and whether a worker who comes back pays it again; empty is automatic.
travel_time_billedtrue or false · may be emptyWhether travel time is billed; empty is automatic.
contingency_bpswhole number · may be emptyThe firm's own contingency on lump sums, in hundredths of a percent (1000 is 10 %, at most 10000); empty is automatic.
crew_countrytext · may be emptyWhere the firm's crew is employed (ISO 3166 country code), when it is not the firm's own country; empty is the firm's own.
updated_by_person_idreference · an id in people · may be emptyWho last changed them.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
tonerowsThe writing style Offerium learnt from the firm's own sent mail, which its drafts are written in: how formal, the greetings and sign-offs, the sentence length, and short phrases the firm prefers or avoids, each one found in the firm's own mail. No whole message is kept. None until it has been learnt.

Each row of tone:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
marketchoiceThe market it was learnt for.one of: us, de
statuschoiceLearnt, or too little of the firm's sent mail to learn from (fewer than eight texts): the drafts then use a neutral style.one of: learnt, insufficient
profileJSON · may be emptyThe style: formality, greetings, sign-offs, sentence length, the phrases preferred and avoided, and whether first names are used.
learnt_fromJSONHow many of the firm's messages, sent covering e-mails and edited e-mails it was learnt from. Counts only.
source_message_idslist of textThe messages it was learnt from, by Offerium's identifier.
learnt_attime (ISO 8601, UTC)When it was learnt.
updated_attime (ISO 8601, UTC)When the row last changed.
rate_termsrowsThe firm's own words for its rates, which a person asked Offerium to remember (“KD-Techniker” is a monteur): Offerium reads them before its own word lists.

Each row of rate_terms:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
phrase_foldedtextThe words, in lower case with umlauts written out.
fieldchoiceWhat they set: the level, the time, the kind, the supply scope, the material class or what is included.one of: grade, band, kind, supply_scope, item_class, includes
valuetextThe value they set.
created_by_person_idreference · an id in people · may be emptyWho asked for it.
created_attime (ISO 8601, UTC)When the row was written.
tax_settingsrowsThe firm's own tax settings: whether it charges no VAT as a small business (§ 19 UStG), and two US state facts. At most one row.

Each row of tax_settings:

FieldTypeMeaning
kleinunternehmertrue or falseThe firm charges no VAT under § 19 UStG.
kleinunternehmer_sincetext · may be emptySince when (YYYY-MM-DD).
kleinunternehmer_confirmed_yearwhole number · may be emptyThe year a person last confirmed it.
us_ne_optionwhole number · may be emptyNebraska's contractor option (1, 2 or 3).
us_cleaning_volumetrue or false · may be emptyOhio: the firm's building maintenance and cleaning receipts reach $5,000 a year.
set_by_person_idreference · an id in people · may be emptyWho set them.
set_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
tax_registrationsrowsThe firm's VAT or sales-tax registrations and establishments outside its seat (an Austrian UID, a Swiss MWST number, a US state permit).

Each row of tax_registrations:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
countrytextThe country (ISO 3166-1 alpha-2).
regiontext · may be emptyThe US state, two letters.
numbertext · may be emptyThe registration number.
establishmenttrue or falseThe firm has a fixed establishment there.
registered_sincetext · may be emptySince when (YYYY-MM-DD).
set_by_person_idreference · an id in people · may be emptyWho entered it.
set_attime (ISO 8601, UTC)When.
created_attime (ISO 8601, UTC)When the row was written.

Selling rates rate_cards

The firm's own selling rates: one list for every customer and, where kept, one per kind of customer, with every value each has had. Values are taken from the firm's own offers in the background or set by a person, whose value wins; a value is never changed in place, so a line priced from one can be checked against it.

Also carried here: rate_card_entries.

Files:data/rate_cards.csvdata/rate_cards.jsonJSON Schema

The fields (14)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
buyer_kindchoice · may be emptyThe kind of customer the list is for; empty for every customer.one of: private_person, property_manager, housing_company, commercial, industrial, public, general_contractor, facility_manager, other
locationtext · may be emptyThe country whose jobs the list prices (ISO 3166 alpha-2, “AT”); empty is the firm's home country. A job in another country never takes the home list's plain rates.
currencytext · may be emptyThe currency the list's amounts are in (ISO 4217), where it is not the firm's own; empty is the firm's.
nametext · may be emptyIts name, when a person gave one.
unspecified_gradechoice · may be emptyWhat an hour with no level, or a trade word, counts as; empty when Offerium asks each time.one of: leitung, meister, vorarbeiter, techniker, monteur, helfer, azubi, facility, trade, unspecified
combine_rulechoiceWhen a line falls under two surcharged times the list states one by one: the highest, both added, or ask.one of: highest, additive, ask
aw_minuteswhole number · may be emptyMinutes per Arbeitswert (AW), when the firm bills so.
copperJSON · may be emptyWhether cable prices carry a copper clause, and its basis per 100 kg.
settings_set_by_person_idreference · an id in people · may be emptyWho last changed these settings.
settings_set_attime (ISO 8601, UTC) · may be emptyWhen.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
entriesrowsEvery value, current and earlier.

Each row of entries:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
entry_keytextThe value's identity as one canonical text.
kindchoiceWhat kind of rate: labour, crew, travel, travel_time, callout, standby, surcharge, markup or small_parts.one of: labour, crew, travel, travel_time, callout, standby, surcharge, markup, small_parts
gradechoice · may be emptyThe level, for an hour.one of: leitung, meister, vorarbeiter, techniker, monteur, helfer, azubi, facility, trade, unspecified
crewJSON · may be emptyFor a crew: each level and how many.
bandlist of textThe time it is for; an empty list is normal hours.
includeslist of textWhat it includes: anfahrt, fahrzeit, kleinmaterial.
unit_keytext · may be emptyIts unit, in Offerium's words.
unit_scalewhole numberHow many units one value is for.
unit_periodchoice · may be emptyA period beside the unit.one of: month, quarter, year, visit
modechoiceAn amount, a percentage, or included (Kleinmaterial “inklusive”).one of: amount, percent, included
amountamount · may be emptyThe amount.
pct_bpswhole number · may be emptyThe percentage, in hundredths of a percent.
pct_basechoice · may be emptyWhat the percentage is on.one of: labour, material, ek, list, proof, total, unknown
billing_increment_minuteswhole number · may be emptyThe steps hours are billed in, in minutes.
min_billable_minuteswhole number · may be emptyThe least time billed, in minutes.
zonetext · may be emptyA travel zone (“Zone 1”, “bis 15 km”).
descriptiontextThe value as the list shows it.
positionwhole numberOrder on the screen, lowest first.
originchoiceTaken from the firm's own offers in the background, or set by a person.one of: seeded, person
seeded_fromJSONFor a value taken from the firm's offers: each pricing decision it was taken from (the line, the offer, the rate, the month and the result).
seeded_attime (ISO 8601, UTC) · may be emptyWhen it was taken.
set_by_person_idreference · an id in people · may be emptyWho set it, when a person did.
set_attime (ISO 8601, UTC) · may be emptyWhen.
valid_fromtextThe day it holds from (YYYY-MM-DD).
superseded_attime (ISO 8601, UTC) · may be emptyWhen another value replaced it; empty while it is current.
superseded_reasonchoice · may be emptyWhy: taken again from newer offers, changed by a person, or removed by a person (then never taken again).one of: reseeded, person_changed, person_removed
created_attime (ISO 8601, UTC)When the row was written.

People people

Everyone at the firm in Offerium, including people removed, with what they may do and the terms they accepted. How anyone signs in is never exported, nor each person's own choices of what reaches them and when.

Also carried here: terms_acceptances.

Files:data/people.csvdata/people.jsonJSON Schema

The fields (20)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
nametextFull name.
first_nametextFirst name, as used in greetings.
emailtextE-mail address.
job_titletext · may be emptyJob title, as printed on offers.
direct_phonetext · may be emptyDirect phone number.
is_ownertrue or falseThe account's owner.
can_approvetrue or falseMay approve bids.
invited_attime (ISO 8601, UTC) · may be emptyWhen they were invited.
joined_attime (ISO 8601, UTC) · may be emptyWhen they first signed in.
removed_attime (ISO 8601, UTC) · may be emptyWhen they were removed.
removed_by_person_idreference · an id in people · may be emptyWho removed them.
signature_content_typetext · may be emptyTheir signature image's media type, if they added one for the offers they sign.
signature_widthwhole number · may be emptyIts width in pixels.
signature_heightwhole number · may be emptyIts height in pixels.
signature_uploaded_attime (ISO 8601, UTC) · may be emptyWhen they added it.
signature_sha256text · may be emptySHA-256 of the signature image file.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
terms_acceptedrowsThe terms and data processing agreement they accepted for the firm.

Each row of terms_accepted:

FieldTypeMeaning
terms_versiontextVersion of the terms.
dpa_versiontextVersion of the data processing agreement.
langtextLanguage accepted in.
accepted_attime (ISO 8601, UTC)When.

Mailboxes mailboxes

The mailboxes Offerium reads or suggested, by address and kind only. The keys Offerium held for them are never exported.

Files:data/mailboxes.csvdata/mailboxes.jsonJSON Schema

The fields (7)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
addresstextThe address.
kindchoiceShared, or one person's own; an earlier third kind is no longer created.one of: shared, personal, forwarded
owner_person_idreference · an id in people · may be emptyWhose own mailbox it is, for a personal one.
is_sending_addresstrue or falseOffers go out from it.
connected_attime (ISO 8601, UTC) · may be emptyWhen it was connected.
created_attime (ISO 8601, UTC)When the row was written.

Calendar events calendar_events

Deadlines and site walks on the Bids calendar. The same events are in calendar/bids.ics.

Files:data/calendar_events.csvdata/calendar_events.jsonJSON Schema

The fields (14)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
kindchoiceA bid's deadline, or someone's attendance (a site walk).one of: bid, attendance
titletextThe event's title.
descriptiontext · may be emptyIts description.
starts_attime (ISO 8601, UTC)Start.
ends_attime (ISO 8601, UTC) · may be emptyEnd.
all_daytrue or falseAn all-day event.
invitee_person_idreference · an id in people · may be emptyWho is invited.
provider_event_idtext · may be emptyThe event's identifier in the firm's own calendar.
last_synced_attime (ISO 8601, UTC) · may be emptyWhen it was last written to that calendar.
deleted_attime (ISO 8601, UTC) · may be emptyWhen it was removed.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.

Drive choices drive_choices

Where approvers chose to save approved packages in the firm's own drive, and each save made there with the files it wrote.

Also carried here: drive_saves, drive_save_files.

Files:data/drive_choices.csvdata/drive_choices.jsonJSON Schema

The fields (16)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bids · may be emptyFor this bid only, when set.
scopechoiceThis bid, every bid from then on, or ask at each approval.one of: this_bid, every_bid, ask
providerchoice · may be emptyWhere the folder is: Google Drive, SharePoint or OneDrive.one of: google_drive, sharepoint, onedrive
web_urltext · may be emptyThe folder's web address at the provider.
folder_labeltextThe folder, as shown.
provider_folder_idtext · may be emptyThe folder's identifier in the firm's drive.
is_shared_drivetrue or falseA shared drive.
chosen_by_person_idreference · an id in peopleWho chose it.
chosen_attime (ISO 8601, UTC)When.
stopped_attime (ISO 8601, UTC) · may be emptyWhen saving there stopped.
stopped_by_person_idreference · an id in people · may be emptyWho stopped it.
last_saved_attime (ISO 8601, UTC) · may be emptyWhen a bid was last saved there.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
savesrowsEach approved bid saved to this folder, with the files it wrote.

Each row of saves:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
send_idreference · an id in sends · may be emptyThe send it was saved for.
approval_idreference · an id in approvals · may be emptyThe approval that asked for it.
folder_pathtextThe folder it was written into, below the chosen one.
file_countwhole numberHow many files it was to write.
files_writtenwhole numberHow many it wrote.
started_attime (ISO 8601, UTC)When it started.
saved_attime (ISO 8601, UTC) · may be emptyWhen every file was written.
created_attime (ISO 8601, UTC)When the row was written.
filesrowsThe files written.

Each row of files:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
relative_pathtextIts path inside the bid's folder.
filenametextIts file name.
content_typetext · may be emptyIts media type.
byte_sizewhole number · may be emptyIts size in bytes.
sha256text · may be emptyIts SHA-256.
web_urltext · may be emptyIts web address at the provider.
written_attime (ISO 8601, UTC) · may be emptyWhen it was written.
created_attime (ISO 8601, UTC)When the row was written.

Invoices from Offerium invoices

Offerium's invoices to the firm, with the bids each one counted, the reminders sent about it and any credit note that corrected it. The PDFs (and e-invoices) of both are under billing/invoices/<year>/. German law has you keep them eight years (§ 14b UStG).

Also carried here: invoice_bids, dunning_notices, credit_notes.

Files:data/invoices.csvdata/invoices.jsonJSON Schema

The fields (42)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
numbertextInvoice number.
statustextPaid, open, void or uncollectible.
kindtextA plan invoice, a change of plan, bids beyond the plan, an Enterprise agreement, or one issued by hand.
planchoice · may be emptyThe plan billed.one of: desk, growth, enterprise
billing_periodchoice · may be emptyMonthly or annual.one of: monthly, annual
period_starttime (ISO 8601, UTC) · may be emptyStart of the period billed.
period_endtime (ISO 8601, UTC) · may be emptyEnd of the period billed.
collection_methodtextCharged automatically, or sent for payment by transfer.
currencytextISO 4217 currency code.
subtotalamountNet amount, after any discount: what the tax is charged on.
discountamountDiscount taken off the lines before tax (a promotion code); 0 without one.
taxamountTax.
totalamountTotal, tax included.
amount_dueamountAmount due.
amount_paidamountAmount paid.
tax_rate_bpswhole number · may be emptyTax rate in hundredths of a percent (1900 = 19 %).
taxability_reasontext · may be emptyWhy tax was or was not charged (reverse charge, for example).
po_numbertext · may be emptyYour purchase order number, as printed.
due_attime (ISO 8601, UTC) · may be emptyDue date.
finalized_attime (ISO 8601, UTC)Date of issue.
paid_attime (ISO 8601, UTC) · may be emptyWhen it was paid.
voided_attime (ISO 8601, UTC) · may be emptyWhen it was voided.
attempt_countwhole numberPayment attempts.
next_attempt_attime (ISO 8601, UTC) · may be emptyThe next payment attempt.
first_failed_attime (ISO 8601, UTC) · may be emptyWhen a payment first failed.
last_failed_attime (ISO 8601, UTC) · may be emptyWhen a payment last failed.
failure_classtext · may be emptyWhy the payment failed, as a key.
credited_amountamountAmount credited back.
credit_note_numbertext · may be emptyThe credit note's number.
formatchoicePDF, ZUGFeRD (a PDF carrying the invoice data) or XRechnung (XML).one of: pdf, zugferd, xrechnung
einvoice_validated_attime (ISO 8601, UTC) · may be emptyWhen the e-invoice passed validation.
eur_ratetext · may be emptyWhen an invoice in another currency charges German VAT: the euro reference rate its VAT is also stated in euros at (1 EUR = this many units of its currency). Its credit notes use the same rate.
eur_rate_daytext · may be emptyThe day of that rate (YYYY-MM-DD).
eur_rate_sourcechoice · may be emptyWhere that rate is from: ecb, the European Central Bank.one of: ecb
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
sha256text · may be emptySHA-256 of the PDF.
einvoice_sha256text · may be emptySHA-256 of the e-invoice file, when there is a separate one.
bidsrowsThe bids this invoice counted: within the allowance, or charged as overage.

Each row of bids:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
rolechoiceWithin the allowance, or charged.one of: included, charged
counted_attime (ISO 8601, UTC)When the bid was counted.
overage_charge_idreference · an id in overage_charges · may be emptyThe overage charge, when charged.
amountamount · may be emptyAmount, when charged.
created_attime (ISO 8601, UTC)When the row was written.
remindersrowsReminders Offerium sent about this invoice.

Each row of reminders:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
stagetextWhich reminder.
fired_attime (ISO 8601, UTC)When it was sent.
detailJSON · may be emptyWhat it said, as recorded.
credit_notesrowsCredit notes against this invoice: invoice corrections, such as a refund under the 30-day money-back guarantee. Each one's file is under billing/invoices/<year>/ beside the invoice's.

Each row of credit_notes:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
numbertextCredit note number.
issued_attime (ISO 8601, UTC)Date of issue.
currencytextISO 4217 currency code.
subtotalamountNet amount credited, after any discount.
taxamountTax credited.
totalamountTotal credited, tax included.
reasontext · may be emptyWhy it was issued, as the payment provider's key (product_unsatisfactory for the 30-day guarantee).
formatchoicePDF, ZUGFeRD or XRechnung, as the firm's invoices.one of: pdf, zugferd, xrechnung
sha256text · may be emptySHA-256 of the PDF.
einvoice_sha256text · may be emptySHA-256 of the e-invoice file, when there is a separate one.
created_attime (ISO 8601, UTC)When the row was written.

Billing details billing_details

One row: the address and tax number Offerium's invoices carry, how they are delivered and paid, who receives them, an Enterprise contract where there is one, and each “Research deeper” run, included or charged. A card's number is never held by Offerium; only its brand and last four digits.

Also carried here: billing_contacts, enterprise_contracts, research_charges.

Files:data/billing_details.csvdata/billing_details.jsonJSON Schema

The fields (33)
FieldTypeMeaning
legal_nametext · may be emptyThe name invoices are made out to.
address_differstrue or falseThe billing address differs from the letterhead's.
address_line1text · may be emptyAddress, first line.
address_line2text · may be emptyAddress, second line.
postal_codetext · may be emptyPostal code.
citytext · may be emptyCity.
statetext · may be emptyState or region.
countrytext · may be emptyCountry, ISO 3166 code.
tax_id_typetext · may be emptyWhich tax number (EU VAT, US EIN …).
tax_id_valuetext · may be emptyThe tax number.
tax_id_verificationtext · may be emptyWhat the tax authority's check said.
tax_id_checked_attime (ISO 8601, UTC) · may be emptyWhen it was checked.
tax_id_verified_nametext · may be emptyThe name the check returned.
tax_exempttextTaxed normally, exempt, or reverse charge.
po_numbertext · may be emptyPurchase order number printed on invoices.
invoice_formatchoiceThe invoice format chosen.one of: pdf, zugferd, xrechnung
alert_near_allowancetrue or falseTell us near the plan's allowance.
alert_at_allowancetrue or falseTell us at the plan's allowance.
ask_before_overagetrue or falseAsk before a bid is charged as overage.
payment_method_typetext · may be emptyCard, SEPA direct debit, PayPal or transfer.
payment_brandtext · may be emptyThe card's brand.
payment_wallettext · may be emptyThe wallet used (Apple Pay, Google Pay), if any.
payment_last4text · may be emptyThe last four digits.
payment_exp_monthwhole number · may be emptyCard expiry month.
payment_exp_yearwhole number · may be emptyCard expiry year.
payment_countrytext · may be emptyThe payment method's country.
sepa_mandate_referencetext · may be emptyThe SEPA mandate's reference.
updated_by_person_idreference · an id in people · may be emptyWho last changed them.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
contactsrowsWho receives invoices, payment notices and usage alerts.

Each row of contacts:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
person_idreference · an id in people · may be emptyThe person, when they are one of the firm's people.
nametextName.
emailtextE-mail address.
receives_invoicestrue or falseReceives invoices.
receives_paymenttrue or falseReceives payment notices.
receives_usagetrue or falseReceives usage alerts.
is_primarytrue or falseThe primary billing contact.
added_by_person_idreference · an id in people · may be emptyWho added them.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
removed_attime (ISO 8601, UTC) · may be emptyWhen they were removed.
removed_by_person_idreference · an id in people · may be emptyWho removed them.
contractsrowsAn Enterprise contract's terms, where there is one.

Each row of contracts:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
referencetextThe contract's reference.
starts_ontime (ISO 8601, UTC)Start.
ends_ontime (ISO 8601, UTC) · may be emptyEnd.
bids_includedwhole numberBids included per period.
allowance_periodchoiceThe allowance's period.one of: monthly, annual
priceamountPrice per invoice interval.
currencytextISO 4217 currency code.
invoice_intervaltextHow often it is invoiced.
collection_methodtextCharged automatically, or paid by transfer.
payment_terms_dayswhole numberDays to pay.
overage_priceamount · may be emptyPrice per bid beyond the allowance.
research_includedwhole number · may be empty“Research deeper” runs included a month; empty is the Enterprise default of 20.
signed_attime (ISO 8601, UTC) · may be emptyWhen it was signed.
notestext · may be emptyNotes on the contract.
created_attime (ISO 8601, UTC)When the row was written.
updated_attime (ISO 8601, UTC)When the row last changed.
research_chargesrowsEach “Research deeper” run, one row each: included in the plan's runs for its month, or charged, and on which invoice.

Each row of research_charges:

FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bids · may be emptyThe bid it was run for; empty if that bid was deleted.
includedtrue or falseNo charge: one of the plan's runs for the month, or one of the free analysis's runs.
free_analysistrue or falseOne of the free analysis's runs, on the request analysed in full before a plan: never charged, and not one of a plan's runs.
amountamount · may be emptyAmount charged; empty when included.
currencytextISO 4217 currency code.
invoice_idreference · an id in invoices · may be emptyThe invoice that charged it; empty when included, or while it waits for the next invoice.
payment_item_idtext · may be emptyThe line's reference at Offerium's payment provider.
created_attime (ISO 8601, UTC)When the row was written.

Overage charges overage_charges

Bids charged beyond the plan's allowance.

Files:data/overage_charges.csvdata/overage_charges.jsonJSON Schema

The fields (6)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
bid_idreference · an id in bidsThe bid this belongs to.
amountamountAmount charged.
currencytextISO 4217 currency code.
payment_item_idtextThe line's reference at Offerium's payment provider.
created_attime (ISO 8601, UTC)When the row was written.

Activity record audit_log

The record B.21 promises: approvals and holds, changes, exports, people added and removed, connections, hand-overs and deletions, with Offerium's own steps. Append-only. What is about one person rather than the firm's work — how they sign in, their sessions, the pages they opened, their e-mail choices — is left out, as the Activity page leaves it out. So is what Offerium recorded about mail that arrived only in a person's own mailbox and never became a bid.

Files:data/audit_log.csvdata/audit_log.jsonJSON Schema

The fields (7)
FieldTypeMeaning
ididentifierOfferium's identifier for this row.
attime (ISO 8601, UTC)When.
actiontextWhat happened, as a key ("export.prepared").
subjecttextThe identifier of the thing it happened to.
actor_person_idreference · an id in people · may be emptyWho did it.
actor_contexttext · may be emptyHow it was done, when not by a person (a job, the reader).
detailJSON · may be emptyWhat changed, as recorded.

How the files are written

One ZIP
One ZIP file with one top folder, offerium-<firm>-<date>/. Above 4 GB it is ZIP64, which every current system opens. Files that are already compressed (PDF, images, Office files) are stored as they are.
Text
UTF-8 everywhere. File names are Unicode NFC; characters Windows cannot hold in a name (< > : " / \ | ? *) are replaced by an underscore.
CSV
RFC 4180 with a byte-order mark and CRLF line ends, so Excel opens it directly. The separator is a comma in a US archive and a semicolon in a German one, and amounts use the market's decimal mark. A cell that begins with = + - @ is prefixed with an apostrophe so no spreadsheet runs it as a formula. The first row names the fields.
JSON
RFC 8259: an array of objects, one row per line, with the same fields as the CSV. Amounts are whole numbers in the currency's minor unit (cents); times are ISO 8601 in UTC; empty values are null.
Identifiers
Every row has an id; a field ending in _id holds the id of a row in another entity, so the files join without Offerium.
Checking a file
manifest.json lists every file with its SHA-256. Check one with sha256sum <file> (macOS: shasum -a 256, Windows: Get-FileHash). A copied document's hash is the one Offerium held for it from the day it arrived.

Never in an export

Some things Offerium holds are never exported, and each for a reason:

  • Sign-ins, sessions, mailbox keys and device keys: a door, not a record, and useful only to an attacker. account, session, user, verificationToken, authenticator, mailbox_grants, tenant_grants, sign_in_codes, session_handoffs, push_subscriptions, imap_credentials, storage_grants, calendar_subscriptions, admin_requests, document_upload_links, admin_request_mailboxes, invitations
  • Offerium's own machinery (queues, alerts, rate counters, payment-provider events, notification deliveries): about Offerium, not about the firm. jobs, ops_alerts, worker_heartbeats, rate_limits, payment_events, notification_deliveries, billing_deliveries, market_refresh_runs, market_research_runs
  • Not the firm's: kept before anyone belonged to a firm. mail_domain_lookups, early_access_requests, signup_invitations, provider_waitlist, seller_invoices, price_indices, free_bid_claims, guarantee_claims, signup_reviews, erased_forwarding_addresses, market_facts, ted_notices
  • Who opened what, per person: a security record about individual people, not part of the firm's bids. access_log
  • The exports themselves; the activity record lists each one. data_exports, data_export_parts, data_export_entries
  • Mail Offerium checked and left alone was never kept, so it cannot be exported. Other firms' data is never in your export.

Where Offerium’s other records go

Every other table Offerium keeps for a firm, and where its contents are in an archive:

stored_files
as files · Every file Offerium kept, as the file itself; its SHA-256 is in manifest.json.
attachments
as files · Attachments as received, under each bid's tender/ folder and inside its rebuilt messages.
messages
as files · The kept bid messages, rebuilt as .eml files under each bid's mail/ folder, with their Message-ID and the Message-IDs of the messages they answer (in_reply_to, reference_ids) as In-Reply-To and References headers.
bid_tax_facts
in bids · In bids (tax_facts).
line_tax_facts
in priced_lines · In priced_lines (tax_facts).
buyer_tax_facts
in buyers · In buyers (tax_facts).
buyer_surcharge_terms
in buyers · In buyers (surcharge_terms).
tax_certificates
in buyers · In buyers (tax_certificates).
outcome_evidence
in bids · In bids (outcome_evidence) and past_bids (outcome_evidence).
company_tax_settings
in company_profile · In company_profile (tax_settings).
company_tax_registrations
in company_profile · In company_profile (tax_registrations).
package_files
in package_versions · In package_versions (files), and as files under offer-as-sent/.
priced_forms
in priced_lines · On each priced line (form_*).
extracted_facts
in bids · In bids (facts).
addenda
in bids · In bids (addenda).
approval_requests
in bids · In bids (approval_requests).
client_form_lines
in bids · In bids (client_form_lines).
buyer_standing_requirements
in buyers · In buyers (standing_requirements).
terms_acceptances
in people · In people (terms_accepted).
company_document_versions
in company_documents · In company_documents (versions), and each version's file under documents/.
company_profiles
in company_profile · In company_profile.
company_officers
in company_profile · In company_profile (officers).
company_closures
in company_profile · In company_profile (closures).
company_holiday_overrides
in company_profile · In company_profile (holiday_overrides).
sending_settings
in company_profile · In company_profile (sending).
drive_saves
in drive_choices · In drive_choices (saves).
drive_save_files
in drive_choices · In drive_choices (saves, files).
invoice_bids
in invoices · In invoices (bids).
dunning_notices
in invoices · In invoices (reminders).
credit_notes
in invoices · In invoices (credit_notes), and each one's file under billing/invoices/<year>/.
line_comparables
in bids · In bids (comparables).
bid_readings
in bids · In bids (readings).
offer_word_drafts
in bids · In bids (words).
price_estimates
in bids · In bids (estimates).
price_estimate_lines
in bids · In bids (estimates, lines).
price_estimate_plans
in bids · In bids (estimates: crew_plan, crew_plan_by_person_id, crew_plan_at): a person's change of the crew plan. The rest of it, the checked plan behind each estimate with Offerium's own checks of it, is Offerium's working, derived from the estimate's lines and reasons, and never exported.
company_pricing
in company_profile · In company_profile (pricing).
tone_profiles
in company_profile · In company_profile (tone).
bid_fit_advice
in bids · In bids (fit_advice).
price_choices
in bids · In bids (price_choices).
firm_rate_terms
in company_profile · In company_profile (rate_terms).
line_benchmarks
in past_bids · In past_bids (benchmarks).
past_offer_records
left out: Offerium’s own machinery · Offerium's own short note of each past offer, written by a model from the offer so that a later estimate can compare with it. The offers themselves are in past_bids, priced_lines and files.
rate_card_entries
in rate_cards · In rate_cards (entries).
framework_contract_buyers
in framework_contracts · In framework_contracts (buyers).
framework_contract_rates
in framework_contracts · In framework_contracts (rates).
research_charges
in billing_details · In billing_details (research_charges): every run, included or charged, with the invoice that charged it.
billing_contacts
in billing_details · In billing_details (contacts).
enterprise_contracts
in billing_details · In billing_details (contracts).
document_candidates
left out: Offerium’s own machinery · Files Offerium proposed as company documents from your past offers or your certificates folder; the ones you added are in company_documents, and every file is under documents/ or files/.
ai_calls
left out: Offerium’s own machinery · A record of each reading or drafting request Offerium made for your firm: when, for what, which model, how many units and what it cost. It never holds the content.
storage_pauses
left out: Offerium’s own machinery · When Offerium paused importing the firm's mail or past offers because its storage had no room, why, and when it read on.
usage_alerts
left out: Offerium’s own machinery · The allowance alerts Offerium showed; what was counted is in invoices (bids).
forwarding_aliases
left out: Offerium’s own machinery · Addresses Offerium set aside for the firm before its name was corrected during setup; they stay the firm's.
companies
in README.html and manifest.json · The firm's name, market, currency and time zone, in README.html and manifest.json. Its billing identifiers are Offerium's, and so are its notes on the free first bid: whether it was withheld because the firm's domain, Microsoft 365 tenant or Google Workspace had already had one, and which bid was read in full before a plan. When Offerium deleted its keys to the firm's mailboxes after a plan ended is in the activity record.
ownership_transfers
in the activity record · Hand-overs of the account are in the activity record.
package_checks
left out: Offerium’s own machinery · The checks Offerium ran on a package before it went out; their result is in approvals and the timeline.
onboarding
left out: Offerium’s own machinery · Where setting up had got to, and how the first request came in.
rebuilds
left out: Offerium’s own machinery · Counters of the first read of your sent mail; what it found is in past_bids and buyers.
old_quotes_sources
left out: Offerium’s own machinery · Counters of the read of your old-quotes folder; what it found is in past_bids.
request_packages
left out: Offerium’s own machinery · Big request packages added to a bid (a ZIP, a folder, a SharePoint or Drive folder): what each held, which documents were copied and what stayed where it was. The copied documents are with the bid's files.
request_package_files
left out: Offerium’s own machinery · Which of a bid's files came from which package.
document_sources
left out: Offerium’s own machinery · The folders you chose for certificates and for new requests under File storage.
document_source_items
left out: Offerium’s own machinery · The files Offerium saw in your certificates folder and when each last changed; the ones it proposed are in document_candidates.
mailbox_events
left out: Offerium’s own machinery · Each mailbox's connection log (connected, missed changes, access withdrawn, disconnected); what people did is in audit_log.
calendar_connections
left out: Offerium’s own machinery · How the Bids calendar is connected to the firm's own calendar and what its events show; the events are in calendar_events and calendar/bids.ics.
mailbox_connect_requests
in the activity record · The owner's requests that a person connect their own mailbox are in the activity record.
mailbox_send_agreements
in the activity record · A person's agreement that bids may go out from their own mailbox, and its withdrawal, are in the activity record.
mailbox_handovers
in the activity record · Who took over the open bids of a mailbox that could no longer send is in the activity record; each bid's choice is in bids (sending_choice).
source_removals
in the activity record · Mail deleted with a disconnected personal mailbox (counts only): the disconnection is in the activity record, and bids and past_bids name it (source_removal_id).
join_requests
left out: not the firm’s · Requests to join from people outside the firm; once added, a person is in people.
account_erasures
left out: not the firm’s · Receipts of firms already deleted: a firm that can export has none.
document_demand
left out: Offerium’s own machinery · Counts of how often your buyers' invitations asked for each kind of document (“Your buyers ask for these”), worked out from the bids and requirements in this archive.
document_absences
in the activity record · Your answers “We don't hold this” and “Not relevant to us” for a kind of document, with who and when, are in the activity record.
document_reminders
left out: Offerium’s own machinery · The document reminders Offerium decided and sent; the documents, their dates and their keepers are in company_documents.
quarantined_uploads
left out: Offerium’s own machinery · Files an issuer sent through an upload link, held in quarantine until a person checks them. An accepted one is a version in company_documents, its file under documents/; one not accepted (not yet checked, rejected, or refused by the malware scan) is not in the archive: it never became the firm's.
profile_proposals
left out: Offerium’s own machinery · Values Offerium found for your letterhead on your website, in past offers and in e-mail signatures. The ones you used are in company_profile, with their source; what you did with each is in the activity record.
standard_text_versions
in standard_texts · In standard_texts (versions) and offer_sections (versions).
bid_section_choices
in bids · In bids (section_choices).
text_proposals
left out: Offerium’s own machinery · Wordings Offerium proposed from your sent offers. One you used is a version in standard_texts or offer_sections, which names it; one you dismissed is in the activity record.
first_run_states
left out: Offerium’s own machinery · Whether a person hid the optional items of the “Before your first bid goes out” checklist, and when setup was first complete.
memberships
left out: part of signing in · Which sign-in belongs to which person: part of signing in.

Earlier formats

An archive of an earlier format reads as described above, except where it differed. Each earlier format is listed with what it held differently from the format after it; its own schema/ folder describes it too.

archive-16

Bids bids
Did not yet say who checked a mail that looked like a trap with the buyer, and when (trust_confirmed_at, trust_confirmed_by_person_id).

archive-15

Bids bids
The package_state of its estimates' lines did not yet take in_total or added_in_total.
Priced lines priced_lines
Its package_state did not yet take in_total or added_in_total.

archive-14

Bids bids
Did not yet carry the firm's earlier offer for the same request (earlier_offer); its addenda did not yet say whether one is a re-issue (kind), and the package_state of its estimates' lines did not yet take option.
Priced lines priced_lines
Its package_state did not yet take option, and it did not yet carry an option counted into the total (option_in_total, option_in_total_at, option_in_total_by_person_id) or the scenario its form prices (form_scenario).
Selling rates rate_cards
Did not yet carry the country a list prices jobs in (location) or the currency of its amounts (currency).
Past bids past_bids
Did not yet carry the country of the job's site (site_country).

archive-13

Bids bids
Its estimates did not yet carry the exchange rate between euros and Swiss francs their market figures were converted at (home_fx).

archive-12

Company profile company_profile
Its pricing did not yet carry how the firm bills (rates_include, premiums_included, mobilisation_fee, travel_time_billed, contingency_bps) or where its crew is employed (crew_country).
Bids bids
Did not yet carry the currency the bid is offered in and its exchange rate (offer_currency, fx), nor did its estimates.

archive-11

Bids bids
Its client_form_lines did not yet carry bidder_cell, nor its estimates' lines package_state and package_quote.
Priced lines priced_lines
Did not yet carry package_state and package_quote.

archive-10

Company profile company_profile
Did not yet carry the firm's own premium for a short job abroad (pricing.abroad_premium_bps).
Bids bids
Its estimates did not yet carry a person's crew plan (crew_plan, crew_plan_by_person_id, crew_plan_at).

archive-9

Bids bids
Did not yet carry when the bid's trade was checked or the kind of work of a bid outside the trades Offerium looks up prices for (trade_checked_at, outside_work); its client_form_lines did not yet carry checked_trade, its estimates neither missing_trades nor each line's trade_key, and its facts not why a deadline is kept to confirm (to_confirm).

archive-8

Billing details billing_details
Its research_charges did not yet carry free_analysis, and included counted only the plan's runs for the month.

archive-7

Overage charges overage_charges
Carried payment_item_id under a field name that named Offerium's payment provider.
Billing details billing_details
Its research_charges carried payment_item_id under a field name that named Offerium's payment provider.
Data data
Also carried the name of the model that read or wrote a text: model in each entry of outcome_evidence (under bids and past_bids), of words_provenance and of snapshot_words_provenance, draft_model in follow_ups, and model in audit_log's detail. Later formats leave every model's name out.

archive-6

Bids bids
Did not yet carry the trade of the bid's own work and where it came from (trade_key, trade_source).

archive-5

Mail mail
The rebuilt messages did not yet carry the Message-IDs of the messages they answer (the In-Reply-To and References headers; in_reply_to, reference_ids), only their own Message-ID.

archive-4

Bids bids
Did not yet carry the language the buyer is answered in and how it was decided (correspondence_lang, correspondence_lang_source). Some archives labelled archive-4 already carry them.
Package versions package_versions
Did not yet carry the language a version's offer document and e-mail are written in (lang). Some archives labelled archive-4 already carry it.
Approvals approvals
Did not yet carry the language of the offer document and the e-mail as approved (snapshot_lang). Some archives labelled archive-4 already carry it.

archive-3

Buyers buyers
Also carried four stored figures for the buyer's record, which only Offerium's demonstration data ever set: 0 in every firm's own archive. Later formats leave them out; a buyer's record is counted from past_bids.
FieldTypeMeaning
record_bidswhole numberBids to them.
record_wonwhole numberOf which won.
record_lostwhole numberOf which lost.
record_unknownwhole numberOf which the result is unknown.

archive-2

Priced lines priced_lines
Did not yet carry where a carried number was first set and where a recovered line was read (origin_price_source, recovered_from), nor the line's identity, its labour and material split and its decision trail (rate_kind to class_set_at, labour_part to metal_clause, source_scope_item_id, decision_key, price_basis, rate_card_entry_id, contract_rate_id). Some archives labelled archive-2 already carry some of them. Nor what a person said of a line for its tax (tax_facts).
Bids bids
Did not yet carry the framework contract a bid is priced under (the framework_contract_ fields), nor, on the buyer's form lines, their identity and what the form states beside them (rate_kind to class_set_at, split_cells, wants_split, buyer_pct_bps, buyer_pct_base, buyer_budget). Nor the facts its VAT or sales tax is decided from (tax_facts), nor the evidence of how it ended (outcome_evidence).
Past bids past_bids
Did not yet carry the day the offer's prices were decided, the job's context, why a lost offer was lost, a discount granted on the award, the framework contract and the rates a buyer's reply named (offer_date, the job_context, price_reason and award_discount fields, framework_contract_id, benchmarks). Nor the price the job was awarded at and the evidence of how it ended (the award_price fields, outcome_evidence).
Buyers buyers
Did not yet carry the customer's type and how it was recognised (kind, kind_source, kind_confidence, kind_evidence, kind_set_by_person_id, kind_set_at). Nor its tax facts and certificates (tax_facts, tax_certificates).
Framework contracts framework_contracts
Not part of this format.
Selling rates rate_cards
Not part of this format.
Company profile company_profile
Did not yet carry the firm's own yearly increase (pricing.own_increase_permille), nor its own words for what a line is (rate_terms). Nor its own tax settings and registrations (tax_settings, tax_registrations).
Outcomes outcomes
Did not yet carry whether a result was recorded from evidence, nor the price the job was awarded at (confirmed_by_evidence, the award_price fields).
Package versions package_versions
Did not yet carry the offer's VAT or sales tax as decided and frozen with the version (the tax_ fields).
Sends sends
Did not yet carry whether a person sent the offer from the firm's own mail program (sent_by_hand, marked_sent_by_person_id).
Invoices from Offerium invoices
Did not yet carry the euro rate an invoice in another currency was converted at (eur_rate, eur_rate_day, eur_rate_source).

archive-1

People people
Also carried each person's own choices of what reaches them and when. Later formats leave them out: they are that person's alone, and no screen shows them to the account's owner.
FieldTypeMeaning
email_preferencesJSONWhich e-mails they chose to get (only the choices they made).
push_preferencesJSONWhich phone notifications they chose to get.
push_quiet_fromwhole number · may be emptyQuiet hours start, in minutes after midnight in the firm's time zone.
push_quiet_untilwhole number · may be emptyQuiet hours end, likewise.
single_key_shortcutstrue or falseSingle-key keyboard shortcuts are on.
Activity record audit_log
Carried every entry of the activity record, including those about one person rather than the firm's work: how they sign in, their sessions, the pages they opened, their e-mail choices. Later formats leave those out, as the Activity page does.

Questions

Questions about a format, or an archive that does not open as described here: write to hello@offerium.ai.