incwo

bill_sheets object

• id:

  integer

  the id of this object

• project_id:

  integer

  The project of this object

• progress_id:

  integer

  Progress of document (draft, sent, etc)

• reference:

  string

  Reference of the bill

• reference_index:

  integer

  Index of object in sequence

• creator_ugroup_id:

  integer

  The group owning this object

• creator_id:

  integer

  The user that created this object

• editor_id:

  integer

  The latest user that modified this object

• created_at:

  timestamp

  Creation date of this object

• updated_at:

  timestamp

  Latest modification date of this object

• contact_id:

  integer

  Link to the Contact object

• firm_id:

  integer

  Link to the Firm object

• beneficiary_contact_id:

  integer

  Link to the beneficiary Contact object

• beneficiary_firm_id:

  integer

  Link to the beneficiary Firm object

• prescriptor_contact_id:

  integer

  Link to the prescriptor Contact object

• prescriptor_firm_id:

  integer

  Link to the prescriptor Firm object

• sheet_type:

  string

  Type of document
  - invoice
  - credit
  - invoice_maybe : future invoice 
  - credit_maybe : future credit

• sheet_subtype:

  string

  Subtype for sheet type

• pos_session_id:

  integer

  The POS session that emitted this bill

• pos_seller_id:

  integer

  The POS seller that emitted this bill

• pos_register_id:

  integer

  The POS register that emitted this bill

• pos_location_id:

  integer

  The location of the POS that emitted this bill

• title:

  string

  Title of the object

• subtitle:

  string

  Subtitles of object

• billing_date:

  date

  Date of the document

• vat_not_deductible:

  integer

• vat_cost:

  decimal

• shipping_cost:

  decimal

• vat_exl_total:

  decimal

• vat_inc_total:

  decimal

• vat_exc_total_with_shipping:

  decimal

• currency_id:

  integer

  The currency of this object

• language:

  string

  The language of this document :
  - fr
  - en
  - sp

• currency_exchange_rate:

  decimal

  Exchange rate between business_file.currency and object.currency

• currency_exchange_rate_date:

  datetime

  The date at which the currency_exchange_rate was set

• bank_account_id:

  integer

  The bank account related to this document. 

• payed_amount:

  decimal

• external_order_ref:

  string

• lead_id:

  integer

  The lead attached to this document

• manager_user_id:

  integer

  The user that manages this document

• origin_object_name:

  string

• origin_object_id:

  integer

• party_origin_reference:

  string

• warehouse_id:

  integer

  The warehouse related to this object

• party_idplus:

  string

  ID plus for contact_id and firm_id

• prescriptor_idplus:

  string

  IDplus for prescriptor_contact_id+prescriptor_firm_id

• is_repeat:

  integer

  Automated calculation on wether the customer is repeat
  0 : no
  1 : yes

• is_export:

  integer

  Automated calculation on wether the customer is export
  0 : no
  1 : yes

• reduction_percent:

  decimal

  Percent of reduction for this object

• billing_add_zip_code:

  string

• billing_add_city:

  string

• billing_add_country:

  string

• shipping_add_zip_code:

  string

• shipping_add_city:

  string

• shipping_add_country:

  string

• reduction_currency:

  decimal

  Amount of reduction for this object

• partial_bill_percent:

  decimal

• late_penalty_show:

  integer

• late_penalty_percent:

  decimal

• early_gain_show:

  integer

• early_gain_percent:

  decimal

• hide_quantity:

  integer

• hide_transport:

  integer

• hide_header:

  integer

• show_line_discounts:

  integer

• make_total_round:

  integer

• recurrence_id:

  integer

  Link to recurrence data

• reduction_percent_unit:

  decimal

• approach_expense_percent:

  decimal

• seen_by_target:

  integer

• seen_by_target_at:

  datetime

• enter_prices_in_ttc:

  integer

  Set to 1 if prices are entered in ttc

• hide_totals:

  integer

• sales_conditions_ufile_id:

  integer

• custom_background_ufile:

  integer

• background_opacity:

  integer

• display_background:

  integer

• standard_background_reference:

  integer

• sheet_apply_distributor_prices:

  integer

• sheet_apply_second_brand:

  integer

  Brand number to apply to this object

• payable_now_ttc:

  decimal

• payable_now_ttc_at:

  date

• payable_now_done:

  integer

• should_override_shipping_name:

  integer

• reference_rules:

  string

  String for automated reference assignment

• non_recoverable_amount:

  decimal

• expenses_paid_for_customer:

  decimal

• total_credits:

  decimal

• count_business_days_required:

  integer

• display_product_photos:

  integer

• hide_header_location:

  integer

• prev_firm_id:

  integer

  Previous value of firm

• should_subrogate:

  integer

• should_display_ttc_column:

  integer

• sales_conditions2_ufile_id:

  integer

• period_first_day:

  date

  First day of document period

• period_last_day:

  date

  Last day of document period (included)

• display_product_photos_highref:

  integer

• display_signature:

  integer

• display_barcode:

  integer

• display_weight:

  integer

• margin_value:

  decimal

  Value of margin on this object

• margin_value_in_file_currency:

  decimal

• margin_percent:

  decimal

  Percent of margin made on this object

• eco_participation_ht:

  decimal

• eco_participation_ht_in_file_currency:

  decimal

• duration:

  decimal

• late_penalty_fee:

  integer

• override_display_price:

  integer

• campaign_id:

  integer

  Link to the Campaign object

• spreadsheet_id:

  integer

• with_third_party:

  integer

• billing_add_street_name:

  string

• shipping_add_street_name:

  string

• billing_add_name:

  string

• shipping_add_name:

  string

• override_shipping_name:

  string

• comment:

  string

• billing_add_street_address:

  string

• billing_add_street_address3:

  string

• shipping_add_street_address:

  string

• shipping_add_street_address3:

  string

• comment_for_party:

  string

• subrogate_text:

  string

• eshop_id:

  integer

  The eshop who generated this bill

• billing_add_country_iso_3166_a3:

  string

• shipping_add_country_iso_3166_a3:

  string

• channel_idplus:

  string

• client_since_days:

  integer

• margin_frozen:

  integer

  Is the margin calculation frozen or recalculated at each change ?
  0 : not frozen
  1 : frozen

• accounting_lock_by:

  integer

• accounting_lock_at:

  datetime

• accounting_lock_status:

  integer

• accounting_check_by:

  integer

• accounting_check_at:

  datetime

• accounting_check_status:

  integer

• financial_category_id:

  integer

  Link to the standard financial category

• financial_parent_category_id:

  integer

• custom_financial_category_id:

  integer

  The custom financial category of the object

• owner_contact_id:

  integer

  Link to the owner Contact object

• owner_firm_id:

  integer

  Link to the owner Firm object

• bookable_id:

  integer

  Link to the Bookable object

• amount_paid_ifc:

  decimal

  Paid amount in file currency

• amount_paid_isc:

  decimal

  Paid amount in sheet currency

• language_products:

  string

• pos_print_count:

  integer

• footer_id:

  integer

• frozen_pdf_upload_file_id:

  integer

• validated_at:

  datetime

• automation_key_id:

  integer

• billing_phone:

  string

• shipping_phone:

  string

• auto_stock:

  integer

• late_pay_notif_idx:

  integer

• late_pay_notif_at:

  datetime

• firm_intra_vat:

  string

• round_when_summing_vat:

  integer

• operation_custom_label_id:

  integer

• operation_location:

  integer

• manager_of_operations_id:

  integer