incwo

bill_sheets

This object describes a customer invoice. 

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