( [db] => DoliDBPgsql Object ( [db] => PgSql\Connection Object ( ) [type] => pgsql [forcecharset] => UTF8 [forcecollate] => en_US.utf8 [_results:DoliDB:private] => [connected] => 1 [database_selected] => 1 [database_name] => postgres [database_user] => postgres [database_host] => dolibarr-db-dev-modules [database_port] => 5432 [transaction_opened] => 0 [lastquery] => SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos [lastqueryerror] => [lasterror] => [lasterrno] => [prefix_db] => [ok] => 1 [error] => [_results:DoliDBPgsql:private] => PgSql\Result Object ( ) [unescapeslashquot] => [standard_conforming_strings] => ) [id] => 355 [entity] => 1 [error] => [errorhidden] => [errors] => Array ( ) [validateFieldsErrors] => Array ( ) [element] => facture [element_for_permission] => [table_element] => facture [table_element_line] => facturedet [import_key] => [array_options] => Array ( [options_commande] => test ) [array_languages] => [contacts_ids] => [linked_objects] => Array ( ) [linkedObjectsIds] => [linkedObjects] => [linkedObjectsFullLoaded] => Array ( ) [oldcopy] => [table_ref_field:protected] => ref [restrictiononfksoc] => 1 [context] => Array ( ) [canvas] => [project] => [fk_project] => 10 [projet] => [fk_projet] => [contact] => [contact_id] => [thirdparty] => [user] => [origin] => [origin_id] => [ref] => **redacted** [ref_ext] => [ref_previous] => [ref_next] => [newref] => [statut] => 1 [status] => 1 [country] => [country_id] => [country_code] => [state] => [state_id] => [state_code] => [region_id] => [region_code] => [region] => [barcode_type] => [barcode_type_code] => [barcode_type_label] => [barcode_type_coder] => [mode_reglement_id] => 2 [cond_reglement_id] => 2 [demand_reason_id] => [transport_mode_id] => [cond_reglement] => 30 days [fk_delivery_address] => [shipping_method_id] => [model_pdf] => crabe [modelpdf] => crabe [last_main_doc] => facture/**redacted**.pdf [fk_bank] => [fk_account] => 1 [openid] => [note_public] => **redacted** [note_private] => [note] => [total_ht] => **redacted** [total_tva] => **redacted** [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => **redacted** [lines] => Array ( [0] => FactureLigne Object ( [db] => DoliDBPgsql Object ( [db] => PgSql\Connection Object ( ) [type] => pgsql [forcecharset] => UTF8 [forcecollate] => en_US.utf8 [_results:DoliDB:private] => [connected] => 1 [database_selected] => 1 [database_name] => postgres [database_user] => postgres [database_host] => dolibarr-db-dev-modules [database_port] => 5432 [transaction_opened] => 0 [lastquery] => SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'facturedet' ORDER BY pos [lastqueryerror] => [lasterror] => [lasterrno] => [prefix_db] => [ok] => 1 [error] => [_results:DoliDBPgsql:private] => PgSql\Result Object ( ) [unescapeslashquot] => [standard_conforming_strings] => ) [id] => 676 [entity] => [error] => [errorhidden] => [errors] => Array ( ) [validateFieldsErrors] => Array ( ) [element] => facturedet [element_for_permission] => [table_element] => facturedet [table_element_line] => [import_key] => [array_options] => Array ( ) [array_languages] => [contacts_ids] => [linked_objects] => [linkedObjectsIds] => [linkedObjects] => [linkedObjectsFullLoaded] => Array ( ) [oldcopy] => [table_ref_field:protected] => [restrictiononfksoc] => 0 [context] => Array ( ) [canvas] => [project] => [fk_project] => [projet] => [fk_projet] => [contact] => [contact_id] => [thirdparty] => [user] => [origin] => [origin_id] => [ref] => [ref_ext] => [ref_previous] => [ref_next] => [newref] => [statut] => [status] => [country] => [country_id] => [country_code] => [state] => [state_id] => [state_code] => [region_id] => [region_code] => [region] => [barcode_type] => [barcode_type_code] => [barcode_type_label] => [barcode_type_coder] => [mode_reglement_id] => [cond_reglement_id] => [demand_reason_id] => [transport_mode_id] => [cond_reglement] => [fk_delivery_address] => [shipping_method_id] => [model_pdf] => [modelpdf] => [last_main_doc] => [fk_bank] => [fk_account] => [openid] => [note_public] => [note_private] => [note] => [total_ht] => **redacted** [total_tva] => **redacted** [total_localtax1] => 0.00000000 [total_localtax2] => 0.00000000 [total_ttc] => **redacted** [lines] => [comments] => Array ( ) [name] => [lastname] => [firstname] => [civility_id] => [date_creation] => [date_validation] => [date_modification] => [date_cloture] => [user_author] => [user_creation] => [user_creation_id] => [user_valid] => [user_validation] => [user_validation_id] => [user_closing_id] => [user_modification] => [user_modification_id] => [next_prev_filter] => [specimen] => 0 [sendtoid] => [alreadypaid] => [childtables:protected] => Array ( ) [childtablesoncascade:protected] => Array ( ) [rowid] => 676 [picto] => line [fk_unit] => [date_debut_prevue] => [date_debut_reel] => [date_fin_prevue] => [date_fin_reel] => [weight] => [weight_units] => [width] => [width_units] => [height] => [height_units] => [length] => [length_units] => [surface] => [surface_units] => [volume] => [volume_units] => [multilangs] => [product_type] => 1 [fk_product] => [desc] => **redacted** [product] => [product_ref] => [product_label] => [product_barcode] => [product_desc] => [fk_product_type] => [qty] => **redacted** [duree] => [remise_percent] => 0 [info_bits] => 0 [special_code] => 0 [label] => [libelle] => [subprice] => **redacted** [price] => [vat_src_code] => [tva_tx] => 20.000 [localtax1_tx] => 0.000 [localtax2_tx] => 0.000 [localtax1_type] => 0 [localtax2_type] => 0 [remise] => [date_start_fill] => [date_end_fill] => [buy_price_ht] => [buyprice] => [pa_ht] => 0.00000000 [marge_tx] => [marque_tx] => 100 [fk_multicurrency] => 0 [multicurrency_code] => EUR [multicurrency_subprice] => **redacted** [multicurrency_total_ht] => **redacted** [multicurrency_total_tva] => **redacted** [multicurrency_total_ttc] => **redacted** [fk_user_author] => [fk_user_modif] => [fk_accounting_account] => 0 [oldline] => [fk_facture] => 355 [fk_parent_line] => [fk_remise_except] => [rang] => 1 [fk_fournprice] => [fk_code_ventilation] => 0 [date_start] => [date_end] => [skip_update_total] => [situation_percent] => 100 [fk_prev_id] => [description] => **redacted** [code_ventilation] => 0 ) ) [comments] => Array ( ) [name] => [lastname] => [firstname] => [civility_id] => [date_creation] => 1696240176 [date_validation] => 1696240237 [date_modification] => 1696233037 [date_cloture] => [user_author] => 15 [user_creation] => [user_creation_id] => [user_valid] => 15 [user_validation] => [user_validation_id] => [user_closing_id] => [user_modification] => 15 [user_modification_id] => [next_prev_filter] => [specimen] => 0 [sendtoid] => [alreadypaid] => [childtables:protected] => Array ( ) [childtablesoncascade:protected] => Array ( ) [totalpaid] => [totaldeposits] => [totalcreditnotes] => [sumpayed] => [sumpayed_multicurrency] => [sumdeposit] => [sumdeposit_multicurrency] => [sumcreditnote] => [sumcreditnote_multicurrency] => [remaintopay] => [fk_incoterms] => 0 [label_incoterms] => [location_incoterms] => [fk_element] => fk_facture [picto] => bill [ismultientitymanaged] => 1 [brouillon] => [socid] => 5 [author] => [fk_user_author] => 15 [fk_user_valid] => 15 [fk_user_modif] => 15 [date] => 1695938400 [datem] => 1696233037 [date_livraison] => [delivery_date] => [ref_client] => [ref_customer] => [ref_int] => [type] => 0 [remise_absolue] => [remise_percent] => [revenuestamp] => 0.00000000 [close_code] => [close_note] => [paye] => 0 [module_source] => [pos_source] => [fk_fac_rec_source] => [fk_facture_source] => [date_lim_reglement] => 1698530400 [cond_reglement_code] => 30D [mode_reglement_code] => VIR [line] => [extraparams] => Array ( ) [fac_rec] => [date_pointoftax] => [fk_multicurrency] => 0 [multicurrency_code] => EUR [multicurrency_tx] => 1.00000000 [multicurrency_total_ht] => **redacted** [multicurrency_total_tva] => **redacted** [multicurrency_total_ttc] => **redacted** [situation_cycle_ref] => [situation_counter] => [situation_final] => 0 [tab_previous_situation_invoice] => Array ( ) [tab_next_situation_invoice] => Array ( ) [retained_warranty] => 0 [retained_warranty_date_limit] => 1646348400 [retained_warranty_fk_cond_reglement] => 0 [fields] => Array ( [rowid] => Array ( [type] => integer [label] => TechnicalID [enabled] => 1 [visible] => -1 [notnull] => 1 [position] => 1 ) [ref] => Array ( [type] => varchar(30) [label] => Ref [enabled] => 1 [visible] => 1 [notnull] => 1 [showoncombobox] => 1 [position] => 5 ) [entity] => Array ( [type] => integer [label] => Entity [default] => 1 [enabled] => 1 [visible] => -2 [notnull] => 1 [position] => 20 [index] => 1 ) [ref_client] => Array ( [type] => varchar(255) [label] => RefCustomer [enabled] => 1 [visible] => -1 [position] => 10 ) [ref_ext] => Array ( [type] => varchar(255) [label] => Ref ext [enabled] => 1 [visible] => 0 [position] => 12 ) [type] => Array ( [type] => smallint(6) [label] => Type [enabled] => 1 [visible] => -1 [notnull] => 1 [position] => 15 ) [fk_soc] => Array ( [type] => integer:Societe:societe/class/societe.class.php [label] => ThirdParty [enabled] => 1 [visible] => -1 [notnull] => 1 [position] => 50 ) [datef] => Array ( [type] => date [label] => DateInvoice [enabled] => 1 [visible] => 1 [position] => 20 ) [date_valid] => Array ( [type] => date [label] => DateValidation [enabled] => 1 [visible] => -1 [position] => 22 ) [date_lim_reglement] => Array ( [type] => date [label] => DateDue [enabled] => 1 [visible] => 1 [position] => 25 ) [date_closing] => Array ( [type] => datetime [label] => Date closing [enabled] => 1 [visible] => -1 [position] => 30 ) [paye] => Array ( [type] => smallint(6) [label] => InvoicePaidCompletely [enabled] => 1 [visible] => -1 [notnull] => 1 [position] => 80 ) [remise_percent] => Array ( [type] => double [label] => RelativeDiscount [enabled] => 1 [visible] => -1 [position] => 90 ) [remise_absolue] => Array ( [type] => double [label] => CustomerRelativeDiscount [enabled] => 1 [visible] => -1 [position] => 91 ) [close_code] => Array ( [type] => varchar(16) [label] => EarlyClosingReason [enabled] => 1 [visible] => -1 [position] => 92 ) [close_note] => Array ( [type] => varchar(128) [label] => EarlyClosingComment [enabled] => 1 [visible] => -1 [position] => 93 ) [total_ht] => Array ( [type] => double(24,8) [label] => AmountHT [enabled] => 1 [visible] => 1 [position] => 95 [isameasure] => 1 ) [total_tva] => Array ( [type] => double(24,8) [label] => AmountVAT [enabled] => 1 [visible] => -1 [position] => 100 [isameasure] => 1 ) [localtax1] => Array ( [type] => double(24,8) [label] => LT1 [enabled] => 1 [visible] => -1 [position] => 110 [isameasure] => 1 ) [localtax2] => Array ( [type] => double(24,8) [label] => LT2 [enabled] => 1 [visible] => -1 [position] => 120 [isameasure] => 1 ) [revenuestamp] => Array ( [type] => double(24,8) [label] => RevenueStamp [enabled] => 1 [visible] => -1 [position] => 115 [isameasure] => 1 ) [total_ttc] => Array ( [type] => double(24,8) [label] => AmountTTC [enabled] => 1 [visible] => 1 [position] => 130 [isameasure] => 1 ) [fk_user_author] => Array ( [type] => integer:User:user/class/user.class.php [label] => UserAuthor [enabled] => 1 [visible] => -1 [position] => 165 ) [fk_user_modif] => Array ( [type] => integer:User:user/class/user.class.php [label] => UserModif [enabled] => 1 [visible] => -2 [notnull] => -1 [position] => 166 ) [fk_user_valid] => Array ( [type] => integer:User:user/class/user.class.php [label] => UserValidation [enabled] => 1 [visible] => -1 [position] => 167 ) [fk_user_closing] => Array ( [type] => integer:User:user/class/user.class.php [label] => UserClosing [enabled] => 1 [visible] => -1 [position] => 168 ) [fk_facture_source] => Array ( [type] => integer [label] => SourceInvoice [enabled] => 1 [visible] => -1 [position] => 170 ) [fk_projet] => Array ( [type] => integer:Project:projet/class/project.class.php:1:fk_statut=1 [label] => Project [enabled] => 1 [visible] => -1 [position] => 175 ) [fk_account] => Array ( [type] => integer [label] => Fk account [enabled] => 1 [visible] => -1 [position] => 180 ) [fk_currency] => Array ( [type] => varchar(3) [label] => CurrencyCode [enabled] => 1 [visible] => -1 [position] => 185 ) [fk_cond_reglement] => Array ( [type] => integer [label] => PaymentTerm [enabled] => 1 [visible] => -1 [notnull] => 1 [position] => 190 ) [fk_mode_reglement] => Array ( [type] => integer [label] => PaymentMode [enabled] => 1 [visible] => -1 [position] => 195 ) [note_private] => Array ( [type] => text [label] => NotePrivate [enabled] => 1 [visible] => 0 [position] => 205 ) [note_public] => Array ( [type] => text [label] => NotePublic [enabled] => 1 [visible] => 0 [position] => 210 ) [model_pdf] => Array ( [type] => varchar(255) [label] => Model pdf [enabled] => 1 [visible] => 0 [position] => 215 ) [extraparams] => Array ( [type] => varchar(255) [label] => Extraparams [enabled] => 1 [visible] => -1 [position] => 225 ) [situation_cycle_ref] => Array ( [type] => smallint(6) [label] => Situation cycle ref [enabled] => $conf->global->INVOICE_USE_SITUATION [visible] => -1 [position] => 230 ) [situation_counter] => Array ( [type] => smallint(6) [label] => Situation counter [enabled] => $conf->global->INVOICE_USE_SITUATION [visible] => -1 [position] => 235 ) [situation_final] => Array ( [type] => smallint(6) [label] => Situation final [enabled] => empty($conf->global->INVOICE_USE_SITUATION) ? 0 : 1 [visible] => -1 [position] => 240 ) [retained_warranty] => Array ( [type] => double [label] => Retained warranty [enabled] => $conf->global->INVOICE_USE_RETAINED_WARRANTY [visible] => -1 [position] => 245 ) [retained_warranty_date_limit] => Array ( [type] => date [label] => Retained warranty date limit [enabled] => $conf->global->INVOICE_USE_RETAINED_WARRANTY [visible] => -1 [position] => 250 ) [retained_warranty_fk_cond_reglement] => Array ( [type] => integer [label] => Retained warranty fk cond reglement [enabled] => $conf->global->INVOICE_USE_RETAINED_WARRANTY [visible] => -1 [position] => 255 ) [fk_incoterms] => Array ( [type] => integer [label] => IncotermCode [enabled] => $conf->incoterm->enabled [visible] => -1 [position] => 260 ) [location_incoterms] => Array ( [type] => varchar(255) [label] => IncotermLabel [enabled] => $conf->incoterm->enabled [visible] => -1 [position] => 265 ) [date_pointoftax] => Array ( [type] => date [label] => DatePointOfTax [enabled] => $conf->global->INVOICE_POINTOFTAX_DATE [visible] => -1 [position] => 270 ) [fk_multicurrency] => Array ( [type] => integer [label] => MulticurrencyID [enabled] => $conf->multicurrency->enabled [visible] => -1 [position] => 275 ) [multicurrency_code] => Array ( [type] => varchar(255) [label] => Currency [enabled] => $conf->multicurrency->enabled [visible] => -1 [position] => 280 ) [multicurrency_tx] => Array ( [type] => double(24,8) [label] => CurrencyRate [enabled] => $conf->multicurrency->enabled [visible] => -1 [position] => 285 [isameasure] => 1 ) [multicurrency_total_ht] => Array ( [type] => double(24,8) [label] => MulticurrencyAmountHT [enabled] => $conf->multicurrency->enabled [visible] => -1 [position] => 290 [isameasure] => 1 ) [multicurrency_total_tva] => Array ( [type] => double(24,8) [label] => MulticurrencyAmountVAT [enabled] => $conf->multicurrency->enabled [visible] => -1 [position] => 291 [isameasure] => 1 ) [multicurrency_total_ttc] => Array ( [type] => double(24,8) [label] => MulticurrencyAmountTTC [enabled] => $conf->multicurrency->enabled [visible] => -1 [position] => 292 [isameasure] => 1 ) [fk_fac_rec_source] => Array ( [type] => integer [label] => RecurringInvoiceSource [enabled] => 1 [visible] => -1 [position] => 305 ) [last_main_doc] => Array ( [type] => varchar(255) [label] => LastMainDoc [enabled] => 1 [visible] => -1 [position] => 310 ) [module_source] => Array ( [type] => varchar(32) [label] => POSModule [enabled] => 1 [visible] => -1 [position] => 315 ) [pos_source] => Array ( [type] => varchar(32) [label] => POSTerminal [enabled] => 1 [visible] => -1 [position] => 320 ) [datec] => Array ( [type] => datetime [label] => DateCreation [enabled] => 1 [visible] => -1 [position] => 500 ) [tms] => Array ( [type] => timestamp [label] => DateModificationShort [enabled] => 1 [visible] => -1 [notnull] => 1 [position] => 500 ) [import_key] => Array ( [type] => varchar(14) [label] => ImportId [enabled] => 1 [visible] => -2 [position] => 900 ) [fk_statut] => Array ( [type] => smallint(6) [label] => Status [enabled] => 1 [visible] => 1 [notnull] => 1 [position] => 1000 [arrayofkeyval] => Array ( [0] => Draft [1] => Validated [2] => Paid [3] => Abandonned ) ) ) [mode_reglement] => Transfer [cond_reglement_doc] => Due in 30 days )