Cliente [Link] Empleado [Link] Clientes.
Email
Alex Alex 8523568945 alexu@[Link]
Marianty Marianty 7222489521 marianty@[Link]
Roger Roger 5554256924 rogerm@[Link]
[Link] de Alta Clientes.Cod_Cliente [Link] Facturas.Id_Cliente
44479 CL0004 FAC520 CL0004
14/04/2020 CL0001 FAC523 CL0001
44839 CL0003 FAC525 CL0003
[Link] [Link] días Facturas.Metodo_Pago [Link]
43833 10 Efectivo 800
30/04/2020 15 Deposito 3000
15/5/2022 15 Deposito 3600
[Link] [Link] [Link]
8 Camara web 1
5 Audifonos 2
2 Cargador Apple 2
[Link] Unitario Movimientos.P_descuento [Link]
1000 0.2 200
1500 0 0
2000 0.2 400
[Link] [Link]
800 FAC520
3000 FAC523
3600 FAC525
Nombre Empleado Telefono Email Fecha de Alta Cod_Cliente
Marianty 7222489521 marianty@[Link] 14/04/2020 CL0001
Jesus 7224568974 jesust@[Link] 2/2/2020 CL0002
Roger 5554256924 rogerm@[Link] 10/5/2022 CL0003
Alex 8523568945 alexu@[Link] 10/10/2021 CL0004
Nelly 7236568945 nellyr@[Link] 1/3/2020 CL0005
Cliente
Marianty
Alex
Roger
IdFact Id_Cliente Fecha Validez días Metodo_Pago Total
FAC523 CL0001 30/04/2020 15 Deposito $3,000.00
FAC530 CL0002 15/2/2020 5 Efectivo $570.00
FAC525 CL0003 15/5/2022 15 Deposito $3,600.00
FAC540 CL0005 10/10/2021 5 Tarjeta $1,500.00
FAC520 CL0004 1/3/2020 10 Efectivo $800.00
Item Producto Unidades Valor Unitario P_descuento Descuento
5 Audifonos 2 $ 1,500.00 0% $0.00
2 Cargador Apple 2 $ 2,000.00 20% $400.00
3 Mica telefono 1 $ 600.00 5% $30.00
6 Mouse 1 $ 1,500.00 0% $0.00
8 Camara web 1 $ 1,000.00 20% $200.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Subtotal IdFact
$3,000.00 FAC523
$3,600.00 FAC525
$570.00 FAC530
$1,500.00 FAC540
$800.00 FAC520
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00