Ej factura
Download as XLS, PDF
0 likes123 views
This document contains information about invoices including invoice numbers, customer names and phone numbers, item codes, quantities, prices, and totals. It also includes tables that define the relationships between invoices, customers, items, and suppliers with primary and foreign keys.
Ej factura
- 1. CANTIDAD X PRECIO FACTURA FOLIO RUT NOMBRE TELEFONO ITEM CANTIDAD PRECIO SUBTOTAL TOTAL 00001 10000000 PEDRO 2848888 0000212 2 1000 2000 10000 00001 10000000 PEDRO 2848888 1001001 1 2000 2000 10000 00001 10000000 PEDRO 2848888 1221221 2 3000 6000 10000 00002 10000000 PEDRO 2848888 1222111 4 1000 4000 6678 00002 10000000 PEDRO 2848888 2233221 2 139 278 6678 00002 10000000 PEDRO 2848888 2232222 2 1200 2400 6678 00005 12000000 MAXWELL 3874777 1151515 10 1500 15000 10795000 00005 12000000 MAXWELL 3874777 7746641 20 89000 1780000 10795000 00005 12000000 MAXWELL 3874777 1122222 30 300000 9000000 10795000 00006 12000000 MAXWELL 3874777 1001001 1 1000 1000 3000 00006 12000000 MAXWELL 3874777 1221221 2 2000 2000 3000 TABLAS PRIMARY KEYFOREING KEY CLIENTE FACTURA FOLIO RUT,ITEM RUT NOMBRE TELEFONO DETALLE RUT NULL ### PEDRO 2848888 CLIENTES ID_PROVEEDOR NULL ### MAXWELL 3874777 PROVEEDOR ITEM ID_PROVEEDOR PRODUCTOS ITEM ITEM PROVEEDOR ID_PROVEEDOR NOM_PROVEEDOR
- 2. DESCRIPCION ID_PROVEEDOR NOM_PROVEEDOR JUGO 1 WATT卒S JUGO 1LT 1 WATT卒S JUGO 1LT 1 WATT卒S JUGO 1LT 1 WATT卒S YOGHURT 2 SOPROLE LECHE 1LT 2 SOPROLE DVD 10 COELSA TV 10 COELSA LCD 10 COELSA JUGO 1LT 1 WATT卒S JUGO 1LT 1 WATT卒S OM_PROVEEDOR