Table of contents
Invoice Forms

• Tables
  • CUSTOMERS
  • DISCOUNT
  • INVOICE
  • ITEMS
  • SHIP_TO
  • SHIPPERS
  • SOLD
  • TAX
• Queries
  • Items Sold
  • Items UnSold
  • qSubForm_Adv_Discount
  • qSubForm_Adv_Shipping
  • qSubForm_Adv_Tax
  • qSubForm_Adv_Total
  • qSubForm_SubTotal
  • qSubForm_Tax
  • qSubForm_Total
• Forms
  • 1. Invoice Unique Items
  • 2. Invoice Basic
  • 3. Invoice Intermediate
  • 4. Invoice Advanced
• Index

List of fields by table

Table name	Field name	Field type	Precision	Primary key	Index #01	% not Null	Average	Most positive	Oldest date	Newest date	Longest string	Default value
CUSTOMERS	CITY	VARCHAR				100					20
	FIRSTNAME	VARCHAR				100					10
	ID	INTEGER		✔		100		200
	LASTNAME	VARCHAR				100					11
	PHONE	VARCHAR				100					12
	STATE	VARCHAR				100					20
	STREET	VARCHAR				100					37
	ZIP	VARCHAR				100					5
DISCOUNT	ID	INTEGER		✔		100		10
	UNITS	DECIMAL	2			91	32,5	70
INVOICE	CUSTOMER_ID	INTEGER				100		39
	DATE	DATE				100			28/08/2012	08/10/2013		CURRENT_DATE
	DISCOUNT_ID	INTEGER				100		2
	ID	INTEGER		✔		100		2
	SHIPPER_ID	INTEGER				100		3
	TAX_ID	INTEGER				100		2
ITEMS	ITEM	VARCHAR				100					9
	ITEM_ID	INTEGER		✔		100		10
	PACKAGING_FEE	DECIMAL	2			100	1,16	4
	PRICE	DECIMAL	4			100	32,3345	99,99
	SHIPPING_WT	DECIMAL	2			100	1,71	6,6
	SKU	VARCHAR				100					9
	TAXABLE	BOOLEAN				100
SHIP_TO	CITY	VARCHAR				50					8
	ID	INTEGER		✔		100		1
	INVOICE_ID	INTEGER			ASC	100		2
	NAME	VARCHAR				50					9
	PHONE	VARCHAR				50					14
	STATE	VARCHAR				50					2
	STREET	VARCHAR				50					16
	ZIP	VARCHAR				50					5
SHIPPERS	BASE_FEE	DECIMAL	2			100	0,25	1
	ID	INTEGER		✔		100		3
	NAME	VARCHAR				100					16
	WEIGHT_RATE	DECIMAL	2			100	0,42	0,85
SOLD	DISC_CURRENCY	DECIMAL	4
	DISC_PERCENT	DECIMAL	4
	ID	INTEGER		✔
	INVOICE_ID	INTEGER
	ITEM_ID	INTEGER
	QTY	INTEGER										1
TAX	ID	INTEGER		✔		100		2
	RATE	DECIMAL	4			67	0,1025	0,12
	TYPE	VARCHAR				100					11