Compalex.net

ListaPreciosActualizadas ⁷

• codigo varchar(10)
• unidad_venta varchar(20)
• clasificacion varchar(20)
• inpuesto varchar(20)
• vip double
• lozcar double
• sodexa double

ListaPreciosActualizadas

Profits

Profits ²²

• id bigint unsigned
• comprobante_id int
• fechaemision date
• foliofiscal varchar(255)
• foliointerno varchar(255)
• razonsocial varchar(255)
• total double
• usocfdi varchar(255)
• metodopago varchar(255)
• formapago varchar(255)
• estatus int
• descripcion varchar(255)
• observaciones varchar(255)
• enviopago date
• condicionpago int
• fechasugeridapago date
• fechapago date
• fechabanco date
• nomovimiento int
• documentid varchar(255)
• created_at timestamp
• updated_at timestamp

abilities ¹⁰

• id int unsigned
• name varchar(255)
• title varchar(255)
• entity_id int unsigned
• entity_type varchar(255)
• only_owned tinyint(1)
• options json
• scope int
• created_at timestamp
• updated_at timestamp

abilities

accountpayables

accountpayables ⁹

• id bigint unsigned
• purchaseorder_id int
• bank_id int
• totalcost decimal(10,2)
• status int
• created_by int
• modified_by int
• created_at timestamp
• updated_at timestamp

accountreceivable

accountreceivable ⁹

• id bigint unsigned
• order_id int
• bank_id int
• totalcost decimal(10,2)
• status int
• created_by int
• modified_by int
• created_at timestamp
• updated_at timestamp

assigned_roles ⁷

• id int unsigned
• role_id int unsigned
• entity_id int unsigned
• entity_type varchar(255)
• restricted_to_id int unsigned
• restricted_to_type varchar(255)
• scope int

assigned_roles

bank

bank ⁹

• id bigint unsigned
• name varchar(255)
• descrption varchar(255)
• accountnumber varchar(255)
• clabe varchar(255)
• saldo int
• status_id int
• created_at timestamp
• updated_at timestamp

classification ⁴

• id int
• name varchar(50)
• description varchar(100)
• created_at datetime

classification ⁶

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

clients ¹⁶

• id bigint unsigned
• code varchar(255)
• name varchar(255)
• rfc varchar(255)
• contact1 varchar(255)
• contact2 varchar(255)
• address1 varchar(255)
• address2 varchar(255)
• telephone1 varchar(255)
• telephone2 varchar(255)
• email varchar(255)
• pricelist_id int
• status int
• user_id int
• created_at timestamp
• updated_at timestamp

clients ¹⁶

• id bigint unsigned
• code varchar(255)
• name varchar(255)
• rfc varchar(255)
• contact1 varchar(255)
• contact2 varchar(255)
• address1 varchar(255)
• address2 varchar(255)
• telephone1 varchar(255)
• telephone2 varchar(255)
• email varchar(255)
• pricelist_id int
• status varchar(255)
• user_id int
• created_at timestamp
• updated_at timestamp

combos ⁸

• id bigint unsigned
• store_id bigint unsigned
• name varchar(255)
• description text
• status int
• image varchar(30)
• created_at timestamp
• updated_at timestamp

combos ⁸

• id bigint unsigned
• store_id bigint unsigned
• name varchar(255)
• description varchar(255)
• status int
• image varchar(255)
• created_at timestamp
• updated_at timestamp

combosdetails ⁹

• id bigint unsigned
• combos_id int
• product_id int
• price decimal(12,2)
• taxes1 decimal(12,2)
• taxes2 decimal(12,2)
• cantidad int
• created_at timestamp
• updated_at timestamp

combosdetails ⁹

• id bigint unsigned
• combos_id int
• product_id int
• price decimal(12,2)
• taxes1 decimal(12,2)
• taxes2 decimal(12,2)
• cantidad int
• created_at timestamp
• updated_at timestamp

condiciones_pagos ⁵

• id bigint unsigned
• nombre varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

condiciones_pagos ⁵

• id bigint unsigned
• nombre varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

costlists ⁸

• id int
• name varchar(30)
• description varchar(30)
• supplier_id int
• costlistnumber varchar(20)
• status int
• created_at timestamp
• updated_at timestamp

costlists ⁸

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• supplier_id int
• costlistnumber varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

costlistsdetails ¹⁰

• id int
• costlist_id int
• product_id int
• cost float
• price float
• iva float
• ieps float
• status int
• created_at timestamp
• updated_at timestamp

costlistsdetails ¹⁰

• id bigint unsigned
• costlist_id int
• product_id int
• cost double(8,2)
• price double(8,2)
• iva double(8,2)
• ieps double(8,2)
• status int
• created_at timestamp
• updated_at timestamp

departments ⁶

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

departments ⁶

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

estatus_comprobantes ⁵

• id bigint unsigned
• nombre varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

estatus_comprobantes ⁵

• id bigint unsigned
• nombre varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

estatus_egresos ⁵

• id bigint unsigned
• nombre varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

estatus_egresos ⁵

• id bigint unsigned
• nombre varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

expenses ²²

• id bigint unsigned
• comprobante_id int
• fechaemision date
• foliofiscal varchar(255)
• foliointerno varchar(255)
• razonsocial varchar(255)
• total double
• usocfdi varchar(255)
• metodopago varchar(255)
• formapago varchar(255)
• estatus int
• descripcion varchar(255)
• observaciones varchar(255)
• enviopago date
• condicionpago int
• fechasugeridapago date
• fechapago date
• fechabanco date
• nomovimiento int
• documentid varchar(255)
• created_at timestamp
• updated_at timestamp

expenses ²²

• id bigint unsigned
• comprobante_id int
• fechaemision date
• foliofiscal varchar(255)
• foliointerno varchar(255)
• razonsocial varchar(255)
• total double
• usocfdi varchar(255)
• metodopago varchar(255)
• formapago varchar(255)
• estatus int
• descripcion varchar(255)
• observaciones varchar(255)
• enviopago date
• condicionpago int
• fechasugeridapago date
• fechapago date
• fechabanco date
• nomovimiento int
• documentid varchar(255)
• created_at timestamp
• updated_at timestamp

failed_jobs

failed_jobs ⁶

• id bigint unsigned
• connection text
• queue text
• payload longtext
• exception longtext
• failed_at timestamp

inbounds

inbounds ¹⁵

• id bigint unsigned
• number varchar(255)
• date date
• reference varchar(255)
• notes varchar(255)
• inboundtype_id int
• return_type int
• bank int
• supplier_id int
• warehouse_id int
• status_id int
• created_by int
• modified_by int
• created_at timestamp
• updated_at timestamp

inboundsdetails

inboundsdetails ¹¹

• id bigint unsigned
• inbound_id int
• product_id int
• qty decimal(10,2)
• code varchar(100)
• created_by int
• modified_by int
• created_at timestamp
• updated_at timestamp
• inicio varchar(255)
• final varchar(255)

inboundtypes

inboundtypes ⁸

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• type varchar(4)
• created_by int
• modified_by int
• created_at timestamp
• updated_at timestamp

inventory ⁹

• id bigint unsigned
• product_id int
• available int
• transitin int
• transitout int
• warehouse_id int
• rack varchar(15)
• created_at timestamp
• updated_at timestamp

inventory ¹¹

• id bigint unsigned
• product_id int
• code varchar(255)
• available int
• not_available int
• transitin int
• transitout int
• warehouse_id int
• rack varchar(255)
• created_at timestamp
• updated_at timestamp

inventorykardex ¹³

• id bigint unsigned
• product_id int
• type varchar(15)
• available int
• available_initial int
• transitin_initial int
• transitout_initial int
• available_final int
• transitin_final int
• transitout_final int
• warehouse_id int
• created_at timestamp
• updated_at timestamp

inventorykardex ¹³

• id bigint unsigned
• product_id int
• type varchar(15)
• available int
• available_initial int
• transitin_initial int
• transitout_initial int
• available_final int
• transitin_final int
• transitout_final int
• warehouse_id int
• created_at timestamp
• updated_at timestamp

migrations ³

• id int unsigned
• migration varchar(255)
• batch int

migrations ³

• id int unsigned
• migration varchar(255)
• batch int

model_has_permissions

model_has_permissions ³

• permission_id bigint unsigned
• model_type varchar(255)
• model_id bigint unsigned

model_has_roles

model_has_roles ³

• role_id bigint unsigned
• model_type varchar(255)
• model_id bigint unsigned

order_invoice ⁵

• id int
• order_id int
• invoice_id varchar(100)
• created_at timestamp
• updated_at timestamp

order_invoice ⁵

• id bigint unsigned
• order_id int
• invoice_id varchar(255)
• created_at timestamp
• updated_at timestamp

order_phase ⁷

• id bigint unsigned
• order_id int
• phase_id int
• status int
• comment longtext
• created_at timestamp
• updated_at timestamp

order_phase ⁷

• id bigint unsigned
• order_id int
• phase_id int
• status int
• comment longtext
• created_at timestamp
• updated_at timestamp

order_remision ⁵

• id int
• order_id int
• folio int
• created_at timestamp
• updated_at timestamp

order_remision ⁵

• id bigint unsigned
• order_id int
• folio int
• created_at timestamp
• updated_at timestamp

ordercomments ⁶

• id bigint unsigned
• order_id int
• comments text
• type varchar(255)
• created_at timestamp
• updated_at timestamp

ordercomments ⁶

• id bigint unsigned
• order_id int
• comments text
• type varchar(255)
• created_at timestamp
• updated_at timestamp

orderdetails ¹³

• id bigint unsigned
• order_id int unsigned
• products_id bigint
• qty int
• qtypicked int
• qtydelivered int
• price float
• taxes1 float
• taxes2 float
• subtotal float
• total float
• created_at timestamp
• updated_at timestamp

orderdetails ¹³

• id bigint unsigned
• order_id int unsigned
• products_id int
• qty int
• qtypicked int
• qtydelivered int
• price double
• taxes1 double
• taxes2 double
• subtotal double
• total double
• created_at timestamp
• updated_at timestamp

orders ⁹

• id bigint unsigned
• client_id int unsigned
• ordernumber varchar(20)
• comments text
• user_id int
• status int
• factura varchar(80)
• created_at timestamp
• updated_at timestamp

orders ⁹

• id bigint unsigned
• client_id int unsigned
• ordernumber varchar(255)
• comments text
• user_id int
• status int
• factura varchar(255)
• created_at timestamp
• updated_at timestamp

orderstatus ⁶

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

orderstatus ⁶

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

outbounddestinations

outbounddestinations ⁵

• id bigint unsigned
• name varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

outbounds

outbounds ¹⁷

• id bigint unsigned
• number varchar(255)
• date date
• reference varchar(255)
• notes varchar(255)
• outboundtype_id int
• bank int
• outbounddestination_id int
• warehouse_id int
• acceptedrep_id int
• acceptedwhs_id int
• status_id int
• created_by int
• modified_by int
• created_at timestamp
• updated_at timestamp
• Client_Id int

outboundsdetails

outboundsdetails ⁸

• id bigint unsigned
• outbound_id int
• product_id int
• qty decimal(10,2)
• created_by int
• modified_by int
• created_at timestamp
• updated_at timestamp

outboundtypes

outboundtypes ⁸

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• type varchar(4)
• created_by int
• modified_by int
• created_at timestamp
• updated_at timestamp

password_resets ³

• email varchar(255)
• token varchar(255)
• created_at timestamp

password_resets ³

• email varchar(255)
• token varchar(255)
• created_at timestamp

permissions ⁶

• id int unsigned
• ability_id int unsigned
• entity_id int unsigned
• entity_type varchar(255)
• forbidden tinyint(1)
• scope int

permissions ⁵

• id bigint unsigned
• name varchar(255)
• guard_name varchar(255)
• created_at timestamp
• updated_at timestamp

pricelistdetails ⁸

• id bigint unsigned
• pricelist_id int
• product_id int
• price decimal(12,2)
• taxes1 decimal(12,2)
• taxes2 decimal(12,2)
• created_at timestamp
• updated_at timestamp

pricelistdetails ⁸

• id bigint unsigned
• pricelist_id int
• product_id int
• price double
• taxes1 double
• taxes2 double
• created_at timestamp
• updated_at timestamp

pricelists ⁷

• description varchar(255)
• vip int
• status int
• created_at timestamp
• updated_at timestamp
• id bigint unsigned
• name varchar(255)

pricelists ⁷

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• vip int
• status int
• created_at timestamp
• updated_at timestamp

prod_cat ⁷

• Id int
• Code varchar(10)
• ConversionValue varchar(50)
• Nombre varchar(100)
• UnidadVenta varchar(100)
• ClaveSat varchar(100)
• Classification varchar(100)

prod_cat ⁹

• Id bigint unsigned
• Code varchar(255)
• ConversionValue varchar(255)
• Nombre varchar(255)
• UnidadVenta varchar(255)
• ClaveSat varchar(255)
• Classification varchar(255)
• created_at timestamp
• updated_at timestamp

productbrands

productbrands ⁷

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• code varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

productcategories

productcategories ⁷

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• code varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

productclassifications

productclassifications ⁷

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• code varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

productlines ⁷

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• code int
• status int
• created_at timestamp
• updated_at timestamp

productlines ⁷

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• code varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

products ²⁰

• id bigint unsigned
• barcode varchar(255)
• code varchar(255)
• conversion_code varchar(255)
• conversion_value int
• name varchar(255)
• description varchar(255)
• line_id int
• unidad_venta varchar(255)
• unidad_compra varchar(255)
• clave_sat varchar(100)
• classification varchar(100)
• is_storage int
• tipo_mov int
• status int
• image varchar(20)
• in_store int
• store_id bigint unsigned
• created_at timestamp
• updated_at timestamp

products ²⁴

• id bigint unsigned
• barcode varchar(255)
• code varchar(255)
• conversion_code varchar(255)
• conversion_value int
• name varchar(255)
• description varchar(255)
• line_id int
• unidad_venta varchar(255)
• unidad_compra varchar(255)
• clave_sat int
• classification int
• is_storage int
• tipo_mov int
• status int
• image varchar(255)
• in_store bigint
• store_id bigint
• unique_code int
• created_at timestamp
• updated_at timestamp
• Origendeelproducto varchar(255)
• Serie varchar(255)
• date date

productsubcategories

productsubcategories ⁸

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• code varchar(255)
• categories_id int
• status int
• created_at timestamp
• updated_at timestamp

profits

profits ²²

• id bigint unsigned
• comprobante_id int
• fechaemision date
• foliofiscal varchar(255)
• foliointerno varchar(255)
• razonsocial varchar(255)
• total double
• usocfdi varchar(255)
• metodopago varchar(255)
• formapago varchar(255)
• estatus int
• descripcion varchar(255)
• observaciones varchar(255)
• enviopago date
• condicionpago int
• fechasugeridapago date
• fechapago date
• fechabanco date
• nomovimiento int
• documentid varchar(255)
• created_at timestamp
• updated_at timestamp

purchaseorders ⁸

• id int
• number varchar(20)
• date datetime
• notes varchar(120)
• supplier_id int
• status int
• created_at timestamp
• updated_at timestamp

purchaseorders ⁸

• id bigint unsigned
• number varchar(255)
• date datetime
• notes varchar(255)
• supplier_id int
• status int
• created_at timestamp
• updated_at timestamp

purchaseordersdetails ¹¹

• id int
• purchaseorder_id int
• product_id int
• qty int
• cost float
• subtotal float
• iva float
• ieps float
• total float
• created_at timestamp
• updated_at timestamp

purchaseordersdetails ¹¹

• id bigint unsigned
• purchaseorder_id int
• product_id int
• qty int
• cost double(8,2)
• subtotal double(8,2)
• iva double(8,2)
• ieps double(8,2)
• total double(8,2)
• created_at timestamp
• updated_at timestamp

returns ⁸

• id int
• type varchar(3)
• order_id int
• client_id int
• user_id int
• comments varchar(200)
• created_at timestamp
• updated_at timestamp

returns ⁹

• id bigint unsigned
• type varchar(3)
• order_id int
• client_id int
• user_id int
• status int
• comments varchar(255)
• created_at timestamp
• updated_at timestamp

returnsdetails ⁷

• id int
• return_id int
• product_id int
• qty int
• type int
• created_at timestamp
• updated_at timestamp

returnsdetails ⁷

• id bigint unsigned
• return_id int
• product_id int
• qty int
• type int
• created_at timestamp
• updated_at timestamp

returntypes ⁵

• id int
• name varchar(30)
• status int
• created_at timestamp
• updated_at timestamp

returntypes ⁵

• id bigint unsigned
• name varchar(255)
• status int
• created_at timestamp
• updated_at timestamp

role_has_permissions

role_has_permissions ²

• permission_id bigint unsigned
• role_id bigint unsigned

roles ⁷

• id int unsigned
• name varchar(255)
• title varchar(255)
• level int unsigned
• scope int
• created_at timestamp
• updated_at timestamp

roles ⁵

• id bigint unsigned
• name varchar(255)
• guard_name varchar(255)
• created_at timestamp
• updated_at timestamp

suppliers ¹⁷

• id int
• suppliernumber varchar(20)
• name varchar(100)
• description text
• contact varchar(100)
• contact2 varchar(100)
• address varchar(100)
• rfc varchar(100)
• telephone1 varchar(100)
• telephone2 varchar(100)
• email varchar(100)
• email2 varchar(100)
• zipcode int
• status int
• paymenttype varchar(30)
• created_at timestamp
• updated_at timestamp

suppliers ¹⁷

• id bigint unsigned
• suppliernumber varchar(255)
• name varchar(255)
• description varchar(255)
• contact varchar(255)
• contact2 varchar(255)
• address varchar(255)
• rfc varchar(255)
• telephone1 varchar(255)
• telephone2 varchar(255)
• email varchar(255)
• email2 varchar(255)
• zipcode int
• status int
• paymenttype varchar(255)
• created_at timestamp
• updated_at timestamp

units ⁶

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

units ⁶

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• isactive int
• created_at timestamp
• updated_at timestamp

users ⁹

• id bigint unsigned
• name varchar(255)
• email varchar(255)
• api_token varchar(60)
• email_verified_at timestamp
• password varchar(255)
• remember_token varchar(100)
• created_at timestamp
• updated_at timestamp

users ¹¹

• id bigint unsigned
• name varchar(255)
• last_name varchar(255)
• email varchar(255)
• api_token varchar(255)
• email_verified_at timestamp
• password varchar(255)
• status_id int
• remember_token varchar(100)
• created_at timestamp
• updated_at timestamp

warehouses ⁷

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• status int
• isdefault int
• created_at timestamp
• updated_at timestamp

warehouses ⁷

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• status int
• isdefault int
• created_at timestamp
• updated_at timestamp

workflow_phase ⁸

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• order int
• department int
• isactive int
• created_at timestamp
• updated_at timestamp

workflow_phase ⁸

• id bigint unsigned
• name varchar(255)
• description varchar(255)
• order int
• department int
• isactive int
• created_at timestamp
• updated_at timestamp