bg4h 1.0.64

bg table definitions for humans

BG4h

bee gees for Humans Table Definitions

Publish

To create a new package:

• First, update the version in pyproject.toml
• Then, run the .bat file: Launch publish_package.bat

Build & Publish

python -m build twine upload dist/*

ChangeLog

1.0.64 - 11.04.2026

• fix: added payroll and employee data
  • new fields in Employee class:
    • salary_pgc_code = 'TPERSONAL31'
    • external_user_code = 'TPERSONAL38'
  • new table definitions:
    • Nominas
    • ValoresNominas

1.0.63 - 24.03.2026

• new table definitions:
  • TiposContratosSat
  • ContratosMantenimiento

1.0.62 - 17.03.2026

• new fields:
  • free_feature_1 = 'TPROVEEDORES44'
  • free_feature_2 = 'TPROVEEDORES45'
  • free_feature_3 = 'TPROVEEDORES46'

1.0.61 - 10.03.2026

• new fields:
  • task_code = "TVALORESPRESUPUESTOS65"
  • task_name = "TVALORESPRESUPUESTOS66"

1.0.60 - 02.03.2026

• new table definitions: TPRESUPUESTOSOBRA

1.0.59 - 25.02.2026

• fix: tipo in TPEDIDOSNUMERACION

1.0.58 - 23.02.2026

• new field: consider_the_time_article_compound = "TPRESUPUESTOS46"

1.0.57 - 19.02.2026

• new table definitions: SubfamiliasFamilia

1.0.56 - 29.01.2026

• new fields tProviders: pgc_1_account_code,pgc_2_account_code,pgc_4_account_code,pgc_4_account_code,pgc_5_account_code

1.0.55 - 11.12.2025

• set_sell_price_manually = "TUNIDADESOBRA50"

1.0.54 - 10.12.2025

• added SeriesPresupuestos class

1.0.53 - 10.12.2025

• fix:
  • price_cost_accounting -> time_cost_accounting = "TVALORESPRESUPUESTOS19"
  • price_cost -> time_cost = "TVALORESPRESUPUESTOS20"

1.0.52 - 09.12.2025

• TVALORESUNIDADESOBRA added:

  • units = 'TVALORESUNIDADESOBRA21'
  • familiy_code = "TUNIDADESOBRA34"
  • subfamiliy_code = "TUNIDADESOBRA36"
  • group_code = "TUNIDADESOBRA37"

• TVALORESPRESUPUESTOS added:

  • puc_accounting = "TVALORESPRESUPUESTOS67"
  • puc = "TVALORESPRESUPUESTOS68"
  • subitem_units = "TVALORESPRESUPUESTOS80"
  • time_price_accounting = "TVALORESPRESUPUESTOS7"
  • time_price = "TVALORESPRESUPUESTOS8"
  • price_cost_accounting = "TVALORESPRESUPUESTOS19"
  • price_cost = "TVALORESPRESUPUESTOS20"
  • time_margin_percentage = "TVALORESPRESUPUESTOS21"

1.0.51 - 28.11.2025

• no changes, just version update to match bg4h_ts

1.0.50 - 25.11.2025

-fix: duplicate: tax_invoice_expenses_percentage_2 = "tcobros32" -> tax_invoice_expenses_percentage_1 tax_invoice_expenses_percentage_2 = "tcobros52"

1.0.49 - 25.11.2025

• fix: duplicate: totals_tax_internal = "TFACTURASVENTAS70" totals_tax_internal = "TFACTURASVENTAS72" -> totals_tax_with_recharge_internal

1.0.48 - 18.11.2025

• added: transporter_code = "TVENTAS281"

1.0.47 - 12.11.2025

• added: TVACACIONES
• added: TOTROSVACACIONES
• added: TOTRASINCIDENCIASPERSONAL

1.0.46 - 10.11.2025

• fix: update ValoresVentas class to remove deprecated/broken/unused margin_percentage attribute and increment version to 1.0.46

1.0.45 - 10.11.2025

• fix:added helpers import to init

1.0.44 - 06.11.2025

• feat: add DeprecatedAttr class for handling deprecated attributes with warnings
• fix: duplicate entry article_margin_percentage mapped to: "TVALORESVENTAS18" and "TVALORESVENTAS21"
• fix: changed duplicate article_margin_percentage to correct: hours_margin_percentage = "TVALORESVENTAS21"
• added old deprecated changes since v1.0.12

1.0.43 - 06.11.2025

• fix: code = article_code = "TVALORESVENTAS2" ->restored for backwards compatibility
• fix: desc = article_desc = "TVALORESVENTAS3" ->restored for backwards compatibility

1.0.42 - 05.11.2025

• new field: use_mailing_code = "TPRESUPUESTOS126"
• new field: client_mailing_code = "TPRESUPUESTOS127"

1.0.41 - 24.10.2025

• new field: total_cost_accounting = "TPRESUPUESTOS49"
• new field: total_cost = "TPRESUPUESTOS50"
• new field: article_cost_accounting = "TVALORESPRESUPUESTOS16"

1.0.40 - 24.10.2025

• new table:_ Tdocumentosavisos
• new field: id_web = "TTAREASAVISOS9"

1.0.39 - 24.10.2025

• rename: order_state -> order_status = "TPEDIDOSAPROVEEDORES6"
• rename: order_send_address -> shipping_address = "TPEDIDOSAPROVEEDORES7" #Envío
• new: shipping_zip_code = "TPEDIDOSAPROVEEDORES38" #Envío
• new: shipping_city = "TPEDIDOSAPROVEEDORES39" #Envío
• new: shipping_province = "TPEDIDOSAPROVEEDORES40" #Envío
• new: shipping_country = "TPEDIDOSAPROVEEDORES41" #Envío
• new: shipping_phone = "TPEDIDOSAPROVEEDORES103" #Envío
• new: shipping_email = "TPEDIDOSAPROVEEDORES104" #Envío
• new: shipping_observations ="TPEDIDOSAPROVEEDORES105" #Envío
• new: invoice_city = "TPEDIDOSAPROVEEDORES34" #facturas
• new: invoice_province = "TPEDIDOSAPROVEEDORES35" #facturas
• new: invoice_country = "TPEDIDOSAPROVEEDORES36" #facturas
• new: receiving_address =" TPEDIDOSAPROVEEDORES17" #recepción
• new: receiving_zip_code = "TPEDIDOSAPROVEEDORES43" #recepción
• new: receiving_city =" TPEDIDOSAPROVEEDORES44" #recepción
• new: receiving_province = "TPEDIDOSAPROVEEDORES45" #recepción
• new: receiving_country = "TPEDIDOSAPROVEEDORES46" #recepción

1.0.38 - 22.10.2025

• fix: assign_time_to_document = "TPRESUPUESTOS33"
• new field: accounting_installed_price = "TVALORESPRESUPUESTOS10"
• new field: installed_price = "TVALORESPRESUPUESTOS11"

1.0.37 - 21.10.2025

• new field: buy_tax_code = "TARTICULOS204"
• new fields: TPRESUPUESTOS and TVALORESPRESUPUESTOS

1.0.35 - 20.10.2025

• new field: is_transporter = "TPROVEEDORES41"
• new field: is_comission_agent = "TPROVEEDORES42"
• rename: output_tax_code - > sell_tax_code = "TARTICULOS10"
• new field: measure_unit = "TVALORESPRESUPUESTOS43"
• lot of new fields to: TCLIENTES15

1.0.34 - 16.10.2025

• new field: client_registered = "TPRESUPUESTOS99"

1.0.33 - 16.10.2025

• rename: margin_currency -> margin_percentage = "TVENTAS37"

1.0.32 - 15.10.2025

• new field: contact_person = "TPRESUPUESTOS107"

1.0.31 - 14.10.2025

• new field: email = "TPRESUPUESTOS150"

1.0.30 - 10.10.2025

• new fields for TDATOSDECONTROL taxes_per_article = 'TDATOSDECONTROL4' taxes_per_budget_doc = 'TDATOSDECONTROL5' default_sell_doc_tax_code = 'TDATOSDECONTROL14' default_client_agrarian_tax_code = 'TDATOSDECONTROL15' default_client_exempt_tax_code = 'TDATOSDECONTROL16' default_client_eu_tax_code = 'TDATOSDECONTROL17' default_provider_tax_code = 'TDATOSDECONTROL18' default_provider_agrarian_tax_code = 'TDATOSDECONTROL19' default_provider_exempt_tax_code = 'TDATOSDECONTROL20' default_provider_eu_tax_code = 'TDATOSDECONTROL21' default_sell_doc_special_tax_code = 'TDATOSDECONTROL35' default_family_code = 'TDATOSDECONTROL42' default_client_general_agrarian_tax_code = 'TDATOSDECONTROL62' default_provider_general_agrarian_tax_code = 'TDATOSDECONTROL63' default_currency = 'TDATOSDECONTROL85'

• rename fields: article_tax_code > default_article_tax_code = 'TDATOSDECONTROL40'

1.0.29 - 08.10.2025

• added: expire_date = "TSTOCKOTROSCONTROLES3"
• fix: pvp_accountant = "TVALORESVENTAS5"
• fix: price_tax_included_intgernal -> price_tax_included_internal = "TVALORESVENTAS34"
• fix: margin_percentage -> article_margin_percentage = "TVALORESVENTAS21"
• fix: code -> article_code = "TVALORESVENTAS2"
• fix: desc -> article_desc = "TVALORESVENTAS3"

1.0.28 26.09.2025

• rename delivery_document_series,delivery_document_number, delivery_document_date to document_series,document_number,document_date

• added: percentage_on_amounts ="TVENTAS122"

1.0.27 - 22.09.2025

• Add observations variable to tTareas class and format existing attributes

1.0.26 - 22.09.2025

• fix: data_default_value -> changed from TTAREAS12 to TTAREAS17
• fix: data_default_inital_value -> is now TTAREAS12

1.0.25 - 19.09.2025

• added: observations = "CCUENTASTESORERIA14"

1.0.24 - 21.08.2025

• Add index_numerico variable to BgSoc class for AvisosElementos

1.0.23 - 19.08.2025

• fix: in var name of tavisoschecklist table name

1.0.22 - 12.08.2025

• added fields to ttareas
• added fields to tvalorespresupuestos

1.0.21 - 05.07.2025

• fix: rename table and fiels TFICHASELEMENTOS -> TFICHAELEMENTOS

1.0.20 - 05.07.2025

• fix: batch_manufacturation -> lot_number = "TFICHASELEMENTOS6"

v1.0.19 - 04.07.2025

• added optional_line = TVALORESPRESUPUESTOS53

v1.0.18 - 04.07.2025

• add new tables for checklist
• TAVISOSCHECKLIST
• TAVISOSCHECKLISTIMP
• TMANTENIMIENTOSSAT
• TVALORESMANTENIMIENTOSSAT

v1.0.17

• import_limit = "CCUENTASTESORERIA15"
• TNOMINAS added

v1.0.16

• contract_source = "TAVISOSREPARACIONESCLIENTES37"
• time_of_call = "TAVISOSREPARACIONESCLIENTES48"
• fee_code ="TAVISOSREPARACIONESCLIENTES157"
• table: IntervencionesAvisos

v1.0.15

• project_code_invoice = "TAVISOSREPARACIONESCLIENTES80"
• in_charge_code_header = "TAVISOSREPARACIONESCLIENTES119"
• worker_code1_header = "TAVISOSREPARACIONESCLIENTES120"
• worker_code2_header = "TAVISOSREPARACIONESCLIENTES121"
• worker_code3_header = "TAVISOSREPARACIONESCLIENTES122"

v1.0.14 16.05.2025

• fix TVENTAS
• added TVALORESPOSIBLESLOCALIZACIONESART

v1.0.13 09.05.2025

• added quotation series and code to AvisosReparacionesClientes
• added vehicle_code to tventas

v1.0.12 03.02.2025

• added missings vars tpersonal
• rename tobras state -> status

v1.0.11 12.12.2024

• fix: correct class definition syntax for StockMinMaxAlmacen

v1.0.10 10.12.2024

• added defs for stockminmaxalmacen

v1.0.9 01.12.2024

• fixed wrong defs on Inmovilizados
• added defs for OtrosCostes and ValoresOtrosCostes

v1.0.8 01.12.2024

• added new fields to bg_soc.py
• fixed typos in bg_main.py
• added missing field definitions in various tables

v1.0.7 25.11.2024

• added missing index field tarticulosavisos

v1.0.6 27.09.2024

• added missing fields in ttareasavisos

v1.0.5 17.09.2024

• added missing worker 1-3 fields -> tavisosreparacionesclientes

v1.0.4 02.08.2024

• added missing fields
• fix misspeling table ttrabajosavisos -> trabajosavisos

v1.0.3 13.03.2024

• fixed spelling in vars of Personal table in BgMain

v1.0.2 - 27.01.2024

• added missing fields from table vacaciones

v1.0.1 - 10.01.2024

• added long description to setup.py
• fixed ttarea6 -> to TTAREAS6

v1.0.0 - 18.12.2023

• ts/net lib converted to python
• spellfix
• added todos for unknown / unclear values