LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/Invoices/Invoice_Forms_v2.odb
File actual save date2018-07-12 16:54:13
Scanning done on2018-08-21 16:18:10
Documentation generated on2018-08-21 16:18:22
Table of contents
Invoice Forms
Controls by form
Form name Control name Control type Caption X,Y Width,Height Root form Data source Master fields Child fields On push Required Format
1. Invoice Unique Items CUSTOMER_ID Fixed Customer 128,36 267,18 MainForm            
  datDATE Date   395,54 133,25 MainForm DATE       ✔ YYYY-MM-DD
  DATE Fixed Date (default today) 396,36 141,18 MainForm            
  fmtID Formatted   37,54 89,25 MainForm ID       ✔ General
  ID Fixed Invoice # 38,36 88,18 MainForm            
  ITEM_NAME Fixed Select ITEM to be added 39,89 373,17 MainForm            
  listCUSTOMER_ID List box   127,54 268,25 MainForm 
SELECT 
	"LASTNAME" || ', ' || "FIRSTNAME" AS "FULLNAME", 
	"ID" 
FROM 
	"CUSTOMERS" 
ORDER BY 
	"LASTNAME" ASC
       ✔  
  Navigation Bar 1 Navigation bar   527,53 193,26 MainForm            
  SERIAL Fixed Select by SERIAL # 413,89 186,18 MainForm            
  SubForm1 Subform       MainForm SOLD (Table) ID INVOICE_ID      
  … ITEM List box   37,106 375,26   
SELECT 
	"ITEMS"."ITEM", 
	"ITEMS"."ITEM_ID" 
FROM 
	{ OJ "ITEMS" 
	LEFT OUTER JOIN "SOLD" ON "ITEMS"."ITEM_ID" = "SOLD"."ITEM_ID" } 
WHERE 
	"SOLD"."ITEM_ID" IS NULL 
ORDER BY 
	"ITEMS"."ITEM" ASC
       ✔  
  … ITEM_SERIAL List box   412,107 187,25   
SELECT 
	"ITEMS"."SKU", 
	"ITEMS"."ITEM_ID" 
FROM 
	{ OJ "ITEMS" 
	LEFT OUTER JOIN "SOLD" ON "ITEMS"."ITEM_ID" = "SOLD"."ITEM_ID" } 
WHERE 
	"SOLD"."ITEM_ID" IS NULL 
ORDER BY 
	"SKU" ASC
       ✔  
  … Push Button 2 Button 2. Next Item 226,135 186,26         Refresh form    
  SubForm2 Subform       MainForm 
SELECT 
	"SOLD".*, 
	"ITEMS".* 
FROM 
	"SOLD", 
	"ITEMS" 
WHERE 
	"SOLD"."ITEM_ID" = "ITEMS"."ITEM_ID"
 ID INVOICE_ID      
  … Navigation Bar 3 Navigation bar   37,419 486,26              
  … Push Button 1 Button 1. Add Item to Invoice 38,135 186,26         Refresh form    
  … SubForm_Grid Gridcontrol   37,161 682,259              
  … … ITEM Text ITEM       ITEM          
  … … ITEM_SERIAL Text SERIAL #       SKU          
  … … PRICE Currency PRICE       PRICE          
  SubForm3 Subform       MainForm 
SELECT 
	"SOLD"."INVOICE_ID", 
	SUM("ITEMS"."PRICE") 
FROM 
	"ITEMS", 
	"SOLD" 
WHERE 
	"ITEMS"."ITEM_ID" = "SOLD"."ITEM_ID" 
GROUP BY 
	"SOLD"."INVOICE_ID"
 ID INVOICE_ID      
  … Push Button 3 Button 3. Get Total 413,135 186,26         Refresh form    
  … TOTAL Formatted   609,419 108,26   SUM("ITEMS"."PRICE")       ✔ [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
  … TOTAL Formatted   609,419 108,26   SUM("ITEMS"."PRICE")       ✔ [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
2. Invoice Basic CUSTOMER_ID Fixed Customer 128,35 267,18 MainForm            
  datDATE Date   395,54 133,25 MainForm DATE       ✔ YYYY-MM-DD
  DATE Fixed Date (default today) 396,35 141,18 MainForm            
  fmtID Formatted   37,54 89,25 MainForm ID       ✔ General
  ID Fixed Invoice # 38,35 88,18 MainForm            
  ITEM_NAME Fixed Select ITEM to be added 39,88 373,17 MainForm            
  listCUSTOMER_ID List box   127,54 268,25 MainForm 
SELECT 
	"LASTNAME" || ', ' || "FIRSTNAME" AS "FULLNAME", 
	"ID" 
FROM 
	"CUSTOMERS" 
ORDER BY 
	"LASTNAME" ASC
       ✔  
  NAVIGATION Fixed Manage Invoices 528,35 191,21 MainForm            
  Navigation Bar 1 Navigation bar   527,53 193,26 MainForm            
  SKU Fixed Select by SKU # 413,88 186,18 MainForm            
  SubForm1 Subform       MainForm SOLD (Table) ID INVOICE_ID      
  … ITEM List box   37,106 375,26   
SELECT 
	"ITEM", 
	"ITEM_ID" 
FROM 
	"ITEMS" 
ORDER BY 
	"ITEM" ASC
       ✔  
  … ITEM_SKU List box   412,107 187,25   
SELECT 
	"SKU", 
	"ITEM_ID" 
FROM 
	"ITEMS" 
ORDER BY 
	"SKU" ASC
       ✔  
  … Push Button 2 Button 2. Next Item 226,135 186,26         Refresh form    
  SubForm2 Subform       MainForm 
SELECT 
	"SOLD".*, 
	"ITEMS".*, 
	"SOLD"."QTY" * "ITEMS"."PRICE" AS "EXTENDED" 
FROM 
	"SOLD", 
	"ITEMS" 
WHERE 
	"SOLD"."ITEM_ID" = "ITEMS"."ITEM_ID"
 ID INVOICE_ID      
  … Navigation Bar 3 Navigation bar   37,419 486,26              
  … Push Button 1 Button 1. Add Item to Invoice 38,135 186,26         Refresh form    
  … SubForm_Grid Gridcontrol   37,161 682,259              
  … … EXTENDED Currency FINAL       EXTENDED          
  … … ITEM Text ITEM       ITEM          
  … … ITEM_SKU Text SKU #       SKU          
  … … PRICE Currency PRICE       PRICE          
  … … QTY Numeric QTY       QTY          
  SubForm3 Subform       MainForm 
SELECT 
	"SOLD"."INVOICE_ID", 
	SUM(
		(
			"ITEMS"."PRICE" * "SOLD"."QTY"
		)) AS "TOTAL" 
FROM 
	"ITEMS", 
	"SOLD" 
WHERE 
	"ITEMS"."ITEM_ID" = "SOLD"."ITEM_ID" 
GROUP BY 
	"SOLD"."INVOICE_ID"
 ID INVOICE_ID      
  … Push Button 3 Button 3. Get Total 413,135 186,26         Refresh form    
  … TOTAL Formatted   609,419 108,26   TOTAL       ✔ [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
  … TOTAL Formatted   609,419 108,26   TOTAL       ✔ [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
3. Invoice Intermediate CUSTOMER_ID Fixed Customer 128,35 267,21 MainForm            
  datDATE Date   393,54 133,25 MainForm DATE       ✔ YYYY-MM-DD
  DATE Fixed Date (default today) 394,35 140,21 MainForm            
  fmtID Formatted   37,54 89,25 MainForm ID       ✔ General
  ID Fixed Invoice # 38,35 88,21 MainForm            
  ITEM_NAME Fixed Select ITEM to be added 40,239 372,21 MainForm            
  listCUSTOMER_ID List box   127,54 269,25 MainForm 
SELECT 
	"LASTNAME" || ', ' || "FIRSTNAME" AS "FULLNAME", 
	"ID" 
FROM 
	"CUSTOMERS" 
ORDER BY 
	"LASTNAME" ASC
       ✔  
  NAVIGATION Fixed Manage Invoices 528,35 191,21 MainForm            
  Navigation Bar 1 Navigation bar   525,53 193,26 MainForm            
  SKU Fixed Select by SKU # 412,239 186,21 MainForm            
  SubForm_Address1 Subform       MainForm 
SELECT 
	"CUSTOMERS".*, 
	"CUSTOMERS"."FIRSTNAME" || ' ' || "LASTNAME" AS "FULLNAME" 
FROM 
	"CUSTOMERS"
 CUSTOMER_ID ID      
  … Push Button 1 Button Undo Changes 186,89 87,21         Undo data entry    
  … Push Button 2 Button Save Changes 274,89 87,21         Save record    
  … Push Button 3 Button Refresh 133,89 53,21         Refresh form    
  … txtCITY Text   34,158 157,26   CITY       ✔  
  … txtFULLNAME Text   34,108 326,26   FULLNAME       ✔  
  … txtPHONE Pattern   34,183 326,25   PHONE       ✔  
  … txtSTATE Text   190,158 82,26   STATE       ✔  
  … txtSTREET Text   34,133 326,26   STREET       ✔  
  … txtZIP Text   271,158 89,26   ZIP       ✔  
  SubForm_Address2 Subform       MainForm SHIP_TO (Table) ID INVOICE_ID      
  … ADDRESS Fixed Billing Address 35,88 326,21              
  … Push Button 1 Button Save separate Shipping Address 393,89 327,21         Save record    
  … SHIPPING_ADDRESS Fixed   392,88 327,21              
  … txtCITY Text   392,158 157,26   CITY       ✔  
  … txtFULLNAME Text   392,108 326,26   NAME       ✔  
  … txtPHONE Pattern   392,183 326,25   PHONE       ✔  
  … txtSTATE Text   548,158 82,26   STATE       ✔  
  … txtSTREET Text   392,133 326,26   STREET       ✔  
  … txtZIP Text   629,158 89,26   ZIP       ✔  
  SubForm_Invoice1 Subform       MainForm SOLD (Table) ID INVOICE_ID      
  … ITEM List box   38,257 375,26   
SELECT 
	"ITEM", 
	"ITEM_ID" 
FROM 
	"ITEMS" 
ORDER BY 
	"ITEM" ASC
       ✔  
  … ITEM_SKU List box   411,257 187,26   
SELECT 
	"SKU", 
	"ITEM_ID" 
FROM 
	"ITEMS" 
ORDER BY 
	"SKU" ASC
       ✔  
  … Push Button 2 Button 2. Next Item 226,286 186,25         Refresh form    
  SubForm_Invoice2 Subform       MainForm 
SELECT 
	"SOLD".*, 
	"ITEMS".*, 
	(
		"ITEMS"."PRICE" - ABS(
			COALESCE ("SOLD"."DISC_CURRENCY", '0'))) * "SOLD"."QTY" * (
		1 - ABS(
			COALESCE ("SOLD"."DISC_PERCENT", '0'))) AS "EXTENDED" 
FROM 
	"SOLD", 
	"ITEMS" 
WHERE 
	"SOLD"."ITEM_ID" = "ITEMS"."ITEM_ID"
 ID INVOICE_ID      
  … Navigation Bar 3 Navigation bar   37,485 468,26              
  … Push Button 1 Button 1. Add Item to Invoice 38,286 186,25         Refresh form    
  … SubForm_Grid Gridcontrol   37,311 682,175              
  … … Discount_Currency Formatted - $       DISC_CURRENCY         [$$-409]0.00;[RED]-[$$-409]0.00
  … … Discount_Percentage Formatted - %       DISC_PERCENT         0%;[RED]-0%
  … … EXTENDED Currency FINAL       EXTENDED          
  … … ITEM Text ITEM       ITEM          
  … … ITEM_SKU Text SKU #       SKU          
  … … PRICE Currency PRICE       PRICE          
  … … QTY Numeric QTY       QTY          
  SubForm_SubTotal Subform       MainForm qSubForm_SubTotal (Query) ID INVOICE_ID      
  … lblSubTotal Fixed SubTotal 504,485 126,26              
  … Push Button 3 Button 3. Get Total 414,286 186,25         Refresh form    
  … SubForm_Tax Subform         qSubForm_Tax (Query) INVOICE_ID INVOICE_ID      
  … … SubForm_Tax_Rate Subform         
SELECT 
	"RATE" * 1e2 || '% ' || "TYPE" AS "TAX_RATE" 
FROM 
	"TAX" 
WHERE 
	"ID" = 1
          
  … … … lblTax Text   503,510 127,26   TAX_RATE          
  … … Tax Formatted   629,511 89,26   TAXES         [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
  … SubForm_Total Subform         qSubForm_Total (Query) INVOICE_ID INVOICE_ID      
  … … lblTotal Fixed TOTAL 503,536 127,26              
  … … Total Formatted   629,536 89,26   TOTAL         [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
  … SubTotal Formatted   629,485 89,26   SUBTOTAL         [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
4. Invoice Advanced CUSTOMER_ID Fixed Customer 128,35 267,21 MainForm            
  datDATE Date   393,54 133,25 MainForm DATE       ✔ YYYY-MM-DD
  DATE Fixed Date (default today) 394,35 140,21 MainForm            
  fmtID Formatted   37,54 89,25 MainForm ID       ✔ General
  ID Fixed Invoice # 38,35 88,21 MainForm            
  ITEM_NAME Fixed Select ITEM to be added 39,239 372,21 MainForm            
  listCUSTOMER_ID List box   127,54 269,25 MainForm 
SELECT 
	"LASTNAME" || ', ' || "FIRSTNAME" AS "FULLNAME", 
	"ID" 
FROM 
	"CUSTOMERS" 
ORDER BY 
	"LASTNAME" ASC
       ✔  
  listDiscount List box   466,460 144,26 MainForm 
SELECT 
	CASEWHEN(
		"ID" = 0, 
		' ', 
		(
			CAST("UNITS" AS INTEGER) || '%  Discount  ')) AS "TYPE_DISPLAY", 
	"ID" 
FROM 
	"DISCOUNT"
          
  listShipper List box   466,511 144,26 MainForm 
SELECT 
	NAME, 
	"ID" 
FROM 
	"SHIPPERS"
          
  listTax List box   466,485 144,26 MainForm 
SELECT 
	COALESCE (
		"RATE" * 1e2 || '%  ' || "TYPE", "TYPE"
	) AS "TYPE_PERCENT", 
	"ID" 
FROM 
	"TAX"
          
  NAVIGATION Fixed Manage Invoices 528,35 191,21 MainForm            
  Navigation Bar 1 Navigation bar   525,53 193,26 MainForm            
  SKU Fixed Select by SKU # 412,239 186,21 MainForm            
  SubForm_Address1 Subform       MainForm 
SELECT 
	"CUSTOMERS".*, 
	"CUSTOMERS"."FIRSTNAME" || ' ' || "LASTNAME" AS "FULLNAME" 
FROM 
	"CUSTOMERS"
 CUSTOMER_ID ID      
  … Push Button 1 Button Undo Changes 186,89 87,21         Undo data entry    
  … Push Button 2 Button Save Changes 274,89 87,21         Save record    
  … Push Button 3 Button Refresh 138,89 48,21         Refresh form    
  … txtCITY Text   34,158 157,26   CITY       ✔  
  … txtFULLNAME Text   34,108 326,26   FULLNAME       ✔  
  … txtPHONE Pattern   34,183 326,25   PHONE       ✔  
  … txtSTATE Text   190,158 82,26   STATE       ✔  
  … txtSTREET Text   34,133 326,26   STREET       ✔  
  … txtZIP Text   271,158 89,26   ZIP       ✔  
  SubForm_Address2 Subform       MainForm SHIP_TO (Table) ID INVOICE_ID      
  … ADDRESS Fixed Billing Address 35,88 326,21              
  … Push Button 1 Button Save separate Shipping Address 393,89 326,21         Save record    
  … SHIPPING_ADDRESS Fixed   392,88 327,21              
  … txtCITY Text   392,158 157,26   CITY       ✔  
  … txtFULLNAME Text   392,108 326,26   NAME       ✔  
  … txtPHONE Pattern   392,183 326,25   PHONE       ✔  
  … txtSTATE Text   548,158 82,26   STATE       ✔  
  … txtSTREET Text   392,133 326,26   STREET       ✔  
  … txtZIP Text   629,158 89,26   ZIP       ✔  
  SubForm_Customer Subform       MainForm SOLD (Table) ID INVOICE_ID      
  … ITEM List box   37,257 375,26   
SELECT 
	"ITEM", 
	"ITEM_ID" 
FROM 
	"ITEMS" 
ORDER BY 
	"ITEM" ASC
       ✔  
  … ITEM_SKU List box   411,257 187,26   
SELECT 
	"SKU", 
	"ITEM_ID" 
FROM 
	"ITEMS" 
ORDER BY 
	"SKU" ASC
       ✔  
  … Push Button 2 Button 2. Next Item 226,286 186,25         Refresh form    
  SubForm_Invoice Subform       MainForm 
SELECT 
	"SOLD".*, 
	"ITEMS".*, 
	(
		"ITEMS"."PRICE" - ABS(
			COALESCE ("SOLD"."DISC_CURRENCY", 0))) * "SOLD"."QTY" * (
		1 - ABS(
			COALESCE ("SOLD"."DISC_PERCENT", 0))) AS "EXTENDED" 
FROM 
	"SOLD", 
	"ITEMS" 
WHERE 
	"SOLD"."ITEM_ID" = "ITEMS"."ITEM_ID"
 ID INVOICE_ID      
  … Navigation Bar 3 Navigation bar   37,434 430,26              
  … Push Button 1 Button 1. Add Item to Invoice 38,286 186,25         Refresh form    
  … SubForm_Grid Gridcontrol   37,311 682,124              
  … … Discount_Currency Formatted - $       DISC_CURRENCY         [$$-409]0.00;[RED]-[$$-409]0.00
  … … Discount_Percentage Formatted - %       DISC_PERCENT         0%;[RED]-0%
  … … EXTENDED Currency FINAL       EXTENDED          
  … … ITEM Text ITEM       ITEM          
  … … ITEM_SKU Text SKU #       SKU          
  … … PRICE Currency PRICE       PRICE          
  … … QTY Numeric QTY       QTY          
  SubForm_SubTotal Subform       MainForm qSubForm_SubTotal (Query) ID INVOICE_ID      
  … lblSubTotal Fixed SubTotal 466,436 144,25              
  … Push Button 3 Button 3. Get Total 414,286 186,25         Refresh form    
  … Push Button 4 Button ✓ 719,537 26,26         Refresh form    
  … SubForm_Discount Subform         qSubForm_Adv_Discount (Query) INVOICE_ID INVOICE_ID      
  … … Discount Formatted   610,460 108,26   INVOICE_DISCOUNT         [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
  … SubForm_Shipping Subform         qSubForm_Adv_Shipping (Query) INVOICE_ID INVOICE_ID      
  … … Shipping Formatted   610,511 108,26   SHIPPING       ✔ [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
  … SubForm_Tax Subform         qSubForm_Adv_Tax (Query) INVOICE_ID INVOICE_ID      
  … … Tax Formatted   610,485 108,26   TAXES         [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
  … SubForm_Total Subform         qSubForm_Adv_Total (Query) INVOICE_ID INVOICE_ID      
  … … lblTotal Fixed TOTAL 466,536 144,26              
  … … Total Formatted   610,536 108,26   TOTAL         [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
  … SubTotal Formatted   610,434 108,26   SUBTOTAL       ✔ [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00